Project

General

Profile

Download (19.9 KB) Statistics
| Revision:

root/inputs/GBIF/Specimen/test.xml.ref @ 6280

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 
                                    <stateprovince>$StateProvince</stateprovince>
273 
                                </place>
274 
                            </matched_place_id>
275 4727 aaronmk 
                            <stateprovince>$StateProvince</stateprovince>
276 5855 aaronmk 
                        </place>
277 
                    </place_id>
278 4726 aaronmk 
                </locationplace>
279 4621 aaronmk 
            </location>
280 
        </path>
281 
    </_simplifyPath>
282 3641 aaronmk 
</VegBIEN>
283 6171 aaronmk 
Inserted 46 new rows into database