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>$authorObsCode</authorlocationcode>
8 4726 aaronmk
                <locationevent>
9
                    <authoreventcode>$authorObsCode</authoreventcode>
10
                    <obsstartdate><_date><date>$obsStartDate</date></_date></obsstartdate>
11
                    <taxonoccurrence>
12 4789 aaronmk
                        <aggregateoccurrence><cover_fraction><_percent_to_fraction><value>$%cover</value></_percent_to_fraction></cover_fraction></aggregateoccurrence>
13 4726 aaronmk
                        <authortaxoncode>$currentTaxonName sec Weakley 2006</authortaxoncode>
14 5012 aaronmk
                        <taxondetermination>
15 5657 aaronmk
                            <taxonverbatim_id>
16
                                <taxonverbatim>
17
                                    <taxonlabel_id>
18 5608 aaronmk
                                        <taxonlabel>
19 5657 aaronmk
                                            <matched_label_id>
20
                                                <taxonlabel>
21 5953 aaronmk
                                                    <reference_id><reference><shortname>TNRS</shortname></reference></reference_id>
22 5657 aaronmk
                                                    <taxonomicname>$currentTaxonName sec Weakley 2006</taxonomicname>
23
                                                </taxonlabel>
24
                                            </matched_label_id>
25 5656 aaronmk
                                            <taxonomicname>$currentTaxonName sec Weakley 2006</taxonomicname>
26 5608 aaronmk
                                        </taxonlabel>
27 5657 aaronmk
                                    </taxonlabel_id>
28 5948 aaronmk
                                    <taxonname>$currentTaxonName sec Weakley 2006</taxonname>
29 5657 aaronmk
                                </taxonverbatim>
30
                            </taxonverbatim_id>
31 5012 aaronmk
                        </taxondetermination>
32 4726 aaronmk
                    </taxonoccurrence>
33
                </locationevent>
34
                <locationplace>
35 5855 aaronmk
                    <place_id>
36
                        <place>
37 5861 aaronmk
                            <coordinates_id>
38
                                <coordinates>
39
                                    <coordsaccuracy_deg><_noCV><value>$locationAccuracy-m</value></_noCV></coordsaccuracy_deg>
40
                                    <latitude_deg>
41
                                        <_nullIf>
42
                                            <null>0</null>
43
                                            <type>float</type>
44
                                            <value>$publicLatitude</value>
45
                                        </_nullIf>
46
                                    </latitude_deg>
47
                                    <longitude_deg>
48
                                        <_nullIf>
49
                                            <null>0</null>
50
                                            <type>float</type>
51
                                            <value>$publicLongitude</value>
52
                                        </_nullIf>
53
                                    </longitude_deg>
54
                                </coordinates>
55
                            </coordinates_id>
56 4727 aaronmk
                            <county>$county</county>
57 5958 aaronmk
                            <matched_place_id>
58
                                <place>
59
                                    <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
60
                                    <coordinates_id>
61
                                        <coordinates>
62 6123 aaronmk
                                            <reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
63 5969 aaronmk
                                            <latitude_deg>
64
                                                <_nullIf>
65
                                                    <null>0</null>
66
                                                    <type>float</type>
67
                                                    <value>$publicLatitude</value>
68
                                                </_nullIf>
69
                                            </latitude_deg>
70
                                            <longitude_deg>
71
                                                <_nullIf>
72
                                                    <null>0</null>
73
                                                    <type>float</type>
74
                                                    <value>$publicLongitude</value>
75
                                                </_nullIf>
76
                                            </longitude_deg>
77 5958 aaronmk
                                        </coordinates>
78
                                    </coordinates_id>
79
                                    <stateprovince>$state</stateprovince>
80
                                </place>
81
                            </matched_place_id>
82 4727 aaronmk
                            <stateprovince>$state</stateprovince>
83 5855 aaronmk
                        </place>
84
                    </place_id>
85 4726 aaronmk
                </locationplace>
86 4621 aaronmk
            </location>
87
        </path>
88
    </_simplifyPath>
89 3641 aaronmk
</VegBIEN>
90 6123 aaronmk
Inserted 22 new rows into database