| 1 |
1 |
geoscrub,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
|
| 2 |
|
geoscrubID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
|
| 3 |
2 |
isInCountry,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/cond/_exists",
|
| 4 |
|
geoscrubID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/else",
|
| 5 |
|
geoscrubID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
|
| 6 |
|
geoscrubID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/then",
|
| 7 |
|
geoscrubID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
|
| 8 |
3 |
latitudeDecimalVerbatim,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
|
| 9 |
4 |
longitudeDecimalVerbatim,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
|
| 10 |
5 |
countryVerbatim,/location/locationplace/*_id/place/country,
|
| ... | ... | |
| 23 |
18 |
isInStateProvince,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/georeference_valid/_first/2/_and/2,
|
| 24 |
19 |
stateProvinceVerbatim,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2,
|
| 25 |
20 |
isInCountry,"/location/locationplace/*_id/place/placecode/_if[@name=""if geovalidation""]/cond/_exists",
|
| 26 |
|
geoscrubID,"/location/locationplace/*_id/place/placecode/_if[@name=""if geovalidation""]/then",
|
| 27 |
21 |
stateProvinceVerbatim,/location/locationplace/*_id/place/stateprovince,
|
| 28 |
|
geoscrubID,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/1",
|
| 29 |
22 |
Index_isCultivatedReason_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
|
| 30 |
23 |
Index_isCultivated_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
|
| 31 |
24 |
badLatLongReason,,** No join mapping for *badLatLongReason **
|
| ... | ... | |
| 38 |
31 |
elevMaxVerbatim,,** No non-empty join mapping for OMIT ** Not geoscrub-related
|
| 39 |
32 |
elevMinVerbatim,,** No non-empty join mapping for OMIT ** Not geoscrub-related
|
| 40 |
33 |
elevationVerbatim,,** No non-empty join mapping for OMIT ** Not geoscrub-related
|
|
34 |
geoscrubID,,"** No non-empty join mapping for OMIT ** Using this would allow multiple occurrences of the same placename/coordinates combination, which would cause problems when datasources try to link up to the geoscrub places"
|
| 41 |
35 |
geoscrubID_idx_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
|
| 42 |
36 |
isBadLatLong,,** No join mapping for latLongDomainInvalid **
|
| 43 |
37 |
isCultivated,,** No non-empty join mapping for OMIT ** Not geoscrub-related
|
inputs/.geoscrub/geoscrub_cleaned_unique/map.csv: Removed geoscrubID->locationID mapping because it allowed multiple occurrences of the same placename/coordinates combination, which was causing problems when datasources try to link up to the geoscrub places (and end up matching multiple output rows for each input row)