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