Project

General

Profile

1
Put template:
2
<VegBIEN>
3
    <_simplifyPath id="-1">
4
        <next>parent_id</next>
5
        <path>
6
            <location>
7
                <authorlocationcode>$authorObsCode</authorlocationcode>
8
                <locationdetermination>
9
                    <coordsaccuracy><_noCV><value>$locationAccuracy-m</value></_noCV></coordsaccuracy>
10
                    <latitude>
11
                        <_nullIf>
12
                            <null>0</null>
13
                            <type>float</type>
14
                            <value>$publicLatitude</value>
15
                        </_nullIf>
16
                    </latitude>
17
                    <longitude>
18
                        <_nullIf>
19
                            <null>0</null>
20
                            <type>float</type>
21
                            <value>$publicLongitude</value>
22
                        </_nullIf>
23
                    </longitude>
24
                    <namedplace_id>
25
                        <_simplifyPath>
26
                            <next>parent_id</next>
27
                            <path>
28
                                <namedplace>
29
                                    <rank>county</rank>
30
                                    <placename>$county</placename>
31
                                    <parent_id>
32
                                        <namedplace>
33
                                            <rank>stateProvince</rank>
34
                                            <placename>$state</placename>
35
                                        </namedplace>
36
                                    </parent_id>
37
                                </namedplace>
38
                            </path>
39
                        </_simplifyPath>
40
                    </namedplace_id>
41
                </locationdetermination>
42
                <locationevent>
43
                    <authoreventcode>$authorObsCode</authoreventcode>
44
                    <obsstartdate><_date><date>$obsStartDate</date></_date></obsstartdate>
45
                    <taxonoccurrence>
46
                        <aggregateoccurrence><cover>$%cover</cover></aggregateoccurrence>
47
                        <authortaxoncode>$currentTaxonName sec Weakley 2006</authortaxoncode>
48
                        <taxondetermination>
49
                            <plantconcept_id>
50
                                <plantconcept>
51
                                    <plantname_id>
52
                                        <_simplifyPath>
53
                                            <next>parent_id</next>
54
                                            <path>
55
                                                <plantname>
56
                                                    <rank>binomial</rank>
57
                                                    <plantname>$currentTaxonName sec Weakley 2006</plantname>
58
                                                </plantname>
59
                                            </path>
60
                                        </_simplifyPath>
61
                                    </plantname_id>
62
                                </plantconcept>
63
                            </plantconcept_id>
64
                        </taxondetermination>
65
                    </taxonoccurrence>
66
                </locationevent>
67
            </location>
68
        </path>
69
    </_simplifyPath>
70
</VegBIEN>
71
Inserted 16 new rows into database
(8-8/9)