"SpeciesLink[DwC,dwcore,darwin1,curatorial,geospatial]",VegBIEN:/specimenreplicate,Comments,Order

CoordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88

coordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88

CoordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89

coordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89

BoundingBox,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91

FootprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91

footprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91

County,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66

county,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66

StateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65

stateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65

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

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

Locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68

locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68

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

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

Habitat,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52

habitat,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52

MinimumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}",,71

MinimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}",,71

minimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}",,71

MaximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72

MaximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72

maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72

DecimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85

decimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85

Latitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81

VerbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81

verbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81

DecimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86

decimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86

Longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82

VerbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82

verbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82

MaximumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75

MaximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75

maximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75

MinimumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74

MinimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74

minimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74

EventDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value",,44

eventDate/_alt,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt",Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,44

DayCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44

MonthCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,44

YearCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,44

eventDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/2",,44

CollectedDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/3",,44

DateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value,,120

dateIdentified/_alt,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom dateIdentified mappings that don't pass through the default dateIdentified mapping,120

DayIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,120

MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,120

YearIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,120

dateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,120

IdentifiedDate,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/3,,120

IdentifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119

identifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119

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

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

ScientificNameAuthor,"/*_id/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

ScientificNameAuthorship,"/*_id/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

scientificNameAuthorship,"/*_id/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

InfraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,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",,150

Subspecies,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,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",,150

infraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,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",,150

Species,"/*_id/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

SpecificEpithet,"/*_id/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

specificEpithet,"/*_id/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,"/*_id/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

genus,"/*_id/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,"/*_id/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

family,"/*_id/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,"/*_id/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

order,"/*_id/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,"/*_id/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

class,"/*_id/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,"/*_id/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

phylum,"/*_id/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,"/*_id/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

kingdom,"/*_id/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

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

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

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

sex,"/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,/description/_merge/1,,

Notes,/description/_merge/1,,

fieldNotes,/description/_merge/1,,

Remarks,/description/_merge/2,,158

TaxonRemarks,/description/_merge/2,,158

taxonRemarks,/description/_merge/2,,158

Collector,/verbatimcollectorname,,23

RecordedBy,/verbatimcollectorname,,23

recordedBy,/verbatimcollectorname,,23

CatalogNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/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

catalogNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/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

CollectorNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22

RecordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22

recordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22

CollectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9

collectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9

FieldNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53

fieldNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53

InstitutionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,,8

institutionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,,8

GlobalUniqueIdentifier,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/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

OccurrenceID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/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

occurrenceID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/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

curatorialCollectorNumber,,** No join mapping for curatorialCollectorNumber ** 

curatorialFieldNumber,,** No join mapping for curatorialFieldNumber ** 

curatorialIdentifiedBy,,** No join mapping for curatorialIdentifiedBy ** 

curatorialIndividualCount,,** No join mapping for curatorialIndividualCount ** 

curatorialTypeStatus,,** No join mapping for curatorialTypeStatus ** 

darwin1BasisOfRecord,,** No join mapping for darwin1BasisOfRecord ** 

darwin1BoundingBox,,** No join mapping for darwin1BoundingBox ** 

darwin1CatalogNumber,,** No join mapping for darwin1CatalogNumber ** 

darwin1Class,,** No join mapping for darwin1Class ** 

darwin1CollectionCode,,** No join mapping for darwin1CollectionCode ** 

darwin1Collector,,** No join mapping for darwin1Collector ** 

darwin1CollectorNumber,,** No join mapping for darwin1CollectorNumber ** 

darwin1ContinentOcean,,** No join mapping for darwin1ContinentOcean ** 

darwin1CoordinatePrecision,,** No join mapping for darwin1CoordinatePrecision ** 

darwin1Country,,** No join mapping for darwin1Country ** 

darwin1County,,** No join mapping for darwin1County ** 

darwin1DateLastModified,,** No join mapping for darwin1DateLastModified ** 

darwin1DayCollected,,** No join mapping for darwin1DayCollected ** 

darwin1DayIdentified,,** No join mapping for darwin1DayIdentified ** 

darwin1Family,,** No join mapping for darwin1Family ** 

darwin1FieldNumber,,** No join mapping for darwin1FieldNumber ** 

darwin1Genus,,** No join mapping for darwin1Genus ** 

darwin1IdentifiedBy,,** No join mapping for darwin1IdentifiedBy ** 

darwin1IndividualCount,,** No join mapping for darwin1IndividualCount ** 

darwin1InstitutionCode,,** No join mapping for darwin1InstitutionCode ** 

darwin1JulianDay,,** No join mapping for darwin1JulianDay ** 

darwin1Kingdom,,** No join mapping for darwin1Kingdom ** 

darwin1Latitude,,** No join mapping for darwin1Latitude ** 

darwin1Locality,,** No join mapping for darwin1Locality ** 

darwin1Longitude,,** No join mapping for darwin1Longitude ** 

darwin1MaximumDepth,,** No join mapping for darwin1MaximumDepth ** 

darwin1MaximumElevation,,** No join mapping for darwin1MaximumElevation ** 

darwin1MinimumDepth,,** No join mapping for darwin1MinimumDepth ** 

darwin1MinimumElevation,,** No join mapping for darwin1MinimumElevation ** 

darwin1MonthCollected,,** No join mapping for darwin1MonthCollected ** 

darwin1MonthIdentified,,** No join mapping for darwin1MonthIdentified ** 

darwin1Notes,,** No join mapping for darwin1Notes ** 

darwin1Order,,** No join mapping for darwin1Order ** 

darwin1Phylum,,** No join mapping for darwin1Phylum ** 

darwin1PreparationType,,** No join mapping for darwin1PreparationType ** 

darwin1PreviousCatalogNumber,,** No join mapping for darwin1PreviousCatalogNumber ** 

darwin1RelatedCatalogItem,,** No join mapping for darwin1RelatedCatalogItem ** 

darwin1RelationshipType,,** No join mapping for darwin1RelationshipType ** 

darwin1ScientificName,,** No join mapping for darwin1ScientificName ** 

darwin1ScientificNameAuthor,,** No join mapping for darwin1ScientificNameAuthor ** 

darwin1Sex,,** No join mapping for darwin1Sex ** 

darwin1Species,,** No join mapping for darwin1Species ** 

darwin1StateProvince,,** No join mapping for darwin1StateProvince ** 

darwin1Subspecies,,** No join mapping for darwin1Subspecies ** 

darwin1TimeOfDay,,** No join mapping for darwin1TimeOfDay ** 

darwin1TypeStatus,,** No join mapping for darwin1TypeStatus ** 

darwin1YearCollected,,** No join mapping for darwin1YearCollected ** 

darwin1YearIdentified,,** No join mapping for darwin1YearIdentified ** 

dwcoreAuthorYearOfScientificName,,** No join mapping for dwcoreAuthorYearOfScientificName ** 

dwcoreBasisOfRecord,,** No join mapping for dwcoreBasisOfRecord ** 

dwcoreCatalogNumber,,** No join mapping for dwcoreCatalogNumber ** 

dwcoreClass,,** No join mapping for dwcoreClass ** 

dwcoreCollectionCode,,** No join mapping for dwcoreCollectionCode ** 

dwcoreCollector,,** No join mapping for dwcoreCollector ** 

dwcoreContinent,,** No join mapping for dwcoreContinent ** 

dwcoreCountry,,** No join mapping for dwcoreCountry ** 

dwcoreCounty,,** No join mapping for dwcoreCounty ** 

dwcoreDateLastModified,,** No join mapping for dwcoreDateLastModified ** 

dwcoreDayOfYear,,** No join mapping for dwcoreDayOfYear ** 

dwcoreFamily,,** No join mapping for dwcoreFamily ** 

dwcoreGenus,,** No join mapping for dwcoreGenus ** 

dwcoreGlobalUniqueIdentifier,,** No join mapping for dwcoreGlobalUniqueIdentifier ** 

dwcoreInfraspecificEpithet,,** No join mapping for dwcoreInfraspecificEpithet ** 

dwcoreInstitutionCode,,** No join mapping for dwcoreInstitutionCode ** 

dwcoreKingdom,,** No join mapping for dwcoreKingdom ** 

dwcoreLocality,,** No join mapping for dwcoreLocality ** 

dwcoreMaximumDepthInMeters,,** No join mapping for dwcoreMaximumDepthInMeters ** 

dwcoreMaximumElevationInMeters,,** No join mapping for dwcoreMaximumElevationInMeters ** 

dwcoreMinimumDepthInMeters,,** No join mapping for dwcoreMinimumDepthInMeters ** 

dwcoreMinimumElevationInMeters,,** No join mapping for dwcoreMinimumElevationInMeters ** 

dwcoreOrder,,** No join mapping for dwcoreOrder ** 

dwcorePhylum,,** No join mapping for dwcorePhylum ** 

dwcoreRemarks,,** No join mapping for dwcoreRemarks ** 

dwcoreScientificName,,** No join mapping for dwcoreScientificName ** 

dwcoreSex,,** No join mapping for dwcoreSex ** 

dwcoreSpecificEpithet,,** No join mapping for dwcoreSpecificEpithet ** 

dwcoreStateProvince,,** No join mapping for dwcoreStateProvince ** 

geospatialDecimalLatitude,,** No join mapping for geospatialDecimalLatitude ** 

geospatialDecimalLongitude,,** No join mapping for geospatialDecimalLongitude ** 

geospatialGeodeticDatum,,** No join mapping for geospatialGeodeticDatum ** 

"SpeciesLink[DwC,dwcore,darwin1,curatorial,geospatial]:brazil_raw"

"dwcoreGlobalUniqueIdentifier"

"dwcoreDateLastModified"

"dwcoreBasisOfRecord"

"dwcoreInstitutionCode"

"dwcoreCollectionCode"

"dwcoreCatalogNumber"

"dwcoreRemarks"

"dwcoreScientificName"

"dwcoreKingdom"

"dwcorePhylum"

"dwcoreClass"

"dwcoreOrder"

"dwcoreFamily"

"dwcoreGenus"

"dwcoreSpecificEpithet"

"dwcoreInfraspecificEpithet"

"dwcoreAuthorYearOfScientificName"

"dwcoreContinent"

"dwcoreCountry"

"dwcoreStateProvince"

"dwcoreCounty"

"dwcoreLocality"

"dwcoreMinimumElevationInMeters"

"dwcoreMaximumElevationInMeters"

"dwcoreMinimumDepthInMeters"

"dwcoreMaximumDepthInMeters"

"dwcoreDayOfYear"

"dwcoreCollector"

"dwcoreSex"

"curatorialIdentifiedBy"

"curatorialCollectorNumber"

"curatorialFieldNumber"

"curatorialTypeStatus"

"curatorialIndividualCount"

"geospatialDecimalLatitude"

"geospatialDecimalLongitude"

"geospatialGeodeticDatum"

"darwin1DateLastModified"

"darwin1InstitutionCode"

"darwin1CollectionCode"

"darwin1CatalogNumber"

"darwin1ScientificName"

"darwin1BasisOfRecord"

"darwin1Kingdom"

"darwin1Phylum"

"darwin1Class"

"darwin1Order"

"darwin1Family"

"darwin1Genus"

"darwin1Species"

"darwin1Subspecies"

"darwin1ScientificNameAuthor"

"darwin1IdentifiedBy"

"darwin1YearIdentified"

"darwin1MonthIdentified"

"darwin1DayIdentified"

"IdentifiedDate"

"darwin1TypeStatus"

"darwin1CollectorNumber"

"darwin1FieldNumber"

"darwin1Collector"

"darwin1YearCollected"

"darwin1MonthCollected"

"darwin1DayCollected"

"CollectedDate"

"darwin1JulianDay"

"darwin1TimeOfDay"

"darwin1ContinentOcean"

"darwin1Country"

"darwin1StateProvince"

"darwin1County"

"darwin1Locality"

"darwin1Longitude"

"darwin1Latitude"

"darwin1CoordinatePrecision"

"darwin1BoundingBox"

"darwin1MinimumElevation"

"darwin1MaximumElevation"

"darwin1MinimumDepth"

"darwin1MaximumDepth"

"darwin1Sex"

"darwin1PreparationType"

"darwin1IndividualCount"

"darwin1PreviousCatalogNumber"

"darwin1RelationshipType"

"darwin1RelatedCatalogItem"

"darwin1Notes"

"SpeciesLink[DwC,dwcore,darwin1,curatorial,geospatial]:brazil_raw","DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[institutionID=$/_ignore/inLabel]/","Comments"

"AuthorYearOfScientificName",,

"DayOfYear",,

"SpeciesLink[DwC,dwcore,darwin1,curatorial,geospatial]:brazil_raw","DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[institutionID=$/_ignore/inLabel]/",Comments

AcceptedNameUsage,AcceptedNameUsage

AcceptedNameUsageID,AcceptedNameUsageID

AssociatedMedia,AssociatedMedia

AssociatedOccurrences,AssociatedOccurrences

AssociatedReferences,AssociatedReferences

AssociatedSequences,AssociatedSequences

AssociatedTaxa,AssociatedTaxa

BasisOfRecord,BasisOfRecord

Bed,Bed

Behavior,Behavior

BoundingBox,BoundingBox

CatalogNumber,CatalogNumber

Class,Class

CollectedDate,CollectedDate

CollectionCode,CollectionCode

CollectionID,CollectionID

Collector,Collector

CollectorNumber,CollectorNumber

Continent,Continent

ContinentOcean,ContinentOcean

CoordinatePrecision,CoordinatePrecision

CoordinateUncertaintyInMeters,CoordinateUncertaintyInMeters

Country,Country

CountryCode,CountryCode

County,County

DataGeneralizations,DataGeneralizations

DatasetID,DatasetID

DatasetName,DatasetName

DateIdentified,DateIdentified

DateLastModified,DateLastModified

Day,Day

DayCollected,DayCollected

DayIdentified,DayIdentified

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

GlobalUniqueIdentifier,GlobalUniqueIdentifier

Group,Group

Habitat,Habitat

HigherClassification,HigherClassification

HigherGeography,HigherGeography

HigherGeographyID,HigherGeographyID

HighestBiostratigraphicZone,HighestBiostratigraphicZone

IdentificationID,IdentificationID

IdentificationQualifier,IdentificationQualifier

IdentificationReferences,IdentificationReferences

IdentificationRemarks,IdentificationRemarks

IdentificationVerificationStatus,IdentificationVerificationStatus

IdentifiedBy,IdentifiedBy

IdentifiedDate,IdentifiedDate

IndividualCount,IndividualCount

IndividualID,IndividualID

InformationWithheld,InformationWithheld

InfraspecificEpithet,InfraspecificEpithet

InstitutionCode,InstitutionCode

InstitutionID,InstitutionID

Island,Island

IslandGroup,IslandGroup

JulianDay,JulianDay

Kingdom,Kingdom

LatestAgeOrHighestStage,LatestAgeOrHighestStage

LatestEonOrHighestEonothem,LatestEonOrHighestEonothem

LatestEpochOrHighestSeries,LatestEpochOrHighestSeries

LatestEraOrHighestErathem,LatestEraOrHighestErathem

LatestPeriodOrHighestSystem,LatestPeriodOrHighestSystem

Latitude,Latitude

LifeStage,LifeStage

LithostratigraphicTerms,LithostratigraphicTerms

Locality,Locality

LocationAccordingTo,LocationAccordingTo

LocationID,LocationID

LocationRemarks,LocationRemarks

Longitude,Longitude

LowestBiostratigraphicZone,LowestBiostratigraphicZone

MaximumDepth,MaximumDepth

MaximumDepthInMeters,MaximumDepthInMeters

MaximumDistanceAboveSurfaceInMeters,MaximumDistanceAboveSurfaceInMeters

MaximumElevation,MaximumElevation

MaximumElevationInMeters,MaximumElevationInMeters

MeasurementAccuracy,MeasurementAccuracy

MeasurementDeterminedBy,MeasurementDeterminedBy

MeasurementDeterminedDate,MeasurementDeterminedDate

MeasurementID,MeasurementID

MeasurementMethod,MeasurementMethod

MeasurementRemarks,MeasurementRemarks

MeasurementType,MeasurementType

MeasurementUnit,MeasurementUnit

MeasurementValue,MeasurementValue

Member,Member

MinimumDepth,MinimumDepth

MinimumDepthInMeters,MinimumDepthInMeters

MinimumDistanceAboveSurfaceInMeters,MinimumDistanceAboveSurfaceInMeters

MinimumElevation,MinimumElevation

MinimumElevationInMeters,MinimumElevationInMeters

Month,Month

MonthCollected,MonthCollected

MonthIdentified,MonthIdentified

Municipality,Municipality

NameAccordingTo,NameAccordingTo

NameAccordingToID,NameAccordingToID

NamePublishedIn,NamePublishedIn

NamePublishedInID,NamePublishedInID

NamePublishedInYear,NamePublishedInYear

NomenclaturalCode,NomenclaturalCode

NomenclaturalStatus,NomenclaturalStatus

Notes,Notes

OccurrenceID,OccurrenceID

OccurrenceRemarks,OccurrenceRemarks

OccurrenceStatus,OccurrenceStatus

Order,Order

OriginalNameUsage,OriginalNameUsage

OriginalNameUsageID,OriginalNameUsageID

OtherCatalogNumbers,OtherCatalogNumbers

OwnerInstitutionCode,OwnerInstitutionCode

ParentNameUsage,ParentNameUsage

ParentNameUsageID,ParentNameUsageID

Phylum,Phylum

PointRadiusSpatialFit,PointRadiusSpatialFit

PreparationType,PreparationType

Preparations,Preparations

PreviousCatalogNumber,PreviousCatalogNumber

PreviousIdentifications,PreviousIdentifications

RecordNumber,RecordNumber

RecordedBy,RecordedBy

RelatedCatalogItem,RelatedCatalogItem

RelatedResourceID,RelatedResourceID

RelationshipAccordingTo,RelationshipAccordingTo

RelationshipEstablishedDate,RelationshipEstablishedDate

RelationshipOfResource,RelationshipOfResource

RelationshipRemarks,RelationshipRemarks

RelationshipType,RelationshipType

Remarks,Remarks

ReproductiveCondition,ReproductiveCondition

ResourceID,ResourceID

ResourceRelationshipID,ResourceRelationshipID

SamplingEffort,SamplingEffort

SamplingProtocol,SamplingProtocol

ScientificName,ScientificName

ScientificNameAuthor,ScientificNameAuthor

ScientificNameAuthorship,ScientificNameAuthorship

ScientificNameID,ScientificNameID

Sex,Sex

Species,Species

SpecificEpithet,SpecificEpithet

StartDayOfYear,StartDayOfYear

StateProvince,StateProvince

Subgenus,Subgenus

Subspecies,Subspecies

TaxonConceptID,TaxonConceptID

TaxonID,TaxonID

TaxonRank,TaxonRank

TaxonRemarks,TaxonRemarks

TaxonomicStatus,TaxonomicStatus

TimeOfDay,TimeOfDay

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

YearCollected,YearCollected

YearIdentified,YearIdentified

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

dateIdentified/_alt,dateIdentified/_alt

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

eventDate/_alt,eventDate/_alt

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

AuthorYearOfScientificName,,

DayOfYear,,

"SpeciesLink[DwC,dwcore,darwin1,curatorial,geospatial]:brazil_raw",VegBIEN:/specimenreplicate,Comments,Order

CoordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88

coordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88

CoordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89

coordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89

BoundingBox,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91

FootprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91

footprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91

County,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66

county,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66

StateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65

stateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65

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

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

Locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68

locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68

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

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

Habitat,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52

habitat,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52

MinimumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}",,71

MinimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}",,71

minimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}",,71

MaximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72

MaximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72

maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72

DecimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85

decimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85

Latitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81

VerbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81

verbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81

DecimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86

decimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86

Longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82

VerbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82

verbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82

MaximumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75

MaximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75

maximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75

MinimumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74

MinimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74

minimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74

EventDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value",,44

eventDate/_alt,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt",Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,44

DayCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44

MonthCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,44

YearCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,44

eventDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/2",,44

CollectedDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/3",,44

DateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value,,120

dateIdentified/_alt,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom dateIdentified mappings that don't pass through the default dateIdentified mapping,120

DayIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,120

MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,120

YearIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,120

dateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,120

IdentifiedDate,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/3,,120

IdentifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119

identifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119

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

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

ScientificNameAuthor,"/*_id/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

ScientificNameAuthorship,"/*_id/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

scientificNameAuthorship,"/*_id/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

InfraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,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",,150

Subspecies,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,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",,150

infraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,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",,150

Species,"/*_id/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

SpecificEpithet,"/*_id/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

specificEpithet,"/*_id/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,"/*_id/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

genus,"/*_id/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,"/*_id/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

family,"/*_id/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,"/*_id/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

order,"/*_id/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,"/*_id/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

class,"/*_id/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,"/*_id/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

phylum,"/*_id/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,"/*_id/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

kingdom,"/*_id/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

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

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

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

sex,"/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,/description/_merge/1,,

Notes,/description/_merge/1,,

fieldNotes,/description/_merge/1,,

Remarks,/description/_merge/2,,158

TaxonRemarks,/description/_merge/2,,158

taxonRemarks,/description/_merge/2,,158

Collector,/verbatimcollectorname,,23

RecordedBy,/verbatimcollectorname,,23

recordedBy,/verbatimcollectorname,,23

CatalogNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/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

catalogNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/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

CollectorNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22

RecordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22

recordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22

CollectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9

collectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9

FieldNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53

fieldNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53

InstitutionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,,8

institutionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,,8

GlobalUniqueIdentifier,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/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

OccurrenceID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/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

occurrenceID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/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

AcceptedNameUsage,,,135

AcceptedNameUsageID,,,128

AssociatedMedia,,,36

AssociatedOccurrences,,,38

AssociatedReferences,,,37

AssociatedSequences,,,39

AssociatedTaxa,,,40

AuthorYearOfScientificName,,

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

Bed,,,117

Behavior,,,29

Continent,,Brad: OMIT,59

ContinentOcean,,Brad: OMIT,59

CountryCode,,,64

DataGeneralizations,,,17

DatasetID,,,10

DatasetName,,,13

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

Day,,Brad: OMIT,50

DayOfYear,,

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

EstablishmentMeans,,,30

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

InstitutionCode,,,

Island,,,62

IslandGroup,,,61

JulianDay,,Brad: OMIT,50

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

PreparationType,,Brad: OMIT,32

Preparations,,Brad: OMIT,32

PreviousCatalogNumber,,?; Brad: OMIT,35

PreviousIdentifications,,Brad: OMIT,35

RelatedCatalogItem,,Brad: OMIT,161

RelatedResourceID,,Brad: OMIT,161

RelationshipAccordingTo,,,163

RelationshipEstablishedDate,,,164

RelationshipOfResource,,Brad: OMIT,162

RelationshipRemarks,,,165

RelationshipType,,Brad: OMIT,162

ReproductiveCondition,,,28

ResourceID,,,160

ResourceRelationshipID,,,159

SamplingEffort,,,43

SamplingProtocol,,,42

ScientificNameID,,,127

StartDayOfYear,,,46

Subgenus,,,148

TaxonConceptID,,,133

TaxonID,,,126

TaxonRank,,,151

TaxonomicStatus,,,156

TimeOfDay,,Brad: OMIT,45

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

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

continent,,Brad: OMIT,59

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

establishmentMeans,,,30

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

institutionCode,,,

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