Revision 5969
Added by Aaron Marcuse-Kubitza about 12 years ago
| inputs/Madidi/Plot/VegBIEN.csv | ||
|---|---|---|
| 88 | 88 |
Longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
| 89 | 89 |
Latitude (DMS),/location/locationplace/*_id/place/*_id/coordinates/verbatimlatitude, |
| 90 | 90 |
Longitude (DMS),/location/locationplace/*_id/place/*_id/coordinates/verbatimlongitude, |
| 91 |
Latitude,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg,
|
|
| 92 |
Longitude,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg,
|
|
| 91 |
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",
|
|
| 92 |
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",
|
|
| 93 | 93 |
Inventory code,"/location/locationplace/*_id/place/placecode/_if[@name=""if geovalidation""]/then", |
| 94 | 94 |
Observaciones,/location/notespublic, |
| 95 | 95 |
Direction,/location/slopeaspect_deg/_alt/1/_compass/value/_alt/1,Part files provide either this field or Orientación |
| inputs/CVS/Organism/VegBIEN.csv | ||
|---|---|---|
| 14 | 14 |
publicLatitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value", |
| 15 | 15 |
publicLongitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
| 16 | 16 |
county,/location/locationplace/*_id/place/county, |
| 17 |
publicLatitude,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg,
|
|
| 18 |
publicLongitude,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg,
|
|
| 17 |
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",
|
|
| 18 |
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 | 19 |
state,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2, |
| 20 | 20 |
state,/location/locationplace/*_id/place/stateprovince, |
| 21 | 21 |
confidentialityStatus,,** No join mapping for *confidentialityStatus ** |
| inputs/SALVIAS-CSV/Plot/VegBIEN.csv | ||
|---|---|---|
| 43 | 43 |
major_geo,/location/locationplace/*_id/place/continent, |
| 44 | 44 |
country,/location/locationplace/*_id/place/country, |
| 45 | 45 |
pol2,/location/locationplace/*_id/place/county,Brad: No pol2=countyParish |
| 46 |
lat_decimal,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg,
|
|
| 47 |
long_decimal,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg,
|
|
| 46 |
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",
|
|
| 47 |
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",
|
|
| 48 | 48 |
country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2, |
| 49 | 49 |
pol1,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2,Brad: No; pol1=stateProvince |
| 50 | 50 |
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,
|
|
| 65 |
long_deg,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg,
|
|
| 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",
|
|
| 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,
|
|
| 30 |
DecimalLongitude,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg,
|
|
| 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",
|
|
| 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/test.xml.ref | ||
|---|---|---|
| 312 | 312 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 313 | 313 |
<coordinates_id> |
| 314 | 314 |
<coordinates> |
| 315 |
<latitude_deg>$DecimalLatitude</latitude_deg> |
|
| 316 |
<longitude_deg>$DecimalLongitude</longitude_deg> |
|
| 315 |
<latitude_deg> |
|
| 316 |
<_nullIf> |
|
| 317 |
<null>0</null> |
|
| 318 |
<type>float</type> |
|
| 319 |
<value>$DecimalLatitude</value> |
|
| 320 |
</_nullIf> |
|
| 321 |
</latitude_deg> |
|
| 322 |
<longitude_deg> |
|
| 323 |
<_nullIf> |
|
| 324 |
<null>0</null> |
|
| 325 |
<type>float</type> |
|
| 326 |
<value>$DecimalLongitude</value> |
|
| 327 |
</_nullIf> |
|
| 328 |
</longitude_deg> |
|
| 317 | 329 |
</coordinates> |
| 318 | 330 |
</coordinates_id> |
| 319 | 331 |
<country>$Country</country> |
| 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,
|
|
| 54 |
longitude,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg,
|
|
| 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",
|
|
| 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/FIA/Organism/test.xml.ref | ||
|---|---|---|
| 137 | 137 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 138 | 138 |
<coordinates_id> |
| 139 | 139 |
<coordinates> |
| 140 |
<latitude_deg>$DecimalLatitude</latitude_deg> |
|
| 141 |
<longitude_deg>$DecimalLongitude</longitude_deg> |
|
| 140 |
<latitude_deg> |
|
| 141 |
<_nullIf> |
|
| 142 |
<null>0</null> |
|
| 143 |
<type>float</type> |
|
| 144 |
<value>$DecimalLatitude</value> |
|
| 145 |
</_nullIf> |
|
| 146 |
</latitude_deg> |
|
| 147 |
<longitude_deg> |
|
| 148 |
<_nullIf> |
|
| 149 |
<null>0</null> |
|
| 150 |
<type>float</type> |
|
| 151 |
<value>$DecimalLongitude</value> |
|
| 152 |
</_nullIf> |
|
| 153 |
</longitude_deg> |
|
| 142 | 154 |
</coordinates> |
| 143 | 155 |
</coordinates_id> |
| 144 | 156 |
<stateprovince>$StateProvince</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/_replace:[""\?$""=]/value", |
|
| 24 |
Long (-=W),"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_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",
|
|
| 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",
|
|
| 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/test.xml.ref | ||
|---|---|---|
| 223 | 223 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 224 | 224 |
<coordinates_id> |
| 225 | 225 |
<coordinates> |
| 226 |
<latitude_deg>$latitude</latitude_deg> |
|
| 227 |
<longitude_deg>$longitude</longitude_deg> |
|
| 226 |
<latitude_deg> |
|
| 227 |
<_nullIf> |
|
| 228 |
<null>0</null> |
|
| 229 |
<type>float</type> |
|
| 230 |
<value>$latitude</value> |
|
| 231 |
</_nullIf> |
|
| 232 |
</latitude_deg> |
|
| 233 |
<longitude_deg> |
|
| 234 |
<_nullIf> |
|
| 235 |
<null>0</null> |
|
| 236 |
<type>float</type> |
|
| 237 |
<value>$longitude</value> |
|
| 238 |
</_nullIf> |
|
| 239 |
</longitude_deg> |
|
| 228 | 240 |
</coordinates> |
| 229 | 241 |
</coordinates_id> |
| 230 | 242 |
<country>$Country</country> |
| 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,
|
|
| 66 |
darwin:Longitude,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg,
|
|
| 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",
|
|
| 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 | ||
|---|---|---|
| 35 | 35 |
Names of Collectors,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 36 | 36 |
Latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value", |
| 37 | 37 |
Longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
| 38 |
Latitude,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg,
|
|
| 39 |
Longitude,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg,
|
|
| 38 |
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",
|
|
| 39 |
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",
|
|
| 40 | 40 |
Subplot Number,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/cond/_exists", |
| 41 | 41 |
1ha Plot Number,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/2", |
| 42 | 42 |
Subplot Number,/location/sourceaccessioncode/_join/2, |
| inputs/TEAM/VL/test.xml.ref | ||
|---|---|---|
| 136 | 136 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 137 | 137 |
<coordinates_id> |
| 138 | 138 |
<coordinates> |
| 139 |
<latitude_deg>$Latitude</latitude_deg> |
|
| 140 |
<longitude_deg>$Longitude</longitude_deg> |
|
| 139 |
<latitude_deg> |
|
| 140 |
<_nullIf> |
|
| 141 |
<null>0</null> |
|
| 142 |
<type>float</type> |
|
| 143 |
<value>$Latitude</value> |
|
| 144 |
</_nullIf> |
|
| 145 |
</latitude_deg> |
|
| 146 |
<longitude_deg> |
|
| 147 |
<_nullIf> |
|
| 148 |
<null>0</null> |
|
| 149 |
<type>float</type> |
|
| 150 |
<value>$Longitude</value> |
|
| 151 |
</_nullIf> |
|
| 152 |
</longitude_deg> |
|
| 141 | 153 |
</coordinates> |
| 142 | 154 |
</coordinates_id> |
| 143 | 155 |
</place> |
| inputs/TEAM/VT/VegBIEN.csv | ||
|---|---|---|
| 35 | 35 |
Names of Collectors,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 36 | 36 |
Latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value", |
| 37 | 37 |
Longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
| 38 |
Latitude,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg,
|
|
| 39 |
Longitude,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg,
|
|
| 38 |
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",
|
|
| 39 |
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",
|
|
| 40 | 40 |
Subplot Number,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/cond/_exists", |
| 41 | 41 |
1ha Plot Number,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/2", |
| 42 | 42 |
Subplot Number,/location/sourceaccessioncode/_join/2, |
| inputs/TEAM/VT/test.xml.ref | ||
|---|---|---|
| 136 | 136 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 137 | 137 |
<coordinates_id> |
| 138 | 138 |
<coordinates> |
| 139 |
<latitude_deg>$Latitude</latitude_deg> |
|
| 140 |
<longitude_deg>$Longitude</longitude_deg> |
|
| 139 |
<latitude_deg> |
|
| 140 |
<_nullIf> |
|
| 141 |
<null>0</null> |
|
| 142 |
<type>float</type> |
|
| 143 |
<value>$Latitude</value> |
|
| 144 |
</_nullIf> |
|
| 145 |
</latitude_deg> |
|
| 146 |
<longitude_deg> |
|
| 147 |
<_nullIf> |
|
| 148 |
<null>0</null> |
|
| 149 |
<type>float</type> |
|
| 150 |
<value>$Longitude</value> |
|
| 151 |
</_nullIf> |
|
| 152 |
</longitude_deg> |
|
| 141 | 153 |
</coordinates> |
| 142 | 154 |
</coordinates_id> |
| 143 | 155 |
</place> |
| inputs/TEAM/TEAM_Sites/VegBIEN.csv | ||
|---|---|---|
| 8 | 8 |
Name,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 9 | 9 |
Latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value", |
| 10 | 10 |
Longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
| 11 |
Latitude,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg,
|
|
| 12 |
Longitude,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg,
|
|
| 11 |
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",
|
|
| 12 |
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",
|
|
| 13 | 13 |
Name,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/2", |
| 14 | 14 |
1ha Plot Coordinate,,** No join mapping for *1ha Plot Coordinate ** |
| inputs/TEAM/TEAM_Sites/test.xml.ref | ||
|---|---|---|
| 36 | 36 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 37 | 37 |
<coordinates_id> |
| 38 | 38 |
<coordinates> |
| 39 |
<latitude_deg>$Latitude</latitude_deg> |
|
| 40 |
<longitude_deg>$Longitude</longitude_deg> |
|
| 39 |
<latitude_deg> |
|
| 40 |
<_nullIf> |
|
| 41 |
<null>0</null> |
|
| 42 |
<type>float</type> |
|
| 43 |
<value>$Latitude</value> |
|
| 44 |
</_nullIf> |
|
| 45 |
</latitude_deg> |
|
| 46 |
<longitude_deg> |
|
| 47 |
<_nullIf> |
|
| 48 |
<null>0</null> |
|
| 49 |
<type>float</type> |
|
| 50 |
<value>$Longitude</value> |
|
| 51 |
</_nullIf> |
|
| 52 |
</longitude_deg> |
|
| 41 | 53 |
</coordinates> |
| 42 | 54 |
</coordinates_id> |
| 43 | 55 |
</place> |
| ... | ... | |
| 49 | 61 |
</path> |
| 50 | 62 |
</_simplifyPath> |
| 51 | 63 |
</VegBIEN> |
| 52 |
Inserted 17 new rows into database |
|
| 64 |
Inserted 15 new rows into database |
|
| inputs/.geoscrub/geoscrub_cleaned_unique/VegBIEN.csv | ||
|---|---|---|
| 8 | 8 |
latitudeDecimalVerbatim,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value", |
| 9 | 9 |
longitudeDecimalVerbatim,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
| 10 | 10 |
countryVerbatim,/location/locationplace/*_id/place/country, |
| 11 |
latitudeDecimalVerbatim,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg,
|
|
| 12 |
longitudeDecimalVerbatim,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg,
|
|
| 11 |
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",
|
|
| 12 |
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",
|
|
| 13 | 13 |
countryStd,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/1, |
| 14 | 14 |
countryVerbatim,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2, |
| 15 | 15 |
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]. |
| inputs/.geoscrub/geoscrub_cleaned_unique/test.xml.ref | ||
|---|---|---|
| 31 | 31 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 32 | 32 |
<coordinates_id> |
| 33 | 33 |
<coordinates> |
| 34 |
<latitude_deg>$latitudeDecimalVerbatim</latitude_deg> |
|
| 35 |
<longitude_deg>$longitudeDecimalVerbatim</longitude_deg> |
|
| 34 |
<latitude_deg> |
|
| 35 |
<_nullIf> |
|
| 36 |
<null>0</null> |
|
| 37 |
<type>float</type> |
|
| 38 |
<value>$latitudeDecimalVerbatim</value> |
|
| 39 |
</_nullIf> |
|
| 40 |
</latitude_deg> |
|
| 41 |
<longitude_deg> |
|
| 42 |
<_nullIf> |
|
| 43 |
<null>0</null> |
|
| 44 |
<type>float</type> |
|
| 45 |
<value>$longitudeDecimalVerbatim</value> |
|
| 46 |
</_nullIf> |
|
| 47 |
</longitude_deg> |
|
| 36 | 48 |
</coordinates> |
| 37 | 49 |
</coordinates_id> |
| 38 | 50 |
<country>$countryStd</country> |
| inputs/ACAD/Specimen/VegBIEN.csv | ||
|---|---|---|
| 66 | 66 |
continent,/location/locationplace/*_id/place/continent, |
| 67 | 67 |
country,/location/locationplace/*_id/place/country, |
| 68 | 68 |
county,/location/locationplace/*_id/place/county, |
| 69 |
decimalLatitude,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg,
|
|
| 70 |
decimalLongitude,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg,
|
|
| 69 |
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",
|
|
| 70 |
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 | 71 |
country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2, |
| 72 | 72 |
stateProvince,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2, |
| 73 | 73 |
stateProvince,/location/locationplace/*_id/place/stateprovince, |
| inputs/ACAD/Specimen/test.xml.ref | ||
|---|---|---|
| 250 | 250 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 251 | 251 |
<coordinates_id> |
| 252 | 252 |
<coordinates> |
| 253 |
<latitude_deg>$decimalLatitude</latitude_deg> |
|
| 254 |
<longitude_deg>$decimalLongitude</longitude_deg> |
|
| 253 |
<latitude_deg> |
|
| 254 |
<_nullIf> |
|
| 255 |
<null>0</null> |
|
| 256 |
<type>float</type> |
|
| 257 |
<value>$decimalLatitude</value> |
|
| 258 |
</_nullIf> |
|
| 259 |
</latitude_deg> |
|
| 260 |
<longitude_deg> |
|
| 261 |
<_nullIf> |
|
| 262 |
<null>0</null> |
|
| 263 |
<type>float</type> |
|
| 264 |
<value>$decimalLongitude</value> |
|
| 265 |
</_nullIf> |
|
| 266 |
</longitude_deg> |
|
| 255 | 267 |
</coordinates> |
| 256 | 268 |
</coordinates_id> |
| 257 | 269 |
<country>$country</country> |
| 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,
|
|
| 28 |
Longitude,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg,
|
|
| 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",
|
|
| 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/CTFS/Plot/test.xml.ref | ||
|---|---|---|
| 42 | 42 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 43 | 43 |
<coordinates_id> |
| 44 | 44 |
<coordinates> |
| 45 |
<latitude_deg>$Latitude</latitude_deg> |
|
| 46 |
<longitude_deg>$Longitude</longitude_deg> |
|
| 45 |
<latitude_deg> |
|
| 46 |
<_nullIf> |
|
| 47 |
<null>0</null> |
|
| 48 |
<type>float</type> |
|
| 49 |
<value>$Latitude</value> |
|
| 50 |
</_nullIf> |
|
| 51 |
</latitude_deg> |
|
| 52 |
<longitude_deg> |
|
| 53 |
<_nullIf> |
|
| 54 |
<null>0</null> |
|
| 55 |
<type>float</type> |
|
| 56 |
<value>$Longitude</value> |
|
| 57 |
</_nullIf> |
|
| 58 |
</longitude_deg> |
|
| 47 | 59 |
</coordinates> |
| 48 | 60 |
</coordinates_id> |
| 49 | 61 |
<country>$CountryName</country> |
| inputs/SALVIAS/plotMetadata/VegBIEN.csv | ||
|---|---|---|
| 44 | 44 |
MajorGeo,/location/locationplace/*_id/place/continent, |
| 45 | 45 |
Country,/location/locationplace/*_id/place/country, |
| 46 | 46 |
pol2,/location/locationplace/*_id/place/county,Brad: No pol2=countyParish |
| 47 |
LatDec,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg,
|
|
| 48 |
LongDec,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg,
|
|
| 47 |
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",
|
|
| 48 |
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",
|
|
| 49 | 49 |
Country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2, |
| 50 | 50 |
PolDiv1,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2,Brad: No; pol1=stateProvince |
| 51 | 51 |
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/SALVIAS/plotMetadata/test.xml.ref | ||
|---|---|---|
| 115 | 115 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 116 | 116 |
<coordinates_id> |
| 117 | 117 |
<coordinates> |
| 118 |
<latitude_deg>$LatDec</latitude_deg> |
|
| 119 |
<longitude_deg>$LongDec</longitude_deg> |
|
| 118 |
<latitude_deg> |
|
| 119 |
<_nullIf> |
|
| 120 |
<null>0</null> |
|
| 121 |
<type>float</type> |
|
| 122 |
<value>$LatDec</value> |
|
| 123 |
</_nullIf> |
|
| 124 |
</latitude_deg> |
|
| 125 |
<longitude_deg> |
|
| 126 |
<_nullIf> |
|
| 127 |
<null>0</null> |
|
| 128 |
<type>float</type> |
|
| 129 |
<value>$LongDec</value> |
|
| 130 |
</_nullIf> |
|
| 131 |
</longitude_deg> |
|
| 120 | 132 |
</coordinates> |
| 121 | 133 |
</coordinates_id> |
| 122 | 134 |
<country>$Country</country> |
| 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,
|
|
| 39 |
Long,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg,
|
|
| 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",
|
|
| 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/U/Specimen/test.xml.ref | ||
|---|---|---|
| 203 | 203 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 204 | 204 |
<coordinates_id> |
| 205 | 205 |
<coordinates> |
| 206 |
<latitude_deg>$Lat</latitude_deg> |
|
| 207 |
<longitude_deg>$Long</longitude_deg> |
|
| 206 |
<latitude_deg> |
|
| 207 |
<_nullIf> |
|
| 208 |
<null>0</null> |
|
| 209 |
<type>float</type> |
|
| 210 |
<value>$Lat</value> |
|
| 211 |
</_nullIf> |
|
| 212 |
</latitude_deg> |
|
| 213 |
<longitude_deg> |
|
| 214 |
<_nullIf> |
|
| 215 |
<null>0</null> |
|
| 216 |
<type>float</type> |
|
| 217 |
<value>$Long</value> |
|
| 218 |
</_nullIf> |
|
| 219 |
</longitude_deg> |
|
| 208 | 220 |
</coordinates> |
| 209 | 221 |
</coordinates_id> |
| 210 | 222 |
<country>$Country</country> |
| 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,
|
|
| 59 |
VerbatimLongitude,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg,
|
|
| 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",
|
|
| 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/QMOR/Specimen/VegBIEN.csv | ||
|---|---|---|
| 74 | 74 |
continent,/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,
|
|
| 78 |
decimalLongitude,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg,
|
|
| 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",
|
|
| 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/GBIF/Specimen/test.xml.ref | ||
|---|---|---|
| 251 | 251 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 252 | 252 |
<coordinates_id> |
| 253 | 253 |
<coordinates> |
| 254 |
<latitude_deg>$VerbatimLatitude</latitude_deg> |
|
| 255 |
<longitude_deg>$VerbatimLongitude</longitude_deg> |
|
| 254 |
<latitude_deg> |
|
| 255 |
<_nullIf> |
|
| 256 |
<null>0</null> |
|
| 257 |
<type>float</type> |
|
| 258 |
<value>$VerbatimLatitude</value> |
|
| 259 |
</_nullIf> |
|
| 260 |
</latitude_deg> |
|
| 261 |
<longitude_deg> |
|
| 262 |
<_nullIf> |
|
| 263 |
<null>0</null> |
|
| 264 |
<type>float</type> |
|
| 265 |
<value>$VerbatimLongitude</value> |
|
| 266 |
</_nullIf> |
|
| 267 |
</longitude_deg> |
|
| 256 | 268 |
</coordinates> |
| 257 | 269 |
</coordinates_id> |
| 258 | 270 |
<country>$Country</country> |
| 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,
|
|
| 218 |
dwc_geospatial_DecimalLatitude,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg,
|
|
| 219 |
dwc_terms_decimalLatitude,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg,
|
|
| 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,
|
|
| 221 |
dwc_geospatial_DecimalLongitude,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg,
|
|
| 222 |
dwc_terms_decimalLongitude,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg,
|
|
| 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",
|
|
| 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/SpeciesLink/Specimen/test.xml.ref | ||
|---|---|---|
| 641 | 641 |
<coordinates_id> |
| 642 | 642 |
<coordinates> |
| 643 | 643 |
<latitude_deg> |
| 644 |
<_alt> |
|
| 645 |
<0>$conceptual_darwin_2003_1_0_Latitude</0> |
|
| 646 |
<1>$dwc_geospatial_DecimalLatitude</1> |
|
| 647 |
<2>$dwc_terms_decimalLatitude</2> |
|
| 648 |
</_alt> |
|
| 644 |
<_nullIf> |
|
| 645 |
<null>0</null> |
|
| 646 |
<type>float</type> |
|
| 647 |
<value> |
|
| 648 |
<_alt> |
|
| 649 |
<0>$conceptual_darwin_2003_1_0_Latitude</0> |
|
| 650 |
<1>$dwc_geospatial_DecimalLatitude</1> |
|
| 651 |
<2>$dwc_terms_decimalLatitude</2> |
|
| 652 |
</_alt> |
|
| 653 |
</value> |
|
| 654 |
</_nullIf> |
|
| 649 | 655 |
</latitude_deg> |
| 650 | 656 |
<longitude_deg> |
| 651 |
<_alt> |
|
| 652 |
<0>$conceptual_darwin_2003_1_0_Longitude</0> |
|
| 653 |
<1>$dwc_geospatial_DecimalLongitude</1> |
|
| 654 |
<2>$dwc_terms_decimalLongitude</2> |
|
| 655 |
</_alt> |
|
| 657 |
<_nullIf> |
|
| 658 |
<null>0</null> |
|
| 659 |
<type>float</type> |
|
| 660 |
<value> |
|
| 661 |
<_alt> |
|
| 662 |
<0>$conceptual_darwin_2003_1_0_Longitude</0> |
|
| 663 |
<1>$dwc_geospatial_DecimalLongitude</1> |
|
| 664 |
<2>$dwc_terms_decimalLongitude</2> |
|
| 665 |
</_alt> |
|
| 666 |
</value> |
|
| 667 |
</_nullIf> |
|
| 656 | 668 |
</longitude_deg> |
| 657 | 669 |
</coordinates> |
| 658 | 670 |
</coordinates_id> |
| inputs/bien_web/observation/VegBIEN.csv | ||
|---|---|---|
| 40 | 40 |
longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
| 41 | 41 |
country,/location/locationplace/*_id/place/country, |
| 42 | 42 |
countyParish,/location/locationplace/*_id/place/county, |
| 43 |
latitude,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg,
|
|
| 44 |
longitude,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg,
|
|
| 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",
|
|
| 45 | 45 |
country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2, |
| 46 | 46 |
stateProvince,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2, |
| 47 | 47 |
stateProvince,/location/locationplace/*_id/place/stateprovince, |
| inputs/bien_web/observation/test.xml.ref | ||
|---|---|---|
| 156 | 156 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 157 | 157 |
<coordinates_id> |
| 158 | 158 |
<coordinates> |
| 159 |
<latitude_deg>$latitude</latitude_deg> |
|
| 160 |
<longitude_deg>$longitude</longitude_deg> |
|
| 159 |
<latitude_deg> |
|
| 160 |
<_nullIf> |
|
| 161 |
<null>0</null> |
|
| 162 |
<type>float</type> |
|
| 163 |
<value>$latitude</value> |
|
| 164 |
</_nullIf> |
|
| 165 |
</latitude_deg> |
|
| 166 |
<longitude_deg> |
|
| 167 |
<_nullIf> |
|
| 168 |
<null>0</null> |
|
| 169 |
<type>float</type> |
|
| 170 |
<value>$longitude</value> |
|
| 171 |
</_nullIf> |
|
| 172 |
</longitude_deg> |
|
| 161 | 173 |
</coordinates> |
| 162 | 174 |
</coordinates_id> |
| 163 | 175 |
<country>$country</country> |
| 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,
|
|
| 74 |
Longitude,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg,
|
|
| 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",
|
|
| 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/NY/Specimen/test.xml.ref | ||
|---|---|---|
| 336 | 336 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 337 | 337 |
<coordinates_id> |
| 338 | 338 |
<coordinates> |
| 339 |
<latitude_deg>$Latitude</latitude_deg> |
|
| 340 |
<longitude_deg>$Longitude</longitude_deg> |
|
| 339 |
<latitude_deg> |
|
| 340 |
<_nullIf> |
|
| 341 |
<null>0</null> |
|
| 342 |
<type>float</type> |
|
| 343 |
<value>$Latitude</value> |
|
| 344 |
</_nullIf> |
|
| 345 |
</latitude_deg> |
|
| 346 |
<longitude_deg> |
|
| 347 |
<_nullIf> |
|
| 348 |
<null>0</null> |
|
| 349 |
<type>float</type> |
|
| 350 |
<value>$Longitude</value> |
|
| 351 |
</_nullIf> |
|
| 352 |
</longitude_deg> |
|
| 341 | 353 |
</coordinates> |
| 342 | 354 |
</coordinates_id> |
| 343 | 355 |
<country>$Country</country> |
| inputs/Madidi/Plot/test.xml.ref | ||
|---|---|---|
| 92 | 92 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 93 | 93 |
<coordinates_id> |
| 94 | 94 |
<coordinates> |
| 95 |
<latitude_deg>$Latitude</latitude_deg> |
|
| 96 |
<longitude_deg>$Longitude</longitude_deg> |
|
| 95 |
<latitude_deg> |
|
| 96 |
<_nullIf> |
|
| 97 |
<null>0</null> |
|
| 98 |
<type>float</type> |
|
| 99 |
<value>$Latitude</value> |
|
| 100 |
</_nullIf> |
|
| 101 |
</latitude_deg> |
|
| 102 |
<longitude_deg> |
|
| 103 |
<_nullIf> |
|
| 104 |
<null>0</null> |
|
| 105 |
<type>float</type> |
|
| 106 |
<value>$Longitude</value> |
|
| 107 |
</_nullIf> |
|
| 108 |
</longitude_deg> |
|
| 97 | 109 |
</coordinates> |
| 98 | 110 |
</coordinates_id> |
| 99 | 111 |
</place> |
| inputs/CVS/Organism/test.xml.ref | ||
|---|---|---|
| 59 | 59 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 60 | 60 |
<coordinates_id> |
| 61 | 61 |
<coordinates> |
| 62 |
<latitude_deg>$publicLatitude</latitude_deg> |
|
| 63 |
<longitude_deg>$publicLongitude</longitude_deg> |
|
| 62 |
<latitude_deg> |
|
| 63 |
<_nullIf> |
|
| 64 |
<null>0</null> |
|
| 65 |
<type>float</type> |
|
| 66 |
<value>$publicLatitude</value> |
|
| 67 |
</_nullIf> |
|
| 68 |
</latitude_deg> |
|
| 69 |
<longitude_deg> |
|
| 70 |
<_nullIf> |
|
| 71 |
<null>0</null> |
|
| 72 |
<type>float</type> |
|
| 73 |
<value>$publicLongitude</value> |
|
| 74 |
</_nullIf> |
|
| 75 |
</longitude_deg> |
|
| 64 | 76 |
</coordinates> |
| 65 | 77 |
</coordinates_id> |
| 66 | 78 |
<stateprovince>$state</stateprovince> |
| inputs/SALVIAS-CSV/Plot/test.xml.ref | ||
|---|---|---|
| 105 | 105 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 106 | 106 |
<coordinates_id> |
| 107 | 107 |
<coordinates> |
| 108 |
<latitude_deg>$lat_decimal</latitude_deg> |
|
| 109 |
<longitude_deg>$long_decimal</longitude_deg> |
|
| 108 |
<latitude_deg> |
|
| 109 |
<_nullIf> |
|
| 110 |
<null>0</null> |
|
| 111 |
<type>float</type> |
|
| 112 |
<value>$lat_decimal</value> |
|
| 113 |
</_nullIf> |
|
| 114 |
</latitude_deg> |
|
| 115 |
<longitude_deg> |
|
| 116 |
<_nullIf> |
|
| 117 |
<null>0</null> |
|
| 118 |
<type>float</type> |
|
| 119 |
<value>$long_decimal</value> |
|
| 120 |
</_nullIf> |
|
| 121 |
</longitude_deg> |
|
| 110 | 122 |
</coordinates> |
| 111 | 123 |
</coordinates_id> |
| 112 | 124 |
<country>$country</country> |
| inputs/REMIB/Specimen/test.xml.ref | ||
|---|---|---|
| 169 | 169 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 170 | 170 |
<coordinates_id> |
| 171 | 171 |
<coordinates> |
| 172 |
<latitude_deg>$lat_deg</latitude_deg> |
|
| 173 |
<longitude_deg>$long_deg</longitude_deg> |
|
| 172 |
<latitude_deg> |
|
| 173 |
<_nullIf> |
|
| 174 |
<null>0</null> |
|
| 175 |
<type>float</type> |
|
| 176 |
<value>$lat_deg</value> |
|
| 177 |
</_nullIf> |
|
| 178 |
</latitude_deg> |
|
| 179 |
<longitude_deg> |
|
| 180 |
<_nullIf> |
|
| 181 |
<null>0</null> |
|
| 182 |
<type>float</type> |
|
| 183 |
<value>$long_deg</value> |
|
| 184 |
</_nullIf> |
|
| 185 |
</longitude_deg> |
|
| 174 | 186 |
</coordinates> |
| 175 | 187 |
</coordinates_id> |
| 176 | 188 |
<country>$country</country> |
| 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,
|
|
| 78 |
DecimalLongitude,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg,
|
|
| 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",
|
|
| 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/QMOR/Specimen/test.xml.ref | ||
|---|---|---|
| 275 | 275 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 276 | 276 |
<coordinates_id> |
| 277 | 277 |
<coordinates> |
| 278 |
<latitude_deg>$decimalLatitude</latitude_deg> |
|
| 279 |
<longitude_deg>$decimalLongitude</longitude_deg> |
|
| 278 |
<latitude_deg> |
|
| 279 |
<_nullIf> |
|
| 280 |
<null>0</null> |
|
| 281 |
<type>float</type> |
|
| 282 |
<value>$decimalLatitude</value> |
|
| 283 |
</_nullIf> |
|
| 284 |
</latitude_deg> |
|
| 285 |
<longitude_deg> |
|
| 286 |
<_nullIf> |
|
| 287 |
<null>0</null> |
|
| 288 |
<type>float</type> |
|
| 289 |
<value>$decimalLongitude</value> |
|
| 290 |
</_nullIf> |
|
| 291 |
</longitude_deg> |
|
| 280 | 292 |
</coordinates> |
| 281 | 293 |
</coordinates_id> |
| 282 | 294 |
<country>$country</country> |
| inputs/VegBank/plot_/test.xml.ref | ||
|---|---|---|
| 46 | 46 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 47 | 47 |
<coordinates_id> |
| 48 | 48 |
<coordinates> |
| 49 |
<latitude_deg>$latitude</latitude_deg> |
|
| 50 |
<longitude_deg>$longitude</longitude_deg> |
|
| 49 |
<latitude_deg> |
|
| 50 |
<_nullIf> |
|
| 51 |
<null>0</null> |
|
| 52 |
<type>float</type> |
|
| 53 |
<value>$latitude</value> |
|
| 54 |
</_nullIf> |
|
| 55 |
</latitude_deg> |
|
| 56 |
<longitude_deg> |
|
| 57 |
<_nullIf> |
|
| 58 |
<null>0</null> |
|
| 59 |
<type>float</type> |
|
| 60 |
<value>$longitude</value> |
|
| 61 |
</_nullIf> |
|
| 62 |
</longitude_deg> |
|
| 51 | 63 |
</coordinates> |
| 52 | 64 |
</coordinates_id> |
| 53 | 65 |
<country> |
| inputs/NCU-NCSC/Specimen/test.xml.ref | ||
|---|---|---|
| 96 | 96 |
<coordinates_id> |
| 97 | 97 |
<coordinates> |
| 98 | 98 |
<latitude_deg> |
| 99 |
<_replace> |
|
| 100 |
<\?$></\?$> |
|
| 101 |
<value>$Lat (-=S)</value> |
|
| 102 |
</_replace> |
|
| 99 |
<_nullIf> |
|
| 100 |
<null>0</null> |
|
| 101 |
<type>float</type> |
|
| 102 |
<value> |
|
| 103 |
<_replace> |
|
| 104 |
<\?$></\?$> |
|
| 105 |
<value>$Lat (-=S)</value> |
|
| 106 |
</_replace> |
|
| 107 |
</value> |
|
| 108 |
</_nullIf> |
|
| 103 | 109 |
</latitude_deg> |
| 104 | 110 |
<longitude_deg> |
| 105 |
<_replace> |
|
| 106 |
<\?$></\?$> |
|
| 107 |
<value>$Long (-=W)</value> |
|
| 108 |
</_replace> |
|
| 111 |
<_nullIf> |
|
| 112 |
<null>0</null> |
|
| 113 |
<type>float</type> |
|
| 114 |
<value> |
|
| 115 |
<_replace> |
|
| 116 |
<\?$></\?$> |
|
| 117 |
<value>$Long (-=W)</value> |
|
| 118 |
</_replace> |
|
| 119 |
</value> |
|
| 120 |
</_nullIf> |
|
| 109 | 121 |
</longitude_deg> |
| 110 | 122 |
</coordinates> |
| 111 | 123 |
</coordinates_id> |
| 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,
|
|
| 24 |
longitude,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg,
|
|
| 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",
|
|
| 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, |
| mappings/VegCore-VegBIEN.csv | ||
|---|---|---|
| 316 | 316 |
county,/location/locationplace/*_id/place/county, |
| 317 | 317 |
acceptedDecimalLatitude,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/1/latitude_deg, |
| 318 | 318 |
acceptedDecimalLongitude,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/1/longitude_deg, |
| 319 |
decimalLatitude,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/latitude_deg,
|
|
| 320 |
decimalLongitude,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg,
|
|
| 319 |
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",
|
|
| 320 |
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",
|
|
| 321 | 321 |
acceptedCountry,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/1, |
| 322 | 322 |
country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2, |
| 323 | 323 |
distanceToCountry_km,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/distance_to_country_m/_km_to_m/value, |
Also available in: Unified diff
mappings/VegCore-VegBIEN.csv: decimalLatitude/Longitude->geoscrub input coordinates: Also set to NULL if 0 here, not just for the coordinates linked to the datasource's place instance