Project

General

Profile

1 11396 aaronmk
<!--put template-->
2 4276 aaronmk
<VegBIEN>
3 6403 aaronmk
    <_setDefault id="-1">
4 10866 aaronmk
        <source_id><source><shortname>CTFS.new</shortname></source></source_id>
5 4621 aaronmk
        <path>
6 6403 aaronmk
            <_simplifyPath>
7
                <next>parent_id</next>
8
                <path>
9
                    <location>
10 10419 aaronmk
                        <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>$elevationInMeters</elevation_m>
14
                        <iscultivated><_locationnarrative_is_cultivated><locationnarrative>$locality</locationnarrative></_locationnarrative_is_cultivated></iscultivated>
15 6403 aaronmk
                        <locationnarrative>
16 10394 aaronmk
                            <_merge>
17 10419 aaronmk
                                <1>$locality</1>
18
                                <4>$locationRemarks</4>
19 10394 aaronmk
                            </_merge>
20 6403 aaronmk
                        </locationnarrative>
21
                        <locationplace>
22
                            <place_id>
23 5958 aaronmk
                                <place>
24
                                    <coordinates_id>
25
                                        <coordinates>
26 10419 aaronmk
                                            <footprintgeometry_dwc>$footprintWKT</footprintgeometry_dwc>
27 5969 aaronmk
                                            <latitude_deg>
28
                                                <_nullIf>
29
                                                    <null>0</null>
30
                                                    <type>float</type>
31 10419 aaronmk
                                                    <value>$decimalLatitude</value>
32 5969 aaronmk
                                                </_nullIf>
33
                                            </latitude_deg>
34
                                            <longitude_deg>
35
                                                <_nullIf>
36
                                                    <null>0</null>
37
                                                    <type>float</type>
38 10419 aaronmk
                                                    <value>$decimalLongitude</value>
39 5969 aaronmk
                                                </_nullIf>
40
                                            </longitude_deg>
41 5958 aaronmk
                                        </coordinates>
42
                                    </coordinates_id>
43 10419 aaronmk
                                    <country>$country</country>
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 10419 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 10419 aaronmk
                                                            <value>$decimalLongitude</value>
62 6403 aaronmk
                                                        </_nullIf>
63
                                                    </longitude_deg>
64
                                                </coordinates>
65
                                            </coordinates_id>
66 10419 aaronmk
                                            <country>$country</country>
67 6403 aaronmk
                                        </place>
68
                                    </matched_place_id>
69 5958 aaronmk
                                </place>
70 6403 aaronmk
                            </place_id>
71
                        </locationplace>
72
                    </location>
73
                </path>
74
            </_simplifyPath>
75 4621 aaronmk
        </path>
76 6403 aaronmk
    </_setDefault>
77 4276 aaronmk
</VegBIEN>
78 5958 aaronmk
Inserted 14 new rows into database