Revision 3770
Added by Aaron Marcuse-Kubitza over 12 years ago
| mappings/DwC2-VegBIEN.specimens.csv | ||
|---|---|---|
| 2 | 2 |
coordinateUncertaintyInMeters,/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88 |
| 3 | 3 |
coordinatePrecision,/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89 |
| 4 | 4 |
footprintWKT,/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91 |
| 5 |
decimalLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,85 |
|
| 6 |
verbatimLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,81 |
|
| 7 |
decimalLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,86 |
|
| 8 |
verbatimLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,82 |
|
| 5 | 9 |
county,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66 |
| 6 | 10 |
stateProvince,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65 |
| 7 | 11 |
country,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63 |
| ... | ... | |
| 11 | 15 |
habitat,"/specimenreplicate/*_id/locationevent/*_id/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52 |
| 12 | 16 |
minimumElevationInMeters,"/specimenreplicate/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71
|
| 13 | 17 |
maximumElevationInMeters,"/specimenreplicate/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72
|
| 14 |
decimalLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
|
|
| 15 |
verbatimLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81
|
|
| 16 |
decimalLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
|
|
| 17 |
verbatimLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82
|
|
| 18 | 18 |
maximumDepthInMeters,"/specimenreplicate/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75 |
| 19 | 19 |
minimumDepthInMeters,"/specimenreplicate/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,74 |
| 20 | 20 |
eventDate,"/specimenreplicate/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value",,44
|
| mappings/for_review/VegX-VegBIEN.stems.csv | ||
|---|---|---|
| 4 | 4 |
//plot/landform,//location/landform, |
| 5 | 5 |
//geospatial/CoordinateUncertaintyInMeters,//locationdetermination/coordsaccuracy, |
| 6 | 6 |
//geospatial/FootprintWKT,//locationdetermination/footprintgeometry_dwc, |
| 7 |
//geospatial/DecimalLatitude,//locationdetermination/latitude, |
|
| 8 |
//geospatial/DecimalLongitude,//locationdetermination/longitude, |
|
| 7 | 9 |
//plot/location[placeType=county]/placeName,"//locationdetermination/namedplace_id/_simplifyPath/path/_forEach:[do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename", |
| 8 | 10 |
//plot/location[placeType=state]/placeName,"//locationdetermination/namedplace_id/_simplifyPath/path/_forEach:[do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
| 9 | 11 |
//plot/location[placeType=country]/placeName,"//locationdetermination/namedplace_id/_simplifyPath/path/_forEach:[do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
| ... | ... | |
| 14 | 16 |
//plot/slopeGradient,//location/slopegradient, |
| 15 | 17 |
//geospatial/maximumElevationInMeters,"/*_id/plantobservation/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}/_units/value/_rangeEnd/value",
|
| 16 | 18 |
//geospatial/minimumElevationInMeters,"/*_id/plantobservation/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units/value/_rangeStart/value",
|
| 17 |
//geospatial/DecimalLatitude,"/*_id/plantobservation/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}",
|
|
| 18 |
//geospatial/DecimalLongitude,"/*_id/plantobservation/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}",
|
|
| 19 | 19 |
//plotObservation/simpleUserdefined[name=method]/*ID/method/name,//method/name, |
| 20 | 20 |
//project/title[@id=name],//project/projectname, |
| 21 | 21 |
//project/title[@id=sourceAccessionCode],//project/sourceaccessioncode, |
| mappings/VegX-VegBIEN.stems.csv | ||
|---|---|---|
| 4 | 4 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/landform,/*_id/plantobservation/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/landform, |
| 5 | 5 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters,/*_id/plantobservation/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy, |
| 6 | 6 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT,/*_id/plantobservation/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc, |
| 7 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude,/*_id/plantobservation/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/latitude, |
|
| 8 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude,/*_id/plantobservation/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/longitude, |
|
| 7 | 9 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/location[placeType=county]/placeName,"/*_id/plantobservation/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename", |
| 8 | 10 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/location[placeType=state]/placeName,"/*_id/plantobservation/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
| 9 | 11 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/location[placeType=country]/placeName,"/*_id/plantobservation/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
| ... | ... | |
| 14 | 16 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeGradient,/*_id/plantobservation/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/slopegradient, |
| 15 | 17 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters,"/*_id/plantobservation/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}/_units:[default=m,to=m,to=]/value/_rangeEnd/value",
|
| 16 | 18 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters,"/*_id/plantobservation/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value",
|
| 17 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude,"/*_id/plantobservation/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}",
|
|
| 18 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude,"/*_id/plantobservation/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}",
|
|
| 19 | 19 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/simpleUserdefined[name=method]/*ID/method/name,/*_id/plantobservation/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/method/name, |
| 20 | 20 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/*ID->/*s/project/title[@id=name],/*_id/plantobservation/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/project/projectname, |
| 21 | 21 |
/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation/*ID->/*s/plotObservation/*ID->/*s/project/title[@id=sourceAccessionCode],/*_id/plantobservation/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/project/sourceaccessioncode, |
| inputs/NCU-NCSC/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 1 | 1 |
NCU-NCSC[DwC],VegBIEN:,Comments,Order |
| 2 | 2 |
Accuracy,/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88 |
| 3 |
Lat (-=S),"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",,81 |
|
| 4 |
Long (-=W),"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",,82 |
|
| 3 | 5 |
County,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66 |
| 4 | 6 |
State,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65 |
| 5 | 7 |
Country,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63 |
| 6 |
Lat (-=S),"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",,81
|
|
| 7 |
Long (-=W),"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",,82
|
|
| 8 | 8 |
Collect Date,"/specimenreplicate/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/3",,44
|
| 9 | 9 |
Full Taxon Name,"/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname","Brad: Bob, Nick, please is this mapping OK?",134 |
| 10 | 10 |
Barcode,"/specimenreplicate/{catalognumber_dwc,*_id/locationevent/*_id/location/sourceaccessioncode/_alt/2/_merge/3}","Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
|
| inputs/SpeciesLink/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 2 | 2 |
coordinateUncertaintyInMeters,/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88 |
| 3 | 3 |
CoordinatePrecision,/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89 |
| 4 | 4 |
BoundingBox,/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91 |
| 5 |
DecimalLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,85 |
|
| 6 |
Latitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,81 |
|
| 7 |
VerbatimLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,81 |
|
| 8 |
decimalLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,85 |
|
| 9 |
verbatimLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,81 |
|
| 10 |
DecimalLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,86 |
|
| 11 |
Longitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,82 |
|
| 12 |
VerbatimLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,82 |
|
| 13 |
decimalLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,86 |
|
| 14 |
verbatimLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,82 |
|
| 5 | 15 |
County,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66 |
| 6 | 16 |
county,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66 |
| 7 | 17 |
StateProvince,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65 |
| ... | ... | |
| 19 | 29 |
MaximumElevation,"/specimenreplicate/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72
|
| 20 | 30 |
MaximumElevationInMeters,"/specimenreplicate/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72
|
| 21 | 31 |
maximumElevationInMeters,"/specimenreplicate/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72
|
| 22 |
DecimalLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
|
|
| 23 |
Latitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81
|
|
| 24 |
VerbatimLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81
|
|
| 25 |
decimalLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
|
|
| 26 |
verbatimLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81
|
|
| 27 |
DecimalLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
|
|
| 28 |
Longitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82
|
|
| 29 |
VerbatimLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82
|
|
| 30 |
decimalLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
|
|
| 31 |
verbatimLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82
|
|
| 32 | 32 |
MaximumDepth,"/specimenreplicate/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75 |
| 33 | 33 |
MaximumDepthInMeters,"/specimenreplicate/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75 |
| 34 | 34 |
maximumDepthInMeters,"/specimenreplicate/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75 |
| inputs/MO/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 1 | 1 |
MO[DwC],VegBIEN:,Comments,Order |
| 2 |
latitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,81 |
|
| 3 |
longitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,82 |
|
| 2 | 4 |
County,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66 |
| 3 | 5 |
StateProvince,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65 |
| 4 | 6 |
Country,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63 |
| ... | ... | |
| 6 | 8 |
Locality,/specimenreplicate/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68 |
| 7 | 9 |
MinimumElevation,"/specimenreplicate/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71
|
| 8 | 10 |
MaximumElevation,"/specimenreplicate/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72
|
| 9 |
latitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81
|
|
| 10 |
longitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82
|
|
| 11 | 11 |
DayCollected,"/specimenreplicate/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44
|
| 12 | 12 |
MonthCollected,"/specimenreplicate/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,44
|
| 13 | 13 |
YearCollected,"/specimenreplicate/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,44
|
| inputs/QMOR/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 1 | 1 |
QMOR[DwC],VegBIEN:,Comments,Order |
| 2 | 2 |
coordinateUncertaintyInMeters,/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88 |
| 3 | 3 |
footprintWKT,/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91 |
| 4 |
decimalLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,85 |
|
| 5 |
verbatimLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,81 |
|
| 6 |
decimalLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,86 |
|
| 7 |
verbatimLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,82 |
|
| 4 | 8 |
county,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66 |
| 5 | 9 |
stateProvince,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65 |
| 6 | 10 |
country,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63 |
| ... | ... | |
| 9 | 13 |
habitat,"/specimenreplicate/*_id/locationevent/*_id/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52 |
| 10 | 14 |
minimumElevationInMeters,"/specimenreplicate/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71
|
| 11 | 15 |
maximumElevationInMeters,"/specimenreplicate/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72
|
| 12 |
decimalLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
|
|
| 13 |
verbatimLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81
|
|
| 14 |
decimalLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
|
|
| 15 |
verbatimLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82
|
|
| 16 | 16 |
eventDate,"/specimenreplicate/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/2",,44
|
| 17 | 17 |
collectionID,/specimenreplicate/collectionnumber/_alt/2,,9 |
| 18 | 18 |
sex,"/specimenreplicate/definedvalue[*_id/userdefined[tablename=specimenreplicate,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections",26 |
| mappings/VegX-VegBIEN.organisms.csv | ||
|---|---|---|
| 4 | 4 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/landform,/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/landform, |
| 5 | 5 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters,/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy, |
| 6 | 6 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT,/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc, |
| 7 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude,/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/latitude, |
|
| 8 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude,/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/longitude, |
|
| 7 | 9 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/location[placeType=county]/placeName,"/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename", |
| 8 | 10 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/location[placeType=state]/placeName,"/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
| 9 | 11 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/location[placeType=country]/placeName,"/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
| ... | ... | |
| 14 | 16 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeGradient,/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/slopegradient, |
| 15 | 17 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters,"/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}/_units:[default=m,to=m,to=]/value/_rangeEnd/value",
|
| 16 | 18 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters,"/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value",
|
| 17 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude,"/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}",
|
|
| 18 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude,"/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}",
|
|
| 19 | 19 |
/*ID->/*s/plotObservation/simpleUserdefined[name=method]/*ID/method/name,/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/method/name, |
| 20 | 20 |
/*ID->/*s/plotObservation/*ID->/*s/project/title[@id=name],/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/project/projectname, |
| 21 | 21 |
/*ID->/*s/plotObservation/*ID->/*s/project/title[@id=sourceAccessionCode],/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/project/sourceaccessioncode, |
| mappings/for_review/VegX-VegBIEN.organisms.csv | ||
|---|---|---|
| 4 | 4 |
//plot/landform,//location/landform, |
| 5 | 5 |
//geospatial/CoordinateUncertaintyInMeters,//locationdetermination/coordsaccuracy, |
| 6 | 6 |
//geospatial/FootprintWKT,//locationdetermination/footprintgeometry_dwc, |
| 7 |
//geospatial/DecimalLatitude,//locationdetermination/latitude, |
|
| 8 |
//geospatial/DecimalLongitude,//locationdetermination/longitude, |
|
| 7 | 9 |
//plot/location[placeType=county]/placeName,"//locationdetermination/namedplace_id/_simplifyPath/path/_forEach:[do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename", |
| 8 | 10 |
//plot/location[placeType=state]/placeName,"//locationdetermination/namedplace_id/_simplifyPath/path/_forEach:[do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
| 9 | 11 |
//plot/location[placeType=country]/placeName,"//locationdetermination/namedplace_id/_simplifyPath/path/_forEach:[do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
| ... | ... | |
| 14 | 16 |
//plot/slopeGradient,//location/slopegradient, |
| 15 | 17 |
//geospatial/maximumElevationInMeters,"/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}/_units/value/_rangeEnd/value",
|
| 16 | 18 |
//geospatial/minimumElevationInMeters,"/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units/value/_rangeStart/value",
|
| 17 |
//geospatial/DecimalLatitude,"/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}",
|
|
| 18 |
//geospatial/DecimalLongitude,"/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}",
|
|
| 19 | 19 |
//plotObservation/simpleUserdefined[name=method]/*ID/method/name,//method/name, |
| 20 | 20 |
//project/title[@id=name],//project/projectname, |
| 21 | 21 |
//project/title[@id=sourceAccessionCode],//project/sourceaccessioncode, |
| mappings/DwC-VegBIEN.specimens.csv | ||
|---|---|---|
| 7 | 7 |
FootprintWKT,/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91 |
| 8 | 8 |
boundingBox,/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91 |
| 9 | 9 |
footprintWKT,/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91 |
| 10 |
DecimalLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,85 |
|
| 11 |
Latitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,81 |
|
| 12 |
VerbatimLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,81 |
|
| 13 |
decimalLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,85 |
|
| 14 |
latitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,81 |
|
| 15 |
verbatimLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,81 |
|
| 16 |
DecimalLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,86 |
|
| 17 |
Longitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,82 |
|
| 18 |
VerbatimLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,82 |
|
| 19 |
decimalLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,86 |
|
| 20 |
longitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,82 |
|
| 21 |
verbatimLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,82 |
|
| 10 | 22 |
County,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66 |
| 11 | 23 |
county,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66 |
| 12 | 24 |
State,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65 |
| ... | ... | |
| 33 | 45 |
MaximumElevationInMeters,"/specimenreplicate/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72
|
| 34 | 46 |
maximumElevation,"/specimenreplicate/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72
|
| 35 | 47 |
maximumElevationInMeters,"/specimenreplicate/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72
|
| 36 |
DecimalLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
|
|
| 37 |
Latitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81
|
|
| 38 |
VerbatimLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81
|
|
| 39 |
decimalLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
|
|
| 40 |
latitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81
|
|
| 41 |
verbatimLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81
|
|
| 42 |
DecimalLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
|
|
| 43 |
Longitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82
|
|
| 44 |
VerbatimLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82
|
|
| 45 |
decimalLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
|
|
| 46 |
longitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82
|
|
| 47 |
verbatimLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82
|
|
| 48 | 48 |
MaximumDepth,"/specimenreplicate/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75 |
| 49 | 49 |
MaximumDepthInMeters,"/specimenreplicate/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75 |
| 50 | 50 |
maximumDepth,"/specimenreplicate/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75 |
| inputs/XAL/test/import.specimens.xml.ref | ||
|---|---|---|
| 7 | 7 |
<location> |
| 8 | 8 |
<locationdetermination> |
| 9 | 9 |
<coordsaccuracy><_noCV><value><_alt><2>$CoordinatePrecision</2></_alt></value></_noCV></coordsaccuracy> |
| 10 |
<latitude> |
|
| 11 |
<_alt> |
|
| 12 |
<1> |
|
| 13 |
<_nullIf> |
|
| 14 |
<null>0</null> |
|
| 15 |
<type>float</type> |
|
| 16 |
<value>$Latitude</value> |
|
| 17 |
</_nullIf> |
|
| 18 |
</1> |
|
| 19 |
</_alt> |
|
| 20 |
</latitude> |
|
| 21 |
<longitude> |
|
| 22 |
<_alt> |
|
| 23 |
<1> |
|
| 24 |
<_nullIf> |
|
| 25 |
<null>0</null> |
|
| 26 |
<type>float</type> |
|
| 27 |
<value>$Longitude</value> |
|
| 28 |
</_nullIf> |
|
| 29 |
</1> |
|
| 30 |
</_alt> |
|
| 31 |
</longitude> |
|
| 10 | 32 |
<namedplace_id> |
| 11 | 33 |
<_simplifyPath> |
| 12 | 34 |
<next>parent_id/namedplace</next> |
| ... | ... | |
| 37 | 59 |
</path> |
| 38 | 60 |
</_simplifyPath> |
| 39 | 61 |
</namedplace_id> |
| 40 |
<latitude> |
|
| 41 |
<_alt> |
|
| 42 |
<1> |
|
| 43 |
<_nullIf> |
|
| 44 |
<null>0</null> |
|
| 45 |
<type>float</type> |
|
| 46 |
<value>$Latitude</value> |
|
| 47 |
</_nullIf> |
|
| 48 |
</1> |
|
| 49 |
</_alt> |
|
| 50 |
</latitude> |
|
| 51 |
<longitude> |
|
| 52 |
<_alt> |
|
| 53 |
<1> |
|
| 54 |
<_nullIf> |
|
| 55 |
<null>0</null> |
|
| 56 |
<type>float</type> |
|
| 57 |
<value>$Longitude</value> |
|
| 58 |
</_nullIf> |
|
| 59 |
</1> |
|
| 60 |
</_alt> |
|
| 61 |
</longitude> |
|
| 62 | 62 |
</locationdetermination> |
| 63 | 63 |
<locationnarrative><_merge><1>$Locality</1></_merge></locationnarrative> |
| 64 | 64 |
<elevation> |
| ... | ... | |
| 137 | 137 |
</to> |
| 138 | 138 |
</_range> |
| 139 | 139 |
</elevationrange> |
| 140 |
<centerlatitude> |
|
| 141 |
<_alt> |
|
| 142 |
<1> |
|
| 143 |
<_nullIf> |
|
| 144 |
<null>0</null> |
|
| 145 |
<type>float</type> |
|
| 146 |
<value>$Latitude</value> |
|
| 147 |
</_nullIf> |
|
| 148 |
</1> |
|
| 149 |
</_alt> |
|
| 150 |
</centerlatitude> |
|
| 151 |
<centerlongitude> |
|
| 152 |
<_alt> |
|
| 153 |
<1> |
|
| 154 |
<_nullIf> |
|
| 155 |
<null>0</null> |
|
| 156 |
<type>float</type> |
|
| 157 |
<value>$Longitude</value> |
|
| 158 |
</_nullIf> |
|
| 159 |
</1> |
|
| 160 |
</_alt> |
|
| 161 |
</centerlongitude> |
|
| 162 | 140 |
<sourceaccessioncode> |
| 163 | 141 |
<_alt> |
| 164 | 142 |
<2> |
| inputs/XAL/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 1 | 1 |
"XAL[DwC,darwin:]:/content/record/",VegBIEN:,Comments,Order |
| 2 | 2 |
CoordinatePrecision,/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89 |
| 3 |
Latitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,81 |
|
| 4 |
Longitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,82 |
|
| 3 | 5 |
County,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66 |
| 4 | 6 |
StateProvince,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65 |
| 5 | 7 |
Country,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63 |
| ... | ... | |
| 7 | 9 |
Locality,/specimenreplicate/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68 |
| 8 | 10 |
MinimumElevation,"/specimenreplicate/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71
|
| 9 | 11 |
MaximumElevation,"/specimenreplicate/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72
|
| 10 |
Latitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81
|
|
| 11 |
Longitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82
|
|
| 12 | 12 |
MaximumDepth,"/specimenreplicate/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75 |
| 13 | 13 |
MinimumDepth,"/specimenreplicate/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,74 |
| 14 | 14 |
DayCollected,"/specimenreplicate/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44
|
| inputs/NY/test/import.specimens.xml.ref | ||
|---|---|---|
| 8 | 8 |
<locationdetermination> |
| 9 | 9 |
<coordsaccuracy><_noCV><value><_alt><2>$CoordinatePrecision</2></_alt></value></_noCV></coordsaccuracy> |
| 10 | 10 |
<footprintgeometry_dwc>$BoundingBox</footprintgeometry_dwc> |
| 11 |
<latitude> |
|
| 12 |
<_alt> |
|
| 13 |
<1> |
|
| 14 |
<_nullIf> |
|
| 15 |
<null>0</null> |
|
| 16 |
<type>float</type> |
|
| 17 |
<value>$Latitude</value> |
|
| 18 |
</_nullIf> |
|
| 19 |
</1> |
|
| 20 |
</_alt> |
|
| 21 |
</latitude> |
|
| 22 |
<longitude> |
|
| 23 |
<_alt> |
|
| 24 |
<1> |
|
| 25 |
<_nullIf> |
|
| 26 |
<null>0</null> |
|
| 27 |
<type>float</type> |
|
| 28 |
<value>$Longitude</value> |
|
| 29 |
</_nullIf> |
|
| 30 |
</1> |
|
| 31 |
</_alt> |
|
| 32 |
</longitude> |
|
| 11 | 33 |
<namedplace_id> |
| 12 | 34 |
<_simplifyPath> |
| 13 | 35 |
<next>parent_id/namedplace</next> |
| ... | ... | |
| 38 | 60 |
</path> |
| 39 | 61 |
</_simplifyPath> |
| 40 | 62 |
</namedplace_id> |
| 41 |
<latitude> |
|
| 42 |
<_alt> |
|
| 43 |
<1> |
|
| 44 |
<_nullIf> |
|
| 45 |
<null>0</null> |
|
| 46 |
<type>float</type> |
|
| 47 |
<value>$Latitude</value> |
|
| 48 |
</_nullIf> |
|
| 49 |
</1> |
|
| 50 |
</_alt> |
|
| 51 |
</latitude> |
|
| 52 |
<longitude> |
|
| 53 |
<_alt> |
|
| 54 |
<1> |
|
| 55 |
<_nullIf> |
|
| 56 |
<null>0</null> |
|
| 57 |
<type>float</type> |
|
| 58 |
<value>$Longitude</value> |
|
| 59 |
</_nullIf> |
|
| 60 |
</1> |
|
| 61 |
</_alt> |
|
| 62 |
</longitude> |
|
| 63 | 63 |
</locationdetermination> |
| 64 | 64 |
<locationnarrative> |
| 65 | 65 |
<_merge> |
| ... | ... | |
| 179 | 179 |
</to> |
| 180 | 180 |
</_range> |
| 181 | 181 |
</elevationrange> |
| 182 |
<centerlatitude> |
|
| 183 |
<_alt> |
|
| 184 |
<1> |
|
| 185 |
<_nullIf> |
|
| 186 |
<null>0</null> |
|
| 187 |
<type>float</type> |
|
| 188 |
<value>$Latitude</value> |
|
| 189 |
</_nullIf> |
|
| 190 |
</1> |
|
| 191 |
</_alt> |
|
| 192 |
</centerlatitude> |
|
| 193 |
<centerlongitude> |
|
| 194 |
<_alt> |
|
| 195 |
<1> |
|
| 196 |
<_nullIf> |
|
| 197 |
<null>0</null> |
|
| 198 |
<type>float</type> |
|
| 199 |
<value>$Longitude</value> |
|
| 200 |
</_nullIf> |
|
| 201 |
</1> |
|
| 202 |
</_alt> |
|
| 203 |
</centerlongitude> |
|
| 204 | 182 |
<sourceaccessioncode> |
| 205 | 183 |
<_alt> |
| 206 | 184 |
<2> |
| inputs/NY/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 1 | 1 |
NY[DwC],VegBIEN:,Comments,Order |
| 2 | 2 |
CoordinatePrecision,/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89 |
| 3 | 3 |
BoundingBox,/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91 |
| 4 |
Latitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,81 |
|
| 5 |
Longitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,82 |
|
| 4 | 6 |
County,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66 |
| 5 | 7 |
StateProvince,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65 |
| 6 | 8 |
Country,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63 |
| ... | ... | |
| 11 | 13 |
Habitat,"/specimenreplicate/*_id/locationevent/*_id/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52 |
| 12 | 14 |
MinimumElevation,"/specimenreplicate/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value/_nullIf:[null=.]/value",,71
|
| 13 | 15 |
MaximumElevation,"/specimenreplicate/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72
|
| 14 |
Latitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81
|
|
| 15 |
Longitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82
|
|
| 16 | 16 |
MaximumDepth,"/specimenreplicate/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75 |
| 17 | 17 |
MinimumDepth,"/specimenreplicate/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,74 |
| 18 | 18 |
DayCollected,"/specimenreplicate/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44
|
| inputs/Madidi/test/import.plots.xml.ref | ||
|---|---|---|
| 22 | 22 |
</_alt> |
| 23 | 23 |
</elevation> |
| 24 | 24 |
<landform>$Topographical situation</landform> |
| 25 |
<locationdetermination> |
|
| 26 |
<latitude> |
|
| 27 |
<_alt> |
|
| 28 |
<1>$Latitude</1> |
|
| 29 |
<2>$Latitude (DMS)</2> |
|
| 30 |
</_alt> |
|
| 31 |
</latitude> |
|
| 32 |
<longitude> |
|
| 33 |
<_alt> |
|
| 34 |
<1>$Longitude</1> |
|
| 35 |
<2>$Longitude (DMS)</2> |
|
| 36 |
</_alt> |
|
| 37 |
</longitude> |
|
| 38 |
</locationdetermination> |
|
| 25 | 39 |
<locationnarrative>$Locality</locationnarrative> |
| 26 | 40 |
<notespublic>$Observaciones</notespublic> |
| 27 | 41 |
<slopeaspect> |
| ... | ... | |
| 47 | 61 |
</from> |
| 48 | 62 |
</_range> |
| 49 | 63 |
</elevationrange> |
| 50 |
<locationdetermination> |
|
| 51 |
<latitude> |
|
| 52 |
<_alt> |
|
| 53 |
<1>$Latitude</1> |
|
| 54 |
<2>$Latitude (DMS)</2> |
|
| 55 |
</_alt> |
|
| 56 |
</latitude> |
|
| 57 |
<longitude> |
|
| 58 |
<_alt> |
|
| 59 |
<1>$Longitude</1> |
|
| 60 |
<2>$Longitude (DMS)</2> |
|
| 61 |
</_alt> |
|
| 62 |
</longitude> |
|
| 63 |
</locationdetermination> |
|
| 64 |
<centerlatitude> |
|
| 65 |
<_alt> |
|
| 66 |
<1>$Latitude</1> |
|
| 67 |
<2>$Latitude (DMS)</2> |
|
| 68 |
</_alt> |
|
| 69 |
</centerlatitude> |
|
| 70 |
<centerlongitude> |
|
| 71 |
<_alt> |
|
| 72 |
<1>$Longitude</1> |
|
| 73 |
<2>$Longitude (DMS)</2> |
|
| 74 |
</_alt> |
|
| 75 |
</centerlongitude> |
|
| 76 | 64 |
<sourceaccessioncode> |
| 77 | 65 |
<_merge> |
| 78 | 66 |
<2> |
| inputs/Madidi/maps/VegBIEN.plots.csv | ||
|---|---|---|
| 2 | 2 |
Area,/*_id/location/area, |
| 3 | 3 |
Altitude,/*_id/location/elevation/_alt/1, |
| 4 | 4 |
Topographical situation,/*_id/location/landform, |
| 5 |
Latitude,/*_id/location/locationdetermination/latitude/_alt/1, |
|
| 6 |
Latitude (DMS),/*_id/location/locationdetermination/latitude/_alt/2, |
|
| 7 |
Longitude,/*_id/location/locationdetermination/longitude/_alt/1, |
|
| 8 |
Longitude (DMS),/*_id/location/locationdetermination/longitude/_alt/2, |
|
| 5 | 9 |
Locality,/*_id/location/locationnarrative, |
| 6 | 10 |
Observaciones,/*_id/location/notespublic, |
| 7 | 11 |
Direction,/*_id/location/slopeaspect/_compass/value/_alt/1,Part files provide either this field or Direction |
| 8 | 12 |
Orientación/exposicion,/*_id/location/slopeaspect/_compass/value/_alt/2,Part files provide either this field or Orientación |
| 9 | 13 |
Slope,/*_id/location/slopegradient, |
| 10 | 14 |
Minimum altitude,"/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value",
|
| 11 |
Latitude,"/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1",
|
|
| 12 |
Latitude (DMS),"/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2",
|
|
| 13 |
Longitude,"/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1",
|
|
| 14 |
Longitude (DMS),"/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2",
|
|
| 15 | 15 |
Expedition name,/*_id/project/projectname,Consistent (globally unique) between PPM and PT data |
| 16 | 16 |
Expedition number,/*_id/project/sourceaccessioncode,Consistent (globally unique) between PPM and PT data |
| 17 | 17 |
Vegetation type,/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| inputs/ACAD/test/import.specimens.xml.ref | ||
|---|---|---|
| 6 | 6 |
<location_id> |
| 7 | 7 |
<location> |
| 8 | 8 |
<locationdetermination> |
| 9 |
<latitude> |
|
| 10 |
<_alt> |
|
| 11 |
<1> |
|
| 12 |
<_nullIf> |
|
| 13 |
<null>0</null> |
|
| 14 |
<type>float</type> |
|
| 15 |
<value>$decimalLatitude</value> |
|
| 16 |
</_nullIf> |
|
| 17 |
</1> |
|
| 18 |
</_alt> |
|
| 19 |
</latitude> |
|
| 20 |
<longitude> |
|
| 21 |
<_alt> |
|
| 22 |
<1> |
|
| 23 |
<_nullIf> |
|
| 24 |
<null>0</null> |
|
| 25 |
<type>float</type> |
|
| 26 |
<value>$decimalLongitude</value> |
|
| 27 |
</_nullIf> |
|
| 28 |
</1> |
|
| 29 |
</_alt> |
|
| 30 |
</longitude> |
|
| 9 | 31 |
<namedplace_id> |
| 10 | 32 |
<_simplifyPath> |
| 11 | 33 |
<next>parent_id/namedplace</next> |
| ... | ... | |
| 36 | 58 |
</path> |
| 37 | 59 |
</_simplifyPath> |
| 38 | 60 |
</namedplace_id> |
| 39 |
<latitude> |
|
| 40 |
<_alt> |
|
| 41 |
<1> |
|
| 42 |
<_nullIf> |
|
| 43 |
<null>0</null> |
|
| 44 |
<type>float</type> |
|
| 45 |
<value>$decimalLatitude</value> |
|
| 46 |
</_nullIf> |
|
| 47 |
</1> |
|
| 48 |
</_alt> |
|
| 49 |
</latitude> |
|
| 50 |
<longitude> |
|
| 51 |
<_alt> |
|
| 52 |
<1> |
|
| 53 |
<_nullIf> |
|
| 54 |
<null>0</null> |
|
| 55 |
<type>float</type> |
|
| 56 |
<value>$decimalLongitude</value> |
|
| 57 |
</_nullIf> |
|
| 58 |
</1> |
|
| 59 |
</_alt> |
|
| 60 |
</longitude> |
|
| 61 | 61 |
</locationdetermination> |
| 62 | 62 |
<locationnarrative> |
| 63 | 63 |
<_merge> |
| ... | ... | |
| 70 | 70 |
</3> |
| 71 | 71 |
</_merge> |
| 72 | 72 |
</locationnarrative> |
| 73 |
<centerlatitude> |
|
| 74 |
<_alt> |
|
| 75 |
<1> |
|
| 76 |
<_nullIf> |
|
| 77 |
<null>0</null> |
|
| 78 |
<type>float</type> |
|
| 79 |
<value>$decimalLatitude</value> |
|
| 80 |
</_nullIf> |
|
| 81 |
</1> |
|
| 82 |
</_alt> |
|
| 83 |
</centerlatitude> |
|
| 84 |
<centerlongitude> |
|
| 85 |
<_alt> |
|
| 86 |
<1> |
|
| 87 |
<_nullIf> |
|
| 88 |
<null>0</null> |
|
| 89 |
<type>float</type> |
|
| 90 |
<value>$decimalLongitude</value> |
|
| 91 |
</_nullIf> |
|
| 92 |
</1> |
|
| 93 |
</_alt> |
|
| 94 |
</centerlongitude> |
|
| 95 | 73 |
<sourceaccessioncode> |
| 96 | 74 |
<_alt> |
| 97 | 75 |
<2> |
| inputs/ACAD/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 1 | 1 |
ACAD[DwC],VegBIEN:,Comments,Order |
| 2 |
decimalLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,85 |
|
| 3 |
decimalLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,86 |
|
| 2 | 4 |
county,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66 |
| 3 | 5 |
stateProvince,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65 |
| 4 | 6 |
country,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63 |
| 5 | 7 |
continent,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",Brad: OMIT,59 |
| 6 | 8 |
locality,/specimenreplicate/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68 |
| 7 | 9 |
habitat,"/specimenreplicate/*_id/locationevent/*_id/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52 |
| 8 |
decimalLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
|
|
| 9 |
decimalLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
|
|
| 10 | 10 |
eventDate,"/specimenreplicate/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/2",,44
|
| 11 | 11 |
recordNumber,/specimenreplicate/collectionnumber/_alt/1/_alt/2,,22 |
| 12 | 12 |
collectionID,/specimenreplicate/collectionnumber/_alt/2,,9 |
| inputs/CVS/test/import.organisms.xml.ref | ||
|---|---|---|
| 11 | 11 |
<location> |
| 12 | 12 |
<locationdetermination> |
| 13 | 13 |
<coordsaccuracy>$locationAccuracy-m</coordsaccuracy> |
| 14 |
<latitude> |
|
| 15 |
<_alt> |
|
| 16 |
<1>$realLatitude</1> |
|
| 17 |
<2>$publicLatitude</2> |
|
| 18 |
</_alt> |
|
| 19 |
</latitude> |
|
| 20 |
<longitude> |
|
| 21 |
<_alt> |
|
| 22 |
<1>$realLongitude</1> |
|
| 23 |
<2>$publicLongitude</2> |
|
| 24 |
</_alt> |
|
| 25 |
</longitude> |
|
| 14 | 26 |
<namedplace_id> |
| 15 | 27 |
<_simplifyPath> |
| 16 | 28 |
<next>parent_id/namedplace</next> |
| ... | ... | |
| 29 | 41 |
</path> |
| 30 | 42 |
</_simplifyPath> |
| 31 | 43 |
</namedplace_id> |
| 32 |
<latitude> |
|
| 33 |
<_alt> |
|
| 34 |
<1>$realLatitude</1> |
|
| 35 |
<2>$publicLatitude</2> |
|
| 36 |
</_alt> |
|
| 37 |
</latitude> |
|
| 38 |
<longitude> |
|
| 39 |
<_alt> |
|
| 40 |
<1>$realLongitude</1> |
|
| 41 |
<2>$publicLongitude</2> |
|
| 42 |
</_alt> |
|
| 43 |
</longitude> |
|
| 44 | 44 |
</locationdetermination> |
| 45 |
<centerlatitude> |
|
| 46 |
<_alt> |
|
| 47 |
<1>$realLatitude</1> |
|
| 48 |
<2>$publicLatitude</2> |
|
| 49 |
</_alt> |
|
| 50 |
</centerlatitude> |
|
| 51 |
<centerlongitude> |
|
| 52 |
<_alt> |
|
| 53 |
<1>$realLongitude</1> |
|
| 54 |
<2>$publicLongitude</2> |
|
| 55 |
</_alt> |
|
| 56 |
</centerlongitude> |
|
| 57 | 45 |
<sourceaccessioncode><_merge><2><_alt><2>$authorObsCode</2></_alt></2></_merge></sourceaccessioncode> |
| 58 | 46 |
</location> |
| 59 | 47 |
</location_id> |
| inputs/CVS/maps/VegBIEN.organisms.csv | ||
|---|---|---|
| 1 | 1 |
CVS,VegBIEN:/plantobservation,Comments |
| 2 | 2 |
locationAccuracy-m,/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy, |
| 3 |
realLatitude,/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/latitude/_alt/1, |
|
| 4 |
publicLatitude,/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/latitude/_alt/2, |
|
| 5 |
realLongitude,/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/longitude/_alt/1, |
|
| 6 |
publicLongitude,/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/longitude/_alt/2, |
|
| 3 | 7 |
county,"/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename", |
| 4 | 8 |
state,"/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
| 5 |
realLatitude,"/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1",
|
|
| 6 |
publicLatitude,"/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2",
|
|
| 7 |
realLongitude,"/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1",
|
|
| 8 |
publicLongitude,"/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2",
|
|
| 9 | 9 |
obsStartDate,/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_*/date, |
| 10 | 10 |
authorObsCode,"/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/{authorlocationcode,*_id/location/sourceaccessioncode/_merge/2/_alt/2}",
|
| 11 | 11 |
currentTaxonName sec Weakley 2006,"/*_id/aggregateoccurrence/*_id/taxonoccurrence/{taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname/_name/first,sourceaccessioncode/_alt/3}",
|
| inputs/SALVIAS-CSV/test/import.plots.xml.ref | ||
|---|---|---|
| 30 | 30 |
</_alt> |
| 31 | 31 |
</elevation> |
| 32 | 32 |
<locationdetermination> |
| 33 |
<latitude>$lat_decimal</latitude> |
|
| 34 |
<longitude>$long_decimal</longitude> |
|
| 33 | 35 |
<namedplace_id> |
| 34 | 36 |
<_simplifyPath> |
| 35 | 37 |
<next>parent_id/namedplace</next> |
| ... | ... | |
| 60 | 62 |
</path> |
| 61 | 63 |
</_simplifyPath> |
| 62 | 64 |
</namedplace_id> |
| 63 |
<latitude>$lat_decimal</latitude> |
|
| 64 |
<longitude>$long_decimal</longitude> |
|
| 65 | 65 |
</locationdetermination> |
| 66 | 66 |
<locationnarrative>$locality_description</locationnarrative> |
| 67 | 67 |
<slopeaspect><_compass><value>$slope_aspect</value></_compass></slopeaspect> |
| ... | ... | |
| 86 | 86 |
</from> |
| 87 | 87 |
</_range> |
| 88 | 88 |
</elevationrange> |
| 89 |
<centerlatitude>$lat_decimal</centerlatitude> |
|
| 90 |
<centerlongitude>$long_decimal</centerlongitude> |
|
| 91 | 89 |
<sourceaccessioncode> |
| 92 | 90 |
<_merge> |
| 93 | 91 |
<2> |
| inputs/SALVIAS-CSV/maps/VegBIEN.plots.csv | ||
|---|---|---|
| 1 | 1 |
SALVIAS-CSV,VegBIEN:/locationevent,Comments |
| 2 | 2 |
plot_area_ha,/*_id/location/area,"Brad: Area in hectares. Is there any way to store units?; Aaron: VegX plot area annotation says ""Total area of the plot in square meters."" so units are fixed" |
| 3 | 3 |
elev_m,/*_id/location/elevation/_alt/1,Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick. |
| 4 |
lat_decimal,/*_id/location/locationdetermination/latitude, |
|
| 5 |
long_decimal,/*_id/location/locationdetermination/longitude, |
|
| 4 | 6 |
pol2,"/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",Brad: No pol2=countyParish |
| 5 | 7 |
pol1,"/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",Brad: No; pol1=stateProvince |
| 6 | 8 |
country,"/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
| ... | ... | |
| 10 | 12 |
slope_gradient,/*_id/location/slopegradient, |
| 11 | 13 |
elev_max_m,"/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}/_units:[default=m,to=m,to=]/value/_rangeEnd/value",
|
| 12 | 14 |
elev_min_m,"/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value",
|
| 13 |
lat_decimal,"/*_id/location/{locationdetermination/latitude,centerlatitude}",
|
|
| 14 |
long_decimal,"/*_id/location/{locationdetermination/longitude,centerlongitude}",
|
|
| 15 | 15 |
plot_methodology,/*_id/method/name, |
| 16 | 16 |
project,/*_id/project/projectname, |
| 17 | 17 |
holdridge_life_zone,/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| inputs/REMIB/test/import.specimens.xml.ref | ||
|---|---|---|
| 6 | 6 |
<location_id> |
| 7 | 7 |
<location> |
| 8 | 8 |
<locationdetermination> |
| 9 |
<latitude> |
|
| 10 |
<_alt> |
|
| 11 |
<1> |
|
| 12 |
<_nullIf> |
|
| 13 |
<null>0</null> |
|
| 14 |
<type>float</type> |
|
| 15 |
<value>$lat_deg</value> |
|
| 16 |
</_nullIf> |
|
| 17 |
</1> |
|
| 18 |
</_alt> |
|
| 19 |
</latitude> |
|
| 20 |
<longitude> |
|
| 21 |
<_alt> |
|
| 22 |
<1> |
|
| 23 |
<_nullIf> |
|
| 24 |
<null>0</null> |
|
| 25 |
<type>float</type> |
|
| 26 |
<value>$long_deg</value> |
|
| 27 |
</_nullIf> |
|
| 28 |
</1> |
|
| 29 |
</_alt> |
|
| 30 |
</longitude> |
|
| 9 | 31 |
<namedplace_id> |
| 10 | 32 |
<_simplifyPath> |
| 11 | 33 |
<next>parent_id/namedplace</next> |
| ... | ... | |
| 30 | 52 |
</path> |
| 31 | 53 |
</_simplifyPath> |
| 32 | 54 |
</namedplace_id> |
| 33 |
<latitude> |
|
| 34 |
<_alt> |
|
| 35 |
<1> |
|
| 36 |
<_nullIf> |
|
| 37 |
<null>0</null> |
|
| 38 |
<type>float</type> |
|
| 39 |
<value>$lat_deg</value> |
|
| 40 |
</_nullIf> |
|
| 41 |
</1> |
|
| 42 |
</_alt> |
|
| 43 |
</latitude> |
|
| 44 |
<longitude> |
|
| 45 |
<_alt> |
|
| 46 |
<1> |
|
| 47 |
<_nullIf> |
|
| 48 |
<null>0</null> |
|
| 49 |
<type>float</type> |
|
| 50 |
<value>$long_deg</value> |
|
| 51 |
</_nullIf> |
|
| 52 |
</1> |
|
| 53 |
</_alt> |
|
| 54 |
</longitude> |
|
| 55 | 55 |
</locationdetermination> |
| 56 | 56 |
<locationnarrative> |
| 57 | 57 |
<_merge> |
| ... | ... | |
| 64 | 64 |
</3> |
| 65 | 65 |
</_merge> |
| 66 | 66 |
</locationnarrative> |
| 67 |
<centerlatitude> |
|
| 68 |
<_alt> |
|
| 69 |
<1> |
|
| 70 |
<_nullIf> |
|
| 71 |
<null>0</null> |
|
| 72 |
<type>float</type> |
|
| 73 |
<value>$lat_deg</value> |
|
| 74 |
</_nullIf> |
|
| 75 |
</1> |
|
| 76 |
</_alt> |
|
| 77 |
</centerlatitude> |
|
| 78 |
<centerlongitude> |
|
| 79 |
<_alt> |
|
| 80 |
<1> |
|
| 81 |
<_nullIf> |
|
| 82 |
<null>0</null> |
|
| 83 |
<type>float</type> |
|
| 84 |
<value>$long_deg</value> |
|
| 85 |
</_nullIf> |
|
| 86 |
</1> |
|
| 87 |
</_alt> |
|
| 88 |
</centerlongitude> |
|
| 89 | 67 |
<sourceaccessioncode> |
| 90 | 68 |
<_alt> |
| 91 | 69 |
<2><_merge><2>$acronym</2></_merge></2> |
| inputs/REMIB/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 1 | 1 |
REMIB[DwC],VegBIEN:,Comments,Order |
| 2 |
lat_deg,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,81 |
|
| 3 |
long_deg,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,82 |
|
| 2 | 4 |
county,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66 |
| 3 | 5 |
state,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65 |
| 4 | 6 |
country,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63 |
| 5 | 7 |
locality,/specimenreplicate/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68 |
| 6 | 8 |
habitat,"/specimenreplicate/*_id/locationevent/*_id/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52 |
| 7 |
lat_deg,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81
|
|
| 8 |
long_deg,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82
|
|
| 9 | 9 |
coll_day,"/specimenreplicate/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44
|
| 10 | 10 |
coll_month,"/specimenreplicate/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,44
|
| 11 | 11 |
coll_year,"/specimenreplicate/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,44
|
| inputs/CTFS/test/import.organisms.xml.ref | ||
|---|---|---|
| 39 | 39 |
<locationdetermination> |
| 40 | 40 |
<coordsaccuracy>$/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters</coordsaccuracy> |
| 41 | 41 |
<footprintgeometry_dwc>$/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT</footprintgeometry_dwc> |
| 42 |
<latitude>$/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude</latitude> |
|
| 43 |
<longitude>$/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude</longitude> |
|
| 42 | 44 |
<namedplace_id> |
| 43 | 45 |
<_simplifyPath> |
| 44 | 46 |
<next>parent_id/namedplace</next> |
| ... | ... | |
| 69 | 71 |
</path> |
| 70 | 72 |
</_simplifyPath> |
| 71 | 73 |
</namedplace_id> |
| 72 |
<latitude>$/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude</latitude> |
|
| 73 |
<longitude>$/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude</longitude> |
|
| 74 | 74 |
</locationdetermination> |
| 75 | 75 |
<locationnarrative>$/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/locationNarrative</locationnarrative> |
| 76 | 76 |
<notespublic>$/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/note</notespublic> |
| ... | ... | |
| 96 | 96 |
</from> |
| 97 | 97 |
</_range> |
| 98 | 98 |
</elevationrange> |
| 99 |
<centerlatitude>$/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude</centerlatitude> |
|
| 100 |
<centerlongitude>$/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude</centerlongitude> |
|
| 101 | 99 |
<sourceaccessioncode> |
| 102 | 100 |
<_merge> |
| 103 | 101 |
<2> |
| inputs/CTFS/maps/VegBIEN.organisms.csv | ||
|---|---|---|
| 4 | 4 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/landform,/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/landform, |
| 5 | 5 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters,/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy, |
| 6 | 6 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT,/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc, |
| 7 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude,/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/latitude, |
|
| 8 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude,/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/longitude, |
|
| 7 | 9 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/location[placeType=county]/placeName,"/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename", |
| 8 | 10 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/location[placeType=state]/placeName,"/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
| 9 | 11 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/location[placeType=country]/placeName,"/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
| ... | ... | |
| 14 | 16 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeGradient,/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/slopegradient, |
| 15 | 17 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters,"/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}/_units:[default=m,to=m,to=]/value/_rangeEnd/value",
|
| 16 | 18 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters,"/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value",
|
| 17 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude,"/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}",
|
|
| 18 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude,"/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}",
|
|
| 19 | 19 |
/*ID->/*s/plotObservation/simpleUserdefined[name=method]/*ID/method/name,/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/method/name, |
| 20 | 20 |
/*ID->/*s/plotObservation/*ID->/*s/project/title[@id=name],/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/project/projectname, |
| 21 | 21 |
/*ID->/*s/plotObservation/*ID->/*s/project/title[@id=sourceAccessionCode],/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent/*_id/project/sourceaccessioncode, |
| inputs/SALVIAS/test/import.plots.xml.ref | ||
|---|---|---|
| 30 | 30 |
</_alt> |
| 31 | 31 |
</elevation> |
| 32 | 32 |
<locationdetermination> |
| 33 |
<latitude>$LatDec</latitude> |
|
| 34 |
<longitude>$LongDec</longitude> |
|
| 33 | 35 |
<namedplace_id> |
| 34 | 36 |
<_simplifyPath> |
| 35 | 37 |
<next>parent_id/namedplace</next> |
| ... | ... | |
| 60 | 62 |
</path> |
| 61 | 63 |
</_simplifyPath> |
| 62 | 64 |
</namedplace_id> |
| 63 |
<latitude>$LatDec</latitude> |
|
| 64 |
<longitude>$LongDec</longitude> |
|
| 65 | 65 |
</locationdetermination> |
| 66 | 66 |
<locationnarrative>$Locality_Description</locationnarrative> |
| 67 | 67 |
<slopeaspect><_compass><value>$slope_aspect</value></_compass></slopeaspect> |
| ... | ... | |
| 86 | 86 |
</from> |
| 87 | 87 |
</_range> |
| 88 | 88 |
</elevationrange> |
| 89 |
<centerlatitude>$LatDec</centerlatitude> |
|
| 90 |
<centerlongitude>$LongDec</centerlongitude> |
|
| 91 | 89 |
<sourceaccessioncode> |
| 92 | 90 |
<_merge> |
| 93 | 91 |
<2> |
| inputs/SALVIAS/maps/VegBIEN.plots.csv | ||
|---|---|---|
| 1 | 1 |
SALVIAS,VegBIEN:/locationevent,Comments |
| 2 | 2 |
plot_area_ha,/*_id/location/area,"Brad: Area in hectares. Is there any way to store units?; Aaron: VegX plot area annotation says ""Total area of the plot in square meters."" so units are fixed" |
| 3 | 3 |
Elev,/*_id/location/elevation/_alt/1,Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick. |
| 4 |
LatDec,/*_id/location/locationdetermination/latitude, |
|
| 5 |
LongDec,/*_id/location/locationdetermination/longitude, |
|
| 4 | 6 |
pol2,"/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",Brad: No pol2=countyParish |
| 5 | 7 |
PolDiv1,"/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",Brad: No; pol1=stateProvince |
| 6 | 8 |
Country,"/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
| ... | ... | |
| 10 | 12 |
slope_gradient,/*_id/location/slopegradient, |
| 11 | 13 |
elev_max_m,"/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}/_units:[default=m,to=m,to=]/value/_rangeEnd/value",
|
| 12 | 14 |
elev_min_m,"/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value",
|
| 13 |
LatDec,"/*_id/location/{locationdetermination/latitude,centerlatitude}",
|
|
| 14 |
LongDec,"/*_id/location/{locationdetermination/longitude,centerlongitude}",
|
|
| 15 | 15 |
PlotMethod,/*_id/method/name, |
| 16 | 16 |
project_id,/*_id/project/projectname, |
| 17 | 17 |
life_zone_code,/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| inputs/U/test/import.specimens.xml.ref | ||
|---|---|---|
| 6 | 6 |
<location_id> |
| 7 | 7 |
<location> |
| 8 | 8 |
<locationdetermination> |
| 9 |
<latitude> |
|
| 10 |
<_alt> |
|
| 11 |
<1> |
|
| 12 |
<_nullIf> |
|
| 13 |
<null>0</null> |
|
| 14 |
<type>float</type> |
|
| 15 |
<value>$Lat</value> |
|
| 16 |
</_nullIf> |
|
| 17 |
</1> |
|
| 18 |
</_alt> |
|
| 19 |
</latitude> |
|
| 20 |
<longitude> |
|
| 21 |
<_alt> |
|
| 22 |
<1> |
|
| 23 |
<_nullIf> |
|
| 24 |
<null>0</null> |
|
| 25 |
<type>float</type> |
|
| 26 |
<value>$Long</value> |
|
| 27 |
</_nullIf> |
|
| 28 |
</1> |
|
| 29 |
</_alt> |
|
| 30 |
</longitude> |
|
| 9 | 31 |
<namedplace_id> |
| 10 | 32 |
<_simplifyPath> |
| 11 | 33 |
<next>parent_id/namedplace</next> |
| ... | ... | |
| 28 | 50 |
</path> |
| 29 | 51 |
</_simplifyPath> |
| 30 | 52 |
</namedplace_id> |
| 31 |
<latitude> |
|
| 32 |
<_alt> |
|
| 33 |
<1> |
|
| 34 |
<_nullIf> |
|
| 35 |
<null>0</null> |
|
| 36 |
<type>float</type> |
|
| 37 |
<value>$Lat</value> |
|
| 38 |
</_nullIf> |
|
| 39 |
</1> |
|
| 40 |
</_alt> |
|
| 41 |
</latitude> |
|
| 42 |
<longitude> |
|
| 43 |
<_alt> |
|
| 44 |
<1> |
|
| 45 |
<_nullIf> |
|
| 46 |
<null>0</null> |
|
| 47 |
<type>float</type> |
|
| 48 |
<value>$Long</value> |
|
| 49 |
</_nullIf> |
|
| 50 |
</1> |
|
| 51 |
</_alt> |
|
| 52 |
</longitude> |
|
| 53 | 53 |
</locationdetermination> |
| 54 | 54 |
<locationnarrative> |
| 55 | 55 |
<_merge> |
| ... | ... | |
| 77 | 77 |
</3> |
| 78 | 78 |
</_merge> |
| 79 | 79 |
</locationnarrative> |
| 80 |
<centerlatitude> |
|
| 81 |
<_alt> |
|
| 82 |
<1> |
|
| 83 |
<_nullIf> |
|
| 84 |
<null>0</null> |
|
| 85 |
<type>float</type> |
|
| 86 |
<value>$Lat</value> |
|
| 87 |
</_nullIf> |
|
| 88 |
</1> |
|
| 89 |
</_alt> |
|
| 90 |
</centerlatitude> |
|
| 91 |
<centerlongitude> |
|
| 92 |
<_alt> |
|
| 93 |
<1> |
|
| 94 |
<_nullIf> |
|
| 95 |
<null>0</null> |
|
| 96 |
<type>float</type> |
|
| 97 |
<value>$Long</value> |
|
| 98 |
</_nullIf> |
|
| 99 |
</1> |
|
| 100 |
</_alt> |
|
| 101 |
</centerlongitude> |
|
| 102 | 80 |
<sourceaccessioncode> |
| 103 | 81 |
<_alt> |
| 104 | 82 |
<2><_merge><3>$Barcode</3></_merge></2> |
| inputs/U/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 1 | 1 |
U[DwC],VegBIEN:,Comments,Order |
| 2 |
Lat,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,85 |
|
| 3 |
Long,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,86 |
|
| 2 | 4 |
Country,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63 |
| 3 | 5 |
Gazetteer,"/specimenreplicate/*_id/locationevent/*_id/location/locationnarrative/_merge/2/_merge/1/_label[label=""gazetteer""]/value/_merge/1","Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69 |
| 4 | 6 |
Newgazett,"/specimenreplicate/*_id/locationevent/*_id/location/locationnarrative/_merge/2/_merge/1/_label[label=""gazetteer""]/value/_merge/2","Only used in 1 row; Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69 |
| 5 | 7 |
Locnotes,/specimenreplicate/*_id/locationevent/*_id/location/locationnarrative/_merge/2/_merge/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69 |
| 6 | 8 |
Ecology,"/specimenreplicate/*_id/locationevent/*_id/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52 |
| 7 |
Lat,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
|
|
| 8 |
Long,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
|
|
| 9 | 9 |
Colldd,"/specimenreplicate/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44
|
| 10 | 10 |
Collmm,"/specimenreplicate/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,44
|
| 11 | 11 |
Collyy,"/specimenreplicate/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,44
|
| inputs/ARIZ/test/import.specimens.xml.ref | ||
|---|---|---|
| 8 | 8 |
<locationdetermination> |
| 9 | 9 |
<coordsaccuracy><_noCV><value><_alt><1>$CoordinateUncertaintyInMeters</1></_alt></value></_noCV></coordsaccuracy> |
| 10 | 10 |
<footprintgeometry_dwc>$BoundingBox</footprintgeometry_dwc> |
| 11 |
<namedplace_id> |
|
| 12 |
<_simplifyPath> |
|
| 13 |
<next>parent_id/namedplace</next> |
|
| 14 |
<require>placename</require> |
|
| 15 |
<path> |
|
| 16 |
<namedplace> |
|
| 17 |
<rank>county</rank> |
|
| 18 |
<placename>$County</placename> |
|
| 19 |
<parent_id> |
|
| 20 |
<namedplace> |
|
| 21 |
<rank>stateProvince</rank> |
|
| 22 |
<placename>$StateProvince</placename> |
|
| 23 |
<parent_id> |
|
| 24 |
<namedplace> |
|
| 25 |
<rank>country</rank> |
|
| 26 |
<placename>$Country</placename> |
|
| 27 |
<parent_id> |
|
| 28 |
<namedplace> |
|
| 29 |
<rank>continent</rank> |
|
| 30 |
<placename>$ContinentOcean</placename> |
|
| 31 |
</namedplace> |
|
| 32 |
</parent_id> |
|
| 33 |
</namedplace> |
|
| 34 |
</parent_id> |
|
| 35 |
</namedplace> |
|
| 36 |
</parent_id> |
|
| 37 |
</namedplace> |
|
| 38 |
</path> |
|
| 39 |
</_simplifyPath> |
|
| 40 |
</namedplace_id> |
|
| 41 | 11 |
<latitude> |
| 42 | 12 |
<_alt> |
| 43 | 13 |
<1> |
| ... | ... | |
| 70 | 40 |
</1> |
| 71 | 41 |
</_alt> |
| 72 | 42 |
</longitude> |
| 43 |
<namedplace_id> |
|
| 44 |
<_simplifyPath> |
|
| 45 |
<next>parent_id/namedplace</next> |
|
| 46 |
<require>placename</require> |
|
| 47 |
<path> |
|
| 48 |
<namedplace> |
|
| 49 |
<rank>county</rank> |
|
| 50 |
<placename>$County</placename> |
|
| 51 |
<parent_id> |
|
| 52 |
<namedplace> |
|
| 53 |
<rank>stateProvince</rank> |
|
| 54 |
<placename>$StateProvince</placename> |
|
| 55 |
<parent_id> |
|
| 56 |
<namedplace> |
|
| 57 |
<rank>country</rank> |
|
| 58 |
<placename>$Country</placename> |
|
| 59 |
<parent_id> |
|
| 60 |
<namedplace> |
|
| 61 |
<rank>continent</rank> |
|
| 62 |
<placename>$ContinentOcean</placename> |
|
| 63 |
</namedplace> |
|
| 64 |
</parent_id> |
|
| 65 |
</namedplace> |
|
| 66 |
</parent_id> |
|
| 67 |
</namedplace> |
|
| 68 |
</parent_id> |
|
| 69 |
</namedplace> |
|
| 70 |
</path> |
|
| 71 |
</_simplifyPath> |
|
| 72 |
</namedplace_id> |
|
| 73 | 73 |
</locationdetermination> |
| 74 | 74 |
<locationnarrative><_merge><1>$Locality</1></_merge></locationnarrative> |
| 75 | 75 |
<elevation> |
| ... | ... | |
| 148 | 148 |
</to> |
| 149 | 149 |
</_range> |
| 150 | 150 |
</elevationrange> |
| 151 |
<centerlatitude> |
|
| 152 |
<_alt> |
|
| 153 |
<1> |
|
| 154 |
<_nullIf> |
|
| 155 |
<null>0</null> |
|
| 156 |
<type>float</type> |
|
| 157 |
<value> |
|
| 158 |
<_alt> |
|
| 159 |
<0>$DecimalLatitude</0> |
|
| 160 |
<1>$VerbatimLatitude</1> |
|
| 161 |
</_alt> |
|
| 162 |
</value> |
|
| 163 |
</_nullIf> |
|
| 164 |
</1> |
|
| 165 |
</_alt> |
|
| 166 |
</centerlatitude> |
|
| 167 |
<centerlongitude> |
|
| 168 |
<_alt> |
|
| 169 |
<1> |
|
| 170 |
<_nullIf> |
|
| 171 |
<null>0</null> |
|
| 172 |
<type>float</type> |
|
| 173 |
<value> |
|
| 174 |
<_alt> |
|
| 175 |
<0>$DecimalLongitude</0> |
|
| 176 |
<1>$VerbatimLongitude</1> |
|
| 177 |
</_alt> |
|
| 178 |
</value> |
|
| 179 |
</_nullIf> |
|
| 180 |
</1> |
|
| 181 |
</_alt> |
|
| 182 |
</centerlongitude> |
|
| 183 | 151 |
<sourceaccessioncode> |
| 184 | 152 |
<_alt> |
| 185 | 153 |
<2> |
| inputs/ARIZ/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 1 | 1 |
ARIZ[DwC],VegBIEN:,Comments,Order |
| 2 | 2 |
CoordinateUncertaintyInMeters,/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88 |
| 3 | 3 |
BoundingBox,/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91 |
| 4 |
DecimalLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,85 |
|
| 5 |
VerbatimLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,81 |
|
| 6 |
DecimalLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,86 |
|
| 7 |
VerbatimLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,82 |
|
| 4 | 8 |
County,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66 |
| 5 | 9 |
StateProvince,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65 |
| 6 | 10 |
Country,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63 |
| ... | ... | |
| 8 | 12 |
Locality,/specimenreplicate/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68 |
| 9 | 13 |
MinimumElevationInMeters,"/specimenreplicate/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71
|
| 10 | 14 |
MaximumElevationInMeters,"/specimenreplicate/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72
|
| 11 |
DecimalLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
|
|
| 12 |
VerbatimLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81
|
|
| 13 |
DecimalLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
|
|
| 14 |
VerbatimLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82
|
|
| 15 | 15 |
MaximumDepthInMeters,"/specimenreplicate/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75 |
| 16 | 16 |
MinimumDepthInMeters,"/specimenreplicate/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,74 |
| 17 | 17 |
VerbatimCollectingDate,"/specimenreplicate/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/0",Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,44
|
| inputs/GBIF/test/import.specimens.xml.ref | ||
|---|---|---|
| 6 | 6 |
<location_id> |
| 7 | 7 |
<location> |
| 8 | 8 |
<locationdetermination> |
| 9 |
<namedplace_id> |
|
| 10 |
<_simplifyPath> |
|
| 11 |
<next>parent_id/namedplace</next> |
|
| 12 |
<require>placename</require> |
|
| 13 |
<path> |
|
| 14 |
<namedplace> |
|
| 15 |
<rank>county</rank> |
|
| 16 |
<placename>$County</placename> |
|
| 17 |
<parent_id> |
|
| 18 |
<namedplace> |
|
| 19 |
<rank>stateProvince</rank> |
|
| 20 |
<placename>$StateProvince</placename> |
|
| 21 |
<parent_id> |
|
| 22 |
<namedplace> |
|
| 23 |
<rank>country</rank> |
|
| 24 |
<placename>$Country</placename> |
|
| 25 |
</namedplace> |
|
| 26 |
</parent_id> |
|
| 27 |
</namedplace> |
|
| 28 |
</parent_id> |
|
| 29 |
</namedplace> |
|
| 30 |
</path> |
|
| 31 |
</_simplifyPath> |
|
| 32 |
</namedplace_id> |
|
| 33 | 9 |
<latitude> |
| 34 | 10 |
<_alt> |
| 35 | 11 |
<1> |
| ... | ... | |
| 62 | 38 |
</1> |
| 63 | 39 |
</_alt> |
| 64 | 40 |
</longitude> |
| 41 |
<namedplace_id> |
|
| 42 |
<_simplifyPath> |
|
| 43 |
<next>parent_id/namedplace</next> |
|
| 44 |
<require>placename</require> |
|
| 45 |
<path> |
|
| 46 |
<namedplace> |
|
| 47 |
<rank>county</rank> |
|
| 48 |
<placename>$County</placename> |
|
| 49 |
<parent_id> |
|
| 50 |
<namedplace> |
|
| 51 |
<rank>stateProvince</rank> |
|
| 52 |
<placename>$StateProvince</placename> |
|
| 53 |
<parent_id> |
|
| 54 |
<namedplace> |
|
| 55 |
<rank>country</rank> |
|
| 56 |
<placename>$Country</placename> |
|
| 57 |
</namedplace> |
|
| 58 |
</parent_id> |
|
| 59 |
</namedplace> |
|
| 60 |
</parent_id> |
|
| 61 |
</namedplace> |
|
| 62 |
</path> |
|
| 63 |
</_simplifyPath> |
|
| 64 |
</namedplace_id> |
|
| 65 | 65 |
</locationdetermination> |
| 66 | 66 |
<locationnarrative><_merge><1>$Locality</1></_merge></locationnarrative> |
| 67 | 67 |
<elevation> |
| ... | ... | |
| 140 | 140 |
</to> |
| 141 | 141 |
</_range> |
| 142 | 142 |
</elevationrange> |
| 143 |
<centerlatitude> |
|
| 144 |
<_alt> |
|
| 145 |
<1> |
|
| 146 |
<_nullIf> |
|
| 147 |
<null>0</null> |
|
| 148 |
<type>float</type> |
|
| 149 |
<value> |
|
| 150 |
<_alt> |
|
| 151 |
<0>$DecimalLatitude</0> |
|
| 152 |
<1>$VerbatimLatitude</1> |
|
| 153 |
</_alt> |
|
| 154 |
</value> |
|
| 155 |
</_nullIf> |
|
| 156 |
</1> |
|
| 157 |
</_alt> |
|
| 158 |
</centerlatitude> |
|
| 159 |
<centerlongitude> |
|
| 160 |
<_alt> |
|
| 161 |
<1> |
|
| 162 |
<_nullIf> |
|
| 163 |
<null>0</null> |
|
| 164 |
<type>float</type> |
|
| 165 |
<value> |
|
| 166 |
<_alt> |
|
| 167 |
<0>$DecimalLongitude</0> |
|
| 168 |
<1>$VerbatimLongitude</1> |
|
| 169 |
</_alt> |
|
| 170 |
</value> |
|
| 171 |
</_nullIf> |
|
| 172 |
</1> |
|
| 173 |
</_alt> |
|
| 174 |
</centerlongitude> |
|
| 175 | 143 |
<sourceaccessioncode> |
| 176 | 144 |
<_alt> |
| 177 | 145 |
<2> |
| inputs/GBIF/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 1 | 1 |
GBIF[DwC],VegBIEN:,Comments,Order |
| 2 |
DecimalLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,85 |
|
| 3 |
VerbatimLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,81 |
|
| 4 |
DecimalLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,86 |
|
| 5 |
VerbatimLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,82 |
|
| 2 | 6 |
County,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66 |
| 3 | 7 |
StateProvince,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65 |
| 4 | 8 |
Country,"/specimenreplicate/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63 |
| 5 | 9 |
Locality,/specimenreplicate/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68 |
| 6 | 10 |
MinimumElevationInMeter,"/specimenreplicate/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71
|
| 7 | 11 |
MaximumElevationInMeter,"/specimenreplicate/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72
|
| 8 |
DecimalLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
|
|
| 9 |
VerbatimLatitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81
|
|
| 10 |
DecimalLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
|
|
| 11 |
VerbatimLongitude,"/specimenreplicate/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82
|
|
| 12 | 12 |
LatestDateCollected,"/specimenreplicate/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/2",,44
|
| 13 | 13 |
IdentifiedBy,"/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
|
| 14 | 14 |
ScientificName,"/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname","Brad: Bob, Nick, please is this mapping OK?",134 |
| inputs/NCU-NCSC/test/import.specimens.xml.ref | ||
|---|---|---|
| 7 | 7 |
<location> |
| 8 | 8 |
<locationdetermination> |
| 9 | 9 |
<coordsaccuracy><_noCV><value><_alt><1>$Accuracy</1></_alt></value></_noCV></coordsaccuracy> |
| 10 |
<namedplace_id> |
|
| 11 |
<_simplifyPath> |
|
| 12 |
<next>parent_id/namedplace</next> |
|
| 13 |
<require>placename</require> |
|
| 14 |
<path> |
|
| 15 |
<namedplace> |
|
| 16 |
<rank>county</rank> |
|
| 17 |
<placename>$County</placename> |
|
| 18 |
<parent_id> |
|
| 19 |
<namedplace> |
|
| 20 |
<rank>stateProvince</rank> |
|
| 21 |
<placename>$State</placename> |
|
| 22 |
<parent_id> |
|
| 23 |
<namedplace> |
|
| 24 |
<rank>country</rank> |
|
| 25 |
<placename>$Country</placename> |
|
| 26 |
</namedplace> |
|
| 27 |
</parent_id> |
|
| 28 |
</namedplace> |
|
| 29 |
</parent_id> |
|
| 30 |
</namedplace> |
|
| 31 |
</path> |
|
| 32 |
</_simplifyPath> |
|
| 33 |
</namedplace_id> |
|
| 34 | 10 |
<latitude> |
| 35 | 11 |
<_alt> |
| 36 | 12 |
<1> |
| ... | ... | |
| 63 | 39 |
</1> |
| 64 | 40 |
</_alt> |
| 65 | 41 |
</longitude> |
| 42 |
<namedplace_id> |
|
| 43 |
<_simplifyPath> |
|
| 44 |
<next>parent_id/namedplace</next> |
|
| 45 |
<require>placename</require> |
|
| 46 |
<path> |
|
| 47 |
<namedplace> |
|
| 48 |
<rank>county</rank> |
|
| 49 |
<placename>$County</placename> |
|
| 50 |
<parent_id> |
|
| 51 |
<namedplace> |
|
| 52 |
<rank>stateProvince</rank> |
|
| 53 |
<placename>$State</placename> |
|
| 54 |
<parent_id> |
|
| 55 |
<namedplace> |
|
| 56 |
<rank>country</rank> |
|
| 57 |
<placename>$Country</placename> |
|
| 58 |
</namedplace> |
|
| 59 |
</parent_id> |
|
| 60 |
</namedplace> |
|
| 61 |
</parent_id> |
|
| 62 |
</namedplace> |
|
| 63 |
</path> |
|
| 64 |
</_simplifyPath> |
|
| 65 |
</namedplace_id> |
|
| 66 | 66 |
</locationdetermination> |
| 67 |
<centerlatitude> |
|
| 68 |
<_alt> |
|
| 69 |
<1> |
|
| 70 |
<_nullIf> |
|
| 71 |
<null>0</null> |
|
| 72 |
<type>float</type> |
|
| 73 |
<value> |
|
| 74 |
<_replace> |
|
| 75 |
<\?$></\?$> |
|
| 76 |
<value>$Lat (-=S)</value> |
|
| 77 |
</_replace> |
|
| 78 |
</value> |
|
| 79 |
</_nullIf> |
|
| 80 |
</1> |
|
| 81 |
</_alt> |
|
| 82 |
</centerlatitude> |
|
| 83 |
<centerlongitude> |
|
| 84 |
<_alt> |
|
| 85 |
<1> |
|
| 86 |
<_nullIf> |
|
| 87 |
<null>0</null> |
|
| 88 |
<type>float</type> |
|
| 89 |
<value> |
|
| 90 |
<_replace> |
|
| 91 |
<\?$></\?$> |
|
| 92 |
<value>$Long (-=W)</value> |
|
| 93 |
</_replace> |
|
| 94 |
</value> |
|
| 95 |
</_nullIf> |
|
| 96 |
</1> |
|
| 97 |
</_alt> |
|
| 98 |
</centerlongitude> |
|
| 99 | 67 |
<sourceaccessioncode> |
| 100 | 68 |
<_alt> |
| 101 | 69 |
<2> |
Also available in: Unified diff
mappings: location: Removed centerlatitude/centerlongitude mappings because the lat/long should be in only one place: the locationdetermination. It is up to the database querier to decide which locationdetermination(s) to use as the coordinates for a plot/specimen.