Project

General

Profile

1 4514 aaronmk
Put template:
2
<VegBIEN>
3 6403 aaronmk
    <_setDefault id="-1">
4 10866 aaronmk
        <source_id><source><shortname>VegBank.new</shortname></source></source_id>
5 4621 aaronmk
        <path>
6 6403 aaronmk
            <_simplifyPath>
7
                <next>parent_id</next>
8
                <path>
9
                    <location>
10 10943 aaronmk
                        <authorlocationcode>$locationName</authorlocationcode>
11
                        <sourceaccessioncode>$locationID</sourceaccessioncode>
12 10936 aaronmk
                        <accesslevel>$accessRights</accesslevel>
13 10943 aaronmk
                        <area_m2>$plotArea_m2</area_m2>
14
                        <elevation_m>$elevationInMeters</elevation_m>
15
                        <iscultivated><_locationnarrative_is_cultivated><locationnarrative>$locality</locationnarrative></_locationnarrative_is_cultivated></iscultivated>
16 6403 aaronmk
                        <landform>$landform</landform>
17 10943 aaronmk
                        <locationnarrative>$locality</locationnarrative>
18 6403 aaronmk
                        <locationplace>
19
                            <place_id>
20 5958 aaronmk
                                <place>
21
                                    <coordinates_id>
22
                                        <coordinates>
23 10938 aaronmk
                                            <coordsaccuracy_m><_noCV><value>$coordinateUncertaintyInMeters</value></_noCV></coordsaccuracy_m>
24 10943 aaronmk
                                            <footprintgeometry_dwc>$footprintWKT</footprintgeometry_dwc>
25 5969 aaronmk
                                            <latitude_deg>
26
                                                <_nullIf>
27
                                                    <null>0</null>
28
                                                    <type>float</type>
29 10943 aaronmk
                                                    <value>$decimalLatitude</value>
30 5969 aaronmk
                                                </_nullIf>
31
                                            </latitude_deg>
32
                                            <longitude_deg>
33
                                                <_nullIf>
34
                                                    <null>0</null>
35
                                                    <type>float</type>
36 10943 aaronmk
                                                    <value>$decimalLongitude</value>
37 5969 aaronmk
                                                </_nullIf>
38
                                            </longitude_deg>
39 5958 aaronmk
                                        </coordinates>
40
                                    </coordinates_id>
41 6403 aaronmk
                                    <continent>$continent</continent>
42 10682 aaronmk
                                    <country>$country</country>
43 6294 aaronmk
                                    <county>$county</county>
44 6403 aaronmk
                                    <matched_place_id>
45
                                        <place>
46
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
47
                                            <coordinates_id>
48
                                                <coordinates>
49
                                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>
50
                                                    <latitude_deg>
51
                                                        <_nullIf>
52
                                                            <null>0</null>
53
                                                            <type>float</type>
54 10943 aaronmk
                                                            <value>$decimalLatitude</value>
55 6403 aaronmk
                                                        </_nullIf>
56
                                                    </latitude_deg>
57
                                                    <longitude_deg>
58
                                                        <_nullIf>
59
                                                            <null>0</null>
60
                                                            <type>float</type>
61 10943 aaronmk
                                                            <value>$decimalLongitude</value>
62 6403 aaronmk
                                                        </_nullIf>
63
                                                    </longitude_deg>
64
                                                </coordinates>
65
                                            </coordinates_id>
66 10682 aaronmk
                                            <country>$country</country>
67 6403 aaronmk
                                            <county>$county</county>
68 10943 aaronmk
                                            <stateprovince>$stateProvince</stateprovince>
69 6403 aaronmk
                                        </place>
70
                                    </matched_place_id>
71 10943 aaronmk
                                    <stateprovince>$stateProvince</stateprovince>
72 5958 aaronmk
                                </place>
73 6403 aaronmk
                            </place_id>
74
                        </locationplace>
75 10943 aaronmk
                        <parent_id><location><sourceaccessioncode>$parentLocationID</sourceaccessioncode></location></parent_id>
76 6403 aaronmk
                        <slopeaspect_deg>
77
                            <_alt>
78 10943 aaronmk
                                <1><_compass><value>$slopeAspect</value></_compass></1>
79 6403 aaronmk
                                <2>
80
                                    <_avg>
81 10943 aaronmk
                                        <1>$minSlopeAspect</1>
82
                                        <2>$maxSlopeAspect</2>
83 6403 aaronmk
                                    </_avg>
84
                                </2>
85
                            </_alt>
86
                        </slopeaspect_deg>
87
                        <slopegradient_fraction>
88
                            <_alt>
89 10943 aaronmk
                                <1>$slopeGradient</1>
90 6403 aaronmk
                                <2>
91
                                    <_avg>
92 10943 aaronmk
                                        <1>$minSlopeGradient</1>
93
                                        <2>$maxSlopeGradient</2>
94 6403 aaronmk
                                    </_avg>
95
                                </2>
96
                            </_alt>
97
                        </slopegradient_fraction>
98
                    </location>
99
                </path>
100
            </_simplifyPath>
101 4621 aaronmk
        </path>
102 6403 aaronmk
    </_setDefault>
103 4514 aaronmk
</VegBIEN>
104 10676 aaronmk
Inserted 14 new rows into database