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 4621 aaronmk
                        <_alt>
74
                            <1>
75
                                <_nullIf>
76
                                    <null>0</null>
77
                                    <type>float</type>
78
                                    <value>
79
                                        <_alt>
80
                                            <0>$dwc_geospatial_DecimalLatitude</0>
81
                                            <1>$dwc_terms_decimalLatitude</1>
82
                                        </_alt>
83
                                    </value>
84
                                </_nullIf>
85
                            </1>
86
                            <2>
87
                                <_nullIf>
88
                                    <null>0</null>
89
                                    <type>float</type>
90
                                    <value>
91
                                        <_alt>
92
                                            <0>$conceptual_darwin_2003_1_0_Latitude</0>
93
                                            <1>$dwc_geospatial_VerbatimLatitude</1>
94
                                            <2>$dwc_terms_verbatimLatitude</2>
95
                                        </_alt>
96
                                    </value>
97
                                </_nullIf>
98
                            </2>
99
                        </_alt>
100 4753 aaronmk
                    </latitude_deg>
101
                    <longitude_deg>
102 4621 aaronmk
                        <_alt>
103
                            <1>
104
                                <_nullIf>
105
                                    <null>0</null>
106
                                    <type>float</type>
107
                                    <value>
108
                                        <_alt>
109
                                            <0>$dwc_geospatial_DecimalLongitude</0>
110
                                            <1>$dwc_terms_decimalLongitude</1>
111
                                        </_alt>
112
                                    </value>
113
                                </_nullIf>
114
                            </1>
115
                            <2>
116
                                <_nullIf>
117
                                    <null>0</null>
118
                                    <type>float</type>
119
                                    <value>
120
                                        <_alt>
121
                                            <0>$conceptual_darwin_2003_1_0_Longitude</0>
122
                                            <1>$dwc_geospatial_VerbatimLongitude</1>
123
                                            <2>$dwc_terms_verbatimLongitude</2>
124
                                        </_alt>
125
                                    </value>
126
                                </_nullIf>
127
                            </2>
128
                        </_alt>
129 4753 aaronmk
                    </longitude_deg>
130 4726 aaronmk
                </locationcoords>
131 4621 aaronmk
                <locationevent>
132
                    <taxonoccurrence>
133
                        <aggregateoccurrence>
134
                            <collectiondate>
135
                                <_date>
136
                                    <day>
137
                                        <_nullIf>
138
                                            <null>0</null>
139
                                            <type>float</type>
140
                                            <value>$conceptual_darwin_2003_1_0_DayCollected</value>
141
                                        </_nullIf>
142
                                    </day>
143
                                    <month>
144
                                        <_nullIf>
145
                                            <null>0</null>
146
                                            <type>float</type>
147
                                            <value>$conceptual_darwin_2003_1_0_MonthCollected</value>
148
                                        </_nullIf>
149
                                    </month>
150
                                    <year>
151
                                        <_nullIf>
152
                                            <null>0</null>
153
                                            <type>float</type>
154
                                            <value>$conceptual_darwin_2003_1_0_YearCollected</value>
155
                                        </_nullIf>
156
                                    </year>
157
                                </_date>
158
                            </collectiondate>
159
                            <count>
160
                                <_alt>
161 4631 aaronmk
                                    <0>$conceptual_darwin_2003_1_0_IndividualCount</0>
162
                                    <1>$dwc_curatorial_IndividualCount</1>
163
                                    <2>$dwc_terms_individualCount</2>
164 4621 aaronmk
                                </_alt>
165
                            </count>
166
                            <notes>$conceptual_darwin_2003_1_0_Notes</notes>
167
                            <plantobservation>
168
                                <collectionnumber>
169 4080 aaronmk
                                    <_alt>
170 4621 aaronmk
                                        <1>$dwc_terms_recordNumber</1>
171
                                        <2>
172
                                            <_alt>
173 4631 aaronmk
                                                <0>$conceptual_darwin_2003_1_0_FieldNumber</0>
174
                                                <1>$dwc_curatorial_FieldNumber</1>
175
                                                <2>$dwc_terms_fieldNumber</2>
176 4621 aaronmk
                                            </_alt>
177
                                        </2>
178
                                        <3>
179
                                            <_alt>
180 4631 aaronmk
                                                <0>$conceptual_darwin_2003_1_0_CollectorNumber</0>
181
                                                <1>$dwc_curatorial_CollectorNumber</1>
182 4621 aaronmk
                                            </_alt>
183
                                        </3>
184 4080 aaronmk
                                    </_alt>
185 4621 aaronmk
                                </collectionnumber>
186
                                <definedvalue fkey="tablerecord_id">
187
                                    <userdefined_id>
188
                                        <userdefined>
189
                                            <tablename>plantobservation</tablename>
190
                                            <userdefinedname>sex</userdefinedname>
191
                                        </userdefined>
192
                                    </userdefined_id>
193
                                    <definedvalue>
194 4068 aaronmk
                                        <_alt>
195 4631 aaronmk
                                            <0>$conceptual_darwin_2003_1_0_Sex</0>
196
                                            <1>$dwc_dwcore_Sex</1>
197
                                            <2>$dwc_terms_sex</2>
198 4068 aaronmk
                                        </_alt>
199 4621 aaronmk
                                    </definedvalue>
200
                                </definedvalue>
201
                                <specimenreplicate>
202
                                    <catalognumber_dwc>
203 4068 aaronmk
                                        <_alt>
204 4631 aaronmk
                                            <0>$conceptual_darwin_2003_1_0_CatalogNumber</0>
205
                                            <1>$dwc_dwcore_CatalogNumber</1>
206
                                            <2>$dwc_terms_catalogNumber</2>
207 4068 aaronmk
                                        </_alt>
208 4621 aaronmk
                                    </catalognumber_dwc>
209
                                    <collectioncode_dwc>
210
                                        <_join>
211
                                            <1>
212
                                                <_alt>
213 4631 aaronmk
                                                    <0>$conceptual_darwin_2003_1_0_CollectionCode</0>
214
                                                    <1>$dwc_dwcore_CollectionCode</1>
215
                                                    <2>$dwc_terms_collectionCode</2>
216 4621 aaronmk
                                                </_alt>
217
                                            </1>
218
                                            <2>$dwc_terms_collectionID</2>
219
                                        </_join>
220
                                    </collectioncode_dwc>
221
                                    <institution_id>
222
                                        <party>
223
                                            <organizationname>
224
                                                <_alt>
225 4631 aaronmk
                                                    <0>$conceptual_darwin_2003_1_0_InstitutionCode</0>
226
                                                    <1>$dwc_dwcore_InstitutionCode</1>
227
                                                    <2>$dwc_terms_institutionCode</2>
228 4621 aaronmk
                                                </_alt>
229
                                            </organizationname>
230
                                        </party>
231
                                    </institution_id>
232
                                    <sourceaccessioncode>$dwc_dwcore_GlobalUniqueIdentifier</sourceaccessioncode>
233
                                </specimenreplicate>
234
                            </plantobservation>
235
                        </aggregateoccurrence>
236
                        <authortaxoncode>
237 4007 aaronmk
                            <_alt>
238 4833 aaronmk
                                <1>$dwc_terms_recordNumber</1>
239
                                <2>
240 4621 aaronmk
                                    <_alt>
241 4833 aaronmk
                                        <0>$conceptual_darwin_2003_1_0_FieldNumber</0>
242
                                        <1>$dwc_curatorial_FieldNumber</1>
243
                                        <2>$dwc_terms_fieldNumber</2>
244 4621 aaronmk
                                    </_alt>
245 4833 aaronmk
                                </2>
246
                                <3>
247 4080 aaronmk
                                    <_alt>
248 4833 aaronmk
                                        <0>$conceptual_darwin_2003_1_0_CollectorNumber</0>
249
                                        <1>$dwc_curatorial_CollectorNumber</1>
250 4080 aaronmk
                                    </_alt>
251 4833 aaronmk
                                </3>
252 4007 aaronmk
                            </_alt>
253 4621 aaronmk
                        </authortaxoncode>
254 4834 aaronmk
                        <sourceaccessioncode>$dwc_dwcore_GlobalUniqueIdentifier</sourceaccessioncode>
255 4621 aaronmk
                        <taxondetermination>
256
                            <party_id>
257
                                <party>
258
                                    <givenname>
259
                                        <_namePart>
260
                                            <first>
261 4068 aaronmk
                                                <_alt>
262 4631 aaronmk
                                                    <0>$conceptual_darwin_2003_1_0_IdentifiedBy</0>
263
                                                    <1>$dwc_curatorial_IdentifiedBy</1>
264
                                                    <2>$dwc_terms_identifiedBy</2>
265 4068 aaronmk
                                                </_alt>
266 4621 aaronmk
                                            </first>
267
                                        </_namePart>
268
                                    </givenname>
269
                                    <middlename>
270
                                        <_namePart>
271
                                            <middle>
272
                                                <_alt>
273 4631 aaronmk
                                                    <0>$conceptual_darwin_2003_1_0_IdentifiedBy</0>
274
                                                    <1>$dwc_curatorial_IdentifiedBy</1>
275
                                                    <2>$dwc_terms_identifiedBy</2>
276 4621 aaronmk
                                                </_alt>
277
                                            </middle>
278
                                        </_namePart>
279
                                    </middlename>
280
                                    <surname>
281
                                        <_namePart>
282
                                            <last>
283
                                                <_alt>
284 4631 aaronmk
                                                    <0>$conceptual_darwin_2003_1_0_IdentifiedBy</0>
285
                                                    <1>$dwc_curatorial_IdentifiedBy</1>
286
                                                    <2>$dwc_terms_identifiedBy</2>
287 4621 aaronmk
                                                </_alt>
288
                                            </last>
289
                                        </_namePart>
290
                                    </surname>
291
                                </party>
292
                            </party_id>
293 4718 aaronmk
                            <taxonpath_id>
294
                                <taxonpath>
295 4703 aaronmk
                                    <class>
296
                                        <_alt>
297
                                            <0>$conceptual_darwin_2003_1_0_Class</0>
298
                                            <1>$dwc_dwcore_Class</1>
299
                                            <2>$dwc_terms_class</2>
300
                                        </_alt>
301
                                    </class>
302
                                    <family>
303
                                        <_alt>
304
                                            <0>$conceptual_darwin_2003_1_0_Family</0>
305
                                            <1>$dwc_dwcore_Family</1>
306
                                            <2>$dwc_terms_family</2>
307
                                        </_alt>
308
                                    </family>
309
                                    <genus>
310
                                        <_alt>
311
                                            <0>$conceptual_darwin_2003_1_0_Genus</0>
312
                                            <1>$dwc_dwcore_Genus</1>
313
                                            <2>$dwc_terms_genus</2>
314
                                        </_alt>
315
                                    </genus>
316
                                    <kingdom>
317
                                        <_alt>
318
                                            <0>$conceptual_darwin_2003_1_0_Kingdom</0>
319
                                            <1>$dwc_dwcore_Kingdom</1>
320
                                            <2>$dwc_terms_kingdom</2>
321
                                        </_alt>
322
                                    </kingdom>
323
                                    <order>
324
                                        <_alt>
325
                                            <0>$conceptual_darwin_2003_1_0_Order</0>
326
                                            <1>$dwc_dwcore_Order</1>
327
                                            <2>$dwc_terms_order</2>
328
                                        </_alt>
329
                                    </order>
330
                                    <phylum>
331
                                        <_alt>
332
                                            <0>$conceptual_darwin_2003_1_0_Phylum</0>
333
                                            <1>$dwc_dwcore_Phylum</1>
334
                                            <2>$dwc_terms_phylum</2>
335
                                        </_alt>
336
                                    </phylum>
337
                                    <scientificname>
338
                                        <_alt>
339
                                            <0>$conceptual_darwin_2003_1_0_ScientificName</0>
340
                                            <1>$dwc_dwcore_ScientificName</1>
341
                                            <2>$dwc_terms_scientificName</2>
342
                                        </_alt>
343
                                    </scientificname>
344
                                    <scientificnameauthor>
345
                                        <_alt>
346
                                            <1>$dwc_terms_scientificNameAuthorship</1>
347
                                            <2>$conceptual_darwin_2003_1_0_ScientificNameAuthor</2>
348
                                            <3>$dwc_dwcore_AuthorYearOfScientificName</3>
349
                                        </_alt>
350
                                    </scientificnameauthor>
351
                                    <species>
352
                                        <_alt>
353
                                            <0>$conceptual_darwin_2003_1_0_Species</0>
354
                                            <1>$dwc_dwcore_SpecificEpithet</1>
355
                                            <2>$dwc_terms_specificEpithet</2>
356
                                        </_alt>
357
                                    </species>
358
                                    <subspecies>
359
                                        <_alt>
360 4750 aaronmk
                                            <1>$conceptual_darwin_2003_1_0_Subspecies</1>
361
                                            <2>
362
                                                <_alt>
363
                                                    <0>$dwc_dwcore_InfraspecificEpithet</0>
364
                                                    <1>$dwc_terms_infraspecificEpithet</1>
365
                                                </_alt>
366
                                            </2>
367 4703 aaronmk
                                        </_alt>
368
                                    </subspecies>
369 4718 aaronmk
                                </taxonpath>
370
                            </taxonpath_id>
371 4621 aaronmk
                            <determinationdate>
372
                                <_alt>
373
                                    <1><_date><date><_dateRangeStart><value>$dwc_terms_dateIdentified</value></_dateRangeStart></date></_date></1>
374
                                    <2>
375
                                        <_date>
376
                                            <day>
377
                                                <_nullIf>
378
                                                    <null>0</null>
379
                                                    <type>float</type>
380
                                                    <value>$conceptual_darwin_2003_1_0_DayIdentified</value>
381
                                                </_nullIf>
382
                                            </day>
383
                                            <month>
384
                                                <_nullIf>
385
                                                    <null>0</null>
386
                                                    <type>float</type>
387
                                                    <value>$conceptual_darwin_2003_1_0_MonthIdentified</value>
388
                                                </_nullIf>
389
                                            </month>
390
                                            <year>
391
                                                <_nullIf>
392
                                                    <null>0</null>
393
                                                    <type>float</type>
394
                                                    <value>$conceptual_darwin_2003_1_0_YearIdentified</value>
395
                                                </_nullIf>
396
                                            </year>
397
                                        </_date>
398
                                    </2>
399
                                </_alt>
400
                            </determinationdate>
401
                            <notes>$dwc_dwcore_Remarks</notes>
402
                        </taxondetermination>
403
                        <verbatimcollectorname>
404
                            <_alt>
405 4631 aaronmk
                                <0>$conceptual_darwin_2003_1_0_Collector</0>
406
                                <1>$dwc_dwcore_Collector</1>
407 4621 aaronmk
                                <2>$dwc_terms_recordedBy</2>
408
                            </_alt>
409
                        </verbatimcollectorname>
410
                    </taxonoccurrence>
411 4753 aaronmk
                    <waterdepth_m>
412 4621 aaronmk
                        <_avg>
413
                            <max>
414 4820 aaronmk
                                <_alt>
415
                                    <0>$conceptual_darwin_2003_1_0_MaximumDepth</0>
416
                                    <1>$dwc_dwcore_MaximumDepthInMeters</1>
417
                                    <2>$dwc_terms_maximumDepthInMeters</2>
418
                                </_alt>
419 4621 aaronmk
                            </max>
420
                            <min>
421 4820 aaronmk
                                <_alt>
422
                                    <0>$conceptual_darwin_2003_1_0_MinimumDepth</0>
423
                                    <1>$dwc_dwcore_MinimumDepthInMeters</1>
424
                                    <2>$dwc_terms_minimumDepthInMeters</2>
425
                                </_alt>
426 4621 aaronmk
                            </min>
427
                        </_avg>
428 4753 aaronmk
                    </waterdepth_m>
429 4621 aaronmk
                </locationevent>
430
                <locationnarrative>
431
                    <_alt>
432 4631 aaronmk
                        <0>$conceptual_darwin_2003_1_0_Locality</0>
433
                        <1>$dwc_dwcore_Locality</1>
434
                        <2>$dwc_terms_locality</2>
435 4621 aaronmk
                    </_alt>
436
                </locationnarrative>
437 4726 aaronmk
                <locationplace>
438 4727 aaronmk
                    <placepath_id>
439
                        <placepath>
440
                            <continent>
441 4726 aaronmk
                                <_alt>
442 4727 aaronmk
                                    <0>$conceptual_darwin_2003_1_0_ContinentOcean</0>
443
                                    <1>$dwc_dwcore_Continent</1>
444
                                    <2>$dwc_terms_continent</2>
445
                                </_alt>
446
                            </continent>
447
                            <country>
448
                                <_alt>
449
                                    <0>$conceptual_darwin_2003_1_0_Country</0>
450
                                    <1>$dwc_dwcore_Country</1>
451
                                    <2>$dwc_terms_country</2>
452
                                </_alt>
453
                            </country>
454
                            <county>
455
                                <_alt>
456 4726 aaronmk
                                    <0>$conceptual_darwin_2003_1_0_County</0>
457
                                    <1>$dwc_dwcore_County</1>
458
                                    <2>$dwc_terms_county</2>
459
                                </_alt>
460 4727 aaronmk
                            </county>
461
                            <stateprovince>
462
                                <_alt>
463
                                    <0>$conceptual_darwin_2003_1_0_StateProvince</0>
464
                                    <1>$dwc_dwcore_StateProvince</1>
465
                                    <2>$dwc_terms_stateProvince</2>
466
                                </_alt>
467
                            </stateprovince>
468
                        </placepath>
469
                    </placepath_id>
470 4726 aaronmk
                </locationplace>
471 4621 aaronmk
            </location>
472
        </path>
473
    </_simplifyPath>
474 3641 aaronmk
</VegBIEN>
475 4727 aaronmk
Inserted 29 new rows into database