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 4726 aaronmk
                <locationcoords>
9 4753 aaronmk
                    <latitude_deg>
10 4621 aaronmk
                        <_nullIf>
11
                            <null>0</null>
12
                            <type>float</type>
13
                            <value>$DecimalLatitude</value>
14
                        </_nullIf>
15 4753 aaronmk
                    </latitude_deg>
16
                    <longitude_deg>
17 4621 aaronmk
                        <_nullIf>
18
                            <null>0</null>
19
                            <type>float</type>
20
                            <value>$DecimalLongitude</value>
21
                        </_nullIf>
22 4753 aaronmk
                    </longitude_deg>
23 4726 aaronmk
                </locationcoords>
24 4621 aaronmk
                <locationevent>
25
                    <taxonoccurrence>
26
                        <aggregateoccurrence>
27
                            <collectiondate>
28
                                <_date>
29
                                    <day>
30
                                        <_nullIf>
31
                                            <null>0</null>
32
                                            <type>float</type>
33
                                            <value>$MeasDay</value>
34
                                        </_nullIf>
35
                                    </day>
36
                                    <month>
37
                                        <_nullIf>
38
                                            <null>0</null>
39
                                            <type>float</type>
40
                                            <value>$MeasMon</value>
41
                                        </_nullIf>
42
                                    </month>
43
                                    <year>
44
                                        <_nullIf>
45
                                            <null>0</null>
46
                                            <type>float</type>
47
                                            <value>$MeasYear</value>
48
                                        </_nullIf>
49
                                    </year>
50
                                </_date>
51
                            </collectiondate>
52
                            <plantobservation>
53
                                <stemobservation>
54 4753 aaronmk
                                    <basaldiameter_m>$BasalDiameter</basaldiameter_m>
55 4866 aaronmk
                                    <diameterbreastheight_m><_in_to_m><value>$DBH</value></_in_to_m></diameterbreastheight_m>
56 4753 aaronmk
                                    <height_m>$Height</height_m>
57 4828 aaronmk
                                    <tag>$TreeTag</tag>
58 4621 aaronmk
                                </stemobservation>
59
                            </plantobservation>
60
                        </aggregateoccurrence>
61 4832 aaronmk
                        <authortaxoncode>$TreeTag</authortaxoncode>
62 4621 aaronmk
                        <taxondetermination>
63 4718 aaronmk
                            <taxonpath_id>
64
                                <taxonpath>
65 4703 aaronmk
                                    <genus>$Genus</genus>
66
                                    <species>$SpecificEpithet</species>
67 5012 aaronmk
                                    <taxonomicnamewithauthor>
68
                                        <_join_words>
69
                                            <2>$Genus</2>
70
                                            <3>$SpecificEpithet</3>
71
                                        </_join_words>
72
                                    </taxonomicnamewithauthor>
73 4718 aaronmk
                                </taxonpath>
74
                            </taxonpath_id>
75 4621 aaronmk
                        </taxondetermination>
76
                    </taxonoccurrence>
77
                </locationevent>
78 4726 aaronmk
                <locationplace>
79 4727 aaronmk
                    <placepath_id>
80
                        <placepath>
81
                            <county>$County</county>
82
                            <stateprovince>$StateProvince</stateprovince>
83
                        </placepath>
84
                    </placepath_id>
85 4726 aaronmk
                </locationplace>
86 4621 aaronmk
            </location>
87
        </path>
88
    </_simplifyPath>
89 4387 aaronmk
</VegBIEN>
90 4832 aaronmk
Inserted 17 new rows into database