Revision 5906
Added by Aaron Marcuse-Kubitza about 12 years ago
| mappings/VegCore-VegBIEN.csv | ||
|---|---|---|
| 11 | 11 |
collectionID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/2", |
| 12 | 12 |
voucherType,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left", |
| 13 | 13 |
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else", |
| 14 |
georeferenceInvalid,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/cond/_exists", |
|
| 15 | 14 |
georeferenceValid,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/cond/_exists", |
| 15 |
latLongInCountry,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/cond/_exists", |
|
| 16 | 16 |
locationID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/else", |
| 17 | 17 |
plotName,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode", |
| 18 | 18 |
locationID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode", |
| ... | ... | |
| 314 | 314 |
continent,/location/locationplace/*_id/place/continent, |
| 315 | 315 |
country,/location/locationplace/*_id/place/country, |
| 316 | 316 |
county,/location/locationplace/*_id/place/county, |
| 317 |
georeferenceInvalid,"/location/locationplace/*_id/place/placecode/_if[@name=""if geovalidation""]/cond/_exists", |
|
| 318 | 317 |
georeferenceValid,"/location/locationplace/*_id/place/placecode/_if[@name=""if geovalidation""]/cond/_exists", |
| 318 |
latLongInCountry,"/location/locationplace/*_id/place/placecode/_if[@name=""if geovalidation""]/cond/_exists", |
|
| 319 | 319 |
locationID,"/location/locationplace/*_id/place/placecode/_if[@name=""if geovalidation""]/then", |
| 320 | 320 |
stateProvince,/location/locationplace/*_id/place/stateprovince, |
| 321 | 321 |
plotNotes,/location/notespublic, |
| mappings/VegCore.csv | ||
|---|---|---|
| 105 | 105 |
georeferenceRemarks,,http://rs.tdwg.org/dwc/terms/#georeferenceRemarks,99 |
| 106 | 106 |
georeferenceSources,,http://rs.tdwg.org/dwc/terms/#georeferenceSources,97 |
| 107 | 107 |
georeferenceVerificationStatus,,http://rs.tdwg.org/dwc/terms/#georeferenceVerificationStatus,98 |
| 108 |
georeferenceValid,,"http://rs.tdwg.org/dwc/terms/#georeferenceVerificationStatus, http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=bien_web&table=observation&target=tbl_structure.php#isValidLatLong","98, 38" |
|
| 109 |
georeferenceInvalid,,"http://rs.tdwg.org/dwc/terms/#georeferenceVerificationStatus, http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=bien_web&table=observation&target=tbl_structure.php#isValidLatLong, http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=geoscrub&table=geoscrub&target=tbl_structure.php#isBadLatLong","98, 38, 21" |
|
| 108 |
georeferenceValid,,"http://rs.tdwg.org/dwc/terms/#georeferenceVerificationStatus, http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=bien_web&table=observation&target=tbl_structure.php#isGeovalid","98, 39" |
|
| 109 |
latLongDomainValid,Whether the coordinates are in the range of valid decimal values,"http://rs.tdwg.org/dwc/terms/#georeferenceVerificationStatus, http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=bien_web&table=observation&target=tbl_structure.php#isValidLatLong","98, 38" |
|
| 110 |
latLongDomainInvalid,Whether the coordinates are not in the range of valid decimal values,"http://rs.tdwg.org/dwc/terms/#georeferenceVerificationStatus, http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=bien_web&table=observation&target=tbl_structure.php#isValidLatLong, http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=geoscrub&table=geoscrub&target=tbl_structure.php#isBadLatLong","98, 38, 21" |
|
| 110 | 111 |
georeferencedBy,,http://rs.tdwg.org/dwc/terms/#georeferencedBy,94 |
| 111 | 112 |
georeferencedDate,,http://rs.tdwg.org/dwc/terms/#georeferencedDate,95 |
| 112 | 113 |
group,,http://rs.tdwg.org/dwc/terms/#group,114 |
| mappings/for_review/VegCore-VegBIEN.csv | ||
|---|---|---|
| 11 | 11 |
collectionID,"/location/authorlocationcode/_if[@name=""if catalogNumber""]/then", |
| 12 | 12 |
voucherType,"/location/authorlocationcode/_if[@name=""if indirect voucher""]/cond", |
| 13 | 13 |
catalogNumber,"/location/authorlocationcode/_if[@name=""if indirect voucher""]/else", |
| 14 |
georeferenceInvalid,"/location/sourceaccessioncode/_if[@name=""if geovalidation""]/cond/_exists", |
|
| 15 | 14 |
georeferenceValid,"/location/sourceaccessioncode/_if[@name=""if geovalidation""]/cond/_exists", |
| 15 |
latLongInCountry,"/location/sourceaccessioncode/_if[@name=""if geovalidation""]/cond/_exists", |
|
| 16 | 16 |
locationID,"/location/sourceaccessioncode/_if[@name=""if geovalidation""]/else", |
| 17 | 17 |
plotName,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode", |
| 18 | 18 |
locationID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode", |
| ... | ... | |
| 314 | 314 |
continent,//place/continent, |
| 315 | 315 |
country,//place/country, |
| 316 | 316 |
county,//place/county, |
| 317 |
georeferenceInvalid,"//place/placecode/_if[@name=""if geovalidation""]/cond/_exists", |
|
| 318 | 317 |
georeferenceValid,"//place/placecode/_if[@name=""if geovalidation""]/cond/_exists", |
| 318 |
latLongInCountry,"//place/placecode/_if[@name=""if geovalidation""]/cond/_exists", |
|
| 319 | 319 |
locationID,"//place/placecode/_if[@name=""if geovalidation""]/then", |
| 320 | 320 |
stateProvince,//place/stateprovince, |
| 321 | 321 |
plotNotes,//location/notespublic, |
Also available in: Unified diff
mappings/VegCore.csv: Replaced georeferenceInvalid with latLongDomainValid, latLongDomainInvalid because this field is actually just whether the coordinates are in the range of valid decimal values, not whether they are within the named place reference. Re-sourced georeferenceValid to bien_web.observation#isGeovalid rather than isValidLatLong. VegCore-VegBIEN.csv: Replaced now-removed georeferenceInvalid with latLongInCountry for locationID redirection checks.