Project

General

Profile

1 3641 aaronmk
Put template:
2
<VegBIEN>
3 6403 aaronmk
    <_setDefault id="-1">
4
        <col>source_id</col>
5
        <value><source><shortname>CVS</shortname></source></value>
6 4621 aaronmk
        <path>
7 6403 aaronmk
            <_simplifyPath>
8
                <next>parent_id</next>
9
                <path>
10
                    <location>
11
                        <authorlocationcode>$authorObsCode</authorlocationcode>
12
                        <locationevent>
13
                            <authoreventcode>$authorObsCode</authoreventcode>
14
                            <obsstartdate>$obsStartDate</obsstartdate>
15
                            <taxonoccurrence>
16
                                <aggregateoccurrence><cover_fraction><_percent_to_fraction><value>$%cover</value></_percent_to_fraction></cover_fraction></aggregateoccurrence>
17
                                <authortaxoncode>$currentTaxonName sec Weakley 2006</authortaxoncode>
18
                                <taxondetermination>
19
                                    <taxonverbatim_id>
20
                                        <taxonverbatim>
21
                                            <taxonlabel_id>
22 5657 aaronmk
                                                <taxonlabel>
23 6403 aaronmk
                                                    <matched_label_id>
24
                                                        <taxonlabel>
25
                                                            <source_id><source><shortname>TNRS</shortname></source></source_id>
26
                                                            <taxonomicname>$currentTaxonName sec Weakley 2006</taxonomicname>
27
                                                        </taxonlabel>
28
                                                    </matched_label_id>
29 5657 aaronmk
                                                    <taxonomicname>$currentTaxonName sec Weakley 2006</taxonomicname>
30
                                                </taxonlabel>
31 6403 aaronmk
                                            </taxonlabel_id>
32
                                            <taxonname>$currentTaxonName sec Weakley 2006</taxonname>
33
                                        </taxonverbatim>
34
                                    </taxonverbatim_id>
35
                                </taxondetermination>
36
                            </taxonoccurrence>
37
                        </locationevent>
38
                        <locationplace>
39
                            <place_id>
40 5958 aaronmk
                                <place>
41
                                    <coordinates_id>
42
                                        <coordinates>
43 6403 aaronmk
                                            <coordsaccuracy_m><_noCV><value>$locationAccuracy-m</value></_noCV></coordsaccuracy_m>
44 5969 aaronmk
                                            <latitude_deg>
45
                                                <_nullIf>
46
                                                    <null>0</null>
47
                                                    <type>float</type>
48
                                                    <value>$publicLatitude</value>
49
                                                </_nullIf>
50
                                            </latitude_deg>
51
                                            <longitude_deg>
52
                                                <_nullIf>
53
                                                    <null>0</null>
54
                                                    <type>float</type>
55
                                                    <value>$publicLongitude</value>
56
                                                </_nullIf>
57
                                            </longitude_deg>
58 5958 aaronmk
                                        </coordinates>
59
                                    </coordinates_id>
60 6294 aaronmk
                                    <county>$county</county>
61 6403 aaronmk
                                    <matched_place_id>
62
                                        <place>
63
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
64
                                            <coordinates_id>
65
                                                <coordinates>
66
                                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>
67
                                                    <latitude_deg>
68
                                                        <_nullIf>
69
                                                            <null>0</null>
70
                                                            <type>float</type>
71
                                                            <value>$publicLatitude</value>
72
                                                        </_nullIf>
73
                                                    </latitude_deg>
74
                                                    <longitude_deg>
75
                                                        <_nullIf>
76
                                                            <null>0</null>
77
                                                            <type>float</type>
78
                                                            <value>$publicLongitude</value>
79
                                                        </_nullIf>
80
                                                    </longitude_deg>
81
                                                </coordinates>
82
                                            </coordinates_id>
83
                                            <county>$county</county>
84
                                            <stateprovince>$state</stateprovince>
85
                                        </place>
86
                                    </matched_place_id>
87 5958 aaronmk
                                    <stateprovince>$state</stateprovince>
88
                                </place>
89 6403 aaronmk
                            </place_id>
90
                        </locationplace>
91
                    </location>
92
                </path>
93
            </_simplifyPath>
94 4621 aaronmk
        </path>
95 6403 aaronmk
    </_setDefault>
96 3641 aaronmk
</VegBIEN>
97 6123 aaronmk
Inserted 22 new rows into database