Project

General

Profile

« Previous | Next » 

Revision 3841

Added by Aaron Marcuse-Kubitza over 12 years ago

mappings/VegX-VegCSV.stems.csv: Mapped standard DwC terms

View differences:

mappings/VegX-VegCSV.stems.csv
14 14 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/volumeCanopy/value,//*s/individualOrganismObservation/volumeCanopy/value,,,
15 15 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/relativePlotPosition/relativeX,//*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/relativePlotPosition/relativeX,,,
16 16 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/relativePlotPosition/relativeY,//*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/relativePlotPosition/relativeY,,,
17 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/obsEndDate,//*s/plotObservation/obsEndDate,,,
18 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/obsStartDate,//*s/plotObservation/obsStartDate,,,
19 17 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/temperature,//*s/plotObservation/temperature,,,
20 18 
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/groupType",//*s/taxonDetermination[role=collector]/groupType,,,
21 19 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,//abioticObservation/simpleUserdefined[name=acidity]/value,,,
......
30 28 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=silt]/value,//abioticObservation/simpleUserdefined[name=silt]/value,,,
31 29 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value,//abioticObservation/simpleUserdefined[name=sodium]/value,,,
32 30 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,//abioticObservation/simpleUserdefined[name=texture]/value,,,
33 
/*s/plot/geospatial/CoordinateUncertaintyInMeters,//geospatial/CoordinateUncertaintyInMeters,,,
34 
/*s/plot/geospatial/DecimalLatitude,//geospatial/DecimalLatitude,,,
35 
/*s/plot/geospatial/DecimalLongitude,//geospatial/DecimalLongitude,,,
36 
/*s/plot/geospatial/maximumDepthInMeters,//geospatial/maximumDepthInMeters,,,
37 
/*s/plot/geospatial/maximumElevationInMeters,//geospatial/maximumElevationInMeters,,,
38 
/*s/plot/geospatial/minimumDepthInMeters,//geospatial/minimumDepthInMeters,,,
39 
/*s/plot/geospatial/minimumElevationInMeters,//geospatial/minimumElevationInMeters,,,
40 
/*s/plot/geospatial/verbatimElevation,//geospatial/verbatimElevation,,,
41 31 
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/givenName",//individualName/givenName,,,
42 32 
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/partyWithRole/*ID->/parties/party/individualName/surName",//individualName/surName,,,
43 33 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/identificationLabel[@id=1],//individualOrganism/identificationLabel[@id=1],,,
......
58 48 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=height]/value,//individualOrganismObservation/simpleUserdefined[name=height]/value,,,
59 49 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/simpleUserdefined[name=lianaInfestation]/value,//individualOrganismObservation/simpleUserdefined[name=lianaInfestation]/value,,,
60 50 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=sourceAccessionCode]/value,//individualOrganismObservation/simpleUserdefined[name=sourceAccessionCode]/value,,,
61 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text,//note/text,,,
62 51 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/volumeCanopy/*ID->/*s/attribute/ordinal/coverPercent,//ordinal/coverPercent,,,
63 52 
/*s/plot/area,//plot/area,,,
64 53 
/*s/plot/landform,//plot/landform,,,
......
74 63 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=precipitation]/value,//plotObservation/simpleUserdefined[name=precipitation]/value,,,
75 64 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/*ID->/*s/project/title[@id=name],//project/title[@id=name],,,
76 65 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/*ID->/*s/project/title[@id=sourceAccessionCode],//project/title[@id=sourceAccessionCode],,,
77 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/voucher,//taxonNameUsageConcept/voucher,,,
66 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/voucher,catalogNumber,"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",http://rs.tdwg.org/dwc/terms/,20
78 67 
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,!partyWithRole]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=cl])/tcs:Name",class,,http://rs.tdwg.org/dwc/terms/,144
79 68 
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=fam])/tcs:Name",computer.family,,http://rs.tdwg.org/dwc/terms/,146
80 69 
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=gen])/tcs:Name",computer.genus,,http://rs.tdwg.org/dwc/terms/,147
......
83 72 
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=auth])/tcs:Name",computer.scientificNameAuthorship,"Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",http://rs.tdwg.org/dwc/terms/,153
84 73 
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=sp])/tcs:Name",computer.specificEpithet,,http://rs.tdwg.org/dwc/terms/,149
85 74 
/*s/plot/location[placeType=continent]/placeName,continent,Brad: OMIT,http://rs.tdwg.org/dwc/terms/,59
75 
/*s/plot/geospatial/CoordinateUncertaintyInMeters,coordinateUncertaintyInMeters,,http://rs.tdwg.org/dwc/terms/,88
86 76 
/*s/plot/location[placeType=country]/placeName,country,Brad: Required; reject record if this field NULL,http://rs.tdwg.org/dwc/terms/,63
87 77 
/*s/plot/location[placeType=county]/placeName,county,,http://rs.tdwg.org/dwc/terms/,66
78 
/*s/plot/geospatial/DecimalLatitude,decimalLatitude,,http://rs.tdwg.org/dwc/terms/,85
79 
/*s/plot/geospatial/DecimalLongitude,decimalLongitude,,http://rs.tdwg.org/dwc/terms/,86
80 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/obsEndDate,eventDate.end,,http://rs.tdwg.org/dwc/terms/,44
81 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/obsStartDate,eventDate.start,,http://rs.tdwg.org/dwc/terms/,44
88 82 
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,!partyWithRole]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=fam])/tcs:Name",family,,http://rs.tdwg.org/dwc/terms/,146
83 
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text,fieldNotes,,http://rs.tdwg.org/dwc/terms/,54
89 84 
/*s/plot/geospatial/FootprintWKT,footprintWKT,,http://rs.tdwg.org/dwc/terms/,91
90 85 
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,!partyWithRole]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=gen])/tcs:Name",genus,,http://rs.tdwg.org/dwc/terms/,147
91 86 
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,!partyWithRole]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=ssp])/tcs:Name",infraspecificEpithet,,http://rs.tdwg.org/dwc/terms/,150
92 87 
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,!partyWithRole]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=reg])/tcs:Name",kingdom,,http://rs.tdwg.org/dwc/terms/,142
88 
/*s/plot/geospatial/maximumDepthInMeters,maximumDepthInMeters,,http://rs.tdwg.org/dwc/terms/,75
89 
/*s/plot/geospatial/maximumElevationInMeters,maximumElevationInMeters,,http://rs.tdwg.org/dwc/terms/,72
90 
/*s/plot/geospatial/minimumDepthInMeters,minimumDepthInMeters,,http://rs.tdwg.org/dwc/terms/,74
91 
/*s/plot/geospatial/minimumElevationInMeters,minimumElevationInMeters,,http://rs.tdwg.org/dwc/terms/,71
93 92 
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,!partyWithRole]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=ord])/tcs:Name",order,,http://rs.tdwg.org/dwc/terms/,145
94 93 
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,!partyWithRole]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=phyl_div])/tcs:Name",phylum,,http://rs.tdwg.org/dwc/terms/,143
95 94 
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,!partyWithRole]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=binom])/fit",scientificName,"Brad: Bob, Nick, please is this mapping OK?",http://rs.tdwg.org/dwc/terms/,134
......
97 96 
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,!partyWithRole]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=auth])/tcs:Name",scientificNameAuthorship,"Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",http://rs.tdwg.org/dwc/terms/,153
98 97 
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,!partyWithRole]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[tcs:Rank/@code=sp])/tcs:Name",specificEpithet,,http://rs.tdwg.org/dwc/terms/,149
99 98 
/*s/plot/location[placeType=state]/placeName,stateProvince,,http://rs.tdwg.org/dwc/terms/,65
99 
/*s/plot/geospatial/verbatimElevation,verbatimElevation,,http://rs.tdwg.org/dwc/terms/,70
mappings/VegCSV-VegBIEN.specimens.csv
1 1 
VegCSV[DwC],VegBIEN:,Comments,Source,Order
2 2 
//plot/area,/location/area,,,
3 
//geospatial/verbatimElevation,/location/elevation/_alt/1,,,
4 
maximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,72
5 
//geospatial/maximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_rangeEnd/value",,,
6 
//geospatial/minimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value",,,
7 
minimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
8 
//geospatial/minimumElevationInMeters,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value",,,
9 
minimumElevationInMeters,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
10 
maximumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1",,http://rs.tdwg.org/dwc/terms/,72
11 
minimumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",,http://rs.tdwg.org/dwc/terms/,71
12 
//geospatial/maximumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_rangeEnd/value",,,
3 
verbatimElevation,/location/elevation/_alt/1,,http://rs.tdwg.org/dwc/terms/,70
4 
maximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_rangeEnd/value",,http://rs.tdwg.org/dwc/terms/,72
5 
minimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value",,http://rs.tdwg.org/dwc/terms/,71
6 
minimumElevationInMeters,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value",,http://rs.tdwg.org/dwc/terms/,71
7 
maximumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_rangeEnd/value",,http://rs.tdwg.org/dwc/terms/,72
13 8 
//plot/landform,/location/landform,,,
14 
//geospatial/CoordinateUncertaintyInMeters,/location/locationdetermination/coordsaccuracy,,,
15 
coordinateUncertaintyInMeters,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,http://rs.tdwg.org/dwc/terms/,88
9 
coordinateUncertaintyInMeters,/location/locationdetermination/coordsaccuracy,,http://rs.tdwg.org/dwc/terms/,88
16 10 
coordinatePrecision,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,http://rs.tdwg.org/dwc/terms/,89
17 11 
footprintWKT,/location/locationdetermination/footprintgeometry_dwc,,http://rs.tdwg.org/dwc/terms/,91
18 
//geospatial/DecimalLatitude,/location/locationdetermination/latitude,,,
19 
decimalLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,85
12 
decimalLatitude,/location/locationdetermination/latitude,,http://rs.tdwg.org/dwc/terms/,85
20 13 
verbatimLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,81
21 
//geospatial/DecimalLongitude,/location/locationdetermination/longitude,,,
22 
decimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,86
14 
decimalLongitude,/location/locationdetermination/longitude,,http://rs.tdwg.org/dwc/terms/,86
23 15 
verbatimLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/,82
24 16 
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,http://rs.tdwg.org/dwc/terms/,66
25 17 
stateProvince,"/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",,http://rs.tdwg.org/dwc/terms/,65
......
31 23 
//plot/plotName,/location/locationevent/authorlocationcode,,,
32 24 
//*s/communityDetermination/*s/communityConcept/commonName,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,,,
33 25 
//*s/communityDetermination/*s/communityConcept/name,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,,,
34 
//*s/plotObservation/obsEndDate,/location/locationevent/obsenddate,,,
26 
eventDate.end,/location/locationevent/obsenddate,,http://rs.tdwg.org/dwc/terms/,44
35 27 
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value,,http://rs.tdwg.org/dwc/terms/,44
36 
//*s/plotObservation/obsStartDate,/location/locationevent/obsstartdate,,,
28 
eventDate.start,/location/locationevent/obsstartdate,,http://rs.tdwg.org/dwc/terms/,44
37 29 
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,,http://rs.tdwg.org/dwc/terms/,44
38 30 
//plot/plotUniqueIdentifier,/location/locationevent/parent_id/locationevent/*_id/location/sourceaccessioncode/_alt/1,,,
39 31 
//plot/plotName,/location/locationevent/parent_id/locationevent/*_id/location/sourceaccessioncode/_alt/2,,,
......
58 50 
//abioticObservation/simpleUserdefined[name=sodium]/value,/location/locationevent/soilobs/sodium,,,
59 51 
//abioticObservation/simpleUserdefined[name=texture]/value,/location/locationevent/soilobs/texture,,,
60 52 
//plot/plotUniqueIdentifier,/location/locationevent/sourceaccessioncode,,,
61 
catalogNumber,/location/locationevent/specimenreplicate/catalognumber_dwc,"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",http://rs.tdwg.org/dwc/terms/,20
62 53 
collectionCode,/location/locationevent/specimenreplicate/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,http://rs.tdwg.org/dwc/terms/,12
63 54 
recordNumber,/location/locationevent/specimenreplicate/collectionnumber/_alt/1,,http://rs.tdwg.org/dwc/terms/,22
64 55 
collectionID,/location/locationevent/specimenreplicate/collectionnumber/_alt/2,,http://rs.tdwg.org/dwc/terms/,9
65 56 
fieldNumber,/location/locationevent/specimenreplicate/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",http://rs.tdwg.org/dwc/terms/,53
66 57 
sex,"/location/locationevent/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",http://rs.tdwg.org/dwc/terms/,26
67 
fieldNotes,/location/locationevent/specimenreplicate/description/_merge/1,,http://rs.tdwg.org/dwc/terms/,54
68 58 
taxonRemarks,/location/locationevent/specimenreplicate/description/_merge/2,,http://rs.tdwg.org/dwc/terms/,158
69 59 
establishmentMeans,"/location/locationevent/specimenreplicate/growthform/_map:[./{tree,shrub,liana,vine,herb,hemiepiphyte,epiphyte,grass,forb,moss,lichen,fungus,""floating aquatic"",""submerged aquatic""}=*,*=]/value",,http://rs.tdwg.org/dwc/terms/,30
70 60 
institutionCode,/location/locationevent/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/,11
......
77 67 
identifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/surname/_namePart/last,Brad: Bob: does this look correct for VegBank?,http://rs.tdwg.org/dwc/terms/,119
78 68 
recordedBy,/location/locationevent/specimenreplicate/verbatimcollectorname,,http://rs.tdwg.org/dwc/terms/,23
79 69 
//*s/taxonDetermination[role=collector]/groupType,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/cond/_eq:[right=direct]/left,,,
80 
//taxonNameUsageConcept/voucher,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/catalognumber_dwc,,,
70 
catalogNumber,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/catalognumber_dwc,"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",http://rs.tdwg.org/dwc/terms/,20
81 71 
//individualOrganismObservation/simpleUserdefined[name=collectionDate]/value,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/collectiondate,,,
82 
//taxonNameUsageConcept/voucher,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/catalognumber_dwc,,,
72 
catalogNumber,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/catalognumber_dwc,"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",http://rs.tdwg.org/dwc/terms/,20
83 73 
//individualOrganismObservation/simpleUserdefined[name=collectionDate]/value,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/collectiondate,,,
84 74 
//*s/aggregateOrganismObservation/*/aggregateValue/value,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,,,
85 75 
//ordinal/coverPercent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover,,,
......
95 85 
//individualOrganismObservation/simpleUserdefined[name=canopyPosition]/value,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyPosition]]:[@fkey=tablerecord_id]/definedvalue",,,
96 86 
//individualOrganismObservation/diameterBaseDistance[baseDistance[*ID/*s/attribute/quantitative/*ID/*s/method(/name=Gentry)]/value=1.37]/diameter,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=gentryDiameter]]:[@fkey=tablerecord_id]/definedvalue",,,
97 87 
//individualOrganismObservation/simpleUserdefined[name=lianaInfestation]/value,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=lianaInfestation]]:[@fkey=tablerecord_id]/definedvalue",,,
98 
//note/text,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=notes]]:[@fkey=tablerecord_id]/definedvalue",,,
88 
fieldNotes,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=notes]]:[@fkey=tablerecord_id]/definedvalue",,http://rs.tdwg.org/dwc/terms/,54
99 89 
//individualOrganismObservation/diameterBaseDistance[baseDistance[]/value=1.37]/diameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight,,,
100 90 
//individualOrganismObservation/simpleUserdefined[name=height]/value,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height,,,
101 91 
//individualOrganismObservation/simpleUserdefined[name=heightFirstBranch]/value,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/heightfirstbranch,,,
......
130 120 
//individualName/givenName,/location/locationevent/taxonoccurrence/verbatimcollectorname/_name/first,,,
131 121 
//individualName/surName,/location/locationevent/taxonoccurrence/verbatimcollectorname/_name/last,,,
132 122 
//*s/plotObservation/temperature,/location/locationevent/temperature,,,
133 
//geospatial/maximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,,
134 123 
maximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,75
135 
//geospatial/minimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,,
136 124 
minimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/,74
137 125 
//plot/locationNarrative,/location/locationnarrative,,,
138 126 
locality,/location/locationnarrative/_merge/1,,http://rs.tdwg.org/dwc/terms/,68
......
144 132 
occurrenceID,/location/sourceaccessioncode/_alt/1,"Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",http://rs.tdwg.org/dwc/terms/,19
145 133 
institutionCode,/location/sourceaccessioncode/_alt/2/_merge/1,,http://rs.tdwg.org/dwc/terms/,11
146 134 
collectionCode,/location/sourceaccessioncode/_alt/2/_merge/2,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,http://rs.tdwg.org/dwc/terms/,12
147 
catalogNumber,/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",http://rs.tdwg.org/dwc/terms/,20
148 135 
//plot/plotUniqueIdentifier,/location/sourceaccessioncode/_merge/1/_alt/1,,,
149 136 
//plot/plotName,/location/sourceaccessioncode/_merge/1/_alt/2,,,
150 137 
//plot/plotUniqueIdentifier,/location/sourceaccessioncode/_merge/2/_alt/1,,,
......
274 261 
verbatimCoordinateSystem,,,http://rs.tdwg.org/dwc/terms/,83
275 262 
verbatimCoordinates,,,http://rs.tdwg.org/dwc/terms/,80
276 263 
verbatimDepth,,,http://rs.tdwg.org/dwc/terms/,73
277 
verbatimElevation,,,http://rs.tdwg.org/dwc/terms/,70
278 264 
verbatimEventDate,,,http://rs.tdwg.org/dwc/terms/,51
279 265 
verbatimSRS,,,http://rs.tdwg.org/dwc/terms/,84
280 266 
verbatimTaxonRank,,,http://rs.tdwg.org/dwc/terms/,152
mappings/VegCSV.self.specimens.csv
13 13 
//*s/individualOrganismObservation/volumeCanopy/value,//*s/individualOrganismObservation/volumeCanopy/value
14 14 
//*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/relativePlotPosition/relativeX,//*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/relativePlotPosition/relativeX
15 15 
//*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/relativePlotPosition/relativeY,//*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/relativePlotPosition/relativeY
16 
//*s/plotObservation/obsEndDate,//*s/plotObservation/obsEndDate
17 
//*s/plotObservation/obsStartDate,//*s/plotObservation/obsStartDate
18 16 
//*s/plotObservation/temperature,//*s/plotObservation/temperature
19 17 
//*s/taxonDetermination[role=collector]/groupType,//*s/taxonDetermination[role=collector]/groupType
20 18 
//abioticObservation/simpleUserdefined[name=acidity]/value,//abioticObservation/simpleUserdefined[name=acidity]/value
......
29 27 
//abioticObservation/simpleUserdefined[name=silt]/value,//abioticObservation/simpleUserdefined[name=silt]/value
30 28 
//abioticObservation/simpleUserdefined[name=sodium]/value,//abioticObservation/simpleUserdefined[name=sodium]/value
31 29 
//abioticObservation/simpleUserdefined[name=texture]/value,//abioticObservation/simpleUserdefined[name=texture]/value
32 
//geospatial/CoordinateUncertaintyInMeters,//geospatial/CoordinateUncertaintyInMeters
33 
//geospatial/DecimalLatitude,//geospatial/DecimalLatitude
34 
//geospatial/DecimalLongitude,//geospatial/DecimalLongitude
35 
//geospatial/maximumDepthInMeters,//geospatial/maximumDepthInMeters
36 
//geospatial/maximumElevationInMeters,//geospatial/maximumElevationInMeters
37 
//geospatial/minimumDepthInMeters,//geospatial/minimumDepthInMeters
38 
//geospatial/minimumElevationInMeters,//geospatial/minimumElevationInMeters
39 
//geospatial/verbatimElevation,//geospatial/verbatimElevation
40 30 
//individualName/givenName,//individualName/givenName
41 31 
//individualName/surName,//individualName/surName
42 32 
//individualOrganism/identificationLabel[@id=1],//individualOrganism/identificationLabel[@id=1]
......
54 44 
//individualOrganismObservation/simpleUserdefined[name=height]/value,//individualOrganismObservation/simpleUserdefined[name=height]/value
55 45 
//individualOrganismObservation/simpleUserdefined[name=lianaInfestation]/value,//individualOrganismObservation/simpleUserdefined[name=lianaInfestation]/value
56 46 
//individualOrganismObservation/simpleUserdefined[name=sourceAccessionCode]/value,//individualOrganismObservation/simpleUserdefined[name=sourceAccessionCode]/value
57 
//note/text,//note/text
58 47 
//ordinal/coverPercent,//ordinal/coverPercent
59 48 
//plot/area,//plot/area
60 49 
//plot/landform,//plot/landform
......
68 57 
//plotObservation/simpleUserdefined[name=precipitation]/value,//plotObservation/simpleUserdefined[name=precipitation]/value
69 58 
//project/title[@id=name],//project/title[@id=name]
70 59 
//project/title[@id=sourceAccessionCode],//project/title[@id=sourceAccessionCode]
71 
//taxonNameUsageConcept/voucher,//taxonNameUsageConcept/voucher
72 60 
acceptedNameUsage,acceptedNameUsage
73 61 
acceptedNameUsageID,acceptedNameUsageID
74 62 
associatedMedia,associatedMedia
......
119 107 
endDayOfYear,endDayOfYear
120 108 
establishmentMeans,establishmentMeans
121 109 
eventDate,eventDate
110 
eventDate.end,eventDate.end
111 
eventDate.start,eventDate.start
122 112 
eventID,eventID
123 113 
eventRemarks,eventRemarks
124 114 
eventTime,eventTime

Also available in: Unified diff