Project

General

Profile

« Previous | Next » 

Revision 1392

Added inputs/GBIF/maps

View differences:

inputs/GBIF/maps/src.join.specimens.csv
1
GBIF[DwC],VegBIEN:/specimenreplicate,Comments,Order
2
CoordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88
3
coordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88
4
CoordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89
5
coordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89
6
BoundingBox,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
7
FootprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
8
footprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
9
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
10
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
11
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
12
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
13
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
14
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
15
Locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
16
locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
17
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
18
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
19
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
20
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
21
MaximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
22
MaximumElevationInMeter,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
23
MaximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
24
maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
25
MinimumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",,71
26
MinimumElevationInMeter,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",,71
27
MinimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",,71
28
minimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",,71
29
DecimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
30
decimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
31
Latitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
32
VerbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
33
verbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
34
DecimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
35
decimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
36
Longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
37
VerbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
38
verbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
39
MaximumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
40
MaximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
41
maximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
42
MinimumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
43
MinimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
44
minimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
45
EventDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value",,44
46
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
47
DayCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44
48
MonthCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,44
49
YearCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,44
50
LatestDateCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/2",,44
51
eventDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/2",,44
52
DateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value,,120
53
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
54
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,120
55
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,120
56
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,120
57
dateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,120
58
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
59
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
60
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
61
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
62
AuthorOfScientificName,"/*_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
63
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
64
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
65
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
66
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
67
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
68
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
69
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
70
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
71
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
72
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
73
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
74
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
75
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
76
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
77
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
78
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
79
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
80
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
81
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
82
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
83
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
84
CollectionCD,/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
85
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
86
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
87
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
88
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
89
FieldNotes,/description,,
90
Notes,/description,,
91
fieldNotes,/description,,
92
Collector,/verbatimcollectorname,,23
93
RecordedBy,/verbatimcollectorname,,23
94
recordedBy,/verbatimcollectorname,,23
95
CatalogNO,:[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
96
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
97
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
98
CollectorNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
99
RecordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
100
recordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
101
CollectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9
102
collectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9
103
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
104
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
105
InstitutionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,,8
106
institutionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,,8
107
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
108
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
109
GBIFFamilyOriginal,,** No join mapping for originalNameUsage/_alt/2/_name/first ** DwC doesn't fully support taxonomic redeterminations
110
GBIFGenusOriginal,,** No join mapping for originalNameUsage/_alt/2/_name/middle ** DwC doesn't fully support taxonomic redeterminations
111
InstitutionCD,,** No join mapping for InstitutionCode ** 
112
LastDateModified,,** No join mapping for DateLastModified ** 
113
ScientificNameOriginal,,** No join mapping for originalNameUsage/_alt/1 ** DwC doesn't fully support taxonomic redeterminations
inputs/GBIF/maps/src.specimens.csv
1
"GBIF[DwC]"
2
"Collector"
3
"LatestDateCollected"
4
"InstitutionCD"
5
"CollectionCD"
6
"CatalogNO"
7
"LastDateModified"
8
"IdentifiedBy"
9
"ScientificNameOriginal"
10
"AuthorOfScientificName"
11
"ScientificName"
12
"GBIFFamilyOriginal"
13
"Family"
14
"GBIFGenusOriginal"
15
"Genus"
16
"Country"
17
"Locality"
18
"County"
19
"StateProvince"
20
"DecimalLatitude"
21
"VerbatimLatitude"
22
"DecimalLongitude"
23
"VerbatimLongitude"
24
"MinimumElevationInMeter"
25
"MaximumElevationInMeter"
26
"SpecificEpithet"
27
"InfraspecificEpithet"
inputs/GBIF/maps/DwC.specimens.csv
1
"GBIF[DwC]","DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[institutionID=$/_ignore/inLabel]/","Comments"
2
"LatestDateCollected","eventDate",
3
"InstitutionCD","InstitutionCode",
4
"CollectionCD","CollectionCode",
5
"CatalogNO","CatalogNumber",
6
"LastDateModified","DateLastModified",
7
"ScientificNameOriginal","originalNameUsage/_alt/1","DwC doesn't fully support taxonomic redeterminations"
8
"AuthorOfScientificName","ScientificNameAuthor",
9
"GBIFFamilyOriginal","originalNameUsage/_alt/2/_name/first","DwC doesn't fully support taxonomic redeterminations"
10
"GBIFGenusOriginal","originalNameUsage/_alt/2/_name/middle","DwC doesn't fully support taxonomic redeterminations"
11
"MinimumElevationInMeter","MinimumElevationInMeters",
12
"MaximumElevationInMeter","MaximumElevationInMeters",
inputs/GBIF/maps/DwC.specimens.full.csv
1
GBIF[DwC],"DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[institutionID=$/_ignore/inLabel]/",Comments
2
AcceptedNameUsage,AcceptedNameUsage
3
AcceptedNameUsageID,AcceptedNameUsageID
4
AssociatedMedia,AssociatedMedia
5
AssociatedOccurrences,AssociatedOccurrences
6
AssociatedReferences,AssociatedReferences
7
AssociatedSequences,AssociatedSequences
8
AssociatedTaxa,AssociatedTaxa
9
BasisOfRecord,BasisOfRecord
10
Bed,Bed
11
Behavior,Behavior
12
BoundingBox,BoundingBox
13
CatalogNO,CatalogNumber,
14
CatalogNumber,CatalogNumber
15
Class,Class
16
CollectionCD,CollectionCode,
17
CollectionCode,CollectionCode
18
CollectionID,CollectionID
19
Collector,Collector
20
CollectorNumber,CollectorNumber
21
Continent,Continent
22
ContinentOcean,ContinentOcean
23
CoordinatePrecision,CoordinatePrecision
24
CoordinateUncertaintyInMeters,CoordinateUncertaintyInMeters
25
Country,Country
26
CountryCode,CountryCode
27
County,County
28
DataGeneralizations,DataGeneralizations
29
DatasetID,DatasetID
30
DatasetName,DatasetName
31
DateIdentified,DateIdentified
32
DateLastModified,DateLastModified
33
LastDateModified,DateLastModified,
34
Day,Day
35
DayCollected,DayCollected
36
DayIdentified,DayIdentified
37
Dcterms:accessRights,Dcterms:accessRights
38
Dcterms:bibliographicCitation,Dcterms:bibliographicCitation
39
Dcterms:language,Dcterms:language
40
Dcterms:modified,Dcterms:modified
41
Dcterms:references,Dcterms:references
42
Dcterms:rights,Dcterms:rights
43
Dcterms:rightsHolder,Dcterms:rightsHolder
44
Dcterms:type,Dcterms:type
45
DecimalLatitude,DecimalLatitude
46
DecimalLongitude,DecimalLongitude
47
Disposition,Disposition
48
DynamicProperties,DynamicProperties
49
EarliestAgeOrLowestStage,EarliestAgeOrLowestStage
50
EarliestEonOrLowestEonothem,EarliestEonOrLowestEonothem
51
EarliestEpochOrLowestSeries,EarliestEpochOrLowestSeries
52
EarliestEraOrLowestErathem,EarliestEraOrLowestErathem
53
EarliestPeriodOrLowestSystem,EarliestPeriodOrLowestSystem
54
EndDayOfYear,EndDayOfYear
55
EstablishmentMeans,EstablishmentMeans
56
EventDate,EventDate
57
EventID,EventID
58
EventRemarks,EventRemarks
59
EventTime,EventTime
60
Family,Family
61
FieldNotes,FieldNotes
62
FieldNumber,FieldNumber
63
FootprintSRS,FootprintSRS
64
FootprintSpatialFit,FootprintSpatialFit
65
FootprintWKT,FootprintWKT
66
Formation,Formation
67
Genus,Genus
68
GeodeticDatum,GeodeticDatum
69
GeologicalContextID,GeologicalContextID
70
GeoreferenceProtocol,GeoreferenceProtocol
71
GeoreferenceRemarks,GeoreferenceRemarks
72
GeoreferenceSources,GeoreferenceSources
73
GeoreferenceVerificationStatus,GeoreferenceVerificationStatus
74
GeoreferencedBy,GeoreferencedBy
75
GeoreferencedDate,GeoreferencedDate
76
Group,Group
77
Habitat,Habitat
78
HigherClassification,HigherClassification
79
HigherGeography,HigherGeography
80
HigherGeographyID,HigherGeographyID
81
HighestBiostratigraphicZone,HighestBiostratigraphicZone
82
IdentificationID,IdentificationID
83
IdentificationQualifier,IdentificationQualifier
84
IdentificationReferences,IdentificationReferences
85
IdentificationRemarks,IdentificationRemarks
86
IdentificationVerificationStatus,IdentificationVerificationStatus
87
IdentifiedBy,IdentifiedBy
88
IndividualCount,IndividualCount
89
IndividualID,IndividualID
90
InformationWithheld,InformationWithheld
91
InfraspecificEpithet,InfraspecificEpithet
92
InstitutionCD,InstitutionCode,
93
InstitutionCode,InstitutionCode
94
InstitutionID,InstitutionID
95
Island,Island
96
IslandGroup,IslandGroup
97
JulianDay,JulianDay
98
Kingdom,Kingdom
99
LatestAgeOrHighestStage,LatestAgeOrHighestStage
100
LatestEonOrHighestEonothem,LatestEonOrHighestEonothem
101
LatestEpochOrHighestSeries,LatestEpochOrHighestSeries
102
LatestEraOrHighestErathem,LatestEraOrHighestErathem
103
LatestPeriodOrHighestSystem,LatestPeriodOrHighestSystem
104
Latitude,Latitude
105
LifeStage,LifeStage
106
LithostratigraphicTerms,LithostratigraphicTerms
107
Locality,Locality
108
LocationAccordingTo,LocationAccordingTo
109
LocationID,LocationID
110
LocationRemarks,LocationRemarks
111
Longitude,Longitude
112
LowestBiostratigraphicZone,LowestBiostratigraphicZone
113
MaximumDepth,MaximumDepth
114
MaximumDepthInMeters,MaximumDepthInMeters
115
MaximumDistanceAboveSurfaceInMeters,MaximumDistanceAboveSurfaceInMeters
116
MaximumElevation,MaximumElevation
117
MaximumElevationInMeter,MaximumElevationInMeters,
118
MaximumElevationInMeters,MaximumElevationInMeters
119
MeasurementAccuracy,MeasurementAccuracy
120
MeasurementDeterminedBy,MeasurementDeterminedBy
121
MeasurementDeterminedDate,MeasurementDeterminedDate
122
MeasurementID,MeasurementID
123
MeasurementMethod,MeasurementMethod
124
MeasurementRemarks,MeasurementRemarks
125
MeasurementType,MeasurementType
126
MeasurementUnit,MeasurementUnit
127
MeasurementValue,MeasurementValue
128
Member,Member
129
MinimumDepth,MinimumDepth
130
MinimumDepthInMeters,MinimumDepthInMeters
131
MinimumDistanceAboveSurfaceInMeters,MinimumDistanceAboveSurfaceInMeters
132
MinimumElevation,MinimumElevation
133
MinimumElevationInMeter,MinimumElevationInMeters,
134
MinimumElevationInMeters,MinimumElevationInMeters
135
Month,Month
136
MonthCollected,MonthCollected
137
MonthIdentified,MonthIdentified
138
Municipality,Municipality
139
NameAccordingTo,NameAccordingTo
140
NameAccordingToID,NameAccordingToID
141
NamePublishedIn,NamePublishedIn
142
NamePublishedInID,NamePublishedInID
143
NamePublishedInYear,NamePublishedInYear
144
NomenclaturalCode,NomenclaturalCode
145
NomenclaturalStatus,NomenclaturalStatus
146
Notes,Notes
147
OccurrenceID,OccurrenceID
148
OccurrenceRemarks,OccurrenceRemarks
149
OccurrenceStatus,OccurrenceStatus
150
Order,Order
151
OriginalNameUsage,OriginalNameUsage
152
OriginalNameUsageID,OriginalNameUsageID
153
OtherCatalogNumbers,OtherCatalogNumbers
154
OwnerInstitutionCode,OwnerInstitutionCode
155
ParentNameUsage,ParentNameUsage
156
ParentNameUsageID,ParentNameUsageID
157
Phylum,Phylum
158
PointRadiusSpatialFit,PointRadiusSpatialFit
159
PreparationType,PreparationType
160
Preparations,Preparations
161
PreviousCatalogNumber,PreviousCatalogNumber
162
PreviousIdentifications,PreviousIdentifications
163
RecordNumber,RecordNumber
164
RecordedBy,RecordedBy
165
RelatedCatalogItem,RelatedCatalogItem
166
RelatedResourceID,RelatedResourceID
167
RelationshipAccordingTo,RelationshipAccordingTo
168
RelationshipEstablishedDate,RelationshipEstablishedDate
169
RelationshipOfResource,RelationshipOfResource
170
RelationshipRemarks,RelationshipRemarks
171
RelationshipType,RelationshipType
172
ReproductiveCondition,ReproductiveCondition
173
ResourceID,ResourceID
174
ResourceRelationshipID,ResourceRelationshipID
175
SamplingEffort,SamplingEffort
176
SamplingProtocol,SamplingProtocol
177
ScientificName,ScientificName
178
AuthorOfScientificName,ScientificNameAuthor,
179
ScientificNameAuthor,ScientificNameAuthor
180
ScientificNameAuthorship,ScientificNameAuthorship
181
ScientificNameID,ScientificNameID
182
Sex,Sex
183
Species,Species
184
SpecificEpithet,SpecificEpithet
185
StartDayOfYear,StartDayOfYear
186
StateProvince,StateProvince
187
Subgenus,Subgenus
188
Subspecies,Subspecies
189
TaxonConceptID,TaxonConceptID
190
TaxonID,TaxonID
191
TaxonRank,TaxonRank
192
TaxonRemarks,TaxonRemarks
193
TaxonomicStatus,TaxonomicStatus
194
TimeOfDay,TimeOfDay
195
TypeStatus,TypeStatus
196
VerbatimCoordinateSystem,VerbatimCoordinateSystem
197
VerbatimCoordinates,VerbatimCoordinates
198
VerbatimDepth,VerbatimDepth
199
VerbatimElevation,VerbatimElevation
200
VerbatimEventDate,VerbatimEventDate
201
VerbatimLatitude,VerbatimLatitude
202
VerbatimLocality,VerbatimLocality
203
VerbatimLongitude,VerbatimLongitude
204
VerbatimSRS,VerbatimSRS
205
VerbatimTaxonRank,VerbatimTaxonRank
206
VernacularName,VernacularName
207
WaterBody,WaterBody
208
Year,Year
209
YearCollected,YearCollected
210
YearIdentified,YearIdentified
211
acceptedNameUsage,acceptedNameUsage
212
acceptedNameUsageID,acceptedNameUsageID
213
associatedMedia,associatedMedia
214
associatedOccurrences,associatedOccurrences
215
associatedReferences,associatedReferences
216
associatedSequences,associatedSequences
217
associatedTaxa,associatedTaxa
218
basisOfRecord,basisOfRecord
219
bed,bed
220
behavior,behavior
221
catalogNumber,catalogNumber
222
class,class
223
collectionCode,collectionCode
224
collectionID,collectionID
225
continent,continent
226
coordinatePrecision,coordinatePrecision
227
coordinateUncertaintyInMeters,coordinateUncertaintyInMeters
228
country,country
229
countryCode,countryCode
230
county,county
231
dataGeneralizations,dataGeneralizations
232
datasetID,datasetID
233
datasetName,datasetName
234
dateIdentified,dateIdentified
235
dateIdentified/_alt,dateIdentified/_alt
236
day,day
237
dcterms:accessRights,dcterms:accessRights
238
dcterms:bibliographicCitation,dcterms:bibliographicCitation
239
dcterms:language,dcterms:language
240
dcterms:modified,dcterms:modified
241
dcterms:references,dcterms:references
242
dcterms:rights,dcterms:rights
243
dcterms:rightsHolder,dcterms:rightsHolder
244
dcterms:type,dcterms:type
245
decimalLatitude,decimalLatitude
246
decimalLongitude,decimalLongitude
247
disposition,disposition
248
dynamicProperties,dynamicProperties
249
earliestAgeOrLowestStage,earliestAgeOrLowestStage
250
earliestEonOrLowestEonothem,earliestEonOrLowestEonothem
251
earliestEpochOrLowestSeries,earliestEpochOrLowestSeries
252
earliestEraOrLowestErathem,earliestEraOrLowestErathem
253
earliestPeriodOrLowestSystem,earliestPeriodOrLowestSystem
254
endDayOfYear,endDayOfYear
255
establishmentMeans,establishmentMeans
256
LatestDateCollected,eventDate,
257
eventDate,eventDate
258
eventDate/_alt,eventDate/_alt
259
eventID,eventID
260
eventRemarks,eventRemarks
261
eventTime,eventTime
262
family,family
263
fieldNotes,fieldNotes
264
fieldNumber,fieldNumber
265
footprintSRS,footprintSRS
266
footprintSpatialFit,footprintSpatialFit
267
footprintWKT,footprintWKT
268
formation,formation
269
genus,genus
270
geodeticDatum,geodeticDatum
271
geologicalContextID,geologicalContextID
272
georeferenceProtocol,georeferenceProtocol
273
georeferenceRemarks,georeferenceRemarks
274
georeferenceSources,georeferenceSources
275
georeferenceVerificationStatus,georeferenceVerificationStatus
276
georeferencedBy,georeferencedBy
277
georeferencedDate,georeferencedDate
278
group,group
279
habitat,habitat
280
higherClassification,higherClassification
281
higherGeography,higherGeography
282
higherGeographyID,higherGeographyID
283
highestBiostratigraphicZone,highestBiostratigraphicZone
284
identificationID,identificationID
285
identificationQualifier,identificationQualifier
286
identificationReferences,identificationReferences
287
identificationRemarks,identificationRemarks
288
identificationVerificationStatus,identificationVerificationStatus
289
identifiedBy,identifiedBy
290
individualCount,individualCount
291
individualID,individualID
292
informationWithheld,informationWithheld
293
infraspecificEpithet,infraspecificEpithet
294
institutionCode,institutionCode
295
institutionID,institutionID
296
island,island
297
islandGroup,islandGroup
298
kingdom,kingdom
299
latestAgeOrHighestStage,latestAgeOrHighestStage
300
latestEonOrHighestEonothem,latestEonOrHighestEonothem
301
latestEpochOrHighestSeries,latestEpochOrHighestSeries
302
latestEraOrHighestErathem,latestEraOrHighestErathem
303
latestPeriodOrHighestSystem,latestPeriodOrHighestSystem
304
lifeStage,lifeStage
305
lithostratigraphicTerms,lithostratigraphicTerms
306
locality,locality
307
locationAccordingTo,locationAccordingTo
308
locationID,locationID
309
locationRemarks,locationRemarks
310
lowestBiostratigraphicZone,lowestBiostratigraphicZone
311
maximumDepthInMeters,maximumDepthInMeters
312
maximumDistanceAboveSurfaceInMeters,maximumDistanceAboveSurfaceInMeters
313
maximumElevationInMeters,maximumElevationInMeters
314
measurementAccuracy,measurementAccuracy
315
measurementDeterminedBy,measurementDeterminedBy
316
measurementDeterminedDate,measurementDeterminedDate
317
measurementID,measurementID
318
measurementMethod,measurementMethod
319
measurementRemarks,measurementRemarks
320
measurementType,measurementType
321
measurementUnit,measurementUnit
322
measurementValue,measurementValue
323
member,member
324
minimumDepthInMeters,minimumDepthInMeters
325
minimumDistanceAboveSurfaceInMeters,minimumDistanceAboveSurfaceInMeters
326
minimumElevationInMeters,minimumElevationInMeters
327
month,month
328
municipality,municipality
329
nameAccordingTo,nameAccordingTo
330
nameAccordingToID,nameAccordingToID
331
namePublishedIn,namePublishedIn
332
namePublishedInID,namePublishedInID
333
namePublishedInYear,namePublishedInYear
334
nomenclaturalCode,nomenclaturalCode
335
nomenclaturalStatus,nomenclaturalStatus
336
occurrenceID,occurrenceID
337
occurrenceRemarks,occurrenceRemarks
338
occurrenceStatus,occurrenceStatus
339
order,order
340
originalNameUsage,originalNameUsage
341
ScientificNameOriginal,originalNameUsage/_alt/1,DwC doesn't fully support taxonomic redeterminations
342
GBIFFamilyOriginal,originalNameUsage/_alt/2/_name/first,DwC doesn't fully support taxonomic redeterminations
343
GBIFGenusOriginal,originalNameUsage/_alt/2/_name/middle,DwC doesn't fully support taxonomic redeterminations
344
originalNameUsageID,originalNameUsageID
345
otherCatalogNumbers,otherCatalogNumbers
346
ownerInstitutionCode,ownerInstitutionCode
347
parentNameUsage,parentNameUsage
348
parentNameUsageID,parentNameUsageID
349
phylum,phylum
350
pointRadiusSpatialFit,pointRadiusSpatialFit
351
preparations,preparations
352
previousIdentifications,previousIdentifications
353
recordNumber,recordNumber
354
recordedBy,recordedBy
355
relatedResourceID,relatedResourceID
356
relationshipAccordingTo,relationshipAccordingTo
357
relationshipEstablishedDate,relationshipEstablishedDate
358
relationshipOfResource,relationshipOfResource
359
relationshipRemarks,relationshipRemarks
360
reproductiveCondition,reproductiveCondition
361
resourceID,resourceID
362
resourceRelationshipID,resourceRelationshipID
363
samplingEffort,samplingEffort
364
samplingProtocol,samplingProtocol
365
scientificName,scientificName
366
scientificNameAuthorship,scientificNameAuthorship
367
scientificNameID,scientificNameID
368
sex,sex
369
specificEpithet,specificEpithet
370
startDayOfYear,startDayOfYear
371
stateProvince,stateProvince
372
subgenus,subgenus
373
taxonConceptID,taxonConceptID
374
taxonID,taxonID
375
taxonRank,taxonRank
376
taxonRemarks,taxonRemarks
377
taxonomicStatus,taxonomicStatus
378
typeStatus,typeStatus
379
verbatimCoordinateSystem,verbatimCoordinateSystem
380
verbatimCoordinates,verbatimCoordinates
381
verbatimDepth,verbatimDepth
382
verbatimElevation,verbatimElevation
383
verbatimEventDate,verbatimEventDate
384
verbatimLatitude,verbatimLatitude
385
verbatimLocality,verbatimLocality
386
verbatimLongitude,verbatimLongitude
387
verbatimSRS,verbatimSRS
388
verbatimTaxonRank,verbatimTaxonRank
389
vernacularName,vernacularName
390
waterBody,waterBody
391
year,year
inputs/GBIF/maps/VegBIEN.specimens.csv
1
GBIF[DwC],VegBIEN:/specimenreplicate,Comments,Order
2
CoordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88
3
coordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88
4
CoordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89
5
coordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89
6
BoundingBox,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
7
FootprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
8
footprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
9
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
10
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
11
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
12
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
13
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
14
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
15
Locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
16
locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
17
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
18
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
19
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
20
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
21
MaximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
22
MaximumElevationInMeter,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
23
MaximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
24
maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
25
MinimumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",,71
26
MinimumElevationInMeter,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",,71
27
MinimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",,71
28
minimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",,71
29
DecimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
30
decimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
31
Latitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
32
VerbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
33
verbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
34
DecimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
35
decimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
36
Longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
37
VerbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
38
verbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
39
MaximumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
40
MaximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
41
maximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
42
MinimumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
43
MinimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
44
minimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
45
EventDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value",,44
46
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
47
DayCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44
48
MonthCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,44
49
YearCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,44
50
LatestDateCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/2",,44
51
eventDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/2",,44
52
DateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value,,120
53
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
54
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,120
55
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,120
56
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,120
57
dateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,120
58
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
59
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
60
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
61
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
62
AuthorOfScientificName,"/*_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
63
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
64
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
65
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
66
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
67
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
68
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
69
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
70
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
71
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
72
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
73
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
74
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
75
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
76
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
77
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
78
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
79
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
80
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
81
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
82
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
83
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
84
CollectionCD,/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
85
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
86
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
87
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
88
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
89
FieldNotes,/description,,
90
Notes,/description,,
91
fieldNotes,/description,,
92
Collector,/verbatimcollectorname,,23
93
RecordedBy,/verbatimcollectorname,,23
94
recordedBy,/verbatimcollectorname,,23
95
CatalogNO,:[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
96
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
97
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
98
CollectorNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
99
RecordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
100
recordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
101
CollectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9
102
collectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9
103
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
104
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
105
InstitutionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,,8
106
institutionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,,8
107
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
108
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
109
AcceptedNameUsage,,,135
110
AcceptedNameUsageID,,,128
111
AssociatedMedia,,,36
112
AssociatedOccurrences,,,38
113
AssociatedReferences,,,37
114
AssociatedSequences,,,39
115
AssociatedTaxa,,,40
116
BasisOfRecord,,Brad: OMIT? See http://rs.tdwg.org/dwc/terms/index.htm#basisOfRecord for definition of this term.,15
117
Bed,,,117
118
Behavior,,,29
119
Continent,,Brad: OMIT,59
120
ContinentOcean,,Brad: OMIT,59
121
CountryCode,,,64
122
DataGeneralizations,,,17
123
DatasetID,,,10
124
DatasetName,,,13
125
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
126
Day,,Brad: OMIT,50
127
Dcterms:accessRights,,,5
128
Dcterms:bibliographicCitation,,,6
129
Dcterms:language,,,2
130
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
131
Dcterms:references,,,7
132
Dcterms:rights,,,3
133
Dcterms:rightsHolder,,,4
134
Dcterms:type,,,0
135
Disposition,,,33
136
DynamicProperties,,,18
137
EarliestAgeOrLowestStage,,,109
138
EarliestEonOrLowestEonothem,,,101
139
EarliestEpochOrLowestSeries,,,107
140
EarliestEraOrLowestErathem,,,103
141
EarliestPeriodOrLowestSystem,,,105
142
EndDayOfYear,,,47
143
EstablishmentMeans,,,30
144
EventID,,,41
145
EventRemarks,,,55
146
EventTime,,Brad: OMIT,45
147
FootprintSRS,,,92
148
FootprintSpatialFit,,,93
149
Formation,,,115
150
GBIFFamilyOriginal,,DwC doesn't fully support taxonomic redeterminations,137
151
GBIFGenusOriginal,,DwC doesn't fully support taxonomic redeterminations,137
152
GeodeticDatum,,,87
153
GeologicalContextID,,,100
154
GeoreferenceProtocol,,,96
155
GeoreferenceRemarks,,,99
156
GeoreferenceSources,,,97
157
GeoreferenceVerificationStatus,,,98
158
GeoreferencedBy,,Brad: Correct for VB. Nick: is there a way to specifically identify this party as collector of a specimen?,94
159
GeoreferencedDate,,,95
160
Group,,,114
161
HigherClassification,,,141
162
HigherGeography,,,58
163
HigherGeographyID,,,57
164
HighestBiostratigraphicZone,,,112
165
IdentificationID,,,118
166
IdentificationQualifier,,,124
167
IdentificationReferences,,,121
168
IdentificationRemarks,,,123
169
IdentificationVerificationStatus,,,122
170
IndividualCount,,Brad: OMIT; not relevant for DwC plant specimen data.,25
171
IndividualID,,"Brad: OMIT; db-specific element, not relevant to VB/VX",24
172
InformationWithheld,,,16
173
InstitutionCD,,,
174
InstitutionCode,,,
175
Island,,,62
176
IslandGroup,,,61
177
JulianDay,,Brad: OMIT,50
178
LastDateModified,,"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
179
LatestAgeOrHighestStage,,,110
180
LatestEonOrHighestEonothem,,,102
181
LatestEpochOrHighestSeries,,,108
182
LatestEraOrHighestErathem,,,104
183
LatestPeriodOrHighestSystem,,,106
184
LifeStage,,,27
185
LithostratigraphicTerms,,,113
186
LocationAccordingTo,,,78
187
LocationID,,,56
188
LocationRemarks,,,79
189
LowestBiostratigraphicZone,,,111
190
MaximumDistanceAboveSurfaceInMeters,,,77
191
MeasurementAccuracy,,,169
192
MeasurementDeterminedBy,,,172
193
MeasurementDeterminedDate,,,171
194
MeasurementID,,,166
195
MeasurementMethod,,,173
196
MeasurementRemarks,,,174
197
MeasurementType,,,167
198
MeasurementUnit,,,170
199
MeasurementValue,,,168
200
Member,,,116
201
MinimumDistanceAboveSurfaceInMeters,,,76
202
Month,,,49
203
Municipality,,,67
204
NameAccordingTo,,,138
205
NameAccordingToID,,,131
206
NamePublishedIn,,,139
207
NamePublishedInID,,,132
208
NamePublishedInYear,,,140
209
NomenclaturalCode,,,155
210
NomenclaturalStatus,,,157
211
OccurrenceRemarks,,,21
212
OccurrenceStatus,,,31
213
OriginalNameUsage,,,137
214
OriginalNameUsageID,,,130
215
OtherCatalogNumbers,,,34
216
OwnerInstitutionCode,,,14
217
ParentNameUsage,,,136
218
ParentNameUsageID,,,129
219
PointRadiusSpatialFit,,,90
220
PreparationType,,Brad: OMIT,32
221
Preparations,,Brad: OMIT,32
222
PreviousCatalogNumber,,?; Brad: OMIT,35
223
PreviousIdentifications,,Brad: OMIT,35
224
RelatedCatalogItem,,Brad: OMIT,161
225
RelatedResourceID,,Brad: OMIT,161
226
RelationshipAccordingTo,,,163
227
RelationshipEstablishedDate,,,164
228
RelationshipOfResource,,Brad: OMIT,162
229
RelationshipRemarks,,,165
230
RelationshipType,,Brad: OMIT,162
231
ReproductiveCondition,,,28
232
ResourceID,,,160
233
ResourceRelationshipID,,,159
234
SamplingEffort,,,43
235
SamplingProtocol,,,42
236
ScientificNameID,,,127
237
ScientificNameOriginal,,DwC doesn't fully support taxonomic redeterminations,137
238
StartDayOfYear,,,46
239
Subgenus,,,148
240
TaxonConceptID,,,133
241
TaxonID,,,126
242
TaxonRank,,,151
243
TaxonRemarks,,,158
244
TaxonomicStatus,,,156
245
TimeOfDay,,Brad: OMIT,45
246
TypeStatus,,Brad: OMIT (?). Indicates whether this specimen served as type for taxon name. Probably not relevant for BIEN,125
247
VerbatimCoordinateSystem,,,83
248
VerbatimCoordinates,,,80
249
VerbatimDepth,,,73
250
VerbatimElevation,,,70
251
VerbatimEventDate,,,51
252
VerbatimSRS,,,84
253
VerbatimTaxonRank,,,152
254
VernacularName,,,154
255
WaterBody,,,60
256
Year,,,48
257
acceptedNameUsage,,,135
258
acceptedNameUsageID,,,128
259
associatedMedia,,,36
260
associatedOccurrences,,,38
261
associatedReferences,,,37
262
associatedSequences,,,39
263
associatedTaxa,,,40
264
basisOfRecord,,Brad: OMIT? See http://rs.tdwg.org/dwc/terms/index.htm#basisOfRecord for definition of this term.,15
265
bed,,,117
266
behavior,,,29
267
continent,,Brad: OMIT,59
268
countryCode,,,64
269
dataGeneralizations,,,17
270
datasetID,,,10
271
datasetName,,,13
272
day,,Brad: OMIT,50
273
dcterms:accessRights,,,5
274
dcterms:bibliographicCitation,,,6
275
dcterms:language,,,2
276
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
277
dcterms:references,,,7
278
dcterms:rights,,,3
279
dcterms:rightsHolder,,,4
280
dcterms:type,,,0
281
disposition,,,33
282
dynamicProperties,,,18
283
earliestAgeOrLowestStage,,,109
284
earliestEonOrLowestEonothem,,,101
285
earliestEpochOrLowestSeries,,,107
286
earliestEraOrLowestErathem,,,103
287
earliestPeriodOrLowestSystem,,,105
288
endDayOfYear,,,47
289
establishmentMeans,,,30
290
eventID,,,41
291
eventRemarks,,,55
292
eventTime,,Brad: OMIT,45
293
footprintSRS,,,92
294
footprintSpatialFit,,,93
295
formation,,,115
296
geodeticDatum,,,87
297
geologicalContextID,,,100
298
georeferenceProtocol,,,96
299
georeferenceRemarks,,,99
300
georeferenceSources,,,97
301
georeferenceVerificationStatus,,,98
302
georeferencedBy,,Brad: Correct for VB. Nick: is there a way to specifically identify this party as collector of a specimen?,94
303
georeferencedDate,,,95
304
group,,,114
305
higherClassification,,,141
306
higherGeography,,,58
307
higherGeographyID,,,57
308
highestBiostratigraphicZone,,,112
309
identificationID,,,118
310
identificationQualifier,,,124
311
identificationReferences,,,121
312
identificationRemarks,,,123
313
identificationVerificationStatus,,,122
314
individualCount,,Brad: OMIT; not relevant for DwC plant specimen data.,25
315
individualID,,"Brad: OMIT; db-specific element, not relevant to VB/VX",24
316
informationWithheld,,,16
317
institutionCode,,,
318
island,,,62
319
islandGroup,,,61
320
latestAgeOrHighestStage,,,110
321
latestEonOrHighestEonothem,,,102
322
latestEpochOrHighestSeries,,,108
323
latestEraOrHighestErathem,,,104
324
latestPeriodOrHighestSystem,,,106
325
lifeStage,,,27
326
lithostratigraphicTerms,,,113
327
locationAccordingTo,,,78
328
locationID,,,56
329
locationRemarks,,,79
330
lowestBiostratigraphicZone,,,111
331
maximumDistanceAboveSurfaceInMeters,,,77
332
measurementAccuracy,,,169
333
measurementDeterminedBy,,,172
334
measurementDeterminedDate,,,171
335
measurementID,,,166
336
measurementMethod,,,173
337
measurementRemarks,,,174
338
measurementType,,,167
339
measurementUnit,,,170
340
measurementValue,,,168
341
member,,,116
342
minimumDistanceAboveSurfaceInMeters,,,76
343
month,,,49
344
municipality,,,67
345
nameAccordingTo,,,138
346
nameAccordingToID,,,131
347
namePublishedIn,,,139
348
namePublishedInID,,,132
349
namePublishedInYear,,,140
350
nomenclaturalCode,,,155
351
nomenclaturalStatus,,,157
352
occurrenceRemarks,,,21
353
occurrenceStatus,,,31
354
originalNameUsage,,,137
355
originalNameUsageID,,,130
356
otherCatalogNumbers,,,34
357
ownerInstitutionCode,,,14
358
parentNameUsage,,,136
359
parentNameUsageID,,,129
360
pointRadiusSpatialFit,,,90
361
preparations,,Brad: OMIT,32
362
previousIdentifications,,Brad: OMIT,35
363
relatedResourceID,,Brad: OMIT,161
364
relationshipAccordingTo,,,163
365
relationshipEstablishedDate,,,164
366
relationshipOfResource,,Brad: OMIT,162
367
relationshipRemarks,,,165
368
reproductiveCondition,,,28
369
resourceID,,,160
370
resourceRelationshipID,,,159
371
samplingEffort,,,43
372
samplingProtocol,,,42
373
scientificNameID,,,127
374
startDayOfYear,,,46
375
subgenus,,,148
376
taxonConceptID,,,133
377
taxonID,,,126
378
taxonRank,,,151
379
taxonRemarks,,,158
380
taxonomicStatus,,,156
381
typeStatus,,Brad: OMIT (?). Indicates whether this specimen served as type for taxon name. Probably not relevant for BIEN,125
382
verbatimCoordinateSystem,,,83
383
verbatimCoordinates,,,80
384
verbatimDepth,,,73
385
verbatimElevation,,,70
386
verbatimEventDate,,,51
387
verbatimSRS,,,84
388
verbatimTaxonRank,,,152
389
vernacularName,,,154
390
waterBody,,,60
391
year,,,48

Also available in: Unified diff