Revision 6123
Added by Aaron Marcuse-Kubitza about 12 years ago
| 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 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
|
| 140 | 141 |
<latitude_deg> |
| 141 | 142 |
<_nullIf> |
| 142 | 143 |
<null>0</null> |
| ... | ... | |
| 164 | 165 |
</path> |
| 165 | 166 |
</_simplifyPath> |
| 166 | 167 |
</VegBIEN> |
| 167 |
Inserted 24 new rows into database |
|
| 168 |
Inserted 25 new rows into database |
|
| 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",""".,"" 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" |
|
| 23 |
Lat (-=S),"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_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:[reference_id/reference/shortname=geoscrub]/_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/test.xml.ref | ||
|---|---|---|
| 223 | 223 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 224 | 224 |
<coordinates_id> |
| 225 | 225 |
<coordinates> |
| 226 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
|
| 226 | 227 |
<latitude_deg> |
| 227 | 228 |
<_nullIf> |
| 228 | 229 |
<null>0</null> |
| 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",""".,"" 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" |
|
| 94 |
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_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:[reference_id/reference/shortname=geoscrub]/_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",""".,"" 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" |
|
| 19 |
publicLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_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:[reference_id/reference/shortname=geoscrub]/_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",""".,"" 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" |
|
| 50 |
lat_decimal,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_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:[reference_id/reference/shortname=geoscrub]/_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",""".,"" 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" |
|
| 64 |
lat_deg,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_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:[reference_id/reference/shortname=geoscrub]/_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",""".,"" 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" |
|
| 29 |
DecimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_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:[reference_id/reference/shortname=geoscrub]/_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/test.xml.ref | ||
|---|---|---|
| 312 | 312 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 313 | 313 |
<coordinates_id> |
| 314 | 314 |
<coordinates> |
| 315 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
|
| 315 | 316 |
<latitude_deg> |
| 316 | 317 |
<_nullIf> |
| 317 | 318 |
<null>0</null> |
| 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",""".,"" 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" |
|
| 53 |
latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_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:[reference_id/reference/shortname=geoscrub]/_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/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",""".,"" 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" |
|
| 79 |
decimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_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:[reference_id/reference/shortname=geoscrub]/_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, |
| 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 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
|
| 278 | 279 |
<latitude_deg> |
| 279 | 280 |
<_nullIf> |
| 280 | 281 |
<null>0</null> |
| 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 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
|
| 49 | 50 |
<latitude_deg> |
| 50 | 51 |
<_nullIf> |
| 51 | 52 |
<null>0</null> |
| ... | ... | |
| 112 | 113 |
</path> |
| 113 | 114 |
</_simplifyPath> |
| 114 | 115 |
</VegBIEN> |
| 115 |
Inserted 11 new rows into database |
|
| 116 |
Inserted 12 new rows into database |
|
| 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",""".,"" 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" |
|
| 65 |
darwin:Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_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:[reference_id/reference/shortname=geoscrub]/_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",""".,"" 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" |
|
| 43 |
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_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:[reference_id/reference/shortname=geoscrub]/_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/VL/test.xml.ref | ||
|---|---|---|
| 152 | 152 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 153 | 153 |
<coordinates_id> |
| 154 | 154 |
<coordinates> |
| 155 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
|
| 155 | 156 |
<latitude_deg> |
| 156 | 157 |
<_nullIf> |
| 157 | 158 |
<null>0</null> |
| 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",""".,"" 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" |
|
| 43 |
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_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:[reference_id/reference/shortname=geoscrub]/_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/test.xml.ref | ||
|---|---|---|
| 152 | 152 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 153 | 153 |
<coordinates_id> |
| 154 | 154 |
<coordinates> |
| 155 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
|
| 155 | 156 |
<latitude_deg> |
| 156 | 157 |
<_nullIf> |
| 157 | 158 |
<null>0</null> |
| 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",""".,"" 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" |
|
| 14 |
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_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:[reference_id/reference/shortname=geoscrub]/_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/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 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
|
| 39 | 40 |
<latitude_deg> |
| 40 | 41 |
<_nullIf> |
| 41 | 42 |
<null>0</null> |
| ... | ... | |
| 61 | 62 |
</path> |
| 62 | 63 |
</_simplifyPath> |
| 63 | 64 |
</VegBIEN> |
| 64 |
Inserted 15 new rows into database |
|
| 65 |
Inserted 17 new rows into database |
|
| 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 |
latitudeDecimalVerbatim,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_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:[reference_id/reference/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 8 | 8 |
countryStd,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub,matched_place_id=0]/country/_first/1", |
| 9 | 9 |
stateProvinceStd,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub,matched_place_id=0]/stateprovince/_first/1", |
| 10 | 10 |
countryVerbatim,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2, |
| 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 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
|
| 34 | 35 |
<latitude_deg> |
| 35 | 36 |
<_nullIf> |
| 36 | 37 |
<null>0</null> |
| 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",""".,"" 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" |
|
| 71 |
decimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_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:[reference_id/reference/shortname=geoscrub]/_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/ACAD/Specimen/test.xml.ref | ||
|---|---|---|
| 250 | 250 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 251 | 251 |
<coordinates_id> |
| 252 | 252 |
<coordinates> |
| 253 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
|
| 253 | 254 |
<latitude_deg> |
| 254 | 255 |
<_nullIf> |
| 255 | 256 |
<null>0</null> |
| ... | ... | |
| 279 | 280 |
</path> |
| 280 | 281 |
</_simplifyPath> |
| 281 | 282 |
</VegBIEN> |
| 282 |
Inserted 42 new rows into database |
|
| 283 |
Inserted 44 new rows into database |
|
| 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",""".,"" 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" |
|
| 27 |
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_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:[reference_id/reference/shortname=geoscrub]/_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/CTFS/Plot/test.xml.ref | ||
|---|---|---|
| 42 | 42 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 43 | 43 |
<coordinates_id> |
| 44 | 44 |
<coordinates> |
| 45 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
|
| 45 | 46 |
<latitude_deg> |
| 46 | 47 |
<_nullIf> |
| 47 | 48 |
<null>0</null> |
| 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",""".,"" 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" |
|
| 51 |
LatDec,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_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:[reference_id/reference/shortname=geoscrub]/_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/SALVIAS/plotMetadata_/test.xml.ref | ||
|---|---|---|
| 115 | 115 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 116 | 116 |
<coordinates_id> |
| 117 | 117 |
<coordinates> |
| 118 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
|
| 118 | 119 |
<latitude_deg> |
| 119 | 120 |
<_nullIf> |
| 120 | 121 |
<null>0</null> |
| ... | ... | |
| 146 | 147 |
</path> |
| 147 | 148 |
</_simplifyPath> |
| 148 | 149 |
</VegBIEN> |
| 149 |
Inserted 26 new rows into database |
|
| 150 |
Inserted 28 new rows into database |
|
| 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",""".,"" 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" |
|
| 38 |
Lat,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_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:[reference_id/reference/shortname=geoscrub]/_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/U/Specimen/test.xml.ref | ||
|---|---|---|
| 203 | 203 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 204 | 204 |
<coordinates_id> |
| 205 | 205 |
<coordinates> |
| 206 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
|
| 206 | 207 |
<latitude_deg> |
| 207 | 208 |
<_nullIf> |
| 208 | 209 |
<null>0</null> |
| ... | ... | |
| 229 | 230 |
</path> |
| 230 | 231 |
</_simplifyPath> |
| 231 | 232 |
</VegBIEN> |
| 232 |
Inserted 33 new rows into database |
|
| 233 |
Inserted 34 new rows into database |
|
| 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",""".,"" 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" |
|
| 58 |
VerbatimLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_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:[reference_id/reference/shortname=geoscrub]/_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/GBIF/Specimen/test.xml.ref | ||
|---|---|---|
| 251 | 251 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 252 | 252 |
<coordinates_id> |
| 253 | 253 |
<coordinates> |
| 254 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
|
| 254 | 255 |
<latitude_deg> |
| 255 | 256 |
<_nullIf> |
| 256 | 257 |
<null>0</null> |
| 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",""".,"" 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" |
|
| 217 |
conceptual_darwin_2003_1_0_Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_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:[reference_id/reference/shortname=geoscrub]/_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:[reference_id/reference/shortname=geoscrub]/_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:[reference_id/reference/shortname=geoscrub]/_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:[reference_id/reference/shortname=geoscrub]/_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:[reference_id/reference/shortname=geoscrub]/_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/SpeciesLink/Specimen/test.xml.ref | ||
|---|---|---|
| 640 | 640 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 641 | 641 |
<coordinates_id> |
| 642 | 642 |
<coordinates> |
| 643 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
|
| 643 | 644 |
<latitude_deg> |
| 644 | 645 |
<_nullIf> |
| 645 | 646 |
<null>0</null> |
| 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",""".,"" 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" |
|
| 48 |
latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_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:[reference_id/reference/shortname=geoscrub]/_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/bien_web/observation/test.xml.ref | ||
|---|---|---|
| 157 | 157 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 158 | 158 |
<coordinates_id> |
| 159 | 159 |
<coordinates> |
| 160 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
|
| 160 | 161 |
<latitude_deg> |
| 161 | 162 |
<_nullIf> |
| 162 | 163 |
<null>0</null> |
| 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",""".,"" 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" |
|
| 73 |
Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_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:[reference_id/reference/shortname=geoscrub]/_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/NY/Specimen/test.xml.ref | ||
|---|---|---|
| 336 | 336 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 337 | 337 |
<coordinates_id> |
| 338 | 338 |
<coordinates> |
| 339 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
|
| 339 | 340 |
<latitude_deg> |
| 340 | 341 |
<_nullIf> |
| 341 | 342 |
<null>0</null> |
| ... | ... | |
| 364 | 365 |
</path> |
| 365 | 366 |
</_simplifyPath> |
| 366 | 367 |
</VegBIEN> |
| 367 |
Inserted 41 new rows into database |
|
| 368 |
Inserted 43 new rows into database |
|
| 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 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
|
| 95 | 96 |
<latitude_deg> |
| 96 | 97 |
<_nullIf> |
| 97 | 98 |
<null>0</null> |
| 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 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
|
| 62 | 63 |
<latitude_deg> |
| 63 | 64 |
<_nullIf> |
| 64 | 65 |
<null>0</null> |
| ... | ... | |
| 86 | 87 |
</path> |
| 87 | 88 |
</_simplifyPath> |
| 88 | 89 |
</VegBIEN> |
| 89 |
Inserted 21 new rows into database |
|
| 90 |
Inserted 22 new rows into database |
|
| 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 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
|
| 108 | 109 |
<latitude_deg> |
| 109 | 110 |
<_nullIf> |
| 110 | 111 |
<null>0</null> |
| ... | ... | |
| 135 | 136 |
</path> |
| 136 | 137 |
</_simplifyPath> |
| 137 | 138 |
</VegBIEN> |
| 138 |
Inserted 17 new rows into database |
|
| 139 |
Inserted 18 new rows into database |
|
| 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 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
|
| 172 | 173 |
<latitude_deg> |
| 173 | 174 |
<_nullIf> |
| 174 | 175 |
<null>0</null> |
| ... | ... | |
| 197 | 198 |
</path> |
| 198 | 199 |
</_simplifyPath> |
| 199 | 200 |
</VegBIEN> |
| 200 |
Inserted 29 new rows into database |
|
| 201 |
Inserted 30 new rows into database |
|
| 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",""".,"" 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" |
|
| 77 |
DecimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_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:[reference_id/reference/shortname=geoscrub]/_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/test.xml.ref | ||
|---|---|---|
| 95 | 95 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
| 96 | 96 |
<coordinates_id> |
| 97 | 97 |
<coordinates> |
| 98 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id> |
|
| 98 | 99 |
<latitude_deg> |
| 99 | 100 |
<_nullIf> |
| 100 | 101 |
<null>0</null> |
| 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",""".,"" 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" |
|
| 23 |
latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_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:[reference_id/reference/shortname=geoscrub]/_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, |
| 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",""".,"" 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" |
|
| 327 |
acceptedDecimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,reference_id/reference/shortname=geoscrub,matched_place_id=0]/*_id/coordinates:[reference_id/reference/shortname=geoscrub]/_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:[reference_id/reference/shortname=geoscrub]/_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:[reference_id/reference/shortname=geoscrub]/_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:[reference_id/reference/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
|
|
| 331 | 331 |
acceptedCountry,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub,matched_place_id=0]/country/_first/1", |
| 332 | 332 |
acceptedStateProvince,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub,matched_place_id=0]/stateprovince/_first/1", |
| 333 | 333 |
country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2, |
Also available in: Unified diff
mappings/VegCore-VegBIEN.csv: matched place's coordinates: Fixed bug where coordinates entry itself needed to have its datasource (reference) set to geoscrub, in addition to the place entry that uses it, in order to match up properly with geoscrub's corresponding input place (whose coordinates as well as place are owned by the geoscrub datasource)