Project

General

Profile

« Previous | Next » 

Revision 3907

Added by Aaron Marcuse-Kubitza over 12 years ago

mappings/DwC2-VegBIEN.specimens.csv: Mapped specimenreplicate via plantobservation for consistency with plots data. (This change is required for VegCSV table merging to work properly.) This is also a more accurate way of representing the data, because a specimen in fact comes from a plant, and it's natural to place the plant-related data (measurements, etc.) in the plantobservation table.

View differences:

inputs/MT/test/import.specimens.xml.ref
31 31 
            </namedplace_id>
32 32 
        </locationdetermination>
33 33 
        <locationevent>
34 
            <specimenreplicate>
35 
                <collectioncode_dwc>$collectionCode</collectioncode_dwc>
36 
                <collectionnumber><_alt><2>$collectionID</2></_alt></collectionnumber>
37 
                <growthform>
38 
                    <_map>
39 
                        <tree>*</tree>
40 
                        <shrub>*</shrub>
41 
                        <liana>*</liana>
42 
                        <vine>*</vine>
43 
                        <herb>*</herb>
44 
                        <hemiepiphyte>*</hemiepiphyte>
45 
                        <epiphyte>*</epiphyte>
46 
                        <grass>*</grass>
47 
                        <forb>*</forb>
48 
                        <moss>*</moss>
49 
                        <lichen>*</lichen>
50 
                        <fungus>*</fungus>
51 
                        <floating aquatic>*</floating aquatic>
52 
                        <submerged aquatic>*</submerged aquatic>
53 
                        <*></*>
54 
                        <value>$establishmentMeans</value>
55 
                    </_map>
56 
                </growthform>
57 
                <institution_id><party><organizationname>$institutionCode</organizationname></party></institution_id>
58 
                <iscultivated>
59 
                    <_map>
60 
                        <cultivated>t</cultivated>
61 
                        <wild>f</wild>
62 
                        <*></*>
63 
                        <value>$establishmentMeans</value>
64 
                    </_map>
65 
                </iscultivated>
66 
                <isnative>
67 
                    <_map>
68 
                        <native>t</native>
69 
                        <exotic>f</exotic>
70 
                        <*></*>
71 
                        <value>$establishmentMeans</value>
72 
                    </_map>
73 
                </isnative>
74 
                <sourceaccessioncode>$id</sourceaccessioncode>
34 
            <taxonoccurrence>
35 
                <aggregateoccurrence>
36 
                    <plantobservation>
37 
                        <specimenreplicate>
38 
                            <collectioncode_dwc>$collectionCode</collectioncode_dwc>
39 
                            <collectionnumber><_alt><2>$collectionID</2></_alt></collectionnumber>
40 
                            <growthform>
41 
                                <_map>
42 
                                    <tree>*</tree>
43 
                                    <shrub>*</shrub>
44 
                                    <liana>*</liana>
45 
                                    <vine>*</vine>
46 
                                    <herb>*</herb>
47 
                                    <hemiepiphyte>*</hemiepiphyte>
48 
                                    <epiphyte>*</epiphyte>
49 
                                    <grass>*</grass>
50 
                                    <forb>*</forb>
51 
                                    <moss>*</moss>
52 
                                    <lichen>*</lichen>
53 
                                    <fungus>*</fungus>
54 
                                    <floating aquatic>*</floating aquatic>
55 
                                    <submerged aquatic>*</submerged aquatic>
56 
                                    <*></*>
57 
                                    <value>$establishmentMeans</value>
58 
                                </_map>
59 
                            </growthform>
60 
                            <institution_id><party><organizationname>$institutionCode</organizationname></party></institution_id>
61 
                            <iscultivated>
62 
                                <_map>
63 
                                    <cultivated>t</cultivated>
64 
                                    <wild>f</wild>
65 
                                    <*></*>
66 
                                    <value>$establishmentMeans</value>
67 
                                </_map>
68 
                            </iscultivated>
69 
                            <isnative>
70 
                                <_map>
71 
                                    <native>t</native>
72 
                                    <exotic>f</exotic>
73 
                                    <*></*>
74 
                                    <value>$establishmentMeans</value>
75 
                                </_map>
76 
                            </isnative>
77 
                            <sourceaccessioncode>$id</sourceaccessioncode>
78 
                        </specimenreplicate>
79 
                    </plantobservation>
80 
                </aggregateoccurrence>
75 81 
                <taxondetermination>
76 82 
                    <isoriginal>true</isoriginal>
77 83 
                    <iscurrent>true</iscurrent>
......
119 125 
                        </plantconcept>
120 126 
                    </plantconcept_id>
121 127 
                </taxondetermination>
122 
            </specimenreplicate>
128 
            </taxonoccurrence>
123 129 
        </locationevent>
124 130 
        <locationnarrative><_merge><1>$locality</1></_merge></locationnarrative>
125 131 
        <sourceaccessioncode>
......
135 141 
        </sourceaccessioncode>
136 142 
    </location>
137 143 
</VegBIEN>
138 
Inserted 16 new rows into database
144 
Inserted 22 new rows into database
inputs/MT/maps/VegBIEN.specimens.csv
1 1 
MT[DwC],VegBIEN:,Comments,Source,Order within table
2 2 
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",,http://rs.tdwg.org/dwc/terms/#continent,59
3 
collectionCode,/location/locationevent/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,http://rs.tdwg.org/dwc/terms/#collectionCode,12
4 
collectionID,/location/locationevent/specimenreplicate/collectionnumber/_alt/2,,http://rs.tdwg.org/dwc/terms/#collectionID,9
5 
establishmentMeans,"/location/locationevent/specimenreplicate/growthform/_map:[./{tree,shrub,liana,vine,herb,hemiepiphyte,epiphyte,grass,forb,moss,lichen,fungus,""floating aquatic"",""submerged aquatic""}=*,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
6 
institutionCode,/location/locationevent/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
7 
establishmentMeans,"/location/locationevent/specimenreplicate/iscultivated/_map:[cultivated=t,wild=f,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
8 
establishmentMeans,"/location/locationevent/specimenreplicate/isnative/_map:[native=t,exotic=f,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
9 
id,/location/locationevent/specimenreplicate/sourceaccessioncode,,"ACAD#id, MT#id, QMOR#id, U#ID; http://rs.tdwg.org/dwc/terms/#occurrenceID",19
10 
genus,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#genus,147
11 
family,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#family,146
3 
collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/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,http://rs.tdwg.org/dwc/terms/#collectionCode,12
4 
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,,http://rs.tdwg.org/dwc/terms/#collectionID,9
5 
establishmentMeans,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/growthform/_map:[./{tree,shrub,liana,vine,herb,hemiepiphyte,epiphyte,grass,forb,moss,lichen,fungus,""floating aquatic"",""submerged aquatic""}=*,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
6 
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
7 
establishmentMeans,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/iscultivated/_map:[cultivated=t,wild=f,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
8 
establishmentMeans,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/isnative/_map:[native=t,exotic=f,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
9 
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,,"ACAD#id, MT#id, QMOR#id, U#ID; http://rs.tdwg.org/dwc/terms/#occurrenceID",19
10 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#genus,147
11 
family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#family,146
12 12 
locality,/location/locationnarrative/_merge/1,,http://rs.tdwg.org/dwc/terms/#locality,68
13 13 
id,/location/sourceaccessioncode/_alt/1,,"ACAD#id, MT#id, QMOR#id, U#ID; http://rs.tdwg.org/dwc/terms/#occurrenceID",19
14 14 
institutionCode,/location/sourceaccessioncode/_alt/2/_merge/1,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
inputs/XAL/test/import.specimens.xml.ref
207 207 
                    </date>
208 208 
                </_date>
209 209 
            </obsstartdate>
210 
            <specimenreplicate>
211 
                <catalognumber_dwc>$CatalogNumber</catalognumber_dwc>
212 
                <collectioncode_dwc>$CollectionCode</collectioncode_dwc>
213 
                <collectionnumber>
214 
                    <_alt>
215 
                        <1><_alt><1>$CollectorNumber</1></_alt></1>
216 
                        <3>$FieldNumber</3>
217 
                    </_alt>
218 
                </collectionnumber>
219 
                <definedvalue fkey="tablerecord_id">
220 
                    <userdefined_id>
221 
                        <userdefined>
222 
                            <tablename>specimenreplicate</tablename>
223 
                            <userdefinedname>sex</userdefinedname>
224 
                        </userdefined>
225 
                    </userdefined_id>
226 
                    <definedvalue>$Sex</definedvalue>
227 
                </definedvalue>
228 
                <description><_merge><1>$Notes</1></_merge></description>
229 
                <institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id>
210 
            <taxonoccurrence>
211 
                <aggregateoccurrence>
212 
                    <plantobservation>
213 
                        <specimenreplicate>
214 
                            <catalognumber_dwc>$CatalogNumber</catalognumber_dwc>
215 
                            <collectioncode_dwc>$CollectionCode</collectioncode_dwc>
216 
                            <collectionnumber>
217 
                                <_alt>
218 
                                    <1><_alt><1>$CollectorNumber</1></_alt></1>
219 
                                    <3>$FieldNumber</3>
220 
                                </_alt>
221 
                            </collectionnumber>
222 
                            <definedvalue fkey="tablerecord_id">
223 
                                <userdefined_id>
224 
                                    <userdefined>
225 
                                        <tablename>specimenreplicate</tablename>
226 
                                        <userdefinedname>sex</userdefinedname>
227 
                                    </userdefined>
228 
                                </userdefined_id>
229 
                                <definedvalue>$Sex</definedvalue>
230 
                            </definedvalue>
231 
                            <description><_merge><1>$Notes</1></_merge></description>
232 
                            <institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id>
233 
                            <verbatimcollectorname>$Collector</verbatimcollectorname>
234 
                        </specimenreplicate>
235 
                    </plantobservation>
236 
                </aggregateoccurrence>
230 237 
                <taxondetermination>
231 238 
                    <role>identifier</role>
232 239 
                    <determinationdate>
......
346 353 
                        </plantconcept>
347 354 
                    </plantconcept_id>
348 355 
                </taxondetermination>
349 
                <verbatimcollectorname>$Collector</verbatimcollectorname>
350 
            </specimenreplicate>
356 
            </taxonoccurrence>
351 357 
            <waterdepth>
352 358 
                <_avg>
353 359 
                    <max>
......
383 389 
        </sourceaccessioncode>
384 390 
    </location>
385 391 
</VegBIEN>
386 
Inserted 41 new rows into database
392 
Inserted 47 new rows into database
inputs/XAL/maps/VegBIEN.specimens.csv
17 17 
DayCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
18 18 
MonthCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/MonthCollected; http://rs.tdwg.org/dwc/terms/#eventDate,10; 44
19 19 
YearCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearCollected; http://rs.tdwg.org/dwc/terms/#eventDate,9; 44
20 
CatalogNumber,/location/locationevent/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
21 
CollectionCode,/location/locationevent/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,http://rs.tdwg.org/dwc/terms/#collectionCode,12
22 
CollectorNumber,/location/locationevent/specimenreplicate/collectionnumber/_alt/1/_alt/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/CollectorNumber; http://rs.tdwg.org/dwc/terms/#recordNumber,7; 22
23 
FieldNumber,/location/locationevent/specimenreplicate/collectionnumber/_alt/3,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53
24 
Sex,"/location/locationevent/specimenreplicate/definedvalue[*_id/userdefined[tablename=specimenreplicate,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",http://rs.tdwg.org/dwc/terms/#sex,26
25 
Notes,/location/locationevent/specimenreplicate/description/_merge/1,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Notes; http://rs.tdwg.org/dwc/terms/#fieldNotes,47; 54
26 
InstitutionCode,/location/locationevent/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
27 
DayIdentified,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,55; 120
28 
MonthIdentified,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/MonthIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,54; 120
29 
YearIdentified,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,53; 120
30 
IdentifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
31 
IdentifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/middlename/_namePart/middle,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
32 
IdentifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/surname/_namePart/last,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
33 
ScientificName,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#scientificName,134
34 
ScientificNameAuthor,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/ScientificNameAuthor; http://rs.tdwg.org/dwc/terms/#scientificNameAuthorship,50; 153
35 
Subspecies,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Subspecies; http://rs.tdwg.org/dwc/terms/#infraspecificEpithet,49; 150
36 
Species,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Species; http://rs.tdwg.org/dwc/terms/#specificEpithet,12; 149
37 
Genus,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#genus,147
38 
Family,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#family,146
39 
Order,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,http://rs.tdwg.org/dwc/terms/#order,145
40 
Class,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,http://rs.tdwg.org/dwc/terms/#class,144
41 
Phylum,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#phylum,143
42 
Kingdom,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#kingdom,142
43 
Collector,/location/locationevent/specimenreplicate/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23
20 
CatalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
21 
CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/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,http://rs.tdwg.org/dwc/terms/#collectionCode,12
22 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/CollectorNumber; http://rs.tdwg.org/dwc/terms/#recordNumber,7; 22
23 
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/3,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53
24 
Sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/definedvalue[*_id/userdefined[tablename=specimenreplicate,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",http://rs.tdwg.org/dwc/terms/#sex,26
25 
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/description/_merge/1,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Notes; http://rs.tdwg.org/dwc/terms/#fieldNotes,47; 54
26 
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
27 
Collector,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23
28 
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,55; 120
29 
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/MonthIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,54; 120
30 
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,53; 120
31 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
32 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/middlename/_namePart/middle,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
33 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/surname/_namePart/last,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
34 
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#scientificName,134
35 
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/ScientificNameAuthor; http://rs.tdwg.org/dwc/terms/#scientificNameAuthorship,50; 153
36 
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Subspecies; http://rs.tdwg.org/dwc/terms/#infraspecificEpithet,49; 150
37 
Species,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Species; http://rs.tdwg.org/dwc/terms/#specificEpithet,12; 149
38 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#genus,147
39 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#family,146
40 
Order,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,http://rs.tdwg.org/dwc/terms/#order,145
41 
Class,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,http://rs.tdwg.org/dwc/terms/#class,144
42 
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#phylum,143
43 
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#kingdom,142
44 44 
MaximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/MaximumDepth; http://rs.tdwg.org/dwc/terms/#maximumDepthInMeters,40; 75
45 45 
MinimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/MinimumDepth; http://rs.tdwg.org/dwc/terms/#minimumDepthInMeters,39; 74
46 46 
Locality,/location/locationnarrative/_merge/1,,http://rs.tdwg.org/dwc/terms/#locality,68
inputs/NY/test/import.specimens.xml.ref
223 223 
                    </date>
224 224 
                </_date>
225 225 
            </obsstartdate>
226 
            <specimenreplicate>
227 
                <catalognumber_dwc>$CatalogNumber</catalognumber_dwc>
228 
                <collectioncode_dwc>$CollectionCode</collectioncode_dwc>
229 
                <collectionnumber>
230 
                    <_alt>
231 
                        <1><_alt><1>$CollectorNumber</1></_alt></1>
232 
                        <3>$FieldNumber</3>
233 
                    </_alt>
234 
                </collectionnumber>
235 
                <definedvalue fkey="tablerecord_id">
236 
                    <userdefined_id>
237 
                        <userdefined>
238 
                            <tablename>specimenreplicate</tablename>
239 
                            <userdefinedname>sex</userdefinedname>
240 
                        </userdefined>
241 
                    </userdefined_id>
242 
                    <definedvalue>$Sex</definedvalue>
243 
                </definedvalue>
244 
                <description>
245 
                    <_merge>
246 
                        <1>
247 
                            <_merge>
248 
                                <1>$Notes</1>
249 
                                <2>
250 
                                    <_label>
251 
                                        <label>plant fungus</label>
252 
                                        <value>$PlantFungusDescription</value>
253 
                                    </_label>
254 
                                </2>
255 
                            </_merge>
256 
                        </1>
257 
                    </_merge>
258 
                </description>
259 
                <institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id>
260 
                <sourceaccessioncode>$UniqueNYInternalRecordNumber</sourceaccessioncode>
226 
            <taxonoccurrence>
227 
                <aggregateoccurrence>
228 
                    <plantobservation>
229 
                        <specimenreplicate>
230 
                            <catalognumber_dwc>$CatalogNumber</catalognumber_dwc>
231 
                            <collectioncode_dwc>$CollectionCode</collectioncode_dwc>
232 
                            <collectionnumber>
233 
                                <_alt>
234 
                                    <1><_alt><1>$CollectorNumber</1></_alt></1>
235 
                                    <3>$FieldNumber</3>
236 
                                </_alt>
237 
                            </collectionnumber>
238 
                            <definedvalue fkey="tablerecord_id">
239 
                                <userdefined_id>
240 
                                    <userdefined>
241 
                                        <tablename>specimenreplicate</tablename>
242 
                                        <userdefinedname>sex</userdefinedname>
243 
                                    </userdefined>
244 
                                </userdefined_id>
245 
                                <definedvalue>$Sex</definedvalue>
246 
                            </definedvalue>
247 
                            <description>
248 
                                <_merge>
249 
                                    <1>
250 
                                        <_merge>
251 
                                            <1>$Notes</1>
252 
                                            <2>
253 
                                                <_label>
254 
                                                    <label>plant fungus</label>
255 
                                                    <value>$PlantFungusDescription</value>
256 
                                                </_label>
257 
                                            </2>
258 
                                        </_merge>
259 
                                    </1>
260 
                                </_merge>
261 
                            </description>
262 
                            <institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id>
263 
                            <sourceaccessioncode>$UniqueNYInternalRecordNumber</sourceaccessioncode>
264 
                            <verbatimcollectorname>$Collector</verbatimcollectorname>
265 
                        </specimenreplicate>
266 
                    </plantobservation>
267 
                </aggregateoccurrence>
261 268 
                <taxondetermination>
262 269 
                    <role>identifier</role>
263 270 
                    <determinationdate>
......
377 384 
                        </plantconcept>
378 385 
                    </plantconcept_id>
379 386 
                </taxondetermination>
380 
                <verbatimcollectorname>$Collector</verbatimcollectorname>
381 
            </specimenreplicate>
387 
            </taxonoccurrence>
382 388 
            <waterdepth>
383 389 
                <_avg>
384 390 
                    <max>
......
441 447 
        </sourceaccessioncode>
442 448 
    </location>
443 449 
</VegBIEN>
444 
Inserted 33 new rows into database
450 
Inserted 39 new rows into database
inputs/QMOR/maps/VegBIEN.specimens.csv
16 16 
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",,http://rs.tdwg.org/dwc/terms/#continent,59
17 17 
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
18 18 
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
19 
catalogNumber,/location/locationevent/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
20 
collectionCode,/location/locationevent/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,http://rs.tdwg.org/dwc/terms/#collectionCode,12
21 
collectionID,/location/locationevent/specimenreplicate/collectionnumber/_alt/2,,http://rs.tdwg.org/dwc/terms/#collectionID,9
22 
sex,"/location/locationevent/specimenreplicate/definedvalue[*_id/userdefined[tablename=specimenreplicate,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",http://rs.tdwg.org/dwc/terms/#sex,26
23 
institutionCode,/location/locationevent/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
24 
id,/location/locationevent/specimenreplicate/sourceaccessioncode,,"ACAD#id, MT#id, QMOR#id, U#ID; http://rs.tdwg.org/dwc/terms/#occurrenceID",19
25 
dateIdentified,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#dateIdentified,120
26 
identifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
27 
identifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/middlename/_namePart/middle,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
28 
identifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/surname/_namePart/last,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
29 
scientificName,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#scientificName,134
30 
scientificNameAuthorship,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#scientificNameAuthorship,153
31 
infraspecificEpithet,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#infraspecificEpithet,150
32 
specificEpithet,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#specificEpithet,149
33 
genus,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#genus,147
34 
family,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#family,146
35 
order,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,http://rs.tdwg.org/dwc/terms/#order,145
36 
class,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,http://rs.tdwg.org/dwc/terms/#class,144
37 
phylum,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#phylum,143
38 
kingdom,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#kingdom,142
39 
recordedBy,/location/locationevent/specimenreplicate/verbatimcollectorname,,http://rs.tdwg.org/dwc/terms/#recordedBy,23
19 
catalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
20 
collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/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,http://rs.tdwg.org/dwc/terms/#collectionCode,12
21 
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,,http://rs.tdwg.org/dwc/terms/#collectionID,9
22 
sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/definedvalue[*_id/userdefined[tablename=specimenreplicate,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",http://rs.tdwg.org/dwc/terms/#sex,26
23 
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
24 
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,,"ACAD#id, MT#id, QMOR#id, U#ID; http://rs.tdwg.org/dwc/terms/#occurrenceID",19
25 
recordedBy,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname,,http://rs.tdwg.org/dwc/terms/#recordedBy,23
26 
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#dateIdentified,120
27 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
28 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/middlename/_namePart/middle,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
29 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/surname/_namePart/last,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
30 
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#scientificName,134
31 
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#scientificNameAuthorship,153
32 
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#infraspecificEpithet,150
33 
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#specificEpithet,149
34 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#genus,147
35 
family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#family,146
36 
order,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,http://rs.tdwg.org/dwc/terms/#order,145
37 
class,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,http://rs.tdwg.org/dwc/terms/#class,144
38 
phylum,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#phylum,143
39 
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#kingdom,142
40 40 
locality,/location/locationnarrative/_merge/1,,http://rs.tdwg.org/dwc/terms/#locality,68
41 41 
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",http://rs.tdwg.org/dwc/terms/#habitat,52
42 42 
id,/location/sourceaccessioncode/_alt/1,,"ACAD#id, MT#id, QMOR#id, U#ID; http://rs.tdwg.org/dwc/terms/#occurrenceID",19
mappings/for_review/DwC2-VegBIEN.specimens.csv
30 30 
establishmentMeans,//specimenreplicate/iscultivated,,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
31 31 
establishmentMeans,//specimenreplicate/isnative,,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
32 32 
occurrenceID,//specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19
33 
dateIdentified,//specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date,,http://rs.tdwg.org/dwc/terms/#dateIdentified,120
34 
identifiedBy,//specimenreplicate/taxondetermination[role=identifier]/*_id/party/givenname,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
35 
identifiedBy,//specimenreplicate/taxondetermination[role=identifier]/*_id/party/middlename,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
36 
identifiedBy,//specimenreplicate/taxondetermination[role=identifier]/*_id/party/surname,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
33 
recordedBy,//specimenreplicate/verbatimcollectorname,,http://rs.tdwg.org/dwc/terms/#recordedBy,23
34 
dateIdentified,//taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date,,http://rs.tdwg.org/dwc/terms/#dateIdentified,120
35 
identifiedBy,//taxonoccurrence/taxondetermination[role=identifier]/*_id/party/givenname,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
36 
identifiedBy,//taxonoccurrence/taxondetermination[role=identifier]/*_id/party/middlename,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
37 
identifiedBy,//taxonoccurrence/taxondetermination[role=identifier]/*_id/party/surname,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
37 38 
scientificName,//plantconcept/plantname_id[rank=binomial]/plantname,,http://rs.tdwg.org/dwc/terms/#scientificName,134
38 39 
scientificNameAuthorship,//plantconcept/plantname_id[rank=authority]/plantname,,http://rs.tdwg.org/dwc/terms/#scientificNameAuthorship,153
39 40 
infraspecificEpithet,//plantconcept/plantname_id[rank=subspecies]/plantname,,http://rs.tdwg.org/dwc/terms/#infraspecificEpithet,150
......
44 45 
class,//plantconcept/plantname_id[rank=class]/plantname,,http://rs.tdwg.org/dwc/terms/#class,144
45 46 
phylum,//plantconcept/plantname_id[rank=subkingdom]/plantname,,http://rs.tdwg.org/dwc/terms/#phylum,143
46 47 
kingdom,//plantconcept/plantname_id[rank=kingdom]/plantname,,http://rs.tdwg.org/dwc/terms/#kingdom,142
47 
recordedBy,//specimenreplicate/verbatimcollectorname,,http://rs.tdwg.org/dwc/terms/#recordedBy,23
48 48 
maximumDepthInMeters,//locationevent/waterdepth,,http://rs.tdwg.org/dwc/terms/#maximumDepthInMeters,75
49 49 
minimumDepthInMeters,//locationevent/waterdepth,,http://rs.tdwg.org/dwc/terms/#minimumDepthInMeters,74
50 50 
locality,//location/locationnarrative,,http://rs.tdwg.org/dwc/terms/#locality,68
mappings/DwC.cs-VegBIEN.specimens.csv
37 37 
yearCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearCollected; http://rs.tdwg.org/dwc/terms/#eventDate,9; 44
38 38 
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
39 39 
collectedDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/3,,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=bien2_staging&table=nybg_raw&target=tbl_structure.php#CollectedDate; http://rs.tdwg.org/dwc/terms/#eventDate,29; 44
40 
catalogNumber,/location/locationevent/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
41 
collectionCode,/location/locationevent/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,http://rs.tdwg.org/dwc/terms/#collectionCode,12
42 
collectorNumber,/location/locationevent/specimenreplicate/collectionnumber/_alt/1/_alt/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/CollectorNumber; http://rs.tdwg.org/dwc/terms/#recordNumber,7; 22
43 
recordNumber,/location/locationevent/specimenreplicate/collectionnumber/_alt/1/_alt/2,,http://rs.tdwg.org/dwc/terms/#recordNumber,22
44 
collectionID,/location/locationevent/specimenreplicate/collectionnumber/_alt/2,,http://rs.tdwg.org/dwc/terms/#collectionID,9
45 
fieldNumber,/location/locationevent/specimenreplicate/collectionnumber/_alt/3,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53
46 
sex,"/location/locationevent/specimenreplicate/definedvalue[*_id/userdefined[tablename=specimenreplicate,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",http://rs.tdwg.org/dwc/terms/#sex,26
47 
fieldNotes,/location/locationevent/specimenreplicate/description/_merge/1,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
48 
notes,/location/locationevent/specimenreplicate/description/_merge/1,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Notes; http://rs.tdwg.org/dwc/terms/#fieldNotes,47; 54
49 
remarks,/location/locationevent/specimenreplicate/description/_merge/2,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Remarks; http://rs.tdwg.org/dwc/terms/#taxonRemarks,65; 158
50 
taxonRemarks,/location/locationevent/specimenreplicate/description/_merge/2,,http://rs.tdwg.org/dwc/terms/#taxonRemarks,158
51 
establishmentMeans,"/location/locationevent/specimenreplicate/growthform/_map:[./{tree,shrub,liana,vine,herb,hemiepiphyte,epiphyte,grass,forb,moss,lichen,fungus,""floating aquatic"",""submerged aquatic""}=*,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
52 
institutionCode,/location/locationevent/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
53 
establishmentMeans,"/location/locationevent/specimenreplicate/iscultivated/_map:[cultivated=t,wild=f,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
54 
establishmentMeans,"/location/locationevent/specimenreplicate/isnative/_map:[native=t,exotic=f,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
55 
globalUniqueIdentifier,/location/locationevent/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/tdwg_dw_core.xsd#/GlobalUniqueIdentifier; http://rs.tdwg.org/dwc/terms/#occurrenceID,0; 19
56 
id,/location/locationevent/specimenreplicate/sourceaccessioncode,,"ACAD#id, MT#id, QMOR#id, U#ID; http://rs.tdwg.org/dwc/terms/#occurrenceID",19
57 
occurrenceID,/location/locationevent/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19
58 
dateIdentified/_alt,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom dateIdentified mappings that don't pass through the default dateIdentified mapping,http://rs.tdwg.org/dwc/terms/#dateIdentified,120
59 
dayIdentified,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,55; 120
60 
monthIdentified,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/MonthIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,54; 120
61 
yearIdentified,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,53; 120
62 
dateIdentified,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#dateIdentified,120
63 
identifiedDate,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/3,,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=bien2_staging&table=nybg_raw&target=tbl_structure.php#IdentifiedDate; http://rs.tdwg.org/dwc/terms/#dateIdentified,21; 120
64 
identifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
65 
identifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/middlename/_namePart/middle,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
66 
identifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/surname/_namePart/last,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
67 
scientificName,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#scientificName,134
68 
scientificNameAuthor,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/ScientificNameAuthor; http://rs.tdwg.org/dwc/terms/#scientificNameAuthorship,50; 153
69 
scientificNameAuthorship,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#scientificNameAuthorship,153
70 
infraspecificEpithet,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#infraspecificEpithet,150
71 
subspecies,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Subspecies; http://rs.tdwg.org/dwc/terms/#infraspecificEpithet,49; 150
72 
species,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Species; http://rs.tdwg.org/dwc/terms/#specificEpithet,12; 149
73 
specificEpithet,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#specificEpithet,149
74 
genus,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#genus,147
75 
family,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#family,146
76 
order,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,http://rs.tdwg.org/dwc/terms/#order,145
77 
class,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,http://rs.tdwg.org/dwc/terms/#class,144
78 
phylum,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#phylum,143
79 
kingdom,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#kingdom,142
80 
collector,/location/locationevent/specimenreplicate/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23
81 
recordedBy,/location/locationevent/specimenreplicate/verbatimcollectorname,,http://rs.tdwg.org/dwc/terms/#recordedBy,23
40 
catalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
41 
collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/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,http://rs.tdwg.org/dwc/terms/#collectionCode,12
42 
collectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/CollectorNumber; http://rs.tdwg.org/dwc/terms/#recordNumber,7; 22
43 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/2,,http://rs.tdwg.org/dwc/terms/#recordNumber,22
44 
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,,http://rs.tdwg.org/dwc/terms/#collectionID,9
45 
fieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/3,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53
46 
sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/definedvalue[*_id/userdefined[tablename=specimenreplicate,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",http://rs.tdwg.org/dwc/terms/#sex,26
47 
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/description/_merge/1,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
48 
notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/description/_merge/1,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Notes; http://rs.tdwg.org/dwc/terms/#fieldNotes,47; 54
49 
remarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/description/_merge/2,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Remarks; http://rs.tdwg.org/dwc/terms/#taxonRemarks,65; 158
50 
taxonRemarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/description/_merge/2,,http://rs.tdwg.org/dwc/terms/#taxonRemarks,158
51 
establishmentMeans,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/growthform/_map:[./{tree,shrub,liana,vine,herb,hemiepiphyte,epiphyte,grass,forb,moss,lichen,fungus,""floating aquatic"",""submerged aquatic""}=*,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
52 
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
53 
establishmentMeans,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/iscultivated/_map:[cultivated=t,wild=f,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
54 
establishmentMeans,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/isnative/_map:[native=t,exotic=f,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
55 
globalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/tdwg_dw_core.xsd#/GlobalUniqueIdentifier; http://rs.tdwg.org/dwc/terms/#occurrenceID,0; 19
56 
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,,"ACAD#id, MT#id, QMOR#id, U#ID; http://rs.tdwg.org/dwc/terms/#occurrenceID",19
57 
occurrenceID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19
58 
collector,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23
59 
recordedBy,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname,,http://rs.tdwg.org/dwc/terms/#recordedBy,23
60 
dateIdentified/_alt,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom dateIdentified mappings that don't pass through the default dateIdentified mapping,http://rs.tdwg.org/dwc/terms/#dateIdentified,120
61 
dayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,55; 120
62 
monthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/MonthIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,54; 120
63 
yearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,53; 120
64 
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#dateIdentified,120
65 
identifiedDate,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/3,,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=bien2_staging&table=nybg_raw&target=tbl_structure.php#IdentifiedDate; http://rs.tdwg.org/dwc/terms/#dateIdentified,21; 120
66 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
67 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/middlename/_namePart/middle,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
68 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/surname/_namePart/last,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
69 
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#scientificName,134
70 
scientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/ScientificNameAuthor; http://rs.tdwg.org/dwc/terms/#scientificNameAuthorship,50; 153
71 
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#scientificNameAuthorship,153
72 
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#infraspecificEpithet,150
73 
subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Subspecies; http://rs.tdwg.org/dwc/terms/#infraspecificEpithet,49; 150
74 
species,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Species; http://rs.tdwg.org/dwc/terms/#specificEpithet,12; 149
75 
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#specificEpithet,149
76 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#genus,147
77 
family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#family,146
78 
order,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,http://rs.tdwg.org/dwc/terms/#order,145
79 
class,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,http://rs.tdwg.org/dwc/terms/#class,144
80 
phylum,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#phylum,143
81 
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#kingdom,142
82 82 
maximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/MaximumDepth; http://rs.tdwg.org/dwc/terms/#maximumDepthInMeters,40; 75
83 83 
maximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/#maximumDepthInMeters,75
84 84 
minimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/MinimumDepth; http://rs.tdwg.org/dwc/terms/#minimumDepthInMeters,39; 74
inputs/NY/maps/VegBIEN.specimens.csv
18 18 
DayCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
19 19 
MonthCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/MonthCollected; http://rs.tdwg.org/dwc/terms/#eventDate,10; 44
20 20 
YearCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearCollected; http://rs.tdwg.org/dwc/terms/#eventDate,9; 44
21 
CatalogNumber,/location/locationevent/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
22 
CollectionCode,/location/locationevent/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,http://rs.tdwg.org/dwc/terms/#collectionCode,12
23 
CollectorNumber,/location/locationevent/specimenreplicate/collectionnumber/_alt/1/_alt/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/CollectorNumber; http://rs.tdwg.org/dwc/terms/#recordNumber,7; 22
24 
FieldNumber,/location/locationevent/specimenreplicate/collectionnumber/_alt/3,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53
25 
Sex,"/location/locationevent/specimenreplicate/definedvalue[*_id/userdefined[tablename=specimenreplicate,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",http://rs.tdwg.org/dwc/terms/#sex,26
26 
Notes,/location/locationevent/specimenreplicate/description/_merge/1/_merge/1,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Notes; http://rs.tdwg.org/dwc/terms/#fieldNotes,47; 54
27 
PlantFungusDescription,"/location/locationevent/specimenreplicate/description/_merge/1/_merge/2/_label[label=""plant fungus""]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Notes; http://rs.tdwg.org/dwc/terms/#fieldNotes,47; 54
28 
InstitutionCode,/location/locationevent/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
29 
UniqueNYInternalRecordNumber,/location/locationevent/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19
30 
DayIdentified,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,55; 120
31 
MonthIdentified,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/MonthIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,54; 120
32 
YearIdentified,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,53; 120
33 
IdentifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
34 
IdentifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/middlename/_namePart/middle,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
35 
IdentifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/surname/_namePart/last,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
36 
ScientificName,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#scientificName,134
37 
ScientificNameAuthor,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/ScientificNameAuthor; http://rs.tdwg.org/dwc/terms/#scientificNameAuthorship,50; 153
38 
Subspecies,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Subspecies; http://rs.tdwg.org/dwc/terms/#infraspecificEpithet,49; 150
39 
Species,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Species; http://rs.tdwg.org/dwc/terms/#specificEpithet,12; 149
40 
Genus,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#genus,147
41 
Family,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#family,146
42 
Order,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,http://rs.tdwg.org/dwc/terms/#order,145
43 
Class,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,http://rs.tdwg.org/dwc/terms/#class,144
44 
Phylum,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#phylum,143
45 
Kingdom,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#kingdom,142
46 
Collector,/location/locationevent/specimenreplicate/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23
21 
CatalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
22 
CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/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,http://rs.tdwg.org/dwc/terms/#collectionCode,12
23 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/CollectorNumber; http://rs.tdwg.org/dwc/terms/#recordNumber,7; 22
24 
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/3,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53
25 
Sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/definedvalue[*_id/userdefined[tablename=specimenreplicate,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",http://rs.tdwg.org/dwc/terms/#sex,26
26 
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/description/_merge/1/_merge/1,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Notes; http://rs.tdwg.org/dwc/terms/#fieldNotes,47; 54
27 
PlantFungusDescription,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/description/_merge/1/_merge/2/_label[label=""plant fungus""]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Notes; http://rs.tdwg.org/dwc/terms/#fieldNotes,47; 54
28 
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
29 
UniqueNYInternalRecordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19
30 
Collector,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23
31 
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,55; 120
32 
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/MonthIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,54; 120
33 
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,53; 120
34 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
35 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/middlename/_namePart/middle,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
36 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/surname/_namePart/last,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
37 
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#scientificName,134
38 
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/ScientificNameAuthor; http://rs.tdwg.org/dwc/terms/#scientificNameAuthorship,50; 153
39 
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Subspecies; http://rs.tdwg.org/dwc/terms/#infraspecificEpithet,49; 150
40 
Species,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Species; http://rs.tdwg.org/dwc/terms/#specificEpithet,12; 149
41 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#genus,147
42 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#family,146
43 
Order,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,http://rs.tdwg.org/dwc/terms/#order,145
44 
Class,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,http://rs.tdwg.org/dwc/terms/#class,144
45 
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#phylum,143
46 
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#kingdom,142
47 47 
MaximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/MaximumDepth; http://rs.tdwg.org/dwc/terms/#maximumDepthInMeters,40; 75
48 48 
MinimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/MinimumDepth; http://rs.tdwg.org/dwc/terms/#minimumDepthInMeters,39; 74
49 49 
Locality,/location/locationnarrative/_merge/1/_merge/1,,http://rs.tdwg.org/dwc/terms/#locality,68
inputs/UNCC/test/import.specimens.xml.ref
102 102 
                    </date>
103 103 
                </_date>
104 104 
            </obsstartdate>
105 
            <specimenreplicate>
106 
                <collectioncode_dwc>$herbarium</collectioncode_dwc>
107 
                <collectionnumber><_alt><1><_alt><1>$collectno</1></_alt></1></_alt></collectionnumber>
108 
                <description>
109 
                    <_merge>
110 
                        <1>
111 
                            <_merge>
112 
                                <1>$comment1</1>
113 
                                <2>$comment2</2>
114 
                                <3>$comment3</3>
115 
                                <4>$comment4</4>
116 
                                <5>
117 
                                    <_label>
118 
                                        <label>campus</label>
119 
                                        <value>$campus</value>
120 
                                    </_label>
121 
                                </5>
122 
                                <6>
123 
                                    <_label>
124 
                                        <label>loaned to</label>
125 
                                        <value>$loanto</value>
126 
                                    </_label>
127 
                                </6>
128 
                                <7>
129 
                                    <_label>
130 
                                        <label>in or out</label>
131 
                                        <value>$inorout</value>
132 
                                    </_label>
133 
                                </7>
134 
                            </_merge>
135 
                        </1>
136 
                    </_merge>
137 
                </description>
138 
                <growthform>
139 
                    <_map>
140 
                        <tree>*</tree>
141 
                        <shrub>*</shrub>
142 
                        <liana>*</liana>
143 
                        <vine>*</vine>
144 
                        <herb>*</herb>
145 
                        <hemiepiphyte>*</hemiepiphyte>
146 
                        <epiphyte>*</epiphyte>
147 
                        <grass>*</grass>
148 
                        <forb>*</forb>
149 
                        <moss>*</moss>
150 
                        <lichen>*</lichen>
151 
                        <fungus>*</fungus>
152 
                        <floating aquatic>*</floating aquatic>
153 
                        <submerged aquatic>*</submerged aquatic>
154 
                        <*></*>
155 
                        <value>
156 
                            <_map>
157 
                                <Y>cultivated</Y>
158 
                                <N>wild</N>
159 
                                <*></*>
160 
                                <value>$cultivated</value>
161 
                            </_map>
162 
                        </value>
163 
                    </_map>
164 
                </growthform>
165 
                <iscultivated>
166 
                    <_map>
167 
                        <cultivated>t</cultivated>
168 
                        <wild>f</wild>
169 
                        <*></*>
170 
                        <value>
171 
                            <_map>
172 
                                <Y>cultivated</Y>
173 
                                <N>wild</N>
174 
                                <*></*>
175 
                                <value>$cultivated</value>
176 
                            </_map>
177 
                        </value>
178 
                    </_map>
179 
                </iscultivated>
180 
                <isnative>
181 
                    <_map>
182 
                        <native>t</native>
183 
                        <exotic>f</exotic>
184 
                        <*></*>
185 
                        <value>
186 
                            <_map>
187 
                                <Y>cultivated</Y>
188 
                                <N>wild</N>
189 
                                <*></*>
190 
                                <value>$cultivated</value>
191 
                            </_map>
192 
                        </value>
193 
                    </_map>
194 
                </isnative>
195 
                <sourceaccessioncode>$accession</sourceaccessioncode>
105 
            <taxonoccurrence>
106 
                <aggregateoccurrence>
107 
                    <plantobservation>
108 
                        <specimenreplicate>
109 
                            <collectioncode_dwc>$herbarium</collectioncode_dwc>
110 
                            <collectionnumber><_alt><1><_alt><1>$collectno</1></_alt></1></_alt></collectionnumber>
111 
                            <description>
112 
                                <_merge>
113 
                                    <1>
114 
                                        <_merge>
115 
                                            <1>$comment1</1>
116 
                                            <2>$comment2</2>
117 
                                            <3>$comment3</3>
118 
                                            <4>$comment4</4>
119 
                                            <5>
120 
                                                <_label>
121 
                                                    <label>campus</label>
122 
                                                    <value>$campus</value>
123 
                                                </_label>
124 
                                            </5>
125 
                                            <6>
126 
                                                <_label>
127 
                                                    <label>loaned to</label>
128 
                                                    <value>$loanto</value>
129 
                                                </_label>
130 
                                            </6>
131 
                                            <7>
132 
                                                <_label>
133 
                                                    <label>in or out</label>
134 
                                                    <value>$inorout</value>
135 
                                                </_label>
136 
                                            </7>
137 
                                        </_merge>
138 
                                    </1>
139 
                                </_merge>
140 
                            </description>
141 
                            <growthform>
142 
                                <_map>
143 
                                    <tree>*</tree>
144 
                                    <shrub>*</shrub>
145 
                                    <liana>*</liana>
146 
                                    <vine>*</vine>
147 
                                    <herb>*</herb>
148 
                                    <hemiepiphyte>*</hemiepiphyte>
149 
                                    <epiphyte>*</epiphyte>
150 
                                    <grass>*</grass>
151 
                                    <forb>*</forb>
152 
                                    <moss>*</moss>
153 
                                    <lichen>*</lichen>
154 
                                    <fungus>*</fungus>
155 
                                    <floating aquatic>*</floating aquatic>
156 
                                    <submerged aquatic>*</submerged aquatic>
157 
                                    <*></*>
158 
                                    <value>
159 
                                        <_map>
160 
                                            <Y>cultivated</Y>
161 
                                            <N>wild</N>
162 
                                            <*></*>
163 
                                            <value>$cultivated</value>
164 
                                        </_map>
165 
                                    </value>
166 
                                </_map>
167 
                            </growthform>
168 
                            <iscultivated>
169 
                                <_map>
170 
                                    <cultivated>t</cultivated>
171 
                                    <wild>f</wild>
172 
                                    <*></*>
173 
                                    <value>
174 
                                        <_map>
175 
                                            <Y>cultivated</Y>
176 
                                            <N>wild</N>
177 
                                            <*></*>
178 
                                            <value>$cultivated</value>
179 
                                        </_map>
180 
                                    </value>
181 
                                </_map>
182 
                            </iscultivated>
183 
                            <isnative>
184 
                                <_map>
185 
                                    <native>t</native>
186 
                                    <exotic>f</exotic>
187 
                                    <*></*>
188 
                                    <value>
189 
                                        <_map>
190 
                                            <Y>cultivated</Y>
191 
                                            <N>wild</N>
192 
                                            <*></*>
193 
                                            <value>$cultivated</value>
194 
                                        </_map>
195 
                                    </value>
196 
                                </_map>
197 
                            </isnative>
198 
                            <sourceaccessioncode>$accession</sourceaccessioncode>
199 
                            <verbatimcollectorname>
200 
                                <_merge>
201 
                                    <1>$collector</1>
202 
                                    <2>$collector1</2>
203 
                                    <3>$collector2</3>
204 
                                    <4>$collector3</4>
205 
                                </_merge>
206 
                            </verbatimcollectorname>
207 
                        </specimenreplicate>
208 
                    </plantobservation>
209 
                </aggregateoccurrence>
196 210 
                <taxondetermination>
197 211 
                    <isoriginal>true</isoriginal>
198 212 
                    <iscurrent>true</iscurrent>
......
244 258 
                        </plantconcept>
245 259 
                    </plantconcept_id>
246 260 
                </taxondetermination>
247 
                <verbatimcollectorname>
248 
                    <_merge>
249 
                        <1>$collector</1>
250 
                        <2>$collector1</2>
251 
                        <3>$collector2</3>
252 
                        <4>$collector3</4>
253 
                    </_merge>
254 
                </verbatimcollectorname>
255 
            </specimenreplicate>
261 
            </taxonoccurrence>
256 262 
        </locationevent>
257 263 
        <locationnarrative>
258 264 
            <_merge>
......
273 279 
        </sourceaccessioncode>
274 280 
    </location>
275 281 
</VegBIEN>
276 
Inserted 15 new rows into database
282 
Inserted 21 new rows into database
inputs/UNCC/maps/VegBIEN.specimens.csv
8 8 
collday,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
9 9 
collmonth,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/MonthCollected; http://rs.tdwg.org/dwc/terms/#eventDate,10; 44
10 10 
collyear,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearCollected; http://rs.tdwg.org/dwc/terms/#eventDate,9; 44
11 
herbarium,/location/locationevent/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,http://rs.tdwg.org/dwc/terms/#collectionCode,12
12 
collectno,/location/locationevent/specimenreplicate/collectionnumber/_alt/1/_alt/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/CollectorNumber; http://rs.tdwg.org/dwc/terms/#recordNumber,7; 22
13 
comment1,/location/locationevent/specimenreplicate/description/_merge/1/_merge/1,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
14 
comment2,/location/locationevent/specimenreplicate/description/_merge/1/_merge/2,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
15 
comment3,/location/locationevent/specimenreplicate/description/_merge/1/_merge/3,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
16 
comment4,/location/locationevent/specimenreplicate/description/_merge/1/_merge/4,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
17 
campus,"/location/locationevent/specimenreplicate/description/_merge/1/_merge/5/_label[label=""campus""]/value",,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
18 
loanto,"/location/locationevent/specimenreplicate/description/_merge/1/_merge/6/_label[label=""loaned to""]/value",,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
19 
inorout,"/location/locationevent/specimenreplicate/description/_merge/1/_merge/7/_label[label=""in or out""]/value",,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
20 
cultivated,"/location/locationevent/specimenreplicate/growthform/_map:[./{tree,shrub,liana,vine,herb,hemiepiphyte,epiphyte,grass,forb,moss,lichen,fungus,""floating aquatic"",""submerged aquatic""}=*,*=]/value/_map:[Y=cultivated,N=wild,*=]/value",Ignore other values,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
21 
cultivated,"/location/locationevent/specimenreplicate/iscultivated/_map:[cultivated=t,wild=f,*=]/value/_map:[Y=cultivated,N=wild,*=]/value",Ignore other values,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
22 
cultivated,"/location/locationevent/specimenreplicate/isnative/_map:[native=t,exotic=f,*=]/value/_map:[Y=cultivated,N=wild,*=]/value",Ignore other values,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
23 
accession,/location/locationevent/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19
24 
SciName,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#scientificName,134
25 
authors,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#scientificNameAuthorship,153
26 
infraname,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#infraspecificEpithet,150
27 
species,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Species; http://rs.tdwg.org/dwc/terms/#specificEpithet,12; 149
28 
genus,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#genus,147
29 
family,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#family,146
30 
collector,/location/locationevent/specimenreplicate/verbatimcollectorname/_merge/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23
31 
collector1,/location/locationevent/specimenreplicate/verbatimcollectorname/_merge/2,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23
32 
collector2,/location/locationevent/specimenreplicate/verbatimcollectorname/_merge/3,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23
33 
collector3,/location/locationevent/specimenreplicate/verbatimcollectorname/_merge/4,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23
11 
herbarium,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/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,http://rs.tdwg.org/dwc/terms/#collectionCode,12
12 
collectno,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/CollectorNumber; http://rs.tdwg.org/dwc/terms/#recordNumber,7; 22
13 
comment1,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/description/_merge/1/_merge/1,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
14 
comment2,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/description/_merge/1/_merge/2,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
15 
comment3,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/description/_merge/1/_merge/3,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
16 
comment4,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/description/_merge/1/_merge/4,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
17 
campus,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/description/_merge/1/_merge/5/_label[label=""campus""]/value",,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
18 
loanto,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/description/_merge/1/_merge/6/_label[label=""loaned to""]/value",,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
19 
inorout,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/description/_merge/1/_merge/7/_label[label=""in or out""]/value",,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
20 
cultivated,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/growthform/_map:[./{tree,shrub,liana,vine,herb,hemiepiphyte,epiphyte,grass,forb,moss,lichen,fungus,""floating aquatic"",""submerged aquatic""}=*,*=]/value/_map:[Y=cultivated,N=wild,*=]/value",Ignore other values,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
21 
cultivated,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/iscultivated/_map:[cultivated=t,wild=f,*=]/value/_map:[Y=cultivated,N=wild,*=]/value",Ignore other values,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
22 
cultivated,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/isnative/_map:[native=t,exotic=f,*=]/value/_map:[Y=cultivated,N=wild,*=]/value",Ignore other values,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
23 
accession,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19
24 
collector,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname/_merge/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23
25 
collector1,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname/_merge/2,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23
26 
collector2,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname/_merge/3,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23
27 
collector3,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname/_merge/4,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23
28 
SciName,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#scientificName,134
29 
authors,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#scientificNameAuthorship,153
30 
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#infraspecificEpithet,150
31 
species,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Species; http://rs.tdwg.org/dwc/terms/#specificEpithet,12; 149
32 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#genus,147
33 
family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#family,146
34 34 
locality,/location/locationnarrative/_merge/1,,http://rs.tdwg.org/dwc/terms/#locality,68
35 35 
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",http://rs.tdwg.org/dwc/terms/#habitat,52
36 36 
accession,/location/sourceaccessioncode/_alt/1,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19
inputs/ACAD/test/import.specimens.xml.ref
58 58 
        <locationevent>
59 59 
            <obsenddate><_date><date><_dateRangeEnd><value><_alt><2>$eventDate</2></_alt></value></_dateRangeEnd></date></_date></obsenddate>
60 60 
            <obsstartdate><_date><date><_dateRangeStart><value><_alt><2>$eventDate</2></_alt></value></_dateRangeStart></date></_date></obsstartdate>
61 
            <specimenreplicate>
62 
                <catalognumber_dwc>$catalogNumber</catalognumber_dwc>
63 
                <collectioncode_dwc>$collectionCode</collectioncode_dwc>
64 
                <collectionnumber>
65 
                    <_alt>
66 
                        <1><_alt><2>$recordNumber</2></_alt></1>
67 
                        <2>$collectionID</2>
68 
                    </_alt>
69 
                </collectionnumber>
70 
                <institution_id><party><organizationname>$institutionCode</organizationname></party></institution_id>
71 
                <sourceaccessioncode>$id</sourceaccessioncode>
61 
            <taxonoccurrence>
62 
                <aggregateoccurrence>
63 
                    <plantobservation>
64 
                        <specimenreplicate>
65 
                            <catalognumber_dwc>$catalogNumber</catalognumber_dwc>
66 
                            <collectioncode_dwc>$collectionCode</collectioncode_dwc>
67 
                            <collectionnumber>
68 
                                <_alt>
69 
                                    <1><_alt><2>$recordNumber</2></_alt></1>
70 
                                    <2>$collectionID</2>
71 
                                </_alt>
72 
                            </collectionnumber>
73 
                            <institution_id><party><organizationname>$institutionCode</organizationname></party></institution_id>
74 
                            <sourceaccessioncode>$id</sourceaccessioncode>
75 
                            <verbatimcollectorname>$recordedBy</verbatimcollectorname>
76 
                        </specimenreplicate>
77 
                    </plantobservation>
78 
                </aggregateoccurrence>
72 79 
                <taxondetermination>
73 80 
                    <role>identifier</role>
74 81 
                    <determinationdate><_date><date><_dateRangeStart><value><_alt><2>$dateIdentified</2></_alt></value></_dateRangeStart></date></_date></determinationdate>
......
152 159 
                        </plantconcept>
153 160 
                    </plantconcept_id>
154 161 
                </taxondetermination>
155 
                <verbatimcollectorname>$recordedBy</verbatimcollectorname>
156 
            </specimenreplicate>
162 
            </taxonoccurrence>
157 163 
        </locationevent>
158 164 
        <locationnarrative>
159 165 
            <_merge>
......
180 186 
        </sourceaccessioncode>
181 187 
    </location>
182 188 
</VegBIEN>
183 
Inserted 32 new rows into database
189 
Inserted 38 new rows into database
inputs/ACAD/maps/VegBIEN.specimens.csv
7 7 
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",,http://rs.tdwg.org/dwc/terms/#continent,59
8 8 
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
9 9 
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
10 
catalogNumber,/location/locationevent/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
11 
collectionCode,/location/locationevent/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,http://rs.tdwg.org/dwc/terms/#collectionCode,12
12 
recordNumber,/location/locationevent/specimenreplicate/collectionnumber/_alt/1/_alt/2,,http://rs.tdwg.org/dwc/terms/#recordNumber,22
13 
collectionID,/location/locationevent/specimenreplicate/collectionnumber/_alt/2,,http://rs.tdwg.org/dwc/terms/#collectionID,9
14 
institutionCode,/location/locationevent/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
15 
id,/location/locationevent/specimenreplicate/sourceaccessioncode,,"ACAD#id, MT#id, QMOR#id, U#ID; http://rs.tdwg.org/dwc/terms/#occurrenceID",19
16 
dateIdentified,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#dateIdentified,120
17 
identifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
18 
identifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/middlename/_namePart/middle,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
19 
identifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/surname/_namePart/last,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
20 
scientificName,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#scientificName,134
21 
scientificNameAuthorship,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#scientificNameAuthorship,153
22 
infraspecificEpithet,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#infraspecificEpithet,150
23 
specificEpithet,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#specificEpithet,149
24 
genus,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#genus,147
25 
family,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#family,146
26 
order,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,http://rs.tdwg.org/dwc/terms/#order,145
27 
class,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,http://rs.tdwg.org/dwc/terms/#class,144
28 
phylum,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#phylum,143
29 
kingdom,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#kingdom,142
30 
recordedBy,/location/locationevent/specimenreplicate/verbatimcollectorname,,http://rs.tdwg.org/dwc/terms/#recordedBy,23
10 
catalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
11 
collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/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,http://rs.tdwg.org/dwc/terms/#collectionCode,12
12 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/2,,http://rs.tdwg.org/dwc/terms/#recordNumber,22
13 
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,,http://rs.tdwg.org/dwc/terms/#collectionID,9
14 
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
15 
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,,"ACAD#id, MT#id, QMOR#id, U#ID; http://rs.tdwg.org/dwc/terms/#occurrenceID",19
16 
recordedBy,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname,,http://rs.tdwg.org/dwc/terms/#recordedBy,23
17 
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#dateIdentified,120
18 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
19 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/middlename/_namePart/middle,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
20 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/surname/_namePart/last,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
21 
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#scientificName,134
22 
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#scientificNameAuthorship,153
23 
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#infraspecificEpithet,150
24 
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#specificEpithet,149
25 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#genus,147
26 
family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#family,146
27 
order,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,http://rs.tdwg.org/dwc/terms/#order,145
28 
class,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,http://rs.tdwg.org/dwc/terms/#class,144
29 
phylum,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#phylum,143
30 
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#kingdom,142
31 31 
locality,/location/locationnarrative/_merge/1,,http://rs.tdwg.org/dwc/terms/#locality,68
32 32 
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",http://rs.tdwg.org/dwc/terms/#habitat,52
33 33 
id,/location/sourceaccessioncode/_alt/1,,"ACAD#id, MT#id, QMOR#id, U#ID; http://rs.tdwg.org/dwc/terms/#occurrenceID",19
inputs/REMIB/test/import.specimens.xml.ref
124 124 
                    </date>
125 125 
                </_date>
126 126 
            </obsstartdate>
127 
            <specimenreplicate>
128 
                <collectioncode_dwc>$acronym</collectioncode_dwc>
129 
                <sourceaccessioncode>$accession_number</sourceaccessioncode>
127 
            <taxonoccurrence>
128 
                <aggregateoccurrence>
129 
                    <plantobservation>
130 
                        <specimenreplicate>
131 
                            <collectioncode_dwc>$acronym</collectioncode_dwc>
132 
                            <sourceaccessioncode>$accession_number</sourceaccessioncode>
133 
                            <verbatimcollectorname>$collector</verbatimcollectorname>
134 
                        </specimenreplicate>
135 
                    </plantobservation>
136 
                </aggregateoccurrence>
130 137 
                <taxondetermination>
131 138 
                    <isoriginal>true</isoriginal>
132 139 
                    <iscurrent>true</iscurrent>
......
175 182 
                        </plantconcept>
176 183 
                    </plantconcept_id>
177 184 
                </taxondetermination>
178 
                <verbatimcollectorname>$collector</verbatimcollectorname>
179 
            </specimenreplicate>
185 
            </taxonoccurrence>
180 186 
        </locationevent>
181 187 
        <locationnarrative>
182 188 
            <_merge>
......
197 203 
        </sourceaccessioncode>
198 204 
    </location>
199 205 
</VegBIEN>
200 
Inserted 20 new rows into database
206 
Inserted 26 new rows into database
inputs/REMIB/maps/VegBIEN.specimens.csv
10 10 
coll_day,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
11 11 
coll_month,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/MonthCollected; http://rs.tdwg.org/dwc/terms/#eventDate,10; 44
12 12 
coll_year,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearCollected; http://rs.tdwg.org/dwc/terms/#eventDate,9; 44
13 
acronym,/location/locationevent/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,http://rs.tdwg.org/dwc/terms/#collectionCode,12
14 
accession_number,/location/locationevent/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19
15 
specificEpithet,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#specificEpithet,149
16 
genus,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#genus,147
17 
family,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#family,146
18 
collector,/location/locationevent/specimenreplicate/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23
13 
acronym,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/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,http://rs.tdwg.org/dwc/terms/#collectionCode,12
14 
accession_number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19
15 
collector,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23
16 
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#specificEpithet,149
17 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#genus,147
18 
family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#family,146
19 19 
locality,/location/locationnarrative/_merge/1,,http://rs.tdwg.org/dwc/terms/#locality,68
20 20 
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",http://rs.tdwg.org/dwc/terms/#habitat,52
21 21 
accession_number,/location/sourceaccessioncode/_alt/1,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19
inputs/U/test/import.specimens.xml.ref
122 122 
                    </date>
123 123 
                </_date>
124 124 
            </obsstartdate>
125 
            <specimenreplicate>
126 
                <catalognumber_dwc>$Barcode</catalognumber_dwc>
127 
                <collectionnumber><_alt><1><_alt><2>$Number</2></_alt></1></_alt></collectionnumber>
128 
                <description><_merge><1>$Notes</1></_merge></description>
129 
                <sourceaccessioncode>$ID</sourceaccessioncode>
125 
            <taxonoccurrence>
126 
                <aggregateoccurrence>
127 
                    <plantobservation>
128 
                        <specimenreplicate>
129 
                            <catalognumber_dwc>$Barcode</catalognumber_dwc>
130 
                            <collectionnumber><_alt><1><_alt><2>$Number</2></_alt></1></_alt></collectionnumber>
131 
                            <description><_merge><1>$Notes</1></_merge></description>
132 
                            <sourceaccessioncode>$ID</sourceaccessioncode>
133 
                            <verbatimcollectorname>
134 
                                <_merge>
135 
                                    <1>$Collector</1>
136 
                                    <2>$Addcoll</2>
137 
                                </_merge>
138 
                            </verbatimcollectorname>
139 
                        </specimenreplicate>
140 
                    </plantobservation>
141 
                </aggregateoccurrence>
130 142 
                <taxondetermination>
131 143 
                    <role>identifier</role>
132 144 
                    <determinationdate>
......
204 216 
                        </plantconcept>
205 217 
                    </plantconcept_id>
206 218 
                </taxondetermination>
207 
                <verbatimcollectorname>
208 
                    <_merge>
209 
                        <1>$Collector</1>
210 
                        <2>$Addcoll</2>
211 
                    </_merge>
212 
                </verbatimcollectorname>
213 
            </specimenreplicate>
219 
            </taxonoccurrence>
214 220 
        </locationevent>
215 221 
        <locationnarrative>
216 222 
            <_merge>
......
246 252 
        </sourceaccessioncode>
247 253 
    </location>
248 254 
</VegBIEN>
249 
Inserted 20 new rows into database
255 
Inserted 26 new rows into database
inputs/U/maps/VegBIEN.specimens.csv
8 8 
Colldd,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
9 9 
Collmm,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/MonthCollected; http://rs.tdwg.org/dwc/terms/#eventDate,10; 44
10 10 
Collyy,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearCollected; http://rs.tdwg.org/dwc/terms/#eventDate,9; 44
11 
Barcode,/location/locationevent/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
12 
Number,/location/locationevent/specimenreplicate/collectionnumber/_alt/1/_alt/2,,http://rs.tdwg.org/dwc/terms/#recordNumber,22
13 
Notes,/location/locationevent/specimenreplicate/description/_merge/1,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Notes; http://rs.tdwg.org/dwc/terms/#fieldNotes,47; 54
14 
ID,/location/locationevent/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/tdwg_dw_core.xsd#/GlobalUniqueIdentifier; http://rs.tdwg.org/dwc/terms/#occurrenceID,0; 19
15 
Detyy,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,53; 120
16 
Detby,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
17 
Detby,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/middlename/_namePart/middle,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
18 
Detby,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/surname/_namePart/last,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
19 
Genus,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#genus,147
20 
Family,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#family,146
21 
Collector,/location/locationevent/specimenreplicate/verbatimcollectorname/_merge/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23
22 
Addcoll,/location/locationevent/specimenreplicate/verbatimcollectorname/_merge/2,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23
11 
Barcode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
12 
Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/2,,http://rs.tdwg.org/dwc/terms/#recordNumber,22
13 
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/description/_merge/1,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Notes; http://rs.tdwg.org/dwc/terms/#fieldNotes,47; 54
14 
ID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/tdwg_dw_core.xsd#/GlobalUniqueIdentifier; http://rs.tdwg.org/dwc/terms/#occurrenceID,0; 19
15 
Collector,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname/_merge/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23
16 
Addcoll,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname/_merge/2,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23
17 
Detyy,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,53; 120
18 
Detby,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
19 
Detby,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/middlename/_namePart/middle,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
20 
Detby,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/surname/_namePart/last,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
21 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#genus,147
22 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#family,146
23 23 
Gazetteer,"/location/locationnarrative/_merge/2/_merge/1/_label[label=""gazetteer""]/value/_merge/1",,http://rs.tdwg.org/dwc/terms/#verbatimLocality,69
24 24 
Newgazett,"/location/locationnarrative/_merge/2/_merge/1/_label[label=""gazetteer""]/value/_merge/2",Only used in 1 row,http://rs.tdwg.org/dwc/terms/#verbatimLocality,69
25 25 
Locnotes,/location/locationnarrative/_merge/2/_merge/2,,http://rs.tdwg.org/dwc/terms/#verbatimLocality,69
inputs/ARIZ/test/import.specimens.xml.ref
220 220 
                    </date>
221 221 
                </_date>
222 222 
            </obsstartdate>
223 
            <specimenreplicate>
224 
                <catalognumber_dwc>$CatalogNumberNumeric</catalognumber_dwc>
225 
                <collectioncode_dwc>$CollectionCode</collectioncode_dwc>
226 
                <collectionnumber>
227 
                    <_alt>
228 
                        <1><_alt><1>$CollectorNumber</1></_alt></1>
229 
                        <3>$FieldNumber</3>
230 
                    </_alt>
231 
                </collectionnumber>
232 
                <definedvalue fkey="tablerecord_id">
233 
                    <userdefined_id>
234 
                        <userdefined>
235 
                            <tablename>specimenreplicate</tablename>
236 
                            <userdefinedname>sex</userdefinedname>
237 
                        </userdefined>
238 
                    </userdefined_id>
239 
                    <definedvalue>$Sex</definedvalue>
240 
                </definedvalue>
241 
                <description>
242 
                    <_merge>
243 
                        <1>$FieldNotes</1>
244 
                        <2>$Remarks</2>
245 
                    </_merge>
246 
                </description>
247 
                <institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id>
248 
                <sourceaccessioncode>$GlobalUniqueIdentifier</sourceaccessioncode>
223 
            <taxonoccurrence>
224 
                <aggregateoccurrence>
225 
                    <plantobservation>
226 
                        <specimenreplicate>
227 
                            <catalognumber_dwc>$CatalogNumberNumeric</catalognumber_dwc>
228 
                            <collectioncode_dwc>$CollectionCode</collectioncode_dwc>
229 
                            <collectionnumber>
230 
                                <_alt>
231 
                                    <1><_alt><1>$CollectorNumber</1></_alt></1>
232 
                                    <3>$FieldNumber</3>
233 
                                </_alt>
234 
                            </collectionnumber>
235 
                            <definedvalue fkey="tablerecord_id">
236 
                                <userdefined_id>
237 
                                    <userdefined>
238 
                                        <tablename>specimenreplicate</tablename>
239 
                                        <userdefinedname>sex</userdefinedname>
240 
                                    </userdefined>
241 
                                </userdefined_id>
242 
                                <definedvalue>$Sex</definedvalue>
243 
                            </definedvalue>
244 
                            <description>
245 
                                <_merge>
246 
                                    <1>$FieldNotes</1>
247 
                                    <2>$Remarks</2>
248 
                                </_merge>
249 
                            </description>
250 
                            <institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id>
251 
                            <sourceaccessioncode>$GlobalUniqueIdentifier</sourceaccessioncode>
252 
                            <verbatimcollectorname>$Collector</verbatimcollectorname>
253 
                        </specimenreplicate>
254 
                    </plantobservation>
255 
                </aggregateoccurrence>
249 256 
                <taxondetermination>
250 257 
                    <role>identifier</role>
251 258 
                    <determinationdate>
......
369 376 
                        </plantconcept>
370 377 
                    </plantconcept_id>
371 378 
                </taxondetermination>
372 
                <verbatimcollectorname>$Collector</verbatimcollectorname>
373 
            </specimenreplicate>
379 
            </taxonoccurrence>
374 380 
            <waterdepth>
375 381 
                <_avg>
376 382 
                    <max>
......
407 413 
        </sourceaccessioncode>
408 414 
    </location>
409 415 
</VegBIEN>
410 
Inserted 32 new rows into database
416 
Inserted 38 new rows into database
inputs/ARIZ/maps/VegBIEN.specimens.csv
22 22 
DayCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
23 23 
MonthCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/MonthCollected; http://rs.tdwg.org/dwc/terms/#eventDate,10; 44
24 24 
YearCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearCollected; http://rs.tdwg.org/dwc/terms/#eventDate,9; 44
25 
CatalogNumberNumeric,/location/locationevent/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
26 
CollectionCode,/location/locationevent/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,http://rs.tdwg.org/dwc/terms/#collectionCode,12
27 
CollectorNumber,/location/locationevent/specimenreplicate/collectionnumber/_alt/1/_alt/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/CollectorNumber; http://rs.tdwg.org/dwc/terms/#recordNumber,7; 22
28 
FieldNumber,/location/locationevent/specimenreplicate/collectionnumber/_alt/3,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53
29 
Sex,"/location/locationevent/specimenreplicate/definedvalue[*_id/userdefined[tablename=specimenreplicate,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",http://rs.tdwg.org/dwc/terms/#sex,26
30 
FieldNotes,/location/locationevent/specimenreplicate/description/_merge/1,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
31 
Remarks,/location/locationevent/specimenreplicate/description/_merge/2,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Remarks; http://rs.tdwg.org/dwc/terms/#taxonRemarks,65; 158
32 
InstitutionCode,/location/locationevent/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
33 
GlobalUniqueIdentifier,/location/locationevent/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/tdwg_dw_core.xsd#/GlobalUniqueIdentifier; http://rs.tdwg.org/dwc/terms/#occurrenceID,0; 19
34 
DayIdentified,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,55; 120
35 
MonthIdentified,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/MonthIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,54; 120
36 
YearIdentified,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,53; 120
37 
IdentifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
38 
IdentifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/middlename/_namePart/middle,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
39 
IdentifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/surname/_namePart/last,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
40 
ScientificNameAuthor,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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/_alt/1",Contains the binomial in addition to the authority,http://rs.tdwg.org/dwc/terms/#scientificName,134
41 
ScientificName,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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/_alt/2",,http://rs.tdwg.org/dwc/terms/#scientificName,134
42 
Subspecies,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Subspecies; http://rs.tdwg.org/dwc/terms/#infraspecificEpithet,49; 150
43 
Species,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Species; http://rs.tdwg.org/dwc/terms/#specificEpithet,12; 149
44 
Genus,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#genus,147
45 
Family,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#family,146
46 
Order,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,http://rs.tdwg.org/dwc/terms/#order,145
47 
Class,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,http://rs.tdwg.org/dwc/terms/#class,144
48 
Phylum,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#phylum,143
49 
Kingdom,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#kingdom,142
50 
Collector,/location/locationevent/specimenreplicate/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23
25 
CatalogNumberNumeric,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
26 
CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/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,http://rs.tdwg.org/dwc/terms/#collectionCode,12
27 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/CollectorNumber; http://rs.tdwg.org/dwc/terms/#recordNumber,7; 22
28 
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/3,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53
29 
Sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/definedvalue[*_id/userdefined[tablename=specimenreplicate,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",http://rs.tdwg.org/dwc/terms/#sex,26
30 
FieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/description/_merge/1,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
31 
Remarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/description/_merge/2,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Remarks; http://rs.tdwg.org/dwc/terms/#taxonRemarks,65; 158
32 
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
33 
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/tdwg_dw_core.xsd#/GlobalUniqueIdentifier; http://rs.tdwg.org/dwc/terms/#occurrenceID,0; 19
34 
Collector,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23
35 
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,55; 120
36 
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/MonthIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,54; 120
37 
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,53; 120
38 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
39 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/middlename/_namePart/middle,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
40 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/surname/_namePart/last,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
41 
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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/_alt/1",Contains the binomial in addition to the authority,http://rs.tdwg.org/dwc/terms/#scientificName,134
42 
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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/_alt/2",,http://rs.tdwg.org/dwc/terms/#scientificName,134
43 
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Subspecies; http://rs.tdwg.org/dwc/terms/#infraspecificEpithet,49; 150
44 
Species,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Species; http://rs.tdwg.org/dwc/terms/#specificEpithet,12; 149
45 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#genus,147
46 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#family,146
47 
Order,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,http://rs.tdwg.org/dwc/terms/#order,145
48 
Class,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,http://rs.tdwg.org/dwc/terms/#class,144
49 
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#phylum,143
50 
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,http://rs.tdwg.org/dwc/terms/#kingdom,142
51 51 
MaximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/#maximumDepthInMeters,75
52 52 
MinimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,http://rs.tdwg.org/dwc/terms/#minimumDepthInMeters,74
53 53 
Locality,/location/locationnarrative/_merge/1,,http://rs.tdwg.org/dwc/terms/#locality,68
inputs/GBIF/test/import.specimens.xml.ref
138 138 
        <locationevent>
139 139 
            <obsenddate><_date><date><_dateRangeEnd><value><_alt><2>$LatestDateCollected</2></_alt></value></_dateRangeEnd></date></_date></obsenddate>
140 140 
            <obsstartdate><_date><date><_dateRangeStart><value><_alt><2>$LatestDateCollected</2></_alt></value></_dateRangeStart></date></_date></obsstartdate>
141 
            <specimenreplicate>
142 
                <catalognumber_dwc>$CatalogNO</catalognumber_dwc>
143 
                <collectioncode_dwc>$CollectionCD</collectioncode_dwc>
144 
                <institution_id><party><organizationname>$InstitutionCD</organizationname></party></institution_id>
141 
            <taxonoccurrence>
142 
                <aggregateoccurrence>
143 
                    <plantobservation>
144 
                        <specimenreplicate>
145 
                            <catalognumber_dwc>$CatalogNO</catalognumber_dwc>
146 
                            <collectioncode_dwc>$CollectionCD</collectioncode_dwc>
147 
                            <institution_id><party><organizationname>$InstitutionCD</organizationname></party></institution_id>
148 
                            <verbatimcollectorname>$Collector</verbatimcollectorname>
149 
                        </specimenreplicate>
150 
                    </plantobservation>
151 
                </aggregateoccurrence>
145 152 
                <taxondetermination>
146 153 
                    <iscurrent>true</iscurrent>
147 154 
                    <role>identifier</role>
......
200 207 
                        </plantconcept>
201 208 
                    </plantconcept_id>
202 209 
                </taxondetermination>
203 
                <verbatimcollectorname>$Collector</verbatimcollectorname>
204 
            </specimenreplicate>
210 
            </taxonoccurrence>
205 211 
        </locationevent>
206 212 
        <locationnarrative><_merge><1>$Locality</1></_merge></locationnarrative>
207 213 
        <sourceaccessioncode>
......
217 223 
        </sourceaccessioncode>
218 224 
    </location>
219 225 
</VegBIEN>
220 
Inserted 25 new rows into database
226 
Inserted 31 new rows into database
inputs/GBIF/maps/VegBIEN.specimens.csv
13 13 
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",,http://rs.tdwg.org/dwc/terms/#country,63
14 14 
LatestDateCollected,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
15 15 
LatestDateCollected,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
16 
CatalogNO,/location/locationevent/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
17 
CollectionCD,/location/locationevent/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,http://rs.tdwg.org/dwc/terms/#collectionCode,12
18 
InstitutionCD,/location/locationevent/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
19 
IdentifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
20 
IdentifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/middlename/_namePart/middle,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
21 
IdentifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/surname/_namePart/last,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
22 
ScientificName,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#scientificName,134
23 
AuthorOfScientificName,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/ScientificNameAuthor; http://rs.tdwg.org/dwc/terms/#scientificNameAuthorship,50; 153
24 
InfraspecificEpithet,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#infraspecificEpithet,150
25 
SpecificEpithet,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#specificEpithet,149
26 
Genus,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#genus,147
27 
Family,"/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#family,146
28 
Collector,/location/locationevent/specimenreplicate/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23
16 
CatalogNO,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
17 
CollectionCD,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/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,http://rs.tdwg.org/dwc/terms/#collectionCode,12
18 
InstitutionCD,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
19 
Collector,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23
20 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
21 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/middlename/_namePart/middle,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
22 
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/surname/_namePart/last,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
23 
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#scientificName,134
24 
AuthorOfScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/ScientificNameAuthor; http://rs.tdwg.org/dwc/terms/#scientificNameAuthorship,50; 153
25 
InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#infraspecificEpithet,150
26 
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#specificEpithet,149
27 
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#genus,147
28 
Family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,http://rs.tdwg.org/dwc/terms/#family,146
29 29 
Locality,/location/locationnarrative/_merge/1,,http://rs.tdwg.org/dwc/terms/#locality,68
30 30 
InstitutionCD,/location/sourceaccessioncode/_alt/2/_merge/1,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
31 31 
CollectionCD,/location/sourceaccessioncode/_alt/2/_merge/2,,http://rs.tdwg.org/dwc/terms/#collectionCode,12
inputs/NCU-NCSC/test/import.specimens.xml.ref
63 63 
        <locationevent>
64 64 
            <obsenddate><_date><date><_dateRangeEnd><value><_alt><3>$Collect Date</3></_alt></value></_dateRangeEnd></date></_date></obsenddate>
65 65 
            <obsstartdate><_date><date><_dateRangeStart><value><_alt><3>$Collect Date</3></_alt></value></_dateRangeStart></date></_date></obsstartdate>
66 
            <specimenreplicate>
67 
                <catalognumber_dwc>$Barcode</catalognumber_dwc>
68 
                <collectioncode_dwc>$SeriesName</collectioncode_dwc>
69 
                <growthform>
70 
                    <_map>
71 
                        <tree>*</tree>
72 
                        <shrub>*</shrub>
73 
                        <liana>*</liana>
74 
                        <vine>*</vine>
75 
                        <herb>*</herb>
76 
                        <hemiepiphyte>*</hemiepiphyte>
77 
                        <epiphyte>*</epiphyte>
78 
                        <grass>*</grass>
79 
                        <forb>*</forb>
80 
                        <moss>*</moss>
81 
                        <lichen>*</lichen>
82 
                        <fungus>*</fungus>
83 
                        <floating aquatic>*</floating aquatic>
84 
                        <submerged aquatic>*</submerged aquatic>
85 
                        <*></*>
86 
                        <value>
87 
                            <_map>
88 
                                <Yes>cultivated</Yes>
89 
                                <No>wild</No>
90 
                                <value>$Cultivated?</value>
91 
                            </_map>
92 
                        </value>
93 
                    </_map>
94 
                </growthform>
95 
                <iscultivated>
96 
                    <_map>
97 
                        <cultivated>t</cultivated>
98 
                        <wild>f</wild>
99 
                        <*></*>
100 
                        <value>
101 
                            <_map>
102 
                                <Yes>cultivated</Yes>
103 
                                <No>wild</No>
104 
                                <value>$Cultivated?</value>
105 
                            </_map>
106 
                        </value>
107 
                    </_map>
108 
                </iscultivated>
109 
                <isnative>
110 
                    <_map>
111 
                        <native>t</native>
112 
                        <exotic>f</exotic>
113 
                        <*></*>
114 
                        <value>
115 
                            <_map>
116 
                                <Yes>cultivated</Yes>
117 
                                <No>wild</No>
118 
                                <value>$Cultivated?</value>
119 
                            </_map>
120 
                        </value>
121 
                    </_map>
122 
                </isnative>
123 
                <sourceaccessioncode>$Accession Number</sourceaccessioncode>
66 
            <taxonoccurrence>
67 
                <aggregateoccurrence>
68 
                    <plantobservation>
69 
                        <specimenreplicate>
70 
                            <catalognumber_dwc>$Barcode</catalognumber_dwc>
71 
                            <collectioncode_dwc>$SeriesName</collectioncode_dwc>
72 
                            <growthform>
73 
                                <_map>
74 
                                    <tree>*</tree>
75 
                                    <shrub>*</shrub>
76 
                                    <liana>*</liana>
77 
                                    <vine>*</vine>
78 
                                    <herb>*</herb>
79 
                                    <hemiepiphyte>*</hemiepiphyte>
80 
                                    <epiphyte>*</epiphyte>
81 
                                    <grass>*</grass>
82 
                                    <forb>*</forb>
83 
                                    <moss>*</moss>
84 
                                    <lichen>*</lichen>
85 
                                    <fungus>*</fungus>
86 
                                    <floating aquatic>*</floating aquatic>
87 
                                    <submerged aquatic>*</submerged aquatic>
88 
                                    <*></*>
89 
                                    <value>
90 
                                        <_map>
91 
                                            <Yes>cultivated</Yes>
92 
                                            <No>wild</No>
93 
                                            <value>$Cultivated?</value>
94 
                                        </_map>
95 
                                    </value>
96 
                                </_map>
97 
                            </growthform>
98 
                            <iscultivated>
99 
                                <_map>
100 
                                    <cultivated>t</cultivated>
101 
                                    <wild>f</wild>
102 
                                    <*></*>
103 
                                    <value>
104 
                                        <_map>
105 
                                            <Yes>cultivated</Yes>
106 
                                            <No>wild</No>
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff