Project

General

Profile

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