collectionID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/2",

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",

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",

latLongInCountry,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/cond/_exists",

locationID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/else",

plotName,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",

county,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2,

distanceToCountry_km,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/distance_to_country_m/_km_to_m/value,

distanceToStateProvince_km,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/distance_to_state_m/_km_to_m/value,

latLongInCountry,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/geovalid/_first/2/_and/1,

latLongInStateProvince,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/geovalid/_first/2/_and/2,

latLongInCounty,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/geovalid/_first/2/_and/3,

georeferenceRemarks,,http://rs.tdwg.org/dwc/terms/#georeferenceRemarks,99

georeferenceSources,,http://rs.tdwg.org/dwc/terms/#georeferenceSources,97

georeferenceVerificationStatus,,http://rs.tdwg.org/dwc/terms/#georeferenceVerificationStatus,98

coordinatePrecision,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"

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"

georeferencedBy,,http://rs.tdwg.org/dwc/terms/#georeferencedBy,94

collectionID,"/location/authorlocationcode/_if[@name=""if catalogNumber""]/then",

voucherType,"/location/authorlocationcode/_if[@name=""if indirect voucher""]/cond",

catalogNumber,"/location/authorlocationcode/_if[@name=""if indirect voucher""]/else",

latLongInCountry,"/location/sourceaccessioncode/_if[@name=""if geovalidation""]/cond/_exists",

locationID,"/location/sourceaccessioncode/_if[@name=""if geovalidation""]/else",

plotName,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",

county,//place/county,

distanceToCountry_km,//place/distance_to_country_m/_km_to_m/value,

distanceToStateProvince_km,//place/distance_to_state_m/_km_to_m/value,

latLongInCountry,//place/geovalid,

latLongInStateProvince,//place/geovalid,

latLongInCounty,//place/geovalid,