Project

General

Profile

1 3641 aaronmk
Put template:
2
<VegBIEN>
3 4621 aaronmk
    <_simplifyPath id="-1">
4
        <next>parent_id</next>
5
        <path>
6
            <location>
7
                <authorlocationcode>
8
                    <_join>
9
                        <1>$InstitutionCD</1>
10
                        <2>$CollectionCD</2>
11
                        <3>$CatalogNO</3>
12
                    </_join>
13
                </authorlocationcode>
14
                <elevation>
15
                    <_avg>
16
                        <max>
17
                            <_units>
18
                                <default>m</default>
19
                                <to>m</to>
20
                                <to></to>
21 3984 aaronmk
                                <value>
22
                                    <_replace>
23
                                        <\bca\.?></\bca\.?>
24 4621 aaronmk
                                        <value>$MaximumElevationInMeter</value>
25 3984 aaronmk
                                    </_replace>
26
                                </value>
27 4621 aaronmk
                            </_units>
28
                        </max>
29
                        <min>
30
                            <_units>
31
                                <default>m</default>
32
                                <to>m</to>
33
                                <to></to>
34 3786 aaronmk
                                <value>
35 4621 aaronmk
                                    <_rangeStart>
36
                                        <value>
37
                                            <_replace>
38
                                                <\bca\.?></\bca\.?>
39
                                                <value>$MinimumElevationInMeter</value>
40
                                            </_replace>
41
                                        </value>
42
                                    </_rangeStart>
43 3786 aaronmk
                                </value>
44 4621 aaronmk
                            </_units>
45
                        </min>
46
                    </_avg>
47
                </elevation>
48
                <elevationrange>
49
                    <_range>
50
                        <from>
51
                            <_units>
52
                                <default>m</default>
53
                                <to>m</to>
54
                                <to></to>
55
                                <value>
56
                                    <_rangeStart>
57 3786 aaronmk
                                        <value>
58
                                            <_replace>
59
                                                <\bca\.?></\bca\.?>
60
                                                <value>$MinimumElevationInMeter</value>
61
                                            </_replace>
62
                                        </value>
63 4621 aaronmk
                                    </_rangeStart>
64
                                </value>
65
                            </_units>
66
                        </from>
67
                        <to>
68
                            <_units>
69
                                <default>m</default>
70
                                <to>m</to>
71
                                <to></to>
72
                                <value>
73
                                    <_alt>
74
                                        <1>
75
                                            <_replace>
76
                                                <\bca\.?></\bca\.?>
77
                                                <value>$MaximumElevationInMeter</value>
78
                                            </_replace>
79
                                        </1>
80
                                        <2>
81
                                            <_rangeEnd>
82
                                                <value>
83
                                                    <_replace>
84
                                                        <\bca\.?></\bca\.?>
85
                                                        <value>$MinimumElevationInMeter</value>
86
                                                    </_replace>
87
                                                </value>
88
                                            </_rangeEnd>
89
                                        </2>
90
                                    </_alt>
91
                                </value>
92
                            </_units>
93
                        </to>
94
                    </_range>
95
                </elevationrange>
96
                <locationdetermination>
97
                    <latitude>
98
                        <_alt>
99
                            <1>
100
                                <_nullIf>
101
                                    <null>0</null>
102
                                    <type>float</type>
103
                                    <value>$DecimalLatitude</value>
104
                                </_nullIf>
105
                            </1>
106
                            <2>
107
                                <_nullIf>
108
                                    <null>0</null>
109
                                    <type>float</type>
110
                                    <value>$VerbatimLatitude</value>
111
                                </_nullIf>
112
                            </2>
113
                        </_alt>
114
                    </latitude>
115
                    <longitude>
116
                        <_alt>
117
                            <1>
118
                                <_nullIf>
119
                                    <null>0</null>
120
                                    <type>float</type>
121
                                    <value>$DecimalLongitude</value>
122
                                </_nullIf>
123
                            </1>
124
                            <2>
125
                                <_nullIf>
126
                                    <null>0</null>
127
                                    <type>float</type>
128
                                    <value>$VerbatimLongitude</value>
129
                                </_nullIf>
130
                            </2>
131
                        </_alt>
132
                    </longitude>
133
                    <namedplace_id>
134 4622 aaronmk
                        <namedplace>
135
                            <rank>county</rank>
136
                            <placename>$County</placename>
137
                            <parent_id>
138 3786 aaronmk
                                <namedplace>
139 4622 aaronmk
                                    <rank>stateProvince</rank>
140
                                    <placename>$StateProvince</placename>
141 3786 aaronmk
                                    <parent_id>
142
                                        <namedplace>
143 4622 aaronmk
                                            <rank>country</rank>
144
                                            <placename>$Country</placename>
145 3786 aaronmk
                                        </namedplace>
146
                                    </parent_id>
147
                                </namedplace>
148 4622 aaronmk
                            </parent_id>
149
                        </namedplace>
150 4621 aaronmk
                    </namedplace_id>
151
                </locationdetermination>
152
                <locationevent>
153
                    <taxonoccurrence>
154
                        <aggregateoccurrence>
155
                            <collectiondate><_date><date>$LatestDateCollected</date></_date></collectiondate>
156
                            <plantobservation>
157
                                <specimenreplicate>
158
                                    <catalognumber_dwc>$CatalogNO</catalognumber_dwc>
159
                                    <collectioncode_dwc>$CollectionCD</collectioncode_dwc>
160
                                    <institution_id><party><organizationname>$InstitutionCD</organizationname></party></institution_id>
161
                                </specimenreplicate>
162
                            </plantobservation>
163
                        </aggregateoccurrence>
164
                        <authortaxoncode>
165
                            <_alt>
166
                                <1>$ScientificNameOriginal</1>
167
                                <2>$ScientificName</2>
168
                            </_alt>
169
                        </authortaxoncode>
170
                        <taxondetermination>
171
                            <party_id>
172
                                <party>
173
                                    <givenname><_namePart><first>$IdentifiedBy</first></_namePart></givenname>
174
                                    <middlename><_namePart><middle>$IdentifiedBy</middle></_namePart></middlename>
175
                                    <surname><_namePart><last>$IdentifiedBy</last></_namePart></surname>
176
                                </party>
177
                            </party_id>
178
                            <plantconcept_id>
179
                                <plantconcept>
180
                                    <plantname_id>
181 4622 aaronmk
                                        <plantname>
182
                                            <rank>binomial</rank>
183
                                            <plantname>$ScientificName</plantname>
184
                                            <parent_id>
185 3641 aaronmk
                                                <plantname>
186 4622 aaronmk
                                                    <rank>authority</rank>
187
                                                    <plantname>$AuthorOfScientificName</plantname>
188 3641 aaronmk
                                                    <parent_id>
189
                                                        <plantname>
190 4622 aaronmk
                                                            <rank>subspecies</rank>
191
                                                            <plantname>$InfraspecificEpithet</plantname>
192 3641 aaronmk
                                                            <parent_id>
193
                                                                <plantname>
194 4622 aaronmk
                                                                    <rank>species</rank>
195
                                                                    <plantname>$SpecificEpithet</plantname>
196 3641 aaronmk
                                                                    <parent_id>
197
                                                                        <plantname>
198 4622 aaronmk
                                                                            <rank>genus</rank>
199
                                                                            <plantname>$Genus</plantname>
200 3786 aaronmk
                                                                            <parent_id>
201
                                                                                <plantname>
202 4622 aaronmk
                                                                                    <rank>family</rank>
203
                                                                                    <plantname>$Family</plantname>
204 3786 aaronmk
                                                                                </plantname>
205
                                                                            </parent_id>
206 3641 aaronmk
                                                                        </plantname>
207
                                                                    </parent_id>
208
                                                                </plantname>
209
                                                            </parent_id>
210
                                                        </plantname>
211
                                                    </parent_id>
212
                                                </plantname>
213 4622 aaronmk
                                            </parent_id>
214
                                        </plantname>
215 4621 aaronmk
                                    </plantname_id>
216
                                </plantconcept>
217
                            </plantconcept_id>
218
                        </taxondetermination>
219
                        <taxondetermination>
220
                            <isoriginal>true</isoriginal>
221
                            <plantconcept_id>
222
                                <plantconcept>
223
                                    <plantname_id>
224 4622 aaronmk
                                        <plantname>
225
                                            <rank>binomial</rank>
226
                                            <plantname>$ScientificNameOriginal</plantname>
227
                                            <parent_id>
228 4583 aaronmk
                                                <plantname>
229 4622 aaronmk
                                                    <rank>authority</rank>
230 4583 aaronmk
                                                    <parent_id>
231
                                                        <plantname>
232 4622 aaronmk
                                                            <rank>subspecies</rank>
233 4583 aaronmk
                                                            <parent_id>
234
                                                                <plantname>
235 4622 aaronmk
                                                                    <rank>species</rank>
236 4583 aaronmk
                                                                    <parent_id>
237
                                                                        <plantname>
238 4622 aaronmk
                                                                            <rank>genus</rank>
239
                                                                            <plantname>$GBIFGenusOriginal</plantname>
240 4583 aaronmk
                                                                            <parent_id>
241
                                                                                <plantname>
242 4622 aaronmk
                                                                                    <rank>family</rank>
243
                                                                                    <plantname>$GBIFFamilyOriginal</plantname>
244 4583 aaronmk
                                                                                </plantname>
245
                                                                            </parent_id>
246
                                                                        </plantname>
247
                                                                    </parent_id>
248
                                                                </plantname>
249
                                                            </parent_id>
250
                                                        </plantname>
251
                                                    </parent_id>
252
                                                </plantname>
253 4622 aaronmk
                                            </parent_id>
254
                                        </plantname>
255 4621 aaronmk
                                    </plantname_id>
256
                                </plantconcept>
257
                            </plantconcept_id>
258
                        </taxondetermination>
259
                        <verbatimcollectorname>$Collector</verbatimcollectorname>
260
                    </taxonoccurrence>
261
                </locationevent>
262
                <locationnarrative>$Locality</locationnarrative>
263
            </location>
264
        </path>
265
    </_simplifyPath>
266 3641 aaronmk
</VegBIEN>
267 4583 aaronmk
Inserted 37 new rows into database