Project

General

Profile

« Previous | Next » 

Revision 3973

Added by Aaron Marcuse-Kubitza over 12 years ago

mappings/DwC2-VegBIEN.specimens.csv: fieldNumber: Remapped to authoreventcode because this is (confusingly) the author code for the event, according to the DwC definition

View differences:

inputs/XAL/test/import.specimens.xml.ref
133 133 
            </namedplace_id>
134 134 
        </locationdetermination>
135 135 
        <locationevent>
136 
            <authoreventcode>$FieldNumber</authoreventcode>
136 137 
            <taxonoccurrence>
137 138 
                <aggregateoccurrence>
138 139 
                    <collectiondate>
......
186 187 
                        <specimenreplicate>
187 188 
                            <_if name="if indirect voucher"><else><catalognumber_dwc>$CatalogNumber</catalognumber_dwc></else></_if>
188 189 
                            <collectioncode_dwc><_alt><1>$CollectionCode</1></_alt></collectioncode_dwc>
189 
                            <collectionnumber>
190 
                                <_alt>
191 
                                    <1><_alt><1>$CollectorNumber</1></_alt></1>
192 
                                    <3>$FieldNumber</3>
193 
                                </_alt>
194 
                            </collectionnumber>
190 
                            <collectionnumber><_alt><1>$CollectorNumber</1></_alt></collectionnumber>
195 191 
                            <institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id>
196 192 
                        </specimenreplicate>
197 193 
                    </plantobservation>
inputs/XAL/maps/VegBIEN.specimens.csv
11 11 
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",
12 12 
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",
13 13 
ContinentOcean,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
14 
FieldNumber,/location/locationevent/authoreventcode,
14 15 
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
15 16 
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
16 17 
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
......
18 19 
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"
19 20 
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",
20 21 
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
21 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/1,
22 
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/3,
22 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1,
23 23 
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
24 24 
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
25 25 
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
inputs/NY/test/import.specimens.xml.ref
214 214 
                            <collectioncode_dwc><_alt><1>$CollectionCode</1></_alt></collectioncode_dwc>
215 215 
                            <collectionnumber>
216 216 
                                <_alt>
217 
                                    <1>
218 
                                        <_alt>
219 
                                            <1>$CollectorNumber</1>
220 
                                            <2>$FieldNumber</2>
221 
                                        </_alt>
222 
                                    </1>
217 
                                    <1>$CollectorNumber</1>
218 
                                    <2>$FieldNumber</2>
223 219 
                                </_alt>
224 220 
                            </collectionnumber>
225 221 
                            <institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id>
inputs/NY/maps/VegBIEN.specimens.csv
20 20 
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"
21 21 
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",
22 22 
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 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/1,
24 
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/2,Usage inconsistent with DwC definition
23 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1,
24 
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,Usage inconsistent with DwC definition
25 25 
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
26 26 
UniqueNYInternalRecordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
27 27 
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
inputs/UNCC/test/import.specimens.xml.ref
96 96 
                    <plantobservation>
97 97 
                        <specimenreplicate>
98 98 
                            <collectioncode_dwc><_alt><1>$herbarium</1></_alt></collectioncode_dwc>
99 
                            <collectionnumber><_alt><1><_alt><1>$collectno</1></_alt></1></_alt></collectionnumber>
99 
                            <collectionnumber><_alt><1>$collectno</1></_alt></collectionnumber>
100 100 
                            <sourceaccessioncode>$accession</sourceaccessioncode>
101 101 
                        </specimenreplicate>
102 102 
                    </plantobservation>
inputs/UNCC/maps/VegBIEN.specimens.csv
13 13 
loanto,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_merge/6/_label[label=""loaned to""]/value",
14 14 
inorout,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_merge/7/_label[label=""in or out""]/value",
15 15 
herbarium,/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
16 
collectno,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/1,
16 
collectno,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1,
17 17 
accession,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
18 18 
cultivated,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value/_map:[Y=cultivated,N=wild,*=]/value",Ignore other values
19 19 
cultivated,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value/_map:[Y=cultivated,N=wild,*=]/value",Ignore other values
inputs/ACAD/test/import.specimens.xml.ref
68 68 
                                    <2>$collectionID</2>
69 69 
                                </_alt>
70 70 
                            </collectioncode_dwc>
71 
                            <collectionnumber><_alt><1><_alt><2>$recordNumber</2></_alt></1></_alt></collectionnumber>
71 
                            <collectionnumber><_alt><2>$recordNumber</2></_alt></collectionnumber>
72 72 
                            <institution_id><party><organizationname>$institutionCode</organizationname></party></institution_id>
73 73 
                            <sourceaccessioncode>$id</sourceaccessioncode>
74 74 
                        </specimenreplicate>
inputs/ACAD/maps/VegBIEN.specimens.csv
9 9 
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",
10 10 
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
11 11 
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/2,
12 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/2,
12 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,
13 13 
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
14 14 
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
15 15 
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,
inputs/U/test/import.specimens.xml.ref
91 91 
                    <plantobservation>
92 92 
                        <specimenreplicate>
93 93 
                            <_if name="if indirect voucher"><else><catalognumber_dwc>$Barcode</catalognumber_dwc></else></_if>
94 
                            <collectionnumber><_alt><1><_alt><2>$Number</2></_alt></1></_alt></collectionnumber>
94 
                            <collectionnumber><_alt><2>$Number</2></_alt></collectionnumber>
95 95 
                            <sourceaccessioncode>$ID</sourceaccessioncode>
96 96 
                        </specimenreplicate>
97 97 
                    </plantobservation>
inputs/U/maps/VegBIEN.specimens.csv
7 7 
Collyy,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
8 8 
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
9 9 
Barcode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",
10 
Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/2,
10 
Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,
11 11 
ID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
12 12 
Detyy,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
13 13 
Detby,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,
inputs/ARIZ/test/import.specimens.xml.ref
200 200 
                            <collectioncode_dwc><_alt><1>$CollectionCode</1></_alt></collectioncode_dwc>
201 201 
                            <collectionnumber>
202 202 
                                <_alt>
203 
                                    <1>
204 
                                        <_alt>
205 
                                            <1>$CollectorNumber</1>
206 
                                            <2>$FieldNumber</2>
207 
                                        </_alt>
208 
                                    </1>
203 
                                    <1>$CollectorNumber</1>
204 
                                    <2>$FieldNumber</2>
209 205 
                                </_alt>
210 206 
                            </collectionnumber>
211 207 
                            <institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id>
inputs/ARIZ/maps/VegBIEN.specimens.csv
22 22 
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"
23 23 
CatalogNumberNumeric,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",
24 24 
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
25 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/1,
26 
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/2,Usage inconsistent with DwC definition
25 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1,
26 
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,Usage inconsistent with DwC definition
27 27 
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
28 28 
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
29 29 
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
inputs/SpeciesLink/test/import.specimens.xml.ref
213 213 
            </namedplace_id>
214 214 
        </locationdetermination>
215 215 
        <locationevent>
216 
            <authoreventcode>
217 
                <_alt>
218 
                    <0>$dwc_curatorial_FieldNumber</0>
219 
                    <1>$conceptual_darwin_2003_1_0_FieldNumber</1>
220 
                    <2>$dwc_terms_fieldNumber</2>
221 
                </_alt>
222 
            </authoreventcode>
216 223 
            <taxonoccurrence>
217 224 
                <aggregateoccurrence>
218 225 
                    <collectiondate>
......
297 304 
                                <_alt>
298 305 
                                    <1>
299 306 
                                        <_alt>
300 
                                            <1>
301 
                                                <_alt>
302 
                                                    <0>$dwc_curatorial_CollectorNumber</0>
303 
                                                    <1>$conceptual_darwin_2003_1_0_CollectorNumber</1>
304 
                                                </_alt>
305 
                                            </1>
306 
                                            <2>$dwc_terms_recordNumber</2>
307 
                                            <0>$dwc_curatorial_CollectorNumber</0>
308 
                                            <1>$conceptual_darwin_2003_1_0_CollectorNumber</1>
307 309 
                                        </_alt>
308 310 
                                    </1>
309 
                                    <3>
310 
                                        <_alt>
311 
                                            <0>$dwc_curatorial_FieldNumber</0>
312 
                                            <1>$conceptual_darwin_2003_1_0_FieldNumber</1>
313 
                                            <2>$dwc_terms_fieldNumber</2>
314 
                                        </_alt>
315 
                                    </3>
311 
                                    <2>$dwc_terms_recordNumber</2>
316 312 
                                </_alt>
317 313 
                            </collectionnumber>
318 314 
                            <institution_id>
inputs/SpeciesLink/maps/VegBIEN.specimens.csv
36 36 
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",
37 37 
ContinentOcean,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
38 38 
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",
39 
FieldNumber,/location/locationevent/authoreventcode,
40 
fieldNumber,/location/locationevent/authoreventcode,
39 41 
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
40 42 
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
41 43 
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
......
47 49 
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
48 50 
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
49 51 
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/2,
50 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/1,
51 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/2,
52 
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/3,
53 
fieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/3,
52 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1,
53 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,
54 54 
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
55 55 
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
56 56 
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
inputs/MO/test/import.specimens.xml.ref
176 176 
                        <specimenreplicate>
177 177 
                            <_if name="if indirect voucher"><else><catalognumber_dwc>$CatalogNumber</catalognumber_dwc></else></_if>
178 178 
                            <collectioncode_dwc><_alt><1>$CollectionCode</1></_alt></collectioncode_dwc>
179 
                            <collectionnumber><_alt><1><_alt><1>$CollectorNumber</1></_alt></1></_alt></collectionnumber>
179 
                            <collectionnumber><_alt><1>$CollectorNumber</1></_alt></collectionnumber>
180 180 
                            <institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id>
181 181 
                        </specimenreplicate>
182 182 
                    </plantobservation>
inputs/MO/maps/VegBIEN.specimens.csv
16 16 
convertednotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
17 17 
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",
18 18 
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
19 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/1,
19 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1,
20 20 
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
21 21 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,
22 22 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/middlename/_namePart/middle,
mappings/DwC2-VegBIEN.specimens.csv
15 15 
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",
16 16 
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",
17 17 
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",
18 
fieldNumber,/location/locationevent/authoreventcode,
18 19 
eventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value,
19 20 
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
20 21 
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"
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 
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/2,
24 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1,
25 
fieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/3,
25 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber,
26 26 
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
27 27 
occurrenceID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
28 28 
establishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value",
mappings/for_review/DwC2-VegBIEN.specimens.csv
15 15 
stateProvince,//locationdetermination/namedplace_id[rank=stateProvince]/placename,
16 16 
country,//locationdetermination/namedplace_id[rank=country]/placename,
17 17 
continent,//locationdetermination/namedplace_id[rank=continent]/placename,
18 
fieldNumber,//locationevent/authoreventcode,
18 19 
eventDate,//aggregateoccurrence/collectiondate/_*/date,
19 20 
fieldNotes,//aggregateoccurrence/notes,
20 21 
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"
......
22 23 
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
23 24 
collectionID,//specimenreplicate/collectioncode_dwc,
24 25 
recordNumber,//specimenreplicate/collectionnumber,
25 
fieldNumber,//specimenreplicate/collectionnumber,
26 26 
institutionCode,//party/organizationname,
27 27 
occurrenceID,//specimenreplicate/sourceaccessioncode,
28 28 
establishmentMeans,//taxonoccurrence/iscultivated,
mappings/DwC-VegBIEN.specimens.csv
51 51 
ContinentOcean,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
52 52 
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",
53 53 
continentOcean,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
54 
FieldNumber,/location/locationevent/authoreventcode,
55 
fieldNumber,/location/locationevent/authoreventcode,
54 56 
EventDate/_alt,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping
55 57 
eventDate/_alt,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping
56 58 
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
......
75 77 
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
76 78 
CollectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/2,
77 79 
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/2,
78 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/1,
79 
collectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/1,
80 
RecordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/2,
81 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/2,
82 
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/3,
83 
fieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/3,
80 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1,
81 
collectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1,
82 
RecordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,
83 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,
84 84 
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
85 85 
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
86 86 
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
mappings/DwC.cs-VegBIEN.specimens.csv
25 25 
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",
26 26 
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",
27 27 
continentOcean,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
28 
fieldNumber,/location/locationevent/authoreventcode,
28 29 
eventDate/_alt,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping
29 30 
dayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
30 31 
monthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
......
37 38 
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",
38 39 
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
39 40 
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/2,
40 
collectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/1,
41 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/2,
42 
fieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/3,
41 
collectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1,
42 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,
43 43 
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
44 44 
globalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
45 45 
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,

Also available in: Unified diff