Project

General

Profile

Download (23.5 KB) Statistics
| Revision:

root/inputs/SpeciesLink/Specimen/test.xml.ref @ 10866

1 3641 aaronmk 
Put template:
2 
<VegBIEN>
3 6403 aaronmk 
    <_setDefault id="-1">
4 10866 aaronmk 
        <source_id><source><shortname>SpeciesLink.new</shortname></source></source_id>
5 4621 aaronmk 
        <path>
6 6403 aaronmk 
            <_simplifyPath>
7 
                <next>parent_id</next>
8 
                <path>
9 
                    <location>
10 
                        <authorlocationcode>
11 
                            <_alt>
12 10530 aaronmk 
                                <1>$occurrenceID</1>
13 4621 aaronmk 
                                <2>
14 
                                    <_join>
15 10530 aaronmk 
                                        <1>$specimenHolderInstitutions</1>
16 4621 aaronmk 
                                        <2>
17 6403 aaronmk 
                                            <_join>
18 10530 aaronmk 
                                                <1>$collection</1>
19 
                                                <2>$collectionURL</2>
20 6403 aaronmk 
                                            </_join>
21 4621 aaronmk 
                                        </2>
22 10530 aaronmk 
                                        <3>$accessionNumber</3>
23 6403 aaronmk 
                                    </_join>
24 
                                </2>
25 
                            </_alt>
26 
                        </authorlocationcode>
27 
                        <elevation_m>
28 
                            <_avg>
29 10530 aaronmk 
                                <1>$minimumElevationInMeters</1>
30 
                                <2>$maximumElevationInMeters</2>
31 6403 aaronmk 
                            </_avg>
32 
                        </elevation_m>
33 10530 aaronmk 
                        <iscultivated><_locationnarrative_is_cultivated><locationnarrative>$locality</locationnarrative></_locationnarrative_is_cultivated></iscultivated>
34 6403 aaronmk 
                        <locationevent>
35 
                            <taxonoccurrence>
36 
                                <aggregateoccurrence>
37 
                                    <collectiondate>
38 
                                        <_date>
39 
                                            <day>
40 
                                                <_nullIf>
41 
                                                    <null>0</null>
42 
                                                    <type>float</type>
43 10530 aaronmk 
                                                    <value>$dayCollected</value>
44 6403 aaronmk 
                                                </_nullIf>
45 
                                            </day>
46 
                                            <month>
47 
                                                <_nullIf>
48 
                                                    <null>0</null>
49 
                                                    <type>float</type>
50 10530 aaronmk 
                                                    <value>$monthCollected</value>
51 6403 aaronmk 
                                                </_nullIf>
52 
                                            </month>
53 
                                            <year>
54 
                                                <_nullIf>
55 
                                                    <null>0</null>
56 
                                                    <type>float</type>
57 10530 aaronmk 
                                                    <value>$yearCollected</value>
58 6403 aaronmk 
                                                </_nullIf>
59 
                                            </year>
60 
                                        </_date>
61 
                                    </collectiondate>
62 10530 aaronmk 
                                    <count>$individualCount</count>
63 
                                    <notes>$occurrenceRemarks</notes>
64 6403 aaronmk 
                                    <plantobservation>
65 10528 aaronmk 
                                        <authorplantcode>$collectorNumber</authorplantcode>
66 6403 aaronmk 
                                        <definedvalue fkey="tablerecord_id">
67 
                                            <userdefined_id>
68 
                                                <userdefined>
69 
                                                    <tablename>plantobservation</tablename>
70 
                                                    <userdefinedname>sex</userdefinedname>
71 
                                                </userdefined>
72 
                                            </userdefined_id>
73 10530 aaronmk 
                                            <definedvalue>$sex</definedvalue>
74 6403 aaronmk 
                                        </definedvalue>
75 
                                        <specimenreplicate>
76 10530 aaronmk 
                                            <catalognumber_dwc>$accessionNumber</catalognumber_dwc>
77 6403 aaronmk 
                                            <collectioncode_dwc>
78 7712 aaronmk 
                                                <_alt>
79 10530 aaronmk 
                                                    <1>$collection</1>
80 
                                                    <2>$collectionURL</2>
81 7712 aaronmk 
                                                </_alt>
82 6403 aaronmk 
                                            </collectioncode_dwc>
83 10528 aaronmk 
                                            <collectionnumber>$collectorNumber</collectionnumber>
84 6403 aaronmk 
                                            <institution_id>
85 6791 aaronmk 
                                                <sourcelist>
86 10530 aaronmk 
                                                    <name>$specimenHolderInstitutions</name>
87 6791 aaronmk 
                                                    <sourcename>
88 6795 aaronmk 
                                                        <name>
89 
                                                            <_split>
90 7433 aaronmk 
                                                                <separator>[,;] *</separator>
91 10530 aaronmk 
                                                                <value>$specimenHolderInstitutions</value>
92 6795 aaronmk 
                                                            </_split>
93 6791 aaronmk 
                                                        </name>
94 
                                                    </sourcename>
95 
                                                </sourcelist>
96 6403 aaronmk 
                                            </institution_id>
97 10530 aaronmk 
                                            <sourceaccessioncode>$occurrenceID</sourceaccessioncode>
98 6403 aaronmk 
                                        </specimenreplicate>
99 
                                    </plantobservation>
100 
                                </aggregateoccurrence>
101 10530 aaronmk 
                                <collector_id><party><fullname>$recordedBy</fullname></party></collector_id>
102 
                                <sourceaccessioncode>$occurrenceID</sourceaccessioncode>
103 6403 aaronmk 
                                <taxondetermination>
104 10530 aaronmk 
                                    <party_id><party><fullname>$identifiedBy</fullname></party></party_id>
105 6403 aaronmk 
                                    <taxonverbatim_id>
106 
                                        <taxonverbatim>
107 
                                            <taxonlabel_id>
108 5657 aaronmk 
                                                <taxonlabel>
109 5294 aaronmk 
                                                    <parent_id>
110 5608 aaronmk 
                                                        <taxonlabel>
111 5294 aaronmk 
                                                            <parent_id>
112 5608 aaronmk 
                                                                <taxonlabel>
113 6403 aaronmk 
                                                                    <rank>cultivar</rank>
114 5294 aaronmk 
                                                                    <parent_id>
115 5608 aaronmk 
                                                                        <taxonlabel>
116 6403 aaronmk 
                                                                            <rank>forma</rank>
117 5294 aaronmk 
                                                                            <parent_id>
118 5608 aaronmk 
                                                                                <taxonlabel>
119 6403 aaronmk 
                                                                                    <rank>variety</rank>
120 5294 aaronmk 
                                                                                    <parent_id>
121 5608 aaronmk 
                                                                                        <taxonlabel>
122 6403 aaronmk 
                                                                                            <rank>subspecies</rank>
123 10530 aaronmk 
                                                                                            <taxonepithet>$subspecies</taxonepithet>
124 5294 aaronmk 
                                                                                            <parent_id>
125 5608 aaronmk 
                                                                                                <taxonlabel>
126 6403 aaronmk 
                                                                                                    <rank>species</rank>
127 10530 aaronmk 
                                                                                                    <taxonepithet>$specificEpithet</taxonepithet>
128 5294 aaronmk 
                                                                                                    <parent_id>
129 5608 aaronmk 
                                                                                                        <taxonlabel>
130 6403 aaronmk 
                                                                                                            <rank>genus</rank>
131 10530 aaronmk 
                                                                                                            <taxonepithet>$genus</taxonepithet>
132 5294 aaronmk 
                                                                                                            <parent_id>
133 5608 aaronmk 
                                                                                                                <taxonlabel>
134 6403 aaronmk 
                                                                                                                    <rank>family</rank>
135 10530 aaronmk 
                                                                                                                    <taxonepithet>$family</taxonepithet>
136 5294 aaronmk 
                                                                                                                    <parent_id>
137 5608 aaronmk 
                                                                                                                        <taxonlabel>
138 6403 aaronmk 
                                                                                                                            <rank>order</rank>
139 10530 aaronmk 
                                                                                                                            <taxonepithet>$order</taxonepithet>
140 5306 aaronmk 
                                                                                                                            <parent_id>
141 5608 aaronmk 
                                                                                                                                <taxonlabel>
142 6403 aaronmk 
                                                                                                                                    <rank>class</rank>
143 10530 aaronmk 
                                                                                                                                    <taxonepithet>$class</taxonepithet>
144 5657 aaronmk 
                                                                                                                                    <parent_id>
145 
                                                                                                                                        <taxonlabel>
146 6403 aaronmk 
                                                                                                                                            <rank>phylum</rank>
147 10530 aaronmk 
                                                                                                                                            <taxonepithet>$phylum</taxonepithet>
148 6403 aaronmk 
                                                                                                                                            <parent_id>
149 
                                                                                                                                                <taxonlabel>
150 
                                                                                                                                                    <rank>kingdom</rank>
151 10530 aaronmk 
                                                                                                                                                    <taxonepithet>$kingdom</taxonepithet>
152 6403 aaronmk 
                                                                                                                                                </taxonlabel>
153 
                                                                                                                                            </parent_id>
154 5657 aaronmk 
                                                                                                                                        </taxonlabel>
155 
                                                                                                                                    </parent_id>
156 5608 aaronmk 
                                                                                                                                </taxonlabel>
157 5306 aaronmk 
                                                                                                                            </parent_id>
158 5608 aaronmk 
                                                                                                                        </taxonlabel>
159 5294 aaronmk 
                                                                                                                    </parent_id>
160 5608 aaronmk 
                                                                                                                </taxonlabel>
161 5294 aaronmk 
                                                                                                            </parent_id>
162 5608 aaronmk 
                                                                                                        </taxonlabel>
163 5294 aaronmk 
                                                                                                    </parent_id>
164 5608 aaronmk 
                                                                                                </taxonlabel>
165 5294 aaronmk 
                                                                                            </parent_id>
166 5608 aaronmk 
                                                                                        </taxonlabel>
167 5294 aaronmk 
                                                                                    </parent_id>
168 5608 aaronmk 
                                                                                </taxonlabel>
169 5294 aaronmk 
                                                                            </parent_id>
170 5608 aaronmk 
                                                                        </taxonlabel>
171 5294 aaronmk 
                                                                    </parent_id>
172 5608 aaronmk 
                                                                </taxonlabel>
173 5294 aaronmk 
                                                            </parent_id>
174 10530 aaronmk 
                                                            <taxonepithet>$infraspecificEpithet</taxonepithet>
175 5608 aaronmk 
                                                        </taxonlabel>
176 5294 aaronmk 
                                                    </parent_id>
177 6403 aaronmk 
                                                    <taxonomicname>
178 7142 aaronmk 
                                                        <_merge_prefix>
179 10530 aaronmk 
                                                            <prefix><_taxon_family_require_std><family>$family</family></_taxon_family_require_std></prefix>
180 7142 aaronmk 
                                                            <value>
181 10434 aaronmk 
                                                                <_alt>
182 10530 aaronmk 
                                                                    <1>$scientificName</1>
183 10434 aaronmk 
                                                                    <2>
184 
                                                                        <_join_words>
185 6403 aaronmk 
                                                                            <1>
186 10435 aaronmk 
                                                                                <_join_words>
187 10530 aaronmk 
                                                                                    <2><_filter_genus><value>$genus</value></_filter_genus></2>
188 
                                                                                    <3>$specificEpithet</3>
189 
                                                                                    <4>$subspecies</4>
190 
                                                                                    <5>$infraspecificEpithet</5>
191 10435 aaronmk 
                                                                                </_join_words>
192 10434 aaronmk 
                                                                            </1>
193 10530 aaronmk 
                                                                            <2>$scientificNameAuthorship</2>
194 10434 aaronmk 
                                                                        </_join_words>
195 
                                                                    </2>
196 
                                                                </_alt>
197 7142 aaronmk 
                                                            </value>
198 
                                                        </_merge_prefix>
199 6403 aaronmk 
                                                    </taxonomicname>
200 
                                                </taxonlabel>
201 
                                            </taxonlabel_id>
202 10530 aaronmk 
                                            <author>$scientificNameAuthorship</author>
203 
                                            <family>$family</family>
204 
                                            <genus>$genus</genus>
205 
                                            <specific_epithet>$specificEpithet</specific_epithet>
206 
                                            <taxonomicname>$scientificName</taxonomicname>
207 6403 aaronmk 
                                        </taxonverbatim>
208 
                                    </taxonverbatim_id>
209 
                                    <determinationdate>
210 5861 aaronmk 
                                        <_alt>
211 10530 aaronmk 
                                            <1><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></1>
212 6403 aaronmk 
                                            <2>
213 
                                                <_date>
214 
                                                    <day>
215 
                                                        <_nullIf>
216 
                                                            <null>0</null>
217 
                                                            <type>float</type>
218 10530 aaronmk 
                                                            <value>$dayIdentified</value>
219 6403 aaronmk 
                                                        </_nullIf>
220 
                                                    </day>
221 
                                                    <month>
222 
                                                        <_nullIf>
223 
                                                            <null>0</null>
224 
                                                            <type>float</type>
225 10530 aaronmk 
                                                            <value>$monthIdentified</value>
226 6403 aaronmk 
                                                        </_nullIf>
227 
                                                    </month>
228 
                                                    <year>
229 
                                                        <_nullIf>
230 
                                                            <null>0</null>
231 
                                                            <type>float</type>
232 10530 aaronmk 
                                                            <value>$yearIdentified</value>
233 6403 aaronmk 
                                                        </_nullIf>
234 
                                                    </year>
235 
                                                </_date>
236 
                                            </2>
237 5861 aaronmk 
                                        </_alt>
238 6403 aaronmk 
                                    </determinationdate>
239 
                                </taxondetermination>
240 
                            </taxonoccurrence>
241 
                            <waterdepth_m>
242 
                                <_avg>
243 10530 aaronmk 
                                    <1>$minimumDepthInMeters</1>
244 
                                    <2>$maximumDepthInMeters</2>
245 6403 aaronmk 
                                </_avg>
246 
                            </waterdepth_m>
247 
                        </locationevent>
248 10530 aaronmk 
                        <locationnarrative>$locality</locationnarrative>
249 6403 aaronmk 
                        <locationplace>
250 
                            <place_id>
251 5958 aaronmk 
                                <place>
252 
                                    <coordinates_id>
253 
                                        <coordinates>
254 10530 aaronmk 
                                            <coordsaccuracy_m><_noCV><value>$coordinateUncertaintyInMeters</value></_noCV></coordsaccuracy_m>
255 5958 aaronmk 
                                            <latitude_deg>
256 5969 aaronmk 
                                                <_nullIf>
257 
                                                    <null>0</null>
258 
                                                    <type>float</type>
259 10530 aaronmk 
                                                    <value>$decimalLatitude</value>
260 5969 aaronmk 
                                                </_nullIf>
261 5958 aaronmk 
                                            </latitude_deg>
262 
                                            <longitude_deg>
263 5969 aaronmk 
                                                <_nullIf>
264 
                                                    <null>0</null>
265 
                                                    <type>float</type>
266 10530 aaronmk 
                                                    <value>$decimalLongitude</value>
267 5969 aaronmk 
                                                </_nullIf>
268 5958 aaronmk 
                                            </longitude_deg>
269 10530 aaronmk 
                                            <verbatimlatitude>$verbatimLatitude</verbatimlatitude>
270 
                                            <verbatimlongitude>$verbatimLongitude</verbatimlongitude>
271 5958 aaronmk 
                                        </coordinates>
272 
                                    </coordinates_id>
273 10530 aaronmk 
                                    <continent>$continent</continent>
274 
                                    <country>$country</country>
275 
                                    <county>$county</county>
276 6403 aaronmk 
                                    <matched_place_id>
277 
                                        <place>
278 
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
279 
                                            <coordinates_id>
280 
                                                <coordinates>
281 
                                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>
282 
                                                    <latitude_deg>
283 
                                                        <_nullIf>
284 
                                                            <null>0</null>
285 
                                                            <type>float</type>
286 10530 aaronmk 
                                                            <value>$decimalLatitude</value>
287 6403 aaronmk 
                                                        </_nullIf>
288 
                                                    </latitude_deg>
289 
                                                    <longitude_deg>
290 
                                                        <_nullIf>
291 
                                                            <null>0</null>
292 
                                                            <type>float</type>
293 10530 aaronmk 
                                                            <value>$decimalLongitude</value>
294 6403 aaronmk 
                                                        </_nullIf>
295 
                                                    </longitude_deg>
296 
                                                </coordinates>
297 
                                            </coordinates_id>
298 10530 aaronmk 
                                            <country>$country</country>
299 
                                            <county>$county</county>
300 
                                            <stateprovince>$stateProvince</stateprovince>
301 6403 aaronmk 
                                        </place>
302 
                                    </matched_place_id>
303 10530 aaronmk 
                                    <stateprovince>$stateProvince</stateprovince>
304 5958 aaronmk 
                                </place>
305 6403 aaronmk 
                            </place_id>
306 
                        </locationplace>
307 
                    </location>
308 
                </path>
309 
            </_simplifyPath>
310 4621 aaronmk 
        </path>
311 6403 aaronmk 
    </_setDefault>
312 3641 aaronmk 
</VegBIEN>
313 7162 aaronmk 
Inserted 44 new rows into database