Project

General

Profile

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