Project

General

Profile

« Previous | Next » 

Revision 6288

Added by Aaron Marcuse-Kubitza about 12 years ago

Removed inputs/QMOR/ because it's an insect collection

View differences:

inputs/QMOR/Specimen/map.csv
1 
QMOR,VegCore,Filter,Comments
2 
id,occurrenceID,,
3 
locationRemarks,locationRemarks,,
4 
decimalLongitude,decimalLongitude,,
5 
stateProvince,stateProvince,,
6 
typeStatus,typeStatus,,
7 
institutionID,institutionID,,
8 
identificationRemarks,identificationRemarks,,
9 
genus,genus,,
10 
georeferenceSources,georeferenceSources,,
11 
samplingProtocol,samplingProtocol,,
12 
country,country,,
13 
georeferencedBy,georeferencedBy,,
14 
acceptedNameUsage,acceptedNameUsage,,
15 
institutionCode,institutionCode,,
16 
decimalLatitude,decimalLatitude,,
17 
catalogNumber,catalogNumber,,
18 
verbatimLongitude,longitude_DMS,,
19 
verbatimEventDate,verbatimEventDate,,
20 
county,county,,
21 
nomenclaturalCode,nomenclaturalCode,,
22 
georeferenceRemarks,georeferenceRemarks,,
23 
occurrenceRemarks,occurrenceRemarks,,
24 
continent,continent,,
25 
bibliographicCitation,dcterms:bibliographicCitation,,
26 
verbatimSRS,verbatimSRS,,
27 
scientificNameAuthorship,scientificNameAuthorship,,
28 
datasetName,datasetName,,
29 
preparations,preparations,,
30 
sex,sex,,
31 
locality,locality,,
32 
waterBody,waterBody,,
33 
behavior,behavior,,
34 
collectionID,collectionID,,
35 
lifeStage,lifeStage,,
36 
habitat,habitat,,
37 
eventDate,eventDate,,
38 
minimumElevationInMeters,minimumElevationInMeters,,
39 
eventRemarks,eventRemarks,,
40 
kingdom,kingdom,,
41 
class,class,,
42 
rightsHolder,dcterms:rightsHolder,,
43 
verbatimCoordinateSystem,verbatimCoordinateSystem,,
44 
language,dcterms:language,,
45 
verbatimCoordinates,verbatimCoordinates,,
46 
rights,dcterms:rights,,
47 
type,dcterms:type,,
48 
footprintWKT,footprintWKT,,
49 
collectionCode,collectionCode,,
50 
georeferenceProtocol,georeferenceProtocol,,
51 
verbatimLatitude,latitude_DMS,,
52 
geodeticDatum,geodeticDatum,,
53 
identifiedBy,identifiedBy,,
54 
datasetID,datasetID,,
55 
georeferencedDate,georeferencedDate,,
56 
taxonRank,taxonRank,,
57 
family,family,,
58 
phylum,phylum,,
59 
modified,dcterms:modified,,
60 
order,order,,
61 
coordinateUncertaintyInMeters,coordinateUncertaintyInMeters,,
62 
basisOfRecord,basisOfRecord,,
63 
scientificName,taxonName,,
64 
maximumElevationInMeters,maximumElevationInMeters,,
65 
dateIdentified,dateIdentified,,
66 
individualCount,individualCount,,
67 
municipality,municipality,,
68 
identificationQualifier,identificationQualifier,,
69 
eventTime,eventTime,,
70 
recordedBy,recordedBy,,
71 
specificEpithet,specificEpithet,,
72 
verbatimElevation,verbatimElevation,,
73 
ownerInstitutionCode,ownerInstitutionCode,,
74 
infraspecificEpithet,infraspecificEpithet,,
inputs/QMOR/Specimen/test.xml.ref
1 
Put template:
2 
<VegBIEN>
3 
    <_simplifyPath id="-1">
4 
        <next>parent_id</next>
5 
        <path>
6 
            <location>
7 
                <authorlocationcode>
8 
                    <_alt>
9 
                        <1>$id</1>
10 
                        <2>
11 
                            <_join>
12 
                                <1>$institutionCode</1>
13 
                                <2>
14 
                                    <_join>
15 
                                        <1>$collectionCode</1>
16 
                                        <2>$collectionID</2>
17 
                                    </_join>
18 
                                </2>
19 
                                <3>$catalogNumber</3>
20 
                            </_join>
21 
                        </2>
22 
                    </_alt>
23 
                </authorlocationcode>
24 
                <elevation_m>
25 
                    <_alt>
26 
                        <1>
27 
                            <_units>
28 
                                <to>m</to>
29 
                                <to></to>
30 
                                <value>$verbatimElevation</value>
31 
                            </_units>
32 
                        </1>
33 
                        <2>
34 
                            <_avg>
35 
                                <max>$maximumElevationInMeters</max>
36 
                                <min>$minimumElevationInMeters</min>
37 
                            </_avg>
38 
                        </2>
39 
                    </_alt>
40 
                </elevation_m>
41 
                <locationevent>
42 
                    <method_id><method><name>$samplingProtocol</name></method></method_id>
43 
                    <obsenddate><_dateRangeEnd><value>$eventDate</value></_dateRangeEnd></obsenddate>
44 
                    <obsstartdate><_dateRangeStart><value>$eventDate</value></_dateRangeStart></obsstartdate>
45 
                    <taxonoccurrence>
46 
                        <aggregateoccurrence>
47 
                            <count>$individualCount</count>
48 
                            <plantobservation>
49 
                                <definedvalue fkey="tablerecord_id">
50 
                                    <userdefined_id>
51 
                                        <userdefined>
52 
                                            <tablename>plantobservation</tablename>
53 
                                            <userdefinedname>sex</userdefinedname>
54 
                                        </userdefined>
55 
                                    </userdefined_id>
56 
                                    <definedvalue>$sex</definedvalue>
57 
                                </definedvalue>
58 
                                <specimenreplicate>
59 
                                    <catalognumber_dwc>$catalogNumber</catalognumber_dwc>
60 
                                    <collectioncode_dwc>
61 
                                        <_join>
62 
                                            <1>$collectionCode</1>
63 
                                            <2>$collectionID</2>
64 
                                        </_join>
65 
                                    </collectioncode_dwc>
66 
                                    <institution_id><sourcename><name>$institutionCode</name></sourcename></institution_id>
67 
                                    <sourceaccessioncode>$id</sourceaccessioncode>
68 
                                </specimenreplicate>
69 
                            </plantobservation>
70 
                        </aggregateoccurrence>
71 
                        <collector_id><party><fullname>$recordedBy</fullname></party></collector_id>
72 
                        <sourceaccessioncode>$id</sourceaccessioncode>
73 
                        <taxondetermination>
74 
                            <party_id><party><fullname>$identifiedBy</fullname></party></party_id>
75 
                            <taxonverbatim_id>
76 
                                <taxonverbatim>
77 
                                    <taxonlabel_id>
78 
                                        <taxonlabel>
79 
                                            <matched_label_id>
80 
                                                <taxonlabel>
81 
                                                    <source_id><source><shortname>TNRS</shortname></source></source_id>
82 
                                                    <taxonomicname>
83 
                                                        <_join_words>
84 
                                                            <1><_taxon_family_require_std><family>$family</family></_taxon_family_require_std></1>
85 
                                                            <2>
86 
                                                                <_join_words>
87 
                                                                    <1>
88 
                                                                        <_alt>
89 
                                                                            <1>$scientificName</1>
90 
                                                                            <2>
91 
                                                                                <_join_words>
92 
                                                                                    <2>$genus</2>
93 
                                                                                    <3>$specificEpithet</3>
94 
                                                                                    <5>
95 
                                                                                        <_join_words>
96 
                                                                                            <1>
97 
                                                                                                <_if name="if has infraspecificEpithet">
98 
                                                                                                    <cond>$infraspecificEpithet</cond>
99 
                                                                                                    <then>$taxonRank</then>
100 
                                                                                                </_if>
101 
                                                                                            </1>
102 
                                                                                            <2>$infraspecificEpithet</2>
103 
                                                                                        </_join_words>
104 
                                                                                    </5>
105 
                                                                                </_join_words>
106 
                                                                            </2>
107 
                                                                        </_alt>
108 
                                                                    </1>
109 
                                                                    <2>$scientificNameAuthorship</2>
110 
                                                                </_join_words>
111 
                                                            </2>
112 
                                                        </_join_words>
113 
                                                    </taxonomicname>
114 
                                                </taxonlabel>
115 
                                            </matched_label_id>
116 
                                            <creationdate><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></creationdate>
117 
                                            <parent_id>
118 
                                                <taxonlabel>
119 
                                                    <rank>$taxonRank</rank>
120 
                                                    <taxonverbatim><verbatimrank>$taxonRank</verbatimrank></taxonverbatim>
121 
                                                    <parent_id>
122 
                                                        <taxonlabel>
123 
                                                            <rank>cultivar</rank>
124 
                                                            <parent_id>
125 
                                                                <taxonlabel>
126 
                                                                    <rank>forma</rank>
127 
                                                                    <parent_id>
128 
                                                                        <taxonlabel>
129 
                                                                            <rank>variety</rank>
130 
                                                                            <parent_id>
131 
                                                                                <taxonlabel>
132 
                                                                                    <rank>subspecies</rank>
133 
                                                                                    <parent_id>
134 
                                                                                        <taxonlabel>
135 
                                                                                            <rank>species</rank>
136 
                                                                                            <taxonepithet>$specificEpithet</taxonepithet>
137 
                                                                                            <parent_id>
138 
                                                                                                <taxonlabel>
139 
                                                                                                    <rank>genus</rank>
140 
                                                                                                    <taxonepithet>$genus</taxonepithet>
141 
                                                                                                    <parent_id>
142 
                                                                                                        <taxonlabel>
143 
                                                                                                            <rank>family</rank>
144 
                                                                                                            <taxonepithet>$family</taxonepithet>
145 
                                                                                                            <parent_id>
146 
                                                                                                                <taxonlabel>
147 
                                                                                                                    <rank>order</rank>
148 
                                                                                                                    <taxonepithet>$order</taxonepithet>
149 
                                                                                                                    <parent_id>
150 
                                                                                                                        <taxonlabel>
151 
                                                                                                                            <rank>class</rank>
152 
                                                                                                                            <taxonepithet>$class</taxonepithet>
153 
                                                                                                                            <parent_id>
154 
                                                                                                                                <taxonlabel>
155 
                                                                                                                                    <rank>phylum</rank>
156 
                                                                                                                                    <taxonepithet>$phylum</taxonepithet>
157 
                                                                                                                                    <parent_id>
158 
                                                                                                                                        <taxonlabel>
159 
                                                                                                                                            <rank>kingdom</rank>
160 
                                                                                                                                            <taxonepithet>$kingdom</taxonepithet>
161 
                                                                                                                                        </taxonlabel>
162 
                                                                                                                                    </parent_id>
163 
                                                                                                                                </taxonlabel>
164 
                                                                                                                            </parent_id>
165 
                                                                                                                        </taxonlabel>
166 
                                                                                                                    </parent_id>
167 
                                                                                                                </taxonlabel>
168 
                                                                                                            </parent_id>
169 
                                                                                                        </taxonlabel>
170 
                                                                                                    </parent_id>
171 
                                                                                                </taxonlabel>
172 
                                                                                            </parent_id>
173 
                                                                                        </taxonlabel>
174 
                                                                                    </parent_id>
175 
                                                                                </taxonlabel>
176 
                                                                            </parent_id>
177 
                                                                        </taxonlabel>
178 
                                                                    </parent_id>
179 
                                                                </taxonlabel>
180 
                                                            </parent_id>
181 
                                                        </taxonlabel>
182 
                                                    </parent_id>
183 
                                                    <taxonepithet>$infraspecificEpithet</taxonepithet>
184 
                                                </taxonlabel>
185 
                                            </parent_id>
186 
                                            <rank>$taxonRank</rank>
187 
                                            <taxonomicname>
188 
                                                <_join_words>
189 
                                                    <1><_taxon_family_require_std><family>$family</family></_taxon_family_require_std></1>
190 
                                                    <2>
191 
                                                        <_join_words>
192 
                                                            <1>
193 
                                                                <_alt>
194 
                                                                    <1>$scientificName</1>
195 
                                                                    <2>
196 
                                                                        <_join_words>
197 
                                                                            <2>$genus</2>
198 
                                                                            <3>$specificEpithet</3>
199 
                                                                            <5>
200 
                                                                                <_join_words>
201 
                                                                                    <1>
202 
                                                                                        <_if name="if has infraspecificEpithet">
203 
                                                                                            <cond>$infraspecificEpithet</cond>
204 
                                                                                            <then>$taxonRank</then>
205 
                                                                                        </_if>
206 
                                                                                    </1>
207 
                                                                                    <2>$infraspecificEpithet</2>
208 
                                                                                </_join_words>
209 
                                                                            </5>
210 
                                                                        </_join_words>
211 
                                                                    </2>
212 
                                                                </_alt>
213 
                                                            </1>
214 
                                                            <2>$scientificNameAuthorship</2>
215 
                                                        </_join_words>
216 
                                                    </2>
217 
                                                </_join_words>
218 
                                            </taxonomicname>
219 
                                        </taxonlabel>
220 
                                    </taxonlabel_id>
221 
                                    <author>$scientificNameAuthorship</author>
222 
                                    <family>$family</family>
223 
                                    <genus>$genus</genus>
224 
                                    <specific_epithet>$specificEpithet</specific_epithet>
225 
                                    <taxonname>$scientificName</taxonname>
226 
                                    <verbatimrank>$taxonRank</verbatimrank>
227 
                                </taxonverbatim>
228 
                            </taxonverbatim_id>
229 
                            <determinationdate><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></determinationdate>
230 
                            <taxonfit>$identificationQualifier</taxonfit>
231 
                        </taxondetermination>
232 
                    </taxonoccurrence>
233 
                </locationevent>
234 
                <locationnarrative>
235 
                    <_merge>
236 
                        <1>$locality</1>
237 
                        <3>
238 
                            <_label>
239 
                                <label>habitat</label>
240 
                                <value>$habitat</value>
241 
                            </_label>
242 
                        </3>
243 
                    </_merge>
244 
                </locationnarrative>
245 
                <locationplace>
246 
                    <place_id>
247 
                        <place>
248 
                            <coordinates_id>
249 
                                <coordinates>
250 
                                    <coordsaccuracy_m><_noCV><value>$coordinateUncertaintyInMeters</value></_noCV></coordsaccuracy_m>
251 
                                    <footprintgeometry_dwc>$footprintWKT</footprintgeometry_dwc>
252 
                                    <latitude_deg>
253 
                                        <_nullIf>
254 
                                            <null>0</null>
255 
                                            <type>float</type>
256 
                                            <value>$decimalLatitude</value>
257 
                                        </_nullIf>
258 
                                    </latitude_deg>
259 
                                    <longitude_deg>
260 
                                        <_nullIf>
261 
                                            <null>0</null>
262 
                                            <type>float</type>
263 
                                            <value>$decimalLongitude</value>
264 
                                        </_nullIf>
265 
                                    </longitude_deg>
266 
                                    <verbatimlatitude>$verbatimLatitude</verbatimlatitude>
267 
                                    <verbatimlongitude>$verbatimLongitude</verbatimlongitude>
268 
                                </coordinates>
269 
                            </coordinates_id>
270 
                            <continent>$continent</continent>
271 
                            <country>$country</country>
272 
                            <county>$county</county>
273 
                            <matched_place_id>
274 
                                <place>
275 
                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>
276 
                                    <coordinates_id>
277 
                                        <coordinates>
278 
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
279 
                                            <latitude_deg>
280 
                                                <_nullIf>
281 
                                                    <null>0</null>
282 
                                                    <type>float</type>
283 
                                                    <value>$decimalLatitude</value>
284 
                                                </_nullIf>
285 
                                            </latitude_deg>
286 
                                            <longitude_deg>
287 
                                                <_nullIf>
288 
                                                    <null>0</null>
289 
                                                    <type>float</type>
290 
                                                    <value>$decimalLongitude</value>
291 
                                                </_nullIf>
292 
                                            </longitude_deg>
293 
                                        </coordinates>
294 
                                    </coordinates_id>
295 
                                    <country>$country</country>
296 
                                    <stateprovince>$stateProvince</stateprovince>
297 
                                </place>
298 
                            </matched_place_id>
299 
                            <stateprovince>$stateProvince</stateprovince>
300 
                        </place>
301 
                    </place_id>
302 
                </locationplace>
303 
                <verbatimelevation>$verbatimElevation</verbatimelevation>
304 
            </location>
305 
        </path>
306 
    </_simplifyPath>
307 
</VegBIEN>
308 
Inserted 37 new rows into database
inputs/QMOR/Specimen/VegBIEN.csv
1 
QMOR,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 
id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1",
3 
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/cond/_exists",
4 
institutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1",
5 
collectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/1",
6 
collectionID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/2",
7 
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
8 
verbatimElevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value",
9 
maximumElevationInMeters,/location/elevation_m/_alt/2/_avg/max,
10 
minimumElevationInMeters,/location/elevation_m/_alt/2/_avg/min,
11 
samplingProtocol,/location/locationevent/*_id/method/name,
12 
eventDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
13 
eventDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsenddate/_alt/2/_dateRangeEnd/value",
14 
eventDate,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsstartdate/_alt/2/_dateRangeStart/value",
15 
eventDate,/location/locationevent/obsenddate/_alt/2/_dateRangeEnd/value,
16 
eventDate,/location/locationevent/obsstartdate/_alt/2/_dateRangeStart/value,
17 
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
18 
sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"
19 
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
20 
collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name
21 
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/2,
22 
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcename/name,
23 
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
24 
scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
25 
recordedBy,/location/locationevent/taxonoccurrence/collector_id/party/fullname,
26 
id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,
27 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname,
28 
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/1/_taxon_family_require_std/family",
29 
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1",
30 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/2",
31 
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
32 
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
33 
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
34 
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
35 
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/2",
36 
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/creationdate/_alt/1/_dateRangeStart/value,
37 
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank",
38 
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank",
39 
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
40 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname",
41 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
42 
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname",
43 
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
44 
order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=order]/taxonepithet",
45 
class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=class]/taxonepithet",
46 
phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=phylum]/taxonepithet",
47 
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=kingdom]/taxonepithet",
48 
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/taxonepithet,
49 
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/rank,
50 
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonepithet/_if[@name=""if taxonomic name is epithet""]/cond/_alt:[2=true]/1/_taxonomic_name_is_epithet/rank",
51 
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/1/_taxon_family_require_std/family,
52 
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/1,
53 
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/2,
54 
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
55 
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
56 
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
57 
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
58 
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_join_words/2/_alt/2/_join_words/2,
59 
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/author,
60 
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family,
61 
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus,
62 
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet,
63 
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonname,
64 
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/verbatimrank,
65 
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_dateRangeStart/value,
66 
identificationQualifier,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,
67 
catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
68 
locality,/location/locationnarrative/_merge/1,
69 
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
70 
coordinateUncertaintyInMeters,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_m/_noCV/value,
71 
footprintWKT,/location/locationplace/*_id/place/*_id/coordinates/footprintgeometry_dwc,
72 
decimalLatitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
73 
decimalLongitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
74 
verbatimLatitude,/location/locationplace/*_id/place/*_id/coordinates/verbatimlatitude,
75 
verbatimLongitude,/location/locationplace/*_id/place/*_id/coordinates/verbatimlongitude,
76 
continent,/location/locationplace/*_id/place/continent,
77 
country,/location/locationplace/*_id/place/country,
78 
county,/location/locationplace/*_id/place/county,
79 
decimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
80 
decimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
81 
country,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/country/_first/2,
82 
stateProvince,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2,
83 
stateProvince,/location/locationplace/*_id/place/stateprovince,
84 
verbatimElevation,/location/verbatimelevation,
85 
acceptedNameUsage,,** No join mapping for acceptedNameUsage **
86 
basisOfRecord,,** No join mapping for basisOfRecord **
87 
behavior,,** No join mapping for behavior **
88 
bibliographicCitation,,** No join mapping for dcterms:bibliographicCitation **
89 
datasetID,,** No join mapping for datasetID **
90 
datasetName,,** No join mapping for datasetName **
91 
eventRemarks,,** No join mapping for eventRemarks **
92 
eventTime,,** No join mapping for eventTime **
93 
geodeticDatum,,** No join mapping for geodeticDatum **
94 
georeferenceProtocol,,** No join mapping for georeferenceProtocol **
95 
georeferenceRemarks,,** No join mapping for georeferenceRemarks **
96 
georeferenceSources,,** No join mapping for georeferenceSources **
97 
georeferencedBy,,** No join mapping for georeferencedBy **
98 
georeferencedDate,,** No join mapping for georeferencedDate **
99 
identificationRemarks,,** No join mapping for identificationRemarks **
100 
institutionID,,** No join mapping for institutionID **
101 
language,,** No join mapping for dcterms:language **
102 
lifeStage,,** No join mapping for lifeStage **
103 
locationRemarks,,** No join mapping for locationRemarks **
104 
modified,,** No join mapping for dcterms:modified **
105 
municipality,,** No join mapping for municipality **
106 
nomenclaturalCode,,** No join mapping for nomenclaturalCode **
107 
occurrenceRemarks,,** No join mapping for occurrenceRemarks **
108 
ownerInstitutionCode,,** No join mapping for ownerInstitutionCode **
109 
preparations,,** No join mapping for preparations **
110 
rights,,** No join mapping for dcterms:rights **
111 
rightsHolder,,** No join mapping for dcterms:rightsHolder **
112 
type,,** No join mapping for dcterms:type **
113 
typeStatus,,** No join mapping for typeStatus **
114 
verbatimCoordinateSystem,,** No join mapping for verbatimCoordinateSystem **
115 
verbatimCoordinates,,** No join mapping for verbatimCoordinates **
116 
verbatimEventDate,,** No join mapping for verbatimEventDate **
117 
verbatimSRS,,** No join mapping for verbatimSRS **
118 
waterBody,,** No join mapping for waterBody **
inputs/QMOR/Specimen/unmapped_terms.csv
1 
locationRemarks
2 
typeStatus
3 
institutionID
4 
identificationRemarks
5 
georeferenceSources
6 
georeferencedBy
7 
acceptedNameUsage
8 
verbatimEventDate
9 
nomenclaturalCode
10 
georeferenceRemarks
11 
occurrenceRemarks
12 
dcterms:bibliographicCitation
13 
verbatimSRS
14 
datasetName
15 
preparations
16 
waterBody
17 
behavior
18 
lifeStage
19 
eventRemarks
20 
dcterms:rightsHolder
21 
verbatimCoordinateSystem
22 
dcterms:language
23 
verbatimCoordinates
24 
dcterms:rights
25 
dcterms:type
26 
georeferenceProtocol
27 
geodeticDatum
28 
datasetID
29 
georeferencedDate
30 
dcterms:modified
31 
basisOfRecord
32 
municipality
33 
eventTime
34 
ownerInstitutionCode
inputs/QMOR/unmapped_terms.csv
1 
acceptedNameUsage
2 
basisOfRecord
3 
behavior
4 
datasetID
5 
datasetName
6 
dcterms:bibliographicCitation
7 
dcterms:language
8 
dcterms:modified
9 
dcterms:rights
10 
dcterms:rightsHolder
11 
dcterms:type
12 
eventRemarks
13 
eventTime
14 
geodeticDatum
15 
georeferenceProtocol
16 
georeferenceRemarks
17 
georeferenceSources
18 
georeferencedBy
19 
georeferencedDate
20 
identificationRemarks
21 
institutionID
22 
lifeStage
23 
locationRemarks
24 
municipality
25 
nomenclaturalCode
26 
occurrenceRemarks
27 
ownerInstitutionCode
28 
preparations
29 
typeStatus
30 
verbatimCoordinateSystem
31 
verbatimCoordinates
32 
verbatimEventDate
33 
verbatimSRS
34 
waterBody

Also available in: Unified diff