Project

General

Profile

1 4514 aaronmk
Put template:
2
<VegBIEN>
3 4621 aaronmk
    <_simplifyPath id="-1">
4
        <next>parent_id</next>
5
        <path>
6
            <location>
7
                <authorlocationcode>$authorplotcode</authorlocationcode>
8
                <sourceaccessioncode>$plot_id</sourceaccessioncode>
9 4753 aaronmk
                <area_m2>$area</area_m2>
10 4810 aaronmk
                <elevation_m>$elevation</elevation_m>
11 4621 aaronmk
                <landform>$landform</landform>
12 4726 aaronmk
                <locationcoords>
13 4753 aaronmk
                    <coordsaccuracy_deg><_noCV><value>$locationaccuracy</value></_noCV></coordsaccuracy_deg>
14 4621 aaronmk
                    <footprintgeometry_dwc>$shape</footprintgeometry_dwc>
15 4753 aaronmk
                    <latitude_deg>
16 4621 aaronmk
                        <_nullIf>
17
                            <null>0</null>
18
                            <type>float</type>
19
                            <value>$latitude</value>
20
                        </_nullIf>
21 4753 aaronmk
                    </latitude_deg>
22
                    <longitude_deg>
23 4621 aaronmk
                        <_nullIf>
24
                            <null>0</null>
25
                            <type>float</type>
26
                            <value>$longitude</value>
27
                        </_nullIf>
28 4753 aaronmk
                    </longitude_deg>
29 4726 aaronmk
                </locationcoords>
30
                <locationnarrative>$locationnarrative</locationnarrative>
31
                <locationplace>
32 4727 aaronmk
                    <placepath_id>
33
                        <placepath>
34
                            <continent>$continent</continent>
35
                            <country>
36
                                <_alt>
37
                                    <0>$area|country|territory</0>
38
                                    <1>$country</1>
39
                                </_alt>
40
                            </country>
41
                            <county>$county</county>
42
                            <stateprovince>
43
                                <_alt>
44
                                    <0>$region|state|province</0>
45
                                    <1>$stateprovince</1>
46
                                </_alt>
47
                            </stateprovince>
48
                        </placepath>
49
                    </placepath_id>
50 4726 aaronmk
                </locationplace>
51 4855 aaronmk
                <parent_id><location><sourceaccessioncode>$parent_id</sourceaccessioncode></location></parent_id>
52 4753 aaronmk
                <slopeaspect_deg>
53 4621 aaronmk
                    <_alt>
54
                        <1><_compass><value>$slopeaspect</value></_compass></1>
55
                        <2>
56
                            <_avg>
57
                                <max>$maxslopeaspect</max>
58
                                <min>$minslopeaspect</min>
59
                            </_avg>
60
                        </2>
61
                    </_alt>
62 4753 aaronmk
                </slopeaspect_deg>
63 4786 aaronmk
                <slopegradient_fraction>
64 4621 aaronmk
                    <_alt>
65
                        <1>$slopegradient</1>
66
                        <2>
67
                            <_avg>
68
                                <max>$maxslopegradient</max>
69
                                <min>$minslopegradient</min>
70
                            </_avg>
71
                        </2>
72
                    </_alt>
73 4786 aaronmk
                </slopegradient_fraction>
74 4621 aaronmk
            </location>
75
        </path>
76
    </_simplifyPath>
77 4514 aaronmk
</VegBIEN>
78 4726 aaronmk
Inserted 9 new rows into database