VegCSV[DwC],VegBIEN:,Comments,Order

//plot/area,/location/area,

//geospatial/verbatimElevation,/location/elevation/_alt/1,

maximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value",,72

//geospatial/maximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_rangeEnd/value",

//geospatial/minimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value",

minimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,71

//geospatial/minimumElevationInMeters,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value",

minimumElevationInMeters,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",,71

maximumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1",,72

minimumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",,71

//geospatial/maximumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_rangeEnd/value",

//plot/landform,/location/landform,

//geospatial/CoordinateUncertaintyInMeters,/location/locationdetermination/coordsaccuracy,

coordinateUncertaintyInMeters,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88

coordinatePrecision,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89

footprintWKT,/location/locationdetermination/footprintgeometry_dwc,,91

//geospatial/DecimalLatitude,/location/locationdetermination/latitude,

decimalLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,85

verbatimLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,81

//geospatial/DecimalLongitude,/location/locationdetermination/longitude,

decimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,86

verbatimLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,82

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

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

country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",Brad: Required; reject record if this field NULL,63

continent,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",Brad: OMIT,59

//plotObservation/simpleUserdefined[name=method]/*ID/method/name,/location/locationevent/*_id/method/name,

//project/title[@id=name],/location/locationevent/*_id/project/projectname,

//project/title[@id=sourceAccessionCode],/location/locationevent/*_id/project/sourceaccessioncode,

//plot/plotName,/location/locationevent/authorlocationcode,

//*s/communityDetermination/*s/communityConcept/commonName,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,

//*s/communityDetermination/*s/communityConcept/name,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,

//*s/plotObservation/obsEndDate,/location/locationevent/obsenddate,

eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value,,44

//*s/plotObservation/obsStartDate,/location/locationevent/obsstartdate,

eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,,44

//plot/plotUniqueIdentifier,/location/locationevent/parent_id/locationevent/*_id/location/sourceaccessioncode/_alt/1,

//plot/plotName,/location/locationevent/parent_id/locationevent/*_id/location/sourceaccessioncode/_alt/2,

//plot/plotName,/location/locationevent/parent_id/locationevent/authorlocationcode,

//plot/plotUniqueIdentifier,/location/locationevent/parent_id/locationevent/sourceaccessioncode,

//plotObservation/simpleUserdefined[name=precipitation]/value,/location/locationevent/precipitation,

//abioticObservation/simpleUserdefined[name=acidity]/value,/location/locationevent/soilobs/acidity,

//abioticObservation/simpleUserdefined[name=base]/value,/location/locationevent/soilobs/basesaturation,

//abioticObservation/simpleUserdefined[name=calcium]/value,/location/locationevent/soilobs/calcium,

//abioticObservation/simpleUserdefined[name=carbon]/value,/location/locationevent/soilobs/carbon,

//abioticObservation/simpleUserdefined[name=cationExchangeCapacity]/value,/location/locationevent/soilobs/cationexchangecapacity,

//abioticObservation/simpleUserdefined[name=clay]/value,/location/locationevent/soilobs/clay,

//abioticObservation/simpleUserdefined[name=conductivity]/value,/location/locationevent/soilobs/conductivity,

//*s/abioticObservation/magnesium,/location/locationevent/soilobs/magnesium,

//*s/abioticObservation/nitrogen,/location/locationevent/soilobs/nitrogen,

//abioticObservation/simpleUserdefined[name=organic]/value,/location/locationevent/soilobs/organic,

//*s/abioticObservation/ph,/location/locationevent/soilobs/ph,

//*s/abioticObservation/phosphorus,/location/locationevent/soilobs/phosphorus,

//*s/abioticObservation/potassium,/location/locationevent/soilobs/potassium,

//abioticObservation/simpleUserdefined[name=sand]/value,/location/locationevent/soilobs/sand,

//abioticObservation/simpleUserdefined[name=silt]/value,/location/locationevent/soilobs/silt,

//abioticObservation/simpleUserdefined[name=sodium]/value,/location/locationevent/soilobs/sodium,

//abioticObservation/simpleUserdefined[name=texture]/value,/location/locationevent/soilobs/texture,

//plot/plotUniqueIdentifier,/location/locationevent/sourceaccessioncode,

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

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

recordNumber,/location/locationevent/specimenreplicate/collectionnumber/_alt/1,,22

collectionID,/location/locationevent/specimenreplicate/collectionnumber/_alt/2,,9

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

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

fieldNotes,/location/locationevent/specimenreplicate/description/_merge/1,,

taxonRemarks,/location/locationevent/specimenreplicate/description/_merge/2,,158

establishmentMeans,"/location/locationevent/specimenreplicate/growthform/_map:[./{tree,shrub,liana,vine,herb,hemiepiphyte,epiphyte,grass,forb,moss,lichen,fungus,""floating aquatic"",""submerged aquatic""}=*,*=]/value",,30

institutionCode,/location/locationevent/specimenreplicate/institution_id/party/organizationname,,

establishmentMeans,"/location/locationevent/specimenreplicate/iscultivated/_map:[cultivated=t,wild=f,*=]/value",,30

establishmentMeans,"/location/locationevent/specimenreplicate/isnative/_map:[native=t,exotic=f,*=]/value",,30

occurrenceID,/location/locationevent/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

dateIdentified,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value,,120

identifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,Brad: Bob: does this look correct for VegBank?,119

identifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/middlename/_namePart/middle,Brad: Bob: does this look correct for VegBank?,119

identifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/surname/_namePart/last,Brad: Bob: does this look correct for VegBank?,119

recordedBy,/location/locationevent/specimenreplicate/verbatimcollectorname,,23

//*s/taxonDetermination[role=collector]/groupType,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/cond/_eq:[right=direct]/left,

//taxonNameUsageConcept/voucher,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/catalognumber_dwc,

//individualOrganismObservation/simpleUserdefined[name=collectionDate]/value,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/collectiondate,

//taxonNameUsageConcept/voucher,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/catalognumber_dwc,

//individualOrganismObservation/simpleUserdefined[name=collectionDate]/value,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/collectiondate,

//*s/aggregateOrganismObservation/*/aggregateValue/value,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,

//ordinal/coverPercent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover,

//individualOrganismObservation/simpleUserdefined[name=censusNo]/value,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue",

//*s/individualOrganismObservation/volumeCanopy/value,/location/locationevent/taxonoccurrence/aggregateoccurrence/linecover,

//individualOrganismObservation/simpleUserdefined[name=authorPlantCode]/value,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode,"""{"" sorts it with other _if:[name=specimenreplicate_via]s"

//*s/individualOrganismObservation/height,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/overallheight,

//individualOrganismObservation/simpleUserdefined[name=height]/value,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/overallheight,

//individualOrganismObservation/simpleUserdefined[name=sourceAccessionCode]/value,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,"""{"" sorts it with other _if:[name=specimenreplicate_via]s"

//*s/aggregateOrganismObservation/*/aggregateValue/value,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount,

//individualOrganismObservation/diameterBaseDistance[value=0]/diameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/basaldiameter,

//individualOrganismObservation/simpleUserdefined[name=canopyForm]/value,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyForm]]:[@fkey=tablerecord_id]/definedvalue",

//individualOrganismObservation/simpleUserdefined[name=canopyPosition]/value,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyPosition]]:[@fkey=tablerecord_id]/definedvalue",

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

//individualOrganismObservation/simpleUserdefined[name=lianaInfestation]/value,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=lianaInfestation]]:[@fkey=tablerecord_id]/definedvalue",

//note/text,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=notes]]:[@fkey=tablerecord_id]/definedvalue",

//individualOrganismObservation/diameterBaseDistance[baseDistance[]/value=1.37]/diameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight,

//individualOrganismObservation/simpleUserdefined[name=height]/value,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height,

//individualOrganismObservation/simpleUserdefined[name=heightFirstBranch]/value,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/heightfirstbranch,

//individualOrganism/identificationLabel[@id=1],"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2

//individualOrganism/identificationLabel[@id=2],/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[iscurrent=true]:[../stemtag?[iscurrent/_alt/2=true]/iscurrent/_alt/1=false]/tag,

//*s/individualOrganismObservation/relativePlotPosition/relativeX,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition,

//*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/relativePlotPosition/relativeX,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition,

//*s/individualOrganismObservation/relativePlotPosition/relativeY,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition,

//*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/relativePlotPosition/relativeY,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition,

//individualOrganismObservation/simpleUserdefined[name=growthForm]/value,/location/locationevent/taxonoccurrence/growthform,

//individualOrganismObservation/simpleUserdefined[name=sourceAccessionCode]/value,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,"""{"" sorts it with other _if:[name=specimenreplicate_via]s"

//individualOrganismObservation/simpleUserdefined[name=authorPlantCode]/value,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2,"""{"" sorts it with other _if:[name=specimenreplicate_via]s"

scientificName,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3,"Brad: Bob, Nick, please is this mapping OK?",134

infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/first",,150

scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[role=computer]:[iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],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

infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=computer]:[iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",,150

specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=computer]:[iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149

genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=computer]:[iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,147

family,"/location/locationevent/taxonoccurrence/taxondetermination[role=computer]:[iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,146

scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname/_name/last","Brad: Bob, Nick, please is this mapping OK?",134

infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150

scientificName,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/taxonfit,"Brad: Bob, Nick, please is this mapping OK?",134

scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname/_name/first","Brad: Bob, Nick, please is this mapping OK?",134

scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],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

specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149

genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,147

family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,146

order,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,145

class,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,144

phylum,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,143

kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,142

//individualName/givenName,/location/locationevent/taxonoccurrence/verbatimcollectorname/_name/first,

//individualName/surName,/location/locationevent/taxonoccurrence/verbatimcollectorname/_name/last,

//*s/plotObservation/temperature,/location/locationevent/temperature,

//geospatial/maximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",

maximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75

//geospatial/minimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",

minimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,74

//plot/locationNarrative,/location/locationnarrative,

locality,/location/locationnarrative/_merge/1,,68

verbatimLocality,/location/locationnarrative/_merge/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69

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

//plot/note,/location/notespublic,

//plot/slopeAspect,/location/slopeaspect/_compass/value,

//plot/slopeGradient,/location/slopegradient,

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

institutionCode,/location/sourceaccessioncode/_alt/2/_merge/1,,

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

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

//plot/plotUniqueIdentifier,/location/sourceaccessioncode/_merge/1/_alt/1,

//plot/plotName,/location/sourceaccessioncode/_merge/1/_alt/2,

//plot/plotUniqueIdentifier,/location/sourceaccessioncode/_merge/2/_alt/1,

//plot/plotName,/location/sourceaccessioncode/_merge/2/_alt/2,

acceptedNameUsage,,,135

acceptedNameUsageID,,,128

associatedMedia,,,36

associatedOccurrences,,,38

associatedReferences,,,37

associatedSequences,,,39

associatedTaxa,,,40

basisOfRecord,,Brad: OMIT? See http://rs.tdwg.org/dwc/terms/index.htm#basisOfRecord for definition of this term.,15

bed,,,117

behavior,,,29

countryCode,,,64

dataGeneralizations,,,17

datasetID,,,10

datasetName,,,13

day,,Brad: OMIT,50

dcterms:accessRights,,,5

dcterms:bibliographicCitation,,,6

dcterms:language,,,2

dcterms:modified,,"Brad: Mapping to VegX is incorrect. I think is this merely an internal timestamp indicated when record last modified, not necessarily when determination (taxon name) last modified. Probably we should omit this field, although might be useful for updating changed records from this source.",1

dcterms:references,,,7

dcterms:rights,,,3

dcterms:rightsHolder,,,4

dcterms:type,,,0

disposition,,,33

dynamicProperties,,,18

earliestAgeOrLowestStage,,,109

earliestEonOrLowestEonothem,,,101

earliestEpochOrLowestSeries,,,107

earliestEraOrLowestErathem,,,103

earliestPeriodOrLowestSystem,,,105

endDayOfYear,,,47

eventID,,,41

eventRemarks,,,55

eventTime,,Brad: OMIT,45

footprintSRS,,,92

footprintSpatialFit,,,93

formation,,,115

geodeticDatum,,,87

geologicalContextID,,,100

georeferenceProtocol,,,96

georeferenceRemarks,,,99

georeferenceSources,,,97

georeferenceVerificationStatus,,,98

georeferencedBy,,Brad: Correct for VB. Nick: is there a way to specifically identify this party as collector of a specimen?,94

georeferencedDate,,,95

group,,,114

higherClassification,,,141

higherGeography,,,58

higherGeographyID,,,57

highestBiostratigraphicZone,,,112

identificationID,,,118

identificationQualifier,,,124

identificationReferences,,,121

identificationRemarks,,,123

identificationVerificationStatus,,,122

individualCount,,Brad: OMIT; not relevant for DwC plant specimen data.,25

individualID,,"Brad: OMIT; db-specific element, not relevant to VB/VX",24

informationWithheld,,,16

institutionID,,,8

island,,,62

islandGroup,,,61

latestAgeOrHighestStage,,,110

latestEonOrHighestEonothem,,,102

latestEpochOrHighestSeries,,,108

latestEraOrHighestErathem,,,104

latestPeriodOrHighestSystem,,,106

lifeStage,,,27

lithostratigraphicTerms,,,113

locationAccordingTo,,,78

locationID,,,56

locationRemarks,,,79

lowestBiostratigraphicZone,,,111

maximumDistanceAboveSurfaceInMeters,,,77

measurementAccuracy,,,169

measurementDeterminedBy,,,172

measurementDeterminedDate,,,171

measurementID,,,166

measurementMethod,,,173

measurementRemarks,,,174

measurementType,,,167

measurementUnit,,,170

measurementValue,,,168

member,,,116

minimumDistanceAboveSurfaceInMeters,,,76

month,,,49

municipality,,,67

nameAccordingTo,,,138

nameAccordingToID,,,131

namePublishedIn,,,139

namePublishedInID,,,132

namePublishedInYear,,,140

nomenclaturalCode,,,155

nomenclaturalStatus,,,157

occurrenceRemarks,,,21

occurrenceStatus,,,31

originalNameUsage,,,137

originalNameUsageID,,,130

otherCatalogNumbers,,,34

ownerInstitutionCode,,,14

parentNameUsage,,,136

parentNameUsageID,,,129

pointRadiusSpatialFit,,,90

preparations,,Brad: OMIT,32

previousIdentifications,,Brad: OMIT,35

relatedResourceID,,Brad: OMIT,161

relationshipAccordingTo,,,163

relationshipEstablishedDate,,,164

relationshipOfResource,,Brad: OMIT,162

relationshipRemarks,,,165

reproductiveCondition,,,28

resourceID,,,160

resourceRelationshipID,,,159

samplingEffort,,,43

samplingProtocol,,,42

scientificNameID,,,127

startDayOfYear,,,46

subgenus,,,148

taxonConceptID,,,133

taxonID,,,126

taxonRank,,,151

taxonomicStatus,,,156

typeStatus,,Brad: OMIT (?). Indicates whether this specimen served as type for taxon name. Probably not relevant for BIEN,125

verbatimCoordinateSystem,,,83

verbatimCoordinates,,,80

verbatimDepth,,,73

verbatimElevation,,,70

verbatimEventDate,,,51

verbatimSRS,,,84

verbatimTaxonRank,,,152

vernacularName,,,154

waterBody,,,60

year,,,48

VegCSV[DwC],VegCSV[DwC]

//*s/abioticObservation/magnesium,//*s/abioticObservation/magnesium

//*s/abioticObservation/nitrogen,//*s/abioticObservation/nitrogen

//*s/abioticObservation/ph,//*s/abioticObservation/ph

//*s/abioticObservation/phosphorus,//*s/abioticObservation/phosphorus

//*s/abioticObservation/potassium,//*s/abioticObservation/potassium

//*s/aggregateOrganismObservation/*/aggregateValue/value,//*s/aggregateOrganismObservation/*/aggregateValue/value

//*s/communityDetermination/*s/communityConcept/commonName,//*s/communityDetermination/*s/communityConcept/commonName

//*s/communityDetermination/*s/communityConcept/name,//*s/communityDetermination/*s/communityConcept/name

//*s/individualOrganismObservation/height,//*s/individualOrganismObservation/height

//*s/individualOrganismObservation/relativePlotPosition/relativeX,//*s/individualOrganismObservation/relativePlotPosition/relativeX

//*s/individualOrganismObservation/relativePlotPosition/relativeY,//*s/individualOrganismObservation/relativePlotPosition/relativeY

//*s/individualOrganismObservation/volumeCanopy/value,//*s/individualOrganismObservation/volumeCanopy/value

//*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/relativePlotPosition/relativeX,//*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/relativePlotPosition/relativeX

//*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/relativePlotPosition/relativeY,//*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/relativePlotPosition/relativeY

//*s/plotObservation/obsEndDate,//*s/plotObservation/obsEndDate

//*s/plotObservation/obsStartDate,//*s/plotObservation/obsStartDate

//*s/plotObservation/temperature,//*s/plotObservation/temperature

//*s/taxonDetermination[role=collector]/groupType,//*s/taxonDetermination[role=collector]/groupType

//abioticObservation/simpleUserdefined[name=acidity]/value,//abioticObservation/simpleUserdefined[name=acidity]/value

//abioticObservation/simpleUserdefined[name=base]/value,//abioticObservation/simpleUserdefined[name=base]/value

//abioticObservation/simpleUserdefined[name=calcium]/value,//abioticObservation/simpleUserdefined[name=calcium]/value

//abioticObservation/simpleUserdefined[name=carbon]/value,//abioticObservation/simpleUserdefined[name=carbon]/value

//abioticObservation/simpleUserdefined[name=cationExchangeCapacity]/value,//abioticObservation/simpleUserdefined[name=cationExchangeCapacity]/value

//abioticObservation/simpleUserdefined[name=clay]/value,//abioticObservation/simpleUserdefined[name=clay]/value

//abioticObservation/simpleUserdefined[name=conductivity]/value,//abioticObservation/simpleUserdefined[name=conductivity]/value

//abioticObservation/simpleUserdefined[name=organic]/value,//abioticObservation/simpleUserdefined[name=organic]/value

//abioticObservation/simpleUserdefined[name=sand]/value,//abioticObservation/simpleUserdefined[name=sand]/value

//abioticObservation/simpleUserdefined[name=silt]/value,//abioticObservation/simpleUserdefined[name=silt]/value

//abioticObservation/simpleUserdefined[name=sodium]/value,//abioticObservation/simpleUserdefined[name=sodium]/value

//abioticObservation/simpleUserdefined[name=texture]/value,//abioticObservation/simpleUserdefined[name=texture]/value

//geospatial/CoordinateUncertaintyInMeters,//geospatial/CoordinateUncertaintyInMeters

//geospatial/DecimalLatitude,//geospatial/DecimalLatitude

//geospatial/DecimalLongitude,//geospatial/DecimalLongitude

//geospatial/maximumDepthInMeters,//geospatial/maximumDepthInMeters

//geospatial/maximumElevationInMeters,//geospatial/maximumElevationInMeters

//geospatial/minimumDepthInMeters,//geospatial/minimumDepthInMeters

//geospatial/minimumElevationInMeters,//geospatial/minimumElevationInMeters

//geospatial/verbatimElevation,//geospatial/verbatimElevation

//individualName/givenName,//individualName/givenName

//individualName/surName,//individualName/surName

//individualOrganism/identificationLabel[@id=1],//individualOrganism/identificationLabel[@id=1]

//individualOrganism/identificationLabel[@id=2],//individualOrganism/identificationLabel[@id=2]

//individualOrganismObservation/diameterBaseDistance[baseDistance[*ID/*s/attribute/quantitative/*ID/*s/method(/name=Gentry)]/value=1.37]/diameter,//individualOrganismObservation/diameterBaseDistance[baseDistance[*ID/*s/attribute/quantitative/*ID/*s/method(/name=Gentry)]/value=1.37]/diameter

//individualOrganismObservation/diameterBaseDistance[baseDistance[]/value=1.37]/diameter,//individualOrganismObservation/diameterBaseDistance[baseDistance[]/value=1.37]/diameter

//individualOrganismObservation/diameterBaseDistance[value=0]/diameter,//individualOrganismObservation/diameterBaseDistance[value=0]/diameter

//individualOrganismObservation/simpleUserdefined[name=authorPlantCode]/value,//individualOrganismObservation/simpleUserdefined[name=authorPlantCode]/value

//individualOrganismObservation/simpleUserdefined[name=canopyForm]/value,//individualOrganismObservation/simpleUserdefined[name=canopyForm]/value

//individualOrganismObservation/simpleUserdefined[name=canopyPosition]/value,//individualOrganismObservation/simpleUserdefined[name=canopyPosition]/value

//individualOrganismObservation/simpleUserdefined[name=censusNo]/value,//individualOrganismObservation/simpleUserdefined[name=censusNo]/value

//individualOrganismObservation/simpleUserdefined[name=collectionDate]/value,//individualOrganismObservation/simpleUserdefined[name=collectionDate]/value

//individualOrganismObservation/simpleUserdefined[name=growthForm]/value,//individualOrganismObservation/simpleUserdefined[name=growthForm]/value

//individualOrganismObservation/simpleUserdefined[name=heightFirstBranch]/value,//individualOrganismObservation/simpleUserdefined[name=heightFirstBranch]/value

//individualOrganismObservation/simpleUserdefined[name=height]/value,//individualOrganismObservation/simpleUserdefined[name=height]/value

//individualOrganismObservation/simpleUserdefined[name=lianaInfestation]/value,//individualOrganismObservation/simpleUserdefined[name=lianaInfestation]/value

//individualOrganismObservation/simpleUserdefined[name=sourceAccessionCode]/value,//individualOrganismObservation/simpleUserdefined[name=sourceAccessionCode]/value

//note/text,//note/text

//ordinal/coverPercent,//ordinal/coverPercent

//plot/area,//plot/area

//plot/landform,//plot/landform

//plot/locationNarrative,//plot/locationNarrative

//plot/note,//plot/note

//plot/plotName,//plot/plotName

//plot/plotUniqueIdentifier,//plot/plotUniqueIdentifier

//plot/slopeAspect,//plot/slopeAspect

//plot/slopeGradient,//plot/slopeGradient

//plotObservation/simpleUserdefined[name=method]/*ID/method/name,//plotObservation/simpleUserdefined[name=method]/*ID/method/name

//plotObservation/simpleUserdefined[name=precipitation]/value,//plotObservation/simpleUserdefined[name=precipitation]/value

//project/title[@id=name],//project/title[@id=name]

//project/title[@id=sourceAccessionCode],//project/title[@id=sourceAccessionCode]

//taxonNameUsageConcept/voucher,//taxonNameUsageConcept/voucher

acceptedNameUsage,acceptedNameUsage

acceptedNameUsageID,acceptedNameUsageID

associatedMedia,associatedMedia

associatedOccurrences,associatedOccurrences

associatedReferences,associatedReferences

associatedSequences,associatedSequences

associatedTaxa,associatedTaxa

basisOfRecord,basisOfRecord

bed,bed

behavior,behavior

catalogNumber,catalogNumber

class,class

collectionCode,collectionCode

collectionID,collectionID

continent,continent

coordinatePrecision,coordinatePrecision

coordinateUncertaintyInMeters,coordinateUncertaintyInMeters

country,country

countryCode,countryCode

county,county

dataGeneralizations,dataGeneralizations

datasetID,datasetID

datasetName,datasetName

dateIdentified,dateIdentified

day,day

dcterms:accessRights,dcterms:accessRights

dcterms:bibliographicCitation,dcterms:bibliographicCitation

dcterms:language,dcterms:language

dcterms:modified,dcterms:modified

dcterms:references,dcterms:references

dcterms:rights,dcterms:rights

dcterms:rightsHolder,dcterms:rightsHolder

dcterms:type,dcterms:type

decimalLatitude,decimalLatitude

decimalLongitude,decimalLongitude

disposition,disposition

dynamicProperties,dynamicProperties

earliestAgeOrLowestStage,earliestAgeOrLowestStage

earliestEonOrLowestEonothem,earliestEonOrLowestEonothem

earliestEpochOrLowestSeries,earliestEpochOrLowestSeries

earliestEraOrLowestErathem,earliestEraOrLowestErathem

earliestPeriodOrLowestSystem,earliestPeriodOrLowestSystem

endDayOfYear,endDayOfYear

establishmentMeans,establishmentMeans

eventDate,eventDate

eventID,eventID

eventRemarks,eventRemarks

eventTime,eventTime

family,family

fieldNotes,fieldNotes

fieldNumber,fieldNumber

footprintSRS,footprintSRS

footprintSpatialFit,footprintSpatialFit

footprintWKT,footprintWKT

formation,formation

genus,genus

geodeticDatum,geodeticDatum

geologicalContextID,geologicalContextID

georeferenceProtocol,georeferenceProtocol

georeferenceRemarks,georeferenceRemarks

georeferenceSources,georeferenceSources

georeferenceVerificationStatus,georeferenceVerificationStatus

georeferencedBy,georeferencedBy

georeferencedDate,georeferencedDate

group,group

habitat,habitat

higherClassification,higherClassification

higherGeography,higherGeography

higherGeographyID,higherGeographyID

highestBiostratigraphicZone,highestBiostratigraphicZone

identificationID,identificationID

identificationQualifier,identificationQualifier

identificationReferences,identificationReferences

identificationRemarks,identificationRemarks

identificationVerificationStatus,identificationVerificationStatus

identifiedBy,identifiedBy

individualCount,individualCount

individualID,individualID

informationWithheld,informationWithheld

infraspecificEpithet,infraspecificEpithet

institutionCode,institutionCode

institutionID,institutionID

island,island

islandGroup,islandGroup

kingdom,kingdom

latestAgeOrHighestStage,latestAgeOrHighestStage

latestEonOrHighestEonothem,latestEonOrHighestEonothem

latestEpochOrHighestSeries,latestEpochOrHighestSeries

latestEraOrHighestErathem,latestEraOrHighestErathem

latestPeriodOrHighestSystem,latestPeriodOrHighestSystem

lifeStage,lifeStage

lithostratigraphicTerms,lithostratigraphicTerms

locality,locality

locationAccordingTo,locationAccordingTo

locationID,locationID

locationRemarks,locationRemarks

lowestBiostratigraphicZone,lowestBiostratigraphicZone

maximumDepthInMeters,maximumDepthInMeters

maximumDistanceAboveSurfaceInMeters,maximumDistanceAboveSurfaceInMeters

maximumElevationInMeters,maximumElevationInMeters

measurementAccuracy,measurementAccuracy

measurementDeterminedBy,measurementDeterminedBy

measurementDeterminedDate,measurementDeterminedDate

measurementID,measurementID

measurementMethod,measurementMethod

measurementRemarks,measurementRemarks

measurementType,measurementType

measurementUnit,measurementUnit

measurementValue,measurementValue

member,member

minimumDepthInMeters,minimumDepthInMeters

minimumDistanceAboveSurfaceInMeters,minimumDistanceAboveSurfaceInMeters

minimumElevationInMeters,minimumElevationInMeters

month,month

municipality,municipality

nameAccordingTo,nameAccordingTo

nameAccordingToID,nameAccordingToID

namePublishedIn,namePublishedIn

namePublishedInID,namePublishedInID

namePublishedInYear,namePublishedInYear

nomenclaturalCode,nomenclaturalCode

nomenclaturalStatus,nomenclaturalStatus

occurrenceID,occurrenceID

occurrenceRemarks,occurrenceRemarks

occurrenceStatus,occurrenceStatus

order,order

originalNameUsage,originalNameUsage

originalNameUsageID,originalNameUsageID

otherCatalogNumbers,otherCatalogNumbers

ownerInstitutionCode,ownerInstitutionCode

parentNameUsage,parentNameUsage

parentNameUsageID,parentNameUsageID

phylum,phylum

pointRadiusSpatialFit,pointRadiusSpatialFit

preparations,preparations

previousIdentifications,previousIdentifications

recordNumber,recordNumber

recordedBy,recordedBy

relatedResourceID,relatedResourceID

relationshipAccordingTo,relationshipAccordingTo

relationshipEstablishedDate,relationshipEstablishedDate

relationshipOfResource,relationshipOfResource

relationshipRemarks,relationshipRemarks

reproductiveCondition,reproductiveCondition

resourceID,resourceID

resourceRelationshipID,resourceRelationshipID

samplingEffort,samplingEffort

samplingProtocol,samplingProtocol

scientificName,scientificName

scientificNameAuthorship,scientificNameAuthorship

scientificNameID,scientificNameID

sex,sex

specificEpithet,specificEpithet

startDayOfYear,startDayOfYear

stateProvince,stateProvince

subgenus,subgenus

taxonConceptID,taxonConceptID

taxonID,taxonID

taxonRank,taxonRank

taxonRemarks,taxonRemarks

taxonomicStatus,taxonomicStatus

typeStatus,typeStatus

verbatimCoordinateSystem,verbatimCoordinateSystem

verbatimCoordinates,verbatimCoordinates

verbatimDepth,verbatimDepth

verbatimElevation,verbatimElevation

verbatimEventDate,verbatimEventDate

verbatimLatitude,verbatimLatitude

verbatimLocality,verbatimLocality

verbatimLongitude,verbatimLongitude

verbatimSRS,verbatimSRS

verbatimTaxonRank,verbatimTaxonRank

vernacularName,vernacularName

waterBody,waterBody

year,year

VegCSV-VegBIEN.specimens.csv: VegX-VegCSV.stems.csv VegX-VegBIEN.stems.csv\

DwC2-VegBIEN.specimens.csv

	<$< $(bin)/invert\

|$(bin)/join $(word 2,$+)\

|$(bin)/union $(word 3,$+)\

|$(bin)/sort_map >$@

vegcsvMaps += VegCSV-VegBIEN.specimens.csv