Project

General

Profile

1 4350 aaronmk
Put template:
2
<VegBIEN>
3 4621 aaronmk
    <_simplifyPath id="-1">
4
        <next>parent_id</next>
5
        <path>
6
            <location>
7
                <parent_id><location><sourceaccessioncode>$PlotID</sourceaccessioncode></location></parent_id>
8
                <authorlocationcode>$QuadratID</authorlocationcode>
9 4458 aaronmk
                <locationevent>
10 4621 aaronmk
                    <parent_id>
11
                        <locationevent>
12 6002 aaronmk
                            <location_id>
13
                                <location>
14
                                    <sourceaccessioncode>
15
                                        <_if name="if subplot">
16
                                            <cond>$QuadratID</cond>
17
                                            <then>$PlotID</then>
18
                                        </_if>
19
                                    </sourceaccessioncode>
20
                                </location>
21
                            </location_id>
22 4621 aaronmk
                            <sourceaccessioncode>$CensusID</sourceaccessioncode>
23
                        </locationevent>
24
                    </parent_id>
25
                    <taxonoccurrence>
26
                        <aggregateoccurrence>
27
                            <plantobservation>
28
                                <sourceaccessioncode>$MeasureID</sourceaccessioncode>
29
                                <stemobservation>
30
                                    <authorstemcode>$StemID</authorstemcode>
31 4861 aaronmk
                                    <diameterbreastheight_m><_cm_to_m><value>$DBH</value></_cm_to_m></diameterbreastheight_m>
32 4828 aaronmk
                                    <tag>
33
                                        <_alt>
34
                                            <0>$StemTag</0>
35
                                            <1>$Tag</1>
36
                                        </_alt>
37
                                    </tag>
38 4753 aaronmk
                                    <xposition_m>$x</xposition_m>
39
                                    <yposition_m>$y</yposition_m>
40 4621 aaronmk
                                </stemobservation>
41
                            </plantobservation>
42
                        </aggregateoccurrence>
43 4832 aaronmk
                        <authortaxoncode>
44
                            <_alt>
45
                                <0>$StemTag</0>
46
                                <1>$Tag</1>
47
                            </_alt>
48
                        </authortaxoncode>
49 4350 aaronmk
                        <sourceaccessioncode>$MeasureID</sourceaccessioncode>
50 4621 aaronmk
                        <taxondetermination>
51 5657 aaronmk
                            <taxonverbatim_id>
52
                                <taxonverbatim>
53
                                    <taxonlabel_id>
54 5608 aaronmk
                                        <taxonlabel>
55 5657 aaronmk
                                            <matched_label_id>
56
                                                <taxonlabel>
57 6179 aaronmk
                                                    <source_id><source><shortname>TNRS</shortname></source></source_id>
58 5657 aaronmk
                                                    <taxonomicname>
59 5138 aaronmk
                                                        <_join_words>
60 5790 aaronmk
                                                            <1><_taxon_family_require_std><family>$Family</family></_taxon_family_require_std></1>
61 5788 aaronmk
                                                            <2>
62 5657 aaronmk
                                                                <_join_words>
63 5788 aaronmk
                                                                    <1>
64
                                                                        <_join_words>
65
                                                                            <2>$Genus</2>
66
                                                                            <3>$SpeciesName</3>
67
                                                                            <4>$SubSpeciesName</4>
68
                                                                        </_join_words>
69
                                                                    </1>
70
                                                                    <2>$SpeciesAuthority</2>
71 5657 aaronmk
                                                                </_join_words>
72 5788 aaronmk
                                                            </2>
73 5138 aaronmk
                                                        </_join_words>
74 5657 aaronmk
                                                    </taxonomicname>
75
                                                </taxonlabel>
76
                                            </matched_label_id>
77 5294 aaronmk
                                            <parent_id>
78 5608 aaronmk
                                                <taxonlabel>
79 5294 aaronmk
                                                    <parent_id>
80 5608 aaronmk
                                                        <taxonlabel>
81 5657 aaronmk
                                                            <rank>cultivar</rank>
82 5294 aaronmk
                                                            <parent_id>
83 5608 aaronmk
                                                                <taxonlabel>
84 5657 aaronmk
                                                                    <rank>forma</rank>
85 5294 aaronmk
                                                                    <parent_id>
86 5608 aaronmk
                                                                        <taxonlabel>
87 5657 aaronmk
                                                                            <rank>variety</rank>
88 5294 aaronmk
                                                                            <parent_id>
89 5608 aaronmk
                                                                                <taxonlabel>
90 5657 aaronmk
                                                                                    <rank>subspecies</rank>
91
                                                                                    <taxonepithet>$SubSpeciesName</taxonepithet>
92 5294 aaronmk
                                                                                    <parent_id>
93 5608 aaronmk
                                                                                        <taxonlabel>
94 5657 aaronmk
                                                                                            <rank>species</rank>
95
                                                                                            <taxonepithet>$SpeciesName</taxonepithet>
96 5306 aaronmk
                                                                                            <parent_id>
97 5608 aaronmk
                                                                                                <taxonlabel>
98 5657 aaronmk
                                                                                                    <rank>genus</rank>
99
                                                                                                    <taxonepithet>$Genus</taxonepithet>
100
                                                                                                    <parent_id>
101
                                                                                                        <taxonlabel>
102
                                                                                                            <rank>family</rank>
103
                                                                                                            <taxonepithet>$Family</taxonepithet>
104
                                                                                                        </taxonlabel>
105
                                                                                                    </parent_id>
106 5608 aaronmk
                                                                                                </taxonlabel>
107 5306 aaronmk
                                                                                            </parent_id>
108 5608 aaronmk
                                                                                        </taxonlabel>
109 5294 aaronmk
                                                                                    </parent_id>
110 5608 aaronmk
                                                                                </taxonlabel>
111 5294 aaronmk
                                                                            </parent_id>
112 5608 aaronmk
                                                                        </taxonlabel>
113 5294 aaronmk
                                                                    </parent_id>
114 5608 aaronmk
                                                                </taxonlabel>
115 5294 aaronmk
                                                            </parent_id>
116 5608 aaronmk
                                                        </taxonlabel>
117 5294 aaronmk
                                                    </parent_id>
118 5608 aaronmk
                                                </taxonlabel>
119 5294 aaronmk
                                            </parent_id>
120 5657 aaronmk
                                            <taxonomicname>
121 5656 aaronmk
                                                <_join_words>
122 5790 aaronmk
                                                    <1><_taxon_family_require_std><family>$Family</family></_taxon_family_require_std></1>
123 5788 aaronmk
                                                    <2>
124 5657 aaronmk
                                                        <_join_words>
125 5788 aaronmk
                                                            <1>
126
                                                                <_join_words>
127
                                                                    <2>$Genus</2>
128
                                                                    <3>$SpeciesName</3>
129
                                                                    <4>$SubSpeciesName</4>
130
                                                                </_join_words>
131
                                                            </1>
132
                                                            <2>$SpeciesAuthority</2>
133 5657 aaronmk
                                                        </_join_words>
134 5788 aaronmk
                                                    </2>
135 5656 aaronmk
                                                </_join_words>
136 5657 aaronmk
                                            </taxonomicname>
137
                                        </taxonlabel>
138
                                    </taxonlabel_id>
139
                                    <author>$SpeciesAuthority</author>
140
                                    <family>$Family</family>
141
                                    <genus>$Genus</genus>
142 5783 aaronmk
                                    <specific_epithet>$SpeciesName</specific_epithet>
143 5657 aaronmk
                                </taxonverbatim>
144
                            </taxonverbatim_id>
145 4621 aaronmk
                        </taxondetermination>
146
                    </taxonoccurrence>
147
                </locationevent>
148 5773 aaronmk
                <sourceaccessioncode>
149
                    <_join>
150
                        <1>$PlotID</1>
151
                        <2>$QuadratID</2>
152
                    </_join>
153
                </sourceaccessioncode>
154 4621 aaronmk
            </location>
155
        </path>
156
    </_simplifyPath>
157 4350 aaronmk
</VegBIEN>
158 5655 aaronmk
Inserted 20 new rows into database