Project

General

Profile

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