Project

General

Profile

« Previous | Next » 

Revision 3811

review: Remove XML functions. This should increase the number of matches between human-readable VegBIEN XPaths of VegX and DwC2.

View differences:

bin/review
28 28
    # Leave enough to include the table of a user-defined value
29 29
    xpath, n = re.subn(r'^(?:/(?!_)[\w*]+)*(?=(?:/(?!_)[\w*]+){2}(?:\[|/_|$))',
30 30
        r'', xpath)
31
    # Prepend / to show truncation
32 31
    if n > 0: truncated = True
33 32
    
33
    # Remove XML functions
34
    xpath = re.sub(r'/_\w+/\w+', r'', xpath)
35
    
34 36
    # Remove backward (child-to-parent) pointer's target ID attr
35 37
    xpath = re.sub(r'\[[\w*]+\]|(?<=\[)[\w*]+,', r'', xpath)
36 38
    
mappings/for_review/VegX-VegBIEN.stems.csv
1 1
VegX:,VegBIEN:,Comments
2 2
/*s/plot/area,//location/area,
3
/*s/plot/geospatial/verbatimElevation,//location/elevation/_alt/1,
4
/*s/plot/geospatial/maximumElevationInMeters,//location/elevation/_alt/2/_avg/max/_units/value/_rangeEnd/value,
5
/*s/plot/geospatial/minimumElevationInMeters,//location/elevation/_alt/2/_avg/min/_units/value/_rangeStart/value,
6
/*s/plot/geospatial/minimumElevationInMeters,//location/elevationrange/_range/from/_units/value/_rangeStart/value,
7
/*s/plot/geospatial/maximumElevationInMeters,//location/elevationrange/_range/to/_units/value/_rangeEnd/value,
3
/*s/plot/geospatial/verbatimElevation,//location/elevation,
4
/*s/plot/geospatial/maximumElevationInMeters,//location/elevation,
5
/*s/plot/geospatial/minimumElevationInMeters,//location/elevation,
6
/*s/plot/geospatial/minimumElevationInMeters,//location/elevationrange,
7
/*s/plot/geospatial/maximumElevationInMeters,//location/elevationrange,
8 8
/*s/plot/landform,//location/landform,
9 9
/*s/plot/geospatial/CoordinateUncertaintyInMeters,//locationdetermination/coordsaccuracy,
10 10
/*s/plot/geospatial/FootprintWKT,//locationdetermination/footprintgeometry_dwc,
11 11
/*s/plot/geospatial/DecimalLatitude,//locationdetermination/latitude,
12 12
/*s/plot/geospatial/DecimalLongitude,//locationdetermination/longitude,
13
/*s/plot/location[placeType=county]/placeName,"//locationdetermination/namedplace_id/_simplifyPath/path/_forEach:[do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
14
/*s/plot/location[placeType=state]/placeName,"//locationdetermination/namedplace_id/_simplifyPath/path/_forEach:[do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
15
/*s/plot/location[placeType=country]/placeName,"//locationdetermination/namedplace_id/_simplifyPath/path/_forEach:[do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
16
/*s/plot/location[placeType=continent]/placeName,"//locationdetermination/namedplace_id/_simplifyPath/path/_forEach:[do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
13
/*s/plot/location[placeType=county]/placeName,"//locationdetermination/namedplace_id/_forEach:[do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
14
/*s/plot/location[placeType=state]/placeName,"//locationdetermination/namedplace_id/_forEach:[do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
15
/*s/plot/location[placeType=country]/placeName,"//locationdetermination/namedplace_id/_forEach:[do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
16
/*s/plot/location[placeType=continent]/placeName,"//locationdetermination/namedplace_id/_forEach:[do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
17 17
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=method]/*ID/method/name,//method/name,
18 18
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/*ID->/*s/project/title[@id=name],//project/projectname,
19 19
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/*ID->/*s/project/title[@id=sourceAccessionCode],//project/sourceaccessioncode,
......
22 22
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/communityDetermination[*ID]/*s/communityConcept/name,//commconcept/commdescription,
23 23
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/obsEndDate,//locationevent/obsenddate,
24 24
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/obsStartDate,//locationevent/obsstartdate,
25
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,//location/sourceaccessioncode/_alt/1,
26
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,//location/sourceaccessioncode/_alt/2,
25
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,//location/sourceaccessioncode,
26
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,//location/sourceaccessioncode,
27 27
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,//locationevent/authorlocationcode,
28 28
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,//locationevent/sourceaccessioncode,
29 29
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=precipitation]/value,//locationevent/precipitation,
......
45 45
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value,//soilobs/sodium,
46 46
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,//soilobs/texture,
47 47
/*s/plot/plotUniqueIdentifier,//locationevent/sourceaccessioncode,
48
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/groupType",//locationevent/taxonoccurrence/_if/cond/_eq/left,
49
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/voucher,//locationevent/taxonoccurrence/_if/else/voucher/*_id/specimenreplicate/catalognumber_dwc,
50
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=collectionDate]/value,//locationevent/taxonoccurrence/_if/else/voucher/*_id/specimenreplicate/collectiondate,
51
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/voucher,//locationevent/taxonoccurrence/_if/then/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,
52
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=collectionDate]/value,//locationevent/taxonoccurrence/_if/then/aggregateoccurrence/plantobservation/specimenreplicate/collectiondate,
48
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/groupType",//locationevent/taxonoccurrence,
49
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/voucher,//locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc,
50
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=collectionDate]/value,//locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectiondate,
51
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/voucher,//locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,
52
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=collectionDate]/value,//locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectiondate,
53 53
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/aggregateOrganismObservation[*ID]/*/aggregateValue/value,//aggregateoccurrence/count,
54 54
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/volumeCanopy/*ID->/*s/attribute/ordinal/coverPercent,//aggregateoccurrence/cover,
55 55
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=censusNo]/value,"//aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]/definedvalue",
......
68 68
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/diameterBaseDistance[baseDistance[!attributeID]/value=1.37]/diameter,//stemobservation/diameterbreastheight,
69 69
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/simpleUserdefined[name=height]/value,//stemobservation/height,
70 70
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/simpleUserdefined[name=heightFirstBranch]/value,//stemobservation/heightfirstbranch,
71
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/identificationLabel[@id=1],"//stemobservation/stemtag[""""/2=true]/tag",Quotes sort it before tag2
72
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/identificationLabel[@id=1],"//stemobservation/stemtag[""""/2=true]/tag",Quotes sort it before tag2
73
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/identificationLabel[@id=2],//stemobservation/stemtag[iscurrent=true]:[../stemtag?[2=true]/1=false]/tag,
74
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/identificationLabel[@id=2],//stemobservation/stemtag[iscurrent=true]:[../stemtag?[2=true]/1=false]/tag,
71
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/identificationLabel[@id=1],"//stemobservation/stemtag[""""/iscurrent=true]/tag",Quotes sort it before tag2
72
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/identificationLabel[@id=1],"//stemobservation/stemtag[""""/iscurrent=true]/tag",Quotes sort it before tag2
73
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/*ID->/*s/individualOrganism/identificationLabel[@id=2],//stemobservation/stemtag[iscurrent=true]:[../stemtag?[iscurrent=true]/iscurrent=false]/tag,
74
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/identificationLabel[@id=2],//stemobservation/stemtag[iscurrent=true]:[../stemtag?[iscurrent=true]/iscurrent=false]/tag,
75 75
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/relativePlotPosition/relativeX,//stemobservation/xposition,
76 76
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/relativePlotPosition/relativeX,//stemobservation/xposition,
77 77
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/relativePlotPosition/relativeY,//stemobservation/yposition,
78 78
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/relativePlotPosition/relativeY,//stemobservation/yposition,
79 79
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=growthForm]/value,//taxonoccurrence/growthform,
80
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=sourceAccessionCode]/value,//taxonoccurrence/sourceaccessioncode/_alt/1,"""{"" sorts it with other _if:[name=specimenreplicate_via]s"
81
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=authorPlantCode]/value,//taxonoccurrence/sourceaccessioncode/_alt/2,"""{"" sorts it with other _if:[name=specimenreplicate_via]s"
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=binom])/tcs:Name",//taxonoccurrence/sourceaccessioncode/_alt/3,
83
"/*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=TaxonomicRankBelowSubspeciesEnum])/tcs:Rank","//taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/first",
84
"/*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","//taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname",
85
"/*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=TaxonomicRankBelowSubspeciesEnum])/tcs:Name","//taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
86
"/*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","//taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
87
"/*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","//taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
88
"/*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","//taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
89
"/*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","//taxonoccurrence/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname/_name/last",
90
"/*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","//taxonoccurrence/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",
80
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=sourceAccessionCode]/value,//taxonoccurrence/sourceaccessioncode,"""{"" sorts it with other _if:[name=specimenreplicate_via]s"
81
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=authorPlantCode]/value,//taxonoccurrence/sourceaccessioncode,"""{"" sorts it with other _if:[name=specimenreplicate_via]s"
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=binom])/tcs:Name",//taxonoccurrence/sourceaccessioncode,
83
"/*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=TaxonomicRankBelowSubspeciesEnum])/tcs:Rank","//taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",
84
"/*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","//taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname",
85
"/*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=TaxonomicRankBelowSubspeciesEnum])/tcs:Name","//taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",
86
"/*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","//taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
87
"/*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","//taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
88
"/*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","//taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
89
"/*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","//taxonoccurrence/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",
90
"/*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","//taxonoccurrence/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",
91 91
"/*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",//taxonoccurrence/taxondetermination[role=identifier]/taxonfit,
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=binom])/tcs:Name","//taxonoccurrence/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname/_name/first",
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=auth])/tcs:Name","//taxonoccurrence/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname",
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=sp])/tcs:Name","//taxonoccurrence/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
95
"/*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","//taxonoccurrence/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
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=fam])/tcs:Name","//taxonoccurrence/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
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=ord])/tcs:Name","//taxonoccurrence/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",
98
"/*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","//taxonoccurrence/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",
99
"/*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","//taxonoccurrence/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",
100
"/*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","//taxonoccurrence/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",
101
"/*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",//taxonoccurrence/verbatimcollectorname/_name/first,
102
"/*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",//taxonoccurrence/verbatimcollectorname/_name/last,
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=binom])/tcs:Name","//taxonoccurrence/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",
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=auth])/tcs:Name","//taxonoccurrence/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname",
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=sp])/tcs:Name","//taxonoccurrence/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
95
"/*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","//taxonoccurrence/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
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=fam])/tcs:Name","//taxonoccurrence/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
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=ord])/tcs:Name","//taxonoccurrence/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",
98
"/*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","//taxonoccurrence/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",
99
"/*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","//taxonoccurrence/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",
100
"/*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","//taxonoccurrence/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",
101
"/*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",//taxonoccurrence/verbatimcollectorname,
102
"/*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",//taxonoccurrence/verbatimcollectorname,
103 103
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/temperature,//locationevent/temperature,
104
/*s/plot/geospatial/maximumDepthInMeters,//locationevent/waterdepth/_avg/max/_units/value,
105
/*s/plot/geospatial/minimumDepthInMeters,//locationevent/waterdepth/_avg/min/_units/value,
104
/*s/plot/geospatial/maximumDepthInMeters,//locationevent/waterdepth,
105
/*s/plot/geospatial/minimumDepthInMeters,//locationevent/waterdepth,
106 106
/*s/plot/locationNarrative,//location/locationnarrative,
107 107
/*s/plot/note,//location/notespublic,
108
/*s/plot/slopeAspect,//location/slopeaspect/_compass/value,
108
/*s/plot/slopeAspect,//location/slopeaspect,
109 109
/*s/plot/slopeGradient,//location/slopegradient,
110
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,//location/sourceaccessioncode/_merge/1/_alt/1,
111
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,//location/sourceaccessioncode/_merge/1/_alt/2,
112
/*s/plot/plotUniqueIdentifier,//location/sourceaccessioncode/_merge/2/_alt/1,
113
/*s/plot/plotName,//location/sourceaccessioncode/_merge/2/_alt/2,
110
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,//location/sourceaccessioncode,
111
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]/simpleUserdefined[name=parent]/value->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotName,//location/sourceaccessioncode,
112
/*s/plot/plotUniqueIdentifier,//location/sourceaccessioncode,
113
/*s/plot/plotName,//location/sourceaccessioncode,
mappings/for_review/DwC2-VegBIEN.specimens.csv
1 1
DwC,VegBIEN:,Comments,Order
2
maximumElevationInMeters,//location/elevation/_alt/2/_avg/max/_units/value,,72
3
minimumElevationInMeters,"//location/elevation/_alt/2/_avg/min/_units/value/_rangeStart/value/_replace[""\bca\.?""=]/value",,71
4
minimumElevationInMeters,"//location/elevationrange/_range/from/_units/value/_rangeStart/value/_replace[""\bca\.?""=]/value",,71
5
maximumElevationInMeters,//location/elevationrange/_range/to/_units/value/_alt/1,,72
6
minimumElevationInMeters,"//location/elevationrange/_range/to/_units/value/_alt/2/_rangeEnd/value/_replace[""\bca\.?""=]/value",,71
7
coordinateUncertaintyInMeters,//locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88
8
coordinatePrecision,//locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89
2
maximumElevationInMeters,//location/elevation,,72
3
minimumElevationInMeters,"//location/elevation/_replace[""\bca\.?""=]/value",,71
4
minimumElevationInMeters,"//location/elevationrange/_replace[""\bca\.?""=]/value",,71
5
maximumElevationInMeters,//location/elevationrange,,72
6
minimumElevationInMeters,"//location/elevationrange/_replace[""\bca\.?""=]/value",,71
7
coordinateUncertaintyInMeters,//locationdetermination/coordsaccuracy,,88
8
coordinatePrecision,//locationdetermination/coordsaccuracy,,89
9 9
footprintWKT,//locationdetermination/footprintgeometry_dwc,,91
10
decimalLatitude,//locationdetermination/latitude/_alt/1/_nullIf/value,,85
11
verbatimLatitude,//locationdetermination/latitude/_alt/1/_nullIf/value,,81
12
decimalLongitude,//locationdetermination/longitude/_alt/1/_nullIf/value,,86
13
verbatimLongitude,//locationdetermination/longitude/_alt/1/_nullIf/value,,82
14
county,"//locationdetermination/namedplace_id/_simplifyPath/path/_forEach:[do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66
15
stateProvince,"//locationdetermination/namedplace_id/_simplifyPath/path/_forEach:[do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65
16
country,"//locationdetermination/namedplace_id/_simplifyPath/path/_forEach:[do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63
17
continent,"//locationdetermination/namedplace_id/_simplifyPath/path/_forEach:[do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",Brad: OMIT,59
18
eventDate,//locationevent/obsenddate/_*/date/_dateRangeEnd/value,,44
19
eventDate,//locationevent/obsstartdate/_*/date/_dateRangeStart/value,,44
10
decimalLatitude,//locationdetermination/latitude,,85
11
verbatimLatitude,//locationdetermination/latitude,,81
12
decimalLongitude,//locationdetermination/longitude,,86
13
verbatimLongitude,//locationdetermination/longitude,,82
14
county,"//locationdetermination/namedplace_id/_forEach:[do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66
15
stateProvince,"//locationdetermination/namedplace_id/_forEach:[do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65
16
country,"//locationdetermination/namedplace_id/_forEach:[do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63
17
continent,"//locationdetermination/namedplace_id/_forEach:[do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",Brad: OMIT,59
18
eventDate,//locationevent/obsenddate/_*/date,,44
19
eventDate,//locationevent/obsstartdate/_*/date,,44
20 20
catalogNumber,//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",20
21 21
collectionCode,//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,12
22
recordNumber,//specimenreplicate/collectionnumber/_alt/1,,22
23
collectionID,//specimenreplicate/collectionnumber/_alt/2,,9
24
fieldNumber,//specimenreplicate/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53
22
recordNumber,//specimenreplicate/collectionnumber,,22
23
collectionID,//specimenreplicate/collectionnumber,,9
24
fieldNumber,//specimenreplicate/collectionnumber,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53
25 25
sex,"//specimenreplicate/definedvalue[*_id/userdefined[tablename=specimenreplicate,userdefinedname=sex]]/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
26
fieldNotes,//specimenreplicate/description/_merge/1,,
27
taxonRemarks,//specimenreplicate/description/_merge/2,,158
28
establishmentMeans,//specimenreplicate/growthform/_map/value,,30
26
fieldNotes,//specimenreplicate/description,,
27
taxonRemarks,//specimenreplicate/description,,158
28
establishmentMeans,//specimenreplicate/growthform,,30
29 29
institutionCode,//party/organizationname,,
30
establishmentMeans,//specimenreplicate/iscultivated/_map/value,,30
31
establishmentMeans,//specimenreplicate/isnative/_map/value,,30
30
establishmentMeans,//specimenreplicate/iscultivated,,30
31
establishmentMeans,//specimenreplicate/isnative,,30
32 32
occurrenceID,//specimenreplicate/sourceaccessioncode,"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",19
33
dateIdentified,//specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value,,120
34
identifiedBy,//specimenreplicate/taxondetermination[role=identifier]/*_id/party/givenname/_namePart/first,Brad: Bob: does this look correct for VegBank?,119
35
identifiedBy,//specimenreplicate/taxondetermination[role=identifier]/*_id/party/middlename/_namePart/middle,Brad: Bob: does this look correct for VegBank?,119
36
identifiedBy,//specimenreplicate/taxondetermination[role=identifier]/*_id/party/surname/_namePart/last,Brad: Bob: does this look correct for VegBank?,119
37
scientificName,"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname","Brad: Bob, Nick, please is this mapping OK?",134
38
scientificNameAuthorship,"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","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",153
39
infraspecificEpithet,"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150
40
specificEpithet,"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149
41
genus,"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,147
42
family,"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,146
43
order,"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,145
44
class,"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,144
45
phylum,"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,143
46
kingdom,"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,142
33
dateIdentified,//specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date,,120
34
identifiedBy,//specimenreplicate/taxondetermination[role=identifier]/*_id/party/givenname,Brad: Bob: does this look correct for VegBank?,119
35
identifiedBy,//specimenreplicate/taxondetermination[role=identifier]/*_id/party/middlename,Brad: Bob: does this look correct for VegBank?,119
36
identifiedBy,//specimenreplicate/taxondetermination[role=identifier]/*_id/party/surname,Brad: Bob: does this look correct for VegBank?,119
37
scientificName,"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname","Brad: Bob, Nick, please is this mapping OK?",134
38
scientificNameAuthorship,"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","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",153
39
infraspecificEpithet,"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150
40
specificEpithet,"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149
41
genus,"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,147
42
family,"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,146
43
order,"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,145
44
class,"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,144
45
phylum,"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,143
46
kingdom,"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,142
47 47
recordedBy,//specimenreplicate/verbatimcollectorname,,23
48
maximumDepthInMeters,//locationevent/waterdepth/_avg/max/_units/value,,75
49
minimumDepthInMeters,//locationevent/waterdepth/_avg/min/_units/value,,74
50
locality,//location/locationnarrative/_merge/1,,68
51
verbatimLocality,//location/locationnarrative/_merge/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
52
habitat,"//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
53
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",19
54
institutionCode,//location/sourceaccessioncode/_alt/2/_merge/1,,
55
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,12
56
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",20
48
maximumDepthInMeters,//locationevent/waterdepth,,75
49
minimumDepthInMeters,//locationevent/waterdepth,,74
50
locality,//location/locationnarrative,,68
51
verbatimLocality,//location/locationnarrative,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
52
habitat,"//location/locationnarrative/_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
53
occurrenceID,//location/sourceaccessioncode,"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",19
54
institutionCode,//location/sourceaccessioncode,,
55
collectionCode,//location/sourceaccessioncode,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,12
56
catalogNumber,//location/sourceaccessioncode,"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
57 57
acceptedNameUsage,,,135
58 58
acceptedNameUsageID,,,128
59 59
associatedMedia,,,36
mappings/for_review/VegBIEN-DwC2.specimens.csv
1 1
VegBIEN:,DwC,Comments
2
//location/elevation/_alt/2/_avg/max/_units/value,maximumElevationInMeters,
3
"//location/elevation/_alt/2/_avg/min/_units/value/_rangeStart/value/_replace[""\bca\.?""=]/value",minimumElevationInMeters,
4
"//location/elevationrange/_range/from/_units/value/_rangeStart/value/_replace[""\bca\.?""=]/value",minimumElevationInMeters,
5
//location/elevationrange/_range/to/_units/value/_alt/1,maximumElevationInMeters,
6
"//location/elevationrange/_range/to/_units/value/_alt/2/_rangeEnd/value/_replace[""\bca\.?""=]/value",minimumElevationInMeters,
7
//locationdetermination/coordsaccuracy/_noCV/value/_alt/1,coordinateUncertaintyInMeters,
8
//locationdetermination/coordsaccuracy/_noCV/value/_alt/2,coordinatePrecision,
2
//location/elevation,maximumElevationInMeters,
3
"//location/elevation/_replace[""\bca\.?""=]/value",minimumElevationInMeters,
4
"//location/elevationrange/_replace[""\bca\.?""=]/value",minimumElevationInMeters,
5
//location/elevationrange,maximumElevationInMeters,
6
"//location/elevationrange/_replace[""\bca\.?""=]/value",minimumElevationInMeters,
7
//locationdetermination/coordsaccuracy,coordinateUncertaintyInMeters,
8
//locationdetermination/coordsaccuracy,coordinatePrecision,
9 9
//locationdetermination/footprintgeometry_dwc,footprintWKT,
10
//locationdetermination/latitude/_alt/1/_nullIf/value,decimalLatitude,
11
//locationdetermination/latitude/_alt/1/_nullIf/value,verbatimLatitude,
12
//locationdetermination/longitude/_alt/1/_nullIf/value,decimalLongitude,
13
//locationdetermination/longitude/_alt/1/_nullIf/value,verbatimLongitude,
14
"//locationdetermination/namedplace_id/_simplifyPath/path/_forEach:[do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",county,
15
"//locationdetermination/namedplace_id/_simplifyPath/path/_forEach:[do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",stateProvince,
16
"//locationdetermination/namedplace_id/_simplifyPath/path/_forEach:[do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",country,Brad: Required; reject record if this field NULL
17
"//locationdetermination/namedplace_id/_simplifyPath/path/_forEach:[do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",continent,Brad: OMIT
18
//locationevent/obsenddate/_*/date/_dateRangeEnd/value,eventDate,
19
//locationevent/obsstartdate/_*/date/_dateRangeStart/value,eventDate,
10
//locationdetermination/latitude,decimalLatitude,
11
//locationdetermination/latitude,verbatimLatitude,
12
//locationdetermination/longitude,decimalLongitude,
13
//locationdetermination/longitude,verbatimLongitude,
14
"//locationdetermination/namedplace_id/_forEach:[do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",county,
15
"//locationdetermination/namedplace_id/_forEach:[do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",stateProvince,
16
"//locationdetermination/namedplace_id/_forEach:[do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",country,Brad: Required; reject record if this field NULL
17
"//locationdetermination/namedplace_id/_forEach:[do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",continent,Brad: OMIT
18
//locationevent/obsenddate/_*/date,eventDate,
19
//locationevent/obsstartdate/_*/date,eventDate,
20 20
//specimenreplicate/catalognumber_dwc,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"
21 21
//specimenreplicate/collectioncode_dwc,collectionCode,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name
22
//specimenreplicate/collectionnumber/_alt/1,recordNumber,
23
//specimenreplicate/collectionnumber/_alt/2,collectionID,
24
//specimenreplicate/collectionnumber/_alt/3,fieldNumber,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?"
22
//specimenreplicate/collectionnumber,recordNumber,
23
//specimenreplicate/collectionnumber,collectionID,
24
//specimenreplicate/collectionnumber,fieldNumber,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?"
25 25
"//specimenreplicate/definedvalue[*_id/userdefined[tablename=specimenreplicate,userdefinedname=sex]]/definedvalue",sex,"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
//specimenreplicate/description/_merge/1,fieldNotes,
27
//specimenreplicate/description/_merge/2,taxonRemarks,
28
//specimenreplicate/growthform/_map/value,establishmentMeans,
26
//specimenreplicate/description,fieldNotes,
27
//specimenreplicate/description,taxonRemarks,
28
//specimenreplicate/growthform,establishmentMeans,
29 29
//party/organizationname,institutionCode,
30
//specimenreplicate/iscultivated/_map/value,establishmentMeans,
31
//specimenreplicate/isnative/_map/value,establishmentMeans,
30
//specimenreplicate/iscultivated,establishmentMeans,
31
//specimenreplicate/isnative,establishmentMeans,
32 32
//specimenreplicate/sourceaccessioncode,occurrenceID,"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"
33
//specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value,dateIdentified,
34
//specimenreplicate/taxondetermination[role=identifier]/*_id/party/givenname/_namePart/first,identifiedBy,Brad: Bob: does this look correct for VegBank?
35
//specimenreplicate/taxondetermination[role=identifier]/*_id/party/middlename/_namePart/middle,identifiedBy,Brad: Bob: does this look correct for VegBank?
36
//specimenreplicate/taxondetermination[role=identifier]/*_id/party/surname/_namePart/last,identifiedBy,Brad: Bob: does this look correct for VegBank?
37
"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",scientificName,"Brad: Bob, Nick, please is this mapping OK?"
38
"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname",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"
39
"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",infraspecificEpithet,
40
"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",specificEpithet,
41
"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",genus,
42
"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",family,
43
"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",order,
44
"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",class,
45
"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",phylum,
46
"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath/path/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",kingdom,
33
//specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date,dateIdentified,
34
//specimenreplicate/taxondetermination[role=identifier]/*_id/party/givenname,identifiedBy,Brad: Bob: does this look correct for VegBank?
35
//specimenreplicate/taxondetermination[role=identifier]/*_id/party/middlename,identifiedBy,Brad: Bob: does this look correct for VegBank?
36
//specimenreplicate/taxondetermination[role=identifier]/*_id/party/surname,identifiedBy,Brad: Bob: does this look correct for VegBank?
37
"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",scientificName,"Brad: Bob, Nick, please is this mapping OK?"
38
"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname",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"
39
"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",infraspecificEpithet,
40
"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",specificEpithet,
41
"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",genus,
42
"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",family,
43
"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",order,
44
"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",class,
45
"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",phylum,
46
"//specimenreplicate/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_forEach:[do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",kingdom,
47 47
//specimenreplicate/verbatimcollectorname,recordedBy,
48
//locationevent/waterdepth/_avg/max/_units/value,maximumDepthInMeters,
49
//locationevent/waterdepth/_avg/min/_units/value,minimumDepthInMeters,
50
//location/locationnarrative/_merge/1,locality,
51
//location/locationnarrative/_merge/2,verbatimLocality,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one."
52
"//location/locationnarrative/_merge/3/_label[label=""habitat""]/value",habitat,"Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
53
//location/sourceaccessioncode/_alt/1,occurrenceID,"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"
54
//location/sourceaccessioncode/_alt/2/_merge/1,institutionCode,
55
//location/sourceaccessioncode/_alt/2/_merge/2,collectionCode,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name
56
//location/sourceaccessioncode/_alt/2/_merge/3,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"
48
//locationevent/waterdepth,maximumDepthInMeters,
49
//locationevent/waterdepth,minimumDepthInMeters,
50
//location/locationnarrative,locality,
51
//location/locationnarrative,verbatimLocality,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one."
52
"//location/locationnarrative/_label[label=""habitat""]/value",habitat,"Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
53
//location/sourceaccessioncode,occurrenceID,"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"
54
//location/sourceaccessioncode,institutionCode,
55
//location/sourceaccessioncode,collectionCode,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name
56
//location/sourceaccessioncode,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"
57 57
,acceptedNameUsage,
58 58
,acceptedNameUsageID,
59 59
,associatedMedia,

Also available in: Unified diff