Project

General

Profile

« Previous | Next » 

Revision 4007

Added by Aaron Marcuse-Kubitza over 12 years ago

mappings/DwC2-VegBIEN.specimens.csv: recordNumber: Added VegCSV mappings for it

View differences:

inputs/XAL/test/import.specimens.xml.ref
193 193 
                    <count>$IndividualCount</count>
194 194 
                    <notes>$Notes</notes>
195 195 
                    <plantobservation>
196 
                        <authorplantcode><_alt><1>$CollectorNumber</1></_alt></authorplantcode>
196 197 
                        <definedvalue fkey="tablerecord_id">
197 198 
                            <userdefined_id>
198 199 
                                <userdefined>
......
210 211 
                        </specimenreplicate>
211 212 
                    </plantobservation>
212 213 
                </aggregateoccurrence>
214 
                <sourceaccessioncode><_alt><2><_alt><1>$CollectorNumber</1></_alt></2></_alt></sourceaccessioncode>
213 215 
                <taxondetermination>
214 216 
                    <isoriginal>true</isoriginal>
215 217 
                    <role>identifier</role>
inputs/XAL/maps/VegBIEN.specimens.csv
20 20 
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
21 21 
IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
22 22 
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
23 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_alt/1,
23 24 
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"
24 25 
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",
25 26 
CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/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
26 27 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1,
27 28 
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
29 
CollectorNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/1,
28 30 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
29 31 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
30 32 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last,
inputs/NY/test/import.specimens.xml.ref
218 218 
                        </_merge>
219 219 
                    </notes>
220 220 
                    <plantobservation>
221 
                        <authorplantcode>
222 
                            <_alt>
223 
                                <1>$CollectorNumber</1>
224 
                                <2>$FieldNumber</2>
225 
                            </_alt>
226 
                        </authorplantcode>
221 227 
                        <definedvalue fkey="tablerecord_id">
222 228 
                            <userdefined_id>
223 229 
                                <userdefined>
......
242 248 
                        </specimenreplicate>
243 249 
                    </plantobservation>
244 250 
                </aggregateoccurrence>
245 
                <sourceaccessioncode><_alt><1>$UniqueNYInternalRecordNumber</1></_alt></sourceaccessioncode>
251 
                <sourceaccessioncode>
252 
                    <_alt>
253 
                        <1>$UniqueNYInternalRecordNumber</1>
254 
                        <2>
255 
                            <_alt>
256 
                                <1>$CollectorNumber</1>
257 
                                <2>$FieldNumber</2>
258 
                            </_alt>
259 
                        </2>
260 
                    </_alt>
261 
                </sourceaccessioncode>
246 262 
                <taxondetermination>
247 263 
                    <isoriginal>true</isoriginal>
248 264 
                    <role>identifier</role>
inputs/NY/maps/VegBIEN.specimens.csv
21 21 
IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
22 22 
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_merge/1,
23 23 
PlantFungusDescription,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_merge/2/_label[label=""plant fungus""]/value",
24 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_alt/1,
25 
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_alt/2,Usage inconsistent with DwC definition
24 26 
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"
25 27 
UniqueNYInternalRecordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
26 28 
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",
......
30 32 
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
31 33 
UniqueNYInternalRecordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
32 34 
UniqueNYInternalRecordNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
35 
CollectorNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/1,
36 
FieldNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/2,Usage inconsistent with DwC definition
33 37 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
34 38 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
35 39 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last,
inputs/UNCC/test/import.specimens.xml.ref
95 95 
                        </_merge>
96 96 
                    </notes>
97 97 
                    <plantobservation>
98 
                        <authorplantcode><_alt><1>$collectno</1></_alt></authorplantcode>
98 99 
                        <sourceaccessioncode>$accession</sourceaccessioncode>
99 100 
                        <specimenreplicate>
100 101 
                            <collectionnumber><_alt><1>$collectno</1></_alt></collectionnumber>
......
133 134 
                        </value>
134 135 
                    </_map>
135 136 
                </isnative>
136 
                <sourceaccessioncode><_alt><1>$accession</1></_alt></sourceaccessioncode>
137 
                <sourceaccessioncode>
138 
                    <_alt>
139 
                        <1>$accession</1>
140 
                        <2><_alt><1>$collectno</1></_alt></2>
141 
                    </_alt>
142 
                </sourceaccessioncode>
137 143 
                <taxondetermination>
138 144 
                    <isoriginal>true</isoriginal>
139 145 
                    <role>identifier</role>
inputs/UNCC/maps/VegBIEN.specimens.csv
13 13 
campus,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_merge/5/_label[label=""campus""]/value",
14 14 
loanto,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_merge/6/_label[label=""loaned to""]/value",
15 15 
inorout,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_merge/7/_label[label=""in or out""]/value",
16 
collectno,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_alt/1,
16 17 
accession,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
17 18 
collectno,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1,
18 19 
herbarium,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
......
20 21 
cultivated,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value/_map:[Y=cultivated,N=wild,*=]/value",Ignore other values
21 22 
cultivated,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value/_map:[Y=cultivated,N=wild,*=]/value",Ignore other values
22 23 
accession,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
24 
collectno,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/1,
23 25 
SciName,"/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",
24 26 
authors,"/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",
25 27 
infraname,"/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",
inputs/ACAD/test/import.specimens.xml.ref
77 77 
                <aggregateoccurrence>
78 78 
                    <collectiondate><_date><date><_dateRangeStart><value><_alt><2>$eventDate</2></_alt></value></_dateRangeStart></date></_date></collectiondate>
79 79 
                    <plantobservation>
80 
                        <authorplantcode><_alt><2>$recordNumber</2></_alt></authorplantcode>
80 81 
                        <sourceaccessioncode>$id</sourceaccessioncode>
81 82 
                        <specimenreplicate>
82 83 
                            <_if name="if indirect voucher"><else><catalognumber_dwc>$catalogNumber</catalognumber_dwc></else></_if>
......
92 93 
                        </specimenreplicate>
93 94 
                    </plantobservation>
94 95 
                </aggregateoccurrence>
95 
                <sourceaccessioncode><_alt><1>$id</1></_alt></sourceaccessioncode>
96 
                <sourceaccessioncode>
97 
                    <_alt>
98 
                        <1>$id</1>
99 
                        <2><_alt><2>$recordNumber</2></_alt></2>
100 
                    </_alt>
101 
                </sourceaccessioncode>
96 102 
                <taxondetermination>
97 103 
                    <isoriginal>true</isoriginal>
98 104 
                    <role>identifier</role>
inputs/ACAD/maps/VegBIEN.specimens.csv
10 10 
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",
11 11 
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",
12 12 
eventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/2,
13 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_alt/2,
13 14 
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
14 15 
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",
15 16 
collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/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
......
18 19 
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
19 20 
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
20 21 
id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
22 
recordNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/2,
21 23 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
22 24 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
23 25 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last,
inputs/U/test/import.specimens.xml.ref
90 90 
                    </collectiondate>
91 91 
                    <notes>$Notes</notes>
92 92 
                    <plantobservation>
93 
                        <authorplantcode><_alt><2>$Number</2></_alt></authorplantcode>
93 94 
                        <sourceaccessioncode>$ID</sourceaccessioncode>
94 95 
                        <specimenreplicate>
95 96 
                            <_if name="if indirect voucher"><else><catalognumber_dwc>$Barcode</catalognumber_dwc></else></_if>
......
98 99 
                        </specimenreplicate>
99 100 
                    </plantobservation>
100 101 
                </aggregateoccurrence>
101 
                <sourceaccessioncode><_alt><1>$ID</1></_alt></sourceaccessioncode>
102 
                <sourceaccessioncode>
103 
                    <_alt>
104 
                        <1>$ID</1>
105 
                        <2><_alt><2>$Number</2></_alt></2>
106 
                    </_alt>
107 
                </sourceaccessioncode>
102 108 
                <taxondetermination>
103 109 
                    <isoriginal>true</isoriginal>
104 110 
                    <role>identifier</role>
inputs/U/maps/VegBIEN.specimens.csv
7 7 
Collmm,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
8 8 
Collyy,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
9 9 
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
10 
Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_alt/2,
10 11 
ID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
11 12 
Barcode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",
12 13 
Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,
13 14 
ID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
14 15 
ID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
16 
Number,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/2,
15 17 
Detby,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
16 18 
Detby,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
17 19 
Detby,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last,
inputs/ARIZ/test/import.specimens.xml.ref
210 210 
                    <count>$IndividualCount</count>
211 211 
                    <notes>$FieldNotes</notes>
212 212 
                    <plantobservation>
213 
                        <authorplantcode>
214 
                            <_alt>
215 
                                <1>$CollectorNumber</1>
216 
                                <2>$FieldNumber</2>
217 
                            </_alt>
218 
                        </authorplantcode>
213 219 
                        <definedvalue fkey="tablerecord_id">
214 220 
                            <userdefined_id>
215 221 
                                <userdefined>
......
234 240 
                        </specimenreplicate>
235 241 
                    </plantobservation>
236 242 
                </aggregateoccurrence>
237 
                <sourceaccessioncode><_alt><1>$GlobalUniqueIdentifier</1></_alt></sourceaccessioncode>
243 
                <sourceaccessioncode>
244 
                    <_alt>
245 
                        <1>$GlobalUniqueIdentifier</1>
246 
                        <2>
247 
                            <_alt>
248 
                                <1>$CollectorNumber</1>
249 
                                <2>$FieldNumber</2>
250 
                            </_alt>
251 
                        </2>
252 
                    </_alt>
253 
                </sourceaccessioncode>
238 254 
                <taxondetermination>
239 255 
                    <isoriginal>true</isoriginal>
240 256 
                    <role>identifier</role>
inputs/ARIZ/maps/VegBIEN.specimens.csv
24 24 
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
25 25 
IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
26 26 
FieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
27 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_alt/1,
28 
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_alt/2,Usage inconsistent with DwC definition
27 29 
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"
28 30 
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
29 31 
CatalogNumberNumeric,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",
......
33 35 
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
34 36 
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
35 37 
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
38 
CollectorNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/1,
39 
FieldNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/2,Usage inconsistent with DwC definition
36 40 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
37 41 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
38 42 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last,
inputs/SpeciesLink/test/import.specimens.xml.ref
303 303 
                    </count>
304 304 
                    <notes>$conceptual_darwin_2003_1_0_Notes</notes>
305 305 
                    <plantobservation>
306 
                        <authorplantcode>
307 
                            <_alt>
308 
                                <1>
309 
                                    <_alt>
310 
                                        <0>$dwc_curatorial_CollectorNumber</0>
311 
                                        <1>$conceptual_darwin_2003_1_0_CollectorNumber</1>
312 
                                    </_alt>
313 
                                </1>
314 
                                <2>$dwc_terms_recordNumber</2>
315 
                            </_alt>
316 
                        </authorplantcode>
306 317 
                        <definedvalue fkey="tablerecord_id">
307 318 
                            <userdefined_id>
308 319 
                                <userdefined>
......
369 380 
                        </specimenreplicate>
370 381 
                    </plantobservation>
371 382 
                </aggregateoccurrence>
372 
                <sourceaccessioncode><_alt><1>$dwc_dwcore_GlobalUniqueIdentifier</1></_alt></sourceaccessioncode>
383 
                <sourceaccessioncode>
384 
                    <_alt>
385 
                        <1>$dwc_dwcore_GlobalUniqueIdentifier</1>
386 
                        <2>
387 
                            <_alt>
388 
                                <1>
389 
                                    <_alt>
390 
                                        <0>$dwc_curatorial_CollectorNumber</0>
391 
                                        <1>$conceptual_darwin_2003_1_0_CollectorNumber</1>
392 
                                    </_alt>
393 
                                </1>
394 
                                <2>$dwc_terms_recordNumber</2>
395 
                            </_alt>
396 
                        </2>
397 
                    </_alt>
398 
                </sourceaccessioncode>
373 399 
                <taxondetermination>
374 400 
                    <isoriginal>true</isoriginal>
375 401 
                    <role>identifier</role>
inputs/SpeciesLink/maps/VegBIEN.specimens.csv
50 50 
IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
51 51 
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
52 52 
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
53 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_alt/1,
54 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_alt/2,
53 55 
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"
54 56 
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"
55 57 
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
......
64 66 
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
65 67 
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
66 68 
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
69 
CollectorNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/1,
70 
recordNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/2,
67 71 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
68 72 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
69 73 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
inputs/MO/test/import.specimens.xml.ref
191 191 
                    <count>$IndividualCount</count>
192 192 
                    <notes>$convertednotes</notes>
193 193 
                    <plantobservation>
194 
                        <authorplantcode><_alt><1>$CollectorNumber</1></_alt></authorplantcode>
194 195 
                        <specimenreplicate>
195 196 
                            <_if name="if indirect voucher"><else><catalognumber_dwc>$CatalogNumber</catalognumber_dwc></else></_if>
196 197 
                            <collectioncode_dwc><_alt><1>$CollectionCode</1></_alt></collectioncode_dwc>
......
199 200 
                        </specimenreplicate>
200 201 
                    </plantobservation>
201 202 
                </aggregateoccurrence>
203 
                <sourceaccessioncode><_alt><2><_alt><1>$CollectorNumber</1></_alt></2></_alt></sourceaccessioncode>
202 204 
                <taxondetermination>
203 205 
                    <isoriginal>true</isoriginal>
204 206 
                    <role>identifier</role>
inputs/MO/maps/VegBIEN.specimens.csv
18 18 
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
19 19 
IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
20 20 
convertednotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
21 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_alt/1,
21 22 
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",
22 23 
CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/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
23 24 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1,
24 25 
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
26 
CollectorNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/1,
25 27 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
26 28 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
27 29 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last,
mappings/DwC2-VegBIEN.specimens.csv
24 24 
eventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value,
25 25 
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
26 26 
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
27 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode,
27 28 
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"
28 29 
occurrenceID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
29 30 
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",
......
35 36 
establishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value",
36 37 
establishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value",
37 38 
occurrenceID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
39 
recordNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2,
38 40 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
39 41 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
40 42 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last,
mappings/for_review/DwC2-VegBIEN.specimens.csv
24 24 
eventDate,//aggregateoccurrence/collectiondate/_*/date,
25 25 
individualCount,//aggregateoccurrence/count,
26 26 
fieldNotes,//aggregateoccurrence/notes,
27 
recordNumber,//plantobservation/authorplantcode,
27 28 
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"
28 29 
occurrenceID,//plantobservation/sourceaccessioncode,
29 30 
catalogNumber,"//plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",
......
35 36 
establishmentMeans,//taxonoccurrence/iscultivated,
36 37 
establishmentMeans,//taxonoccurrence/isnative,
37 38 
occurrenceID,//taxonoccurrence/sourceaccessioncode,
39 
recordNumber,//taxonoccurrence/sourceaccessioncode,
38 40 
identifiedBy,//taxonoccurrence/taxondetermination[role=identifier]/*_id/party/givenname,
39 41 
identifiedBy,//taxonoccurrence/taxondetermination[role=identifier]/*_id/party/middlename,
40 42 
identifiedBy,//taxonoccurrence/taxondetermination[role=identifier]/*_id/party/surname,
mappings/DwC-VegBIEN.specimens.csv
81 81 
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
82 82 
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
83 83 
notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
84 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_alt/1,
85 
collectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_alt/1,
86 
RecordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_alt/2,
87 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_alt/2,
84 88 
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"
85 89 
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"
86 90 
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
......
117 121 
globalUniqueIdentifier,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
118 122 
id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
119 123 
occurrenceID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
124 
CollectorNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/1,
125 
collectorNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/1,
126 
RecordNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/2,
127 
recordNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/2,
120 128 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
121 129 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
122 130 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
mappings/DwC.cs-VegBIEN.specimens.csv
40 40 
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
41 41 
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
42 42 
notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
43 
collectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_alt/1,
44 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_alt/2,
43 45 
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"
44 46 
globalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
45 47 
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
......
58 60 
globalUniqueIdentifier,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
59 61 
id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
60 62 
occurrenceID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
63 
collectorNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/1,
64 
recordNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_alt/2,
61 65 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
62 66 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
63 67 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last,

Also available in: Unified diff