Project

General

Profile

« Previous | Next » 

Revision 4082

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

View differences:

mappings/DwC.self.specimens.csv
2 2
AcceptedNameUsage,AcceptedNameUsage
3 3
AcceptedNameUsageID,AcceptedNameUsageID
4 4
AccessRights,AccessRights
5
Acidity,Acidity
5 6
AssociatedMedia,AssociatedMedia
6 7
AssociatedOccurrences,AssociatedOccurrences
7 8
AssociatedReferences,AssociatedReferences
8 9
AssociatedSequences,AssociatedSequences
9 10
AssociatedTaxa,AssociatedTaxa
11
BasalDiameter,BasalDiameter
12
BaseSaturation,BaseSaturation
10 13
BasisOfRecord,BasisOfRecord
11 14
Bed,Bed
12 15
Behavior,Behavior
13 16
BibliographicCitation,BibliographicCitation
14 17
BoundingBox,BoundingBox
18
Calcium,Calcium
19
CanopyForm,CanopyForm
20
CanopyPosition,CanopyPosition
21
Carbon,Carbon
15 22
CatalogNumber,CatalogNumber
23
CationExchangeCapacity,CationExchangeCapacity
24
CensusNumber,CensusNumber
16 25
Class,Class
26
Clay,Clay
17 27
CollectedDate,CollectedDate
18 28
CollectionCode,CollectionCode
19 29
CollectionID,CollectionID
20 30
Collector,Collector
21 31
CollectorNumber,CollectorNumber
32
CommunityID,CommunityID
33
CommunityName,CommunityName
34
Computer.family,Computer.family
35
Computer.genus,Computer.genus
36
Computer.infraspecificEpithet,Computer.infraspecificEpithet
37
Computer.scientificNameAuthorship,Computer.scientificNameAuthorship
38
Computer.specificEpithet,Computer.specificEpithet
39
Computer.taxonRank,Computer.taxonRank
40
Conductivity,Conductivity
22 41
Continent,Continent
23 42
ContinentOcean,ContinentOcean
24 43
CoordinatePrecision,CoordinatePrecision
......
26 45
Country,Country
27 46
CountryCode,CountryCode
28 47
County,County
48
CoverPercent,CoverPercent
29 49
DataGeneralizations,DataGeneralizations
30 50
DatasetID,DatasetID
31 51
DatasetName,DatasetName
......
47 67
Dcterms:type,Dcterms:type
48 68
DecimalLatitude,DecimalLatitude
49 69
DecimalLongitude,DecimalLongitude
70
DiameterBreastHeight,DiameterBreastHeight
71
DiameterBreastHeightGentry,DiameterBreastHeightGentry
50 72
Disposition,Disposition
51 73
DynamicProperties,DynamicProperties
52 74
EarliestAgeOrLowestStage,EarliestAgeOrLowestStage
......
78 100
GeoreferencedDate,GeoreferencedDate
79 101
GlobalUniqueIdentifier,GlobalUniqueIdentifier
80 102
Group,Group
103
GrowthForm,GrowthForm
81 104
Habitat,Habitat
105
Height,Height
106
HeightFirstBranch,HeightFirstBranch
82 107
HigherClassification,HigherClassification
83 108
HigherGeography,HigherGeography
84 109
HigherGeographyID,HigherGeographyID
......
101 126
IslandGroup,IslandGroup
102 127
JulianDay,JulianDay
103 128
Kingdom,Kingdom
129
Landform,Landform
104 130
Language,Language
105 131
LatestAgeOrHighestStage,LatestAgeOrHighestStage
106 132
LatestEonOrHighestEonothem,LatestEonOrHighestEonothem
......
108 134
LatestEraOrHighestErathem,LatestEraOrHighestErathem
109 135
LatestPeriodOrHighestSystem,LatestPeriodOrHighestSystem
110 136
Latitude,Latitude
137
LianaInfestation,LianaInfestation
111 138
LifeStage,LifeStage
112 139
LithostratigraphicTerms,LithostratigraphicTerms
113 140
Locality,Locality
......
116 143
LocationRemarks,LocationRemarks
117 144
Longitude,Longitude
118 145
LowestBiostratigraphicZone,LowestBiostratigraphicZone
146
Magnesium,Magnesium
119 147
MaximumDepth,MaximumDepth
120 148
MaximumDepthInMeters,MaximumDepthInMeters
121 149
MaximumDistanceAboveSurfaceInMeters,MaximumDistanceAboveSurfaceInMeters
......
146 174
NamePublishedIn,NamePublishedIn
147 175
NamePublishedInID,NamePublishedInID
148 176
NamePublishedInYear,NamePublishedInYear
177
Nitrogen,Nitrogen
149 178
NomenclaturalCode,NomenclaturalCode
150 179
NomenclaturalStatus,NomenclaturalStatus
151 180
Notes,Notes
......
153 182
OccurrenceRemarks,OccurrenceRemarks
154 183
OccurrenceStatus,OccurrenceStatus
155 184
Order,Order
185
Organic,Organic
156 186
OriginalNameUsage,OriginalNameUsage
157 187
OriginalNameUsageID,OriginalNameUsageID
158 188
OtherCatalogNumbers,OtherCatalogNumbers
159 189
OwnerInstitutionCode,OwnerInstitutionCode
190
ParentLocationID,ParentLocationID
160 191
ParentNameUsage,ParentNameUsage
161 192
ParentNameUsageID,ParentNameUsageID
193
ParentPlotName,ParentPlotName
194
Ph,Ph
195
Phosphorus,Phosphorus
162 196
Phylum,Phylum
197
PlotArea,PlotArea
198
PlotEventEndDate,PlotEventEndDate
199
PlotEventStartDate,PlotEventStartDate
200
PlotName,PlotName
201
PlotNotes,PlotNotes
163 202
PointRadiusSpatialFit,PointRadiusSpatialFit
203
Potassium,Potassium
204
Precipitation,Precipitation
164 205
Preparation,Preparation
165 206
PreparationType,PreparationType
166 207
Preparations,Preparations
167 208
PreviousCatalogNumber,PreviousCatalogNumber
168 209
PreviousIdentifications,PreviousIdentifications
210
PreviousTag,PreviousTag
211
ProjectID,ProjectID
212
ProjectName,ProjectName
169 213
RecordNumber,RecordNumber
170 214
RecordedBy,RecordedBy
215
RecordedBy.givenName,RecordedBy.givenName
216
RecordedBy.surName,RecordedBy.surName
171 217
References,References
172 218
RelatedCatalogItem,RelatedCatalogItem
173 219
RelatedResourceID,RelatedResourceID
......
176 222
RelationshipOfResource,RelationshipOfResource
177 223
RelationshipRemarks,RelationshipRemarks
178 224
RelationshipType,RelationshipType
225
RelativePlotX,RelativePlotX
226
RelativePlotY,RelativePlotY
179 227
Remarks,Remarks
180 228
ReproductiveCondition,ReproductiveCondition
181 229
ResourceID,ResourceID
......
184 232
RightsHolder,RightsHolder
185 233
SamplingEffort,SamplingEffort
186 234
SamplingProtocol,SamplingProtocol
235
Sand,Sand
187 236
ScientificName,ScientificName
188 237
ScientificNameAuthor,ScientificNameAuthor
189 238
ScientificNameAuthorship,ScientificNameAuthorship
190 239
ScientificNameID,ScientificNameID
191 240
Sex,Sex
241
Silt,Silt
242
SlopeAspect,SlopeAspect
243
SlopeGradient,SlopeGradient
244
Sodium,Sodium
192 245
Species,Species
193 246
SpecificEpithet,SpecificEpithet
194 247
StartDayOfYear,StartDayOfYear
195 248
State,State
196 249
StateProvince,StateProvince
250
StemCount,StemCount
251
StemNotes,StemNotes
197 252
Subgenus,Subgenus
198 253
Subspecies,Subspecies
254
Tag,Tag
199 255
TaxonConceptID,TaxonConceptID
200 256
TaxonID,TaxonID
201 257
TaxonRank,TaxonRank
202 258
TaxonRemarks,TaxonRemarks
203 259
TaxonomicStatus,TaxonomicStatus
260
Temperature,Temperature
261
Texture,Texture
204 262
TimeOfDay,TimeOfDay
205 263
Type,Type
206 264
TypeStatus,TypeStatus
......
215 273
VerbatimSRS,VerbatimSRS
216 274
VerbatimTaxonRank,VerbatimTaxonRank
217 275
VernacularName,VernacularName
276
VolumeCanopy,VolumeCanopy
277
VoucherType,VoucherType
218 278
WaterBody,WaterBody
219 279
Year,Year
220 280
YearCollected,YearCollected
......
222 282
acceptedNameUsage,acceptedNameUsage
223 283
acceptedNameUsageID,acceptedNameUsageID
224 284
accessRights,accessRights
285
acidity,acidity
225 286
associatedMedia,associatedMedia
226 287
associatedOccurrences,associatedOccurrences
227 288
associatedReferences,associatedReferences
228 289
associatedSequences,associatedSequences
229 290
associatedTaxa,associatedTaxa
291
basalDiameter,basalDiameter
292
baseSaturation,baseSaturation
230 293
basisOfRecord,basisOfRecord
231 294
bed,bed
232 295
behavior,behavior
233 296
bibliographicCitation,bibliographicCitation
234 297
boundingBox,boundingBox
298
calcium,calcium
299
canopyForm,canopyForm
300
canopyPosition,canopyPosition
301
carbon,carbon
235 302
catalogNumber,catalogNumber
303
cationExchangeCapacity,cationExchangeCapacity
304
censusNumber,censusNumber
236 305
class,class
306
clay,clay
237 307
collectedDate,collectedDate
238 308
collectionCode,collectionCode
239 309
collectionID,collectionID
240 310
collector,collector
241 311
collectorNumber,collectorNumber
312
communityID,communityID
313
communityName,communityName
314
computer.family,computer.family
315
computer.genus,computer.genus
316
computer.infraspecificEpithet,computer.infraspecificEpithet
317
computer.scientificNameAuthorship,computer.scientificNameAuthorship
318
computer.specificEpithet,computer.specificEpithet
319
computer.taxonRank,computer.taxonRank
320
conductivity,conductivity
242 321
continent,continent
243 322
continentOcean,continentOcean
244 323
coordinatePrecision,coordinatePrecision
......
246 325
country,country
247 326
countryCode,countryCode
248 327
county,county
328
coverPercent,coverPercent
249 329
dataGeneralizations,dataGeneralizations
250 330
datasetID,datasetID
251 331
datasetName,datasetName
......
267 347
dcterms:type,dcterms:type
268 348
decimalLatitude,decimalLatitude
269 349
decimalLongitude,decimalLongitude
350
diameterBreastHeight,diameterBreastHeight
351
diameterBreastHeightGentry,diameterBreastHeightGentry
270 352
disposition,disposition
271 353
dynamicProperties,dynamicProperties
272 354
earliestAgeOrLowestStage,earliestAgeOrLowestStage
......
298 380
georeferencedDate,georeferencedDate
299 381
globalUniqueIdentifier,globalUniqueIdentifier
300 382
group,group
383
growthForm,growthForm
301 384
habitat,habitat
385
height,height
386
heightFirstBranch,heightFirstBranch
302 387
higherClassification,higherClassification
303 388
higherGeography,higherGeography
304 389
higherGeographyID,higherGeographyID
......
321 406
islandGroup,islandGroup
322 407
julianDay,julianDay
323 408
kingdom,kingdom
409
landform,landform
324 410
language,language
325 411
latestAgeOrHighestStage,latestAgeOrHighestStage
326 412
latestEonOrHighestEonothem,latestEonOrHighestEonothem
......
328 414
latestEraOrHighestErathem,latestEraOrHighestErathem
329 415
latestPeriodOrHighestSystem,latestPeriodOrHighestSystem
330 416
latitude,latitude
417
lianaInfestation,lianaInfestation
331 418
lifeStage,lifeStage
332 419
lithostratigraphicTerms,lithostratigraphicTerms
333 420
locality,locality
......
336 423
locationRemarks,locationRemarks
337 424
longitude,longitude
338 425
lowestBiostratigraphicZone,lowestBiostratigraphicZone
426
magnesium,magnesium
339 427
maximumDepth,maximumDepth
340 428
maximumDepthInMeters,maximumDepthInMeters
341 429
maximumDistanceAboveSurfaceInMeters,maximumDistanceAboveSurfaceInMeters
......
366 454
namePublishedIn,namePublishedIn
367 455
namePublishedInID,namePublishedInID
368 456
namePublishedInYear,namePublishedInYear
457
nitrogen,nitrogen
369 458
nomenclaturalCode,nomenclaturalCode
370 459
nomenclaturalStatus,nomenclaturalStatus
371 460
notes,notes
......
373 462
occurrenceRemarks,occurrenceRemarks
374 463
occurrenceStatus,occurrenceStatus
375 464
order,order
465
organic,organic
376 466
originalNameUsage,originalNameUsage
377 467
originalNameUsageID,originalNameUsageID
378 468
otherCatalogNumbers,otherCatalogNumbers
379 469
ownerInstitutionCode,ownerInstitutionCode
470
parentLocationID,parentLocationID
380 471
parentNameUsage,parentNameUsage
381 472
parentNameUsageID,parentNameUsageID
473
parentPlotName,parentPlotName
474
ph,ph
475
phosphorus,phosphorus
382 476
phylum,phylum
477
plotArea,plotArea
478
plotEventEndDate,plotEventEndDate
479
plotEventStartDate,plotEventStartDate
480
plotName,plotName
481
plotNotes,plotNotes
383 482
pointRadiusSpatialFit,pointRadiusSpatialFit
483
potassium,potassium
484
precipitation,precipitation
384 485
preparation,preparation
385 486
preparationType,preparationType
386 487
preparations,preparations
387 488
previousCatalogNumber,previousCatalogNumber
388 489
previousIdentifications,previousIdentifications
490
previousTag,previousTag
491
projectID,projectID
492
projectName,projectName
389 493
recordNumber,recordNumber
390 494
recordedBy,recordedBy
495
recordedBy.givenName,recordedBy.givenName
496
recordedBy.surName,recordedBy.surName
391 497
references,references
392 498
relatedCatalogItem,relatedCatalogItem
393 499
relatedResourceID,relatedResourceID
......
396 502
relationshipOfResource,relationshipOfResource
397 503
relationshipRemarks,relationshipRemarks
398 504
relationshipType,relationshipType
505
relativePlotX,relativePlotX
506
relativePlotY,relativePlotY
399 507
remarks,remarks
400 508
reproductiveCondition,reproductiveCondition
401 509
resourceID,resourceID
......
404 512
rightsHolder,rightsHolder
405 513
samplingEffort,samplingEffort
406 514
samplingProtocol,samplingProtocol
515
sand,sand
407 516
scientificName,scientificName
408 517
scientificNameAuthor,scientificNameAuthor
409 518
scientificNameAuthorship,scientificNameAuthorship
410 519
scientificNameID,scientificNameID
411 520
sex,sex
521
silt,silt
522
slopeAspect,slopeAspect
523
slopeGradient,slopeGradient
524
sodium,sodium
412 525
species,species
413 526
specificEpithet,specificEpithet
414 527
startDayOfYear,startDayOfYear
415 528
state,state
416 529
stateProvince,stateProvince
530
stemCount,stemCount
531
stemNotes,stemNotes
417 532
subgenus,subgenus
418 533
subspecies,subspecies
534
tag,tag
419 535
taxonConceptID,taxonConceptID
420 536
taxonID,taxonID
421 537
taxonRank,taxonRank
422 538
taxonRemarks,taxonRemarks
423 539
taxonomicStatus,taxonomicStatus
540
temperature,temperature
541
texture,texture
424 542
timeOfDay,timeOfDay
425 543
type,type
426 544
typeStatus,typeStatus
......
435 553
verbatimSRS,verbatimSRS
436 554
verbatimTaxonRank,verbatimTaxonRank
437 555
vernacularName,vernacularName
556
volumeCanopy,volumeCanopy
557
voucherType,voucherType
438 558
waterBody,waterBody
439 559
year,year
440 560
yearCollected,yearCollected
mappings/DwC2-VegBIEN.specimens.csv
1 1
DwC,VegBIEN:,Comments
2
plotArea,/location/area,
3
plotName,/location/authorlocationcode/_alt/1,
4
fieldNumber,/location/authorlocationcode/_alt/2,
2 5
occurrenceID,/location/authorlocationcode/_alt/3,
3 6
institutionCode,/location/authorlocationcode/_alt/4/_merge/1,
4 7
collectionCode,/location/authorlocationcode/_alt/4/_merge/2/_merge/1,
5 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",
6 10
catalogNumber,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/else",
7 11
verbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
8 12
maximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
......
10 14
minimumElevationInMeters,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
11 15
maximumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
12 16
minimumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
17
landform,/location/landform,
13 18
coordinateUncertaintyInMeters,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,
14 19
coordinatePrecision,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,
15 20
footprintWKT,/location/locationdetermination/footprintgeometry_dwc,
......
22 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",
23 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",
24 29
samplingProtocol,/location/locationevent/*_id/method/name,
30
projectName,/location/locationevent/*_id/project/projectname,
31
projectID,/location/locationevent/*_id/project/sourceaccessioncode,
25 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,
26 36
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1,
27 37
dateCollected,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2,
38
plotEventStartDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,
28 39
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1,
29 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,
30 59
dateCollected,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date,
31 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,
32 64
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
33 65
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber,
34 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"
35 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",
36 69
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
37 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
38 71
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_merge/2,
39 72
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
40 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,
41 88
recordNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1,
42 89
scientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2,
90
growthForm,/location/locationevent/taxonoccurrence/growthform,
43 91
establishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value",
44 92
establishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value",
45 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",
46 100
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
47 101
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
48 102
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last,
......
60 114
taxonRemarks,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/notes,
61 115
identificationQualifier,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/taxonfit,
62 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",
63 120
catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
121
temperature,/location/locationevent/temperature,
64 122
maximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
65 123
minimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
66 124
locality,/location/locationnarrative/_merge/1,
67 125
verbatimLocality,/location/locationnarrative/_merge/2,
68 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,
69 132
locationID,/location/sourceaccessioncode,
70 133
acceptedNameUsage,,
71 134
acceptedNameUsageID,,
mappings/for_review/DwC2-VegBIEN.specimens.csv
1 1
DwC,VegBIEN:,Comments
2
plotArea,//location/area,
3
plotName,//location/authorlocationcode,
4
fieldNumber,//location/authorlocationcode,
2 5
occurrenceID,//location/authorlocationcode,
3 6
institutionCode,//location/authorlocationcode,
4 7
collectionCode,//location/authorlocationcode,
5 8
collectionID,//location/authorlocationcode,
9
voucherType,"//location/authorlocationcode/_if[@name=""if indirect voucher""]/cond",
6 10
catalogNumber,"//location/authorlocationcode/_if[@name=""if indirect voucher""]/else",
7 11
verbatimElevation,//location/elevation,
8 12
maximumElevationInMeters,//location/elevation,
......
10 14
minimumElevationInMeters,//location/elevationrange,
11 15
maximumElevationInMeters,//location/elevationrange,
12 16
minimumElevationInMeters,//location/elevationrange,
17
landform,//location/landform,
13 18
coordinateUncertaintyInMeters,//locationdetermination/coordsaccuracy,
14 19
coordinatePrecision,//locationdetermination/coordsaccuracy,
15 20
footprintWKT,//locationdetermination/footprintgeometry_dwc,
......
22 27
country,//locationdetermination/namedplace_id[rank=country]/placename,
23 28
continent,//locationdetermination/namedplace_id[rank=continent]/placename,
24 29
samplingProtocol,//method/name,
30
projectName,//project/projectname,
31
projectID,//project/sourceaccessioncode,
25 32
fieldNumber,//locationevent/authoreventcode,
33
communityID,//*/commname,
34
communityName,//commconcept/commdescription,
35
plotEventEndDate,//locationevent/obsenddate/_*/date,
26 36
eventDate,//locationevent/obsenddate/_*/date,
27 37
dateCollected,//locationevent/obsenddate/_*/date,
38
plotEventStartDate,//locationevent/obsstartdate/_*/date,
28 39
eventDate,//locationevent/obsstartdate/_*/date,
29 40
dateCollected,//locationevent/obsstartdate/_*/date,
41
precipitation,//locationevent/precipitation,
42
acidity,//soilobs/acidity,
43
baseSaturation,//soilobs/basesaturation,
44
calcium,//soilobs/calcium,
45
carbon,//soilobs/carbon,
46
cationExchangeCapacity,//soilobs/cationexchangecapacity,
47
clay,//soilobs/clay,
48
conductivity,//soilobs/conductivity,
49
magnesium,//soilobs/magnesium,
50
nitrogen,//soilobs/nitrogen,
51
organic,//soilobs/organic,
52
ph,//soilobs/ph,
53
phosphorus,//soilobs/phosphorus,
54
potassium,//soilobs/potassium,
55
sand,//soilobs/sand,
56
silt,//soilobs/silt,
57
sodium,//soilobs/sodium,
58
texture,//soilobs/texture,
30 59
dateCollected,//aggregateoccurrence/collectiondate/_*/date,
31 60
individualCount,//aggregateoccurrence/count,
61
coverPercent,//aggregateoccurrence/cover,
62
censusNumber,"//aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]/definedvalue",
63
volumeCanopy,//aggregateoccurrence/linecover,
32 64
fieldNotes,//aggregateoccurrence/notes,
33 65
recordNumber,//plantobservation/collectionnumber,
34 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"
35 67
individualID,//plantobservation/sourceaccessioncode,
68
voucherType,"//specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond",
36 69
catalogNumber,"//specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
37 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
38 71
collectionID,//specimenreplicate/collectioncode_dwc,
39 72
institutionCode,//party/organizationname,
40 73
occurrenceID,//specimenreplicate/sourceaccessioncode,
74
stemCount,//plantobservation/stemcount,
75
basalDiameter,//stemobservation/basaldiameter,
76
canopyForm,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyForm]]/definedvalue",
77
canopyPosition,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyPosition]]/definedvalue",
78
diameterBreastHeightGentry,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=gentryDiameter]]/definedvalue",
79
lianaInfestation,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=lianaInfestation]]/definedvalue",
80
stemNotes,"//stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=notes]]/definedvalue",
81
diameterBreastHeight,//stemobservation/diameterbreastheight,
82
height,//stemobservation/height,
83
heightFirstBranch,//stemobservation/heightfirstbranch,
84
tag,"//stemobservation/stemtag[""""/iscurrent=true]/tag",Quotes sort it before tag2
85
previousTag,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag:[../stemtag?[iscurrent=true]/iscurrent=false]/tag,
86
relativePlotX,//stemobservation/xposition,
87
relativePlotY,//stemobservation/yposition,
41 88
recordNumber,//taxonoccurrence/authortaxoncode,
42 89
scientificName,//taxonoccurrence/authortaxoncode,
90
growthForm,//taxonoccurrence/growthform,
43 91
establishmentMeans,//taxonoccurrence/iscultivated,
44 92
establishmentMeans,//taxonoccurrence/isnative,
45 93
individualID,//taxonoccurrence/sourceaccessioncode,
94
computer.scientificNameAuthorship,//plantconcept/plantname_id[rank=authority]/plantname,
95
computer.taxonRank,//plantconcept/plantname_id[rank=subspecies]/plantname,
96
computer.infraspecificEpithet,//plantconcept/plantname_id[rank=subspecies]/plantname,
97
computer.specificEpithet,//plantconcept/plantname_id[rank=species]/plantname,
98
computer.genus,//plantconcept/plantname_id[rank=genus]/plantname,
99
computer.family,//plantconcept/plantname_id[rank=family]/plantname,
46 100
identifiedBy,//taxonoccurrence/taxondetermination[role=identifier]/*_id/party/givenname,
47 101
identifiedBy,//taxonoccurrence/taxondetermination[role=identifier]/*_id/party/middlename,
48 102
identifiedBy,//taxonoccurrence/taxondetermination[role=identifier]/*_id/party/surname,
......
60 114
taxonRemarks,//taxonoccurrence/taxondetermination[role=identifier]/notes,
61 115
identificationQualifier,//taxonoccurrence/taxondetermination[role=identifier]/taxonfit,
62 116
recordedBy,//taxonoccurrence/verbatimcollectorname,
117
recordedBy.givenName,//taxonoccurrence/verbatimcollectorname,
118
recordedBy.surName,//taxonoccurrence/verbatimcollectorname,
119
voucherType,"//specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond",
63 120
catalogNumber,"//specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
121
temperature,//locationevent/temperature,
64 122
maximumDepthInMeters,//locationevent/waterdepth,
65 123
minimumDepthInMeters,//locationevent/waterdepth,
66 124
locality,//location/locationnarrative,
67 125
verbatimLocality,//location/locationnarrative,
68 126
habitat,"//location/locationnarrative/_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/authorlocationcode,
129
parentLocationID,//location/sourceaccessioncode,
130
slopeAspect,//location/slopeaspect,
131
slopeGradient,//location/slopegradient,
69 132
locationID,//location/sourceaccessioncode,
70 133
acceptedNameUsage,,
71 134
acceptedNameUsageID,,
mappings/DwC-VegBIEN.specimens.csv
1 1
DwC,VegBIEN:,Comments
2
PlotArea,/location/area,
3
plotArea,/location/area,
4
PlotName,/location/authorlocationcode/_alt/1,
5
plotName,/location/authorlocationcode/_alt/1,
6
FieldNumber,/location/authorlocationcode/_alt/2,
7
fieldNumber,/location/authorlocationcode/_alt/2,
2 8
GlobalUniqueIdentifier,/location/authorlocationcode/_alt/3,
3 9
Id,/location/authorlocationcode/_alt/3,
4 10
OccurrenceID,/location/authorlocationcode/_alt/3,
......
11 17
collectionCode,/location/authorlocationcode/_alt/4/_merge/2/_merge/1,
12 18
CollectionID,/location/authorlocationcode/_alt/4/_merge/2/_merge/2,
13 19
collectionID,/location/authorlocationcode/_alt/4/_merge/2/_merge/2,
20
VoucherType,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left",
21
voucherType,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left",
14 22
CatalogNumber,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/else",
15 23
catalogNumber,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/else",
16 24
VerbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
......
35 43
MinimumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
36 44
minimumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
37 45
minimumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
46
Landform,/location/landform,
47
landform,/location/landform,
38 48
CoordinateUncertaintyInMeters,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,
39 49
coordinateUncertaintyInMeters,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,
40 50
CoordinatePrecision,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,
......
69 79
continentOcean,"/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",
70 80
SamplingProtocol,/location/locationevent/*_id/method/name,
71 81
samplingProtocol,/location/locationevent/*_id/method/name,
82
ProjectName,/location/locationevent/*_id/project/projectname,
83
projectName,/location/locationevent/*_id/project/projectname,
84
ProjectID,/location/locationevent/*_id/project/sourceaccessioncode,
85
projectID,/location/locationevent/*_id/project/sourceaccessioncode,
72 86
FieldNumber,/location/locationevent/authoreventcode,
73 87
fieldNumber,/location/locationevent/authoreventcode,
88
CommunityID,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
89
communityID,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
90
CommunityName,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,
91
communityName,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,
92
PlotEventEndDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value,
93
plotEventEndDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value,
74 94
EventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1,
75 95
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1,
76 96
DateCollected/_alt,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt,Allow datasource to define custom dateCollected mappings that don't pass through the default dateCollected mapping
......
85 105
dateCollected,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/2,
86 106
CollectedDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/3,
87 107
collectedDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/3,
108
PlotEventStartDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,
109
plotEventStartDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,
88 110
EventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1,
89 111
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1,
90 112
DateCollected/_alt,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt,Allow datasource to define custom dateCollected mappings that don't pass through the default dateCollected mapping
......
99 121
dateCollected,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/2,
100 122
CollectedDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/3,
101 123
collectedDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/3,
124
Precipitation,/location/locationevent/precipitation,
125
precipitation,/location/locationevent/precipitation,
126
Acidity,/location/locationevent/soilobs/acidity,
127
acidity,/location/locationevent/soilobs/acidity,
128
BaseSaturation,/location/locationevent/soilobs/basesaturation,
129
baseSaturation,/location/locationevent/soilobs/basesaturation,
130
Calcium,/location/locationevent/soilobs/calcium,
131
calcium,/location/locationevent/soilobs/calcium,
132
Carbon,/location/locationevent/soilobs/carbon,
133
carbon,/location/locationevent/soilobs/carbon,
134
CationExchangeCapacity,/location/locationevent/soilobs/cationexchangecapacity,
135
cationExchangeCapacity,/location/locationevent/soilobs/cationexchangecapacity,
136
Clay,/location/locationevent/soilobs/clay,
137
clay,/location/locationevent/soilobs/clay,
138
Conductivity,/location/locationevent/soilobs/conductivity,
139
conductivity,/location/locationevent/soilobs/conductivity,
140
Magnesium,/location/locationevent/soilobs/magnesium,
141
magnesium,/location/locationevent/soilobs/magnesium,
142
Nitrogen,/location/locationevent/soilobs/nitrogen,
143
nitrogen,/location/locationevent/soilobs/nitrogen,
144
Organic,/location/locationevent/soilobs/organic,
145
organic,/location/locationevent/soilobs/organic,
146
Ph,/location/locationevent/soilobs/ph,
147
ph,/location/locationevent/soilobs/ph,
148
Phosphorus,/location/locationevent/soilobs/phosphorus,
149
phosphorus,/location/locationevent/soilobs/phosphorus,
150
Potassium,/location/locationevent/soilobs/potassium,
151
potassium,/location/locationevent/soilobs/potassium,
152
Sand,/location/locationevent/soilobs/sand,
153
sand,/location/locationevent/soilobs/sand,
154
Silt,/location/locationevent/soilobs/silt,
155
silt,/location/locationevent/soilobs/silt,
156
Sodium,/location/locationevent/soilobs/sodium,
157
sodium,/location/locationevent/soilobs/sodium,
158
Texture,/location/locationevent/soilobs/texture,
159
texture,/location/locationevent/soilobs/texture,
102 160
DateCollected/_alt,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt,Allow datasource to define custom dateCollected mappings that don't pass through the default dateCollected mapping
103 161
dateCollected/_alt,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt,Allow datasource to define custom dateCollected mappings that don't pass through the default dateCollected mapping
104 162
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
......
113 171
collectedDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/3,
114 172
IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
115 173
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
174
CoverPercent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover,
175
coverPercent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover,
176
CensusNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue",
177
censusNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue",
178
VolumeCanopy,/location/locationevent/taxonoccurrence/aggregateoccurrence/linecover,
179
volumeCanopy,/location/locationevent/taxonoccurrence/aggregateoccurrence/linecover,
116 180
FieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
117 181
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
118 182
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
......
125 189
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"
126 190
IndividualID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
127 191
individualID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
192
VoucherType,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left",
193
voucherType,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left",
128 194
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
129 195
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
130 196
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
......
139 205
globalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
140 206
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
141 207
occurrenceID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
208
StemCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount,
209
stemCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount,
210
BasalDiameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/basaldiameter,
211
basalDiameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/basaldiameter,
212
CanopyForm,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyForm]]:[@fkey=tablerecord_id]/definedvalue",
213
canopyForm,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyForm]]:[@fkey=tablerecord_id]/definedvalue",
214
CanopyPosition,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyPosition]]:[@fkey=tablerecord_id]/definedvalue",
215
canopyPosition,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyPosition]]:[@fkey=tablerecord_id]/definedvalue",
216
DiameterBreastHeightGentry,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=gentryDiameter]]:[@fkey=tablerecord_id]/definedvalue",
217
diameterBreastHeightGentry,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=gentryDiameter]]:[@fkey=tablerecord_id]/definedvalue",
218
LianaInfestation,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=lianaInfestation]]:[@fkey=tablerecord_id]/definedvalue",
219
lianaInfestation,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=lianaInfestation]]:[@fkey=tablerecord_id]/definedvalue",
220
StemNotes,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=notes]]:[@fkey=tablerecord_id]/definedvalue",
221
stemNotes,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=notes]]:[@fkey=tablerecord_id]/definedvalue",
222
DiameterBreastHeight,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight,
223
diameterBreastHeight,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight,
224
Height,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height,
225
height,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height,
226
HeightFirstBranch,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/heightfirstbranch,
227
heightFirstBranch,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/heightfirstbranch,
228
Tag,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2
229
tag,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2
230
PreviousTag,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[iscurrent=true]:[../stemtag?[iscurrent/_alt/2=true]/iscurrent/_alt/1=false]/tag,
231
previousTag,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[iscurrent=true]:[../stemtag?[iscurrent/_alt/2=true]/iscurrent/_alt/1=false]/tag,
232
RelativePlotX,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition,
233
relativePlotX,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition,
234
RelativePlotY,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition,
235
relativePlotY,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition,
142 236
CollectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,
143 237
collectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,
144 238
RecordNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,
145 239
recordNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,
146 240
ScientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2,
147 241
scientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2,
242
GrowthForm,/location/locationevent/taxonoccurrence/growthform,
243
growthForm,/location/locationevent/taxonoccurrence/growthform,
148 244
EstablishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value",
149 245
establishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value",
150 246
EstablishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value",
151 247
establishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value",
152 248
IndividualID,/location/locationevent/taxonoccurrence/sourceaccessioncode,
153 249
individualID,/location/locationevent/taxonoccurrence/sourceaccessioncode,
250
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",
251
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",
252
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",
253
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",
254
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",
255
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",
256
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",
257
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",
258
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",
259
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",
260
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",
261
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",
154 262
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
155 263
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
156 264
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
......
205 313
RecordedBy,/location/locationevent/taxonoccurrence/verbatimcollectorname,
206 314
collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
207 315
recordedBy,/location/locationevent/taxonoccurrence/verbatimcollectorname,
316
RecordedBy.givenName,/location/locationevent/taxonoccurrence/verbatimcollectorname/_name/first,
317
recordedBy.givenName,/location/locationevent/taxonoccurrence/verbatimcollectorname/_name/first,
318
RecordedBy.surName,/location/locationevent/taxonoccurrence/verbatimcollectorname/_name/last,
319
recordedBy.surName,/location/locationevent/taxonoccurrence/verbatimcollectorname/_name/last,
320
VoucherType,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left",
321
voucherType,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left",
208 322
CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
209 323
catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
324
Temperature,/location/locationevent/temperature,
325
temperature,/location/locationevent/temperature,
210 326
MaximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
211 327
MaximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
212 328
maximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
......
221 337
verbatimLocality,/location/locationnarrative/_merge/2,
222 338
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?"
223 339
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?"
340
PlotNotes,/location/notespublic,
341
plotNotes,/location/notespublic,
342
ParentPlotName,/location/parent_id/location/authorlocationcode,
343
parentPlotName,/location/parent_id/location/authorlocationcode,
344
ParentLocationID,/location/parent_id/location/sourceaccessioncode,
345
parentLocationID,/location/parent_id/location/sourceaccessioncode,
346
SlopeAspect,/location/slopeaspect/_compass/value,
347
slopeAspect,/location/slopeaspect/_compass/value,
348
SlopeGradient,/location/slopegradient,
349
slopeGradient,/location/slopegradient,
224 350
LocationID,/location/sourceaccessioncode,
225 351
locationID,/location/sourceaccessioncode,
226 352
AcceptedNameUsage,,** No non-empty join mapping for acceptedNameUsage ** 
mappings/DwC.cs-VegBIEN.specimens.csv
1 1
DwC,VegBIEN:,Comments
2
plotArea,/location/area,
3
plotName,/location/authorlocationcode/_alt/1,
4
fieldNumber,/location/authorlocationcode/_alt/2,
2 5
globalUniqueIdentifier,/location/authorlocationcode/_alt/3,
3 6
id,/location/authorlocationcode/_alt/3,
4 7
occurrenceID,/location/authorlocationcode/_alt/3,
5 8
institutionCode,/location/authorlocationcode/_alt/4/_merge/1,
6 9
collectionCode,/location/authorlocationcode/_alt/4/_merge/2/_merge/1,
7 10
collectionID,/location/authorlocationcode/_alt/4/_merge/2/_merge/2,
11
voucherType,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left",
8 12
catalogNumber,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/else",
9 13
verbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
10 14
maximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
......
17 21
maximumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
18 22
minimumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
19 23
minimumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
24
landform,/location/landform,
20 25
coordinateUncertaintyInMeters,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,
21 26
coordinatePrecision,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,
22 27
boundingBox,/location/locationdetermination/footprintgeometry_dwc,
......
34 39
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",
35 40
continentOcean,"/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",
36 41
samplingProtocol,/location/locationevent/*_id/method/name,
42
projectName,/location/locationevent/*_id/project/projectname,
43
projectID,/location/locationevent/*_id/project/sourceaccessioncode,
37 44
fieldNumber,/location/locationevent/authoreventcode,
45
communityID,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
46
communityName,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,
47
plotEventEndDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value,
38 48
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1,
39 49
dateCollected/_alt,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt,Allow datasource to define custom dateCollected mappings that don't pass through the default dateCollected mapping
40 50
dayCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
......
42 52
yearCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
43 53
dateCollected,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/2,
44 54
collectedDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2/_alt/3,
55
plotEventStartDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,
45 56
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1,
46 57
dateCollected/_alt,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt,Allow datasource to define custom dateCollected mappings that don't pass through the default dateCollected mapping
47 58
dayCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
......
49 60
yearCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
50 61
dateCollected,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/2,
51 62
collectedDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2/_alt/3,
63
precipitation,/location/locationevent/precipitation,
64
acidity,/location/locationevent/soilobs/acidity,
65
baseSaturation,/location/locationevent/soilobs/basesaturation,
66
calcium,/location/locationevent/soilobs/calcium,
67
carbon,/location/locationevent/soilobs/carbon,
68
cationExchangeCapacity,/location/locationevent/soilobs/cationexchangecapacity,
69
clay,/location/locationevent/soilobs/clay,
70
conductivity,/location/locationevent/soilobs/conductivity,
71
magnesium,/location/locationevent/soilobs/magnesium,
72
nitrogen,/location/locationevent/soilobs/nitrogen,
73
organic,/location/locationevent/soilobs/organic,
74
ph,/location/locationevent/soilobs/ph,
75
phosphorus,/location/locationevent/soilobs/phosphorus,
76
potassium,/location/locationevent/soilobs/potassium,
77
sand,/location/locationevent/soilobs/sand,
78
silt,/location/locationevent/soilobs/silt,
79
sodium,/location/locationevent/soilobs/sodium,
80
texture,/location/locationevent/soilobs/texture,
52 81
dateCollected/_alt,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt,Allow datasource to define custom dateCollected mappings that don't pass through the default dateCollected mapping
53 82
dayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
54 83
monthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
......
56 85
dateCollected,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/2,
57 86
collectedDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/3,
58 87
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
88
coverPercent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover,
89
censusNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue",
90
volumeCanopy,/location/locationevent/taxonoccurrence/aggregateoccurrence/linecover,
59 91
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
60 92
notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
61 93
collectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/1,
62 94
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2,
63 95
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"
64 96
individualID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
97
voucherType,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left",
65 98
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
66 99
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
67 100
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_merge/2,
......
69 102
globalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
70 103
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
71 104
occurrenceID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
105
stemCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount,
106
basalDiameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/basaldiameter,
107
canopyForm,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyForm]]:[@fkey=tablerecord_id]/definedvalue",
108
canopyPosition,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyPosition]]:[@fkey=tablerecord_id]/definedvalue",
109
diameterBreastHeightGentry,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=gentryDiameter]]:[@fkey=tablerecord_id]/definedvalue",
110
lianaInfestation,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=lianaInfestation]]:[@fkey=tablerecord_id]/definedvalue",
111
stemNotes,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=notes]]:[@fkey=tablerecord_id]/definedvalue",
112
diameterBreastHeight,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight,
113
height,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height,
114
heightFirstBranch,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/heightfirstbranch,
115
tag,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2
116
previousTag,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[iscurrent=true]:[../stemtag?[iscurrent/_alt/2=true]/iscurrent/_alt/1=false]/tag,
117
relativePlotX,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition,
118
relativePlotY,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition,
72 119
collectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,
73 120
recordNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,
74 121
scientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2,
122
growthForm,/location/locationevent/taxonoccurrence/growthform,
75 123
establishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value",
76 124
establishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value",
77 125
individualID,/location/locationevent/taxonoccurrence/sourceaccessioncode,
126
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",
127
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",
128
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",
129
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",
130
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",
131
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",
78 132
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
79 133
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
80 134
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last,
......
102 156
identificationQualifier,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/taxonfit,
103 157
collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
104 158
recordedBy,/location/locationevent/taxonoccurrence/verbatimcollectorname,
159
recordedBy.givenName,/location/locationevent/taxonoccurrence/verbatimcollectorname/_name/first,
160
recordedBy.surName,/location/locationevent/taxonoccurrence/verbatimcollectorname/_name/last,
161
voucherType,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left",
105 162
catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
163
temperature,/location/locationevent/temperature,
106 164
maximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
107 165
maximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
108 166
minimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
......
110 168
locality,/location/locationnarrative/_merge/1,
111 169
verbatimLocality,/location/locationnarrative/_merge/2,
112 170
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?"
171
plotNotes,/location/notespublic,
172
parentPlotName,/location/parent_id/location/authorlocationcode,
173
parentLocationID,/location/parent_id/location/sourceaccessioncode,
174
slopeAspect,/location/slopeaspect/_compass/value,
175
slopeGradient,/location/slopegradient,
113 176
locationID,/location/sourceaccessioncode,
114 177
acceptedNameUsage,,
115 178
acceptedNameUsageID,,

Also available in: Unified diff