Project

General

Profile

1 3641 aaronmk
Put template:
2
<VegBIEN>
3 4621 aaronmk
    <_simplifyPath id="-1">
4
        <next>parent_id</next>
5
        <path>
6
            <location>
7
                <authorlocationcode>
8
                    <_join>
9
                        <1>$InstitutionCD</1>
10
                        <2>$CollectionCD</2>
11
                        <3>$CatalogNO</3>
12
                    </_join>
13
                </authorlocationcode>
14 4753 aaronmk
                <elevation_m>
15 4621 aaronmk
                    <_avg>
16 4820 aaronmk
                        <max>$MaximumElevationInMeter</max>
17 4822 aaronmk
                        <min>$MinimumElevationInMeter</min>
18 4621 aaronmk
                    </_avg>
19 4753 aaronmk
                </elevation_m>
20 4621 aaronmk
                <locationevent>
21
                    <taxonoccurrence>
22
                        <aggregateoccurrence>
23 6217 aaronmk
                            <collectiondate>$LatestDateCollected</collectiondate>
24 4621 aaronmk
                            <plantobservation>
25
                                <specimenreplicate>
26
                                    <catalognumber_dwc>$CatalogNO</catalognumber_dwc>
27
                                    <collectioncode_dwc>$CollectionCD</collectioncode_dwc>
28 6179 aaronmk
                                    <institution_id><sourcename><name>$InstitutionCD</name></sourcename></institution_id>
29 4621 aaronmk
                                </specimenreplicate>
30
                            </plantobservation>
31
                        </aggregateoccurrence>
32 6171 aaronmk
                        <collector_id><party><fullname>$Collector</fullname></party></collector_id>
33 4621 aaronmk
                        <taxondetermination>
34 5600 aaronmk
                            <party_id><party><fullname>$IdentifiedBy</fullname></party></party_id>
35 5657 aaronmk
                            <taxonverbatim_id>
36
                                <taxonverbatim>
37
                                    <taxonlabel_id>
38 5608 aaronmk
                                        <taxonlabel>
39 5657 aaronmk
                                            <matched_label_id>
40
                                                <taxonlabel>
41 6179 aaronmk
                                                    <source_id><source><shortname>TNRS</shortname></source></source_id>
42 5657 aaronmk
                                                    <taxonomicname>
43
                                                        <_join_words>
44 5790 aaronmk
                                                            <1><_taxon_family_require_std><family>$Family</family></_taxon_family_require_std></1>
45 5788 aaronmk
                                                            <2>
46
                                                                <_join_words>
47
                                                                    <1>
48
                                                                        <_alt>
49
                                                                            <1>$ScientificName</1>
50
                                                                            <2>
51
                                                                                <_join_words>
52
                                                                                    <2>$Genus</2>
53
                                                                                    <3>$SpecificEpithet</3>
54
                                                                                    <5>$InfraspecificEpithet</5>
55
                                                                                </_join_words>
56
                                                                            </2>
57
                                                                        </_alt>
58
                                                                    </1>
59
                                                                    <2>$AuthorOfScientificName</2>
60
                                                                </_join_words>
61
                                                            </2>
62 5657 aaronmk
                                                        </_join_words>
63
                                                    </taxonomicname>
64
                                                </taxonlabel>
65
                                            </matched_label_id>
66 5294 aaronmk
                                            <parent_id>
67 5608 aaronmk
                                                <taxonlabel>
68 5294 aaronmk
                                                    <parent_id>
69 5608 aaronmk
                                                        <taxonlabel>
70 5657 aaronmk
                                                            <rank>cultivar</rank>
71 5294 aaronmk
                                                            <parent_id>
72 5608 aaronmk
                                                                <taxonlabel>
73 5657 aaronmk
                                                                    <rank>forma</rank>
74 5294 aaronmk
                                                                    <parent_id>
75 5608 aaronmk
                                                                        <taxonlabel>
76 5657 aaronmk
                                                                            <rank>variety</rank>
77 5294 aaronmk
                                                                            <parent_id>
78 5608 aaronmk
                                                                                <taxonlabel>
79 5657 aaronmk
                                                                                    <rank>subspecies</rank>
80 5294 aaronmk
                                                                                    <parent_id>
81 5608 aaronmk
                                                                                        <taxonlabel>
82 5657 aaronmk
                                                                                            <rank>species</rank>
83
                                                                                            <taxonepithet>$SpecificEpithet</taxonepithet>
84 5306 aaronmk
                                                                                            <parent_id>
85 5608 aaronmk
                                                                                                <taxonlabel>
86 5657 aaronmk
                                                                                                    <rank>genus</rank>
87
                                                                                                    <taxonepithet>$Genus</taxonepithet>
88
                                                                                                    <parent_id>
89
                                                                                                        <taxonlabel>
90
                                                                                                            <rank>family</rank>
91
                                                                                                            <taxonepithet>$Family</taxonepithet>
92
                                                                                                        </taxonlabel>
93
                                                                                                    </parent_id>
94 5608 aaronmk
                                                                                                </taxonlabel>
95 5306 aaronmk
                                                                                            </parent_id>
96 5608 aaronmk
                                                                                        </taxonlabel>
97 5294 aaronmk
                                                                                    </parent_id>
98 5608 aaronmk
                                                                                </taxonlabel>
99 5294 aaronmk
                                                                            </parent_id>
100 5608 aaronmk
                                                                        </taxonlabel>
101 5294 aaronmk
                                                                    </parent_id>
102 5608 aaronmk
                                                                </taxonlabel>
103 5294 aaronmk
                                                            </parent_id>
104 5608 aaronmk
                                                        </taxonlabel>
105 5294 aaronmk
                                                    </parent_id>
106 5657 aaronmk
                                                    <taxonepithet>$InfraspecificEpithet</taxonepithet>
107 5608 aaronmk
                                                </taxonlabel>
108 5294 aaronmk
                                            </parent_id>
109 5657 aaronmk
                                            <taxonomicname>
110
                                                <_join_words>
111 5790 aaronmk
                                                    <1><_taxon_family_require_std><family>$Family</family></_taxon_family_require_std></1>
112 5788 aaronmk
                                                    <2>
113
                                                        <_join_words>
114
                                                            <1>
115
                                                                <_alt>
116
                                                                    <1>$ScientificName</1>
117
                                                                    <2>
118
                                                                        <_join_words>
119
                                                                            <2>$Genus</2>
120
                                                                            <3>$SpecificEpithet</3>
121
                                                                            <5>$InfraspecificEpithet</5>
122
                                                                        </_join_words>
123
                                                                    </2>
124
                                                                </_alt>
125
                                                            </1>
126
                                                            <2>$AuthorOfScientificName</2>
127
                                                        </_join_words>
128
                                                    </2>
129 5657 aaronmk
                                                </_join_words>
130
                                            </taxonomicname>
131 5608 aaronmk
                                        </taxonlabel>
132 5657 aaronmk
                                    </taxonlabel_id>
133
                                    <author>$AuthorOfScientificName</author>
134
                                    <family>$Family</family>
135
                                    <genus>$Genus</genus>
136 5783 aaronmk
                                    <specific_epithet>$SpecificEpithet</specific_epithet>
137 5948 aaronmk
                                    <taxonname>$ScientificName</taxonname>
138 5657 aaronmk
                                </taxonverbatim>
139
                            </taxonverbatim_id>
140 4621 aaronmk
                        </taxondetermination>
141
                        <taxondetermination>
142
                            <isoriginal>true</isoriginal>
143 5657 aaronmk
                            <taxonverbatim_id>
144
                                <taxonverbatim>
145
                                    <taxonlabel_id>
146 5608 aaronmk
                                        <taxonlabel>
147 5657 aaronmk
                                            <matched_label_id>
148
                                                <taxonlabel>
149 6179 aaronmk
                                                    <source_id><source><shortname>TNRS</shortname></source></source_id>
150 5657 aaronmk
                                                    <taxonomicname>
151 5788 aaronmk
                                                        <_join_words>
152 5790 aaronmk
                                                            <1><_taxon_family_require_std><family>$GBIFFamilyOriginal</family></_taxon_family_require_std></1>
153 5657 aaronmk
                                                            <2>
154 5788 aaronmk
                                                                <_alt>
155
                                                                    <1>$ScientificNameOriginal</1>
156 5657 aaronmk
                                                                    <2>$GBIFGenusOriginal</2>
157 5788 aaronmk
                                                                </_alt>
158 5657 aaronmk
                                                            </2>
159 5788 aaronmk
                                                        </_join_words>
160 5657 aaronmk
                                                    </taxonomicname>
161
                                                </taxonlabel>
162
                                            </matched_label_id>
163 5295 aaronmk
                                            <parent_id>
164 5608 aaronmk
                                                <taxonlabel>
165 5295 aaronmk
                                                    <parent_id>
166 5608 aaronmk
                                                        <taxonlabel>
167 5657 aaronmk
                                                            <rank>cultivar</rank>
168 5295 aaronmk
                                                            <parent_id>
169 5608 aaronmk
                                                                <taxonlabel>
170 5657 aaronmk
                                                                    <rank>forma</rank>
171 5295 aaronmk
                                                                    <parent_id>
172 5608 aaronmk
                                                                        <taxonlabel>
173 5657 aaronmk
                                                                            <rank>variety</rank>
174 5295 aaronmk
                                                                            <parent_id>
175 5608 aaronmk
                                                                                <taxonlabel>
176 5657 aaronmk
                                                                                    <rank>subspecies</rank>
177 5295 aaronmk
                                                                                    <parent_id>
178 5608 aaronmk
                                                                                        <taxonlabel>
179 5657 aaronmk
                                                                                            <rank>species</rank>
180 5306 aaronmk
                                                                                            <parent_id>
181 5608 aaronmk
                                                                                                <taxonlabel>
182 5657 aaronmk
                                                                                                    <rank>genus</rank>
183
                                                                                                    <taxonepithet>$GBIFGenusOriginal</taxonepithet>
184
                                                                                                    <parent_id>
185
                                                                                                        <taxonlabel>
186
                                                                                                            <rank>family</rank>
187
                                                                                                            <taxonepithet>$GBIFFamilyOriginal</taxonepithet>
188
                                                                                                        </taxonlabel>
189
                                                                                                    </parent_id>
190 5608 aaronmk
                                                                                                </taxonlabel>
191 5306 aaronmk
                                                                                            </parent_id>
192 5608 aaronmk
                                                                                        </taxonlabel>
193 5295 aaronmk
                                                                                    </parent_id>
194 5608 aaronmk
                                                                                </taxonlabel>
195 5295 aaronmk
                                                                            </parent_id>
196 5608 aaronmk
                                                                        </taxonlabel>
197 5295 aaronmk
                                                                    </parent_id>
198 5608 aaronmk
                                                                </taxonlabel>
199 5295 aaronmk
                                                            </parent_id>
200 5608 aaronmk
                                                        </taxonlabel>
201 5295 aaronmk
                                                    </parent_id>
202 5608 aaronmk
                                                </taxonlabel>
203 5295 aaronmk
                                            </parent_id>
204 5657 aaronmk
                                            <taxonomicname>
205 5788 aaronmk
                                                <_join_words>
206 5790 aaronmk
                                                    <1><_taxon_family_require_std><family>$GBIFFamilyOriginal</family></_taxon_family_require_std></1>
207 5657 aaronmk
                                                    <2>
208 5788 aaronmk
                                                        <_alt>
209
                                                            <1>$ScientificNameOriginal</1>
210 5657 aaronmk
                                                            <2>$GBIFGenusOriginal</2>
211 5788 aaronmk
                                                        </_alt>
212 5657 aaronmk
                                                    </2>
213 5788 aaronmk
                                                </_join_words>
214 5657 aaronmk
                                            </taxonomicname>
215 5608 aaronmk
                                        </taxonlabel>
216 5657 aaronmk
                                    </taxonlabel_id>
217
                                    <family>$GBIFFamilyOriginal</family>
218
                                    <genus>$GBIFGenusOriginal</genus>
219 5948 aaronmk
                                    <taxonname>$ScientificNameOriginal</taxonname>
220 5657 aaronmk
                                </taxonverbatim>
221
                            </taxonverbatim_id>
222 4621 aaronmk
                        </taxondetermination>
223
                    </taxonoccurrence>
224
                </locationevent>
225
                <locationnarrative>$Locality</locationnarrative>
226 4726 aaronmk
                <locationplace>
227 5855 aaronmk
                    <place_id>
228
                        <place>
229 5861 aaronmk
                            <coordinates_id>
230
                                <coordinates>
231
                                    <latitude_deg>
232
                                        <_nullIf>
233
                                            <null>0</null>
234
                                            <type>float</type>
235
                                            <value>$VerbatimLatitude</value>
236
                                        </_nullIf>
237
                                    </latitude_deg>
238
                                    <longitude_deg>
239
                                        <_nullIf>
240
                                            <null>0</null>
241
                                            <type>float</type>
242
                                            <value>$VerbatimLongitude</value>
243
                                        </_nullIf>
244
                                    </longitude_deg>
245
                                </coordinates>
246
                            </coordinates_id>
247 4727 aaronmk
                            <country>$Country</country>
248
                            <county>$County</county>
249 5958 aaronmk
                            <matched_place_id>
250
                                <place>
251 6179 aaronmk
                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>
252 5958 aaronmk
                                    <coordinates_id>
253
                                        <coordinates>
254 6179 aaronmk
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
255 5969 aaronmk
                                            <latitude_deg>
256
                                                <_nullIf>
257
                                                    <null>0</null>
258
                                                    <type>float</type>
259
                                                    <value>$VerbatimLatitude</value>
260
                                                </_nullIf>
261
                                            </latitude_deg>
262
                                            <longitude_deg>
263
                                                <_nullIf>
264
                                                    <null>0</null>
265
                                                    <type>float</type>
266
                                                    <value>$VerbatimLongitude</value>
267
                                                </_nullIf>
268
                                            </longitude_deg>
269 5958 aaronmk
                                        </coordinates>
270
                                    </coordinates_id>
271
                                    <country>$Country</country>
272 6294 aaronmk
                                    <county>$County</county>
273 5958 aaronmk
                                    <stateprovince>$StateProvince</stateprovince>
274
                                </place>
275
                            </matched_place_id>
276 4727 aaronmk
                            <stateprovince>$StateProvince</stateprovince>
277 5855 aaronmk
                        </place>
278
                    </place_id>
279 4726 aaronmk
                </locationplace>
280 4621 aaronmk
            </location>
281
        </path>
282
    </_simplifyPath>
283 3641 aaronmk
</VegBIEN>
284 6171 aaronmk
Inserted 46 new rows into database