Project

General

Profile

« Previous | Next » 

Revision 1267

Added inputs/UArizona/maps/DwC.specimens.csv autogen maps

View differences:

inputs/UArizona/maps/DwC.specimens.full.csv
1
UArizona[DwC]:ariz_raw,"DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[institutionID=$/_ignore/inLabel]/",Comments
2
BasisOfRecord,BasisOfRecord
3
BoundingBox,BoundingBox
4
Class,Class
5
CollectionCode,CollectionCode
6
Collector,Collector
7
CollectorNumber,CollectorNumber
8
ContinentOcean,ContinentOcean
9
CoordinatePrecision,CoordinatePrecision
10
Country,Country
11
County,County
12
DateLastModified,DateLastModified
13
DayCollected,DayCollected
14
DayIdentified,DayIdentified
15
Family,Family
16
FieldNumber,FieldNumber
17
Genus,Genus
18
IdentifiedBy,IdentifiedBy
19
IndividualCount,IndividualCount
20
InstitutionCode,InstitutionCode
21
JulianDay,JulianDay
22
Kingdom,Kingdom
23
Latitude,Latitude
24
Locality,Locality
25
Longitude,Longitude
26
MaximumDepth,MaximumDepth
27
MaximumElevation,MaximumElevation
28
MinimumDepth,MinimumDepth
29
MinimumElevation,MinimumElevation
30
MonthCollected,MonthCollected
31
MonthIdentified,MonthIdentified
32
Notes,Notes
33
Order,Order
34
Phylum,Phylum
35
PreparationType,PreparationType
36
PreviousCatalogNumber,PreviousCatalogNumber
37
RelatedCatalogItem,RelatedCatalogItem
38
RelationshipType,RelationshipType
39
ScientificName,ScientificName
40
ScientificNameAuthor,ScientificNameAuthor
41
Sex,Sex
42
Species,Species
43
StateProvince,StateProvince
44
Subspecies,Subspecies
45
TimeOfDay,TimeOfDay
46
TypeStatus,TypeStatus
47
YearCollected,YearCollected
48
YearIdentified,YearIdentified
49
acceptedNameUsage,acceptedNameUsage
50
acceptedNameUsageID,acceptedNameUsageID
51
associatedMedia,associatedMedia
52
associatedOccurrences,associatedOccurrences
53
associatedReferences,associatedReferences
54
associatedSequences,associatedSequences
55
associatedTaxa,associatedTaxa
56
basisOfRecord,basisOfRecord
57
bed,bed
58
behavior,behavior
59
CatalogNumberNumeric,catalogNumber,
60
catalogNumber,catalogNumber
61
class,class
62
collectionCode,collectionCode
63
collectionID,collectionID
64
continent,continent
65
coordinatePrecision,coordinatePrecision
66
coordinateUncertaintyInMeters,coordinateUncertaintyInMeters
67
country,country
68
countryCode,countryCode
69
county,county
70
dataGeneralizations,dataGeneralizations
71
datasetID,datasetID
72
datasetName,datasetName
73
dateIdentified,dateIdentified
74
IdentifiedDate,dateIdentified/_alt/0,
75
day,day
76
dcterms:accessRights,dcterms:accessRights
77
dcterms:bibliographicCitation,dcterms:bibliographicCitation
78
dcterms:language,dcterms:language
79
dcterms:modified,dcterms:modified
80
dcterms:references,dcterms:references
81
dcterms:rights,dcterms:rights
82
dcterms:rightsHolder,dcterms:rightsHolder
83
dcterms:type,dcterms:type
84
decimalLatitude,decimalLatitude
85
decimalLongitude,decimalLongitude
86
disposition,disposition
87
dynamicProperties,dynamicProperties
88
earliestAgeOrLowestStage,earliestAgeOrLowestStage
89
earliestEonOrLowestEonothem,earliestEonOrLowestEonothem
90
earliestEpochOrLowestSeries,earliestEpochOrLowestSeries
91
earliestEraOrLowestErathem,earliestEraOrLowestErathem
92
earliestPeriodOrLowestSystem,earliestPeriodOrLowestSystem
93
endDayOfYear,endDayOfYear
94
establishmentMeans,establishmentMeans
95
eventDate,eventDate
96
VerbatimCollectingDate,eventDate/_alt/0,
97
eventID,eventID
98
eventRemarks,eventRemarks
99
eventTime,eventTime
100
family,family
101
FieldNotes,fieldNotes,
102
fieldNotes,fieldNotes
103
fieldNumber,fieldNumber
104
footprintSRS,footprintSRS
105
footprintSpatialFit,footprintSpatialFit
106
footprintWKT,footprintWKT
107
formation,formation
108
genus,genus
109
geodeticDatum,geodeticDatum
110
geologicalContextID,geologicalContextID
111
georeferenceProtocol,georeferenceProtocol
112
georeferenceRemarks,georeferenceRemarks
113
georeferenceSources,georeferenceSources
114
georeferenceVerificationStatus,georeferenceVerificationStatus
115
georeferencedBy,georeferencedBy
116
georeferencedDate,georeferencedDate
117
group,group
118
habitat,habitat
119
higherClassification,higherClassification
120
higherGeography,higherGeography
121
higherGeographyID,higherGeographyID
122
highestBiostratigraphicZone,highestBiostratigraphicZone
123
identificationID,identificationID
124
identificationQualifier,identificationQualifier
125
identificationReferences,identificationReferences
126
identificationRemarks,identificationRemarks
127
identificationVerificationStatus,identificationVerificationStatus
128
identifiedBy,identifiedBy
129
individualCount,individualCount
130
individualID,individualID
131
informationWithheld,informationWithheld
132
infraspecificEpithet,infraspecificEpithet
133
institutionCode,institutionCode
134
institutionID,institutionID
135
island,island
136
islandGroup,islandGroup
137
kingdom,kingdom
138
latestAgeOrHighestStage,latestAgeOrHighestStage
139
latestEonOrHighestEonothem,latestEonOrHighestEonothem
140
latestEpochOrHighestSeries,latestEpochOrHighestSeries
141
latestEraOrHighestErathem,latestEraOrHighestErathem
142
latestPeriodOrHighestSystem,latestPeriodOrHighestSystem
143
lifeStage,lifeStage
144
lithostratigraphicTerms,lithostratigraphicTerms
145
locality,locality
146
locationAccordingTo,locationAccordingTo
147
locationID,locationID
148
locationRemarks,locationRemarks
149
lowestBiostratigraphicZone,lowestBiostratigraphicZone
150
maximumDepthInMeters,maximumDepthInMeters
151
maximumDistanceAboveSurfaceInMeters,maximumDistanceAboveSurfaceInMeters
152
maximumElevationInMeters,maximumElevationInMeters
153
measurementAccuracy,measurementAccuracy
154
measurementDeterminedBy,measurementDeterminedBy
155
measurementDeterminedDate,measurementDeterminedDate
156
measurementID,measurementID
157
measurementMethod,measurementMethod
158
measurementRemarks,measurementRemarks
159
measurementType,measurementType
160
measurementUnit,measurementUnit
161
measurementValue,measurementValue
162
member,member
163
minimumDepthInMeters,minimumDepthInMeters
164
minimumDistanceAboveSurfaceInMeters,minimumDistanceAboveSurfaceInMeters
165
minimumElevationInMeters,minimumElevationInMeters
166
month,month
167
municipality,municipality
168
nameAccordingTo,nameAccordingTo
169
nameAccordingToID,nameAccordingToID
170
namePublishedIn,namePublishedIn
171
namePublishedInID,namePublishedInID
172
namePublishedInYear,namePublishedInYear
173
nomenclaturalCode,nomenclaturalCode
174
nomenclaturalStatus,nomenclaturalStatus
175
GlobalUniqueIdentifier,occurrenceID,
176
occurrenceID,occurrenceID
177
occurrenceRemarks,occurrenceRemarks
178
occurrenceStatus,occurrenceStatus
179
order,order
180
originalNameUsage,originalNameUsage
181
originalNameUsageID,originalNameUsageID
182
otherCatalogNumbers,otherCatalogNumbers
183
ownerInstitutionCode,ownerInstitutionCode
184
parentNameUsage,parentNameUsage
185
parentNameUsageID,parentNameUsageID
186
phylum,phylum
187
pointRadiusSpatialFit,pointRadiusSpatialFit
188
preparations,preparations
189
previousIdentifications,previousIdentifications
190
recordNumber,recordNumber
191
recordedBy,recordedBy
192
relatedResourceID,relatedResourceID
193
relationshipAccordingTo,relationshipAccordingTo
194
relationshipEstablishedDate,relationshipEstablishedDate
195
relationshipOfResource,relationshipOfResource
196
relationshipRemarks,relationshipRemarks
197
reproductiveCondition,reproductiveCondition
198
resourceID,resourceID
199
resourceRelationshipID,resourceRelationshipID
200
samplingEffort,samplingEffort
201
samplingProtocol,samplingProtocol
202
scientificName,scientificName
203
scientificNameAuthorship,scientificNameAuthorship
204
scientificNameID,scientificNameID
205
sex,sex
206
specificEpithet,specificEpithet
207
startDayOfYear,startDayOfYear
208
stateProvince,stateProvince
209
subgenus,subgenus
210
taxonConceptID,taxonConceptID
211
taxonID,taxonID
212
taxonRank,taxonRank
213
taxonRemarks,taxonRemarks
214
taxonomicStatus,taxonomicStatus
215
typeStatus,typeStatus
216
verbatimCoordinateSystem,verbatimCoordinateSystem
217
verbatimCoordinates,verbatimCoordinates
218
verbatimDepth,verbatimDepth
219
verbatimElevation,verbatimElevation
220
verbatimEventDate,verbatimEventDate
221
verbatimLatitude,verbatimLatitude
222
verbatimLocality,verbatimLocality
223
verbatimLongitude,verbatimLongitude
224
verbatimSRS,verbatimSRS
225
verbatimTaxonRank,verbatimTaxonRank
226
vernacularName,vernacularName
227
waterBody,waterBody
228
year,year
229
AgeClass,,
230
CatalogNumber,,Map to nothing so it doesn't overwrite CatalogNumberNumeric
231
CollectedDate,,Not used
232
DecimalLatitude,,
233
DecimalLongitude,,
234
GenGankNum,,
235
GeoRefMethod,,
236
HigherGeography,,
237
HorizontalDatum,,
238
IdentificationModifier,,
239
Island,,
240
IslandGroup,,
241
LatLongComments,,
242
MaximumDepthInMeters,,
243
MinimumDepthInMeters,,
244
OriginalCoordinateSystem,,
245
OtherCatalogNumber,,
246
RelatedCatalogItems,,
247
Remarks,,
248
Tissues,,
249
VerbatimDepth,,
250
VerbatimElevation,,
251
VerbatimLatitude,,
252
VerbatimLongitude,,
inputs/UArizona/maps/VegBIEN.specimens.csv
1
UArizona[DwC]:ariz_raw,VegBIEN:/specimenreplicate,Comments,Order
2
Country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""area|country|territory""])/placename",Brad: Required; reject record if this field NULL,63
3
country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""area|country|territory""])/placename",Brad: Required; reject record if this field NULL,63
4
StateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename",,65
5
stateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename",,65
6
County,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename,,66
7
county,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename,,66
8
CoordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/coordsaccuracy/_noCV/value,,89
9
coordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/coordsaccuracy/_noCV/value,,89
10
BoundingBox,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/footprintgeometry_dwc,,91
11
footprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/footprintgeometry_dwc,,91
12
locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
13
Locality,/*_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
14
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
15
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
16
MaximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
17
maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
18
MinimumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",,71
19
minimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",,71
20
decimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
21
Latitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
22
verbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
23
decimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
24
Longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
25
verbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
26
eventDate,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate,,44
27
VerbatimCollectingDate,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/0,,44
28
DayCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/1/_date/day,,44
29
MonthCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/1/_date/month,,44
30
YearCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/1/_date/year,,44
31
MaximumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/max,,75
32
maximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/max,,75
33
MinimumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/min,,74
34
minimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/min,,74
35
ScientificNameAuthor,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/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
36
scientificNameAuthorship,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/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
37
dateIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate",,120
38
IdentifiedDate,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/0",,120
39
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/1/_date/day",,120
40
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/1/_date/month",,120
41
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/1/_date/year",,120
42
IdentifiedBy,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]:[determinationtype=Author,iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
43
identifiedBy,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]:[determinationtype=Author,iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
44
ScientificName,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Bob, Nick, please is this mapping OK?",134
45
scientificName,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Bob, Nick, please is this mapping OK?",134
46
Class,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Class]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,144
47
class,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Class]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,144
48
Family,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,146
49
family,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,146
50
Genus,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Genus]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,147
51
genus,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Genus]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,147
52
Kingdom,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Kingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,142
53
kingdom,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Kingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,142
54
Order,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Order]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,145
55
order,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Order]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,145
56
Species,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,149
57
specificEpithet,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,149
58
Phylum,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,143
59
phylum,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,143
60
Subspecies,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
61
infraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Subspecies]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",,150
62
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
63
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
64
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
65
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
66
FieldNotes,/description,,
67
Notes,/description,,
68
fieldNotes,/description,,
69
Collector,/verbatimcollectorname,,23
70
recordedBy,/verbatimcollectorname,,23
71
CatalogNumberNumeric,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
72
catalogNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
73
CollectorNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
74
recordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
75
collectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9
76
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
77
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
78
institutionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,,8
79
GlobalUniqueIdentifier,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,"Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
80
occurrenceID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,"Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
81
AgeClass,,
82
BasisOfRecord,,Brad: OMIT? See http://rs.tdwg.org/dwc/terms/index.htm#basisOfRecord for definition of this term.,15
83
CatalogNumber,,Map to nothing so it doesn't overwrite CatalogNumberNumeric
84
CollectedDate,,Not used
85
ContinentOcean,,Brad: OMIT,59
86
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
87
DecimalLatitude,,
88
DecimalLongitude,,
89
GenGankNum,,
90
GeoRefMethod,,
91
HigherGeography,,
92
HorizontalDatum,,
93
IdentificationModifier,,
94
IndividualCount,,Brad: OMIT; not relevant for DwC plant specimen data.,25
95
InstitutionCode,,,
96
Island,,
97
IslandGroup,,
98
JulianDay,,Brad: OMIT,50
99
LatLongComments,,
100
MaximumDepthInMeters,,
101
MinimumDepthInMeters,,
102
OriginalCoordinateSystem,,
103
OtherCatalogNumber,,
104
PreparationType,,Brad: OMIT,32
105
PreviousCatalogNumber,,?; Brad: OMIT,35
106
RelatedCatalogItem,,Brad: OMIT,161
107
RelatedCatalogItems,,
108
RelationshipType,,Brad: OMIT,162
109
Remarks,,
110
TimeOfDay,,Brad: OMIT,45
111
Tissues,,
112
TypeStatus,,Brad: OMIT (?). Indicates whether this specimen served as type for taxon name. Probably not relevant for BIEN,125
113
VerbatimDepth,,
114
VerbatimElevation,,
115
VerbatimLatitude,,
116
VerbatimLongitude,,
117
acceptedNameUsage,,,135
118
acceptedNameUsageID,,,128
119
associatedMedia,,,36
120
associatedOccurrences,,,38
121
associatedReferences,,,37
122
associatedSequences,,,39
123
associatedTaxa,,,40
124
basisOfRecord,,Brad: OMIT? See http://rs.tdwg.org/dwc/terms/index.htm#basisOfRecord for definition of this term.,15
125
bed,,,117
126
behavior,,,29
127
continent,,Brad: OMIT,59
128
coordinateUncertaintyInMeters,,,88
129
countryCode,,,64
130
dataGeneralizations,,,17
131
datasetID,,,10
132
datasetName,,,13
133
day,,Brad: OMIT,50
134
dcterms:accessRights,,,5
135
dcterms:bibliographicCitation,,,6
136
dcterms:language,,,2
137
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
138
dcterms:references,,,7
139
dcterms:rights,,,3
140
dcterms:rightsHolder,,,4
141
dcterms:type,,,0
142
disposition,,,33
143
dynamicProperties,,,18
144
earliestAgeOrLowestStage,,,109
145
earliestEonOrLowestEonothem,,,101
146
earliestEpochOrLowestSeries,,,107
147
earliestEraOrLowestErathem,,,103
148
earliestPeriodOrLowestSystem,,,105
149
endDayOfYear,,,47
150
establishmentMeans,,,30
151
eventID,,,41
152
eventRemarks,,,55
153
eventTime,,Brad: OMIT,45
154
footprintSRS,,,92
155
footprintSpatialFit,,,93
156
formation,,,115
157
geodeticDatum,,,87
158
geologicalContextID,,,100
159
georeferenceProtocol,,,96
160
georeferenceRemarks,,,99
161
georeferenceSources,,,97
162
georeferenceVerificationStatus,,,98
163
georeferencedBy,,Brad: Correct for VB. Nick: is there a way to specifically identify this party as collector of a specimen?,94
164
georeferencedDate,,,95
165
group,,,114
166
higherClassification,,,141
167
higherGeography,,,58
168
higherGeographyID,,,57
169
highestBiostratigraphicZone,,,112
170
identificationID,,,118
171
identificationQualifier,,,124
172
identificationReferences,,,121
173
identificationRemarks,,,123
174
identificationVerificationStatus,,,122
175
individualCount,,Brad: OMIT; not relevant for DwC plant specimen data.,25
176
individualID,,"Brad: OMIT; db-specific element, not relevant to VB/VX",24
177
informationWithheld,,,16
178
institutionCode,,,
179
island,,,62
180
islandGroup,,,61
181
latestAgeOrHighestStage,,,110
182
latestEonOrHighestEonothem,,,102
183
latestEpochOrHighestSeries,,,108
184
latestEraOrHighestErathem,,,104
185
latestPeriodOrHighestSystem,,,106
186
lifeStage,,,27
187
lithostratigraphicTerms,,,113
188
locationAccordingTo,,,78
189
locationID,,,56
190
locationRemarks,,,79
191
lowestBiostratigraphicZone,,,111
192
maximumDistanceAboveSurfaceInMeters,,,77
193
measurementAccuracy,,,169
194
measurementDeterminedBy,,,172
195
measurementDeterminedDate,,,171
196
measurementID,,,166
197
measurementMethod,,,173
198
measurementRemarks,,,174
199
measurementType,,,167
200
measurementUnit,,,170
201
measurementValue,,,168
202
member,,,116
203
minimumDistanceAboveSurfaceInMeters,,,76
204
month,,,49
205
municipality,,,67
206
nameAccordingTo,,,138
207
nameAccordingToID,,,131
208
namePublishedIn,,,139
209
namePublishedInID,,,132
210
namePublishedInYear,,,140
211
nomenclaturalCode,,,155
212
nomenclaturalStatus,,,157
213
occurrenceRemarks,,,21
214
occurrenceStatus,,,31
215
originalNameUsage,,,137
216
originalNameUsageID,,,130
217
otherCatalogNumbers,,,34
218
ownerInstitutionCode,,,14
219
parentNameUsage,,,136
220
parentNameUsageID,,,129
221
pointRadiusSpatialFit,,,90
222
preparations,,Brad: OMIT,32
223
previousIdentifications,,Brad: OMIT,35
224
relatedResourceID,,Brad: OMIT,161
225
relationshipAccordingTo,,,163
226
relationshipEstablishedDate,,,164
227
relationshipOfResource,,Brad: OMIT,162
228
relationshipRemarks,,,165
229
reproductiveCondition,,,28
230
resourceID,,,160
231
resourceRelationshipID,,,159
232
samplingEffort,,,43
233
samplingProtocol,,,42
234
scientificNameID,,,127
235
startDayOfYear,,,46
236
subgenus,,,148
237
taxonConceptID,,,133
238
taxonID,,,126
239
taxonRank,,,151
240
taxonRemarks,,,158
241
taxonomicStatus,,,156
242
typeStatus,,Brad: OMIT (?). Indicates whether this specimen served as type for taxon name. Probably not relevant for BIEN,125
243
verbatimCoordinateSystem,,,83
244
verbatimCoordinates,,,80
245
verbatimDepth,,,73
246
verbatimElevation,,,70
247
verbatimEventDate,,,51
248
verbatimSRS,,,84
249
verbatimTaxonRank,,,152
250
vernacularName,,,154
251
waterBody,,,60
252
year,,,48

Also available in: Unified diff