Project

General

Profile

1 3641 aaronmk
Put template:
2
<VegBIEN>
3 4621 aaronmk
    <_simplifyPath id="-1">
4
        <next>parent_id</next>
5
        <path>
6
            <location>
7
                <authorlocationcode>
8
                    <_alt>
9
                        <1>$dwc_dwcore_GlobalUniqueIdentifier</1>
10 4066 aaronmk
                        <2>
11 4327 aaronmk
                            <_join>
12 4066 aaronmk
                                <1>
13 4068 aaronmk
                                    <_alt>
14 4631 aaronmk
                                        <0>$conceptual_darwin_2003_1_0_InstitutionCode</0>
15
                                        <1>$dwc_dwcore_InstitutionCode</1>
16
                                        <2>$dwc_terms_institutionCode</2>
17 4068 aaronmk
                                    </_alt>
18 4066 aaronmk
                                </1>
19 4621 aaronmk
                                <2>
20
                                    <_join>
21
                                        <1>
22
                                            <_alt>
23 4631 aaronmk
                                                <0>$conceptual_darwin_2003_1_0_CollectionCode</0>
24
                                                <1>$dwc_dwcore_CollectionCode</1>
25
                                                <2>$dwc_terms_collectionCode</2>
26 4621 aaronmk
                                            </_alt>
27
                                        </1>
28
                                        <2>$dwc_terms_collectionID</2>
29
                                    </_join>
30
                                </2>
31
                                <3>
32
                                    <_alt>
33 4631 aaronmk
                                        <0>$conceptual_darwin_2003_1_0_CatalogNumber</0>
34
                                        <1>$dwc_dwcore_CatalogNumber</1>
35
                                        <2>$dwc_terms_catalogNumber</2>
36 4621 aaronmk
                                    </_alt>
37
                                </3>
38 4327 aaronmk
                            </_join>
39 4066 aaronmk
                        </2>
40 4621 aaronmk
                    </_alt>
41
                </authorlocationcode>
42 4753 aaronmk
                <elevation_m>
43 4621 aaronmk
                    <_avg>
44
                        <max>
45 4820 aaronmk
                            <_alt>
46
                                <0>$conceptual_darwin_2003_1_0_MaximumElevation</0>
47
                                <1>$dwc_dwcore_MaximumElevationInMeters</1>
48
                                <2>$dwc_terms_maximumElevationInMeters</2>
49
                            </_alt>
50
                        </max>
51
                        <min>
52 4822 aaronmk
                            <_alt>
53
                                <0>$conceptual_darwin_2003_1_0_MinimumElevation</0>
54
                                <1>$dwc_dwcore_MinimumElevationInMeters</1>
55
                                <2>$dwc_terms_minimumElevationInMeters</2>
56
                            </_alt>
57 4621 aaronmk
                        </min>
58
                    </_avg>
59 4753 aaronmk
                </elevation_m>
60 4726 aaronmk
                <locationcoords>
61 4753 aaronmk
                    <coordsaccuracy_deg>
62 4621 aaronmk
                        <_noCV>
63 3786 aaronmk
                            <value>
64 4068 aaronmk
                                <_alt>
65 4621 aaronmk
                                    <1>$dwc_terms_coordinateUncertaintyInMeters</1>
66
                                    <2>$conceptual_darwin_2003_1_0_CoordinatePrecision</2>
67 4068 aaronmk
                                </_alt>
68 3786 aaronmk
                            </value>
69 4621 aaronmk
                        </_noCV>
70 4753 aaronmk
                    </coordsaccuracy_deg>
71 4621 aaronmk
                    <footprintgeometry_dwc>$conceptual_darwin_2003_1_0_BoundingBox</footprintgeometry_dwc>
72 4753 aaronmk
                    <latitude_deg>
73 4907 aaronmk
                        <_nullIf>
74
                            <null>0</null>
75
                            <type>float</type>
76
                            <value>
77
                                <_alt>
78
                                    <0>$conceptual_darwin_2003_1_0_Latitude</0>
79
                                    <1>$dwc_geospatial_DecimalLatitude</1>
80
                                    <2>$dwc_terms_decimalLatitude</2>
81
                                </_alt>
82
                            </value>
83
                        </_nullIf>
84 4753 aaronmk
                    </latitude_deg>
85
                    <longitude_deg>
86 4907 aaronmk
                        <_nullIf>
87
                            <null>0</null>
88
                            <type>float</type>
89
                            <value>
90
                                <_alt>
91
                                    <0>$conceptual_darwin_2003_1_0_Longitude</0>
92
                                    <1>$dwc_geospatial_DecimalLongitude</1>
93
                                    <2>$dwc_terms_decimalLongitude</2>
94
                                </_alt>
95
                            </value>
96
                        </_nullIf>
97
                    </longitude_deg>
98
                    <verbatimlatitude>
99 4621 aaronmk
                        <_alt>
100 4907 aaronmk
                            <0>$dwc_geospatial_VerbatimLatitude</0>
101
                            <1>$dwc_terms_verbatimLatitude</1>
102 4621 aaronmk
                        </_alt>
103 4907 aaronmk
                    </verbatimlatitude>
104
                    <verbatimlongitude>
105
                        <_alt>
106
                            <0>$dwc_geospatial_VerbatimLongitude</0>
107
                            <1>$dwc_terms_verbatimLongitude</1>
108
                        </_alt>
109
                    </verbatimlongitude>
110 4726 aaronmk
                </locationcoords>
111 4621 aaronmk
                <locationevent>
112
                    <taxonoccurrence>
113
                        <aggregateoccurrence>
114
                            <collectiondate>
115
                                <_date>
116
                                    <day>
117
                                        <_nullIf>
118
                                            <null>0</null>
119
                                            <type>float</type>
120
                                            <value>$conceptual_darwin_2003_1_0_DayCollected</value>
121
                                        </_nullIf>
122
                                    </day>
123
                                    <month>
124
                                        <_nullIf>
125
                                            <null>0</null>
126
                                            <type>float</type>
127
                                            <value>$conceptual_darwin_2003_1_0_MonthCollected</value>
128
                                        </_nullIf>
129
                                    </month>
130
                                    <year>
131
                                        <_nullIf>
132
                                            <null>0</null>
133
                                            <type>float</type>
134
                                            <value>$conceptual_darwin_2003_1_0_YearCollected</value>
135
                                        </_nullIf>
136
                                    </year>
137
                                </_date>
138
                            </collectiondate>
139
                            <count>
140
                                <_alt>
141 4631 aaronmk
                                    <0>$conceptual_darwin_2003_1_0_IndividualCount</0>
142
                                    <1>$dwc_curatorial_IndividualCount</1>
143
                                    <2>$dwc_terms_individualCount</2>
144 4621 aaronmk
                                </_alt>
145
                            </count>
146
                            <notes>$conceptual_darwin_2003_1_0_Notes</notes>
147
                            <plantobservation>
148
                                <collectionnumber>
149 4080 aaronmk
                                    <_alt>
150 4621 aaronmk
                                        <1>$dwc_terms_recordNumber</1>
151
                                        <2>
152
                                            <_alt>
153 4631 aaronmk
                                                <0>$conceptual_darwin_2003_1_0_FieldNumber</0>
154
                                                <1>$dwc_curatorial_FieldNumber</1>
155
                                                <2>$dwc_terms_fieldNumber</2>
156 4621 aaronmk
                                            </_alt>
157
                                        </2>
158
                                        <3>
159
                                            <_alt>
160 4631 aaronmk
                                                <0>$conceptual_darwin_2003_1_0_CollectorNumber</0>
161
                                                <1>$dwc_curatorial_CollectorNumber</1>
162 4621 aaronmk
                                            </_alt>
163
                                        </3>
164 4080 aaronmk
                                    </_alt>
165 4621 aaronmk
                                </collectionnumber>
166
                                <definedvalue fkey="tablerecord_id">
167
                                    <userdefined_id>
168
                                        <userdefined>
169
                                            <tablename>plantobservation</tablename>
170
                                            <userdefinedname>sex</userdefinedname>
171
                                        </userdefined>
172
                                    </userdefined_id>
173
                                    <definedvalue>
174 4068 aaronmk
                                        <_alt>
175 4631 aaronmk
                                            <0>$conceptual_darwin_2003_1_0_Sex</0>
176
                                            <1>$dwc_dwcore_Sex</1>
177
                                            <2>$dwc_terms_sex</2>
178 4068 aaronmk
                                        </_alt>
179 4621 aaronmk
                                    </definedvalue>
180
                                </definedvalue>
181
                                <specimenreplicate>
182
                                    <catalognumber_dwc>
183 4068 aaronmk
                                        <_alt>
184 4631 aaronmk
                                            <0>$conceptual_darwin_2003_1_0_CatalogNumber</0>
185
                                            <1>$dwc_dwcore_CatalogNumber</1>
186
                                            <2>$dwc_terms_catalogNumber</2>
187 4068 aaronmk
                                        </_alt>
188 4621 aaronmk
                                    </catalognumber_dwc>
189
                                    <collectioncode_dwc>
190
                                        <_join>
191
                                            <1>
192
                                                <_alt>
193 4631 aaronmk
                                                    <0>$conceptual_darwin_2003_1_0_CollectionCode</0>
194
                                                    <1>$dwc_dwcore_CollectionCode</1>
195
                                                    <2>$dwc_terms_collectionCode</2>
196 4621 aaronmk
                                                </_alt>
197
                                            </1>
198
                                            <2>$dwc_terms_collectionID</2>
199
                                        </_join>
200
                                    </collectioncode_dwc>
201
                                    <institution_id>
202
                                        <party>
203
                                            <organizationname>
204
                                                <_alt>
205 4631 aaronmk
                                                    <0>$conceptual_darwin_2003_1_0_InstitutionCode</0>
206
                                                    <1>$dwc_dwcore_InstitutionCode</1>
207
                                                    <2>$dwc_terms_institutionCode</2>
208 4621 aaronmk
                                                </_alt>
209
                                            </organizationname>
210
                                        </party>
211
                                    </institution_id>
212
                                    <sourceaccessioncode>$dwc_dwcore_GlobalUniqueIdentifier</sourceaccessioncode>
213
                                </specimenreplicate>
214
                            </plantobservation>
215
                        </aggregateoccurrence>
216 4834 aaronmk
                        <sourceaccessioncode>$dwc_dwcore_GlobalUniqueIdentifier</sourceaccessioncode>
217 4621 aaronmk
                        <taxondetermination>
218
                            <party_id>
219
                                <party>
220
                                    <givenname>
221
                                        <_namePart>
222
                                            <first>
223 4068 aaronmk
                                                <_alt>
224 4631 aaronmk
                                                    <0>$conceptual_darwin_2003_1_0_IdentifiedBy</0>
225
                                                    <1>$dwc_curatorial_IdentifiedBy</1>
226
                                                    <2>$dwc_terms_identifiedBy</2>
227 4068 aaronmk
                                                </_alt>
228 4621 aaronmk
                                            </first>
229
                                        </_namePart>
230
                                    </givenname>
231
                                    <middlename>
232
                                        <_namePart>
233
                                            <middle>
234
                                                <_alt>
235 4631 aaronmk
                                                    <0>$conceptual_darwin_2003_1_0_IdentifiedBy</0>
236
                                                    <1>$dwc_curatorial_IdentifiedBy</1>
237
                                                    <2>$dwc_terms_identifiedBy</2>
238 4621 aaronmk
                                                </_alt>
239
                                            </middle>
240
                                        </_namePart>
241
                                    </middlename>
242
                                    <surname>
243
                                        <_namePart>
244
                                            <last>
245
                                                <_alt>
246 4631 aaronmk
                                                    <0>$conceptual_darwin_2003_1_0_IdentifiedBy</0>
247
                                                    <1>$dwc_curatorial_IdentifiedBy</1>
248
                                                    <2>$dwc_terms_identifiedBy</2>
249 4621 aaronmk
                                                </_alt>
250
                                            </last>
251
                                        </_namePart>
252
                                    </surname>
253
                                </party>
254
                            </party_id>
255 5225 aaronmk
                            <taxonconcept_id>
256
                                <taxonconcept>
257
                                    <canon_taxonconcept_id>
258
                                        <taxonconcept>
259 5242 aaronmk
                                            <creator_id>
260 5237 aaronmk
                                                <party>
261 5242 aaronmk
                                                    <creator_id>0</creator_id>
262 5237 aaronmk
                                                    <organizationname>TNRS</organizationname>
263
                                                </party>
264 5242 aaronmk
                                            </creator_id>
265 5138 aaronmk
                                            <identifyingtaxonomicname>
266
                                                <_join_words>
267
                                                    <1>
268
                                                        <_alt>
269
                                                            <1>
270
                                                                <_alt>
271
                                                                    <0>$conceptual_darwin_2003_1_0_ScientificName</0>
272
                                                                    <1>$dwc_dwcore_ScientificName</1>
273
                                                                    <2>$dwc_terms_scientificName</2>
274
                                                                </_alt>
275
                                                            </1>
276
                                                            <2>
277
                                                                <_join_words>
278
                                                                    <1>
279
                                                                        <_alt>
280
                                                                            <0>$conceptual_darwin_2003_1_0_Family</0>
281
                                                                            <1>$dwc_dwcore_Family</1>
282
                                                                            <2>$dwc_terms_family</2>
283
                                                                        </_alt>
284
                                                                    </1>
285
                                                                    <2>
286
                                                                        <_alt>
287
                                                                            <0>$conceptual_darwin_2003_1_0_Genus</0>
288
                                                                            <1>$dwc_dwcore_Genus</1>
289
                                                                            <2>$dwc_terms_genus</2>
290
                                                                        </_alt>
291
                                                                    </2>
292
                                                                    <3>
293
                                                                        <_alt>
294
                                                                            <0>$conceptual_darwin_2003_1_0_Species</0>
295
                                                                            <1>$dwc_dwcore_SpecificEpithet</1>
296
                                                                            <2>$dwc_terms_specificEpithet</2>
297
                                                                        </_alt>
298
                                                                    </3>
299
                                                                    <4>$conceptual_darwin_2003_1_0_Subspecies</4>
300
                                                                    <5>
301
                                                                        <_alt>
302
                                                                            <0>$dwc_dwcore_InfraspecificEpithet</0>
303
                                                                            <1>$dwc_terms_infraspecificEpithet</1>
304
                                                                        </_alt>
305
                                                                    </5>
306
                                                                </_join_words>
307
                                                            </2>
308
                                                        </_alt>
309
                                                    </1>
310
                                                    <2>
311
                                                        <_alt>
312
                                                            <1>$dwc_terms_scientificNameAuthorship</1>
313
                                                            <2>$conceptual_darwin_2003_1_0_ScientificNameAuthor</2>
314
                                                            <3>$dwc_dwcore_AuthorYearOfScientificName</3>
315
                                                        </_alt>
316
                                                    </2>
317
                                                </_join_words>
318
                                            </identifyingtaxonomicname>
319 5225 aaronmk
                                        </taxonconcept>
320
                                    </canon_taxonconcept_id>
321 4944 aaronmk
                                    <author>
322
                                        <_alt>
323
                                            <1>$dwc_terms_scientificNameAuthorship</1>
324
                                            <2>$conceptual_darwin_2003_1_0_ScientificNameAuthor</2>
325
                                            <3>$dwc_dwcore_AuthorYearOfScientificName</3>
326
                                        </_alt>
327
                                    </author>
328 4703 aaronmk
                                    <class>
329
                                        <_alt>
330
                                            <0>$conceptual_darwin_2003_1_0_Class</0>
331
                                            <1>$dwc_dwcore_Class</1>
332
                                            <2>$dwc_terms_class</2>
333
                                        </_alt>
334
                                    </class>
335 5241 aaronmk
                                    <creator_id>
336 5240 aaronmk
                                        <_simplifyPath>
337 5242 aaronmk
                                            <next>creator_id</next>
338 5240 aaronmk
                                            <path>
339
                                                <party>
340
                                                    <givenname>
341
                                                        <_namePart>
342
                                                            <first>
343
                                                                <_alt>
344
                                                                    <0>$conceptual_darwin_2003_1_0_IdentifiedBy</0>
345
                                                                    <1>$dwc_curatorial_IdentifiedBy</1>
346
                                                                    <2>$dwc_terms_identifiedBy</2>
347
                                                                </_alt>
348
                                                            </first>
349
                                                        </_namePart>
350
                                                    </givenname>
351
                                                    <middlename>
352
                                                        <_namePart>
353
                                                            <middle>
354
                                                                <_alt>
355
                                                                    <0>$conceptual_darwin_2003_1_0_IdentifiedBy</0>
356
                                                                    <1>$dwc_curatorial_IdentifiedBy</1>
357
                                                                    <2>$dwc_terms_identifiedBy</2>
358
                                                                </_alt>
359
                                                            </middle>
360
                                                        </_namePart>
361
                                                    </middlename>
362
                                                    <surname>
363
                                                        <_namePart>
364
                                                            <last>
365
                                                                <_alt>
366
                                                                    <0>$conceptual_darwin_2003_1_0_IdentifiedBy</0>
367
                                                                    <1>$dwc_curatorial_IdentifiedBy</1>
368
                                                                    <2>$dwc_terms_identifiedBy</2>
369
                                                                </_alt>
370
                                                            </last>
371
                                                        </_namePart>
372
                                                    </surname>
373
                                                </party>
374
                                            </path>
375
                                        </_simplifyPath>
376 5241 aaronmk
                                    </creator_id>
377 4703 aaronmk
                                    <family>
378
                                        <_alt>
379
                                            <0>$conceptual_darwin_2003_1_0_Family</0>
380
                                            <1>$dwc_dwcore_Family</1>
381
                                            <2>$dwc_terms_family</2>
382
                                        </_alt>
383
                                    </family>
384
                                    <genus>
385
                                        <_alt>
386
                                            <0>$conceptual_darwin_2003_1_0_Genus</0>
387
                                            <1>$dwc_dwcore_Genus</1>
388
                                            <2>$dwc_terms_genus</2>
389
                                        </_alt>
390
                                    </genus>
391 5137 aaronmk
                                    <kingdom>
392
                                        <_alt>
393
                                            <0>$conceptual_darwin_2003_1_0_Kingdom</0>
394
                                            <1>$dwc_dwcore_Kingdom</1>
395
                                            <2>$dwc_terms_kingdom</2>
396
                                        </_alt>
397
                                    </kingdom>
398
                                    <order>
399
                                        <_alt>
400
                                            <0>$conceptual_darwin_2003_1_0_Order</0>
401
                                            <1>$dwc_dwcore_Order</1>
402
                                            <2>$dwc_terms_order</2>
403
                                        </_alt>
404
                                    </order>
405
                                    <phylum>
406
                                        <_alt>
407
                                            <0>$conceptual_darwin_2003_1_0_Phylum</0>
408
                                            <1>$dwc_dwcore_Phylum</1>
409
                                            <2>$dwc_terms_phylum</2>
410
                                        </_alt>
411
                                    </phylum>
412
                                    <species>
413
                                        <_alt>
414
                                            <0>$conceptual_darwin_2003_1_0_Species</0>
415
                                            <1>$dwc_dwcore_SpecificEpithet</1>
416
                                            <2>$dwc_terms_specificEpithet</2>
417
                                        </_alt>
418
                                    </species>
419 5263 aaronmk
                                    <subspecies>$conceptual_darwin_2003_1_0_Subspecies</subspecies>
420
                                    <taxonname>
421 5137 aaronmk
                                        <_alt>
422 5263 aaronmk
                                            <0>$dwc_dwcore_InfraspecificEpithet</0>
423
                                            <1>$dwc_terms_infraspecificEpithet</1>
424 5137 aaronmk
                                        </_alt>
425 5263 aaronmk
                                    </taxonname>
426 5137 aaronmk
                                    <taxonomicname>
427
                                        <_alt>
428
                                            <0>$conceptual_darwin_2003_1_0_ScientificName</0>
429
                                            <1>$dwc_dwcore_ScientificName</1>
430
                                            <2>$dwc_terms_scientificName</2>
431
                                        </_alt>
432
                                    </taxonomicname>
433 5225 aaronmk
                                </taxonconcept>
434
                            </taxonconcept_id>
435 4621 aaronmk
                            <determinationdate>
436
                                <_alt>
437
                                    <1><_date><date><_dateRangeStart><value>$dwc_terms_dateIdentified</value></_dateRangeStart></date></_date></1>
438
                                    <2>
439
                                        <_date>
440
                                            <day>
441
                                                <_nullIf>
442
                                                    <null>0</null>
443
                                                    <type>float</type>
444
                                                    <value>$conceptual_darwin_2003_1_0_DayIdentified</value>
445
                                                </_nullIf>
446
                                            </day>
447
                                            <month>
448
                                                <_nullIf>
449
                                                    <null>0</null>
450
                                                    <type>float</type>
451
                                                    <value>$conceptual_darwin_2003_1_0_MonthIdentified</value>
452
                                                </_nullIf>
453
                                            </month>
454
                                            <year>
455
                                                <_nullIf>
456
                                                    <null>0</null>
457
                                                    <type>float</type>
458
                                                    <value>$conceptual_darwin_2003_1_0_YearIdentified</value>
459
                                                </_nullIf>
460
                                            </year>
461
                                        </_date>
462
                                    </2>
463
                                </_alt>
464
                            </determinationdate>
465
                            <notes>$dwc_dwcore_Remarks</notes>
466
                        </taxondetermination>
467
                        <verbatimcollectorname>
468
                            <_alt>
469 4631 aaronmk
                                <0>$conceptual_darwin_2003_1_0_Collector</0>
470
                                <1>$dwc_dwcore_Collector</1>
471 4621 aaronmk
                                <2>$dwc_terms_recordedBy</2>
472
                            </_alt>
473
                        </verbatimcollectorname>
474
                    </taxonoccurrence>
475 4753 aaronmk
                    <waterdepth_m>
476 4621 aaronmk
                        <_avg>
477
                            <max>
478 4820 aaronmk
                                <_alt>
479
                                    <0>$conceptual_darwin_2003_1_0_MaximumDepth</0>
480
                                    <1>$dwc_dwcore_MaximumDepthInMeters</1>
481
                                    <2>$dwc_terms_maximumDepthInMeters</2>
482
                                </_alt>
483 4621 aaronmk
                            </max>
484
                            <min>
485 4820 aaronmk
                                <_alt>
486
                                    <0>$conceptual_darwin_2003_1_0_MinimumDepth</0>
487
                                    <1>$dwc_dwcore_MinimumDepthInMeters</1>
488
                                    <2>$dwc_terms_minimumDepthInMeters</2>
489
                                </_alt>
490 4621 aaronmk
                            </min>
491
                        </_avg>
492 4753 aaronmk
                    </waterdepth_m>
493 4621 aaronmk
                </locationevent>
494
                <locationnarrative>
495
                    <_alt>
496 4631 aaronmk
                        <0>$conceptual_darwin_2003_1_0_Locality</0>
497
                        <1>$dwc_dwcore_Locality</1>
498
                        <2>$dwc_terms_locality</2>
499 4621 aaronmk
                    </_alt>
500
                </locationnarrative>
501 4726 aaronmk
                <locationplace>
502 4727 aaronmk
                    <placepath_id>
503
                        <placepath>
504
                            <continent>
505 4726 aaronmk
                                <_alt>
506 4727 aaronmk
                                    <0>$conceptual_darwin_2003_1_0_ContinentOcean</0>
507
                                    <1>$dwc_dwcore_Continent</1>
508
                                    <2>$dwc_terms_continent</2>
509
                                </_alt>
510
                            </continent>
511
                            <country>
512
                                <_alt>
513
                                    <0>$conceptual_darwin_2003_1_0_Country</0>
514
                                    <1>$dwc_dwcore_Country</1>
515
                                    <2>$dwc_terms_country</2>
516
                                </_alt>
517
                            </country>
518
                            <county>
519
                                <_alt>
520 4726 aaronmk
                                    <0>$conceptual_darwin_2003_1_0_County</0>
521
                                    <1>$dwc_dwcore_County</1>
522
                                    <2>$dwc_terms_county</2>
523
                                </_alt>
524 4727 aaronmk
                            </county>
525
                            <stateprovince>
526
                                <_alt>
527
                                    <0>$conceptual_darwin_2003_1_0_StateProvince</0>
528
                                    <1>$dwc_dwcore_StateProvince</1>
529
                                    <2>$dwc_terms_stateProvince</2>
530
                                </_alt>
531
                            </stateprovince>
532
                        </placepath>
533
                    </placepath_id>
534 4726 aaronmk
                </locationplace>
535 4621 aaronmk
            </location>
536
        </path>
537
    </_simplifyPath>
538 3641 aaronmk
</VegBIEN>
539 5138 aaronmk
Inserted 32 new rows into database