Revision 6122
Added by Aaron Marcuse-Kubitza about 12 years ago
| mappings/for_review/VegCore-VegBIEN.csv | ||
|---|---|---|
| 324 | 324 |
continent,//place/continent, |
| 325 | 325 |
country,//place/country, |
| 326 | 326 |
county,//place/county, |
| 327 |
acceptedDecimalLatitude,//*_id/coordinates/latitude_deg, |
|
| 328 |
acceptedDecimalLongitude,//*_id/coordinates/longitude_deg, |
|
| 327 |
acceptedDecimalLatitude,//*_id/coordinates/latitude_deg,""".,"" sorts it with other coordinates mappings" |
|
| 328 |
acceptedDecimalLongitude,//*_id/coordinates/longitude_deg,""".,"" sorts it with other coordinates mappings" |
|
| 329 |
decimalLatitude,//*_id/coordinates/latitude_deg,""".,"" sorts it with other coordinates mappings" |
|
| 330 |
decimalLongitude,//*_id/coordinates/longitude_deg,""".,"" sorts it with other coordinates mappings" |
|
| 329 | 331 |
acceptedCountry,//place/country, |
| 330 | 332 |
acceptedStateProvince,//place/stateprovince, |
| 331 |
decimalLatitude,//*_id/coordinates/latitude_deg, |
|
| 332 |
decimalLongitude,//*_id/coordinates/longitude_deg, |
|
| 333 | 333 |
country,//place/country, |
| 334 | 334 |
distanceToCountry_km,//place/distance_to_country_m/_km_to_m/value, |
| 335 | 335 |
distanceToStateProvince_km,//place/distance_to_state_m/_km_to_m/value, |
| inputs/XAL/Specimen/VegBIEN.csv | ||
|---|---|---|
| 62 | 62 |
darwin:ContinentOcean,/location/locationplace/*_id/place/continent, |
| 63 | 63 |
darwin:Country,/location/locationplace/*_id/place/country, |
| 64 | 64 |
darwin:County,/location/locationplace/*_id/place/county, |
| 65 |
darwin:Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 66 |
darwin:Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 65 |
darwin:Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 66 |
darwin:Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 67 | 67 |
darwin:Country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2, |
| 68 | 68 |
darwin:StateProvince,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2, |
| 69 | 69 |
darwin:StateProvince,/location/locationplace/*_id/place/stateprovince, |
| inputs/TEAM/VL/VegBIEN.csv | ||
|---|---|---|
| 40 | 40 |
Names of Collectors,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 41 | 41 |
Latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value", |
| 42 | 42 |
Longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
| 43 |
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 44 |
Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 43 |
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 44 |
Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 45 | 45 |
Subplot Number,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/cond/_exists", |
| 46 | 46 |
1ha Plot Number,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/2", |
| 47 | 47 |
Subplot Number,/location/sourceaccessioncode/_join/2, |
| inputs/TEAM/VT/VegBIEN.csv | ||
|---|---|---|
| 40 | 40 |
Names of Collectors,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 41 | 41 |
Latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value", |
| 42 | 42 |
Longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
| 43 |
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 44 |
Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 43 |
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 44 |
Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 45 | 45 |
Subplot Number,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/cond/_exists", |
| 46 | 46 |
1ha Plot Number,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/2", |
| 47 | 47 |
Subplot Number,/location/sourceaccessioncode/_join/2, |
| inputs/TEAM/TEAM_Sites/VegBIEN.csv | ||
|---|---|---|
| 11 | 11 |
Name,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 12 | 12 |
Latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value", |
| 13 | 13 |
Longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
| 14 |
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 15 |
Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 14 |
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 15 |
Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 16 | 16 |
Name,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/2", |
| 17 | 17 |
1ha Plot Coordinate,,** No join mapping for *1ha Plot Coordinate ** |
| inputs/.geoscrub/geoscrub_cleaned_unique/VegBIEN.csv | ||
|---|---|---|
| 3 | 3 |
latitudeDecimalVerbatim,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value", |
| 4 | 4 |
longitudeDecimalVerbatim,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
| 5 | 5 |
countryVerbatim,/location/locationplace/*_id/place/country, |
| 6 |
latitudeDecimalVerbatim,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings" |
|
| 7 |
longitudeDecimalVerbatim,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings" |
|
| 6 | 8 |
countryStd,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub,matched_place_id=0]/country/_first/1", |
| 7 | 9 |
stateProvinceStd,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub,matched_place_id=0]/stateprovince/_first/1", |
| 8 |
latitudeDecimalVerbatim,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 9 |
longitudeDecimalVerbatim,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 10 | 10 |
countryVerbatim,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2, |
| 11 | 11 |
distErrCountry,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/distance_to_country_m/_km_to_m/value,"Assuming units based on the range of values and the circumference of the Earth [1]. |
| 12 | 12 |
|
| inputs/.geoscrub/geoscrub_cleaned_unique/test.xml.ref | ||
|---|---|---|
| 29 | 29 |
<matched_place_id> |
| 30 | 30 |
<place> |
| 31 | 31 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 32 |
<matched_place_id>0</matched_place_id> |
|
| 33 |
<country>$countryStd</country> |
|
| 34 |
<stateprovince>$stateProvinceStd</stateprovince> |
|
| 35 | 32 |
<coordinates_id> |
| 36 | 33 |
<coordinates> |
| 37 | 34 |
<latitude_deg> |
| ... | ... | |
| 50 | 47 |
</longitude_deg> |
| 51 | 48 |
</coordinates> |
| 52 | 49 |
</coordinates_id> |
| 50 |
<matched_place_id>0</matched_place_id> |
|
| 51 |
<country>$countryStd</country> |
|
| 52 |
<stateprovince>$stateProvinceStd</stateprovince> |
|
| 53 | 53 |
<distance_to_country_m><_km_to_m><value>$distErrCountry</value></_km_to_m></distance_to_country_m> |
| 54 | 54 |
<distance_to_state_m><_km_to_m><value>$distErrStateProvince</value></_km_to_m></distance_to_state_m> |
| 55 | 55 |
<georeference_valid> |
| inputs/ACAD/Specimen/VegBIEN.csv | ||
|---|---|---|
| 68 | 68 |
continent,/location/locationplace/*_id/place/continent, |
| 69 | 69 |
country,/location/locationplace/*_id/place/country, |
| 70 | 70 |
county,/location/locationplace/*_id/place/county, |
| 71 |
decimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 72 |
decimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 71 |
decimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 72 |
decimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 73 | 73 |
country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2, |
| 74 | 74 |
stateProvince,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2, |
| 75 | 75 |
stateProvince,/location/locationplace/*_id/place/stateprovince, |
| inputs/CTFS/Plot/VegBIEN.csv | ||
|---|---|---|
| 24 | 24 |
Latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value", |
| 25 | 25 |
Longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
| 26 | 26 |
CountryName,/location/locationplace/*_id/place/country, |
| 27 |
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 28 |
Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 27 |
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 28 |
Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 29 | 29 |
CountryName,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2, |
| 30 | 30 |
PlotID,"/location/locationplace/*_id/place/placecode/_if[@name=""if geovalidation""]/then", |
| 31 | 31 |
PlotID,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/1", |
| inputs/SALVIAS/plotMetadata_/VegBIEN.csv | ||
|---|---|---|
| 48 | 48 |
MajorGeo,/location/locationplace/*_id/place/continent, |
| 49 | 49 |
Country,/location/locationplace/*_id/place/country, |
| 50 | 50 |
pol2,/location/locationplace/*_id/place/county,Brad: No pol2=countyParish |
| 51 |
LatDec,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 52 |
LongDec,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 51 |
LatDec,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 52 |
LongDec,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 53 | 53 |
Country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2, |
| 54 | 54 |
PolDiv1,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2,Brad: No; pol1=stateProvince |
| 55 | 55 |
PlotID,"/location/locationplace/*_id/place/placecode/_if[@name=""if geovalidation""]/then","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata." |
| inputs/U/Specimen/VegBIEN.csv | ||
|---|---|---|
| 35 | 35 |
Lat,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value", |
| 36 | 36 |
Long,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
| 37 | 37 |
Country,/location/locationplace/*_id/place/country, |
| 38 |
Lat,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 39 |
Long,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 38 |
Lat,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 39 |
Long,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 40 | 40 |
Country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2, |
| 41 | 41 |
Alt,,** No join mapping for *Alt ** What is this? |
| 42 | 42 |
Alt2,,** No join mapping for *Alt2 ** What is this? |
| inputs/GBIF/Specimen/VegBIEN.csv | ||
|---|---|---|
| 55 | 55 |
VerbatimLongitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
| 56 | 56 |
Country,/location/locationplace/*_id/place/country, |
| 57 | 57 |
County,/location/locationplace/*_id/place/county, |
| 58 |
VerbatimLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 59 |
VerbatimLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 58 |
VerbatimLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 59 |
VerbatimLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 60 | 60 |
Country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2, |
| 61 | 61 |
StateProvince,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2, |
| 62 | 62 |
StateProvince,/location/locationplace/*_id/place/stateprovince, |
| inputs/SpeciesLink/Specimen/VegBIEN.csv | ||
|---|---|---|
| 214 | 214 |
conceptual_darwin_2003_1_0_County,/location/locationplace/*_id/place/county, |
| 215 | 215 |
dwc_dwcore_County,/location/locationplace/*_id/place/county, |
| 216 | 216 |
dwc_terms_county,/location/locationplace/*_id/place/county, |
| 217 |
conceptual_darwin_2003_1_0_Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 218 |
dwc_geospatial_DecimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 219 |
dwc_terms_decimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 220 |
conceptual_darwin_2003_1_0_Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 221 |
dwc_geospatial_DecimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 222 |
dwc_terms_decimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 217 |
conceptual_darwin_2003_1_0_Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 218 |
dwc_geospatial_DecimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 219 |
dwc_terms_decimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 220 |
conceptual_darwin_2003_1_0_Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 221 |
dwc_geospatial_DecimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 222 |
dwc_terms_decimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 223 | 223 |
conceptual_darwin_2003_1_0_Country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2, |
| 224 | 224 |
dwc_dwcore_Country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2, |
| 225 | 225 |
dwc_terms_country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2, |
| inputs/bien_web/observation/VegBIEN.csv | ||
|---|---|---|
| 45 | 45 |
longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
| 46 | 46 |
country,/location/locationplace/*_id/place/country, |
| 47 | 47 |
countyParish,/location/locationplace/*_id/place/county, |
| 48 |
latitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 49 |
longitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 48 |
latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 49 |
longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 50 | 50 |
country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2, |
| 51 | 51 |
stateProvince,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2, |
| 52 | 52 |
plotID,"/location/locationplace/*_id/place/placecode/_if[@name=""if geovalidation""]/then", |
| inputs/NY/Specimen/VegBIEN.csv | ||
|---|---|---|
| 70 | 70 |
ContinentOcean,/location/locationplace/*_id/place/continent, |
| 71 | 71 |
Country,/location/locationplace/*_id/place/country, |
| 72 | 72 |
County,/location/locationplace/*_id/place/county, |
| 73 |
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 74 |
Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 73 |
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 74 |
Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 75 | 75 |
Country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2, |
| 76 | 76 |
StateProvince,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2, |
| 77 | 77 |
StateProvince,/location/locationplace/*_id/place/stateprovince, |
| inputs/Madidi/Plot/VegBIEN.csv | ||
|---|---|---|
| 91 | 91 |
Longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
| 92 | 92 |
Latitude (DMS),/location/locationplace/*_id/place/*_id/coordinates/verbatimlatitude, |
| 93 | 93 |
Longitude (DMS),/location/locationplace/*_id/place/*_id/coordinates/verbatimlongitude, |
| 94 |
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 95 |
Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 94 |
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 95 |
Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 96 | 96 |
Inventory code,"/location/locationplace/*_id/place/placecode/_if[@name=""if geovalidation""]/then", |
| 97 | 97 |
Observaciones,/location/notespublic, |
| 98 | 98 |
Direction,/location/slopeaspect_deg/_alt/1/_compass/value/_alt/1,Part files provide either this field or Orientación |
| inputs/CVS/Organism/VegBIEN.csv | ||
|---|---|---|
| 16 | 16 |
publicLatitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value", |
| 17 | 17 |
publicLongitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
| 18 | 18 |
county,/location/locationplace/*_id/place/county, |
| 19 |
publicLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 20 |
publicLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 19 |
publicLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 20 |
publicLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 21 | 21 |
state,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2, |
| 22 | 22 |
state,/location/locationplace/*_id/place/stateprovince, |
| 23 | 23 |
confidentialityStatus,,** No join mapping for *confidentialityStatus ** |
| inputs/SALVIAS-CSV/Plot/VegBIEN.csv | ||
|---|---|---|
| 47 | 47 |
major_geo,/location/locationplace/*_id/place/continent, |
| 48 | 48 |
country,/location/locationplace/*_id/place/country, |
| 49 | 49 |
pol2,/location/locationplace/*_id/place/county,Brad: No pol2=countyParish |
| 50 |
lat_decimal,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 51 |
long_decimal,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 50 |
lat_decimal,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 51 |
long_decimal,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 52 | 52 |
country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2, |
| 53 | 53 |
pol1,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2,Brad: No; pol1=stateProvince |
| 54 | 54 |
PLOT_ID,"/location/locationplace/*_id/place/placecode/_if[@name=""if geovalidation""]/then","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata." |
| inputs/REMIB/Specimen/VegBIEN.csv | ||
|---|---|---|
| 61 | 61 |
long_deg,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
| 62 | 62 |
country,/location/locationplace/*_id/place/country, |
| 63 | 63 |
county,/location/locationplace/*_id/place/county, |
| 64 |
lat_deg,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 65 |
long_deg,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 64 |
lat_deg,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 65 |
long_deg,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 66 | 66 |
country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2, |
| 67 | 67 |
state,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2, |
| 68 | 68 |
state,/location/locationplace/*_id/place/stateprovince, |
| inputs/FIA/Organism/VegBIEN.csv | ||
|---|---|---|
| 26 | 26 |
DecimalLatitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value", |
| 27 | 27 |
DecimalLongitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
| 28 | 28 |
County,/location/locationplace/*_id/place/county, |
| 29 |
DecimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 30 |
DecimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 29 |
DecimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 30 |
DecimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 31 | 31 |
StateProvince,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2, |
| 32 | 32 |
PlotCD,"/location/locationplace/*_id/place/placecode/_if[@name=""if geovalidation""]/then", |
| 33 | 33 |
StateProvince,/location/locationplace/*_id/place/stateprovince, |
| inputs/ARIZ/Specimen/VegBIEN.csv | ||
|---|---|---|
| 74 | 74 |
ContinentOcean,/location/locationplace/*_id/place/continent, |
| 75 | 75 |
Country,/location/locationplace/*_id/place/country, |
| 76 | 76 |
County,/location/locationplace/*_id/place/county, |
| 77 |
DecimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 78 |
DecimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 77 |
DecimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 78 |
DecimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 79 | 79 |
Country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2, |
| 80 | 80 |
StateProvince,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2, |
| 81 | 81 |
StateProvince,/location/locationplace/*_id/place/stateprovince, |
| inputs/NCU-NCSC/Specimen/VegBIEN.csv | ||
|---|---|---|
| 20 | 20 |
Long (-=W),"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value", |
| 21 | 21 |
Country,/location/locationplace/*_id/place/country, |
| 22 | 22 |
County,/location/locationplace/*_id/place/county, |
| 23 |
Lat (-=S),"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",
|
|
| 24 |
Long (-=W),"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",
|
|
| 23 |
Lat (-=S),"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 24 |
Long (-=W),"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 25 | 25 |
Country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2, |
| 26 | 26 |
State,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2, |
| 27 | 27 |
State,/location/locationplace/*_id/place/stateprovince, |
| inputs/MO/Specimen/VegBIEN.csv | ||
|---|---|---|
| 50 | 50 |
ContinentOcean,/location/locationplace/*_id/place/continent, |
| 51 | 51 |
Country,/location/locationplace/*_id/place/country, |
| 52 | 52 |
County,/location/locationplace/*_id/place/county, |
| 53 |
latitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 54 |
longitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 53 |
latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 54 |
longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 55 | 55 |
Country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2, |
| 56 | 56 |
StateProvince,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2, |
| 57 | 57 |
StateProvince,/location/locationplace/*_id/place/stateprovince, |
| inputs/VegBank/plot_/VegBIEN.csv | ||
|---|---|---|
| 20 | 20 |
area|country|territory,/location/locationplace/*_id/place/country, |
| 21 | 21 |
country,/location/locationplace/*_id/place/country, |
| 22 | 22 |
county,/location/locationplace/*_id/place/county, |
| 23 |
latitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 24 |
longitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 23 |
latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 24 |
longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 25 | 25 |
area|country|territory,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2, |
| 26 | 26 |
country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2, |
| 27 | 27 |
region|state|province,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2, |
| inputs/QMOR/Specimen/VegBIEN.csv | ||
|---|---|---|
| 76 | 76 |
continent,/location/locationplace/*_id/place/continent, |
| 77 | 77 |
country,/location/locationplace/*_id/place/country, |
| 78 | 78 |
county,/location/locationplace/*_id/place/county, |
| 79 |
decimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 80 |
decimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",
|
|
| 79 |
decimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 80 |
decimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 81 | 81 |
country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2, |
| 82 | 82 |
stateProvince,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2, |
| 83 | 83 |
stateProvince,/location/locationplace/*_id/place/stateprovince, |
| mappings/VegCore-VegBIEN.csv | ||
|---|---|---|
| 324 | 324 |
continent,/location/locationplace/*_id/place/continent, |
| 325 | 325 |
country,/location/locationplace/*_id/place/country, |
| 326 | 326 |
county,/location/locationplace/*_id/place/county, |
| 327 |
acceptedDecimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub,matched_place_id=0]/*_id/coordinates/_first/1/latitude_deg", |
|
| 328 |
acceptedDecimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub,matched_place_id=0]/*_id/coordinates/_first/1/longitude_deg", |
|
| 327 |
acceptedDecimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub,matched_place_id=0]/*_id/coordinates/_first/1/latitude_deg",""".,"" sorts it with other coordinates mappings" |
|
| 328 |
acceptedDecimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub,matched_place_id=0]/*_id/coordinates/_first/1/longitude_deg",""".,"" sorts it with other coordinates mappings" |
|
| 329 |
decimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings" |
|
| 330 |
decimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings" |
|
| 329 | 331 |
acceptedCountry,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub,matched_place_id=0]/country/_first/1", |
| 330 | 332 |
acceptedStateProvince,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub,matched_place_id=0]/stateprovince/_first/1", |
| 331 |
decimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 332 |
decimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value", |
|
| 333 | 333 |
country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2, |
| 334 | 334 |
distanceToCountry_km,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/distance_to_country_m/_km_to_m/value, |
| 335 | 335 |
distanceToStateProvince_km,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/distance_to_state_m/_km_to_m/value, |
Also available in: Unified diff
mappings/VegCore-VegBIEN.csv: matched place's coordinates: Fixed bug where coordinates mappings with and without matched_place_id=0 need to sort together in order to be merged, by prepending ".," to the place attrs list