Project

General

Profile

Download (16.6 KB) Statistics
| Revision:

root/inputs/MO/Specimen/test.xml.ref @ 5951

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>$InstitutionCode</1>
10 
                        <2>$CollectionCode</2>
11 
                        <3>$CatalogNumber</3>
12 
                    </_join>
13 
                </authorlocationcode>
14 4753 aaronmk 
                <elevation_m>
15 4621 aaronmk 
                    <_avg>
16 4820 aaronmk 
                        <max>$MaximumElevation</max>
17 4822 aaronmk 
                        <min>$MinimumElevation</min>
18 4621 aaronmk 
                    </_avg>
19 4753 aaronmk 
                </elevation_m>
20 4621 aaronmk 
                <locationevent>
21 
                    <taxonoccurrence>
22 
                        <aggregateoccurrence>
23 
                            <collectiondate>
24 
                                <_date>
25 
                                    <day>
26 
                                        <_nullIf>
27 
                                            <null>0</null>
28 
                                            <type>float</type>
29 
                                            <value>$DayCollected</value>
30 
                                        </_nullIf>
31 
                                    </day>
32 
                                    <month>
33 
                                        <_nullIf>
34 
                                            <null>0</null>
35 
                                            <type>float</type>
36 
                                            <value>$MonthCollected</value>
37 
                                        </_nullIf>
38 
                                    </month>
39 
                                    <year>
40 
                                        <_nullIf>
41 
                                            <null>0</null>
42 
                                            <type>float</type>
43 
                                            <value>$YearCollected</value>
44 
                                        </_nullIf>
45 
                                    </year>
46 
                                </_date>
47 
                            </collectiondate>
48 
                            <count>$IndividualCount</count>
49 
                            <notes>
50 
                                <_alt>
51 
                                    <0>$convertednotes</0>
52 
                                    <1>$notes</1>
53 
                                </_alt>
54 
                            </notes>
55 
                            <plantobservation>
56 
                                <collectionnumber>$CollectorNumber</collectionnumber>
57 
                                <specimenreplicate>
58 
                                    <catalognumber_dwc>$CatalogNumber</catalognumber_dwc>
59 
                                    <collectioncode_dwc>$CollectionCode</collectioncode_dwc>
60 
                                    <institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id>
61 
                                </specimenreplicate>
62 
                            </plantobservation>
63 
                        </aggregateoccurrence>
64 
                        <taxondetermination>
65 5600 aaronmk 
                            <party_id><party><fullname>$IdentifiedBy</fullname></party></party_id>
66 5657 aaronmk 
                            <taxonverbatim_id>
67 
                                <taxonverbatim>
68 
                                    <taxonlabel_id>
69 5608 aaronmk 
                                        <taxonlabel>
70 5657 aaronmk 
                                            <matched_label_id>
71 
                                                <taxonlabel>
72 
                                                    <creator_id>
73 
                                                        <party>
74 
                                                            <creator_id>0</creator_id>
75 
                                                            <organizationname>TNRS</organizationname>
76 
                                                        </party>
77 
                                                    </creator_id>
78 
                                                    <taxonomicname>
79 
                                                        <_join_words>
80 5790 aaronmk 
                                                            <1><_taxon_family_require_std><family>$family</family></_taxon_family_require_std></1>
81 5788 aaronmk 
                                                            <2>
82 
                                                                <_join_words>
83 
                                                                    <1>
84 
                                                                        <_alt>
85 
                                                                            <1>$ScientificName</1>
86 
                                                                            <2>
87 
                                                                                <_join_words>
88 
                                                                                    <2>$genus</2>
89 
                                                                                    <3>$species</3>
90 
                                                                                    <4>$Subspecies</4>
91 
                                                                                </_join_words>
92 
                                                                            </2>
93 
                                                                        </_alt>
94 
                                                                    </1>
95 
                                                                    <2>$ScientificNameAuthor</2>
96 
                                                                </_join_words>
97 
                                                            </2>
98 5657 aaronmk 
                                                        </_join_words>
99 
                                                    </taxonomicname>
100 
                                                </taxonlabel>
101 
                                            </matched_label_id>
102 5294 aaronmk 
                                            <parent_id>
103 5608 aaronmk 
                                                <taxonlabel>
104 5294 aaronmk 
                                                    <parent_id>
105 5608 aaronmk 
                                                        <taxonlabel>
106 5657 aaronmk 
                                                            <rank>cultivar</rank>
107 5294 aaronmk 
                                                            <parent_id>
108 5608 aaronmk 
                                                                <taxonlabel>
109 5657 aaronmk 
                                                                    <rank>forma</rank>
110 5294 aaronmk 
                                                                    <parent_id>
111 5608 aaronmk 
                                                                        <taxonlabel>
112 5657 aaronmk 
                                                                            <rank>variety</rank>
113 5294 aaronmk 
                                                                            <parent_id>
114 5608 aaronmk 
                                                                                <taxonlabel>
115 5657 aaronmk 
                                                                                    <rank>subspecies</rank>
116 
                                                                                    <taxonepithet>$Subspecies</taxonepithet>
117 5294 aaronmk 
                                                                                    <parent_id>
118 5608 aaronmk 
                                                                                        <taxonlabel>
119 5657 aaronmk 
                                                                                            <rank>species</rank>
120 
                                                                                            <taxonepithet>$species</taxonepithet>
121 5294 aaronmk 
                                                                                            <parent_id>
122 5608 aaronmk 
                                                                                                <taxonlabel>
123 5657 aaronmk 
                                                                                                    <rank>genus</rank>
124 
                                                                                                    <taxonepithet>$genus</taxonepithet>
125 5294 aaronmk 
                                                                                                    <parent_id>
126 5608 aaronmk 
                                                                                                        <taxonlabel>
127 5657 aaronmk 
                                                                                                            <rank>family</rank>
128 
                                                                                                            <taxonepithet>$family</taxonepithet>
129 5294 aaronmk 
                                                                                                            <parent_id>
130 5608 aaronmk 
                                                                                                                <taxonlabel>
131 5657 aaronmk 
                                                                                                                    <rank>order</rank>
132 5294 aaronmk 
                                                                                                                    <parent_id>
133 5608 aaronmk 
                                                                                                                        <taxonlabel>
134 5657 aaronmk 
                                                                                                                            <rank>class</rank>
135 5306 aaronmk 
                                                                                                                            <parent_id>
136 5608 aaronmk 
                                                                                                                                <taxonlabel>
137 5657 aaronmk 
                                                                                                                                    <rank>phylum</rank>
138 
                                                                                                                                    <parent_id>
139 
                                                                                                                                        <taxonlabel>
140 
                                                                                                                                            <rank>kingdom</rank>
141 
                                                                                                                                            <taxonepithet>$Kingdom</taxonepithet>
142 
                                                                                                                                        </taxonlabel>
143 
                                                                                                                                    </parent_id>
144 5608 aaronmk 
                                                                                                                                </taxonlabel>
145 5306 aaronmk 
                                                                                                                            </parent_id>
146 5608 aaronmk 
                                                                                                                        </taxonlabel>
147 5294 aaronmk 
                                                                                                                    </parent_id>
148 5608 aaronmk 
                                                                                                                </taxonlabel>
149 5294 aaronmk 
                                                                                                            </parent_id>
150 5608 aaronmk 
                                                                                                        </taxonlabel>
151 5294 aaronmk 
                                                                                                    </parent_id>
152 5608 aaronmk 
                                                                                                </taxonlabel>
153 5294 aaronmk 
                                                                                            </parent_id>
154 5608 aaronmk 
                                                                                        </taxonlabel>
155 5294 aaronmk 
                                                                                    </parent_id>
156 5608 aaronmk 
                                                                                </taxonlabel>
157 5294 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 5657 aaronmk 
                                            <taxonomicname>
167 
                                                <_join_words>
168 5790 aaronmk 
                                                    <1><_taxon_family_require_std><family>$family</family></_taxon_family_require_std></1>
169 5788 aaronmk 
                                                    <2>
170 
                                                        <_join_words>
171 
                                                            <1>
172 
                                                                <_alt>
173 
                                                                    <1>$ScientificName</1>
174 
                                                                    <2>
175 
                                                                        <_join_words>
176 
                                                                            <2>$genus</2>
177 
                                                                            <3>$species</3>
178 
                                                                            <4>$Subspecies</4>
179 
                                                                        </_join_words>
180 
                                                                    </2>
181 
                                                                </_alt>
182 
                                                            </1>
183 
                                                            <2>$ScientificNameAuthor</2>
184 
                                                        </_join_words>
185 
                                                    </2>
186 5657 aaronmk 
                                                </_join_words>
187 
                                            </taxonomicname>
188 5608 aaronmk 
                                        </taxonlabel>
189 5657 aaronmk 
                                    </taxonlabel_id>
190 
                                    <author>$ScientificNameAuthor</author>
191 
                                    <family>$family</family>
192 
                                    <genus>$genus</genus>
193 5783 aaronmk 
                                    <specific_epithet>$species</specific_epithet>
194 5948 aaronmk 
                                    <taxonname>$ScientificName</taxonname>
195 5657 aaronmk 
                                </taxonverbatim>
196 
                            </taxonverbatim_id>
197 4621 aaronmk 
                        </taxondetermination>
198 
                        <verbatimcollectorname>$Collector</verbatimcollectorname>
199 
                    </taxonoccurrence>
200 
                </locationevent>
201 
                <locationnarrative>$Locality</locationnarrative>
202 4726 aaronmk 
                <locationplace>
203 5855 aaronmk 
                    <place_id>
204 
                        <place>
205 5861 aaronmk 
                            <coordinates_id>
206 
                                <coordinates>
207 
                                    <latitude_deg>
208 
                                        <_nullIf>
209 
                                            <null>0</null>
210 
                                            <type>float</type>
211 
                                            <value>$latitude</value>
212 
                                        </_nullIf>
213 
                                    </latitude_deg>
214 
                                    <longitude_deg>
215 
                                        <_nullIf>
216 
                                            <null>0</null>
217 
                                            <type>float</type>
218 
                                            <value>$longitude</value>
219 
                                        </_nullIf>
220 
                                    </longitude_deg>
221 
                                </coordinates>
222 
                            </coordinates_id>
223 4727 aaronmk 
                            <continent>$ContinentOcean</continent>
224 
                            <country>$Country</country>
225 
                            <county>$County</county>
226 
                            <stateprovince>$StateProvince</stateprovince>
227 5855 aaronmk 
                        </place>
228 
                    </place_id>
229 4726 aaronmk 
                </locationplace>
230 4621 aaronmk 
            </location>
231 
        </path>
232 
    </_simplifyPath>
233 3641 aaronmk 
</VegBIEN>
234 5861 aaronmk 
Inserted 34 new rows into database