Project

General

Profile

« Previous | Next » 

Revision 1516

Added inputs/UNCC/maps

View differences:

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

Also available in: Unified diff