Project

General

Profile

« Previous | Next » 

Revision 4006

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

View differences:

inputs/MT/test/import.specimens.xml.ref
41 41
                <aggregateoccurrence>
42 42
                    <count>$individualCount</count>
43 43
                    <plantobservation>
44
                        <sourceaccessioncode>$id</sourceaccessioncode>
44 45
                        <specimenreplicate>
45 46
                            <collectioncode_dwc>
46 47
                                <_alt>
......
69 70
                        <value>$establishmentMeans</value>
70 71
                    </_map>
71 72
                </isnative>
73
                <sourceaccessioncode><_alt><1>$id</1></_alt></sourceaccessioncode>
72 74
                <taxondetermination>
73 75
                    <isoriginal>true</isoriginal>
74 76
                    <role>identifier</role>
inputs/MT/maps/VegBIEN.specimens.csv
3 3
collectionCode,/location/authorlocationcode/_merge/2,
4 4
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",
5 5
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
6
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
6 7
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
7 8
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/2,
8 9
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
9 10
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
10 11
establishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value",
11 12
establishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value",
13
id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
12 14
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",
13 15
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",
14 16
locality,/location/locationnarrative/_merge/1,
inputs/NY/test/import.specimens.xml.ref
227 227
                            </userdefined_id>
228 228
                            <definedvalue>$Sex</definedvalue>
229 229
                        </definedvalue>
230
                        <sourceaccessioncode>$UniqueNYInternalRecordNumber</sourceaccessioncode>
230 231
                        <specimenreplicate>
231 232
                            <_if name="if indirect voucher"><else><catalognumber_dwc>$CatalogNumber</catalognumber_dwc></else></_if>
232 233
                            <collectioncode_dwc><_alt><1>$CollectionCode</1></_alt></collectioncode_dwc>
......
241 242
                        </specimenreplicate>
242 243
                    </plantobservation>
243 244
                </aggregateoccurrence>
245
                <sourceaccessioncode><_alt><1>$UniqueNYInternalRecordNumber</1></_alt></sourceaccessioncode>
244 246
                <taxondetermination>
245 247
                    <isoriginal>true</isoriginal>
246 248
                    <role>identifier</role>
inputs/NY/maps/VegBIEN.specimens.csv
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 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"
25
UniqueNYInternalRecordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
25 26
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",
26 27
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
27 28
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1,
28 29
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,Usage inconsistent with DwC definition
29 30
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
30 31
UniqueNYInternalRecordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
32
UniqueNYInternalRecordNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
31 33
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
32 34
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
33 35
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
                        <sourceaccessioncode>$accession</sourceaccessioncode>
98 99
                        <specimenreplicate>
99 100
                            <collectionnumber><_alt><1>$collectno</1></_alt></collectionnumber>
100 101
                            <institution_id><party><organizationname>$herbarium</organizationname></party></institution_id>
......
132 133
                        </value>
133 134
                    </_map>
134 135
                </isnative>
136
                <sourceaccessioncode><_alt><1>$accession</1></_alt></sourceaccessioncode>
135 137
                <taxondetermination>
136 138
                    <isoriginal>true</isoriginal>
137 139
                    <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
accession,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
16 17
collectno,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1,
17 18
herbarium,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
18 19
accession,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
19 20
cultivated,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value/_map:[Y=cultivated,N=wild,*=]/value",Ignore other values
20 21
cultivated,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value/_map:[Y=cultivated,N=wild,*=]/value",Ignore other values
22
accession,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
21 23
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",
22 24
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",
23 25
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
                        <sourceaccessioncode>$id</sourceaccessioncode>
80 81
                        <specimenreplicate>
81 82
                            <_if name="if indirect voucher"><else><catalognumber_dwc>$catalogNumber</catalognumber_dwc></else></_if>
82 83
                            <collectioncode_dwc>
......
91 92
                        </specimenreplicate>
92 93
                    </plantobservation>
93 94
                </aggregateoccurrence>
95
                <sourceaccessioncode><_alt><1>$id</1></_alt></sourceaccessioncode>
94 96
                <taxondetermination>
95 97
                    <isoriginal>true</isoriginal>
96 98
                    <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
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
13 14
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",
14 15
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
15 16
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/2,
16 17
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,
17 18
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
18 19
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
20
id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
19 21
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
20 22
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
21 23
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last,
inputs/REMIB/test/import.specimens.xml.ref
91 91
                        </_date>
92 92
                    </collectiondate>
93 93
                    <plantobservation>
94
                        <sourceaccessioncode>$accession_number</sourceaccessioncode>
94 95
                        <specimenreplicate>
95 96
                            <collectioncode_dwc><_alt><1>$acronym</1></_alt></collectioncode_dwc>
96 97
                            <sourceaccessioncode>$accession_number</sourceaccessioncode>
97 98
                        </specimenreplicate>
98 99
                    </plantobservation>
99 100
                </aggregateoccurrence>
101
                <sourceaccessioncode><_alt><1>$accession_number</1></_alt></sourceaccessioncode>
100 102
                <taxondetermination>
101 103
                    <isoriginal>true</isoriginal>
102 104
                    <role>identifier</role>
inputs/REMIB/maps/VegBIEN.specimens.csv
8 8
coll_day,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",
9 9
coll_month,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",
10 10
coll_year,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
11
accession_number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
11 12
acronym,/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
12 13
accession_number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
14
accession_number,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
13 15
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",
14 16
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",
15 17
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",
inputs/U/test/import.specimens.xml.ref
90 90
                    </collectiondate>
91 91
                    <notes>$Notes</notes>
92 92
                    <plantobservation>
93
                        <sourceaccessioncode>$ID</sourceaccessioncode>
93 94
                        <specimenreplicate>
94 95
                            <_if name="if indirect voucher"><else><catalognumber_dwc>$Barcode</catalognumber_dwc></else></_if>
95 96
                            <collectionnumber><_alt><2>$Number</2></_alt></collectionnumber>
......
97 98
                        </specimenreplicate>
98 99
                    </plantobservation>
99 100
                </aggregateoccurrence>
101
                <sourceaccessioncode><_alt><1>$ID</1></_alt></sourceaccessioncode>
100 102
                <taxondetermination>
101 103
                    <isoriginal>true</isoriginal>
102 104
                    <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
ID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
10 11
Barcode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",
11 12
Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,
12 13
ID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
14
ID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
13 15
Detby,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
14 16
Detby,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
15 17
Detby,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last,
inputs/ARIZ/test/import.specimens.xml.ref
219 219
                            </userdefined_id>
220 220
                            <definedvalue>$Sex</definedvalue>
221 221
                        </definedvalue>
222
                        <sourceaccessioncode>$GlobalUniqueIdentifier</sourceaccessioncode>
222 223
                        <specimenreplicate>
223 224
                            <_if name="if indirect voucher"><else><catalognumber_dwc>$CatalogNumberNumeric</catalognumber_dwc></else></_if>
224 225
                            <collectioncode_dwc><_alt><1>$CollectionCode</1></_alt></collectioncode_dwc>
......
233 234
                        </specimenreplicate>
234 235
                    </plantobservation>
235 236
                </aggregateoccurrence>
237
                <sourceaccessioncode><_alt><1>$GlobalUniqueIdentifier</1></_alt></sourceaccessioncode>
236 238
                <taxondetermination>
237 239
                    <isoriginal>true</isoriginal>
238 240
                    <role>identifier</role>
inputs/ARIZ/maps/VegBIEN.specimens.csv
25 25
IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
26 26
FieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
27 27
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
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
28 29
CatalogNumberNumeric,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",
29 30
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
30 31
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1,
31 32
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,Usage inconsistent with DwC definition
32 33
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
33 34
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
35
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
34 36
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
35 37
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
36 38
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last,
inputs/NCU-NCSC/test/import.specimens.xml.ref
81 81
                <aggregateoccurrence>
82 82
                    <collectiondate><_date><date><_dateRangeStart><value><_alt><3>$Collect Date</3></_alt></value></_dateRangeStart></date></_date></collectiondate>
83 83
                    <plantobservation>
84
                        <sourceaccessioncode>$Accession Number</sourceaccessioncode>
84 85
                        <specimenreplicate>
85 86
                            <_if name="if indirect voucher"><else><catalognumber_dwc>$Barcode</catalognumber_dwc></else></_if>
86 87
                            <collectioncode_dwc><_alt><1>$SeriesName</1></_alt></collectioncode_dwc>
......
116 117
                        </value>
117 118
                    </_map>
118 119
                </isnative>
120
                <sourceaccessioncode><_alt><1>$Accession Number</1></_alt></sourceaccessioncode>
119 121
                <taxondetermination>
120 122
                    <isoriginal>true</isoriginal>
121 123
                    <role>identifier</role>
inputs/NCU-NCSC/maps/VegBIEN.specimens.csv
9 9
State,"/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",
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
Collect Date,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/3,
12
Accession Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
12 13
Barcode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",
13 14
SeriesName,/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
14 15
Accession Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
15 16
Cultivated?,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value/_map:[Yes=cultivated,No=wild]/value",
16 17
Cultivated?,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value/_map:[Yes=cultivated,No=wild]/value",
18
Accession Number,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
17 19
Full Taxon Name,"/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",
18 20
Accession Number,/location/sourceaccessioncode/_alt/1,
19 21
Alt E/W,,** No input mapping for Alt E/W ** 
inputs/SpeciesLink/test/import.specimens.xml.ref
318 318
                                </_alt>
319 319
                            </definedvalue>
320 320
                        </definedvalue>
321
                        <sourceaccessioncode>$dwc_dwcore_GlobalUniqueIdentifier</sourceaccessioncode>
321 322
                        <specimenreplicate>
322 323
                            <_if name="if indirect voucher">
323 324
                                <else>
......
368 369
                        </specimenreplicate>
369 370
                    </plantobservation>
370 371
                </aggregateoccurrence>
372
                <sourceaccessioncode><_alt><1>$dwc_dwcore_GlobalUniqueIdentifier</1></_alt></sourceaccessioncode>
371 373
                <taxondetermination>
372 374
                    <isoriginal>true</isoriginal>
373 375
                    <role>identifier</role>
inputs/SpeciesLink/maps/VegBIEN.specimens.csv
52 52
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
53 53
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 54
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
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
55 56
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",
56 57
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",
57 58
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
......
62 63
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
63 64
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
64 65
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
66
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
65 67
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
66 68
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
67 69
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
inputs/QMOR/test/import.specimens.xml.ref
182 182
                            </userdefined_id>
183 183
                            <definedvalue>$sex</definedvalue>
184 184
                        </definedvalue>
185
                        <sourceaccessioncode>$id</sourceaccessioncode>
185 186
                        <specimenreplicate>
186 187
                            <_if name="if indirect voucher"><else><catalognumber_dwc>$catalogNumber</catalognumber_dwc></else></_if>
187 188
                            <collectioncode_dwc>
......
195 196
                        </specimenreplicate>
196 197
                    </plantobservation>
197 198
                </aggregateoccurrence>
199
                <sourceaccessioncode><_alt><1>$id</1></_alt></sourceaccessioncode>
198 200
                <taxondetermination>
199 201
                    <isoriginal>true</isoriginal>
200 202
                    <role>identifier</role>
inputs/QMOR/maps/VegBIEN.specimens.csv
22 22
eventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_dateRangeStart/value/_alt/2,
23 23
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
24 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"
25
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
25 26
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",
26 27
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
27 28
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/2,
28 29
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
29 30
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
31
id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
30 32
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
31 33
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
32 34
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last,
mappings/DwC2-VegBIEN.specimens.csv
25 25
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
26 26
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
27 27
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
occurrenceID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
28 29
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",
29 30
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
30 31
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/2,
......
33 34
occurrenceID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
34 35
establishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value",
35 36
establishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value",
37
occurrenceID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
36 38
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
37 39
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
38 40
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last,
mappings/for_review/DwC2-VegBIEN.specimens.csv
25 25
individualCount,//aggregateoccurrence/count,
26 26
fieldNotes,//aggregateoccurrence/notes,
27 27
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
occurrenceID,//plantobservation/sourceaccessioncode,
28 29
catalogNumber,"//plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",
29 30
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
30 31
collectionID,//specimenreplicate/collectioncode_dwc,
......
33 34
occurrenceID,//specimenreplicate/sourceaccessioncode,
34 35
establishmentMeans,//taxonoccurrence/iscultivated,
35 36
establishmentMeans,//taxonoccurrence/isnative,
37
occurrenceID,//taxonoccurrence/sourceaccessioncode,
36 38
identifiedBy,//taxonoccurrence/taxondetermination[role=identifier]/*_id/party/givenname,
37 39
identifiedBy,//taxonoccurrence/taxondetermination[role=identifier]/*_id/party/middlename,
38 40
identifiedBy,//taxonoccurrence/taxondetermination[role=identifier]/*_id/party/surname,
mappings/DwC-VegBIEN.specimens.csv
83 83
notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
84 84
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 85
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
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
87
Id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
88
OccurrenceID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
89
globalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
90
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
91
occurrenceID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
86 92
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",
87 93
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",
88 94
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
......
105 111
establishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value",
106 112
EstablishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value",
107 113
establishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value",
114
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
115
Id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
116
OccurrenceID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
117
globalUniqueIdentifier,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
118
id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
119
occurrenceID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
108 120
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
109 121
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
110 122
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
mappings/DwC.cs-VegBIEN.specimens.csv
41 41
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
42 42
notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
43 43
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
globalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
45
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
46
occurrenceID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
44 47
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/_if[@name=""if indirect voucher""]/else/catalognumber_dwc",
45 48
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
46 49
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/2,
......
52 55
occurrenceID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
53 56
establishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value",
54 57
establishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value",
58
globalUniqueIdentifier,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
59
id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
60
occurrenceID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
55 61
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first,
56 62
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle,
57 63
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last,

Also available in: Unified diff