Project

General

Profile

1
Put template:
2
<VegBIEN>
3
    <_setDefault id="-1">
4
        <source_id><source><shortname>Madidi.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
                        <area_m2><_ha_to_m2><value>$plotArea_ha</value></_ha_to_m2></area_m2>
13
                        <elevation_m>
14
                            <_avg>
15
                                <1>$minimumElevationInMeters</1>
16
                                <2>$maximumElevationInMeters</2>
17
                            </_avg>
18
                        </elevation_m>
19
                        <iscultivated><_locationnarrative_is_cultivated><locationnarrative>$locality</locationnarrative></_locationnarrative_is_cultivated></iscultivated>
20
                        <landform>$landform</landform>
21
                        <locationnarrative>
22
                            <_merge>
23
                                <1>$locality</1>
24
                                <4>$locationRemarks</4>
25
                            </_merge>
26
                        </locationnarrative>
27
                        <locationplace>
28
                            <place_id>
29
                                <place>
30
                                    <coordinates_id>
31
                                        <coordinates>
32
                                            <latitude_deg>
33
                                                <_nullIf>
34
                                                    <null>0</null>
35
                                                    <type>float</type>
36
                                                    <value>$decimalLatitude</value>
37
                                                </_nullIf>
38
                                            </latitude_deg>
39
                                            <longitude_deg>
40
                                                <_nullIf>
41
                                                    <null>0</null>
42
                                                    <type>float</type>
43
                                                    <value>$decimalLongitude</value>
44
                                                </_nullIf>
45
                                            </longitude_deg>
46
                                        </coordinates>
47
                                    </coordinates_id>
48
                                    <country>$country</country>
49
                                    <county>$county</county>
50
                                    <matched_place_id>
51
                                        <place>
52
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
53
                                            <coordinates_id>
54
                                                <coordinates>
55
                                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>
56
                                                    <latitude_deg>
57
                                                        <_nullIf>
58
                                                            <null>0</null>
59
                                                            <type>float</type>
60
                                                            <value>$decimalLatitude</value>
61
                                                        </_nullIf>
62
                                                    </latitude_deg>
63
                                                    <longitude_deg>
64
                                                        <_nullIf>
65
                                                            <null>0</null>
66
                                                            <type>float</type>
67
                                                            <value>$decimalLongitude</value>
68
                                                        </_nullIf>
69
                                                    </longitude_deg>
70
                                                </coordinates>
71
                                            </coordinates_id>
72
                                            <country>$country</country>
73
                                            <county>$county</county>
74
                                            <stateprovince>$stateProvince</stateprovince>
75
                                        </place>
76
                                    </matched_place_id>
77
                                    <stateprovince>$stateProvince</stateprovince>
78
                                </place>
79
                            </place_id>
80
                        </locationplace>
81
                    </location>
82
                </path>
83
            </_simplifyPath>
84
        </path>
85
    </_setDefault>
86
</VegBIEN>
87
Inserted 14 new rows into database
(7-7/8)