Project

General

Profile

1
Put template:
2
<VegBIEN>
3
    <location id="-1">
4
        <sourceaccessioncode>$PlotID</sourceaccessioncode>
5
        <area>$SizeOfSite</area>
6
        <authorlocationcode>$PlotName</authorlocationcode>
7
        <elevation>
8
            <_replace>
9
                <\bca\.?></\bca\.?>
10
                <value>$Elevation</value>
11
            </_replace>
12
        </elevation>
13
        <locationdetermination>
14
            <footprintgeometry_dwc>$ShapeOfSite</footprintgeometry_dwc>
15
            <latitude>
16
                <_nullIf>
17
                    <null>0</null>
18
                    <type>float</type>
19
                    <value>$Latitude</value>
20
                </_nullIf>
21
            </latitude>
22
            <longitude>
23
                <_nullIf>
24
                    <null>0</null>
25
                    <type>float</type>
26
                    <value>$Longitude</value>
27
                </_nullIf>
28
            </longitude>
29
            <namedplace_id>
30
                <_simplifyPath>
31
                    <next>parent_id/namedplace</next>
32
                    <require>placename</require>
33
                    <path>
34
                        <namedplace>
35
                            <rank>county</rank>
36
                            <parent_id>
37
                                <namedplace>
38
                                    <rank>stateProvince</rank>
39
                                    <parent_id>
40
                                        <namedplace>
41
                                            <rank>country</rank>
42
                                            <placename>$CountryName</placename>
43
                                        </namedplace>
44
                                    </parent_id>
45
                                </namedplace>
46
                            </parent_id>
47
                        </namedplace>
48
                    </path>
49
                </_simplifyPath>
50
            </namedplace_id>
51
        </locationdetermination>
52
        <locationnarrative>
53
            <_alt>
54
                <0>$DescriptionOfSite</0>
55
                <1>$LocationName</1>
56
            </_alt>
57
        </locationnarrative>
58
    </location>
59
</VegBIEN>
60
Inserted 6 new rows into database
(9-9/9)