Project

General

Profile

« Previous | Next » 

Revision 3199

Added by Aaron Marcuse-Kubitza over 12 years ago

VegBIEN: Fixing import issue related to duplicate entries in tables with children, where when a new table entry duplicates an existing entry, the 1:1 tables of that table and those tables' children are not merged, causing them to become orphaned. It is described in detail at <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Import_issues#Merging-duplicates-with-children&gt;, including the rationale for this solution. Note that this is not a bug in column-based import, it applies to row-based import as well. This commit fixes the issue for specimenreplicate->taxonoccurrence.

View differences:

inputs/GBIF/test/import.specimens.out.ref
1 
Inserted 27 new rows into database
1 
Inserted 25 new rows into database
inputs/GBIF/maps/VegBIEN.specimens.csv
1 1 
GBIF[DwC],VegBIEN:/specimenreplicate,Comments,Order
2 
County,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66
3 
StateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65
4 
Country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/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",Brad: Required; reject record if this field NULL,63
5 
Locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
6 
MinimumElevationInMeter,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71
7 
MaximumElevationInMeter,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72
8 
DecimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
9 
VerbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81
10 
DecimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
11 
VerbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82
12 
LatestDateCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/2",,44
13 
IdentifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
14 
ScientificName,"/*_id/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","Brad: Bob, Nick, please is this mapping OK?",134
15 
AuthorOfScientificName,"/*_id/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","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
16 
InfraspecificEpithet,"/*_id/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",,150
17 
SpecificEpithet,"/*_id/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",,149
18 
Genus,"/*_id/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",,147
19 
Family,"/*_id/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",,146
20 
Collector,/*_id/taxonoccurrence/verbatimcollectorname,,23
2 
County,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66
3 
StateProvince,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65
4 
Country,"/*_id/locationevent/*_id/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",Brad: Required; reject record if this field NULL,63
5 
Locality,/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
6 
MinimumElevationInMeter,"/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71
7 
MaximumElevationInMeter,"/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72
8 
DecimalLatitude,"/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
9 
VerbatimLatitude,"/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81
10 
DecimalLongitude,"/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
11 
VerbatimLongitude,"/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82
12 
LatestDateCollected,"/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/2",,44
21 13 
CollectionCD,/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,12
22 
CatalogNO,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/catalognumber_dwc","Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
14 
IdentifiedBy,"/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
15 
ScientificName,"/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","Brad: Bob, Nick, please is this mapping OK?",134
16 
AuthorOfScientificName,"/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","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
17 
InfraspecificEpithet,"/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",,150
18 
SpecificEpithet,"/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",,149
19 
Genus,"/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",,147
20 
Family,"/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",,146
21 
Collector,/verbatimcollectorname,,23
22 
CatalogNO,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
23 23 
InstitutionCD,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/institution_id/party/organizationname,,
24 24 
GBIFFamilyOriginal,,** No non-empty join mapping for originalNameUsage/_alt/2/_name/first ** DwC doesn't fully support taxonomic redeterminations
25 25 
GBIFGenusOriginal,,** No non-empty join mapping for originalNameUsage/_alt/2/_name/middle ** DwC doesn't fully support taxonomic redeterminations
inputs/NCU-NCSC/test/VegBIEN.specimens.xml.ref
1 1 
<?xml version="1.0" ?>
2 2 
<VegBIEN>
3 3 
    <specimenreplicate id="0">
4 
        <taxonoccurrence_id>
5 
            <taxonoccurrence>
6 
                <locationevent_id>
7 
                    <locationevent>
8 
                        <location_id>
9 
                            <location>
10 
                                <locationdetermination>
11 
                                    <namedplace_id>
4 
        <locationevent_id>
5 
            <locationevent>
6 
                <location_id>
7 
                    <location>
8 
                        <locationdetermination>
9 
                            <namedplace_id>
10 
                                <namedplace>
11 
                                    <rank>county</rank>
12 
                                    <placename>Lancaster</placename>
13 
                                    <parent_id>
12 14 
                                        <namedplace>
13 
                                            <rank>county</rank>
14 
                                            <placename>Lancaster</placename>
15 
                                            <rank>stateProvince</rank>
16 
                                            <placename>Virginia</placename>
15 17 
                                            <parent_id>
16 18 
                                                <namedplace>
17 
                                                    <rank>stateProvince</rank>
18 
                                                    <placename>Virginia</placename>
19 
                                                    <parent_id>
20 
                                                        <namedplace>
21 
                                                            <rank>country</rank>
22 
                                                            <placename>USA</placename>
23 
                                                        </namedplace>
24 
                                                    </parent_id>
19 
                                                    <rank>country</rank>
20 
                                                    <placename>USA</placename>
25 21 
                                                </namedplace>
26 22 
                                            </parent_id>
27 23 
                                        </namedplace>
28 
                                    </namedplace_id>
29 
                                </locationdetermination>
30 
                            </location>
31 
                        </location_id>
32 
                        <obsstartdate>1994-06-25</obsstartdate>
33 
                        <obsenddate/>
34 
                    </locationevent>
35 
                </locationevent_id>
36 
                <taxondetermination>
37 
                    <isoriginal>true</isoriginal>
38 
                    <iscurrent>true</iscurrent>
39 
                    <role>identifier</role>
40 
                    <plantconcept_id>
41 
                        <plantconcept>
42 
                            <plantname_id>
43 
                                <plantname>
44 
                                    <rank>binomial</rank>
45 
                                    <plantname>Sanguinaria canadensis</plantname>
46 
                                </plantname>
47 
                            </plantname_id>
48 
                        </plantconcept>
49 
                    </plantconcept_id>
50 
                </taxondetermination>
51 
                <growthform/>
52 
                <iscultivated>f</iscultivated>
53 
                <isnative/>
54 
            </taxonoccurrence>
55 
        </taxonoccurrence_id>
24 
                                    </parent_id>
25 
                                </namedplace>
26 
                            </namedplace_id>
27 
                        </locationdetermination>
28 
                    </location>
29 
                </location_id>
30 
                <obsstartdate>1994-06-25</obsstartdate>
31 
                <obsenddate/>
32 
            </locationevent>
33 
        </locationevent_id>
56 34 
        <collectioncode_dwc>NCU</collectioncode_dwc>
35 
        <taxondetermination>
36 
            <isoriginal>true</isoriginal>
37 
            <iscurrent>true</iscurrent>
38 
            <role>identifier</role>
39 
            <plantconcept_id>
40 
                <plantconcept>
41 
                    <plantname_id>
42 
                        <plantname>
43 
                            <rank>binomial</rank>
44 
                            <plantname>Sanguinaria canadensis</plantname>
45 
                        </plantname>
46 
                    </plantname_id>
47 
                </plantconcept>
48 
            </plantconcept_id>
49 
        </taxondetermination>
50 
        <growthform/>
51 
        <iscultivated>f</iscultivated>
52 
        <isnative/>
57 53 
        <datasource_id><party><organizationname>NCU-NCSC</organizationname></party></datasource_id>
58 54 
        <catalognumber_dwc>NCU00090254</catalognumber_dwc>
59 55 
        <sourceaccessioncode>0</sourceaccessioncode>
60 56 
    </specimenreplicate>
61 57 
    <specimenreplicate id="1">
62 
        <taxonoccurrence_id>
63 
            <taxonoccurrence>
64 
                <locationevent_id>
65 
                    <locationevent>
66 
                        <location_id>
67 
                            <location>
68 
                                <locationdetermination>
69 
                                    <coordsaccuracy>1000</coordsaccuracy>
70 
                                    <namedplace_id>
58 
        <locationevent_id>
59 
            <locationevent>
60 
                <location_id>
61 
                    <location>
62 
                        <locationdetermination>
63 
                            <coordsaccuracy>1000</coordsaccuracy>
64 
                            <namedplace_id>
65 
                                <namedplace>
66 
                                    <rank>county</rank>
67 
                                    <placename>Moore</placename>
68 
                                    <parent_id>
71 69 
                                        <namedplace>
72 
                                            <rank>county</rank>
73 
                                            <placename>Moore</placename>
70 
                                            <rank>stateProvince</rank>
71 
                                            <placename>North Carolina</placename>
74 72 
                                            <parent_id>
75 73 
                                                <namedplace>
76 
                                                    <rank>stateProvince</rank>
77 
                                                    <placename>North Carolina</placename>
78 
                                                    <parent_id>
79 
                                                        <namedplace>
80 
                                                            <rank>country</rank>
81 
                                                            <placename>USA</placename>
82 
                                                        </namedplace>
83 
                                                    </parent_id>
74 
                                                    <rank>country</rank>
75 
                                                    <placename>USA</placename>
84 76 
                                                </namedplace>
85 77 
                                            </parent_id>
86 78 
                                        </namedplace>
87 
                                    </namedplace_id>
88 
                                    <latitude>35.1611111</latitude>
89 
                                    <longitude>-79.3486111</longitude>
90 
                                </locationdetermination>
91 
                                <centerlatitude>35.1611111</centerlatitude>
92 
                                <centerlongitude>-79.3486111</centerlongitude>
93 
                            </location>
94 
                        </location_id>
95 
                        <obsstartdate>1965-05-08</obsstartdate>
96 
                        <obsenddate/>
97 
                    </locationevent>
98 
                </locationevent_id>
99 
                <taxondetermination>
100 
                    <isoriginal>true</isoriginal>
101 
                    <iscurrent>true</iscurrent>
102 
                    <role>identifier</role>
103 
                    <plantconcept_id>
104 
                        <plantconcept>
105 
                            <plantname_id>
106 
                                <plantname>
107 
                                    <rank>binomial</rank>
108 
                                    <plantname>Senecio anonymus</plantname>
109 
                                </plantname>
110 
                            </plantname_id>
111 
                        </plantconcept>
112 
                    </plantconcept_id>
113 
                </taxondetermination>
114 
                <growthform/>
115 
                <iscultivated>f</iscultivated>
116 
                <isnative/>
117 
            </taxonoccurrence>
118 
        </taxonoccurrence_id>
79 
                                    </parent_id>
80 
                                </namedplace>
81 
                            </namedplace_id>
82 
                            <latitude>35.1611111</latitude>
83 
                            <longitude>-79.3486111</longitude>
84 
                        </locationdetermination>
85 
                        <centerlatitude>35.1611111</centerlatitude>
86 
                        <centerlongitude>-79.3486111</centerlongitude>
87 
                    </location>
88 
                </location_id>
89 
                <obsstartdate>1965-05-08</obsstartdate>
90 
                <obsenddate/>
91 
            </locationevent>
92 
        </locationevent_id>
119 93 
        <collectioncode_dwc>WEWO</collectioncode_dwc>
94 
        <taxondetermination>
95 
            <isoriginal>true</isoriginal>
96 
            <iscurrent>true</iscurrent>
97 
            <role>identifier</role>
98 
            <plantconcept_id>
99 
                <plantconcept>
100 
                    <plantname_id>
101 
                        <plantname>
102 
                            <rank>binomial</rank>
103 
                            <plantname>Senecio anonymus</plantname>
104 
                        </plantname>
105 
                    </plantname_id>
106 
                </plantconcept>
107 
            </plantconcept_id>
108 
        </taxondetermination>
109 
        <growthform/>
110 
        <iscultivated>f</iscultivated>
111 
        <isnative/>
120 112 
        <datasource_id><party><organizationname>NCU-NCSC</organizationname></party></datasource_id>
121 113 
        <sourceaccessioncode>1</sourceaccessioncode>
122 114 
    </specimenreplicate>
inputs/SpeciesLink/test/import.specimens.out.ref
1 
Inserted 36 new rows into database
1 
Inserted 34 new rows into database
inputs/SpeciesLink/maps/VegBIEN.specimens.csv
1 1 
"SpeciesLink[DwC,dwc_dwcore_,dwc_curatorial_,dwc_geospatial_,http__purl_org_,dwc_terms_,conceptual_darwin_2003_1_0_]",VegBIEN:/specimenreplicate,Comments,Order
2 
coordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88
3 
CoordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89
4 
BoundingBox,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
5 
County,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66
6 
county,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66
7 
StateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65
8 
stateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65
9 
Country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/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",Brad: Required; reject record if this field NULL,63
10 
country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/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",Brad: Required; reject record if this field NULL,63
11 
Continent,"/*_id/taxonoccurrence/*_id/locationevent/*_id/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",Brad: OMIT,59
12 
ContinentOcean,"/*_id/taxonoccurrence/*_id/locationevent/*_id/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",Brad: OMIT,59
13 
continent,"/*_id/taxonoccurrence/*_id/locationevent/*_id/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",Brad: OMIT,59
14 
Locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
15 
locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
16 
MinimumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71
17 
MinimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71
18 
minimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71
19 
MaximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72
20 
MaximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72
21 
maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72
22 
DecimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
23 
Latitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81
24 
VerbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81
25 
decimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
26 
verbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81
27 
DecimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
28 
Longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82
29 
VerbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82
30 
decimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
31 
verbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82
32 
MaximumDepth,"/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75
33 
MaximumDepthInMeters,"/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75
34 
maximumDepthInMeters,"/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75
35 
MinimumDepth,"/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,74
36 
MinimumDepthInMeters,"/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,74
37 
minimumDepthInMeters,"/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,74
38 
DayCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44
39 
MonthCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,44
40 
YearCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,44
41 
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,120
42 
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,120
43 
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,120
44 
dateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,120
45 
IdentifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
46 
identifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
47 
ScientificName,"/*_id/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","Brad: Bob, Nick, please is this mapping OK?",134
48 
scientificName,"/*_id/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","Brad: Bob, Nick, please is this mapping OK?",134
49 
AuthorYearOfScientificName,"/*_id/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","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
50 
ScientificNameAuthor,"/*_id/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","`union` would otherwise remove this input name because it's been mapped to (renamed) above; Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
51 
scientificNameAuthorship,"/*_id/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","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
52 
InfraspecificEpithet,"/*_id/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",,150
53 
Subspecies,"/*_id/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",,150
54 
infraspecificEpithet,"/*_id/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",,150
55 
Species,"/*_id/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",,149
56 
SpecificEpithet,"/*_id/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",,149
57 
specificEpithet,"/*_id/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",,149
58 
Genus,"/*_id/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",,147
59 
genus,"/*_id/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",,147
60 
Family,"/*_id/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",,146
61 
family,"/*_id/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",,146
62 
Order,"/*_id/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",,145
63 
order,"/*_id/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",,145
64 
Class,"/*_id/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",,144
65 
class,"/*_id/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",,144
66 
Phylum,"/*_id/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",,143
67 
phylum,"/*_id/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",,143
68 
Kingdom,"/*_id/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",,142
69 
kingdom,"/*_id/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",,142
70 
Collector,/*_id/taxonoccurrence/verbatimcollectorname,,23
71 
recordedBy,/*_id/taxonoccurrence/verbatimcollectorname,,23
2 
coordinateUncertaintyInMeters,/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88
3 
CoordinatePrecision,/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89
4 
BoundingBox,/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
5 
County,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66
6 
county,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66
7 
StateProvince,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65
8 
stateProvince,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65
9 
Country,"/*_id/locationevent/*_id/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",Brad: Required; reject record if this field NULL,63
10 
country,"/*_id/locationevent/*_id/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",Brad: Required; reject record if this field NULL,63
11 
Continent,"/*_id/locationevent/*_id/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",Brad: OMIT,59
12 
ContinentOcean,"/*_id/locationevent/*_id/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",Brad: OMIT,59
13 
continent,"/*_id/locationevent/*_id/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",Brad: OMIT,59
14 
Locality,/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
15 
locality,/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
16 
MinimumElevation,"/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71
17 
MinimumElevationInMeters,"/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71
18 
minimumElevationInMeters,"/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71
19 
MaximumElevation,"/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72
20 
MaximumElevationInMeters,"/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72
21 
maximumElevationInMeters,"/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72
22 
DecimalLatitude,"/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
23 
Latitude,"/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81
24 
VerbatimLatitude,"/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81
25 
decimalLatitude,"/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
26 
verbatimLatitude,"/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81
27 
DecimalLongitude,"/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
28 
Longitude,"/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82
29 
VerbatimLongitude,"/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82
30 
decimalLongitude,"/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
31 
verbatimLongitude,"/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82
32 
MaximumDepth,"/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75
33 
MaximumDepthInMeters,"/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75
34 
maximumDepthInMeters,"/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75
35 
MinimumDepth,"/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,74
36 
MinimumDepthInMeters,"/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,74
37 
minimumDepthInMeters,"/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,74
38 
DayCollected,"/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44
39 
MonthCollected,"/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,44
40 
YearCollected,"/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,44
72 41 
CollectionCode,/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,12
73 42 
collectionCode,/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,12
74 43 
Sex,"/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",26
75 44 
sex,"/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",26
76 45 
Notes,/description/_merge/1,,
77 46 
Remarks,/description/_merge/2,,158
78 
CatalogNumber,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/catalognumber_dwc","Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
79 
catalogNumber,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/catalognumber_dwc","Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
80 
GlobalUniqueIdentifier,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
47 
DayIdentified,"/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,120
48 
MonthIdentified,"/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,120
49 
YearIdentified,"/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,120
50 
dateIdentified,/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,120
51 
IdentifiedBy,"/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
52 
identifiedBy,"/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
53 
ScientificName,"/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","Brad: Bob, Nick, please is this mapping OK?",134
54 
scientificName,"/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","Brad: Bob, Nick, please is this mapping OK?",134
55 
AuthorYearOfScientificName,"/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","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
56 
ScientificNameAuthor,"/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","`union` would otherwise remove this input name because it's been mapped to (renamed) above; Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
57 
scientificNameAuthorship,"/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","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
58 
InfraspecificEpithet,"/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",,150
59 
Subspecies,"/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",,150
60 
infraspecificEpithet,"/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",,150
61 
Species,"/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",,149
62 
SpecificEpithet,"/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",,149
63 
specificEpithet,"/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",,149
64 
Genus,"/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",,147
65 
genus,"/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",,147
66 
Family,"/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",,146
67 
family,"/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",,146
68 
Order,"/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",,145
69 
order,"/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",,145
70 
Class,"/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",,144
71 
class,"/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",,144
72 
Phylum,"/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",,143
73 
phylum,"/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",,143
74 
Kingdom,"/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",,142
75 
kingdom,"/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",,142
76 
Collector,/verbatimcollectorname,,23
77 
recordedBy,/verbatimcollectorname,,23
78 
CatalogNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
79 
catalogNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
81 80 
CollectorNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1/_alt/1,,22
82 81 
recordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1/_alt/2,,22
83 82 
collectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9
......
85 84 
fieldNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53
86 85 
InstitutionCode,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/institution_id/party/organizationname,,
87 86 
institutionCode,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/institution_id/party/organizationname,,
87 
GlobalUniqueIdentifier,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,"Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
88 88 
BasisOfRecord,,** No non-empty join mapping for BasisOfRecord **
89 89 
DateLastModified,,** No non-empty join mapping for DateLastModified **
90 90 
DayOfYear,,** No non-empty join mapping for JulianDay **
inputs/MO/maps/VegBIEN.specimens.csv
1 1 
MO[DwC],VegBIEN:/specimenreplicate,Comments,Order
2 
County,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66
3 
StateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65
4 
Country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/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",Brad: Required; reject record if this field NULL,63
5 
ContinentOcean,"/*_id/taxonoccurrence/*_id/locationevent/*_id/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",Brad: OMIT,59
6 
Locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
7 
MinimumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71
8 
MaximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72
9 
latitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81
10 
longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82
11 
DayCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44
12 
MonthCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,44
13 
YearCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,44
14 
IdentifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
15 
ScientificName,"/*_id/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","Brad: Bob, Nick, please is this mapping OK?",134
16 
ScientificNameAuthor,"/*_id/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","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
17 
Subspecies,"/*_id/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",,150
18 
species,"/*_id/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",,149
19 
genus,"/*_id/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",,147
20 
family,"/*_id/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",,146
21 
Kingdom,"/*_id/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",,142
22 
Collector,/*_id/taxonoccurrence/verbatimcollectorname,,23
2 
County,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66
3 
StateProvince,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65
4 
Country,"/*_id/locationevent/*_id/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",Brad: Required; reject record if this field NULL,63
5 
ContinentOcean,"/*_id/locationevent/*_id/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",Brad: OMIT,59
6 
Locality,/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
7 
MinimumElevation,"/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71
8 
MaximumElevation,"/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72
9 
latitude,"/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81
10 
longitude,"/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82
11 
DayCollected,"/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44
12 
MonthCollected,"/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,44
13 
YearCollected,"/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,44
23 14 
CollectionCode,/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,12
24 15 
convertednotes,/description/_merge/1,,
25 
CatalogNumber,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/catalognumber_dwc","Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
16 
IdentifiedBy,"/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
17 
ScientificName,"/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","Brad: Bob, Nick, please is this mapping OK?",134
18 
ScientificNameAuthor,"/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","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
19 
Subspecies,"/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",,150
20 
species,"/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",,149
21 
genus,"/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",,147
22 
family,"/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",,146
23 
Kingdom,"/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",,142
24 
Collector,/verbatimcollectorname,,23
25 
CatalogNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
26 26 
CollectorNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1/_alt/1,,22
27 27 
InstitutionCode,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/institution_id/party/organizationname,,
28 28 
BasisOfRecord,,** No non-empty join mapping for BasisOfRecord **
inputs/QMOR/maps/VegBIEN.specimens.csv
1 1 
QMOR[DwC],VegBIEN:/specimenreplicate,Comments,Order
2 
coordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88
3 
footprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
4 
county,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66
5 
stateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65
6 
country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/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",Brad: Required; reject record if this field NULL,63
7 
continent,"/*_id/taxonoccurrence/*_id/locationevent/*_id/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",Brad: OMIT,59
8 
locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
9 
habitat,"/*_id/taxonoccurrence/*_id/locationevent/*_id/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?",52
10 
minimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71
11 
maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72
12 
decimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
13 
verbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81
14 
decimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
15 
verbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82
16 
eventDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/2",,44
17 
dateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,120
18 
identifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
19 
scientificName,"/*_id/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","Brad: Bob, Nick, please is this mapping OK?",134
20 
scientificNameAuthorship,"/*_id/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","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
21 
infraspecificEpithet,"/*_id/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",,150
22 
specificEpithet,"/*_id/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",,149
23 
genus,"/*_id/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",,147
24 
family,"/*_id/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",,146
25 
order,"/*_id/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",,145
26 
class,"/*_id/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",,144
27 
phylum,"/*_id/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",,143
28 
kingdom,"/*_id/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",,142
29 
recordedBy,/*_id/taxonoccurrence/verbatimcollectorname,,23
2 
coordinateUncertaintyInMeters,/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88
3 
footprintWKT,/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
4 
county,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66
5 
stateProvince,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65
6 
country,"/*_id/locationevent/*_id/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",Brad: Required; reject record if this field NULL,63
7 
continent,"/*_id/locationevent/*_id/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",Brad: OMIT,59
8 
locality,/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
9 
habitat,"/*_id/locationevent/*_id/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?",52
10 
minimumElevationInMeters,"/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71
11 
maximumElevationInMeters,"/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72
12 
decimalLatitude,"/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
13 
verbatimLatitude,"/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81
14 
decimalLongitude,"/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
15 
verbatimLongitude,"/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82
16 
eventDate,"/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/2",,44
30 17 
collectionCode,/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,12
31 18 
sex,"/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",26
32 
catalogNumber,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/catalognumber_dwc","Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
33 
id,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
19 
dateIdentified,/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,120
20 
identifiedBy,"/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
21 
scientificName,"/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","Brad: Bob, Nick, please is this mapping OK?",134
22 
scientificNameAuthorship,"/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","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
23 
infraspecificEpithet,"/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",,150
24 
specificEpithet,"/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",,149
25 
genus,"/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",,147
26 
family,"/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",,146
27 
order,"/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",,145
28 
class,"/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",,144
29 
phylum,"/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",,143
30 
kingdom,"/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",,142
31 
recordedBy,/verbatimcollectorname,,23
32 
catalogNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
34 33 
collectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9
35 34 
institutionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,,8
36 35 
institutionCode,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/institution_id/party/organizationname,,
36 
id,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,"Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
37 37 
acceptedNameUsage,,** No non-empty join mapping for acceptedNameUsage **
38 38 
basisOfRecord,,** No non-empty join mapping for basisOfRecord **
39 39 
behavior,,** No non-empty join mapping for behavior **
inputs/MT/test/import.specimens.out.ref
1 
Inserted 18 new rows into database
1 
Inserted 16 new rows into database
inputs/MT/test/VegBIEN.specimens.xml.ref
1 1 
<?xml version="1.0" ?>
2 2 
<VegBIEN>
3 3 
    <specimenreplicate id="0">
4 
        <taxonoccurrence_id>
5 
            <taxonoccurrence>
6 
                <locationevent_id>
7 
                    <locationevent>
8 
                        <location_id>
9 
                            <location>
10 
                                <locationdetermination>
11 
                                    <namedplace_id>
12 
                                        <namedplace>
13 
                                            <rank>continent</rank>
14 
                                            <placename>NA</placename>
15 
                                        </namedplace>
16 
                                    </namedplace_id>
17 
                                </locationdetermination>
18 
                                <locationnarrative>Canada</locationnarrative>
19 
                            </location>
20 
                        </location_id>
21 
                    </locationevent>
22 
                </locationevent_id>
23 
                <taxondetermination>
24 
                    <isoriginal>true</isoriginal>
25 
                    <iscurrent>true</iscurrent>
26 
                    <role>identifier</role>
27 
                    <plantconcept_id>
28 
                        <plantconcept>
29 
                            <plantname_id>
4 
        <locationevent_id>
5 
            <locationevent>
6 
                <location_id>
7 
                    <location>
8 
                        <locationdetermination>
9 
                            <namedplace_id>
10 
                                <namedplace>
11 
                                    <rank>continent</rank>
12 
                                    <placename>NA</placename>
13 
                                </namedplace>
14 
                            </namedplace_id>
15 
                        </locationdetermination>
16 
                        <locationnarrative>Canada</locationnarrative>
17 
                    </location>
18 
                </location_id>
19 
            </locationevent>
20 
        </locationevent_id>
21 
        <collectioncode_dwc>MT</collectioncode_dwc>
22 
        <taxondetermination>
23 
            <isoriginal>true</isoriginal>
24 
            <iscurrent>true</iscurrent>
25 
            <role>identifier</role>
26 
            <plantconcept_id>
27 
                <plantconcept>
28 
                    <plantname_id>
29 
                        <plantname>
30 
                            <rank>genus</rank>
31 
                            <plantname>Lycopodium</plantname>
32 
                            <parent_id>
30 33 
                                <plantname>
31 
                                    <rank>genus</rank>
32 
                                    <plantname>Lycopodium</plantname>
33 
                                    <parent_id>
34 
                                        <plantname>
35 
                                            <rank>family</rank>
36 
                                            <plantname>Lycopodiaceae</plantname>
37 
                                        </plantname>
38 
                                    </parent_id>
34 
                                    <rank>family</rank>
35 
                                    <plantname>Lycopodiaceae</plantname>
39 36 
                                </plantname>
40 
                            </plantname_id>
41 
                        </plantconcept>
42 
                    </plantconcept_id>
43 
                </taxondetermination>
44 
            </taxonoccurrence>
45 
        </taxonoccurrence_id>
46 
        <collectioncode_dwc>MT</collectioncode_dwc>
37 
                            </parent_id>
38 
                        </plantname>
39 
                    </plantname_id>
40 
                </plantconcept>
41 
            </plantconcept_id>
42 
        </taxondetermination>
47 43 
        <datasource_id><party><organizationname>MT</organizationname></party></datasource_id>
48 
        <sourceaccessioncode>1</sourceaccessioncode>
49 44 
        <collectionnumber>urn:lsid:biocol.org:col:14437</collectionnumber>
50 45 
        <institution_id><party><organizationname>Universit&#233; de Montr&#233;al Biodiversity Centre</organizationname></party></institution_id>
46 
        <sourceaccessioncode>1</sourceaccessioncode>
51 47 
    </specimenreplicate>
52 48 
    <specimenreplicate id="1">
53 
        <taxonoccurrence_id>
54 
            <taxonoccurrence>
55 
                <locationevent_id>
56 
                    <locationevent>
57 
                        <location_id>
58 
                            <location>
59 
                                <locationdetermination>
60 
                                    <namedplace_id>
61 
                                        <namedplace>
62 
                                            <rank>continent</rank>
63 
                                            <placename>NA</placename>
64 
                                        </namedplace>
65 
                                    </namedplace_id>
66 
                                </locationdetermination>
67 
                                <locationnarrative>Canada</locationnarrative>
68 
                            </location>
69 
                        </location_id>
70 
                    </locationevent>
71 
                </locationevent_id>
72 
                <taxondetermination>
73 
                    <isoriginal>true</isoriginal>
74 
                    <iscurrent>true</iscurrent>
75 
                    <role>identifier</role>
76 
                    <plantconcept_id>
77 
                        <plantconcept>
78 
                            <plantname_id>
49 
        <locationevent_id>
50 
            <locationevent>
51 
                <location_id>
52 
                    <location>
53 
                        <locationdetermination>
54 
                            <namedplace_id>
55 
                                <namedplace>
56 
                                    <rank>continent</rank>
57 
                                    <placename>NA</placename>
58 
                                </namedplace>
59 
                            </namedplace_id>
60 
                        </locationdetermination>
61 
                        <locationnarrative>Canada</locationnarrative>
62 
                    </location>
63 
                </location_id>
64 
            </locationevent>
65 
        </locationevent_id>
66 
        <collectioncode_dwc>MT</collectioncode_dwc>
67 
        <taxondetermination>
68 
            <isoriginal>true</isoriginal>
69 
            <iscurrent>true</iscurrent>
70 
            <role>identifier</role>
71 
            <plantconcept_id>
72 
                <plantconcept>
73 
                    <plantname_id>
74 
                        <plantname>
75 
                            <rank>genus</rank>
76 
                            <plantname>Lycopodium</plantname>
77 
                            <parent_id>
79 78 
                                <plantname>
80 
                                    <rank>genus</rank>
81 
                                    <plantname>Lycopodium</plantname>
82 
                                    <parent_id>
83 
                                        <plantname>
84 
                                            <rank>family</rank>
85 
                                            <plantname>Lycopodiaceae</plantname>
86 
                                        </plantname>
87 
                                    </parent_id>
79 
                                    <rank>family</rank>
80 
                                    <plantname>Lycopodiaceae</plantname>
88 81 
                                </plantname>
89 
                            </plantname_id>
90 
                        </plantconcept>
91 
                    </plantconcept_id>
92 
                </taxondetermination>
93 
            </taxonoccurrence>
94 
        </taxonoccurrence_id>
95 
        <collectioncode_dwc>MT</collectioncode_dwc>
82 
                            </parent_id>
83 
                        </plantname>
84 
                    </plantname_id>
85 
                </plantconcept>
86 
            </plantconcept_id>
87 
        </taxondetermination>
96 88 
        <datasource_id><party><organizationname>MT</organizationname></party></datasource_id>
97 
        <sourceaccessioncode>2</sourceaccessioncode>
98 89 
        <collectionnumber>urn:lsid:biocol.org:col:14437</collectionnumber>
99 90 
        <institution_id><party><organizationname>Universit&#233; de Montr&#233;al Biodiversity Centre</organizationname></party></institution_id>
91 
        <sourceaccessioncode>2</sourceaccessioncode>
100 92 
    </specimenreplicate>
101 93 
</VegBIEN>
inputs/MT/maps/VegBIEN.specimens.csv
1 1 
MT[DwC],VegBIEN:/specimenreplicate,Comments,Order
2 
continent,"/*_id/taxonoccurrence/*_id/locationevent/*_id/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",Brad: OMIT,59
3 
locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
4 
genus,"/*_id/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",,147
5 
family,"/*_id/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",,146
6 
establishmentMeans,"/*_id/taxonoccurrence/{growthform/_map:[./{tree,shrub,liana,vine,herb,hemiepiphyte,epiphyte,grass,forb,moss,lichen,fungus,""floating aquatic"",""submerged aquatic""}=*,*=],iscultivated/_map:[cultivated=t,wild=f,*=],isnative/_map:[native=t,exotic=f,*=]}/value",,30
2 
continent,"/*_id/locationevent/*_id/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",Brad: OMIT,59
3 
locality,/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
7 4 
collectionCode,/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,12
8 
id,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
5 
genus,"/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",,147
6 
family,"/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",,146
7 
establishmentMeans,"/{growthform/_map:[./{tree,shrub,liana,vine,herb,hemiepiphyte,epiphyte,grass,forb,moss,lichen,fungus,""floating aquatic"",""submerged aquatic""}=*,*=],iscultivated/_map:[cultivated=t,wild=f,*=],isnative/_map:[native=t,exotic=f,*=]}/value",,30
9 8 
collectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9
10 9 
institutionCode,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/institution_id/party/organizationname,,
10 
id,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,"Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
11 11 
basisOfRecord,,** No non-empty join mapping for basisOfRecord **
12 12 
countryCode,,** No non-empty join mapping for countryCode **
13 13 
datasetName,,** No non-empty join mapping for datasetName **
inputs/XAL/test/import.specimens.out.ref
1 
Inserted 43 new rows into database
1 
Inserted 41 new rows into database
inputs/XAL/test/VegBIEN.specimens.xml.ref
1 1 
<?xml version="1.0" ?>
2 2 
<VegBIEN>
3 3 
    <specimenreplicate id="0">
4 
        <taxonoccurrence_id>
5 
            <taxonoccurrence>
6 
                <locationevent_id>
7 
                    <locationevent>
8 
                        <location_id>
9 
                            <location>
10 
                                <locationdetermination>
11 
                                    <namedplace_id>
4 
        <locationevent_id>
5 
            <locationevent>
6 
                <location_id>
7 
                    <location>
8 
                        <locationdetermination>
9 
                            <namedplace_id>
10 
                                <namedplace>
11 
                                    <rank>county</rank>
12 
                                    <placename>NAYAR, EL</placename>
13 
                                    <parent_id>
12 14 
                                        <namedplace>
13 
                                            <rank>county</rank>
14 
                                            <placename>NAYAR, EL</placename>
15 
                                            <rank>stateProvince</rank>
16 
                                            <placename>Nayarit</placename>
15 17 
                                            <parent_id>
16 18 
                                                <namedplace>
17 
                                                    <rank>stateProvince</rank>
18 
                                                    <placename>Nayarit</placename>
19 
                                                    <rank>country</rank>
20 
                                                    <placename>MEXICO</placename>
19 21 
                                                    <parent_id>
20 22 
                                                        <namedplace>
21 
                                                            <rank>country</rank>
22 
                                                            <placename>MEXICO</placename>
23 
                                                            <parent_id>
24 
                                                                <namedplace>
25 
                                                                    <rank>continent</rank>
26 
                                                                    <placename>AMERICA</placename>
27 
                                                                </namedplace>
28 
                                                            </parent_id>
23 
                                                            <rank>continent</rank>
24 
                                                            <placename>AMERICA</placename>
29 25 
                                                        </namedplace>
30 26 
                                                    </parent_id>
31 27 
                                                </namedplace>
32 28 
                                            </parent_id>
33 29 
                                        </namedplace>
34 
                                    </namedplace_id>
35 
                                    <latitude>22.267</latitude>
36 
                                    <longitude>-104.633</longitude>
37 
                                </locationdetermination>
38 
                                <locationnarrative>N de la cuesta, Cerro de La Loma</locationnarrative>
39 
                                <elevation>1200.0</elevation>
40 
                                <elevationrange/>
41 
                                <centerlatitude>22.267</centerlatitude>
42 
                                <centerlongitude>-104.633</centerlongitude>
43 
                            </location>
44 
                        </location_id>
45 
                        <waterdepth>1000.0</waterdepth>
46 
                        <obsstartdate>1994-04-21</obsstartdate>
47 
                        <obsenddate/>
48 
                    </locationevent>
49 
                </locationevent_id>
50 
                <taxondetermination>
51 
                    <iscurrent>true</iscurrent>
52 
                    <role>identifier</role>
53 
                    <party_id>
54 
                        <party>
55 
                            <givenname>ND</givenname>
56 
                            <middlename></middlename>
57 
                            <surname>ND</surname>
58 
                        </party>
59 
                    </party_id>
60 
                    <isoriginal>true</isoriginal>
61 
                    <plantconcept_id>
62 
                        <plantconcept>
63 
                            <plantname_id>
30 
                                    </parent_id>
31 
                                </namedplace>
32 
                            </namedplace_id>
33 
                            <latitude>22.267</latitude>
34 
                            <longitude>-104.633</longitude>
35 
                        </locationdetermination>
36 
                        <locationnarrative>N de la cuesta, Cerro de La Loma</locationnarrative>
37 
                        <elevation>1200.0</elevation>
38 
                        <elevationrange/>
39 
                        <centerlatitude>22.267</centerlatitude>
40 
                        <centerlongitude>-104.633</centerlongitude>
41 
                    </location>
42 
                </location_id>
43 
                <waterdepth>1000.0</waterdepth>
44 
                <obsstartdate>1994-04-21</obsstartdate>
45 
                <obsenddate/>
46 
            </locationevent>
47 
        </locationevent_id>
48 
        <collectioncode_dwc>XAL</collectioncode_dwc>
49 
        <definedvalue fkey="tablerecord_id">
50 
            <userdefined_id>
51 
                <userdefined>
52 
                    <tablename>specimenreplicate</tablename>
53 
                    <userdefinedname>sex</userdefinedname>
54 
                </userdefined>
55 
            </userdefined_id>
56 
            <definedvalue>ND</definedvalue>
57 
        </definedvalue>
58 
        <taxondetermination>
59 
            <iscurrent>true</iscurrent>
60 
            <role>identifier</role>
61 
            <party_id>
62 
                <party>
63 
                    <givenname>ND</givenname>
64 
                    <middlename></middlename>
65 
                    <surname>ND</surname>
66 
                </party>
67 
            </party_id>
68 
            <isoriginal>true</isoriginal>
69 
            <plantconcept_id>
70 
                <plantconcept>
71 
                    <plantname_id>
72 
                        <plantname>
73 
                            <rank>binomial</rank>
74 
                            <plantname>Chamaedorea Willd.</plantname>
75 
                            <parent_id>
64 76 
                                <plantname>
65 
                                    <rank>binomial</rank>
66 
                                    <plantname>Chamaedorea Willd.</plantname>
77 
                                    <rank>authority</rank>
78 
                                    <plantname>Willd.</plantname>
67 79 
                                    <parent_id>
68 80 
                                        <plantname>
69 
                                            <rank>authority</rank>
70 
                                            <plantname>Willd.</plantname>
81 
                                            <rank>genus</rank>
82 
                                            <plantname>Chamaedorea</plantname>
71 83 
                                            <parent_id>
72 84 
                                                <plantname>
73 
                                                    <rank>genus</rank>
74 
                                                    <plantname>Chamaedorea</plantname>
85 
                                                    <rank>family</rank>
86 
                                                    <plantname>Arecaceae</plantname>
75 87 
                                                    <parent_id>
76 88 
                                                        <plantname>
77 
                                                            <rank>family</rank>
78 
                                                            <plantname>Arecaceae</plantname>
89 
                                                            <rank>order</rank>
90 
                                                            <plantname>Arecales</plantname>
79 91 
                                                            <parent_id>
80 92 
                                                                <plantname>
81 
                                                                    <rank>order</rank>
82 
                                                                    <plantname>Arecales</plantname>
93 
                                                                    <rank>class</rank>
94 
                                                                    <plantname>LILIOPSIDA</plantname>
83 95 
                                                                    <parent_id>
84 96 
                                                                        <plantname>
85 
                                                                            <rank>class</rank>
86 
                                                                            <plantname>LILIOPSIDA</plantname>
97 
                                                                            <rank>subkingdom</rank>
98 
                                                                            <plantname>MAGNOLIOPHYTA</plantname>
87 99 
                                                                            <parent_id>
88 100 
                                                                                <plantname>
89 
                                                                                    <rank>subkingdom</rank>
90 
                                                                                    <plantname>MAGNOLIOPHYTA</plantname>
91 
                                                                                    <parent_id>
92 
                                                                                        <plantname>
93 
                                                                                            <rank>kingdom</rank>
94 
                                                                                            <plantname>PLANTAE</plantname>
95 
                                                                                        </plantname>
96 
                                                                                    </parent_id>
101 
                                                                                    <rank>kingdom</rank>
102 
                                                                                    <plantname>PLANTAE</plantname>
97 103 
                                                                                </plantname>
98 104 
                                                                            </parent_id>
99 105 
                                                                        </plantname>
......
107 113 
                                        </plantname>
108 114 
                                    </parent_id>
109 115 
                                </plantname>
110 
                            </plantname_id>
111 
                        </plantconcept>
112 
                    </plantconcept_id>
113 
                </taxondetermination>
114 
                <verbatimcollectorname>J.A. Machuca N.</verbatimcollectorname>
115 
            </taxonoccurrence>
116 
        </taxonoccurrence_id>
117 
        <collectioncode_dwc>XAL</collectioncode_dwc>
118 
        <definedvalue fkey="tablerecord_id">
119 
            <userdefined_id>
120 
                <userdefined>
121 
                    <tablename>specimenreplicate</tablename>
122 
                    <userdefinedname>sex</userdefinedname>
123 
                </userdefined>
124 
            </userdefined_id>
125 
            <definedvalue>ND</definedvalue>
126 
        </definedvalue>
116 
                            </parent_id>
117 
                        </plantname>
118 
                    </plantname_id>
119 
                </plantconcept>
120 
            </plantconcept_id>
121 
        </taxondetermination>
122 
        <verbatimcollectorname>J.A. Machuca N.</verbatimcollectorname>
127 123 
        <datasource_id><party><organizationname>XAL</organizationname></party></datasource_id>
128 124 
        <catalognumber_dwc>K400001</catalognumber_dwc>
129 125 
        <collectionnumber>7086</collectionnumber>
130 126 
        <institution_id><party><organizationname>IE</organizationname></party></institution_id>
131 127 
    </specimenreplicate>
132 128 
    <specimenreplicate id="1">
133 
        <taxonoccurrence_id>
134 
            <taxonoccurrence>
135 
                <locationevent_id>
136 
                    <locationevent>
137 
                        <location_id>
138 
                            <location>
139 
                                <locationdetermination>
140 
                                    <namedplace_id>
129 
        <locationevent_id>
130 
            <locationevent>
131 
                <location_id>
132 
                    <location>
133 
                        <locationdetermination>
134 
                            <namedplace_id>
135 
                                <namedplace>
136 
                                    <rank>county</rank>
137 
                                    <placename>SAN FELIPE USILA</placename>
138 
                                    <parent_id>
141 139 
                                        <namedplace>
142 
                                            <rank>county</rank>
143 
                                            <placename>SAN FELIPE USILA</placename>
140 
                                            <rank>stateProvince</rank>
141 
                                            <placename>Oaxaca</placename>
144 142 
                                            <parent_id>
145 143 
                                                <namedplace>
146 
                                                    <rank>stateProvince</rank>
147 
                                                    <placename>Oaxaca</placename>
144 
                                                    <rank>country</rank>
145 
                                                    <placename>MEXICO</placename>
148 146 
                                                    <parent_id>
149 147 
                                                        <namedplace>
150 
                                                            <rank>country</rank>
151 
                                                            <placename>MEXICO</placename>
152 
                                                            <parent_id>
153 
                                                                <namedplace>
154 
                                                                    <rank>continent</rank>
155 
                                                                    <placename>AMERICA</placename>
156 
                                                                </namedplace>
157 
                                                            </parent_id>
148 
                                                            <rank>continent</rank>
149 
                                                            <placename>AMERICA</placename>
158 150 
                                                        </namedplace>
159 151 
                                                    </parent_id>
160 152 
                                                </namedplace>
161 153 
                                            </parent_id>
162 154 
                                        </namedplace>
163 
                                    </namedplace_id>
164 
                                    <latitude>17.644</latitude>
165 
                                    <longitude>-96.529</longitude>
166 
                                </locationdetermination>
167 
                                <locationnarrative>8 km en l&#237;nea recta, 181&#186; al S de Santa Cruz Tepetotutla, Distrito Tuxtepec</locationnarrative>
168 
                                <elevation>2430.0</elevation>
169 
                                <elevationrange/>
170 
                                <centerlatitude>17.644</centerlatitude>
171 
                                <centerlongitude>-96.529</centerlongitude>
172 
                            </location>
173 
                        </location_id>
174 
                        <waterdepth>2430.0</waterdepth>
175 
                        <obsstartdate>1994-09-18</obsstartdate>
176 
                        <obsenddate/>
177 
                    </locationevent>
178 
                </locationevent_id>
179 
                <taxondetermination>
180 
                    <role>identifier</role>
181 
                    <determinationdate>1995-01-01</determinationdate>
182 
                    <isoriginal>true</isoriginal>
183 
                    <iscurrent>true</iscurrent>
184 
                    <plantconcept_id>
185 
                        <plantconcept>
186 
                            <plantname_id>
155 
                                    </parent_id>
156 
                                </namedplace>
157 
                            </namedplace_id>
158 
                            <latitude>17.644</latitude>
159 
                            <longitude>-96.529</longitude>
160 
                        </locationdetermination>
161 
                        <locationnarrative>8 km en l&#237;nea recta, 181&#186; al S de Santa Cruz Tepetotutla, Distrito Tuxtepec</locationnarrative>
162 
                        <elevation>2430.0</elevation>
163 
                        <elevationrange/>
164 
                        <centerlatitude>17.644</centerlatitude>
165 
                        <centerlongitude>-96.529</centerlongitude>
166 
                    </location>
167 
                </location_id>
168 
                <waterdepth>2430.0</waterdepth>
169 
                <obsstartdate>1994-09-18</obsstartdate>
170 
                <obsenddate/>
171 
            </locationevent>
172 
        </locationevent_id>
173 
        <collectioncode_dwc>XAL</collectioncode_dwc>
174 
        <definedvalue fkey="tablerecord_id">
175 
            <userdefined_id>
176 
                <userdefined>
177 
                    <tablename>specimenreplicate</tablename>
178 
                    <userdefinedname>sex</userdefinedname>
179 
                </userdefined>
180 
            </userdefined_id>
181 
            <definedvalue>ND</definedvalue>
182 
        </definedvalue>
183 
        <taxondetermination>
184 
            <role>identifier</role>
185 
            <determinationdate>1995-01-01</determinationdate>
186 
            <isoriginal>true</isoriginal>
187 
            <iscurrent>true</iscurrent>
188 
            <plantconcept_id>
189 
                <plantconcept>
190 
                    <plantname_id>
191 
                        <plantname>
192 
                            <rank>binomial</rank>
193 
                            <plantname>Peltapteris peltata (Sw.) C.V. Morton</plantname>
194 
                            <parent_id>
187 195 
                                <plantname>
188 
                                    <rank>binomial</rank>
189 
                                    <plantname>Peltapteris peltata (Sw.) C.V. Morton</plantname>
196 
                                    <rank>authority</rank>
197 
                                    <plantname>(Sw.) C.V. Morton</plantname>
190 198 
                                    <parent_id>
191 199 
                                        <plantname>
192 
                                            <rank>authority</rank>
193 
                                            <plantname>(Sw.) C.V. Morton</plantname>
200 
                                            <rank>species</rank>
201 
                                            <plantname>peltata</plantname>
194 202 
                                            <parent_id>
195 203 
                                                <plantname>
196 
                                                    <rank>species</rank>
197 
                                                    <plantname>peltata</plantname>
204 
                                                    <rank>genus</rank>
205 
                                                    <plantname>Peltapteris</plantname>
198 206 
                                                    <parent_id>
199 207 
                                                        <plantname>
200 
                                                            <rank>genus</rank>
201 
                                                            <plantname>Peltapteris</plantname>
208 
                                                            <rank>family</rank>
209 
                                                            <plantname>Lomariopsidaceae</plantname>
202 210 
                                                            <parent_id>
203 211 
                                                                <plantname>
204 
                                                                    <rank>family</rank>
205 
                                                                    <plantname>Lomariopsidaceae</plantname>
212 
                                                                    <rank>order</rank>
213 
                                                                    <plantname>Filicales</plantname>
206 214 
                                                                    <parent_id>
207 215 
                                                                        <plantname>
208 
                                                                            <rank>order</rank>
209 
                                                                            <plantname>Filicales</plantname>
216 
                                                                            <rank>class</rank>
217 
                                                                            <plantname>POLYPODIOPSIDA</plantname>
210 218 
                                                                            <parent_id>
211 219 
                                                                                <plantname>
212 
                                                                                    <rank>class</rank>
213 
                                                                                    <plantname>POLYPODIOPSIDA</plantname>
220 
                                                                                    <rank>subkingdom</rank>
221 
                                                                                    <plantname>PTERIDOPHYTA</plantname>
214 222 
                                                                                    <parent_id>
215 223 
                                                                                        <plantname>
216 
                                                                                            <rank>subkingdom</rank>
217 
                                                                                            <plantname>PTERIDOPHYTA</plantname>
218 
                                                                                            <parent_id>
219 
                                                                                                <plantname>
220 
                                                                                                    <rank>kingdom</rank>
221 
                                                                                                    <plantname>PLANTAE</plantname>
222 
                                                                                                </plantname>
223 
                                                                                            </parent_id>
224 
                                                                                            <rank>kingdom</rank>
225 
                                                                                            <plantname>PLANTAE</plantname>
224 226 
                                                                                        </plantname>
225 227 
                                                                                    </parent_id>
226 228 
                                                                                </plantname>
......
236 238 
                                        </plantname>
237 239 
                                    </parent_id>
238 240 
                                </plantname>
239 
                            </plantname_id>
240 
                        </plantconcept>
241 
                    </plantconcept_id>
242 
                </taxondetermination>
243 
                <verbatimcollectorname>C. Gallardo H. y  et al.</verbatimcollectorname>
244 
            </taxonoccurrence>
245 
        </taxonoccurrence_id>
246 
        <collectioncode_dwc>XAL</collectioncode_dwc>
247 
        <definedvalue fkey="tablerecord_id">
248 
            <userdefined_id>
249 
                <userdefined>
250 
                    <tablename>specimenreplicate</tablename>
251 
                    <userdefinedname>sex</userdefinedname>
252 
                </userdefined>
253 
            </userdefined_id>
254 
            <definedvalue>ND</definedvalue>
255 
        </definedvalue>
241 
                            </parent_id>
242 
                        </plantname>
243 
                    </plantname_id>
244 
                </plantconcept>
245 
            </plantconcept_id>
246 
        </taxondetermination>
247 
        <verbatimcollectorname>C. Gallardo H. y  et al.</verbatimcollectorname>
256 248 
        <datasource_id><party><organizationname>XAL</organizationname></party></datasource_id>
257 249 
        <catalognumber_dwc>K400002</catalognumber_dwc>
258 250 
        <collectionnumber>1216</collectionnumber>
inputs/XAL/maps/VegBIEN.specimens.csv
1 1 
"XAL[DwC,darwin:]:/content/record/",VegBIEN:/specimenreplicate,Comments,Order
2 
CoordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89
3 
County,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66
4 
StateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65
5 
Country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/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",Brad: Required; reject record if this field NULL,63
6 
ContinentOcean,"/*_id/taxonoccurrence/*_id/locationevent/*_id/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",Brad: OMIT,59
7 
Locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
8 
MinimumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71
9 
MaximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72
10 
Latitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81
11 
Longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82
12 
MaximumDepth,"/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75
13 
MinimumDepth,"/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,74
14 
DayCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44
15 
MonthCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,44
16 
YearCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,44
17 
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,120
18 
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,120
19 
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,120
20 
IdentifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
21 
ScientificName,"/*_id/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","Brad: Bob, Nick, please is this mapping OK?",134
22 
ScientificNameAuthor,"/*_id/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","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
23 
Subspecies,"/*_id/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",,150
24 
Species,"/*_id/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",,149
25 
Genus,"/*_id/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",,147
26 
Family,"/*_id/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",,146
27 
Order,"/*_id/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",,145
28 
Class,"/*_id/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",,144
29 
Phylum,"/*_id/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",,143
30 
Kingdom,"/*_id/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",,142
31 
Collector,/*_id/taxonoccurrence/verbatimcollectorname,,23
2 
CoordinatePrecision,/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89
3 
County,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66
4 
StateProvince,"/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",,65
5 
Country,"/*_id/locationevent/*_id/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",Brad: Required; reject record if this field NULL,63
6 
ContinentOcean,"/*_id/locationevent/*_id/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",Brad: OMIT,59
7 
Locality,/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
8 
MinimumElevation,"/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value}/_replace[""\bca\.?""=]/value",,71
9 
MaximumElevation,"/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value,elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1}",,72
10 
Latitude,"/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,81
11 
Longitude,"/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,82
12 
MaximumDepth,"/*_id/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value",,75
13 
MinimumDepth,"/*_id/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value",,74
14 
DayCollected,"/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44
15 
MonthCollected,"/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,44
16 
YearCollected,"/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,44
32 17 
CollectionCode,/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,12
33 18 
Sex,"/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",26
34 19 
Notes,/description/_merge/1,,
35 
CatalogNumber,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/catalognumber_dwc","Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
20 
DayIdentified,"/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,120
21 
MonthIdentified,"/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,120
22 
YearIdentified,"/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,120
23 
IdentifiedBy,"/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
24 
ScientificName,"/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","Brad: Bob, Nick, please is this mapping OK?",134
25 
ScientificNameAuthor,"/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","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
26 
Subspecies,"/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",,150
27 
Species,"/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",,149
28 
Genus,"/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",,147
29 
Family,"/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",,146
30 
Order,"/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",,145
31 
Class,"/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",,144
32 
Phylum,"/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",,143
33 
Kingdom,"/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",,142
34 
Collector,/verbatimcollectorname,,23
35 
CatalogNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/catalognumber_dwc,"Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
36 36 
CollectorNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1/_alt/1,,22
37 37 
FieldNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53
38 38 
InstitutionCode,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/institution_id/party/organizationname,,
inputs/NY/test/import.specimens.out.ref
1 
Inserted 35 new rows into database
1 
Inserted 33 new rows into database
inputs/NY/test/VegBIEN.specimens.xml.ref
1 1 
<?xml version="1.0" ?>
2 2 
<VegBIEN>
3 3 
    <specimenreplicate id="0">
4 
        <taxonoccurrence_id>
5 
            <taxonoccurrence>
6 
                <locationevent_id>
7 
                    <locationevent>
8 
                        <location_id>
9 
                            <location>
10 
                                <locationdetermination>
11 
                                    <namedplace_id>
4 
        <locationevent_id>
5 
            <locationevent>
6 
                <location_id>
7 
                    <location>
8 
                        <locationdetermination>
9 
                            <namedplace_id>
10 
                                <namedplace>
11 
                                    <rank>county</rank>
12 
                                    <placename>Man&#250;</placename>
13 
                                    <parent_id>
12 14 
                                        <namedplace>
13 
                                            <rank>county</rank>
14 
                                            <placename>Man&#250;</placename>
15 
                                            <rank>stateProvince</rank>
16 
                                            <placename>Madre de Dios</placename>
15 17 
                                            <parent_id>
16 18 
                                                <namedplace>
17 
                                                    <rank>stateProvince</rank>
18 
                                                    <placename>Madre de Dios</placename>
19 
                                                    <rank>country</rank>
20 
                                                    <placename>Peru</placename>
19 21 
                                                    <parent_id>
20 22 
                                                        <namedplace>
21 
                                                            <rank>country</rank>
22 
                                                            <placename>Peru</placename>
23 
                                                            <parent_id>
24 
                                                                <namedplace>
25 
                                                                    <rank>continent</rank>
26 
                                                                    <placename>South America</placename>
27 
                                                                </namedplace>
28 
                                                            </parent_id>
23 
                                                            <rank>continent</rank>
24 
                                                            <placename>South America</placename>
29 25 
                                                        </namedplace>
30 26 
                                                    </parent_id>
31 27 
                                                </namedplace>
32 28 
                                            </parent_id>
33 29 
                                        </namedplace>
34 
                                    </namedplace_id>
35 
                                    <latitude>-11.80</latitude>
36 
                                    <longitude>-71.40</longitude>
37 
                                </locationdetermination>
38 
                                <locationnarrative>Parque Nacional del Manu. R&#237;o Manu: Cocha Casha Station; habitat: Floodplain forest</locationnarrative>
39 
                                <elevation>350.0</elevation>
40 
                                <elevationrange>0.0</elevationrange>
41 
                                <centerlatitude>-11.80</centerlatitude>
42 
                                <centerlongitude>-71.40</centerlongitude>
43 
                            </location>
44 
                        </location_id>
45 
                        <obsstartdate>1984-08-20</obsstartdate>
46 
                        <obsenddate/>
47 
                    </locationevent>
48 
                </locationevent_id>
49 
                <taxondetermination>
50 
                    <isoriginal>true</isoriginal>
51 
                    <iscurrent>true</iscurrent>
52 
                    <role>identifier</role>
53 
                    <plantconcept_id>
54 
                        <plantconcept>
55 
                            <plantname_id>
30 
                                    </parent_id>
31 
                                </namedplace>
32 
                            </namedplace_id>
33 
                            <latitude>-11.80</latitude>
34 
                            <longitude>-71.40</longitude>
35 
                        </locationdetermination>
36 
                        <locationnarrative>Parque Nacional del Manu. R&#237;o Manu: Cocha Casha Station; habitat: Floodplain forest</locationnarrative>
37 
                        <elevation>350.0</elevation>
38 
                        <elevationrange>0.0</elevationrange>
39 
                        <centerlatitude>-11.80</centerlatitude>
40 
                        <centerlongitude>-71.40</centerlongitude>
41 
                    </location>
42 
                </location_id>
43 
                <obsstartdate>1984-08-20</obsstartdate>
44 
                <obsenddate/>
45 
            </locationevent>
46 
        </locationevent_id>
47 
        <collectioncode_dwc>Herbarium</collectioncode_dwc>
48 
        <description>plant fungus: with rough brown bark, almost no buttressing, 1 m diam; fallen fruit and leaves</description>
49 
        <taxondetermination>
50 
            <isoriginal>true</isoriginal>
51 
            <iscurrent>true</iscurrent>
52 
            <role>identifier</role>
53 
            <plantconcept_id>
54 
                <plantconcept>
55 
                    <plantname_id>
56 
                        <plantname>
57 
                            <rank>binomial</rank>
58 
                            <plantname>Cariniana estrellensis (Raddi) Kuntze</plantname>
59 
                            <parent_id>
56 60 
                                <plantname>
57 
                                    <rank>binomial</rank>
58 
                                    <plantname>Cariniana estrellensis (Raddi) Kuntze</plantname>
61 
                                    <rank>authority</rank>
62 
                                    <plantname>(Raddi) Kuntze</plantname>
59 63 
                                    <parent_id>
60 64 
                                        <plantname>
61 
                                            <rank>authority</rank>
62 
                                            <plantname>(Raddi) Kuntze</plantname>
65 
                                            <rank>species</rank>
66 
                                            <plantname>estrellensis</plantname>
63 67 
                                            <parent_id>
64 68 
                                                <plantname>
65 
                                                    <rank>species</rank>
66 
                                                    <plantname>estrellensis</plantname>
69 
                                                    <rank>genus</rank>
70 
                                                    <plantname>Cariniana</plantname>
67 71 
                                                    <parent_id>
68 72 
                                                        <plantname>
69 
                                                            <rank>genus</rank>
70 
                                                            <plantname>Cariniana</plantname>
73 
                                                            <rank>family</rank>
74 
                                                            <plantname>Lecythidaceae</plantname>
71 75 
                                                            <parent_id>
72 76 
                                                                <plantname>
73 
                                                                    <rank>family</rank>
74 
                                                                    <plantname>Lecythidaceae</plantname>
77 
                                                                    <rank>subkingdom</rank>
78 
                                                                    <plantname>Magnoliophyta (flowering plants)</plantname>
75 79 
                                                                    <parent_id>
76 80 
                                                                        <plantname>
77 
                                                                            <rank>subkingdom</rank>
78 
                                                                            <plantname>Magnoliophyta (flowering plants)</plantname>
79 
                                                                            <parent_id>
80 
                                                                                <plantname>
81 
                                                                                    <rank>kingdom</rank>
82 
                                                                                    <plantname>Plantae</plantname>
83 
                                                                                </plantname>
84 
                                                                            </parent_id>
81 
                                                                            <rank>kingdom</rank>
82 
                                                                            <plantname>Plantae</plantname>
85 83 
                                                                        </plantname>
86 84 
                                                                    </parent_id>
87 85 
                                                                </plantname>
......
93 91 
                                        </plantname>
94 92 
                                    </parent_id>
95 93 
                                </plantname>
96 
                            </plantname_id>
97 
                        </plantconcept>
98 
                    </plantconcept_id>
99 
                </taxondetermination>
100 
                <verbatimcollectorname>R. B. Foster</verbatimcollectorname>
101 
            </taxonoccurrence>
102 
        </taxonoccurrence_id>
103 
        <collectioncode_dwc>Herbarium</collectioncode_dwc>
104 
        <description>plant fungus: with rough brown bark, almost no buttressing, 1 m diam; fallen fruit and leaves</description>
94 
                            </parent_id>
95 
                        </plantname>
96 
                    </plantname_id>
97 
                </plantconcept>
98 
            </plantconcept_id>
99 
        </taxondetermination>
100 
        <verbatimcollectorname>R. B. Foster</verbatimcollectorname>
105 101 
        <datasource_id><party><organizationname>NY</organizationname></party></datasource_id>
106 102 
        <catalognumber_dwc>00682023</catalognumber_dwc>
107 
        <sourceaccessioncode>816590</sourceaccessioncode>
108 103 
        <collectionnumber>9877</collectionnumber>
109 104 
        <institution_id><party><organizationname>NY</organizationname></party></institution_id>
105 
        <sourceaccessioncode>816590</sourceaccessioncode>
110 106 
    </specimenreplicate>
111 107 
    <specimenreplicate id="1">
112 
        <taxonoccurrence_id>
113 
            <taxonoccurrence>
114 
                <locationevent_id>
115 
                    <locationevent>
116 
                        <location_id>
117 
                            <location>
118 
                                <locationdetermination>
119 
                                    <namedplace_id>
108 
        <locationevent_id>
109 
            <locationevent>
110 
                <location_id>
111 
                    <location>
112 
                        <locationdetermination>
113 
                            <namedplace_id>
114 
                                <namedplace>
115 
                                    <rank>stateProvince</rank>
116 
                                    <placename>Belize District</placename>
117 
                                    <parent_id>
120 118 
                                        <namedplace>
121 
                                            <rank>stateProvince</rank>
122 
                                            <placename>Belize District</placename>
119 
                                            <rank>country</rank>
120 
                                            <placename>Belize</placename>
123 121 
                                            <parent_id>
124 122 
                                                <namedplace>
125 
                                                    <rank>country</rank>
126 
                                                    <placename>Belize</placename>
127 
                                                    <parent_id>
128 
                                                        <namedplace>
129 
                                                            <rank>continent</rank>
130 
                                                            <placename>Central America</placename>
131 
                                                        </namedplace>
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff