Project

General

Profile

« Previous | Next » 

Revision 1440

Renamed inputs/UNC-NCSC to inputs/NCU-NCSC to match herbarium code

View differences:

inputs/UNC-NCSC/test/DwC.specimens.xml.ref
1
<?xml version="1.0" ?>
2
<DwC xmlns:dcterms="http://purl.org/dc/terms/">
3
    <list id="0">
4
        <institutionID>UNC-NCSC</institutionID>
5
        <CatalogNumber>NCU00090254</CatalogNumber>
6
        <CollectedDate>25-Jun-94</CollectedDate>
7
        <CollectionCode>NCU</CollectionCode>
8
        <Country>USA</Country>
9
        <County>Lancaster</County>
10
        <PreparationType>Specimen</PreparationType>
11
        <ScientificName>Sanguinaria canadensis</ScientificName>
12
        <StateProvince>Virginia</StateProvince>
13
        <establishmentMeans/>
14
        <occurrenceID>0</occurrenceID>
15
    </list>
16
    <list id="1">
17
        <institutionID>UNC-NCSC</institutionID>
18
        <CollectedDate>8-May-65</CollectedDate>
19
        <CollectionCode>WEWO</CollectionCode>
20
        <CoordinateUncertaintyInMeters>1000</CoordinateUncertaintyInMeters>
21
        <Country>USA</Country>
22
        <County>Moore</County>
23
        <Latitude>35.1611111</Latitude>
24
        <Longitude>-79.3486111</Longitude>
25
        <PreparationType>Specimen</PreparationType>
26
        <ScientificName>Senecio anonymus</ScientificName>
27
        <StateProvince>North Carolina</StateProvince>
28
        <establishmentMeans/>
29
        <occurrenceID>1</occurrenceID>
30
    </list>
31
</DwC>
inputs/UNC-NCSC/test/VegBIEN.specimens.xml.ref
1
<?xml version="1.0" ?>
2
<VegBIEN>
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>county</rank>
14
                                            <placename>Lancaster</placename>
15
                                            <parent_id>
16
                                                <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>
25
                                                </namedplace>
26
                                            </parent_id>
27
                                        </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
                    <role>identifier</role>
38
                    <isoriginal>true</isoriginal>
39
                    <iscurrent>true</iscurrent>
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
            </taxonoccurrence>
52
        </taxonoccurrence_id>
53
        <collectioncode_dwc>NCU</collectioncode_dwc>
54
        <datasource_id><party><organizationname>UNC-NCSC</organizationname></party></datasource_id>
55
        <catalognumber_dwc>NCU00090254</catalognumber_dwc>
56
        <sourceaccessioncode>0</sourceaccessioncode>
57
    </specimenreplicate>
58
    <specimenreplicate id="1">
59
        <taxonoccurrence_id>
60
            <taxonoccurrence>
61
                <locationevent_id>
62
                    <locationevent>
63
                        <location_id>
64
                            <location>
65
                                <locationdetermination>
66
                                    <coordsaccuracy>1000</coordsaccuracy>
67
                                    <namedplace_id>
68
                                        <namedplace>
69
                                            <rank>county</rank>
70
                                            <placename>Moore</placename>
71
                                            <parent_id>
72
                                                <namedplace>
73
                                                    <rank>stateProvince</rank>
74
                                                    <placename>North Carolina</placename>
75
                                                    <parent_id>
76
                                                        <namedplace>
77
                                                            <rank>country</rank>
78
                                                            <placename>USA</placename>
79
                                                        </namedplace>
80
                                                    </parent_id>
81
                                                </namedplace>
82
                                            </parent_id>
83
                                        </namedplace>
84
                                    </namedplace_id>
85
                                    <latitude>35.1611111</latitude>
86
                                    <longitude>-79.3486111</longitude>
87
                                </locationdetermination>
88
                                <centerlatitude>35.1611111</centerlatitude>
89
                                <centerlongitude>-79.3486111</centerlongitude>
90
                            </location>
91
                        </location_id>
92
                        <obsstartdate>1965-05-08</obsstartdate>
93
                        <obsenddate/>
94
                    </locationevent>
95
                </locationevent_id>
96
                <taxondetermination>
97
                    <role>identifier</role>
98
                    <isoriginal>true</isoriginal>
99
                    <iscurrent>true</iscurrent>
100
                    <plantconcept_id>
101
                        <plantconcept>
102
                            <plantname_id>
103
                                <plantname>
104
                                    <rank>binomial</rank>
105
                                    <plantname>Senecio anonymus</plantname>
106
                                </plantname>
107
                            </plantname_id>
108
                        </plantconcept>
109
                    </plantconcept_id>
110
                </taxondetermination>
111
            </taxonoccurrence>
112
        </taxonoccurrence_id>
113
        <collectioncode_dwc>WEWO</collectioncode_dwc>
114
        <datasource_id><party><organizationname>UNC-NCSC</organizationname></party></datasource_id>
115
        <sourceaccessioncode>1</sourceaccessioncode>
116
    </specimenreplicate>
117
</VegBIEN>
inputs/UNC-NCSC/test/import.specimens.out.ref
1
Inserted 22 new rows into database
inputs/UNC-NCSC/maps/VegBIEN.specimens.csv
1
UNC-NCSC[DwC],VegBIEN:/specimenreplicate,Comments,Order
2
Accuracy,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88
3
CoordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88
4
coordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88
5
CoordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89
6
coordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89
7
BoundingBox,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
8
FootprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
9
footprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
10
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
11
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
12
State,"/*_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
13
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
14
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
15
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
16
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
17
Locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
18
locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
19
VerbatimLocality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
20
verbatimLocality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
21
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
22
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
23
MinimumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}",,71
24
MinimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}",,71
25
minimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}",,71
26
MaximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72
27
MaximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72
28
maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72
29
DecimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
30
decimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
31
Latitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
32
VerbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
33
verbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
34
Lat (-=S),"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",,81
35
DecimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
36
decimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
37
Longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
38
VerbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
39
verbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
40
Long (-=W),"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",,82
41
MaximumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
42
MaximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
43
maximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
44
MinimumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
45
MinimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
46
minimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
47
EventDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value",,44
48
eventDate/_alt,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt",Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,44
49
DayCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44
50
MonthCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,44
51
YearCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,44
52
eventDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/2",,44
53
Collect Date,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/3",,44
54
CollectedDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/3",,44
55
DateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value,,120
56
dateIdentified/_alt,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom dateIdentified mappings that don't pass through the default dateIdentified mapping,120
57
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,120
58
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,120
59
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,120
60
dateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,120
61
IdentifiedDate,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/3,,120
62
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
63
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
64
Full Taxon Name,"/*_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
65
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
66
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
67
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
68
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
69
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
70
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
71
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
72
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
73
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
74
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
75
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
76
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
77
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
78
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
79
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
80
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
81
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
82
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
83
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
84
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
85
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
86
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
87
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
88
Collector,/*_id/taxonoccurrence/verbatimcollectorname,,23
89
RecordedBy,/*_id/taxonoccurrence/verbatimcollectorname,,23
90
recordedBy,/*_id/taxonoccurrence/verbatimcollectorname,,23
91
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
92
SeriesName,/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
93
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
94
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
95
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
96
FieldNotes,/description/_merge/1,,
97
Notes,/description/_merge/1,,
98
fieldNotes,/description/_merge/1,,
99
Remarks,/description/_merge/2,,158
100
TaxonRemarks,/description/_merge/2,,158
101
taxonRemarks,/description/_merge/2,,158
102
Barcode,":[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
103
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
104
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
105
Accession Number,":[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
106
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
107
OccurrenceID,":[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
108
occurrenceID,":[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
109
CollectorNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
110
RecordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
111
recordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
112
CollectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9
113
collectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9
114
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
115
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
116
InstitutionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,,8
117
institutionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,,8
118
AcceptedNameUsage,,,135
119
AcceptedNameUsageID,,,128
120
Alt E/W,,
121
Alt N/S,,
122
AssociatedMedia,,,36
123
AssociatedOccurrences,,,38
124
AssociatedReferences,,,37
125
AssociatedSequences,,,39
126
AssociatedTaxa,,,40
127
BasisOfRecord,,Brad: OMIT? See http://rs.tdwg.org/dwc/terms/index.htm#basisOfRecord for definition of this term.,15
128
Bed,,,117
129
Behavior,,,29
130
Continent,,Brad: OMIT,59
131
ContinentOcean,,Brad: OMIT,59
132
CountryCode,,,64
133
Cultivated?,,,30
134
DataGeneralizations,,,17
135
DatasetID,,,10
136
DatasetName,,,13
137
DateLastModified,,"Brad: Mapping to VegX is incorrect. I think is this merely an internal timestamp indicated when record last modified, not necessarily when determination (taxon name) last modified. Probably we should omit this field, although might be useful for updating changed records from this source.",1
138
Day,,Brad: OMIT,50
139
Dcterms:accessRights,,,5
140
Dcterms:bibliographicCitation,,,6
141
Dcterms:language,,,2
142
Dcterms:modified,,"Brad: Mapping to VegX is incorrect. I think is this merely an internal timestamp indicated when record last modified, not necessarily when determination (taxon name) last modified. Probably we should omit this field, although might be useful for updating changed records from this source.",1
143
Dcterms:references,,,7
144
Dcterms:rights,,,3
145
Dcterms:rightsHolder,,,4
146
Dcterms:type,,,0
147
Disposition,,,33
148
DynamicProperties,,,18
149
EarliestAgeOrLowestStage,,,109
150
EarliestEonOrLowestEonothem,,,101
151
EarliestEpochOrLowestSeries,,,107
152
EarliestEraOrLowestErathem,,,103
153
EarliestPeriodOrLowestSystem,,,105
154
Elevation,,,70
155
EndDayOfYear,,,47
156
EstablishmentMeans,,,30
157
EventID,,,41
158
EventRemarks,,,55
159
EventTime,,Brad: OMIT,45
160
FIPS,,FIPS county code
161
FootprintSRS,,,92
162
FootprintSpatialFit,,,93
163
Format,,Brad: OMIT,32
164
Formation,,,115
165
GeodeticDatum,,,87
166
GeologicalContextID,,,100
167
GeoreferenceProtocol,,,96
168
GeoreferenceRemarks,,,99
169
GeoreferenceSources,,,97
170
GeoreferenceVerificationStatus,,,98
171
GeoreferencedBy,,Brad: Correct for VB. Nick: is there a way to specifically identify this party as collector of a specimen?,94
172
GeoreferencedDate,,,95
173
Group,,,114
174
HigherClassification,,,141
175
HigherGeography,,,58
176
HigherGeographyID,,,57
177
HighestBiostratigraphicZone,,,112
178
IdentificationID,,,118
179
IdentificationQualifier,,,124
180
IdentificationReferences,,,121
181
IdentificationRemarks,,,123
182
IdentificationVerificationStatus,,,122
183
IndividualCount,,Brad: OMIT; not relevant for DwC plant specimen data.,25
184
IndividualID,,"Brad: OMIT; db-specific element, not relevant to VB/VX",24
185
InformationWithheld,,,16
186
InstitutionCode,,,
187
Island,,,62
188
IslandGroup,,,61
189
JulianDay,,Brad: OMIT,50
190
LatestAgeOrHighestStage,,,110
191
LatestEonOrHighestEonothem,,,102
192
LatestEpochOrHighestSeries,,,108
193
LatestEraOrHighestErathem,,,104
194
LatestPeriodOrHighestSystem,,,106
195
LifeStage,,,27
196
LithostratigraphicTerms,,,113
197
LocationAccordingTo,,,78
198
LocationID,,,56
199
LocationRemarks,,,79
200
LowestBiostratigraphicZone,,,111
201
MaximumDistanceAboveSurfaceInMeters,,,77
202
MeasurementAccuracy,,,169
203
MeasurementDeterminedBy,,,172
204
MeasurementDeterminedDate,,,171
205
MeasurementID,,,166
206
MeasurementMethod,,,173
207
MeasurementRemarks,,,174
208
MeasurementType,,,167
209
MeasurementUnit,,,170
210
MeasurementValue,,,168
211
Member,,,116
212
MinimumDistanceAboveSurfaceInMeters,,,76
213
Month,,,49
214
Municipality,,,67
215
NameAccordingTo,,,138
216
NameAccordingToID,,,131
217
NamePublishedIn,,,139
218
NamePublishedInID,,,132
219
NamePublishedInYear,,,140
220
NomenclaturalCode,,,155
221
NomenclaturalStatus,,,157
222
OccurrenceRemarks,,,21
223
OccurrenceStatus,,,31
224
OriginalNameUsage,,,137
225
OriginalNameUsageID,,,130
226
OtherCatalogNumbers,,,34
227
OwnerInstitutionCode,,,14
228
ParentNameUsage,,,136
229
ParentNameUsageID,,,129
230
PointRadiusSpatialFit,,,90
231
PreparationType,,Brad: OMIT,32
232
Preparations,,Brad: OMIT,32
233
PreviousCatalogNumber,,?; Brad: OMIT,35
234
PreviousIdentifications,,Brad: OMIT,35
235
RelatedCatalogItem,,Brad: OMIT,161
236
RelatedResourceID,,Brad: OMIT,161
237
RelationshipAccordingTo,,,163
238
RelationshipEstablishedDate,,,164
239
RelationshipOfResource,,Brad: OMIT,162
240
RelationshipRemarks,,,165
241
RelationshipType,,Brad: OMIT,162
242
ReproductiveCondition,,,28
243
ResourceID,,,160
244
ResourceRelationshipID,,,159
245
SamplingEffort,,,43
246
SamplingProtocol,,,42
247
ScientificNameID,,,127
248
StartDayOfYear,,,46
249
Subgenus,,,148
250
TaxonConceptID,,,133
251
TaxonID,,,126
252
TaxonRank,,,151
253
TaxonomicStatus,,,156
254
TimeOfDay,,Brad: OMIT,45
255
TypeStatus,,Brad: OMIT (?). Indicates whether this specimen served as type for taxon name. Probably not relevant for BIEN,125
256
Typology,,
257
VerbatimCoordinateSystem,,,83
258
VerbatimCoordinates,,,80
259
VerbatimDepth,,,73
260
VerbatimElevation,,,70
261
VerbatimEventDate,,,51
262
VerbatimSRS,,,84
263
VerbatimTaxonRank,,,152
264
VernacularName,,,154
265
WaterBody,,,60
266
Year,,,48
267
acceptedNameUsage,,,135
268
acceptedNameUsageID,,,128
269
associatedMedia,,,36
270
associatedOccurrences,,,38
271
associatedReferences,,,37
272
associatedSequences,,,39
273
associatedTaxa,,,40
274
basisOfRecord,,Brad: OMIT? See http://rs.tdwg.org/dwc/terms/index.htm#basisOfRecord for definition of this term.,15
275
bed,,,117
276
behavior,,,29
277
continent,,Brad: OMIT,59
278
countryCode,,,64
279
dataGeneralizations,,,17
280
datasetID,,,10
281
datasetName,,,13
282
day,,Brad: OMIT,50
283
dcterms:accessRights,,,5
284
dcterms:bibliographicCitation,,,6
285
dcterms:language,,,2
286
dcterms:modified,,"Brad: Mapping to VegX is incorrect. I think is this merely an internal timestamp indicated when record last modified, not necessarily when determination (taxon name) last modified. Probably we should omit this field, although might be useful for updating changed records from this source.",1
287
dcterms:references,,,7
288
dcterms:rights,,,3
289
dcterms:rightsHolder,,,4
290
dcterms:type,,,0
291
disposition,,,33
292
dynamicProperties,,,18
293
earliestAgeOrLowestStage,,,109
294
earliestEonOrLowestEonothem,,,101
295
earliestEpochOrLowestSeries,,,107
296
earliestEraOrLowestErathem,,,103
297
earliestPeriodOrLowestSystem,,,105
298
endDayOfYear,,,47
299
establishmentMeans,,,30
300
eventID,,,41
301
eventRemarks,,,55
302
eventTime,,Brad: OMIT,45
303
footprintSRS,,,92
304
footprintSpatialFit,,,93
305
formation,,,115
306
geodeticDatum,,,87
307
geologicalContextID,,,100
308
georeferenceProtocol,,,96
309
georeferenceRemarks,,,99
310
georeferenceSources,,,97
311
georeferenceVerificationStatus,,,98
312
georeferencedBy,,Brad: Correct for VB. Nick: is there a way to specifically identify this party as collector of a specimen?,94
313
georeferencedDate,,,95
314
group,,,114
315
higherClassification,,,141
316
higherGeography,,,58
317
higherGeographyID,,,57
318
highestBiostratigraphicZone,,,112
319
identificationID,,,118
320
identificationQualifier,,,124
321
identificationReferences,,,121
322
identificationRemarks,,,123
323
identificationVerificationStatus,,,122
324
individualCount,,Brad: OMIT; not relevant for DwC plant specimen data.,25
325
individualID,,"Brad: OMIT; db-specific element, not relevant to VB/VX",24
326
informationWithheld,,,16
327
institutionCode,,,
328
island,,,62
329
islandGroup,,,61
330
latestAgeOrHighestStage,,,110
331
latestEonOrHighestEonothem,,,102
332
latestEpochOrHighestSeries,,,108
333
latestEraOrHighestErathem,,,104
334
latestPeriodOrHighestSystem,,,106
335
lifeStage,,,27
336
lithostratigraphicTerms,,,113
337
locationAccordingTo,,,78
338
locationID,,,56
339
locationRemarks,,,79
340
lowestBiostratigraphicZone,,,111
341
maximumDistanceAboveSurfaceInMeters,,,77
342
measurementAccuracy,,,169
343
measurementDeterminedBy,,,172
344
measurementDeterminedDate,,,171
345
measurementID,,,166
346
measurementMethod,,,173
347
measurementRemarks,,,174
348
measurementType,,,167
349
measurementUnit,,,170
350
measurementValue,,,168
351
member,,,116
352
minimumDistanceAboveSurfaceInMeters,,,76
353
month,,,49
354
municipality,,,67
355
nameAccordingTo,,,138
356
nameAccordingToID,,,131
357
namePublishedIn,,,139
358
namePublishedInID,,,132
359
namePublishedInYear,,,140
360
nomenclaturalCode,,,155
361
nomenclaturalStatus,,,157
362
occurrenceRemarks,,,21
363
occurrenceStatus,,,31
364
originalNameUsage,,,137
365
originalNameUsageID,,,130
366
otherCatalogNumbers,,,34
367
ownerInstitutionCode,,,14
368
parentNameUsage,,,136
369
parentNameUsageID,,,129
370
pointRadiusSpatialFit,,,90
371
preparations,,Brad: OMIT,32
372
previousIdentifications,,Brad: OMIT,35
373
relatedResourceID,,Brad: OMIT,161
374
relationshipAccordingTo,,,163
375
relationshipEstablishedDate,,,164
376
relationshipOfResource,,Brad: OMIT,162
377
relationshipRemarks,,,165
378
reproductiveCondition,,,28
379
resourceID,,,160
380
resourceRelationshipID,,,159
381
samplingEffort,,,43
382
samplingProtocol,,,42
383
scientificNameID,,,127
384
startDayOfYear,,,46
385
subgenus,,,148
386
taxonConceptID,,,133
387
taxonID,,,126
388
taxonRank,,,151
389
taxonomicStatus,,,156
390
typeStatus,,Brad: OMIT (?). Indicates whether this specimen served as type for taxon name. Probably not relevant for BIEN,125
391
verbatimCoordinateSystem,,,83
392
verbatimCoordinates,,,80
393
verbatimDepth,,,73
394
verbatimElevation,,,70
395
verbatimEventDate,,,51
396
verbatimSRS,,,84
397
verbatimTaxonRank,,,152
398
vernacularName,,,154
399
waterBody,,,60
400
year,,,48
inputs/UNC-NCSC/maps/src.join.specimens.csv
1
UNC-NCSC[DwC],VegBIEN:/specimenreplicate,Comments,Order
2
Accuracy,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88
3
CoordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88
4
coordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88
5
CoordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89
6
coordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89
7
BoundingBox,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
8
FootprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
9
footprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
10
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
11
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
12
State,"/*_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
13
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
14
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
15
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
16
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
17
Locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
18
locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
19
VerbatimLocality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
20
verbatimLocality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
21
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
22
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
23
MinimumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}",,71
24
MinimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}",,71
25
minimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}",,71
26
MaximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72
27
MaximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72
28
maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72
29
DecimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
30
decimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
31
Latitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
32
VerbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
33
verbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
34
Lat (-=S),"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",,81
35
DecimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
36
decimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
37
Longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
38
VerbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
39
verbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
40
Long (-=W),"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",,82
41
MaximumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
42
MaximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
43
maximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
44
MinimumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
45
MinimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
46
minimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
47
EventDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value",,44
48
eventDate/_alt,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt",Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,44
49
DayCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44
50
MonthCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,44
51
YearCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,44
52
eventDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/2",,44
53
Collect Date,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/3",,44
54
CollectedDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/3",,44
55
DateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value,,120
56
dateIdentified/_alt,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom dateIdentified mappings that don't pass through the default dateIdentified mapping,120
57
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,120
58
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,120
59
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,120
60
dateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,120
61
IdentifiedDate,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/3,,120
62
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
63
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
64
Full Taxon Name,"/*_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
65
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
66
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
67
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
68
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
69
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
70
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
71
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
72
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
73
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
74
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
75
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
76
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
77
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
78
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
79
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
80
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
81
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
82
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
83
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
84
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
85
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
86
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
87
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
88
Collector,/*_id/taxonoccurrence/verbatimcollectorname,,23
89
RecordedBy,/*_id/taxonoccurrence/verbatimcollectorname,,23
90
recordedBy,/*_id/taxonoccurrence/verbatimcollectorname,,23
91
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
92
SeriesName,/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
93
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
94
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
95
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
96
FieldNotes,/description/_merge/1,,
97
Notes,/description/_merge/1,,
98
fieldNotes,/description/_merge/1,,
99
Remarks,/description/_merge/2,,158
100
TaxonRemarks,/description/_merge/2,,158
101
taxonRemarks,/description/_merge/2,,158
102
Barcode,":[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
103
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
104
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
105
Accession Number,":[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
106
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
107
OccurrenceID,":[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
108
occurrenceID,":[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
109
CollectorNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
110
RecordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
111
recordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
112
CollectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9
113
collectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9
114
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
115
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
116
InstitutionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,,8
117
institutionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,,8
118
Alt E/W,,
119
Alt N/S,,
120
Cultivated?,,** No join mapping for establishmentMeans/_if:[then=cultivated]/cond/_eq:[right=Yes]/left ** 
121
Elevation,,** No join mapping for VerbatimElevation ** 
122
FIPS,,FIPS county code
123
Format,,** No join mapping for PreparationType ** 
124
Typology,,
inputs/UNC-NCSC/maps/src.specimens.csv
1
"UNC-NCSC[DwC]"
2
"Accession Number"
3
"SeriesName"
4
"Barcode"
5
"Full Taxon Name"
6
"Collect Date"
7
"Country"
8
"State"
9
"County"
10
"Cultivated?"
11
"Elevation"
12
"Lat (-=S)"
13
"Long (-=W)"
14
"Accuracy"
15
"FIPS"
16
"Alt N/S"
17
"Alt E/W"
18
"Format"
19
"Typology"
inputs/UNC-NCSC/maps/DwC.specimens.csv
1
"UNC-NCSC[DwC]","DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[institutionID=$/_ignore/inLabel]/","Comments"
2
"Accession Number","occurrenceID",
3
"SeriesName","CollectionCode",
4
"Barcode","CatalogNumber",
5
"Full Taxon Name","ScientificName",
6
"Collect Date","CollectedDate",
7
"State","StateProvince",
8
"Cultivated?","establishmentMeans/_if:[then=cultivated]/cond/_eq:[right=Yes]/left",
9
"Elevation","VerbatimElevation",
10
"Lat (-=S)","Latitude/_replace:[""\?$""=]/value",
11
"Long (-=W)","Longitude/_replace:[""\?$""=]/value",
12
"Accuracy","CoordinateUncertaintyInMeters",
13
"FIPS",,"FIPS county code"
14
"Alt N/S",,
15
"Alt E/W",,
16
"Format","PreparationType",
17
"Typology",,
inputs/UNC-NCSC/maps/DwC.specimens.full.csv
1
UNC-NCSC[DwC],"DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[institutionID=$/_ignore/inLabel]/",Comments
2
AcceptedNameUsage,AcceptedNameUsage
3
AcceptedNameUsageID,AcceptedNameUsageID
4
AssociatedMedia,AssociatedMedia
5
AssociatedOccurrences,AssociatedOccurrences
6
AssociatedReferences,AssociatedReferences
7
AssociatedSequences,AssociatedSequences
8
AssociatedTaxa,AssociatedTaxa
9
BasisOfRecord,BasisOfRecord
10
Bed,Bed
11
Behavior,Behavior
12
BoundingBox,BoundingBox
13
Barcode,CatalogNumber,
14
CatalogNumber,CatalogNumber
15
Class,Class
16
Collect Date,CollectedDate,
17
CollectedDate,CollectedDate
18
CollectionCode,CollectionCode
19
SeriesName,CollectionCode,
20
CollectionID,CollectionID
21
Collector,Collector
22
CollectorNumber,CollectorNumber
23
Continent,Continent
24
ContinentOcean,ContinentOcean
25
CoordinatePrecision,CoordinatePrecision
26
Accuracy,CoordinateUncertaintyInMeters,
27
CoordinateUncertaintyInMeters,CoordinateUncertaintyInMeters
28
Country,Country
29
CountryCode,CountryCode
30
County,County
31
DataGeneralizations,DataGeneralizations
32
DatasetID,DatasetID
33
DatasetName,DatasetName
34
DateIdentified,DateIdentified
35
DateLastModified,DateLastModified
36
Day,Day
37
DayCollected,DayCollected
38
DayIdentified,DayIdentified
39
Dcterms:accessRights,Dcterms:accessRights
40
Dcterms:bibliographicCitation,Dcterms:bibliographicCitation
41
Dcterms:language,Dcterms:language
42
Dcterms:modified,Dcterms:modified
43
Dcterms:references,Dcterms:references
44
Dcterms:rights,Dcterms:rights
45
Dcterms:rightsHolder,Dcterms:rightsHolder
46
Dcterms:type,Dcterms:type
47
DecimalLatitude,DecimalLatitude
48
DecimalLongitude,DecimalLongitude
49
Disposition,Disposition
50
DynamicProperties,DynamicProperties
51
EarliestAgeOrLowestStage,EarliestAgeOrLowestStage
52
EarliestEonOrLowestEonothem,EarliestEonOrLowestEonothem
53
EarliestEpochOrLowestSeries,EarliestEpochOrLowestSeries
54
EarliestEraOrLowestErathem,EarliestEraOrLowestErathem
55
EarliestPeriodOrLowestSystem,EarliestPeriodOrLowestSystem
56
EndDayOfYear,EndDayOfYear
57
EstablishmentMeans,EstablishmentMeans
58
EventDate,EventDate
59
EventID,EventID
60
EventRemarks,EventRemarks
61
EventTime,EventTime
62
Family,Family
63
FieldNotes,FieldNotes
64
FieldNumber,FieldNumber
65
FootprintSRS,FootprintSRS
66
FootprintSpatialFit,FootprintSpatialFit
67
FootprintWKT,FootprintWKT
68
Formation,Formation
69
Genus,Genus
70
GeodeticDatum,GeodeticDatum
71
GeologicalContextID,GeologicalContextID
72
GeoreferenceProtocol,GeoreferenceProtocol
73
GeoreferenceRemarks,GeoreferenceRemarks
74
GeoreferenceSources,GeoreferenceSources
75
GeoreferenceVerificationStatus,GeoreferenceVerificationStatus
76
GeoreferencedBy,GeoreferencedBy
77
GeoreferencedDate,GeoreferencedDate
78
GlobalUniqueIdentifier,GlobalUniqueIdentifier
79
Group,Group
80
Habitat,Habitat
81
HigherClassification,HigherClassification
82
HigherGeography,HigherGeography
83
HigherGeographyID,HigherGeographyID
84
HighestBiostratigraphicZone,HighestBiostratigraphicZone
85
IdentificationID,IdentificationID
86
IdentificationQualifier,IdentificationQualifier
87
IdentificationReferences,IdentificationReferences
88
IdentificationRemarks,IdentificationRemarks
89
IdentificationVerificationStatus,IdentificationVerificationStatus
90
IdentifiedBy,IdentifiedBy
91
IdentifiedDate,IdentifiedDate
92
IndividualCount,IndividualCount
93
IndividualID,IndividualID
94
InformationWithheld,InformationWithheld
95
InfraspecificEpithet,InfraspecificEpithet
96
InstitutionCode,InstitutionCode
97
InstitutionID,InstitutionID
98
Island,Island
99
IslandGroup,IslandGroup
100
JulianDay,JulianDay
101
Kingdom,Kingdom
102
LatestAgeOrHighestStage,LatestAgeOrHighestStage
103
LatestEonOrHighestEonothem,LatestEonOrHighestEonothem
104
LatestEpochOrHighestSeries,LatestEpochOrHighestSeries
105
LatestEraOrHighestErathem,LatestEraOrHighestErathem
106
LatestPeriodOrHighestSystem,LatestPeriodOrHighestSystem
107
Latitude,Latitude
108
Lat (-=S),"Latitude/_replace:[""\?$""=]/value",
109
LifeStage,LifeStage
110
LithostratigraphicTerms,LithostratigraphicTerms
111
Locality,Locality
112
LocationAccordingTo,LocationAccordingTo
113
LocationID,LocationID
114
LocationRemarks,LocationRemarks
115
Longitude,Longitude
116
Long (-=W),"Longitude/_replace:[""\?$""=]/value",
117
LowestBiostratigraphicZone,LowestBiostratigraphicZone
118
MaximumDepth,MaximumDepth
119
MaximumDepthInMeters,MaximumDepthInMeters
120
MaximumDistanceAboveSurfaceInMeters,MaximumDistanceAboveSurfaceInMeters
121
MaximumElevation,MaximumElevation
122
MaximumElevationInMeters,MaximumElevationInMeters
123
MeasurementAccuracy,MeasurementAccuracy
124
MeasurementDeterminedBy,MeasurementDeterminedBy
125
MeasurementDeterminedDate,MeasurementDeterminedDate
126
MeasurementID,MeasurementID
127
MeasurementMethod,MeasurementMethod
128
MeasurementRemarks,MeasurementRemarks
129
MeasurementType,MeasurementType
130
MeasurementUnit,MeasurementUnit
131
MeasurementValue,MeasurementValue
132
Member,Member
133
MinimumDepth,MinimumDepth
134
MinimumDepthInMeters,MinimumDepthInMeters
135
MinimumDistanceAboveSurfaceInMeters,MinimumDistanceAboveSurfaceInMeters
136
MinimumElevation,MinimumElevation
137
MinimumElevationInMeters,MinimumElevationInMeters
138
Month,Month
139
MonthCollected,MonthCollected
140
MonthIdentified,MonthIdentified
141
Municipality,Municipality
142
NameAccordingTo,NameAccordingTo
143
NameAccordingToID,NameAccordingToID
144
NamePublishedIn,NamePublishedIn
145
NamePublishedInID,NamePublishedInID
146
NamePublishedInYear,NamePublishedInYear
147
NomenclaturalCode,NomenclaturalCode
148
NomenclaturalStatus,NomenclaturalStatus
149
Notes,Notes
150
OccurrenceID,OccurrenceID
151
OccurrenceRemarks,OccurrenceRemarks
152
OccurrenceStatus,OccurrenceStatus
153
Order,Order
154
OriginalNameUsage,OriginalNameUsage
155
OriginalNameUsageID,OriginalNameUsageID
156
OtherCatalogNumbers,OtherCatalogNumbers
157
OwnerInstitutionCode,OwnerInstitutionCode
158
ParentNameUsage,ParentNameUsage
159
ParentNameUsageID,ParentNameUsageID
160
Phylum,Phylum
161
PointRadiusSpatialFit,PointRadiusSpatialFit
162
Format,PreparationType,
163
PreparationType,PreparationType
164
Preparations,Preparations
165
PreviousCatalogNumber,PreviousCatalogNumber
166
PreviousIdentifications,PreviousIdentifications
167
RecordNumber,RecordNumber
168
RecordedBy,RecordedBy
169
RelatedCatalogItem,RelatedCatalogItem
170
RelatedResourceID,RelatedResourceID
171
RelationshipAccordingTo,RelationshipAccordingTo
172
RelationshipEstablishedDate,RelationshipEstablishedDate
173
RelationshipOfResource,RelationshipOfResource
174
RelationshipRemarks,RelationshipRemarks
175
RelationshipType,RelationshipType
176
Remarks,Remarks
177
ReproductiveCondition,ReproductiveCondition
178
ResourceID,ResourceID
179
ResourceRelationshipID,ResourceRelationshipID
180
SamplingEffort,SamplingEffort
181
SamplingProtocol,SamplingProtocol
182
Full Taxon Name,ScientificName,
183
ScientificName,ScientificName
184
ScientificNameAuthor,ScientificNameAuthor
185
ScientificNameAuthorship,ScientificNameAuthorship
186
ScientificNameID,ScientificNameID
187
Sex,Sex
188
Species,Species
189
SpecificEpithet,SpecificEpithet
190
StartDayOfYear,StartDayOfYear
191
State,StateProvince,
192
StateProvince,StateProvince
193
Subgenus,Subgenus
194
Subspecies,Subspecies
195
TaxonConceptID,TaxonConceptID
196
TaxonID,TaxonID
197
TaxonRank,TaxonRank
198
TaxonRemarks,TaxonRemarks
199
TaxonomicStatus,TaxonomicStatus
200
TimeOfDay,TimeOfDay
201
TypeStatus,TypeStatus
202
VerbatimCoordinateSystem,VerbatimCoordinateSystem
203
VerbatimCoordinates,VerbatimCoordinates
204
VerbatimDepth,VerbatimDepth
205
Elevation,VerbatimElevation,
206
VerbatimElevation,VerbatimElevation
207
VerbatimEventDate,VerbatimEventDate
208
VerbatimLatitude,VerbatimLatitude
209
VerbatimLocality,VerbatimLocality
210
VerbatimLongitude,VerbatimLongitude
211
VerbatimSRS,VerbatimSRS
212
VerbatimTaxonRank,VerbatimTaxonRank
213
VernacularName,VernacularName
214
WaterBody,WaterBody
215
Year,Year
216
YearCollected,YearCollected
217
YearIdentified,YearIdentified
218
acceptedNameUsage,acceptedNameUsage
219
acceptedNameUsageID,acceptedNameUsageID
220
associatedMedia,associatedMedia
221
associatedOccurrences,associatedOccurrences
222
associatedReferences,associatedReferences
223
associatedSequences,associatedSequences
224
associatedTaxa,associatedTaxa
225
basisOfRecord,basisOfRecord
226
bed,bed
227
behavior,behavior
228
catalogNumber,catalogNumber
229
class,class
230
collectionCode,collectionCode
231
collectionID,collectionID
232
continent,continent
233
coordinatePrecision,coordinatePrecision
234
coordinateUncertaintyInMeters,coordinateUncertaintyInMeters
235
country,country
236
countryCode,countryCode
237
county,county
238
dataGeneralizations,dataGeneralizations
239
datasetID,datasetID
240
datasetName,datasetName
241
dateIdentified,dateIdentified
242
dateIdentified/_alt,dateIdentified/_alt
243
day,day
244
dcterms:accessRights,dcterms:accessRights
245
dcterms:bibliographicCitation,dcterms:bibliographicCitation
246
dcterms:language,dcterms:language
247
dcterms:modified,dcterms:modified
248
dcterms:references,dcterms:references
249
dcterms:rights,dcterms:rights
250
dcterms:rightsHolder,dcterms:rightsHolder
251
dcterms:type,dcterms:type
252
decimalLatitude,decimalLatitude
253
decimalLongitude,decimalLongitude
254
disposition,disposition
255
dynamicProperties,dynamicProperties
256
earliestAgeOrLowestStage,earliestAgeOrLowestStage
257
earliestEonOrLowestEonothem,earliestEonOrLowestEonothem
258
earliestEpochOrLowestSeries,earliestEpochOrLowestSeries
259
earliestEraOrLowestErathem,earliestEraOrLowestErathem
260
earliestPeriodOrLowestSystem,earliestPeriodOrLowestSystem
261
endDayOfYear,endDayOfYear
262
establishmentMeans,establishmentMeans
263
Cultivated?,establishmentMeans/_if:[then=cultivated]/cond/_eq:[right=Yes]/left,
264
eventDate,eventDate
265
eventDate/_alt,eventDate/_alt
266
eventID,eventID
267
eventRemarks,eventRemarks
268
eventTime,eventTime
269
family,family
270
fieldNotes,fieldNotes
271
fieldNumber,fieldNumber
272
footprintSRS,footprintSRS
273
footprintSpatialFit,footprintSpatialFit
274
footprintWKT,footprintWKT
275
formation,formation
276
genus,genus
277
geodeticDatum,geodeticDatum
278
geologicalContextID,geologicalContextID
279
georeferenceProtocol,georeferenceProtocol
280
georeferenceRemarks,georeferenceRemarks
281
georeferenceSources,georeferenceSources
282
georeferenceVerificationStatus,georeferenceVerificationStatus
283
georeferencedBy,georeferencedBy
284
georeferencedDate,georeferencedDate
285
group,group
286
habitat,habitat
287
higherClassification,higherClassification
288
higherGeography,higherGeography
289
higherGeographyID,higherGeographyID
290
highestBiostratigraphicZone,highestBiostratigraphicZone
291
identificationID,identificationID
292
identificationQualifier,identificationQualifier
293
identificationReferences,identificationReferences
294
identificationRemarks,identificationRemarks
295
identificationVerificationStatus,identificationVerificationStatus
296
identifiedBy,identifiedBy
297
individualCount,individualCount
298
individualID,individualID
299
informationWithheld,informationWithheld
300
infraspecificEpithet,infraspecificEpithet
301
institutionCode,institutionCode
302
institutionID,institutionID
303
island,island
304
islandGroup,islandGroup
305
kingdom,kingdom
306
latestAgeOrHighestStage,latestAgeOrHighestStage
307
latestEonOrHighestEonothem,latestEonOrHighestEonothem
308
latestEpochOrHighestSeries,latestEpochOrHighestSeries
309
latestEraOrHighestErathem,latestEraOrHighestErathem
310
latestPeriodOrHighestSystem,latestPeriodOrHighestSystem
311
lifeStage,lifeStage
312
lithostratigraphicTerms,lithostratigraphicTerms
313
locality,locality
314
locationAccordingTo,locationAccordingTo
315
locationID,locationID
316
locationRemarks,locationRemarks
317
lowestBiostratigraphicZone,lowestBiostratigraphicZone
318
maximumDepthInMeters,maximumDepthInMeters
319
maximumDistanceAboveSurfaceInMeters,maximumDistanceAboveSurfaceInMeters
320
maximumElevationInMeters,maximumElevationInMeters
321
measurementAccuracy,measurementAccuracy
322
measurementDeterminedBy,measurementDeterminedBy
323
measurementDeterminedDate,measurementDeterminedDate
324
measurementID,measurementID
325
measurementMethod,measurementMethod
326
measurementRemarks,measurementRemarks
327
measurementType,measurementType
328
measurementUnit,measurementUnit
329
measurementValue,measurementValue
330
member,member
331
minimumDepthInMeters,minimumDepthInMeters
332
minimumDistanceAboveSurfaceInMeters,minimumDistanceAboveSurfaceInMeters
333
minimumElevationInMeters,minimumElevationInMeters
334
month,month
335
municipality,municipality
336
nameAccordingTo,nameAccordingTo
337
nameAccordingToID,nameAccordingToID
338
namePublishedIn,namePublishedIn
339
namePublishedInID,namePublishedInID
340
namePublishedInYear,namePublishedInYear
341
nomenclaturalCode,nomenclaturalCode
342
nomenclaturalStatus,nomenclaturalStatus
343
Accession Number,occurrenceID,
344
occurrenceID,occurrenceID
345
occurrenceRemarks,occurrenceRemarks
346
occurrenceStatus,occurrenceStatus
347
order,order
348
originalNameUsage,originalNameUsage
349
originalNameUsageID,originalNameUsageID
350
otherCatalogNumbers,otherCatalogNumbers
351
ownerInstitutionCode,ownerInstitutionCode
352
parentNameUsage,parentNameUsage
353
parentNameUsageID,parentNameUsageID
354
phylum,phylum
355
pointRadiusSpatialFit,pointRadiusSpatialFit
356
preparations,preparations
357
previousIdentifications,previousIdentifications
358
recordNumber,recordNumber
359
recordedBy,recordedBy
360
relatedResourceID,relatedResourceID
361
relationshipAccordingTo,relationshipAccordingTo
362
relationshipEstablishedDate,relationshipEstablishedDate
363
relationshipOfResource,relationshipOfResource
364
relationshipRemarks,relationshipRemarks
365
reproductiveCondition,reproductiveCondition
366
resourceID,resourceID
367
resourceRelationshipID,resourceRelationshipID
368
samplingEffort,samplingEffort
369
samplingProtocol,samplingProtocol
370
scientificName,scientificName
371
scientificNameAuthorship,scientificNameAuthorship
372
scientificNameID,scientificNameID
373
sex,sex
374
specificEpithet,specificEpithet
375
startDayOfYear,startDayOfYear
376
stateProvince,stateProvince
377
subgenus,subgenus
378
taxonConceptID,taxonConceptID
379
taxonID,taxonID
380
taxonRank,taxonRank
381
taxonRemarks,taxonRemarks
382
taxonomicStatus,taxonomicStatus
383
typeStatus,typeStatus
384
verbatimCoordinateSystem,verbatimCoordinateSystem
385
verbatimCoordinates,verbatimCoordinates
386
verbatimDepth,verbatimDepth
387
verbatimElevation,verbatimElevation
388
verbatimEventDate,verbatimEventDate
389
verbatimLatitude,verbatimLatitude
390
verbatimLocality,verbatimLocality
391
verbatimLongitude,verbatimLongitude
392
verbatimSRS,verbatimSRS
393
verbatimTaxonRank,verbatimTaxonRank
394
vernacularName,vernacularName
395
waterBody,waterBody
396
year,year
397
Alt E/W,,
398
Alt N/S,,
399
FIPS,,FIPS county code
400
Typology,,
inputs/NCU-NCSC/test/DwC.specimens.xml.ref
1
<?xml version="1.0" ?>
2
<DwC xmlns:dcterms="http://purl.org/dc/terms/">
3
    <list id="0">
4
        <institutionID>NCU-NCSC</institutionID>
5
        <CatalogNumber>NCU00090254</CatalogNumber>
6
        <CollectedDate>25-Jun-94</CollectedDate>
7
        <CollectionCode>NCU</CollectionCode>
8
        <Country>USA</Country>
9
        <County>Lancaster</County>
10
        <PreparationType>Specimen</PreparationType>
11
        <ScientificName>Sanguinaria canadensis</ScientificName>
12
        <StateProvince>Virginia</StateProvince>
13
        <establishmentMeans/>
14
        <occurrenceID>0</occurrenceID>
15
    </list>
16
    <list id="1">
17
        <institutionID>NCU-NCSC</institutionID>
18
        <CollectedDate>8-May-65</CollectedDate>
19
        <CollectionCode>WEWO</CollectionCode>
20
        <CoordinateUncertaintyInMeters>1000</CoordinateUncertaintyInMeters>
21
        <Country>USA</Country>
22
        <County>Moore</County>
23
        <Latitude>35.1611111</Latitude>
24
        <Longitude>-79.3486111</Longitude>
25
        <PreparationType>Specimen</PreparationType>
26
        <ScientificName>Senecio anonymus</ScientificName>
27
        <StateProvince>North Carolina</StateProvince>
28
        <establishmentMeans/>
29
        <occurrenceID>1</occurrenceID>
30
    </list>
31
</DwC>
inputs/NCU-NCSC/test/VegBIEN.specimens.xml.ref
1
<?xml version="1.0" ?>
2
<VegBIEN>
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>county</rank>
14
                                            <placename>Lancaster</placename>
15
                                            <parent_id>
16
                                                <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>
25
                                                </namedplace>
26
                                            </parent_id>
27
                                        </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
                    <role>identifier</role>
38
                    <isoriginal>true</isoriginal>
39
                    <iscurrent>true</iscurrent>
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
            </taxonoccurrence>
52
        </taxonoccurrence_id>
53
        <collectioncode_dwc>NCU</collectioncode_dwc>
54
        <datasource_id><party><organizationname>NCU-NCSC</organizationname></party></datasource_id>
55
        <catalognumber_dwc>NCU00090254</catalognumber_dwc>
56
        <sourceaccessioncode>0</sourceaccessioncode>
57
    </specimenreplicate>
58
    <specimenreplicate id="1">
59
        <taxonoccurrence_id>
60
            <taxonoccurrence>
61
                <locationevent_id>
62
                    <locationevent>
63
                        <location_id>
64
                            <location>
65
                                <locationdetermination>
66
                                    <coordsaccuracy>1000</coordsaccuracy>
67
                                    <namedplace_id>
68
                                        <namedplace>
69
                                            <rank>county</rank>
70
                                            <placename>Moore</placename>
71
                                            <parent_id>
72
                                                <namedplace>
73
                                                    <rank>stateProvince</rank>
74
                                                    <placename>North Carolina</placename>
75
                                                    <parent_id>
76
                                                        <namedplace>
77
                                                            <rank>country</rank>
78
                                                            <placename>USA</placename>
79
                                                        </namedplace>
80
                                                    </parent_id>
81
                                                </namedplace>
82
                                            </parent_id>
83
                                        </namedplace>
84
                                    </namedplace_id>
85
                                    <latitude>35.1611111</latitude>
86
                                    <longitude>-79.3486111</longitude>
87
                                </locationdetermination>
88
                                <centerlatitude>35.1611111</centerlatitude>
89
                                <centerlongitude>-79.3486111</centerlongitude>
90
                            </location>
91
                        </location_id>
92
                        <obsstartdate>1965-05-08</obsstartdate>
93
                        <obsenddate/>
94
                    </locationevent>
95
                </locationevent_id>
96
                <taxondetermination>
97
                    <role>identifier</role>
98
                    <isoriginal>true</isoriginal>
99
                    <iscurrent>true</iscurrent>
100
                    <plantconcept_id>
101
                        <plantconcept>
102
                            <plantname_id>
103
                                <plantname>
104
                                    <rank>binomial</rank>
105
                                    <plantname>Senecio anonymus</plantname>
106
                                </plantname>
107
                            </plantname_id>
108
                        </plantconcept>
109
                    </plantconcept_id>
110
                </taxondetermination>
111
            </taxonoccurrence>
112
        </taxonoccurrence_id>
113
        <collectioncode_dwc>WEWO</collectioncode_dwc>
114
        <datasource_id><party><organizationname>NCU-NCSC</organizationname></party></datasource_id>
115
        <sourceaccessioncode>1</sourceaccessioncode>
116
    </specimenreplicate>
117
</VegBIEN>
inputs/NCU-NCSC/test/import.specimens.out.ref
1
Inserted 22 new rows into database
inputs/NCU-NCSC/maps/src.join.specimens.csv
1
NCU-NCSC[DwC],VegBIEN:/specimenreplicate,Comments,Order
2
Accuracy,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88
3
CoordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88
4
coordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88
5
CoordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89
6
coordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89
7
BoundingBox,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
8
FootprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
9
footprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
10
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
11
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
12
State,"/*_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
13
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
14
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
15
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
16
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
17
Locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
18
locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
19
VerbatimLocality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
20
verbatimLocality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
21
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
22
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
23
MinimumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}",,71
24
MinimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}",,71
25
minimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}",,71
26
MaximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72
27
MaximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72
28
maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72
29
DecimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
30
decimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
31
Latitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
32
VerbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
33
verbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
34
Lat (-=S),"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",,81
35
DecimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
36
decimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
37
Longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
38
VerbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
39
verbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
40
Long (-=W),"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",,82
41
MaximumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
42
MaximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
43
maximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
44
MinimumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
45
MinimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
46
minimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
47
EventDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value",,44
48
eventDate/_alt,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt",Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,44
49
DayCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44
50
MonthCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,44
51
YearCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,44
52
eventDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/2",,44
53
Collect Date,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/3",,44
54
CollectedDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/3",,44
55
DateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value,,120
56
dateIdentified/_alt,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom dateIdentified mappings that don't pass through the default dateIdentified mapping,120
57
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,120
58
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,120
59
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,120
60
dateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,120
61
IdentifiedDate,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/3,,120
62
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
63
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
64
Full Taxon Name,"/*_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
65
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
66
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
67
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
68
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
69
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
70
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
71
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
72
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
73
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
74
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
75
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
76
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
77
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
78
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
79
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
80
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
81
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
82
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
83
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
84
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
85
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
86
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
87
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
88
Collector,/*_id/taxonoccurrence/verbatimcollectorname,,23
89
RecordedBy,/*_id/taxonoccurrence/verbatimcollectorname,,23
90
recordedBy,/*_id/taxonoccurrence/verbatimcollectorname,,23
91
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
92
SeriesName,/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
93
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
94
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
95
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
96
FieldNotes,/description/_merge/1,,
97
Notes,/description/_merge/1,,
98
fieldNotes,/description/_merge/1,,
99
Remarks,/description/_merge/2,,158
100
TaxonRemarks,/description/_merge/2,,158
101
taxonRemarks,/description/_merge/2,,158
102
Barcode,":[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
103
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
104
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
105
Accession Number,":[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
106
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
107
OccurrenceID,":[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
108
occurrenceID,":[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
109
CollectorNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
110
RecordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
111
recordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
112
CollectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9
113
collectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9
114
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
115
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
116
InstitutionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,,8
117
institutionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,,8
118
Alt E/W,,
119
Alt N/S,,
120
Cultivated?,,** No join mapping for establishmentMeans/_if:[then=cultivated]/cond/_eq:[right=Yes]/left ** 
121
Elevation,,** No join mapping for VerbatimElevation ** 
122
FIPS,,FIPS county code
123
Format,,** No join mapping for PreparationType ** 
124
Typology,,
inputs/NCU-NCSC/maps/src.specimens.csv
1
"NCU-NCSC[DwC]"
2
"Accession Number"
3
"SeriesName"
4
"Barcode"
5
"Full Taxon Name"
6
"Collect Date"
7
"Country"
8
"State"
9
"County"
10
"Cultivated?"
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff