Project

General

Profile

« Previous | Next » 

Revision 4076

schemas/vegbien.sql: Moved collectionnumber from specimenreplicate to plantobservation to replace authorplantcode, since these terms are used analogously in plots and specimens data. This code is really the DwC recordNumber (VegBIEN collectionnumber), which "serves as a link between field notes and an Occurrence record, such as a specimen [or plots data] collector's number" (http://rs.tdwg.org/dwc/terms/#recordNumber). Also, this prevents a specimenreplicate from incorrectly being created when plots data provides an authorplantcode.

View differences:

mappings/VegCSV.self.specimens.csv
1 1
VegCSV[DwC],VegCSV[DwC]
2
acceptedNameUsage,acceptedNameUsage
3
acceptedNameUsageID,acceptedNameUsageID
2 4
acidity,acidity
5
associatedMedia,associatedMedia
6
associatedOccurrences,associatedOccurrences
7
associatedReferences,associatedReferences
8
associatedSequences,associatedSequences
9
associatedTaxa,associatedTaxa
3 10
basalDiameter,basalDiameter
4 11
baseSaturation,baseSaturation
12
basisOfRecord,basisOfRecord
13
bed,bed
14
behavior,behavior
5 15
calcium,calcium
6 16
canopyForm,canopyForm
7 17
canopyPosition,canopyPosition
......
11 21
censusNumber,censusNumber
12 22
class,class
13 23
clay,clay
24
collectionCode,collectionCode
25
collectionID,collectionID
14 26
communityID,communityID
15 27
communityName,communityName
16 28
computer.family,computer.family
......
21 33
computer.taxonRank,computer.taxonRank
22 34
conductivity,conductivity
23 35
continent,continent
36
coordinatePrecision,coordinatePrecision
24 37
coordinateUncertaintyInMeters,coordinateUncertaintyInMeters
25 38
country,country
39
countryCode,countryCode
26 40
county,county
27 41
coverPercent,coverPercent
42
dataGeneralizations,dataGeneralizations
43
datasetID,datasetID
44
datasetName,datasetName
45
dateCollected,dateCollected
46
dateIdentified,dateIdentified
47
day,day
48
dcterms:accessRights,dcterms:accessRights
49
dcterms:bibliographicCitation,dcterms:bibliographicCitation
50
dcterms:language,dcterms:language
51
dcterms:modified,dcterms:modified
52
dcterms:references,dcterms:references
53
dcterms:rights,dcterms:rights
54
dcterms:rightsHolder,dcterms:rightsHolder
55
dcterms:type,dcterms:type
28 56
decimalLatitude,decimalLatitude
29 57
decimalLongitude,decimalLongitude
30 58
diameterBreastHeight,diameterBreastHeight
31 59
diameterBreastHeightGentry,diameterBreastHeightGentry
60
disposition,disposition
61
dynamicProperties,dynamicProperties
62
earliestAgeOrLowestStage,earliestAgeOrLowestStage
63
earliestEonOrLowestEonothem,earliestEonOrLowestEonothem
64
earliestEpochOrLowestSeries,earliestEpochOrLowestSeries
65
earliestEraOrLowestErathem,earliestEraOrLowestErathem
66
earliestPeriodOrLowestSystem,earliestPeriodOrLowestSystem
67
endDayOfYear,endDayOfYear
68
establishmentMeans,establishmentMeans
32 69
eventDate,eventDate
70
eventID,eventID
71
eventRemarks,eventRemarks
72
eventTime,eventTime
33 73
family,family
34 74
fieldNotes,fieldNotes
35 75
fieldNumber,fieldNumber
76
footprintSRS,footprintSRS
77
footprintSpatialFit,footprintSpatialFit
36 78
footprintWKT,footprintWKT
79
formation,formation
37 80
genus,genus
81
geodeticDatum,geodeticDatum
82
geologicalContextID,geologicalContextID
83
georeferenceProtocol,georeferenceProtocol
84
georeferenceRemarks,georeferenceRemarks
85
georeferenceSources,georeferenceSources
86
georeferenceVerificationStatus,georeferenceVerificationStatus
87
georeferencedBy,georeferencedBy
88
georeferencedDate,georeferencedDate
89
group,group
38 90
growthForm,growthForm
91
habitat,habitat
39 92
height,height
40 93
heightFirstBranch,heightFirstBranch
94
higherClassification,higherClassification
95
higherGeography,higherGeography
96
higherGeographyID,higherGeographyID
97
highestBiostratigraphicZone,highestBiostratigraphicZone
98
identificationID,identificationID
41 99
identificationQualifier,identificationQualifier
100
identificationReferences,identificationReferences
101
identificationRemarks,identificationRemarks
102
identificationVerificationStatus,identificationVerificationStatus
103
identifiedBy,identifiedBy
42 104
individualCount,individualCount
43 105
individualID,individualID
106
informationWithheld,informationWithheld
44 107
infraspecificEpithet,infraspecificEpithet
108
institutionCode,institutionCode
109
institutionID,institutionID
110
island,island
111
islandGroup,islandGroup
45 112
kingdom,kingdom
46 113
landform,landform
114
latestAgeOrHighestStage,latestAgeOrHighestStage
115
latestEonOrHighestEonothem,latestEonOrHighestEonothem
116
latestEpochOrHighestSeries,latestEpochOrHighestSeries
117
latestEraOrHighestErathem,latestEraOrHighestErathem
118
latestPeriodOrHighestSystem,latestPeriodOrHighestSystem
47 119
lianaInfestation,lianaInfestation
120
lifeStage,lifeStage
121
lithostratigraphicTerms,lithostratigraphicTerms
48 122
locality,locality
123
locationAccordingTo,locationAccordingTo
49 124
locationID,locationID
125
locationRemarks,locationRemarks
126
lowestBiostratigraphicZone,lowestBiostratigraphicZone
50 127
magnesium,magnesium
51 128
maximumDepthInMeters,maximumDepthInMeters
129
maximumDistanceAboveSurfaceInMeters,maximumDistanceAboveSurfaceInMeters
52 130
maximumElevationInMeters,maximumElevationInMeters
131
measurementAccuracy,measurementAccuracy
132
measurementDeterminedBy,measurementDeterminedBy
133
measurementDeterminedDate,measurementDeterminedDate
134
measurementID,measurementID
135
measurementMethod,measurementMethod
136
measurementRemarks,measurementRemarks
137
measurementType,measurementType
138
measurementUnit,measurementUnit
139
measurementValue,measurementValue
140
member,member
53 141
minimumDepthInMeters,minimumDepthInMeters
142
minimumDistanceAboveSurfaceInMeters,minimumDistanceAboveSurfaceInMeters
54 143
minimumElevationInMeters,minimumElevationInMeters
144
month,month
145
municipality,municipality
146
nameAccordingTo,nameAccordingTo
147
nameAccordingToID,nameAccordingToID
148
namePublishedIn,namePublishedIn
149
namePublishedInID,namePublishedInID
150
namePublishedInYear,namePublishedInYear
55 151
nitrogen,nitrogen
152
nomenclaturalCode,nomenclaturalCode
153
nomenclaturalStatus,nomenclaturalStatus
154
occurrenceID,occurrenceID
155
occurrenceRemarks,occurrenceRemarks
156
occurrenceStatus,occurrenceStatus
56 157
order,order
57 158
organic,organic
159
originalNameUsage,originalNameUsage
160
originalNameUsageID,originalNameUsageID
161
otherCatalogNumbers,otherCatalogNumbers
162
ownerInstitutionCode,ownerInstitutionCode
58 163
parentLocationID,parentLocationID
164
parentNameUsage,parentNameUsage
165
parentNameUsageID,parentNameUsageID
59 166
parentPlotName,parentPlotName
60 167
ph,ph
61 168
phosphorus,phosphorus
......
65 172
plotEventStartDate,plotEventStartDate
66 173
plotName,plotName
67 174
plotNotes,plotNotes
175
pointRadiusSpatialFit,pointRadiusSpatialFit
68 176
potassium,potassium
69 177
precipitation,precipitation
178
preparations,preparations
179
previousIdentifications,previousIdentifications
70 180
previousTag,previousTag
71 181
projectID,projectID
72 182
projectName,projectName
73 183
recordNumber,recordNumber
184
recordedBy,recordedBy
74 185
recordedBy.givenName,recordedBy.givenName
75 186
recordedBy.surName,recordedBy.surName
187
relatedResourceID,relatedResourceID
188
relationshipAccordingTo,relationshipAccordingTo
189
relationshipEstablishedDate,relationshipEstablishedDate
190
relationshipOfResource,relationshipOfResource
191
relationshipRemarks,relationshipRemarks
76 192
relativePlotX,relativePlotX
77 193
relativePlotY,relativePlotY
194
reproductiveCondition,reproductiveCondition
195
resourceID,resourceID
196
resourceRelationshipID,resourceRelationshipID
197
samplingEffort,samplingEffort
78 198
samplingProtocol,samplingProtocol
79 199
sand,sand
80 200
scientificName,scientificName
81 201
scientificNameAuthorship,scientificNameAuthorship
202
scientificNameID,scientificNameID
203
sex,sex
82 204
silt,silt
83 205
slopeAspect,slopeAspect
84 206
slopeGradient,slopeGradient
85 207
sodium,sodium
86 208
specificEpithet,specificEpithet
209
startDayOfYear,startDayOfYear
87 210
stateProvince,stateProvince
88 211
stemCount,stemCount
89 212
stemNotes,stemNotes
213
subgenus,subgenus
90 214
tag,tag
215
taxonConceptID,taxonConceptID
216
taxonID,taxonID
217
taxonRank,taxonRank
218
taxonRemarks,taxonRemarks
219
taxonomicStatus,taxonomicStatus
91 220
temperature,temperature
92 221
texture,texture
222
typeStatus,typeStatus
223
verbatimCoordinateSystem,verbatimCoordinateSystem
224
verbatimCoordinates,verbatimCoordinates
225
verbatimDepth,verbatimDepth
93 226
verbatimElevation,verbatimElevation
227
verbatimEventDate,verbatimEventDate
228
verbatimLatitude,verbatimLatitude
229
verbatimLocality,verbatimLocality
230
verbatimLongitude,verbatimLongitude
231
verbatimSRS,verbatimSRS
232
verbatimTaxonRank,verbatimTaxonRank
233
vernacularName,vernacularName
94 234
volumeCanopy,volumeCanopy
95 235
voucherType,voucherType
236
waterBody,waterBody
237
year,year
mappings/for_review/DwC2-VegBIEN.specimens.csv
30 30
dateCollected,//aggregateoccurrence/collectiondate/_*/date,
31 31
individualCount,//aggregateoccurrence/count,
32 32
fieldNotes,//aggregateoccurrence/notes,
33
recordNumber,//plantobservation/authorplantcode,
33
recordNumber,//plantobservation/collectionnumber,
34 34
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 35
individualID,//plantobservation/sourceaccessioncode,
36 36
catalogNumber,"//specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
37 37
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 38
collectionID,//specimenreplicate/collectioncode_dwc,
39
recordNumber,//specimenreplicate/collectionnumber,
40 39
institutionCode,//party/organizationname,
41 40
occurrenceID,//specimenreplicate/sourceaccessioncode,
42 41
recordNumber,//taxonoccurrence/authortaxoncode,
mappings/DwC.cs-VegBIEN.specimens.csv
58 58
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
59 59
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
60 60
notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
61
collectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_alt/1,
62
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_alt/2,
61
collectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/1,
62
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2,
63 63
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 64
individualID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
65 65
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
66 66
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 67
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_merge/2,
68
collectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1,
69
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,
70 68
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
71 69
globalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
72 70
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
inputs/XAL/test/import.specimens.xml.ref
239 239
                    <count>$IndividualCount</count>
240 240
                    <notes>$Notes</notes>
241 241
                    <plantobservation>
242
                        <authorplantcode>$CollectorNumber</authorplantcode>
242
                        <collectionnumber>$CollectorNumber</collectionnumber>
243 243
                        <definedvalue fkey="tablerecord_id">
244 244
                            <userdefined_id>
245 245
                                <userdefined>
......
252 252
                        <specimenreplicate>
253 253
                            <catalognumber_dwc><_if name="if indirect voucher"><else>$CatalogNumber</else></_if></catalognumber_dwc>
254 254
                            <collectioncode_dwc>$CollectionCode</collectioncode_dwc>
255
                            <collectionnumber>$CollectorNumber</collectionnumber>
256 255
                            <institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id>
257 256
                        </specimenreplicate>
258 257
                    </plantobservation>
inputs/XAL/maps/VegBIEN.specimens.csv
26 26
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
27 27
IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
28 28
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
29
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_alt/1,
29
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/1,
30 30
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"
31 31
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
32 32
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
33
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1,
34 33
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
35 34
CollectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,
36 35
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
inputs/NY/test/import.specimens.xml.ref
269 269
                        </_merge>
270 270
                    </notes>
271 271
                    <plantobservation>
272
                        <authorplantcode>
272
                        <collectionnumber>
273 273
                            <_alt>
274 274
                                <1>$CollectorNumber</1>
275 275
                                <2>$FieldNumber</2>
276 276
                            </_alt>
277
                        </authorplantcode>
277
                        </collectionnumber>
278 278
                        <definedvalue fkey="tablerecord_id">
279 279
                            <userdefined_id>
280 280
                                <userdefined>
......
287 287
                        <specimenreplicate>
288 288
                            <catalognumber_dwc><_if name="if indirect voucher"><else>$CatalogNumber</else></_if></catalognumber_dwc>
289 289
                            <collectioncode_dwc>$CollectionCode</collectioncode_dwc>
290
                            <collectionnumber>
291
                                <_alt>
292
                                    <1>$CollectorNumber</1>
293
                                    <2>$FieldNumber</2>
294
                                </_alt>
295
                            </collectionnumber>
296 290
                            <institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id>
297 291
                            <sourceaccessioncode>$UniqueNYInternalRecordNumber</sourceaccessioncode>
298 292
                        </specimenreplicate>
inputs/NY/maps/VegBIEN.specimens.csv
28 28
IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
29 29
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_merge/1,
30 30
PlantFungusDescription,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_merge/2/_label[label=""plant fungus""]/value",
31
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_alt/1,
32
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_alt/2,Usage inconsistent with DwC definition
31
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/1,
32
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2,Usage inconsistent with DwC definition
33 33
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"
34 34
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
35 35
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
36
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1,
37
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,Usage inconsistent with DwC definition
38 36
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
39 37
UniqueNYInternalRecordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
40 38
CollectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,
inputs/UNCC/test/import.specimens.xml.ref
158 158
                        </_merge>
159 159
                    </notes>
160 160
                    <plantobservation>
161
                        <authorplantcode>$collectno</authorplantcode>
161
                        <collectionnumber>$collectno</collectionnumber>
162 162
                        <specimenreplicate>
163
                            <collectionnumber>$collectno</collectionnumber>
164 163
                            <institution_id><party><organizationname>$herbarium</organizationname></party></institution_id>
165 164
                            <sourceaccessioncode>$accession</sourceaccessioncode>
166 165
                        </specimenreplicate>
inputs/UNCC/maps/VegBIEN.specimens.csv
20 20
campus,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_merge/5/_label[label=""campus""]/value",
21 21
loanto,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_merge/6/_label[label=""loaned to""]/value",
22 22
inorout,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_merge/7/_label[label=""in or out""]/value",
23
collectno,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_alt/1,
24
collectno,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1,
23
collectno,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/1,
25 24
herbarium,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
26 25
accession,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
27 26
collectno,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,
inputs/ACAD/test/import.specimens.xml.ref
76 76
            <taxonoccurrence>
77 77
                <aggregateoccurrence>
78 78
                    <plantobservation>
79
                        <authorplantcode>$recordNumber</authorplantcode>
79
                        <collectionnumber>$recordNumber</collectionnumber>
80 80
                        <specimenreplicate>
81 81
                            <catalognumber_dwc><_if name="if indirect voucher"><else>$catalogNumber</else></_if></catalognumber_dwc>
82 82
                            <collectioncode_dwc>
......
85 85
                                    <2>$collectionID</2>
86 86
                                </_merge>
87 87
                            </collectioncode_dwc>
88
                            <collectionnumber>$recordNumber</collectionnumber>
89 88
                            <institution_id><party><organizationname>$institutionCode</organizationname></party></institution_id>
90 89
                            <sourceaccessioncode>$id</sourceaccessioncode>
91 90
                        </specimenreplicate>
inputs/ACAD/maps/VegBIEN.specimens.csv
13 13
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",
14 14
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1,
15 15
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1,
16
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_alt/2,
16
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2,
17 17
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
18 18
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
19 19
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_merge/2,
20
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,
21 20
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
22 21
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
23 22
recordNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,
inputs/SALVIAS-CSV/test/import.organisms.xml.ref
39 39
                    </definedvalue>
40 40
                    <linecover>$intercept_cm</linecover>
41 41
                    <plantobservation>
42
                        <authorplantcode>$individual_code</authorplantcode>
42
                        <collectionnumber>$individual_code</collectionnumber>
43 43
                        <sourceaccessioncode>$OBSERVATION_ID</sourceaccessioncode>
44 44
                        <specimenreplicate>
45 45
                            <catalognumber_dwc>
inputs/SALVIAS-CSV/maps/VegBIEN.organisms.csv
15 15
cover_percent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover,
16 16
census_no,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue","Brad: Assigned by SALVIAS. 1 for first plot, then 2, 3, etc. I can't recall if we even have repeat censuses in SALVIAS. Probably not."
17 17
intercept_cm,/location/locationevent/taxonoccurrence/aggregateoccurrence/linecover,"Brad: Incorrect for VegBank This is an aggregate observation. Used in line-intercept methodology only, describes the point along centerline at which an individual intercepts the center line of the plot. Used to determin relative abundance."
18
individual_code,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode,"Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot."
18
individual_code,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber,"Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot."
19 19
OBSERVATION_ID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,"Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."
20 20
det_type,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left","Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider  asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen."
21 21
coll_number,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else/_alt/1",Brad: Incorrect. Map instead as for voucher_string
inputs/SALVIAS/test/import.organisms.xml.ref
41 41
                    <linecover>$intercept_cm</linecover>
42 42
                    <notes>$Notes</notes>
43 43
                    <plantobservation>
44
                        <authorplantcode>$Ind</authorplantcode>
44
                        <collectionnumber>$Ind</collectionnumber>
45 45
                        <sourceaccessioncode>$PlotObsID</sourceaccessioncode>
46 46
                        <specimenreplicate>
47 47
                            <catalognumber_dwc>
inputs/SALVIAS/maps/VegBIEN.organisms.csv
24 24
census_no,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue","Brad: Assigned by SALVIAS. 1 for first plot, then 2, 3, etc. I can't recall if we even have repeat censuses in SALVIAS. Probably not."
25 25
intercept_cm,/location/locationevent/taxonoccurrence/aggregateoccurrence/linecover,"Brad: Incorrect for VegBank This is an aggregate observation. Used in line-intercept methodology only, describes the point along centerline at which an individual intercepts the center line of the plot. Used to determin relative abundance."
26 26
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
27
Ind,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode,"Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot."
27
Ind,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber,"Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot."
28 28
PlotObsID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,"Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."
29 29
DetType,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left","Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider  asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen."
30 30
coll_number,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else/_alt/1",Brad: Incorrect. Map instead as for voucher_string
inputs/U/test/import.specimens.xml.ref
145 145
                    </collectiondate>
146 146
                    <notes>$Notes</notes>
147 147
                    <plantobservation>
148
                        <authorplantcode>$Number</authorplantcode>
148
                        <collectionnumber>$Number</collectionnumber>
149 149
                        <specimenreplicate>
150 150
                            <catalognumber_dwc><_if name="if indirect voucher"><else>$Barcode</else></_if></catalognumber_dwc>
151
                            <collectionnumber>$Number</collectionnumber>
152 151
                            <sourceaccessioncode>$ID</sourceaccessioncode>
153 152
                        </specimenreplicate>
154 153
                    </plantobservation>
inputs/U/maps/VegBIEN.specimens.csv
14 14
Collmm,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
15 15
Collyy,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
16 16
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
17
Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_alt/2,
17
Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2,
18 18
Barcode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
19
Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,
20 19
ID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
21 20
Number,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,
22 21
Detby,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
inputs/ARIZ/test/import.specimens.xml.ref
291 291
                    <count>$IndividualCount</count>
292 292
                    <notes>$FieldNotes</notes>
293 293
                    <plantobservation>
294
                        <authorplantcode>
294
                        <collectionnumber>
295 295
                            <_alt>
296 296
                                <1>$CollectorNumber</1>
297 297
                                <2>$FieldNumber</2>
298 298
                            </_alt>
299
                        </authorplantcode>
299
                        </collectionnumber>
300 300
                        <definedvalue fkey="tablerecord_id">
301 301
                            <userdefined_id>
302 302
                                <userdefined>
......
309 309
                        <specimenreplicate>
310 310
                            <catalognumber_dwc><_if name="if indirect voucher"><else>$CatalogNumberNumeric</else></_if></catalognumber_dwc>
311 311
                            <collectioncode_dwc>$CollectionCode</collectioncode_dwc>
312
                            <collectionnumber>
313
                                <_alt>
314
                                    <1>$CollectorNumber</1>
315
                                    <2>$FieldNumber</2>
316
                                </_alt>
317
                            </collectionnumber>
318 312
                            <institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id>
319 313
                            <sourceaccessioncode>$GlobalUniqueIdentifier</sourceaccessioncode>
320 314
                        </specimenreplicate>
inputs/ARIZ/maps/VegBIEN.specimens.csv
33 33
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
34 34
IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
35 35
FieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
36
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_alt/1,
37
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_alt/2,Usage inconsistent with DwC definition
36
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/1,
37
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2,Usage inconsistent with DwC definition
38 38
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"
39 39
CatalogNumberNumeric,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
40 40
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
41
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1,
42
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,Usage inconsistent with DwC definition
43 41
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
44 42
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
45 43
CollectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,
inputs/SpeciesLink/test/import.specimens.xml.ref
391 391
                    </count>
392 392
                    <notes>$conceptual_darwin_2003_1_0_Notes</notes>
393 393
                    <plantobservation>
394
                        <authorplantcode>
394
                        <collectionnumber>
395 395
                            <_alt>
396 396
                                <1>
397 397
                                    <_alt>
......
401 401
                                </1>
402 402
                                <2>$dwc_terms_recordNumber</2>
403 403
                            </_alt>
404
                        </authorplantcode>
404
                        </collectionnumber>
405 405
                        <definedvalue fkey="tablerecord_id">
406 406
                            <userdefined_id>
407 407
                                <userdefined>
......
441 441
                                    <2>$dwc_terms_collectionID</2>
442 442
                                </_merge>
443 443
                            </collectioncode_dwc>
444
                            <collectionnumber>
445
                                <_alt>
446
                                    <1>
447
                                        <_alt>
448
                                            <0>$dwc_curatorial_CollectorNumber</0>
449
                                            <1>$conceptual_darwin_2003_1_0_CollectorNumber</1>
450
                                        </_alt>
451
                                    </1>
452
                                    <2>$dwc_terms_recordNumber</2>
453
                                </_alt>
454
                            </collectionnumber>
455 444
                            <institution_id>
456 445
                                <party>
457 446
                                    <organizationname>
inputs/SpeciesLink/maps/VegBIEN.specimens.csv
58 58
IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
59 59
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
60 60
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
61
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_alt/1,
62
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_alt/2,
61
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/1,
62
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2,
63 63
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 64
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"
65 65
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
......
67 67
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
68 68
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
69 69
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_merge/2,
70
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1,
71
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,
72 70
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
73 71
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
74 72
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
inputs/MO/test/import.specimens.xml.ref
237 237
                    <count>$IndividualCount</count>
238 238
                    <notes>$convertednotes</notes>
239 239
                    <plantobservation>
240
                        <authorplantcode>$CollectorNumber</authorplantcode>
240
                        <collectionnumber>$CollectorNumber</collectionnumber>
241 241
                        <specimenreplicate>
242 242
                            <catalognumber_dwc><_if name="if indirect voucher"><else>$CatalogNumber</else></_if></catalognumber_dwc>
243 243
                            <collectioncode_dwc>$CollectionCode</collectioncode_dwc>
244
                            <collectionnumber>$CollectorNumber</collectionnumber>
245 244
                            <institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id>
246 245
                        </specimenreplicate>
247 246
                    </plantobservation>
inputs/MO/maps/VegBIEN.specimens.csv
24 24
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
25 25
IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
26 26
convertednotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
27
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_alt/1,
27
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/1,
28 28
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
29 29
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
30
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1,
31 30
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
32 31
CollectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,
33 32
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
schemas/vegbien.my.sql
1559 1559
    aggregateoccurrence_id int(11) NOT NULL,
1560 1560
    overallheight double precision,
1561 1561
    overallheightaccuracy double precision,
1562
    authorplantcode text,
1562
    collectionnumber text,
1563 1563
    stemcount int(11),
1564 1564
    plant_id int(11),
1565 1565
    accessioncode text
......
1574 1574

  
1575 1575

  
1576 1576
--
1577
-- Name: COLUMN plantobservation.collectionnumber; Type: COMMENT; Schema: public; Owner: -
1578
--
1579

  
1580

  
1581

  
1582

  
1583
--
1577 1584
-- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1578 1585
--
1579 1586

  
......
2122 2129
    institution_id int(11),
2123 2130
    collectioncode_dwc text,
2124 2131
    catalognumber_dwc text,
2125
    collectionnumber text,
2126 2132
    description text,
2127 2133
    specimen_id int(11),
2128 2134
    accessioncode text
......
2151 2157

  
2152 2158

  
2153 2159
--
2154
-- Name: COLUMN specimenreplicate.collectionnumber; Type: COMMENT; Schema: public; Owner: -
2155
--
2156

  
2157

  
2158

  
2159

  
2160
--
2161 2160
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2162 2161
--
2163 2162

  
schemas/vegbien.sql
1965 1965
    aggregateoccurrence_id integer NOT NULL,
1966 1966
    overallheight double precision,
1967 1967
    overallheightaccuracy double precision,
1968
    authorplantcode text,
1968
    collectionnumber text,
1969 1969
    stemcount integer,
1970 1970
    plant_id integer,
1971 1971
    accessioncode text
......
1980 1980

  
1981 1981

  
1982 1982
--
1983
-- Name: COLUMN plantobservation.collectionnumber; Type: COMMENT; Schema: public; Owner: -
1984
--
1985

  
1986
COMMENT ON COLUMN plantobservation.collectionnumber IS 'The number of the organism within the data collection or event.';
1987

  
1988

  
1989
--
1983 1990
-- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1984 1991
--
1985 1992

  
......
2598 2605
    institution_id integer,
2599 2606
    collectioncode_dwc text,
2600 2607
    catalognumber_dwc text,
2601
    collectionnumber text,
2602 2608
    description text,
2603 2609
    specimen_id integer,
2604 2610
    accessioncode text,
......
2628 2634

  
2629 2635

  
2630 2636
--
2631
-- Name: COLUMN specimenreplicate.collectionnumber; Type: COMMENT; Schema: public; Owner: -
2632
--
2633

  
2634
COMMENT ON COLUMN specimenreplicate.collectionnumber IS 'The number of the specimenreplicate within the collection.';
2635

  
2636

  
2637
--
2638 2637
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2639 2638
--
2640 2639

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

Also available in: Unified diff