Project

General

Profile

« Previous | Next » 

Revision 4077

mappings/VegCSV-VegBIEN.specimens.csv: Added DwC mappings, to enable use of one VegCSV-VegBIEN mapping for specimens and plots data

View differences:

mappings/VegCSV.self.plots.csv
1 1
VegCSV[DwC],VegCSV[DwC]
2
acceptedNameUsage,acceptedNameUsage
3
acceptedNameUsageID,acceptedNameUsageID
2 4
acidity,acidity
5
associatedMedia,associatedMedia
6
associatedOccurrences,associatedOccurrences
7
associatedReferences,associatedReferences
8
associatedSequences,associatedSequences
9
associatedTaxa,associatedTaxa
3 10
basalDiameter,basalDiameter
4 11
baseSaturation,baseSaturation
12
basisOfRecord,basisOfRecord
13
bed,bed
14
behavior,behavior
5 15
calcium,calcium
6 16
canopyForm,canopyForm
7 17
canopyPosition,canopyPosition
......
11 21
censusNumber,censusNumber
12 22
class,class
13 23
clay,clay
24
collectionCode,collectionCode
25
collectionID,collectionID
14 26
communityID,communityID
15 27
communityName,communityName
16 28
computer.family,computer.family
......
21 33
computer.taxonRank,computer.taxonRank
22 34
conductivity,conductivity
23 35
continent,continent
36
coordinatePrecision,coordinatePrecision
24 37
coordinateUncertaintyInMeters,coordinateUncertaintyInMeters
25 38
country,country
39
countryCode,countryCode
26 40
county,county
27 41
coverPercent,coverPercent
42
dataGeneralizations,dataGeneralizations
43
datasetID,datasetID
44
datasetName,datasetName
45
dateCollected,dateCollected
46
dateIdentified,dateIdentified
47
day,day
48
dcterms:accessRights,dcterms:accessRights
49
dcterms:bibliographicCitation,dcterms:bibliographicCitation
50
dcterms:language,dcterms:language
51
dcterms:modified,dcterms:modified
52
dcterms:references,dcterms:references
53
dcterms:rights,dcterms:rights
54
dcterms:rightsHolder,dcterms:rightsHolder
55
dcterms:type,dcterms:type
28 56
decimalLatitude,decimalLatitude
29 57
decimalLongitude,decimalLongitude
30 58
diameterBreastHeight,diameterBreastHeight
31 59
diameterBreastHeightGentry,diameterBreastHeightGentry
60
disposition,disposition
61
dynamicProperties,dynamicProperties
62
earliestAgeOrLowestStage,earliestAgeOrLowestStage
63
earliestEonOrLowestEonothem,earliestEonOrLowestEonothem
64
earliestEpochOrLowestSeries,earliestEpochOrLowestSeries
65
earliestEraOrLowestErathem,earliestEraOrLowestErathem
66
earliestPeriodOrLowestSystem,earliestPeriodOrLowestSystem
67
endDayOfYear,endDayOfYear
68
establishmentMeans,establishmentMeans
32 69
eventDate,eventDate
70
eventID,eventID
71
eventRemarks,eventRemarks
72
eventTime,eventTime
33 73
family,family
34 74
fieldNotes,fieldNotes
35 75
fieldNumber,fieldNumber
76
footprintSRS,footprintSRS
77
footprintSpatialFit,footprintSpatialFit
36 78
footprintWKT,footprintWKT
79
formation,formation
37 80
genus,genus
81
geodeticDatum,geodeticDatum
82
geologicalContextID,geologicalContextID
83
georeferenceProtocol,georeferenceProtocol
84
georeferenceRemarks,georeferenceRemarks
85
georeferenceSources,georeferenceSources
86
georeferenceVerificationStatus,georeferenceVerificationStatus
87
georeferencedBy,georeferencedBy
88
georeferencedDate,georeferencedDate
89
group,group
38 90
growthForm,growthForm
91
habitat,habitat
39 92
height,height
40 93
heightFirstBranch,heightFirstBranch
94
higherClassification,higherClassification
95
higherGeography,higherGeography
96
higherGeographyID,higherGeographyID
97
highestBiostratigraphicZone,highestBiostratigraphicZone
98
identificationID,identificationID
41 99
identificationQualifier,identificationQualifier
100
identificationReferences,identificationReferences
101
identificationRemarks,identificationRemarks
102
identificationVerificationStatus,identificationVerificationStatus
103
identifiedBy,identifiedBy
42 104
individualCount,individualCount
43 105
individualID,individualID
106
informationWithheld,informationWithheld
44 107
infraspecificEpithet,infraspecificEpithet
108
institutionCode,institutionCode
109
institutionID,institutionID
110
island,island
111
islandGroup,islandGroup
45 112
kingdom,kingdom
46 113
landform,landform
114
latestAgeOrHighestStage,latestAgeOrHighestStage
115
latestEonOrHighestEonothem,latestEonOrHighestEonothem
116
latestEpochOrHighestSeries,latestEpochOrHighestSeries
117
latestEraOrHighestErathem,latestEraOrHighestErathem
118
latestPeriodOrHighestSystem,latestPeriodOrHighestSystem
47 119
lianaInfestation,lianaInfestation
120
lifeStage,lifeStage
121
lithostratigraphicTerms,lithostratigraphicTerms
48 122
locality,locality
123
locationAccordingTo,locationAccordingTo
49 124
locationID,locationID
125
locationRemarks,locationRemarks
126
lowestBiostratigraphicZone,lowestBiostratigraphicZone
50 127
magnesium,magnesium
51 128
maximumDepthInMeters,maximumDepthInMeters
129
maximumDistanceAboveSurfaceInMeters,maximumDistanceAboveSurfaceInMeters
52 130
maximumElevationInMeters,maximumElevationInMeters
131
measurementAccuracy,measurementAccuracy
132
measurementDeterminedBy,measurementDeterminedBy
133
measurementDeterminedDate,measurementDeterminedDate
134
measurementID,measurementID
135
measurementMethod,measurementMethod
136
measurementRemarks,measurementRemarks
137
measurementType,measurementType
138
measurementUnit,measurementUnit
139
measurementValue,measurementValue
140
member,member
53 141
minimumDepthInMeters,minimumDepthInMeters
142
minimumDistanceAboveSurfaceInMeters,minimumDistanceAboveSurfaceInMeters
54 143
minimumElevationInMeters,minimumElevationInMeters
144
month,month
145
municipality,municipality
146
nameAccordingTo,nameAccordingTo
147
nameAccordingToID,nameAccordingToID
148
namePublishedIn,namePublishedIn
149
namePublishedInID,namePublishedInID
150
namePublishedInYear,namePublishedInYear
55 151
nitrogen,nitrogen
152
nomenclaturalCode,nomenclaturalCode
153
nomenclaturalStatus,nomenclaturalStatus
154
occurrenceID,occurrenceID
155
occurrenceRemarks,occurrenceRemarks
156
occurrenceStatus,occurrenceStatus
56 157
order,order
57 158
organic,organic
159
originalNameUsage,originalNameUsage
160
originalNameUsageID,originalNameUsageID
161
otherCatalogNumbers,otherCatalogNumbers
162
ownerInstitutionCode,ownerInstitutionCode
58 163
parentLocationID,parentLocationID
164
parentNameUsage,parentNameUsage
165
parentNameUsageID,parentNameUsageID
59 166
parentPlotName,parentPlotName
60 167
ph,ph
61 168
phosphorus,phosphorus
......
65 172
plotEventStartDate,plotEventStartDate
66 173
plotName,plotName
67 174
plotNotes,plotNotes
175
pointRadiusSpatialFit,pointRadiusSpatialFit
68 176
potassium,potassium
69 177
precipitation,precipitation
178
preparations,preparations
179
previousIdentifications,previousIdentifications
70 180
previousTag,previousTag
71 181
projectID,projectID
72 182
projectName,projectName
73 183
recordNumber,recordNumber
184
recordedBy,recordedBy
74 185
recordedBy.givenName,recordedBy.givenName
75 186
recordedBy.surName,recordedBy.surName
187
relatedResourceID,relatedResourceID
188
relationshipAccordingTo,relationshipAccordingTo
189
relationshipEstablishedDate,relationshipEstablishedDate
190
relationshipOfResource,relationshipOfResource
191
relationshipRemarks,relationshipRemarks
76 192
relativePlotX,relativePlotX
77 193
relativePlotY,relativePlotY
194
reproductiveCondition,reproductiveCondition
195
resourceID,resourceID
196
resourceRelationshipID,resourceRelationshipID
197
samplingEffort,samplingEffort
78 198
samplingProtocol,samplingProtocol
79 199
sand,sand
80 200
scientificName,scientificName
81 201
scientificNameAuthorship,scientificNameAuthorship
202
scientificNameID,scientificNameID
203
sex,sex
82 204
silt,silt
83 205
slopeAspect,slopeAspect
84 206
slopeGradient,slopeGradient
85 207
sodium,sodium
86 208
specificEpithet,specificEpithet
209
startDayOfYear,startDayOfYear
87 210
stateProvince,stateProvince
88 211
stemCount,stemCount
89 212
stemNotes,stemNotes
213
subgenus,subgenus
90 214
tag,tag
215
taxonConceptID,taxonConceptID
216
taxonID,taxonID
217
taxonRank,taxonRank
218
taxonRemarks,taxonRemarks
219
taxonomicStatus,taxonomicStatus
91 220
temperature,temperature
92 221
texture,texture
222
typeStatus,typeStatus
223
verbatimCoordinateSystem,verbatimCoordinateSystem
224
verbatimCoordinates,verbatimCoordinates
225
verbatimDepth,verbatimDepth
93 226
verbatimElevation,verbatimElevation
227
verbatimEventDate,verbatimEventDate
228
verbatimLatitude,verbatimLatitude
229
verbatimLocality,verbatimLocality
230
verbatimLongitude,verbatimLongitude
231
verbatimSRS,verbatimSRS
232
verbatimTaxonRank,verbatimTaxonRank
233
vernacularName,vernacularName
94 234
volumeCanopy,volumeCanopy
95 235
voucherType,voucherType
236
waterBody,waterBody
237
year,year
mappings/VegCSV.self.organisms.csv
1 1
VegCSV[DwC],VegCSV[DwC]
2
acceptedNameUsage,acceptedNameUsage
3
acceptedNameUsageID,acceptedNameUsageID
2 4
acidity,acidity
5
associatedMedia,associatedMedia
6
associatedOccurrences,associatedOccurrences
7
associatedReferences,associatedReferences
8
associatedSequences,associatedSequences
9
associatedTaxa,associatedTaxa
3 10
basalDiameter,basalDiameter
4 11
baseSaturation,baseSaturation
12
basisOfRecord,basisOfRecord
13
bed,bed
14
behavior,behavior
5 15
calcium,calcium
6 16
canopyForm,canopyForm
7 17
canopyPosition,canopyPosition
......
11 21
censusNumber,censusNumber
12 22
class,class
13 23
clay,clay
24
collectionCode,collectionCode
25
collectionID,collectionID
14 26
communityID,communityID
15 27
communityName,communityName
16 28
computer.family,computer.family
......
21 33
computer.taxonRank,computer.taxonRank
22 34
conductivity,conductivity
23 35
continent,continent
36
coordinatePrecision,coordinatePrecision
24 37
coordinateUncertaintyInMeters,coordinateUncertaintyInMeters
25 38
country,country
39
countryCode,countryCode
26 40
county,county
27 41
coverPercent,coverPercent
42
dataGeneralizations,dataGeneralizations
43
datasetID,datasetID
44
datasetName,datasetName
45
dateCollected,dateCollected
46
dateIdentified,dateIdentified
47
day,day
48
dcterms:accessRights,dcterms:accessRights
49
dcterms:bibliographicCitation,dcterms:bibliographicCitation
50
dcterms:language,dcterms:language
51
dcterms:modified,dcterms:modified
52
dcterms:references,dcterms:references
53
dcterms:rights,dcterms:rights
54
dcterms:rightsHolder,dcterms:rightsHolder
55
dcterms:type,dcterms:type
28 56
decimalLatitude,decimalLatitude
29 57
decimalLongitude,decimalLongitude
30 58
diameterBreastHeight,diameterBreastHeight
31 59
diameterBreastHeightGentry,diameterBreastHeightGentry
60
disposition,disposition
61
dynamicProperties,dynamicProperties
62
earliestAgeOrLowestStage,earliestAgeOrLowestStage
63
earliestEonOrLowestEonothem,earliestEonOrLowestEonothem
64
earliestEpochOrLowestSeries,earliestEpochOrLowestSeries
65
earliestEraOrLowestErathem,earliestEraOrLowestErathem
66
earliestPeriodOrLowestSystem,earliestPeriodOrLowestSystem
67
endDayOfYear,endDayOfYear
68
establishmentMeans,establishmentMeans
32 69
eventDate,eventDate
70
eventID,eventID
71
eventRemarks,eventRemarks
72
eventTime,eventTime
33 73
family,family
34 74
fieldNotes,fieldNotes
35 75
fieldNumber,fieldNumber
76
footprintSRS,footprintSRS
77
footprintSpatialFit,footprintSpatialFit
36 78
footprintWKT,footprintWKT
79
formation,formation
37 80
genus,genus
81
geodeticDatum,geodeticDatum
82
geologicalContextID,geologicalContextID
83
georeferenceProtocol,georeferenceProtocol
84
georeferenceRemarks,georeferenceRemarks
85
georeferenceSources,georeferenceSources
86
georeferenceVerificationStatus,georeferenceVerificationStatus
87
georeferencedBy,georeferencedBy
88
georeferencedDate,georeferencedDate
89
group,group
38 90
growthForm,growthForm
91
habitat,habitat
39 92
height,height
40 93
heightFirstBranch,heightFirstBranch
94
higherClassification,higherClassification
95
higherGeography,higherGeography
96
higherGeographyID,higherGeographyID
97
highestBiostratigraphicZone,highestBiostratigraphicZone
98
identificationID,identificationID
41 99
identificationQualifier,identificationQualifier
100
identificationReferences,identificationReferences
101
identificationRemarks,identificationRemarks
102
identificationVerificationStatus,identificationVerificationStatus
103
identifiedBy,identifiedBy
42 104
individualCount,individualCount
43 105
individualID,individualID
106
informationWithheld,informationWithheld
44 107
infraspecificEpithet,infraspecificEpithet
108
institutionCode,institutionCode
109
institutionID,institutionID
110
island,island
111
islandGroup,islandGroup
45 112
kingdom,kingdom
46 113
landform,landform
114
latestAgeOrHighestStage,latestAgeOrHighestStage
115
latestEonOrHighestEonothem,latestEonOrHighestEonothem
116
latestEpochOrHighestSeries,latestEpochOrHighestSeries
117
latestEraOrHighestErathem,latestEraOrHighestErathem
118
latestPeriodOrHighestSystem,latestPeriodOrHighestSystem
47 119
lianaInfestation,lianaInfestation
120
lifeStage,lifeStage
121
lithostratigraphicTerms,lithostratigraphicTerms
48 122
locality,locality
123
locationAccordingTo,locationAccordingTo
49 124
locationID,locationID
125
locationRemarks,locationRemarks
126
lowestBiostratigraphicZone,lowestBiostratigraphicZone
50 127
magnesium,magnesium
51 128
maximumDepthInMeters,maximumDepthInMeters
129
maximumDistanceAboveSurfaceInMeters,maximumDistanceAboveSurfaceInMeters
52 130
maximumElevationInMeters,maximumElevationInMeters
131
measurementAccuracy,measurementAccuracy
132
measurementDeterminedBy,measurementDeterminedBy
133
measurementDeterminedDate,measurementDeterminedDate
134
measurementID,measurementID
135
measurementMethod,measurementMethod
136
measurementRemarks,measurementRemarks
137
measurementType,measurementType
138
measurementUnit,measurementUnit
139
measurementValue,measurementValue
140
member,member
53 141
minimumDepthInMeters,minimumDepthInMeters
142
minimumDistanceAboveSurfaceInMeters,minimumDistanceAboveSurfaceInMeters
54 143
minimumElevationInMeters,minimumElevationInMeters
144
month,month
145
municipality,municipality
146
nameAccordingTo,nameAccordingTo
147
nameAccordingToID,nameAccordingToID
148
namePublishedIn,namePublishedIn
149
namePublishedInID,namePublishedInID
150
namePublishedInYear,namePublishedInYear
55 151
nitrogen,nitrogen
152
nomenclaturalCode,nomenclaturalCode
153
nomenclaturalStatus,nomenclaturalStatus
154
occurrenceID,occurrenceID
155
occurrenceRemarks,occurrenceRemarks
156
occurrenceStatus,occurrenceStatus
56 157
order,order
57 158
organic,organic
159
originalNameUsage,originalNameUsage
160
originalNameUsageID,originalNameUsageID
161
otherCatalogNumbers,otherCatalogNumbers
162
ownerInstitutionCode,ownerInstitutionCode
58 163
parentLocationID,parentLocationID
164
parentNameUsage,parentNameUsage
165
parentNameUsageID,parentNameUsageID
59 166
parentPlotName,parentPlotName
60 167
ph,ph
61 168
phosphorus,phosphorus
......
65 172
plotEventStartDate,plotEventStartDate
66 173
plotName,plotName
67 174
plotNotes,plotNotes
175
pointRadiusSpatialFit,pointRadiusSpatialFit
68 176
potassium,potassium
69 177
precipitation,precipitation
178
preparations,preparations
179
previousIdentifications,previousIdentifications
70 180
previousTag,previousTag
71 181
projectID,projectID
72 182
projectName,projectName
73 183
recordNumber,recordNumber
184
recordedBy,recordedBy
74 185
recordedBy.givenName,recordedBy.givenName
75 186
recordedBy.surName,recordedBy.surName
187
relatedResourceID,relatedResourceID
188
relationshipAccordingTo,relationshipAccordingTo
189
relationshipEstablishedDate,relationshipEstablishedDate
190
relationshipOfResource,relationshipOfResource
191
relationshipRemarks,relationshipRemarks
76 192
relativePlotX,relativePlotX
77 193
relativePlotY,relativePlotY
194
reproductiveCondition,reproductiveCondition
195
resourceID,resourceID
196
resourceRelationshipID,resourceRelationshipID
197
samplingEffort,samplingEffort
78 198
samplingProtocol,samplingProtocol
79 199
sand,sand
80 200
scientificName,scientificName
81 201
scientificNameAuthorship,scientificNameAuthorship
202
scientificNameID,scientificNameID
203
sex,sex
82 204
silt,silt
83 205
slopeAspect,slopeAspect
84 206
slopeGradient,slopeGradient
85 207
sodium,sodium
86 208
specificEpithet,specificEpithet
209
startDayOfYear,startDayOfYear
87 210
stateProvince,stateProvince
88 211
stemCount,stemCount
89 212
stemNotes,stemNotes
213
subgenus,subgenus
90 214
tag,tag
215
taxonConceptID,taxonConceptID
216
taxonID,taxonID
217
taxonRank,taxonRank
218
taxonRemarks,taxonRemarks
219
taxonomicStatus,taxonomicStatus
91 220
temperature,temperature
92 221
texture,texture
222
typeStatus,typeStatus
223
verbatimCoordinateSystem,verbatimCoordinateSystem
224
verbatimCoordinates,verbatimCoordinates
225
verbatimDepth,verbatimDepth
93 226
verbatimElevation,verbatimElevation
227
verbatimEventDate,verbatimEventDate
228
verbatimLatitude,verbatimLatitude
229
verbatimLocality,verbatimLocality
230
verbatimLongitude,verbatimLongitude
231
verbatimSRS,verbatimSRS
232
verbatimTaxonRank,verbatimTaxonRank
233
vernacularName,vernacularName
94 234
volumeCanopy,volumeCanopy
95 235
voucherType,voucherType
236
waterBody,waterBody
237
year,year
mappings/VegCSV-VegBIEN.specimens.csv
1
"VegCSV[DwC]","VegBIEN:","Comments"
2
"plotArea","/location/area",
3
"plotName","/location/authorlocationcode/_alt/1",
4
"fieldNumber","/location/authorlocationcode/_alt/2",
5
"voucherType","/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left",
6
"catalogNumber","/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/else",
7
"verbatimElevation","/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
8
"maximumElevationInMeters","/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
9
"minimumElevationInMeters","/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
10
"minimumElevationInMeters","/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
11
"maximumElevationInMeters","/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
12
"minimumElevationInMeters","/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
13
"landform","/location/landform",
14
"coordinateUncertaintyInMeters","/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1",
15
"footprintWKT","/location/locationdetermination/footprintgeometry_dwc",
16
"decimalLatitude","/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
17
"decimalLongitude","/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
18
"county","/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
19
"stateProvince","/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
20
"country","/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
21
"continent","/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
22
"samplingProtocol","/location/locationevent/*_id/method/name",
23
"projectName","/location/locationevent/*_id/project/projectname",
24
"projectID","/location/locationevent/*_id/project/sourceaccessioncode",
25
"fieldNumber","/location/locationevent/authoreventcode",
26
"communityID","/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname",
27
"communityName","/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription",
28
"plotEventEndDate","/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value",
29
"eventDate","/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1",
30
"plotEventStartDate","/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value",
31
"eventDate","/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1",
32
"precipitation","/location/locationevent/precipitation",
33
"acidity","/location/locationevent/soilobs/acidity",
34
"baseSaturation","/location/locationevent/soilobs/basesaturation",
35
"calcium","/location/locationevent/soilobs/calcium",
36
"carbon","/location/locationevent/soilobs/carbon",
37
"cationExchangeCapacity","/location/locationevent/soilobs/cationexchangecapacity",
38
"clay","/location/locationevent/soilobs/clay",
39
"conductivity","/location/locationevent/soilobs/conductivity",
40
"magnesium","/location/locationevent/soilobs/magnesium",
41
"nitrogen","/location/locationevent/soilobs/nitrogen",
42
"organic","/location/locationevent/soilobs/organic",
43
"ph","/location/locationevent/soilobs/ph",
44
"phosphorus","/location/locationevent/soilobs/phosphorus",
45
"potassium","/location/locationevent/soilobs/potassium",
46
"sand","/location/locationevent/soilobs/sand",
47
"silt","/location/locationevent/soilobs/silt",
48
"sodium","/location/locationevent/soilobs/sodium",
49
"texture","/location/locationevent/soilobs/texture",
50
"individualCount","/location/locationevent/taxonoccurrence/aggregateoccurrence/count",
51
"coverPercent","/location/locationevent/taxonoccurrence/aggregateoccurrence/cover",
52
"censusNumber","/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue",
53
"volumeCanopy","/location/locationevent/taxonoccurrence/aggregateoccurrence/linecover",
54
"fieldNotes","/location/locationevent/taxonoccurrence/aggregateoccurrence/notes",
55
"recordNumber","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber",
56
"individualID","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode",
57
"voucherType","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left",
58
"catalogNumber","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
59
"stemCount","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount",
60
"basalDiameter","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/basaldiameter",
61
"canopyForm","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyForm]]:[@fkey=tablerecord_id]/definedvalue",
62
"canopyPosition","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyPosition]]:[@fkey=tablerecord_id]/definedvalue",
63
"diameterBreastHeightGentry","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=gentryDiameter]]:[@fkey=tablerecord_id]/definedvalue",
64
"lianaInfestation","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=lianaInfestation]]:[@fkey=tablerecord_id]/definedvalue",
65
"stemNotes","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=notes]]:[@fkey=tablerecord_id]/definedvalue",
66
"diameterBreastHeight","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight",
67
"height","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height",
68
"heightFirstBranch","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/heightfirstbranch",
69
"tag","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag","Quotes sort it before tag2"
70
"previousTag","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[iscurrent=true]:[../stemtag?[iscurrent/_alt/2=true]/iscurrent/_alt/1=false]/tag",
71
"relativePlotX","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition",
72
"relativePlotY","/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition",
73
"recordNumber","/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1",
74
"scientificName","/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2",
75
"growthForm","/location/locationevent/taxonoccurrence/growthform",
76
"individualID","/location/locationevent/taxonoccurrence/sourceaccessioncode",
77
"computer.scientificNameAuthorship","/location/locationevent/taxonoccurrence/taxondetermination[role=computer]/*_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",
78
"computer.taxonRank","/location/locationevent/taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/first",
79
"computer.infraspecificEpithet","/location/locationevent/taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
80
"computer.specificEpithet","/location/locationevent/taxonoccurrence/taxondetermination[role=computer]/*_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",
81
"computer.genus","/location/locationevent/taxonoccurrence/taxondetermination[role=computer]/*_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",
82
"computer.family","/location/locationevent/taxonoccurrence/taxondetermination[role=computer]/*_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",
83
"scientificName","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
84
"scientificNameAuthorship","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
85
"infraspecificEpithet","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
86
"specificEpithet","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
87
"genus","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
88
"family","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
89
"order","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
90
"class","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
91
"phylum","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
92
"kingdom","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
93
"identificationQualifier","/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/taxonfit",
94
"recordedBy.givenName","/location/locationevent/taxonoccurrence/verbatimcollectorname/_name/first",
95
"recordedBy.surName","/location/locationevent/taxonoccurrence/verbatimcollectorname/_name/last",
96
"voucherType","/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left",
97
"catalogNumber","/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
98
"temperature","/location/locationevent/temperature",
99
"maximumDepthInMeters","/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
100
"minimumDepthInMeters","/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
101
"locality","/location/locationnarrative/_merge/1",
102
"plotNotes","/location/notespublic",
103
"parentPlotName","/location/parent_id/location/authorlocationcode",
104
"parentLocationID","/location/parent_id/location/sourceaccessioncode",
105
"slopeAspect","/location/slopeaspect/_compass/value",
106
"slopeGradient","/location/slopegradient",
107
"locationID","/location/sourceaccessioncode",
1
VegCSV[DwC],VegBIEN:,Comments
2
plotArea,/location/area,
3
plotName,/location/authorlocationcode/_alt/1,
4
fieldNumber,/location/authorlocationcode/_alt/2,
5
occurrenceID,/location/authorlocationcode/_alt/3,
6
institutionCode,/location/authorlocationcode/_alt/4/_merge/1,
7
collectionCode,/location/authorlocationcode/_alt/4/_merge/2/_merge/1,
8
collectionID,/location/authorlocationcode/_alt/4/_merge/2/_merge/2,
9
voucherType,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left",
10
catalogNumber,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/else",
11
verbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
12
maximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
13
minimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
14
minimumElevationInMeters,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
15
maximumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
16
minimumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
17
landform,/location/landform,
18
coordinateUncertaintyInMeters,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,
19
coordinatePrecision,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,
20
footprintWKT,/location/locationdetermination/footprintgeometry_dwc,
21
decimalLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
22
verbatimLatitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
23
decimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
24
verbatimLongitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
25
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
26
stateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
27
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
28
continent,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
29
samplingProtocol,/location/locationevent/*_id/method/name,
30
projectName,/location/locationevent/*_id/project/projectname,
31
projectID,/location/locationevent/*_id/project/sourceaccessioncode,
32
fieldNumber,/location/locationevent/authoreventcode,
33
communityID,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
34
communityName,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,
35
plotEventEndDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value,
36
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1,
37
dateCollected,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2,
38
plotEventStartDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,
39
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1,
40
dateCollected,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2,
41
precipitation,/location/locationevent/precipitation,
42
acidity,/location/locationevent/soilobs/acidity,
43
baseSaturation,/location/locationevent/soilobs/basesaturation,
44
calcium,/location/locationevent/soilobs/calcium,
45
carbon,/location/locationevent/soilobs/carbon,
46
cationExchangeCapacity,/location/locationevent/soilobs/cationexchangecapacity,
47
clay,/location/locationevent/soilobs/clay,
48
conductivity,/location/locationevent/soilobs/conductivity,
49
magnesium,/location/locationevent/soilobs/magnesium,
50
nitrogen,/location/locationevent/soilobs/nitrogen,
51
organic,/location/locationevent/soilobs/organic,
52
ph,/location/locationevent/soilobs/ph,
53
phosphorus,/location/locationevent/soilobs/phosphorus,
54
potassium,/location/locationevent/soilobs/potassium,
55
sand,/location/locationevent/soilobs/sand,
56
silt,/location/locationevent/soilobs/silt,
57
sodium,/location/locationevent/soilobs/sodium,
58
texture,/location/locationevent/soilobs/texture,
59
dateCollected,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date,
60
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
61
coverPercent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover,
62
censusNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue",
63
volumeCanopy,/location/locationevent/taxonoccurrence/aggregateoccurrence/linecover,
64
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
65
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber,
66
sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,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"
67
individualID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
68
voucherType,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left",
69
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
70
collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_merge/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name
71
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_merge/2,
72
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
73
occurrenceID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
74
stemCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount,
75
basalDiameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/basaldiameter,
76
canopyForm,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyForm]]:[@fkey=tablerecord_id]/definedvalue",
77
canopyPosition,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyPosition]]:[@fkey=tablerecord_id]/definedvalue",
78
diameterBreastHeightGentry,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=gentryDiameter]]:[@fkey=tablerecord_id]/definedvalue",
79
lianaInfestation,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=lianaInfestation]]:[@fkey=tablerecord_id]/definedvalue",
80
stemNotes,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=notes]]:[@fkey=tablerecord_id]/definedvalue",
81
diameterBreastHeight,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight,
82
height,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height,
83
heightFirstBranch,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/heightfirstbranch,
84
tag,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2
85
previousTag,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[iscurrent=true]:[../stemtag?[iscurrent/_alt/2=true]/iscurrent/_alt/1=false]/tag,
86
relativePlotX,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition,
87
relativePlotY,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition,
88
recordNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1,
89
scientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2,
90
growthForm,/location/locationevent/taxonoccurrence/growthform,
91
establishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value",
92
establishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value",
93
individualID,/location/locationevent/taxonoccurrence/sourceaccessioncode,
94
computer.scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[role=computer]/*_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",
95
computer.taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/first",
96
computer.infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=computer]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
97
computer.specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=computer]/*_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",
98
computer.genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=computer]/*_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",
99
computer.family,"/location/locationevent/taxonoccurrence/taxondetermination[role=computer]/*_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",
100
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
101
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
102
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last,
103
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
104
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
105
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
106
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
107
genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
108
family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
109
order,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
110
class,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
111
phylum,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
112
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
113
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/determinationdate/_*/date/_dateRangeStart/value,
114
taxonRemarks,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/notes,
115
identificationQualifier,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/taxonfit,
116
recordedBy,/location/locationevent/taxonoccurrence/verbatimcollectorname,
117
recordedBy.givenName,/location/locationevent/taxonoccurrence/verbatimcollectorname/_name/first,
118
recordedBy.surName,/location/locationevent/taxonoccurrence/verbatimcollectorname/_name/last,
119
voucherType,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left",
120
catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
121
temperature,/location/locationevent/temperature,
122
maximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
123
minimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
124
locality,/location/locationnarrative/_merge/1,
125
verbatimLocality,/location/locationnarrative/_merge/2,
126
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
127
plotNotes,/location/notespublic,
128
parentPlotName,/location/parent_id/location/authorlocationcode,
129
parentLocationID,/location/parent_id/location/sourceaccessioncode,
130
slopeAspect,/location/slopeaspect/_compass/value,
131
slopeGradient,/location/slopegradient,
132
locationID,/location/sourceaccessioncode,
133
acceptedNameUsage,,
134
acceptedNameUsageID,,
135
associatedMedia,,
136
associatedOccurrences,,
137
associatedReferences,,
138
associatedSequences,,
139
associatedTaxa,,
140
basisOfRecord,,Brad: OMIT? See http://rs.tdwg.org/dwc/terms/index.htm#basisOfRecord for definition of this term.
141
bed,,
142
behavior,,
143
countryCode,,
144
dataGeneralizations,,
145
datasetID,,
146
datasetName,,
147
day,,Brad: OMIT
148
dcterms:accessRights,,
149
dcterms:bibliographicCitation,,
150
dcterms:language,,
151
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."
152
dcterms:references,,
153
dcterms:rights,,
154
dcterms:rightsHolder,,
155
dcterms:type,,
156
disposition,,
157
dynamicProperties,,
158
earliestAgeOrLowestStage,,
159
earliestEonOrLowestEonothem,,
160
earliestEpochOrLowestSeries,,
161
earliestEraOrLowestErathem,,
162
earliestPeriodOrLowestSystem,,
163
endDayOfYear,,
164
eventID,,
165
eventRemarks,,
166
eventTime,,Brad: OMIT
167
footprintSRS,,
168
footprintSpatialFit,,
169
formation,,
170
geodeticDatum,,
171
geologicalContextID,,
172
georeferenceProtocol,,
173
georeferenceRemarks,,
174
georeferenceSources,,
175
georeferenceVerificationStatus,,
176
georeferencedBy,,
177
georeferencedDate,,
178
group,,
179
higherClassification,,
180
higherGeography,,
181
higherGeographyID,,
182
highestBiostratigraphicZone,,
183
identificationID,,
184
identificationReferences,,
185
identificationRemarks,,
186
identificationVerificationStatus,,
187
informationWithheld,,
188
institutionID,,
189
island,,
190
islandGroup,,
191
latestAgeOrHighestStage,,
192
latestEonOrHighestEonothem,,
193
latestEpochOrHighestSeries,,
194
latestEraOrHighestErathem,,
195
latestPeriodOrHighestSystem,,
196
lifeStage,,
197
lithostratigraphicTerms,,
198
locationAccordingTo,,
199
locationRemarks,,
200
lowestBiostratigraphicZone,,
201
maximumDistanceAboveSurfaceInMeters,,
202
measurementAccuracy,,
203
measurementDeterminedBy,,
204
measurementDeterminedDate,,
205
measurementID,,
206
measurementMethod,,
207
measurementRemarks,,
208
measurementType,,
209
measurementUnit,,
210
measurementValue,,
211
member,,
212
minimumDistanceAboveSurfaceInMeters,,
213
month,,
214
municipality,,
215
nameAccordingTo,,
216
nameAccordingToID,,
217
namePublishedIn,,
218
namePublishedInID,,
219
namePublishedInYear,,
220
nomenclaturalCode,,
221
nomenclaturalStatus,,
222
occurrenceRemarks,,
223
occurrenceStatus,,
224
originalNameUsage,,
225
originalNameUsageID,,
226
otherCatalogNumbers,,
227
ownerInstitutionCode,,
228
parentNameUsage,,
229
parentNameUsageID,,
230
pointRadiusSpatialFit,,
231
preparations,,Brad: OMIT
232
previousIdentifications,,Brad: OMIT
233
relatedResourceID,,Brad: OMIT
234
relationshipAccordingTo,,
235
relationshipEstablishedDate,,
236
relationshipOfResource,,Brad: OMIT
237
relationshipRemarks,,
238
reproductiveCondition,,
239
resourceID,,
240
resourceRelationshipID,,
241
samplingEffort,,
242
scientificNameID,,
243
startDayOfYear,,
244
subgenus,,
245
taxonConceptID,,
246
taxonID,,
247
taxonRank,,
248
taxonomicStatus,,
249
typeStatus,,Brad: OMIT (?). Indicates whether this specimen served as type for taxon name. Probably not relevant for BIEN
250
verbatimCoordinateSystem,,
251
verbatimCoordinates,,
252
verbatimDepth,,
253
verbatimEventDate,,
254
verbatimSRS,,
255
verbatimTaxonRank,,
256
vernacularName,,
257
waterBody,,
258
year,,
mappings/for_review/VegCSV-VegBIEN.specimens.csv
62 62
censusNumber,"//aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]/definedvalue",
63 63
volumeCanopy,//aggregateoccurrence/linecover,
64 64
fieldNotes,//aggregateoccurrence/notes,
65
recordNumber,//plantobservation/authorplantcode,
65
recordNumber,//plantobservation/collectionnumber,
66 66
sex,"//plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"
67 67
individualID,//plantobservation/sourceaccessioncode,
68 68
voucherType,"//specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond",
69 69
catalogNumber,"//specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
70 70
collectionCode,//specimenreplicate/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name
71 71
collectionID,//specimenreplicate/collectioncode_dwc,
72
recordNumber,//specimenreplicate/collectionnumber,
73 72
institutionCode,//party/organizationname,
74 73
occurrenceID,//specimenreplicate/sourceaccessioncode,
75 74
stemCount,//plantobservation/stemcount,
mappings/VegCSV.self.stems.csv
1 1
VegCSV[DwC],VegCSV[DwC]
2
acceptedNameUsage,acceptedNameUsage
3
acceptedNameUsageID,acceptedNameUsageID
2 4
acidity,acidity
5
associatedMedia,associatedMedia
6
associatedOccurrences,associatedOccurrences
7
associatedReferences,associatedReferences
8
associatedSequences,associatedSequences
9
associatedTaxa,associatedTaxa
3 10
basalDiameter,basalDiameter
4 11
baseSaturation,baseSaturation
12
basisOfRecord,basisOfRecord
13
bed,bed
14
behavior,behavior
5 15
calcium,calcium
6 16
canopyForm,canopyForm
7 17
canopyPosition,canopyPosition
......
11 21
censusNumber,censusNumber
12 22
class,class
13 23
clay,clay
24
collectionCode,collectionCode
25
collectionID,collectionID
14 26
communityID,communityID
15 27
communityName,communityName
16 28
computer.family,computer.family
......
21 33
computer.taxonRank,computer.taxonRank
22 34
conductivity,conductivity
23 35
continent,continent
36
coordinatePrecision,coordinatePrecision
24 37
coordinateUncertaintyInMeters,coordinateUncertaintyInMeters
25 38
country,country
39
countryCode,countryCode
26 40
county,county
27 41
coverPercent,coverPercent
42
dataGeneralizations,dataGeneralizations
43
datasetID,datasetID
44
datasetName,datasetName
45
dateCollected,dateCollected
46
dateIdentified,dateIdentified
47
day,day
48
dcterms:accessRights,dcterms:accessRights
49
dcterms:bibliographicCitation,dcterms:bibliographicCitation
50
dcterms:language,dcterms:language
51
dcterms:modified,dcterms:modified
52
dcterms:references,dcterms:references
53
dcterms:rights,dcterms:rights
54
dcterms:rightsHolder,dcterms:rightsHolder
55
dcterms:type,dcterms:type
28 56
decimalLatitude,decimalLatitude
29 57
decimalLongitude,decimalLongitude
30 58
diameterBreastHeight,diameterBreastHeight
31 59
diameterBreastHeightGentry,diameterBreastHeightGentry
60
disposition,disposition
61
dynamicProperties,dynamicProperties
62
earliestAgeOrLowestStage,earliestAgeOrLowestStage
63
earliestEonOrLowestEonothem,earliestEonOrLowestEonothem
64
earliestEpochOrLowestSeries,earliestEpochOrLowestSeries
65
earliestEraOrLowestErathem,earliestEraOrLowestErathem
66
earliestPeriodOrLowestSystem,earliestPeriodOrLowestSystem
67
endDayOfYear,endDayOfYear
68
establishmentMeans,establishmentMeans
32 69
eventDate,eventDate
70
eventID,eventID
71
eventRemarks,eventRemarks
72
eventTime,eventTime
33 73
family,family
34 74
fieldNotes,fieldNotes
35 75
fieldNumber,fieldNumber
76
footprintSRS,footprintSRS
77
footprintSpatialFit,footprintSpatialFit
36 78
footprintWKT,footprintWKT
79
formation,formation
37 80
genus,genus
81
geodeticDatum,geodeticDatum
82
geologicalContextID,geologicalContextID
83
georeferenceProtocol,georeferenceProtocol
84
georeferenceRemarks,georeferenceRemarks
85
georeferenceSources,georeferenceSources
86
georeferenceVerificationStatus,georeferenceVerificationStatus
87
georeferencedBy,georeferencedBy
88
georeferencedDate,georeferencedDate
89
group,group
38 90
growthForm,growthForm
91
habitat,habitat
39 92
height,height
40 93
heightFirstBranch,heightFirstBranch
94
higherClassification,higherClassification
95
higherGeography,higherGeography
96
higherGeographyID,higherGeographyID
97
highestBiostratigraphicZone,highestBiostratigraphicZone
98
identificationID,identificationID
41 99
identificationQualifier,identificationQualifier
100
identificationReferences,identificationReferences
101
identificationRemarks,identificationRemarks
102
identificationVerificationStatus,identificationVerificationStatus
103
identifiedBy,identifiedBy
42 104
individualCount,individualCount
43 105
individualID,individualID
106
informationWithheld,informationWithheld
44 107
infraspecificEpithet,infraspecificEpithet
108
institutionCode,institutionCode
109
institutionID,institutionID
110
island,island
111
islandGroup,islandGroup
45 112
kingdom,kingdom
46 113
landform,landform
114
latestAgeOrHighestStage,latestAgeOrHighestStage
115
latestEonOrHighestEonothem,latestEonOrHighestEonothem
116
latestEpochOrHighestSeries,latestEpochOrHighestSeries
117
latestEraOrHighestErathem,latestEraOrHighestErathem
118
latestPeriodOrHighestSystem,latestPeriodOrHighestSystem
47 119
lianaInfestation,lianaInfestation
120
lifeStage,lifeStage
121
lithostratigraphicTerms,lithostratigraphicTerms
48 122
locality,locality
123
locationAccordingTo,locationAccordingTo
49 124
locationID,locationID
125
locationRemarks,locationRemarks
126
lowestBiostratigraphicZone,lowestBiostratigraphicZone
50 127
magnesium,magnesium
51 128
maximumDepthInMeters,maximumDepthInMeters
129
maximumDistanceAboveSurfaceInMeters,maximumDistanceAboveSurfaceInMeters
52 130
maximumElevationInMeters,maximumElevationInMeters
131
measurementAccuracy,measurementAccuracy
132
measurementDeterminedBy,measurementDeterminedBy
133
measurementDeterminedDate,measurementDeterminedDate
134
measurementID,measurementID
135
measurementMethod,measurementMethod
136
measurementRemarks,measurementRemarks
137
measurementType,measurementType
138
measurementUnit,measurementUnit
139
measurementValue,measurementValue
140
member,member
53 141
minimumDepthInMeters,minimumDepthInMeters
142
minimumDistanceAboveSurfaceInMeters,minimumDistanceAboveSurfaceInMeters
54 143
minimumElevationInMeters,minimumElevationInMeters
144
month,month
145
municipality,municipality
146
nameAccordingTo,nameAccordingTo
147
nameAccordingToID,nameAccordingToID
148
namePublishedIn,namePublishedIn
149
namePublishedInID,namePublishedInID
150
namePublishedInYear,namePublishedInYear
55 151
nitrogen,nitrogen
152
nomenclaturalCode,nomenclaturalCode
153
nomenclaturalStatus,nomenclaturalStatus
154
occurrenceID,occurrenceID
155
occurrenceRemarks,occurrenceRemarks
156
occurrenceStatus,occurrenceStatus
56 157
order,order
57 158
organic,organic
159
originalNameUsage,originalNameUsage
160
originalNameUsageID,originalNameUsageID
161
otherCatalogNumbers,otherCatalogNumbers
162
ownerInstitutionCode,ownerInstitutionCode
58 163
parentLocationID,parentLocationID
164
parentNameUsage,parentNameUsage
165
parentNameUsageID,parentNameUsageID
59 166
parentPlotName,parentPlotName
60 167
ph,ph
61 168
phosphorus,phosphorus
......
65 172
plotEventStartDate,plotEventStartDate
66 173
plotName,plotName
67 174
plotNotes,plotNotes
175
pointRadiusSpatialFit,pointRadiusSpatialFit
68 176
potassium,potassium
69 177
precipitation,precipitation
178
preparations,preparations
179
previousIdentifications,previousIdentifications
70 180
previousTag,previousTag
71 181
projectID,projectID
72 182
projectName,projectName
73 183
recordNumber,recordNumber
184
recordedBy,recordedBy
74 185
recordedBy.givenName,recordedBy.givenName
75 186
recordedBy.surName,recordedBy.surName
187
relatedResourceID,relatedResourceID
188
relationshipAccordingTo,relationshipAccordingTo
189
relationshipEstablishedDate,relationshipEstablishedDate
190
relationshipOfResource,relationshipOfResource
191
relationshipRemarks,relationshipRemarks
76 192
relativePlotX,relativePlotX
77 193
relativePlotY,relativePlotY
194
reproductiveCondition,reproductiveCondition
195
resourceID,resourceID
196
resourceRelationshipID,resourceRelationshipID
197
samplingEffort,samplingEffort
78 198
samplingProtocol,samplingProtocol
79 199
sand,sand
80 200
scientificName,scientificName
81 201
scientificNameAuthorship,scientificNameAuthorship
202
scientificNameID,scientificNameID
203
sex,sex
82 204
silt,silt
83 205
slopeAspect,slopeAspect
84 206
slopeGradient,slopeGradient
85 207
sodium,sodium
86 208
specificEpithet,specificEpithet
209
startDayOfYear,startDayOfYear
87 210
stateProvince,stateProvince
88 211
stemCount,stemCount
89 212
stemNotes,stemNotes
213
subgenus,subgenus
90 214
tag,tag
215
taxonConceptID,taxonConceptID
216
taxonID,taxonID
217
taxonRank,taxonRank
218
taxonRemarks,taxonRemarks
219
taxonomicStatus,taxonomicStatus
91 220
temperature,temperature
92 221
texture,texture
222
typeStatus,typeStatus
223
verbatimCoordinateSystem,verbatimCoordinateSystem
224
verbatimCoordinates,verbatimCoordinates
225
verbatimDepth,verbatimDepth
93 226
verbatimElevation,verbatimElevation
227
verbatimEventDate,verbatimEventDate
228
verbatimLatitude,verbatimLatitude
229
verbatimLocality,verbatimLocality
230
verbatimLongitude,verbatimLongitude
231
verbatimSRS,verbatimSRS
232
verbatimTaxonRank,verbatimTaxonRank
233
vernacularName,vernacularName
94 234
volumeCanopy,volumeCanopy
95 235
voucherType,voucherType
236
waterBody,waterBody
237
year,year

Also available in: Unified diff