Project

General

Profile

1 4387 aaronmk
Put template:
2
<VegBIEN>
3
    <location id="-1">
4
        <sourceaccessioncode>$PlotCD</sourceaccessioncode>
5
        <locationdetermination>
6
            <latitude>
7
                <_nullIf>
8
                    <null>0</null>
9
                    <type>float</type>
10
                    <value>$DecimalLatitude</value>
11
                </_nullIf>
12
            </latitude>
13
            <longitude>
14
                <_nullIf>
15
                    <null>0</null>
16
                    <type>float</type>
17
                    <value>$DecimalLongitude</value>
18
                </_nullIf>
19
            </longitude>
20
            <namedplace_id>
21
                <_simplifyPath>
22
                    <next>parent_id/namedplace</next>
23
                    <require>placename</require>
24
                    <path>
25
                        <namedplace>
26
                            <rank>county</rank>
27
                            <placename>$County</placename>
28
                            <parent_id>
29
                                <namedplace>
30
                                    <rank>stateProvince</rank>
31
                                    <placename>$StateProvince</placename>
32
                                </namedplace>
33
                            </parent_id>
34
                        </namedplace>
35
                    </path>
36
                </_simplifyPath>
37
            </namedplace_id>
38
        </locationdetermination>
39
        <locationevent>
40
            <taxonoccurrence>
41
                <aggregateoccurrence>
42
                    <collectiondate>
43
                        <_date>
44 4566 aaronmk
                            <day>
45
                                <_nullIf>
46
                                    <null>0</null>
47
                                    <type>float</type>
48
                                    <value>$MeasDay</value>
49
                                </_nullIf>
50
                            </day>
51
                            <month>
52
                                <_nullIf>
53
                                    <null>0</null>
54
                                    <type>float</type>
55
                                    <value>$MeasMon</value>
56
                                </_nullIf>
57
                            </month>
58
                            <year>
59
                                <_nullIf>
60
                                    <null>0</null>
61
                                    <type>float</type>
62
                                    <value>$MeasYear</value>
63
                                </_nullIf>
64
                            </year>
65 4387 aaronmk
                        </_date>
66
                    </collectiondate>
67
                    <plantobservation>
68
                        <stemobservation>
69
                            <basaldiameter>$BasalDiameter</basaldiameter>
70
                            <diameterbreastheight>$DBH</diameterbreastheight>
71
                            <height>$Height</height>
72
                            <stemtag>
73
                                <iscurrent>true</iscurrent>
74
                                <tag>$TreeTag</tag>
75
                            </stemtag>
76
                        </stemobservation>
77
                    </plantobservation>
78
                </aggregateoccurrence>
79
                <taxondetermination>
80
                    <plantconcept_id>
81
                        <plantconcept>
82
                            <plantname_id>
83
                                <_simplifyPath>
84
                                    <next>parent_id</next>
85
                                    <path>
86
                                        <plantname>
87
                                            <rank>binomial</rank>
88
                                            <parent_id>
89
                                                <plantname>
90
                                                    <rank>authority</rank>
91
                                                    <parent_id>
92
                                                        <plantname>
93
                                                            <rank>subspecies</rank>
94
                                                            <parent_id>
95
                                                                <plantname>
96
                                                                    <rank>species</rank>
97
                                                                    <plantname>$SpecificEpithet</plantname>
98
                                                                    <parent_id>
99
                                                                        <plantname>
100
                                                                            <rank>genus</rank>
101
                                                                            <plantname>$Genus</plantname>
102
                                                                        </plantname>
103
                                                                    </parent_id>
104
                                                                </plantname>
105
                                                            </parent_id>
106
                                                        </plantname>
107
                                                    </parent_id>
108
                                                </plantname>
109
                                            </parent_id>
110
                                        </plantname>
111
                                    </path>
112
                                </_simplifyPath>
113
                            </plantname_id>
114
                        </plantconcept>
115
                    </plantconcept_id>
116
                </taxondetermination>
117
            </taxonoccurrence>
118
        </locationevent>
119
    </location>
120
</VegBIEN>
121
Inserted 15 new rows into database