Revision 3641
Added by Aaron Marcuse-Kubitza over 12 years ago
inputs/MT/test/import.specimens.out.ref | ||
---|---|---|
1 |
Put template: |
|
2 |
<VegBIEN> |
|
3 |
<_ignore><inLabel>MT</inLabel></_ignore> |
|
4 |
<specimenreplicate id="-1"> |
|
5 |
<datasource_id><party><organizationname><_alt><2>MT</2></_alt></organizationname></party></datasource_id> |
|
6 |
<locationevent_id> |
|
7 |
<locationevent> |
|
8 |
<location_id> |
|
9 |
<location> |
|
10 |
<datasource_id><party><organizationname><_alt><2>MT</2></_alt></organizationname></party></datasource_id> |
|
11 |
<locationdetermination> |
|
12 |
<namedplace_id> |
|
13 |
<_simplifyPath> |
|
14 |
<next>parent_id/namedplace</next> |
|
15 |
<require>placename</require> |
|
16 |
<path> |
|
17 |
<namedplace> |
|
18 |
<rank>county</rank> |
|
19 |
<parent_id> |
|
20 |
<namedplace> |
|
21 |
<rank>stateProvince</rank> |
|
22 |
<parent_id> |
|
23 |
<namedplace> |
|
24 |
<rank>country</rank> |
|
25 |
<parent_id> |
|
26 |
<namedplace> |
|
27 |
<rank>continent</rank> |
|
28 |
<placename>$continent</placename> |
|
29 |
</namedplace> |
|
30 |
</parent_id> |
|
31 |
</namedplace> |
|
32 |
</parent_id> |
|
33 |
</namedplace> |
|
34 |
</parent_id> |
|
35 |
</namedplace> |
|
36 |
</path> |
|
37 |
</_simplifyPath> |
|
38 |
</namedplace_id> |
|
39 |
</locationdetermination> |
|
40 |
<locationnarrative><_merge><1>$locality</1></_merge></locationnarrative> |
|
41 |
<sourceaccessioncode> |
|
42 |
<_alt> |
|
43 |
<2> |
|
44 |
<_merge> |
|
45 |
<2>$collectionCode</2> |
|
46 |
<1>$institutionCode</1> |
|
47 |
</_merge> |
|
48 |
</2> |
|
49 |
<1>$id</1> |
|
50 |
</_alt> |
|
51 |
</sourceaccessioncode> |
|
52 |
</location> |
|
53 |
</location_id> |
|
54 |
</locationevent> |
|
55 |
</locationevent_id> |
|
56 |
<collectionnumber><_alt><2>$collectionID</2></_alt></collectionnumber> |
|
57 |
<taxondetermination> |
|
58 |
<isoriginal>true</isoriginal> |
|
59 |
<iscurrent>true</iscurrent> |
|
60 |
<role>identifier</role> |
|
61 |
<plantconcept_id> |
|
62 |
<plantconcept> |
|
63 |
<plantname_id> |
|
64 |
<_simplifyPath> |
|
65 |
<next>parent_id/plantname</next> |
|
66 |
<require>plantname</require> |
|
67 |
<path> |
|
68 |
<plantname> |
|
69 |
<rank>binomial</rank> |
|
70 |
<parent_id> |
|
71 |
<plantname> |
|
72 |
<rank>authority</rank> |
|
73 |
<parent_id> |
|
74 |
<plantname> |
|
75 |
<rank>subspecies</rank> |
|
76 |
<parent_id> |
|
77 |
<plantname> |
|
78 |
<rank>species</rank> |
|
79 |
<parent_id> |
|
80 |
<plantname> |
|
81 |
<rank>genus</rank> |
|
82 |
<plantname>$genus</plantname> |
|
83 |
<parent_id> |
|
84 |
<plantname> |
|
85 |
<rank>family</rank> |
|
86 |
<plantname>$family</plantname> |
|
87 |
</plantname> |
|
88 |
</parent_id> |
|
89 |
</plantname> |
|
90 |
</parent_id> |
|
91 |
</plantname> |
|
92 |
</parent_id> |
|
93 |
</plantname> |
|
94 |
</parent_id> |
|
95 |
</plantname> |
|
96 |
</parent_id> |
|
97 |
</plantname> |
|
98 |
</path> |
|
99 |
</_simplifyPath> |
|
100 |
</plantname_id> |
|
101 |
</plantconcept> |
|
102 |
</plantconcept_id> |
|
103 |
</taxondetermination> |
|
104 |
<collectioncode_dwc>$collectionCode</collectioncode_dwc> |
|
105 |
<growthform> |
|
106 |
<_map> |
|
107 |
<tree>*</tree> |
|
108 |
<shrub>*</shrub> |
|
109 |
<liana>*</liana> |
|
110 |
<vine>*</vine> |
|
111 |
<herb>*</herb> |
|
112 |
<hemiepiphyte>*</hemiepiphyte> |
|
113 |
<epiphyte>*</epiphyte> |
|
114 |
<grass>*</grass> |
|
115 |
<forb>*</forb> |
|
116 |
<moss>*</moss> |
|
117 |
<lichen>*</lichen> |
|
118 |
<fungus>*</fungus> |
|
119 |
<floating aquatic>*</floating aquatic> |
|
120 |
<submerged aquatic>*</submerged aquatic> |
|
121 |
<*></*> |
|
122 |
<value>$establishmentMeans</value> |
|
123 |
</_map> |
|
124 |
</growthform> |
|
125 |
<iscultivated> |
|
126 |
<_map> |
|
127 |
<cultivated>t</cultivated> |
|
128 |
<wild>f</wild> |
|
129 |
<*></*> |
|
130 |
<value>$establishmentMeans</value> |
|
131 |
</_map> |
|
132 |
</iscultivated> |
|
133 |
<isnative> |
|
134 |
<_map> |
|
135 |
<native>t</native> |
|
136 |
<exotic>f</exotic> |
|
137 |
<*></*> |
|
138 |
<value>$establishmentMeans</value> |
|
139 |
</_map> |
|
140 |
</isnative> |
|
141 |
<institution_id><party><organizationname>$institutionCode</organizationname></party></institution_id> |
|
142 |
<sourceaccessioncode>$id</sourceaccessioncode> |
|
143 |
</specimenreplicate> |
|
144 |
</VegBIEN> |
|
1 | 145 |
Inserted 16 new rows into database |
inputs/XAL/test/import.specimens.out.ref | ||
---|---|---|
1 |
Put template: |
|
2 |
<VegBIEN> |
|
3 |
<_ignore><inLabel>XAL</inLabel></_ignore> |
|
4 |
<specimenreplicate id="-1"> |
|
5 |
<datasource_id><party><organizationname><_alt><2>XAL</2></_alt></organizationname></party></datasource_id> |
|
6 |
<locationevent_id> |
|
7 |
<locationevent> |
|
8 |
<location_id> |
|
9 |
<location> |
|
10 |
<datasource_id><party><organizationname><_alt><2>XAL</2></_alt></organizationname></party></datasource_id> |
|
11 |
<locationdetermination> |
|
12 |
<coordsaccuracy><_noCV><value><_alt><2>$CoordinatePrecision</2></_alt></value></_noCV></coordsaccuracy> |
|
13 |
<namedplace_id> |
|
14 |
<_simplifyPath> |
|
15 |
<next>parent_id/namedplace</next> |
|
16 |
<require>placename</require> |
|
17 |
<path> |
|
18 |
<namedplace> |
|
19 |
<rank>county</rank> |
|
20 |
<placename>$County</placename> |
|
21 |
<parent_id> |
|
22 |
<namedplace> |
|
23 |
<rank>stateProvince</rank> |
|
24 |
<placename>$StateProvince</placename> |
|
25 |
<parent_id> |
|
26 |
<namedplace> |
|
27 |
<rank>country</rank> |
|
28 |
<placename>$Country</placename> |
|
29 |
<parent_id> |
|
30 |
<namedplace> |
|
31 |
<rank>continent</rank> |
|
32 |
<placename>$ContinentOcean</placename> |
|
33 |
</namedplace> |
|
34 |
</parent_id> |
|
35 |
</namedplace> |
|
36 |
</parent_id> |
|
37 |
</namedplace> |
|
38 |
</parent_id> |
|
39 |
</namedplace> |
|
40 |
</path> |
|
41 |
</_simplifyPath> |
|
42 |
</namedplace_id> |
|
43 |
<latitude> |
|
44 |
<_alt> |
|
45 |
<1> |
|
46 |
<_nullIf> |
|
47 |
<null>0</null> |
|
48 |
<type>float</type> |
|
49 |
<value>$Latitude</value> |
|
50 |
</_nullIf> |
|
51 |
</1> |
|
52 |
</_alt> |
|
53 |
</latitude> |
|
54 |
<longitude> |
|
55 |
<_alt> |
|
56 |
<1> |
|
57 |
<_nullIf> |
|
58 |
<null>0</null> |
|
59 |
<type>float</type> |
|
60 |
<value>$Longitude</value> |
|
61 |
</_nullIf> |
|
62 |
</1> |
|
63 |
</_alt> |
|
64 |
</longitude> |
|
65 |
</locationdetermination> |
|
66 |
<locationnarrative><_merge><1>$Locality</1></_merge></locationnarrative> |
|
67 |
<elevation> |
|
68 |
<_alt> |
|
69 |
<2> |
|
70 |
<_avg> |
|
71 |
<min> |
|
72 |
<_units> |
|
73 |
<default>m</default> |
|
74 |
<to>m</to> |
|
75 |
<to></to> |
|
76 |
<value> |
|
77 |
<_rangeStart> |
|
78 |
<value> |
|
79 |
<_replace> |
|
80 |
<\bca\.?></\bca\.?> |
|
81 |
<value>$MinimumElevation</value> |
|
82 |
</_replace> |
|
83 |
</value> |
|
84 |
</_rangeStart> |
|
85 |
</value> |
|
86 |
</_units> |
|
87 |
</min> |
|
88 |
<max> |
|
89 |
<_units> |
|
90 |
<default>m</default> |
|
91 |
<to>m</to> |
|
92 |
<to></to> |
|
93 |
<value>$MaximumElevation</value> |
|
94 |
</_units> |
|
95 |
</max> |
|
96 |
</_avg> |
|
97 |
</2> |
|
98 |
</_alt> |
|
99 |
</elevation> |
|
100 |
<elevationrange> |
|
101 |
<_range> |
|
102 |
<from> |
|
103 |
<_units> |
|
104 |
<default>m</default> |
|
105 |
<to>m</to> |
|
106 |
<to></to> |
|
107 |
<value> |
|
108 |
<_rangeStart> |
|
109 |
<value> |
|
110 |
<_replace> |
|
111 |
<\bca\.?></\bca\.?> |
|
112 |
<value>$MinimumElevation</value> |
|
113 |
</_replace> |
|
114 |
</value> |
|
115 |
</_rangeStart> |
|
116 |
</value> |
|
117 |
</_units> |
|
118 |
</from> |
|
119 |
<to> |
|
120 |
<_units> |
|
121 |
<default>m</default> |
|
122 |
<to>m</to> |
|
123 |
<to></to> |
|
124 |
<value> |
|
125 |
<_alt> |
|
126 |
<2> |
|
127 |
<_rangeEnd> |
|
128 |
<value> |
|
129 |
<_replace> |
|
130 |
<\bca\.?></\bca\.?> |
|
131 |
<value>$MinimumElevation</value> |
|
132 |
</_replace> |
|
133 |
</value> |
|
134 |
</_rangeEnd> |
|
135 |
</2> |
|
136 |
<1>$MaximumElevation</1> |
|
137 |
</_alt> |
|
138 |
</value> |
|
139 |
</_units> |
|
140 |
</to> |
|
141 |
</_range> |
|
142 |
</elevationrange> |
|
143 |
<centerlatitude> |
|
144 |
<_alt> |
|
145 |
<1> |
|
146 |
<_nullIf> |
|
147 |
<null>0</null> |
|
148 |
<type>float</type> |
|
149 |
<value>$Latitude</value> |
|
150 |
</_nullIf> |
|
151 |
</1> |
|
152 |
</_alt> |
|
153 |
</centerlatitude> |
|
154 |
<centerlongitude> |
|
155 |
<_alt> |
|
156 |
<1> |
|
157 |
<_nullIf> |
|
158 |
<null>0</null> |
|
159 |
<type>float</type> |
|
160 |
<value>$Longitude</value> |
|
161 |
</_nullIf> |
|
162 |
</1> |
|
163 |
</_alt> |
|
164 |
</centerlongitude> |
|
165 |
<sourceaccessioncode> |
|
166 |
<_alt> |
|
167 |
<2> |
|
168 |
<_merge> |
|
169 |
<3>$CatalogNumber</3> |
|
170 |
<2>$CollectionCode</2> |
|
171 |
<1>$InstitutionCode</1> |
|
172 |
</_merge> |
|
173 |
</2> |
|
174 |
</_alt> |
|
175 |
</sourceaccessioncode> |
|
176 |
</location> |
|
177 |
</location_id> |
|
178 |
<waterdepth> |
|
179 |
<_avg> |
|
180 |
<max> |
|
181 |
<_units> |
|
182 |
<default>m</default> |
|
183 |
<to>m</to> |
|
184 |
<to></to> |
|
185 |
<value>$MaximumDepth</value> |
|
186 |
</_units> |
|
187 |
</max> |
|
188 |
<min> |
|
189 |
<_units> |
|
190 |
<default>m</default> |
|
191 |
<to>m</to> |
|
192 |
<to></to> |
|
193 |
<value>$MinimumDepth</value> |
|
194 |
</_units> |
|
195 |
</min> |
|
196 |
</_avg> |
|
197 |
</waterdepth> |
|
198 |
<obsstartdate> |
|
199 |
<_date> |
|
200 |
<date> |
|
201 |
<_dateRangeStart> |
|
202 |
<value> |
|
203 |
<_alt> |
|
204 |
<1> |
|
205 |
<_date> |
|
206 |
<day> |
|
207 |
<_nullIf> |
|
208 |
<null>0</null> |
|
209 |
<type>float</type> |
|
210 |
<value>$DayCollected</value> |
|
211 |
</_nullIf> |
|
212 |
</day> |
|
213 |
<month> |
|
214 |
<_nullIf> |
|
215 |
<null>0</null> |
|
216 |
<type>float</type> |
|
217 |
<value>$MonthCollected</value> |
|
218 |
</_nullIf> |
|
219 |
</month> |
|
220 |
<year> |
|
221 |
<_nullIf> |
|
222 |
<null>0</null> |
|
223 |
<type>float</type> |
|
224 |
<value>$YearCollected</value> |
|
225 |
</_nullIf> |
|
226 |
</year> |
|
227 |
</_date> |
|
228 |
</1> |
|
229 |
</_alt> |
|
230 |
</value> |
|
231 |
</_dateRangeStart> |
|
232 |
</date> |
|
233 |
</_date> |
|
234 |
</obsstartdate> |
|
235 |
<obsenddate> |
|
236 |
<_date> |
|
237 |
<date> |
|
238 |
<_dateRangeEnd> |
|
239 |
<value> |
|
240 |
<_alt> |
|
241 |
<1> |
|
242 |
<_date> |
|
243 |
<day> |
|
244 |
<_nullIf> |
|
245 |
<null>0</null> |
|
246 |
<type>float</type> |
|
247 |
<value>$DayCollected</value> |
|
248 |
</_nullIf> |
|
249 |
</day> |
|
250 |
<month> |
|
251 |
<_nullIf> |
|
252 |
<null>0</null> |
|
253 |
<type>float</type> |
|
254 |
<value>$MonthCollected</value> |
|
255 |
</_nullIf> |
|
256 |
</month> |
|
257 |
<year> |
|
258 |
<_nullIf> |
|
259 |
<null>0</null> |
|
260 |
<type>float</type> |
|
261 |
<value>$YearCollected</value> |
|
262 |
</_nullIf> |
|
263 |
</year> |
|
264 |
</_date> |
|
265 |
</1> |
|
266 |
</_alt> |
|
267 |
</value> |
|
268 |
</_dateRangeEnd> |
|
269 |
</date> |
|
270 |
</_date> |
|
271 |
</obsenddate> |
|
272 |
</locationevent> |
|
273 |
</locationevent_id> |
|
274 |
<collectionnumber> |
|
275 |
<_alt> |
|
276 |
<1><_alt><1>$CollectorNumber</1></_alt></1> |
|
277 |
<3>$FieldNumber</3> |
|
278 |
</_alt> |
|
279 |
</collectionnumber> |
|
280 |
<definedvalue fkey="tablerecord_id"> |
|
281 |
<userdefined_id> |
|
282 |
<userdefined> |
|
283 |
<tablename>specimenreplicate</tablename> |
|
284 |
<userdefinedname>sex</userdefinedname> |
|
285 |
</userdefined> |
|
286 |
</userdefined_id> |
|
287 |
<definedvalue>$Sex</definedvalue> |
|
288 |
</definedvalue> |
|
289 |
<description><_merge><1>$Notes</1></_merge></description> |
|
290 |
<taxondetermination> |
|
291 |
<role>identifier</role> |
|
292 |
<determinationdate> |
|
293 |
<_date> |
|
294 |
<date> |
|
295 |
<_dateRangeStart> |
|
296 |
<value> |
|
297 |
<_alt> |
|
298 |
<1> |
|
299 |
<_date> |
|
300 |
<day> |
|
301 |
<_nullIf> |
|
302 |
<null>0</null> |
|
303 |
<type>float</type> |
|
304 |
<value>$DayIdentified</value> |
|
305 |
</_nullIf> |
|
306 |
</day> |
|
307 |
<month> |
|
308 |
<_nullIf> |
|
309 |
<null>0</null> |
|
310 |
<type>float</type> |
|
311 |
<value>$MonthIdentified</value> |
|
312 |
</_nullIf> |
|
313 |
</month> |
|
314 |
<year> |
|
315 |
<_nullIf> |
|
316 |
<null>0</null> |
|
317 |
<type>float</type> |
|
318 |
<value>$YearIdentified</value> |
|
319 |
</_nullIf> |
|
320 |
</year> |
|
321 |
</_date> |
|
322 |
</1> |
|
323 |
</_alt> |
|
324 |
</value> |
|
325 |
</_dateRangeStart> |
|
326 |
</date> |
|
327 |
</_date> |
|
328 |
</determinationdate> |
|
329 |
<iscurrent>true</iscurrent> |
|
330 |
<party_id> |
|
331 |
<party> |
|
332 |
<givenname><_namePart><first>$IdentifiedBy</first></_namePart></givenname> |
|
333 |
<middlename><_namePart><middle>$IdentifiedBy</middle></_namePart></middlename> |
|
334 |
<surname><_namePart><last>$IdentifiedBy</last></_namePart></surname> |
|
335 |
</party> |
|
336 |
</party_id> |
|
337 |
<isoriginal>true</isoriginal> |
|
338 |
<plantconcept_id> |
|
339 |
<plantconcept> |
|
340 |
<plantname_id> |
|
341 |
<_simplifyPath> |
|
342 |
<next>parent_id/plantname</next> |
|
343 |
<require>plantname</require> |
|
344 |
<path> |
|
345 |
<plantname> |
|
346 |
<rank>binomial</rank> |
|
347 |
<plantname>$ScientificName</plantname> |
|
348 |
<parent_id> |
|
349 |
<plantname> |
|
350 |
<rank>authority</rank> |
|
351 |
<plantname>$ScientificNameAuthor</plantname> |
|
352 |
<parent_id> |
|
353 |
<plantname> |
|
354 |
<rank>subspecies</rank> |
|
355 |
<plantname>$Subspecies</plantname> |
|
356 |
<parent_id> |
|
357 |
<plantname> |
|
358 |
<rank>species</rank> |
|
359 |
<plantname>$Species</plantname> |
|
360 |
<parent_id> |
|
361 |
<plantname> |
|
362 |
<rank>genus</rank> |
|
363 |
<plantname>$Genus</plantname> |
|
364 |
<parent_id> |
|
365 |
<plantname> |
|
366 |
<rank>family</rank> |
|
367 |
<plantname>$Family</plantname> |
|
368 |
<parent_id> |
|
369 |
<plantname> |
|
370 |
<rank>order</rank> |
|
371 |
<plantname>$Order</plantname> |
|
372 |
<parent_id> |
|
373 |
<plantname> |
|
374 |
<rank>class</rank> |
|
375 |
<plantname>$Class</plantname> |
|
376 |
<parent_id> |
|
377 |
<plantname> |
|
378 |
<rank>subkingdom</rank> |
|
379 |
<plantname>$Phylum</plantname> |
|
380 |
<parent_id> |
|
381 |
<plantname> |
|
382 |
<rank>kingdom</rank> |
|
383 |
<plantname>$Kingdom</plantname> |
|
384 |
</plantname> |
|
385 |
</parent_id> |
|
386 |
</plantname> |
|
387 |
</parent_id> |
|
388 |
</plantname> |
|
389 |
</parent_id> |
|
390 |
</plantname> |
|
391 |
</parent_id> |
|
392 |
</plantname> |
|
393 |
</parent_id> |
|
394 |
</plantname> |
|
395 |
</parent_id> |
|
396 |
</plantname> |
|
397 |
</parent_id> |
|
398 |
</plantname> |
|
399 |
</parent_id> |
|
400 |
</plantname> |
|
401 |
</parent_id> |
|
402 |
</plantname> |
|
403 |
</path> |
|
404 |
</_simplifyPath> |
|
405 |
</plantname_id> |
|
406 |
</plantconcept> |
|
407 |
</plantconcept_id> |
|
408 |
</taxondetermination> |
|
409 |
<verbatimcollectorname>$Collector</verbatimcollectorname> |
|
410 |
<catalognumber_dwc>$CatalogNumber</catalognumber_dwc> |
|
411 |
<collectioncode_dwc>$CollectionCode</collectioncode_dwc> |
|
412 |
<institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id> |
|
413 |
</specimenreplicate> |
|
414 |
</VegBIEN> |
|
1 | 415 |
Inserted 41 new rows into database |
inputs/NY/test/import.specimens.out.ref | ||
---|---|---|
1 |
Put template: |
|
2 |
<VegBIEN> |
|
3 |
<_ignore><inLabel>NY</inLabel></_ignore> |
|
4 |
<specimenreplicate id="-1"> |
|
5 |
<datasource_id><party><organizationname><_alt><2>NY</2></_alt></organizationname></party></datasource_id> |
|
6 |
<locationevent_id> |
|
7 |
<locationevent> |
|
8 |
<location_id> |
|
9 |
<location> |
|
10 |
<datasource_id><party><organizationname><_alt><2>NY</2></_alt></organizationname></party></datasource_id> |
|
11 |
<locationdetermination> |
|
12 |
<coordsaccuracy><_noCV><value><_alt><2>$CoordinatePrecision</2></_alt></value></_noCV></coordsaccuracy> |
|
13 |
<footprintgeometry_dwc>$BoundingBox</footprintgeometry_dwc> |
|
14 |
<namedplace_id> |
|
15 |
<_simplifyPath> |
|
16 |
<next>parent_id/namedplace</next> |
|
17 |
<require>placename</require> |
|
18 |
<path> |
|
19 |
<namedplace> |
|
20 |
<rank>county</rank> |
|
21 |
<placename>$County</placename> |
|
22 |
<parent_id> |
|
23 |
<namedplace> |
|
24 |
<rank>stateProvince</rank> |
|
25 |
<placename>$StateProvince</placename> |
|
26 |
<parent_id> |
|
27 |
<namedplace> |
|
28 |
<rank>country</rank> |
|
29 |
<placename>$Country</placename> |
|
30 |
<parent_id> |
|
31 |
<namedplace> |
|
32 |
<rank>continent</rank> |
|
33 |
<placename>$ContinentOcean</placename> |
|
34 |
</namedplace> |
|
35 |
</parent_id> |
|
36 |
</namedplace> |
|
37 |
</parent_id> |
|
38 |
</namedplace> |
|
39 |
</parent_id> |
|
40 |
</namedplace> |
|
41 |
</path> |
|
42 |
</_simplifyPath> |
|
43 |
</namedplace_id> |
|
44 |
<latitude> |
|
45 |
<_alt> |
|
46 |
<1> |
|
47 |
<_nullIf> |
|
48 |
<null>0</null> |
|
49 |
<type>float</type> |
|
50 |
<value>$Latitude</value> |
|
51 |
</_nullIf> |
|
52 |
</1> |
|
53 |
</_alt> |
|
54 |
</latitude> |
|
55 |
<longitude> |
|
56 |
<_alt> |
|
57 |
<1> |
|
58 |
<_nullIf> |
|
59 |
<null>0</null> |
|
60 |
<type>float</type> |
|
61 |
<value>$Longitude</value> |
|
62 |
</_nullIf> |
|
63 |
</1> |
|
64 |
</_alt> |
|
65 |
</longitude> |
|
66 |
</locationdetermination> |
|
67 |
<locationnarrative> |
|
68 |
<_merge> |
|
69 |
<1> |
|
70 |
<_merge> |
|
71 |
<1>$Locality</1> |
|
72 |
<2> |
|
73 |
<_label> |
|
74 |
<label>substrate</label> |
|
75 |
<value>$Substrate</value> |
|
76 |
</_label> |
|
77 |
</2> |
|
78 |
<3> |
|
79 |
<_label> |
|
80 |
<label>vegetation</label> |
|
81 |
<value>$Vegetation</value> |
|
82 |
</_label> |
|
83 |
</3> |
|
84 |
</_merge> |
|
85 |
</1> |
|
86 |
<3> |
|
87 |
<_label> |
|
88 |
<label>habitat</label> |
|
89 |
<value>$Habitat</value> |
|
90 |
</_label> |
|
91 |
</3> |
|
92 |
</_merge> |
|
93 |
</locationnarrative> |
|
94 |
<elevation> |
|
95 |
<_alt> |
|
96 |
<2> |
|
97 |
<_avg> |
|
98 |
<min> |
|
99 |
<_units> |
|
100 |
<default>m</default> |
|
101 |
<to>m</to> |
|
102 |
<to></to> |
|
103 |
<value> |
|
104 |
<_rangeStart> |
|
105 |
<value> |
|
106 |
<_replace> |
|
107 |
<\bca\.?></\bca\.?> |
|
108 |
<value> |
|
109 |
<_nullIf> |
|
110 |
<null>.</null> |
|
111 |
<value>$MinimumElevation</value> |
|
112 |
</_nullIf> |
|
113 |
</value> |
|
114 |
</_replace> |
|
115 |
</value> |
|
116 |
</_rangeStart> |
|
117 |
</value> |
|
118 |
</_units> |
|
119 |
</min> |
|
120 |
<max> |
|
121 |
<_units> |
|
122 |
<default>m</default> |
|
123 |
<to>m</to> |
|
124 |
<to></to> |
|
125 |
<value>$MaximumElevation</value> |
|
126 |
</_units> |
|
127 |
</max> |
|
128 |
</_avg> |
|
129 |
</2> |
|
130 |
</_alt> |
|
131 |
</elevation> |
|
132 |
<elevationrange> |
|
133 |
<_range> |
|
134 |
<from> |
|
135 |
<_units> |
|
136 |
<default>m</default> |
|
137 |
<to>m</to> |
|
138 |
<to></to> |
|
139 |
<value> |
|
140 |
<_rangeStart> |
|
141 |
<value> |
|
142 |
<_replace> |
|
143 |
<\bca\.?></\bca\.?> |
|
144 |
<value> |
|
145 |
<_nullIf> |
|
146 |
<null>.</null> |
|
147 |
<value>$MinimumElevation</value> |
|
148 |
</_nullIf> |
|
149 |
</value> |
|
150 |
</_replace> |
|
151 |
</value> |
|
152 |
</_rangeStart> |
|
153 |
</value> |
|
154 |
</_units> |
|
155 |
</from> |
|
156 |
<to> |
|
157 |
<_units> |
|
158 |
<default>m</default> |
|
159 |
<to>m</to> |
|
160 |
<to></to> |
|
161 |
<value> |
|
162 |
<_alt> |
|
163 |
<2> |
|
164 |
<_rangeEnd> |
|
165 |
<value> |
|
166 |
<_replace> |
|
167 |
<\bca\.?></\bca\.?> |
|
168 |
<value> |
|
169 |
<_nullIf> |
|
170 |
<null>.</null> |
|
171 |
<value>$MinimumElevation</value> |
|
172 |
</_nullIf> |
|
173 |
</value> |
|
174 |
</_replace> |
|
175 |
</value> |
|
176 |
</_rangeEnd> |
|
177 |
</2> |
|
178 |
<1>$MaximumElevation</1> |
|
179 |
</_alt> |
|
180 |
</value> |
|
181 |
</_units> |
|
182 |
</to> |
|
183 |
</_range> |
|
184 |
</elevationrange> |
|
185 |
<centerlatitude> |
|
186 |
<_alt> |
|
187 |
<1> |
|
188 |
<_nullIf> |
|
189 |
<null>0</null> |
|
190 |
<type>float</type> |
|
191 |
<value>$Latitude</value> |
|
192 |
</_nullIf> |
|
193 |
</1> |
|
194 |
</_alt> |
|
195 |
</centerlatitude> |
|
196 |
<centerlongitude> |
|
197 |
<_alt> |
|
198 |
<1> |
|
199 |
<_nullIf> |
|
200 |
<null>0</null> |
|
201 |
<type>float</type> |
|
202 |
<value>$Longitude</value> |
|
203 |
</_nullIf> |
|
204 |
</1> |
|
205 |
</_alt> |
|
206 |
</centerlongitude> |
|
207 |
<sourceaccessioncode> |
|
208 |
<_alt> |
|
209 |
<2> |
|
210 |
<_merge> |
|
211 |
<3>$CatalogNumber</3> |
|
212 |
<2>$CollectionCode</2> |
|
213 |
<1>$InstitutionCode</1> |
|
214 |
</_merge> |
|
215 |
</2> |
|
216 |
<1>$UniqueNYInternalRecordNumber</1> |
|
217 |
</_alt> |
|
218 |
</sourceaccessioncode> |
|
219 |
</location> |
|
220 |
</location_id> |
|
221 |
<waterdepth> |
|
222 |
<_avg> |
|
223 |
<max> |
|
224 |
<_units> |
|
225 |
<default>m</default> |
|
226 |
<to>m</to> |
|
227 |
<to></to> |
|
228 |
<value>$MaximumDepth</value> |
|
229 |
</_units> |
|
230 |
</max> |
|
231 |
<min> |
|
232 |
<_units> |
|
233 |
<default>m</default> |
|
234 |
<to>m</to> |
|
235 |
<to></to> |
|
236 |
<value>$MinimumDepth</value> |
|
237 |
</_units> |
|
238 |
</min> |
|
239 |
</_avg> |
|
240 |
</waterdepth> |
|
241 |
<obsstartdate> |
|
242 |
<_date> |
|
243 |
<date> |
|
244 |
<_dateRangeStart> |
|
245 |
<value> |
|
246 |
<_alt> |
|
247 |
<1> |
|
248 |
<_date> |
|
249 |
<day> |
|
250 |
<_nullIf> |
|
251 |
<null>0</null> |
|
252 |
<type>float</type> |
|
253 |
<value>$DayCollected</value> |
|
254 |
</_nullIf> |
|
255 |
</day> |
|
256 |
<month> |
|
257 |
<_nullIf> |
|
258 |
<null>0</null> |
|
259 |
<type>float</type> |
|
260 |
<value>$MonthCollected</value> |
|
261 |
</_nullIf> |
|
262 |
</month> |
|
263 |
<year> |
|
264 |
<_nullIf> |
|
265 |
<null>0</null> |
|
266 |
<type>float</type> |
|
267 |
<value>$YearCollected</value> |
|
268 |
</_nullIf> |
|
269 |
</year> |
|
270 |
</_date> |
|
271 |
</1> |
|
272 |
</_alt> |
|
273 |
</value> |
|
274 |
</_dateRangeStart> |
|
275 |
</date> |
|
276 |
</_date> |
|
277 |
</obsstartdate> |
|
278 |
<obsenddate> |
|
279 |
<_date> |
|
280 |
<date> |
|
281 |
<_dateRangeEnd> |
|
282 |
<value> |
|
283 |
<_alt> |
|
284 |
<1> |
|
285 |
<_date> |
|
286 |
<day> |
|
287 |
<_nullIf> |
|
288 |
<null>0</null> |
|
289 |
<type>float</type> |
|
290 |
<value>$DayCollected</value> |
|
291 |
</_nullIf> |
|
292 |
</day> |
|
293 |
<month> |
|
294 |
<_nullIf> |
|
295 |
<null>0</null> |
|
296 |
<type>float</type> |
|
297 |
<value>$MonthCollected</value> |
|
298 |
</_nullIf> |
|
299 |
</month> |
|
300 |
<year> |
|
301 |
<_nullIf> |
|
302 |
<null>0</null> |
|
303 |
<type>float</type> |
|
304 |
<value>$YearCollected</value> |
|
305 |
</_nullIf> |
|
306 |
</year> |
|
307 |
</_date> |
|
308 |
</1> |
|
309 |
</_alt> |
|
310 |
</value> |
|
311 |
</_dateRangeEnd> |
|
312 |
</date> |
|
313 |
</_date> |
|
314 |
</obsenddate> |
|
315 |
</locationevent> |
|
316 |
</locationevent_id> |
|
317 |
<collectionnumber> |
|
318 |
<_alt> |
|
319 |
<1><_alt><1>$CollectorNumber</1></_alt></1> |
|
320 |
<3>$FieldNumber</3> |
|
321 |
</_alt> |
|
322 |
</collectionnumber> |
|
323 |
<definedvalue fkey="tablerecord_id"> |
|
324 |
<userdefined_id> |
|
325 |
<userdefined> |
|
326 |
<tablename>specimenreplicate</tablename> |
|
327 |
<userdefinedname>sex</userdefinedname> |
|
328 |
</userdefined> |
|
329 |
</userdefined_id> |
|
330 |
<definedvalue>$Sex</definedvalue> |
|
331 |
</definedvalue> |
|
332 |
<description> |
|
333 |
<_merge> |
|
334 |
<1> |
|
335 |
<_merge> |
|
336 |
<1>$Notes</1> |
|
337 |
<2> |
|
338 |
<_label> |
|
339 |
<label>plant fungus</label> |
|
340 |
<value>$PlantFungusDescription</value> |
|
341 |
</_label> |
|
342 |
</2> |
|
343 |
</_merge> |
|
344 |
</1> |
|
345 |
</_merge> |
|
346 |
</description> |
|
347 |
<taxondetermination> |
|
348 |
<role>identifier</role> |
|
349 |
<determinationdate> |
|
350 |
<_date> |
|
351 |
<date> |
|
352 |
<_dateRangeStart> |
|
353 |
<value> |
|
354 |
<_alt> |
|
355 |
<1> |
|
356 |
<_date> |
|
357 |
<day> |
|
358 |
<_nullIf> |
|
359 |
<null>0</null> |
|
360 |
<type>float</type> |
|
361 |
<value>$DayIdentified</value> |
|
362 |
</_nullIf> |
|
363 |
</day> |
|
364 |
<month> |
|
365 |
<_nullIf> |
|
366 |
<null>0</null> |
|
367 |
<type>float</type> |
|
368 |
<value>$MonthIdentified</value> |
|
369 |
</_nullIf> |
|
370 |
</month> |
|
371 |
<year> |
|
372 |
<_nullIf> |
|
373 |
<null>0</null> |
|
374 |
<type>float</type> |
|
375 |
<value>$YearIdentified</value> |
|
376 |
</_nullIf> |
|
377 |
</year> |
|
378 |
</_date> |
|
379 |
</1> |
|
380 |
</_alt> |
|
381 |
</value> |
|
382 |
</_dateRangeStart> |
|
383 |
</date> |
|
384 |
</_date> |
|
385 |
</determinationdate> |
|
386 |
<iscurrent>true</iscurrent> |
|
387 |
<party_id> |
|
388 |
<party> |
|
389 |
<givenname><_namePart><first>$IdentifiedBy</first></_namePart></givenname> |
|
390 |
<middlename><_namePart><middle>$IdentifiedBy</middle></_namePart></middlename> |
|
391 |
<surname><_namePart><last>$IdentifiedBy</last></_namePart></surname> |
|
392 |
</party> |
|
393 |
</party_id> |
|
394 |
<isoriginal>true</isoriginal> |
|
395 |
<plantconcept_id> |
|
396 |
<plantconcept> |
|
397 |
<plantname_id> |
|
398 |
<_simplifyPath> |
|
399 |
<next>parent_id/plantname</next> |
|
400 |
<require>plantname</require> |
|
401 |
<path> |
|
402 |
<plantname> |
|
403 |
<rank>binomial</rank> |
|
404 |
<plantname>$ScientificName</plantname> |
|
405 |
<parent_id> |
|
406 |
<plantname> |
|
407 |
<rank>authority</rank> |
|
408 |
<plantname>$ScientificNameAuthor</plantname> |
|
409 |
<parent_id> |
|
410 |
<plantname> |
|
411 |
<rank>subspecies</rank> |
|
412 |
<plantname>$Subspecies</plantname> |
|
413 |
<parent_id> |
|
414 |
<plantname> |
|
415 |
<rank>species</rank> |
|
416 |
<plantname>$Species</plantname> |
|
417 |
<parent_id> |
|
418 |
<plantname> |
|
419 |
<rank>genus</rank> |
|
420 |
<plantname>$Genus</plantname> |
|
421 |
<parent_id> |
|
422 |
<plantname> |
|
423 |
<rank>family</rank> |
|
424 |
<plantname>$Family</plantname> |
|
425 |
<parent_id> |
|
426 |
<plantname> |
|
427 |
<rank>order</rank> |
|
428 |
<plantname>$Order</plantname> |
|
429 |
<parent_id> |
|
430 |
<plantname> |
|
431 |
<rank>class</rank> |
|
432 |
<plantname>$Class</plantname> |
|
433 |
<parent_id> |
|
434 |
<plantname> |
|
435 |
<rank>subkingdom</rank> |
|
436 |
<plantname>$Phylum</plantname> |
|
437 |
<parent_id> |
|
438 |
<plantname> |
|
439 |
<rank>kingdom</rank> |
|
440 |
<plantname>$Kingdom</plantname> |
|
441 |
</plantname> |
|
442 |
</parent_id> |
|
443 |
</plantname> |
|
444 |
</parent_id> |
|
445 |
</plantname> |
|
446 |
</parent_id> |
|
447 |
</plantname> |
|
448 |
</parent_id> |
|
449 |
</plantname> |
|
450 |
</parent_id> |
|
451 |
</plantname> |
|
452 |
</parent_id> |
|
453 |
</plantname> |
|
454 |
</parent_id> |
|
455 |
</plantname> |
|
456 |
</parent_id> |
|
457 |
</plantname> |
|
458 |
</parent_id> |
|
459 |
</plantname> |
|
460 |
</path> |
|
461 |
</_simplifyPath> |
|
462 |
</plantname_id> |
|
463 |
</plantconcept> |
|
464 |
</plantconcept_id> |
|
465 |
</taxondetermination> |
|
466 |
<verbatimcollectorname>$Collector</verbatimcollectorname> |
|
467 |
<catalognumber_dwc>$CatalogNumber</catalognumber_dwc> |
|
468 |
<collectioncode_dwc>$CollectionCode</collectioncode_dwc> |
|
469 |
<institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id> |
|
470 |
<sourceaccessioncode>$UniqueNYInternalRecordNumber</sourceaccessioncode> |
|
471 |
</specimenreplicate> |
|
472 |
</VegBIEN> |
|
1 | 473 |
Inserted 33 new rows into database |
inputs/Madidi/test/import.plots.out.ref | ||
---|---|---|
1 |
Inserted 0 new rows into database |
|
1 |
Put template: |
|
2 |
<VegBIEN><_ignore><inLabel>Madidi</inLabel></_ignore></VegBIEN>Inserted 0 new rows into database |
inputs/Madidi/test/import.organisms.out.ref | ||
---|---|---|
1 |
Inserted 0 new rows into database |
|
1 |
Put template: |
|
2 |
<VegBIEN><_ignore><inLabel>Madidi</inLabel></_ignore></VegBIEN>Inserted 0 new rows into database |
inputs/UNCC/test/import.specimens.out.ref | ||
---|---|---|
1 |
Put template: |
|
2 |
<VegBIEN> |
|
3 |
<_ignore><inLabel>UNCC</inLabel></_ignore> |
|
4 |
<specimenreplicate id="-1"> |
|
5 |
<datasource_id><party><organizationname><_alt><2>UNCC</2></_alt></organizationname></party></datasource_id> |
|
6 |
<locationevent_id> |
|
7 |
<locationevent> |
|
8 |
<location_id> |
|
9 |
<location> |
|
10 |
<datasource_id><party><organizationname><_alt><2>UNCC</2></_alt></organizationname></party></datasource_id> |
|
11 |
<locationdetermination> |
|
12 |
<namedplace_id> |
|
13 |
<_simplifyPath> |
|
14 |
<next>parent_id/namedplace</next> |
|
15 |
<require>placename</require> |
|
16 |
<path> |
|
17 |
<namedplace> |
|
18 |
<rank>county</rank> |
|
19 |
<placename>$county</placename> |
|
20 |
<parent_id> |
|
21 |
<namedplace> |
|
22 |
<rank>stateProvince</rank> |
|
23 |
<placename>$state</placename> |
|
24 |
<parent_id> |
|
25 |
<namedplace> |
|
26 |
<rank>country</rank> |
|
27 |
<placename>$country</placename> |
|
28 |
</namedplace> |
|
29 |
</parent_id> |
|
30 |
</namedplace> |
|
31 |
</parent_id> |
|
32 |
</namedplace> |
|
33 |
</path> |
|
34 |
</_simplifyPath> |
|
35 |
</namedplace_id> |
|
36 |
</locationdetermination> |
|
37 |
<locationnarrative> |
|
38 |
<_merge> |
|
39 |
<1>$locality</1> |
|
40 |
<3> |
|
41 |
<_label> |
|
42 |
<label>habitat</label> |
|
43 |
<value>$habitat</value> |
|
44 |
</_label> |
|
45 |
</3> |
|
46 |
</_merge> |
|
47 |
</locationnarrative> |
|
48 |
<sourceaccessioncode> |
|
49 |
<_alt> |
|
50 |
<2><_merge><2>$herbarium</2></_merge></2> |
|
51 |
<1>$accession</1> |
|
52 |
</_alt> |
|
53 |
</sourceaccessioncode> |
|
54 |
</location> |
|
55 |
</location_id> |
|
56 |
<obsstartdate> |
|
57 |
<_date> |
|
58 |
<date> |
|
59 |
<_dateRangeStart> |
|
60 |
<value> |
|
61 |
<_alt> |
|
62 |
<1> |
|
63 |
<_date> |
|
64 |
<day> |
|
65 |
<_nullIf> |
|
66 |
<null>0</null> |
|
67 |
<type>float</type> |
|
68 |
<value>$collday</value> |
|
69 |
</_nullIf> |
|
70 |
</day> |
|
71 |
<month> |
|
72 |
<_nullIf> |
|
73 |
<null>0</null> |
|
74 |
<type>float</type> |
|
75 |
<value>$collmonth</value> |
|
76 |
</_nullIf> |
|
77 |
</month> |
|
78 |
<year> |
|
79 |
<_nullIf> |
|
80 |
<null>0</null> |
|
81 |
<type>float</type> |
|
82 |
<value>$collyear</value> |
|
83 |
</_nullIf> |
|
84 |
</year> |
|
85 |
</_date> |
|
86 |
</1> |
|
87 |
</_alt> |
|
88 |
</value> |
|
89 |
</_dateRangeStart> |
|
90 |
</date> |
|
91 |
</_date> |
|
92 |
</obsstartdate> |
|
93 |
<obsenddate> |
|
94 |
<_date> |
|
95 |
<date> |
|
96 |
<_dateRangeEnd> |
|
97 |
<value> |
|
98 |
<_alt> |
|
99 |
<1> |
|
100 |
<_date> |
|
101 |
<day> |
|
102 |
<_nullIf> |
|
103 |
<null>0</null> |
|
104 |
<type>float</type> |
|
105 |
<value>$collday</value> |
|
106 |
</_nullIf> |
|
107 |
</day> |
|
108 |
<month> |
|
109 |
<_nullIf> |
|
110 |
<null>0</null> |
|
111 |
<type>float</type> |
|
112 |
<value>$collmonth</value> |
|
113 |
</_nullIf> |
|
114 |
</month> |
|
115 |
<year> |
|
116 |
<_nullIf> |
|
117 |
<null>0</null> |
|
118 |
<type>float</type> |
|
119 |
<value>$collyear</value> |
|
120 |
</_nullIf> |
|
121 |
</year> |
|
122 |
</_date> |
|
123 |
</1> |
|
124 |
</_alt> |
|
125 |
</value> |
|
126 |
</_dateRangeEnd> |
|
127 |
</date> |
|
128 |
</_date> |
|
129 |
</obsenddate> |
|
130 |
</locationevent> |
|
131 |
</locationevent_id> |
|
132 |
<collectionnumber><_alt><1><_alt><1>$collectno</1></_alt></1></_alt></collectionnumber> |
|
133 |
<description> |
|
134 |
<_merge> |
|
135 |
<1> |
|
136 |
<_merge> |
|
137 |
<1>$comment1</1> |
|
138 |
<2>$comment2</2> |
|
139 |
<3>$comment3</3> |
|
140 |
<4>$comment4</4> |
|
141 |
<5> |
|
142 |
<_label> |
|
143 |
<label>campus</label> |
|
144 |
<value>$campus</value> |
|
145 |
</_label> |
|
146 |
</5> |
|
147 |
<6> |
|
148 |
<_label> |
|
149 |
<label>loaned to</label> |
|
150 |
<value>$loanto</value> |
|
151 |
</_label> |
|
152 |
</6> |
|
153 |
<7> |
|
154 |
<_label> |
|
155 |
<label>in or out</label> |
|
156 |
<value>$inorout</value> |
|
157 |
</_label> |
|
158 |
</7> |
|
159 |
</_merge> |
|
160 |
</1> |
|
161 |
</_merge> |
|
162 |
</description> |
|
163 |
<taxondetermination> |
|
164 |
<isoriginal>true</isoriginal> |
|
165 |
<iscurrent>true</iscurrent> |
|
166 |
<role>identifier</role> |
|
167 |
<plantconcept_id> |
|
168 |
<plantconcept> |
|
169 |
<plantname_id> |
|
170 |
<_simplifyPath> |
|
171 |
<next>parent_id/plantname</next> |
|
172 |
<require>plantname</require> |
|
173 |
<path> |
|
174 |
<plantname> |
|
175 |
<rank>binomial</rank> |
|
176 |
<plantname>$SciName</plantname> |
|
177 |
<parent_id> |
|
178 |
<plantname> |
|
179 |
<rank>authority</rank> |
|
180 |
<plantname>$authors</plantname> |
|
181 |
<parent_id> |
|
182 |
<plantname> |
|
183 |
<rank>subspecies</rank> |
|
184 |
<plantname>$infraname</plantname> |
|
185 |
<parent_id> |
|
186 |
<plantname> |
|
187 |
<rank>species</rank> |
|
188 |
<plantname>$species</plantname> |
|
189 |
<parent_id> |
|
190 |
<plantname> |
|
191 |
<rank>genus</rank> |
|
192 |
<plantname>$genus</plantname> |
|
193 |
<parent_id> |
|
194 |
<plantname> |
|
195 |
<rank>family</rank> |
|
196 |
<plantname>$family</plantname> |
|
197 |
</plantname> |
|
198 |
</parent_id> |
|
199 |
</plantname> |
|
200 |
</parent_id> |
|
201 |
</plantname> |
|
202 |
</parent_id> |
|
203 |
</plantname> |
|
204 |
</parent_id> |
|
205 |
</plantname> |
|
206 |
</parent_id> |
|
207 |
</plantname> |
|
208 |
</path> |
|
209 |
</_simplifyPath> |
|
210 |
</plantname_id> |
|
211 |
</plantconcept> |
|
212 |
</plantconcept_id> |
|
213 |
</taxondetermination> |
|
214 |
<verbatimcollectorname> |
|
215 |
<_merge> |
|
216 |
<1>$collector</1> |
|
217 |
<2>$collector1</2> |
|
218 |
<3>$collector2</3> |
|
219 |
<4>$collector3</4> |
|
220 |
</_merge> |
|
221 |
</verbatimcollectorname> |
|
222 |
<collectioncode_dwc>$herbarium</collectioncode_dwc> |
|
223 |
<growthform> |
|
224 |
<_map> |
|
225 |
<tree>*</tree> |
|
226 |
<shrub>*</shrub> |
|
227 |
<liana>*</liana> |
|
228 |
<vine>*</vine> |
|
229 |
<herb>*</herb> |
|
230 |
<hemiepiphyte>*</hemiepiphyte> |
|
231 |
<epiphyte>*</epiphyte> |
|
232 |
<grass>*</grass> |
|
233 |
<forb>*</forb> |
|
234 |
<moss>*</moss> |
|
235 |
<lichen>*</lichen> |
|
236 |
<fungus>*</fungus> |
|
237 |
<floating aquatic>*</floating aquatic> |
|
238 |
<submerged aquatic>*</submerged aquatic> |
|
239 |
<*></*> |
|
240 |
<value> |
|
241 |
<_map> |
|
242 |
<Y>cultivated</Y> |
|
243 |
<N>wild</N> |
|
244 |
<*></*> |
|
245 |
<value>$cultivated</value> |
|
246 |
</_map> |
|
247 |
</value> |
|
248 |
</_map> |
|
249 |
</growthform> |
|
250 |
<iscultivated> |
|
251 |
<_map> |
|
252 |
<cultivated>t</cultivated> |
|
253 |
<wild>f</wild> |
|
254 |
<*></*> |
|
255 |
<value> |
|
256 |
<_map> |
|
257 |
<Y>cultivated</Y> |
|
258 |
<N>wild</N> |
|
259 |
<*></*> |
|
260 |
<value>$cultivated</value> |
|
261 |
</_map> |
|
262 |
</value> |
|
263 |
</_map> |
|
264 |
</iscultivated> |
|
265 |
<isnative> |
|
266 |
<_map> |
|
267 |
<native>t</native> |
|
268 |
<exotic>f</exotic> |
|
269 |
<*></*> |
|
270 |
<value> |
|
271 |
<_map> |
|
272 |
<Y>cultivated</Y> |
|
273 |
<N>wild</N> |
|
274 |
<*></*> |
|
275 |
<value>$cultivated</value> |
|
276 |
</_map> |
|
277 |
</value> |
|
278 |
</_map> |
|
279 |
</isnative> |
|
280 |
<sourceaccessioncode>$accession</sourceaccessioncode> |
|
281 |
</specimenreplicate> |
|
282 |
</VegBIEN> |
|
1 | 283 |
Inserted 15 new rows into database |
inputs/ACAD/test/import.specimens.out.ref | ||
---|---|---|
1 |
Put template: |
|
2 |
<VegBIEN> |
|
3 |
<_ignore><inLabel>ACAD</inLabel></_ignore> |
|
4 |
<specimenreplicate id="-1"> |
|
5 |
<datasource_id><party><organizationname><_alt><2>ACAD</2></_alt></organizationname></party></datasource_id> |
|
6 |
<locationevent_id> |
|
7 |
<locationevent> |
|
8 |
<location_id> |
|
9 |
<location> |
|
10 |
<datasource_id><party><organizationname><_alt><2>ACAD</2></_alt></organizationname></party></datasource_id> |
|
11 |
<locationdetermination> |
|
12 |
<namedplace_id> |
|
13 |
<_simplifyPath> |
|
14 |
<next>parent_id/namedplace</next> |
|
15 |
<require>placename</require> |
|
16 |
<path> |
|
17 |
<namedplace> |
|
18 |
<rank>county</rank> |
|
19 |
<placename>$county</placename> |
|
20 |
<parent_id> |
|
21 |
<namedplace> |
|
22 |
<rank>stateProvince</rank> |
|
23 |
<placename>$stateProvince</placename> |
|
24 |
<parent_id> |
|
25 |
<namedplace> |
|
26 |
<rank>country</rank> |
|
27 |
<placename>$country</placename> |
|
28 |
<parent_id> |
|
29 |
<namedplace> |
|
30 |
<rank>continent</rank> |
|
31 |
<placename>$continent</placename> |
|
32 |
</namedplace> |
|
33 |
</parent_id> |
|
34 |
</namedplace> |
|
35 |
</parent_id> |
|
36 |
</namedplace> |
|
37 |
</parent_id> |
|
38 |
</namedplace> |
|
39 |
</path> |
|
40 |
</_simplifyPath> |
|
41 |
</namedplace_id> |
|
42 |
<latitude> |
|
43 |
<_alt> |
|
44 |
<1> |
|
45 |
<_nullIf> |
|
46 |
<null>0</null> |
|
47 |
<type>float</type> |
|
48 |
<value>$decimalLatitude</value> |
|
49 |
</_nullIf> |
|
50 |
</1> |
|
51 |
</_alt> |
|
52 |
</latitude> |
|
53 |
<longitude> |
|
54 |
<_alt> |
|
55 |
<1> |
|
56 |
<_nullIf> |
|
57 |
<null>0</null> |
|
58 |
<type>float</type> |
|
59 |
<value>$decimalLongitude</value> |
|
60 |
</_nullIf> |
|
61 |
</1> |
|
62 |
</_alt> |
|
63 |
</longitude> |
|
64 |
</locationdetermination> |
|
65 |
<locationnarrative> |
|
66 |
<_merge> |
|
67 |
<1>$locality</1> |
|
68 |
<3> |
|
69 |
<_label> |
|
70 |
<label>habitat</label> |
|
71 |
<value>$habitat</value> |
|
72 |
</_label> |
|
73 |
</3> |
|
74 |
</_merge> |
|
75 |
</locationnarrative> |
|
76 |
<centerlatitude> |
|
77 |
<_alt> |
|
78 |
<1> |
|
79 |
<_nullIf> |
|
80 |
<null>0</null> |
|
81 |
<type>float</type> |
|
82 |
<value>$decimalLatitude</value> |
|
83 |
</_nullIf> |
|
84 |
</1> |
|
85 |
</_alt> |
|
86 |
</centerlatitude> |
|
87 |
<centerlongitude> |
|
88 |
<_alt> |
|
89 |
<1> |
|
90 |
<_nullIf> |
|
91 |
<null>0</null> |
|
92 |
<type>float</type> |
|
93 |
<value>$decimalLongitude</value> |
|
94 |
</_nullIf> |
|
95 |
</1> |
|
96 |
</_alt> |
|
97 |
</centerlongitude> |
|
98 |
<sourceaccessioncode> |
|
99 |
<_alt> |
|
100 |
<2> |
|
101 |
<_merge> |
|
102 |
<3>$catalogNumber</3> |
|
103 |
<2>$collectionCode</2> |
|
104 |
<1>$institutionCode</1> |
|
105 |
</_merge> |
|
106 |
</2> |
|
107 |
<1>$id</1> |
|
108 |
</_alt> |
|
109 |
</sourceaccessioncode> |
|
110 |
</location> |
|
111 |
</location_id> |
|
112 |
<obsstartdate><_date><date><_dateRangeStart><value><_alt><2>$eventDate</2></_alt></value></_dateRangeStart></date></_date></obsstartdate> |
|
113 |
<obsenddate><_date><date><_dateRangeEnd><value><_alt><2>$eventDate</2></_alt></value></_dateRangeEnd></date></_date></obsenddate> |
|
114 |
</locationevent> |
|
115 |
</locationevent_id> |
|
116 |
<collectionnumber> |
|
117 |
<_alt> |
|
118 |
<1><_alt><2>$recordNumber</2></_alt></1> |
|
119 |
<2>$collectionID</2> |
|
120 |
</_alt> |
|
121 |
</collectionnumber> |
|
122 |
<taxondetermination> |
|
123 |
<role>identifier</role> |
|
124 |
<determinationdate><_date><date><_dateRangeStart><value><_alt><2>$dateIdentified</2></_alt></value></_dateRangeStart></date></_date></determinationdate> |
|
125 |
<iscurrent>true</iscurrent> |
|
126 |
<party_id> |
|
127 |
<party> |
|
128 |
<givenname><_namePart><first>$identifiedBy</first></_namePart></givenname> |
|
129 |
<middlename><_namePart><middle>$identifiedBy</middle></_namePart></middlename> |
|
130 |
<surname><_namePart><last>$identifiedBy</last></_namePart></surname> |
|
131 |
</party> |
|
132 |
</party_id> |
|
133 |
<isoriginal>true</isoriginal> |
|
134 |
<plantconcept_id> |
|
135 |
<plantconcept> |
|
136 |
<plantname_id> |
|
137 |
<_simplifyPath> |
|
138 |
<next>parent_id/plantname</next> |
|
139 |
<require>plantname</require> |
|
140 |
<path> |
|
141 |
<plantname> |
|
142 |
<rank>binomial</rank> |
|
143 |
<plantname>$scientificName</plantname> |
|
144 |
<parent_id> |
Also available in: Unified diff
bin/map: out_is_db: Output the put template to stdout so it will be validated in the automated testing