Revision 5908
Added by Aaron Marcuse-Kubitza about 12 years ago
| inputs/XAL/Specimen/VegBIEN.csv | ||
|---|---|---|
| 63 | 63 |
darwin:ContinentOcean,/location/locationplace/*_id/place/continent, |
| 64 | 64 |
darwin:Country,/location/locationplace/*_id/place/country, |
| 65 | 65 |
darwin:County,/location/locationplace/*_id/place/county, |
| 66 |
darwin:Latitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/latitude_deg", |
|
| 67 |
darwin:Longitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/longitude_deg", |
|
| 66 | 68 |
darwin:StateProvince,/location/locationplace/*_id/place/stateprovince, |
| 67 | 69 |
darwin:BasisOfRecord,,** No join mapping for basisOfRecord ** |
| 68 | 70 |
darwin:DateLastModified,,** No join mapping for dcterms:modified ** |
| 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/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/latitude_deg", |
|
| 39 |
Longitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/longitude_deg", |
|
| 38 | 40 |
Subplot Number,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/cond/_exists", |
| 39 | 41 |
1ha Plot Number,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/2", |
| 40 | 42 |
Subplot Number,/location/sourceaccessioncode/_join/2, |
| 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/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/latitude_deg", |
|
| 39 |
Longitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/longitude_deg", |
|
| 38 | 40 |
Subplot Number,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/cond/_exists", |
| 39 | 41 |
1ha Plot Number,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/2", |
| 40 | 42 |
Subplot Number,/location/sourceaccessioncode/_join/2, |
| 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/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/latitude_deg", |
|
| 12 |
Longitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/longitude_deg", |
|
| 11 | 13 |
Name,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/2", |
| 12 | 14 |
1ha Plot Coordinate,,** No join mapping for *1ha Plot Coordinate ** |
| inputs/NY/Specimen/VegBIEN.csv | ||
|---|---|---|
| 71 | 71 |
ContinentOcean,/location/locationplace/*_id/place/continent, |
| 72 | 72 |
Country,/location/locationplace/*_id/place/country, |
| 73 | 73 |
County,/location/locationplace/*_id/place/county, |
| 74 |
Latitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/latitude_deg", |
|
| 75 |
Longitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/longitude_deg", |
|
| 74 | 76 |
StateProvince,/location/locationplace/*_id/place/stateprovince, |
| 75 | 77 |
BasisOfRecord,,** No join mapping for basisOfRecord ** |
| 76 | 78 |
CollectorNumber,,** No non-empty join mapping for UNUSED ** |
| 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/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/latitude_deg", |
|
| 92 |
Longitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/longitude_deg", |
|
| 91 | 93 |
Inventory code,"/location/locationplace/*_id/place/placecode/_if[@name=""if geovalidation""]/then", |
| 92 | 94 |
Observaciones,/location/notespublic, |
| 93 | 95 |
Direction,/location/slopeaspect_deg/_alt/1/_compass/value/_alt/1,Part files provide either this field or Orientación |
| inputs/ACAD/Specimen/VegBIEN.csv | ||
|---|---|---|
| 67 | 67 |
continent,/location/locationplace/*_id/place/continent, |
| 68 | 68 |
country,/location/locationplace/*_id/place/country, |
| 69 | 69 |
county,/location/locationplace/*_id/place/county, |
| 70 |
decimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/latitude_deg", |
|
| 71 |
decimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/longitude_deg", |
|
| 70 | 72 |
stateProvince,/location/locationplace/*_id/place/stateprovince, |
| 71 | 73 |
verbatimElevation,/location/verbatimelevation, |
| 72 | 74 |
basisOfRecord,,** No join mapping for basisOfRecord ** |
| 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/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/latitude_deg", |
|
| 47 |
long_decimal,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/longitude_deg", |
|
| 46 | 48 |
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." |
| 47 | 49 |
pol1,/location/locationplace/*_id/place/stateprovince,Brad: No; pol1=stateProvince |
| 48 | 50 |
slope_aspect,/location/slopeaspect_deg/_alt/1/_compass/value, |
| 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/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/latitude_deg", |
|
| 18 |
publicLongitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/longitude_deg", |
|
| 17 | 19 |
state,/location/locationplace/*_id/place/stateprovince, |
| 18 | 20 |
confidentialityStatus,,** No join mapping for *confidentialityStatus ** |
| 19 | 21 |
realLatitude,,** No non-empty join mapping for PRIVATE ** |
| 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/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/latitude_deg", |
|
| 65 |
long_deg,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/longitude_deg", |
|
| 64 | 66 |
state,/location/locationplace/*_id/place/stateprovince, |
| 65 | 67 |
lat_min,,** No join mapping for *lat_min ** |
| 66 | 68 |
lat_sec,,** No join mapping for *lat_sec ** |
| 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/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/latitude_deg", |
|
| 28 |
Longitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/longitude_deg", |
|
| 27 | 29 |
PlotID,"/location/locationplace/*_id/place/placecode/_if[@name=""if geovalidation""]/then", |
| 28 | 30 |
PlotID,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/1", |
| 29 | 31 |
PlotName,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/2", |
| 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/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/latitude_deg", |
|
| 30 |
DecimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/longitude_deg", |
|
| 29 | 31 |
PlotCD,"/location/locationplace/*_id/place/placecode/_if[@name=""if geovalidation""]/then", |
| 30 | 32 |
StateProvince,/location/locationplace/*_id/place/stateprovince, |
| 31 | 33 |
PlotCD,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/1", |
| 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/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/latitude_deg", |
|
| 48 |
LongDec,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/longitude_deg", |
|
| 47 | 49 |
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." |
| 48 | 50 |
PolDiv1,/location/locationplace/*_id/place/stateprovince,Brad: No; pol1=stateProvince |
| 49 | 51 |
plot_notes,/location/notespublic, |
| inputs/U/Specimen/VegBIEN.csv | ||
|---|---|---|
| 36 | 36 |
Lat,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value", |
| 37 | 37 |
Long,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
| 38 | 38 |
Country,/location/locationplace/*_id/place/country, |
| 39 |
Lat,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/latitude_deg", |
|
| 40 |
Long,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/longitude_deg", |
|
| 39 | 41 |
Alt,,** No join mapping for *Alt ** What is this? |
| 40 | 42 |
Alt2,,** No join mapping for *Alt2 ** What is this? |
| 41 | 43 |
Coorsyst,,** No join mapping for *Coorsyst ** |
| inputs/ARIZ/Specimen/VegBIEN.csv | ||
|---|---|---|
| 75 | 75 |
ContinentOcean,/location/locationplace/*_id/place/continent, |
| 76 | 76 |
Country,/location/locationplace/*_id/place/country, |
| 77 | 77 |
County,/location/locationplace/*_id/place/county, |
| 78 |
DecimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/latitude_deg", |
|
| 79 |
DecimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/longitude_deg", |
|
| 78 | 80 |
StateProvince,/location/locationplace/*_id/place/stateprovince, |
| 79 | 81 |
AgeClass,,** No join mapping for lifeStage ** |
| 80 | 82 |
BasisOfRecord,,** No join mapping for basisOfRecord ** |
| inputs/GBIF/Specimen/VegBIEN.csv | ||
|---|---|---|
| 56 | 56 |
VerbatimLongitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
| 57 | 57 |
Country,/location/locationplace/*_id/place/country, |
| 58 | 58 |
County,/location/locationplace/*_id/place/county, |
| 59 |
VerbatimLatitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/latitude_deg", |
|
| 60 |
VerbatimLongitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/longitude_deg", |
|
| 59 | 61 |
StateProvince,/location/locationplace/*_id/place/stateprovince, |
| 60 | 62 |
0,,** No join mapping for *0 ** |
| 61 | 63 |
1,,** No join mapping for *1 ** |
| 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/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/latitude_deg/_replace:[""\?$""=]/value", |
|
| 24 |
Long (-=W),"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/longitude_deg/_replace:[""\?$""=]/value", |
|
| 23 | 25 |
State,/location/locationplace/*_id/place/stateprovince, |
| 24 | 26 |
Elevation,/location/verbatimelevation, |
| 25 | 27 |
Alt E/W,,** No join mapping for *Alt E/W ** |
| inputs/SpeciesLink/Specimen/VegBIEN.csv | ||
|---|---|---|
| 217 | 217 |
conceptual_darwin_2003_1_0_County,/location/locationplace/*_id/place/county, |
| 218 | 218 |
dwc_dwcore_County,/location/locationplace/*_id/place/county, |
| 219 | 219 |
dwc_terms_county,/location/locationplace/*_id/place/county, |
| 220 |
conceptual_darwin_2003_1_0_Latitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/latitude_deg", |
|
| 221 |
dwc_geospatial_DecimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/latitude_deg", |
|
| 222 |
dwc_terms_decimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/latitude_deg", |
|
| 223 |
conceptual_darwin_2003_1_0_Longitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/longitude_deg", |
|
| 224 |
dwc_geospatial_DecimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/longitude_deg", |
|
| 225 |
dwc_terms_decimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/longitude_deg", |
|
| 220 | 226 |
conceptual_darwin_2003_1_0_StateProvince,/location/locationplace/*_id/place/stateprovince, |
| 221 | 227 |
dwc_dwcore_StateProvince,/location/locationplace/*_id/place/stateprovince, |
| 222 | 228 |
dwc_terms_stateProvince,/location/locationplace/*_id/place/stateprovince, |
| inputs/bien_web/observation/VegBIEN.csv | ||
|---|---|---|
| 41 | 41 |
longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
| 42 | 42 |
country,/location/locationplace/*_id/place/country, |
| 43 | 43 |
countyParish,/location/locationplace/*_id/place/county, |
| 44 |
latitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/latitude_deg", |
|
| 45 |
longitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/longitude_deg", |
|
| 44 | 46 |
stateProvince,/location/locationplace/*_id/place/stateprovince, |
| 45 | 47 |
plotCode,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/2", |
| 46 | 48 |
isCultivatedReason,,** No join mapping for cultivatedBasis ** |
| inputs/MO/Specimen/VegBIEN.csv | ||
|---|---|---|
| 51 | 51 |
ContinentOcean,/location/locationplace/*_id/place/continent, |
| 52 | 52 |
Country,/location/locationplace/*_id/place/country, |
| 53 | 53 |
County,/location/locationplace/*_id/place/county, |
| 54 |
latitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/latitude_deg", |
|
| 55 |
longitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/longitude_deg", |
|
| 54 | 56 |
StateProvince,/location/locationplace/*_id/place/stateprovince, |
| 55 | 57 |
BasisOfRecord,,** No join mapping for basisOfRecord ** |
| 56 | 58 |
DateLastModified,,** No join mapping for dcterms:modified ** |
| 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/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/latitude_deg", |
|
| 24 |
longitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/longitude_deg", |
|
| 23 | 25 |
plot_id,"/location/locationplace/*_id/place/placecode/_if[@name=""if geovalidation""]/then", |
| 24 | 26 |
region|state|province,/location/locationplace/*_id/place/stateprovince, |
| 25 | 27 |
stateprovince,/location/locationplace/*_id/place/stateprovince, |
| inputs/QMOR/Specimen/VegBIEN.csv | ||
|---|---|---|
| 75 | 75 |
continent,/location/locationplace/*_id/place/continent, |
| 76 | 76 |
country,/location/locationplace/*_id/place/country, |
| 77 | 77 |
county,/location/locationplace/*_id/place/county, |
| 78 |
decimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/latitude_deg", |
|
| 79 |
decimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/longitude_deg", |
|
| 78 | 80 |
stateProvince,/location/locationplace/*_id/place/stateprovince, |
| 79 | 81 |
verbatimElevation,/location/verbatimelevation, |
| 80 | 82 |
acceptedNameUsage,,** No join mapping for acceptedNameUsage ** |
| mappings/VegCore-VegBIEN.csv | ||
|---|---|---|
| 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 |
acceptedDecimalLatitude,/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/1/latitude_deg, |
|
| 318 |
acceptedDecimalLongitude,/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/1/longitude_deg, |
|
| 319 |
georeferenceValid,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/cond/_exists", |
|
| 320 |
latLongInCountry,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/cond/_exists", |
|
| 321 |
decimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/latitude_deg", |
|
| 322 |
decimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place/*_id/coordinates/_first/2/_if[@name=""if geovalidation""]/then/longitude_deg", |
|
| 323 |
acceptedCountry,/location/locationplace/*_id/place/matched_place_id/place/country, |
|
| 324 |
acceptedStateProvince,/location/locationplace/*_id/place/matched_place_id/place/stateprovince, |
|
| 317 | 325 |
georeferenceValid,"/location/locationplace/*_id/place/placecode/_if[@name=""if geovalidation""]/cond/_exists", |
| 318 | 326 |
latLongInCountry,"/location/locationplace/*_id/place/placecode/_if[@name=""if geovalidation""]/cond/_exists", |
| 319 | 327 |
locationID,"/location/locationplace/*_id/place/placecode/_if[@name=""if geovalidation""]/then", |
| mappings/for_review/VegCore-VegBIEN.csv | ||
|---|---|---|
| 314 | 314 |
continent,//place/continent, |
| 315 | 315 |
country,//place/country, |
| 316 | 316 |
county,//place/county, |
| 317 |
acceptedDecimalLatitude,//*_id/coordinates/latitude_deg, |
|
| 318 |
acceptedDecimalLongitude,//*_id/coordinates/longitude_deg, |
|
| 319 |
georeferenceValid,"//*_id/coordinates/_if[@name=""if geovalidation""]/cond/_exists", |
|
| 320 |
latLongInCountry,"//*_id/coordinates/_if[@name=""if geovalidation""]/cond/_exists", |
|
| 321 |
decimalLatitude,"//*_id/coordinates/_if[@name=""if geovalidation""]/then/latitude_deg", |
|
| 322 |
decimalLongitude,"//*_id/coordinates/_if[@name=""if geovalidation""]/then/longitude_deg", |
|
| 323 |
acceptedCountry,//place/country, |
|
| 324 |
acceptedStateProvince,//place/stateprovince, |
|
| 317 | 325 |
georeferenceValid,"//place/placecode/_if[@name=""if geovalidation""]/cond/_exists", |
| 318 | 326 |
latLongInCountry,"//place/placecode/_if[@name=""if geovalidation""]/cond/_exists", |
| 319 | 327 |
locationID,"//place/placecode/_if[@name=""if geovalidation""]/then", |
Also available in: Unified diff
mappings/VegCore-VegBIEN.csv: Mapped acceptedCountry, acceptedStateProvince, acceptedDecimalLatitude/Longitude. Mapped decimalLatitude/Longitude to matched place's coordinates when acceptedDecimalLatitude/Longitude not provided (as is the case for the geoscrub table).