Project

General

Profile

« Previous | Next » 

Revision 4621

mappings/VegCore-VegBIEN.csv: Added /_simplifyPath:[next=parent_id]/path to root so the returned subplot location will be its parent location if there is no subplot name or ID (indicating that that particular plot did not have subplots). Note that this also causes the parent_id forwarding effect to occur for all other tables containing parent_id, which will help prevent similar issues with subplot events, etc. This will hopefully fix the SALVIAS.plotObservations bug where some organisms did not have a subplot #, causing the subplot location to become NULL and causing the corresponding locationevent rows not to match the locationevent_unique_within_location index filter condition (which requires a parent_id), which caused multiple output table pkeys to be returned for those rows, violating the locationevent_pkeys temp table's primary key.

View differences:

test.xml.ref
1 1
Put template:
2 2
<VegBIEN>
3
    <location id="-1">
4
        <authorlocationcode>
5
            <_alt>
6
                <1>$dwc_dwcore_GlobalUniqueIdentifier</1>
7
                <2>
8
                    <_join>
9
                        <1>
10
                            <_alt>
11
                                <0>$dwc_dwcore_InstitutionCode</0>
12
                                <1>$dwc_terms_institutionCode</1>
13
                                <2>$conceptual_darwin_2003_1_0_InstitutionCode</2>
14
                            </_alt>
15
                        </1>
3
    <_simplifyPath id="-1">
4
        <next>parent_id</next>
5
        <path>
6
            <location>
7
                <authorlocationcode>
8
                    <_alt>
9
                        <1>$dwc_dwcore_GlobalUniqueIdentifier</1>
16 10
                        <2>
17 11
                            <_join>
18 12
                                <1>
19 13
                                    <_alt>
20
                                        <0>$dwc_dwcore_CollectionCode</0>
21
                                        <1>$dwc_terms_collectionCode</1>
22
                                        <2>$conceptual_darwin_2003_1_0_CollectionCode</2>
14
                                        <0>$dwc_dwcore_InstitutionCode</0>
15
                                        <1>$dwc_terms_institutionCode</1>
16
                                        <2>$conceptual_darwin_2003_1_0_InstitutionCode</2>
23 17
                                    </_alt>
24 18
                                </1>
25
                                <2>$dwc_terms_collectionID</2>
19
                                <2>
20
                                    <_join>
21
                                        <1>
22
                                            <_alt>
23
                                                <0>$dwc_dwcore_CollectionCode</0>
24
                                                <1>$dwc_terms_collectionCode</1>
25
                                                <2>$conceptual_darwin_2003_1_0_CollectionCode</2>
26
                                            </_alt>
27
                                        </1>
28
                                        <2>$dwc_terms_collectionID</2>
29
                                    </_join>
30
                                </2>
31
                                <3>
32
                                    <_alt>
33
                                        <0>$dwc_dwcore_CatalogNumber</0>
34
                                        <1>$dwc_terms_catalogNumber</1>
35
                                        <2>$conceptual_darwin_2003_1_0_CatalogNumber</2>
36
                                    </_alt>
37
                                </3>
26 38
                            </_join>
27 39
                        </2>
28
                        <3>
29
                            <_alt>
30
                                <0>$dwc_dwcore_CatalogNumber</0>
31
                                <1>$dwc_terms_catalogNumber</1>
32
                                <2>$conceptual_darwin_2003_1_0_CatalogNumber</2>
33
                            </_alt>
34
                        </3>
35
                    </_join>
36
                </2>
37
            </_alt>
38
        </authorlocationcode>
39
        <elevation>
40
            <_avg>
41
                <max>
42
                    <_units>
43
                        <default>m</default>
44
                        <to>m</to>
45
                        <to></to>
46
                        <value>
47
                            <_replace>
48
                                <\bca\.?></\bca\.?>
40
                    </_alt>
41
                </authorlocationcode>
42
                <elevation>
43
                    <_avg>
44
                        <max>
45
                            <_units>
46
                                <default>m</default>
47
                                <to>m</to>
48
                                <to></to>
49 49
                                <value>
50
                                    <_alt>
51
                                        <0>$conceptual_darwin_2003_1_0_MaximumElevation</0>
52
                                        <1>$dwc_dwcore_MaximumElevationInMeters</1>
53
                                        <2>$dwc_terms_maximumElevationInMeters</2>
54
                                    </_alt>
55
                                </value>
56
                            </_replace>
57
                        </value>
58
                    </_units>
59
                </max>
60
                <min>
61
                    <_units>
62
                        <default>m</default>
63
                        <to>m</to>
64
                        <to></to>
65
                        <value>
66
                            <_rangeStart>
67
                                <value>
68 50
                                    <_replace>
69 51
                                        <\bca\.?></\bca\.?>
70 52
                                        <value>
71 53
                                            <_alt>
72
                                                <0>$conceptual_darwin_2003_1_0_MinimumElevation</0>
73
                                                <1>$dwc_dwcore_MinimumElevationInMeters</1>
74
                                                <2>$dwc_terms_minimumElevationInMeters</2>
54
                                                <0>$conceptual_darwin_2003_1_0_MaximumElevation</0>
55
                                                <1>$dwc_dwcore_MaximumElevationInMeters</1>
56
                                                <2>$dwc_terms_maximumElevationInMeters</2>
75 57
                                            </_alt>
76 58
                                        </value>
77 59
                                    </_replace>
78 60
                                </value>
79
                            </_rangeStart>
80
                        </value>
81
                    </_units>
82
                </min>
83
            </_avg>
84
        </elevation>
85
        <elevationrange>
86
            <_range>
87
                <from>
88
                    <_units>
89
                        <default>m</default>
90
                        <to>m</to>
91
                        <to></to>
92
                        <value>
93
                            <_rangeStart>
61
                            </_units>
62
                        </max>
63
                        <min>
64
                            <_units>
65
                                <default>m</default>
66
                                <to>m</to>
67
                                <to></to>
94 68
                                <value>
95
                                    <_replace>
96
                                        <\bca\.?></\bca\.?>
69
                                    <_rangeStart>
97 70
                                        <value>
98
                                            <_alt>
99
                                                <0>$conceptual_darwin_2003_1_0_MinimumElevation</0>
100
                                                <1>$dwc_dwcore_MinimumElevationInMeters</1>
101
                                                <2>$dwc_terms_minimumElevationInMeters</2>
102
                                            </_alt>
71
                                            <_replace>
72
                                                <\bca\.?></\bca\.?>
73
                                                <value>
74
                                                    <_alt>
75
                                                        <0>$conceptual_darwin_2003_1_0_MinimumElevation</0>
76
                                                        <1>$dwc_dwcore_MinimumElevationInMeters</1>
77
                                                        <2>$dwc_terms_minimumElevationInMeters</2>
78
                                                    </_alt>
79
                                                </value>
80
                                            </_replace>
103 81
                                        </value>
104
                                    </_replace>
82
                                    </_rangeStart>
105 83
                                </value>
106
                            </_rangeStart>
107
                        </value>
108
                    </_units>
109
                </from>
110
                <to>
111
                    <_units>
112
                        <default>m</default>
113
                        <to>m</to>
114
                        <to></to>
115
                        <value>
116
                            <_alt>
117
                                <1>
118
                                    <_replace>
119
                                        <\bca\.?></\bca\.?>
84
                            </_units>
85
                        </min>
86
                    </_avg>
87
                </elevation>
88
                <elevationrange>
89
                    <_range>
90
                        <from>
91
                            <_units>
92
                                <default>m</default>
93
                                <to>m</to>
94
                                <to></to>
95
                                <value>
96
                                    <_rangeStart>
120 97
                                        <value>
121
                                            <_alt>
122
                                                <0>$conceptual_darwin_2003_1_0_MaximumElevation</0>
123
                                                <1>$dwc_dwcore_MaximumElevationInMeters</1>
124
                                                <2>$dwc_terms_maximumElevationInMeters</2>
125
                                            </_alt>
126
                                        </value>
127
                                    </_replace>
128
                                </1>
129
                                <2>
130
                                    <_rangeEnd>
131
                                        <value>
132 98
                                            <_replace>
133 99
                                                <\bca\.?></\bca\.?>
134 100
                                                <value>
......
140 106
                                                </value>
141 107
                                            </_replace>
142 108
                                        </value>
143
                                    </_rangeEnd>
144
                                </2>
145
                            </_alt>
146
                        </value>
147
                    </_units>
148
                </to>
149
            </_range>
150
        </elevationrange>
151
        <locationdetermination>
152
            <coordsaccuracy>
153
                <_noCV>
154
                    <value>
155
                        <_alt>
156
                            <1>$dwc_terms_coordinateUncertaintyInMeters</1>
157
                            <2>$conceptual_darwin_2003_1_0_CoordinatePrecision</2>
158
                        </_alt>
159
                    </value>
160
                </_noCV>
161
            </coordsaccuracy>
162
            <footprintgeometry_dwc>$conceptual_darwin_2003_1_0_BoundingBox</footprintgeometry_dwc>
163
            <latitude>
164
                <_alt>
165
                    <1>
166
                        <_nullIf>
167
                            <null>0</null>
168
                            <type>float</type>
109
                                    </_rangeStart>
110
                                </value>
111
                            </_units>
112
                        </from>
113
                        <to>
114
                            <_units>
115
                                <default>m</default>
116
                                <to>m</to>
117
                                <to></to>
118
                                <value>
119
                                    <_alt>
120
                                        <1>
121
                                            <_replace>
122
                                                <\bca\.?></\bca\.?>
123
                                                <value>
124
                                                    <_alt>
125
                                                        <0>$conceptual_darwin_2003_1_0_MaximumElevation</0>
126
                                                        <1>$dwc_dwcore_MaximumElevationInMeters</1>
127
                                                        <2>$dwc_terms_maximumElevationInMeters</2>
128
                                                    </_alt>
129
                                                </value>
130
                                            </_replace>
131
                                        </1>
132
                                        <2>
133
                                            <_rangeEnd>
134
                                                <value>
135
                                                    <_replace>
136
                                                        <\bca\.?></\bca\.?>
137
                                                        <value>
138
                                                            <_alt>
139
                                                                <0>$conceptual_darwin_2003_1_0_MinimumElevation</0>
140
                                                                <1>$dwc_dwcore_MinimumElevationInMeters</1>
141
                                                                <2>$dwc_terms_minimumElevationInMeters</2>
142
                                                            </_alt>
143
                                                        </value>
144
                                                    </_replace>
145
                                                </value>
146
                                            </_rangeEnd>
147
                                        </2>
148
                                    </_alt>
149
                                </value>
150
                            </_units>
151
                        </to>
152
                    </_range>
153
                </elevationrange>
154
                <locationdetermination>
155
                    <coordsaccuracy>
156
                        <_noCV>
169 157
                            <value>
170 158
                                <_alt>
171
                                    <0>$dwc_geospatial_DecimalLatitude</0>
172
                                    <1>$dwc_terms_decimalLatitude</1>
159
                                    <1>$dwc_terms_coordinateUncertaintyInMeters</1>
160
                                    <2>$conceptual_darwin_2003_1_0_CoordinatePrecision</2>
173 161
                                </_alt>
174 162
                            </value>
175
                        </_nullIf>
176
                    </1>
177
                    <2>
178
                        <_nullIf>
179
                            <null>0</null>
180
                            <type>float</type>
181
                            <value>
182
                                <_alt>
183
                                    <0>$conceptual_darwin_2003_1_0_Latitude</0>
184
                                    <1>$dwc_geospatial_VerbatimLatitude</1>
185
                                    <2>$dwc_terms_verbatimLatitude</2>
186
                                </_alt>
187
                            </value>
188
                        </_nullIf>
189
                    </2>
190
                </_alt>
191
            </latitude>
192
            <longitude>
193
                <_alt>
194
                    <1>
195
                        <_nullIf>
196
                            <null>0</null>
197
                            <type>float</type>
198
                            <value>
199
                                <_alt>
200
                                    <0>$dwc_geospatial_DecimalLongitude</0>
201
                                    <1>$dwc_terms_decimalLongitude</1>
202
                                </_alt>
203
                            </value>
204
                        </_nullIf>
205
                    </1>
206
                    <2>
207
                        <_nullIf>
208
                            <null>0</null>
209
                            <type>float</type>
210
                            <value>
211
                                <_alt>
212
                                    <0>$conceptual_darwin_2003_1_0_Longitude</0>
213
                                    <1>$dwc_geospatial_VerbatimLongitude</1>
214
                                    <2>$dwc_terms_verbatimLongitude</2>
215
                                </_alt>
216
                            </value>
217
                        </_nullIf>
218
                    </2>
219
                </_alt>
220
            </longitude>
221
            <namedplace_id>
222
                <_simplifyPath>
223
                    <next>parent_id</next>
224
                    <path>
225
                        <namedplace>
226
                            <rank>county</rank>
227
                            <placename>
228
                                <_alt>
229
                                    <0>$dwc_dwcore_County</0>
230
                                    <1>$dwc_terms_county</1>
231
                                    <2>$conceptual_darwin_2003_1_0_County</2>
232
                                </_alt>
233
                            </placename>
234
                            <parent_id>
163
                        </_noCV>
164
                    </coordsaccuracy>
165
                    <footprintgeometry_dwc>$conceptual_darwin_2003_1_0_BoundingBox</footprintgeometry_dwc>
166
                    <latitude>
167
                        <_alt>
168
                            <1>
169
                                <_nullIf>
170
                                    <null>0</null>
171
                                    <type>float</type>
172
                                    <value>
173
                                        <_alt>
174
                                            <0>$dwc_geospatial_DecimalLatitude</0>
175
                                            <1>$dwc_terms_decimalLatitude</1>
176
                                        </_alt>
177
                                    </value>
178
                                </_nullIf>
179
                            </1>
180
                            <2>
181
                                <_nullIf>
182
                                    <null>0</null>
183
                                    <type>float</type>
184
                                    <value>
185
                                        <_alt>
186
                                            <0>$conceptual_darwin_2003_1_0_Latitude</0>
187
                                            <1>$dwc_geospatial_VerbatimLatitude</1>
188
                                            <2>$dwc_terms_verbatimLatitude</2>
189
                                        </_alt>
190
                                    </value>
191
                                </_nullIf>
192
                            </2>
193
                        </_alt>
194
                    </latitude>
195
                    <longitude>
196
                        <_alt>
197
                            <1>
198
                                <_nullIf>
199
                                    <null>0</null>
200
                                    <type>float</type>
201
                                    <value>
202
                                        <_alt>
203
                                            <0>$dwc_geospatial_DecimalLongitude</0>
204
                                            <1>$dwc_terms_decimalLongitude</1>
205
                                        </_alt>
206
                                    </value>
207
                                </_nullIf>
208
                            </1>
209
                            <2>
210
                                <_nullIf>
211
                                    <null>0</null>
212
                                    <type>float</type>
213
                                    <value>
214
                                        <_alt>
215
                                            <0>$conceptual_darwin_2003_1_0_Longitude</0>
216
                                            <1>$dwc_geospatial_VerbatimLongitude</1>
217
                                            <2>$dwc_terms_verbatimLongitude</2>
218
                                        </_alt>
219
                                    </value>
220
                                </_nullIf>
221
                            </2>
222
                        </_alt>
223
                    </longitude>
224
                    <namedplace_id>
225
                        <_simplifyPath>
226
                            <next>parent_id</next>
227
                            <path>
235 228
                                <namedplace>
236
                                    <rank>stateProvince</rank>
229
                                    <rank>county</rank>
237 230
                                    <placename>
238 231
                                        <_alt>
239
                                            <0>$dwc_dwcore_StateProvince</0>
240
                                            <1>$dwc_terms_stateProvince</1>
241
                                            <2>$conceptual_darwin_2003_1_0_StateProvince</2>
232
                                            <0>$dwc_dwcore_County</0>
233
                                            <1>$dwc_terms_county</1>
234
                                            <2>$conceptual_darwin_2003_1_0_County</2>
242 235
                                        </_alt>
243 236
                                    </placename>
244 237
                                    <parent_id>
245 238
                                        <namedplace>
246
                                            <rank>country</rank>
239
                                            <rank>stateProvince</rank>
247 240
                                            <placename>
248 241
                                                <_alt>
249
                                                    <0>$dwc_dwcore_Country</0>
250
                                                    <1>$dwc_terms_country</1>
251
                                                    <2>$conceptual_darwin_2003_1_0_Country</2>
242
                                                    <0>$dwc_dwcore_StateProvince</0>
243
                                                    <1>$dwc_terms_stateProvince</1>
244
                                                    <2>$conceptual_darwin_2003_1_0_StateProvince</2>
252 245
                                                </_alt>
253 246
                                            </placename>
254 247
                                            <parent_id>
255 248
                                                <namedplace>
256
                                                    <rank>continent</rank>
249
                                                    <rank>country</rank>
257 250
                                                    <placename>
258 251
                                                        <_alt>
259
                                                            <0>$dwc_dwcore_Continent</0>
260
                                                            <1>$dwc_terms_continent</1>
261
                                                            <2>$conceptual_darwin_2003_1_0_ContinentOcean</2>
252
                                                            <0>$dwc_dwcore_Country</0>
253
                                                            <1>$dwc_terms_country</1>
254
                                                            <2>$conceptual_darwin_2003_1_0_Country</2>
262 255
                                                        </_alt>
263 256
                                                    </placename>
257
                                                    <parent_id>
258
                                                        <namedplace>
259
                                                            <rank>continent</rank>
260
                                                            <placename>
261
                                                                <_alt>
262
                                                                    <0>$dwc_dwcore_Continent</0>
263
                                                                    <1>$dwc_terms_continent</1>
264
                                                                    <2>$conceptual_darwin_2003_1_0_ContinentOcean</2>
265
                                                                </_alt>
266
                                                            </placename>
267
                                                        </namedplace>
268
                                                    </parent_id>
264 269
                                                </namedplace>
265 270
                                            </parent_id>
266 271
                                        </namedplace>
267 272
                                    </parent_id>
268 273
                                </namedplace>
269
                            </parent_id>
270
                        </namedplace>
271
                    </path>
272
                </_simplifyPath>
273
            </namedplace_id>
274
        </locationdetermination>
275
        <locationevent>
276
            <taxonoccurrence>
277
                <aggregateoccurrence>
278
                    <collectiondate>
279
                        <_date>
280
                            <day>
281
                                <_nullIf>
282
                                    <null>0</null>
283
                                    <type>float</type>
284
                                    <value>$conceptual_darwin_2003_1_0_DayCollected</value>
285
                                </_nullIf>
286
                            </day>
287
                            <month>
288
                                <_nullIf>
289
                                    <null>0</null>
290
                                    <type>float</type>
291
                                    <value>$conceptual_darwin_2003_1_0_MonthCollected</value>
292
                                </_nullIf>
293
                            </month>
294
                            <year>
295
                                <_nullIf>
296
                                    <null>0</null>
297
                                    <type>float</type>
298
                                    <value>$conceptual_darwin_2003_1_0_YearCollected</value>
299
                                </_nullIf>
300
                            </year>
301
                        </_date>
302
                    </collectiondate>
303
                    <count>
304
                        <_alt>
305
                            <0>$dwc_curatorial_IndividualCount</0>
306
                            <1>$dwc_terms_individualCount</1>
307
                            <2>$conceptual_darwin_2003_1_0_IndividualCount</2>
308
                        </_alt>
309
                    </count>
310
                    <notes>$conceptual_darwin_2003_1_0_Notes</notes>
311
                    <plantobservation>
312
                        <collectionnumber>
313
                            <_alt>
314
                                <1>$dwc_terms_recordNumber</1>
315
                                <2>
274
                            </path>
275
                        </_simplifyPath>
276
                    </namedplace_id>
277
                </locationdetermination>
278
                <locationevent>
279
                    <taxonoccurrence>
280
                        <aggregateoccurrence>
281
                            <collectiondate>
282
                                <_date>
283
                                    <day>
284
                                        <_nullIf>
285
                                            <null>0</null>
286
                                            <type>float</type>
287
                                            <value>$conceptual_darwin_2003_1_0_DayCollected</value>
288
                                        </_nullIf>
289
                                    </day>
290
                                    <month>
291
                                        <_nullIf>
292
                                            <null>0</null>
293
                                            <type>float</type>
294
                                            <value>$conceptual_darwin_2003_1_0_MonthCollected</value>
295
                                        </_nullIf>
296
                                    </month>
297
                                    <year>
298
                                        <_nullIf>
299
                                            <null>0</null>
300
                                            <type>float</type>
301
                                            <value>$conceptual_darwin_2003_1_0_YearCollected</value>
302
                                        </_nullIf>
303
                                    </year>
304
                                </_date>
305
                            </collectiondate>
306
                            <count>
307
                                <_alt>
308
                                    <0>$dwc_curatorial_IndividualCount</0>
309
                                    <1>$dwc_terms_individualCount</1>
310
                                    <2>$conceptual_darwin_2003_1_0_IndividualCount</2>
311
                                </_alt>
312
                            </count>
313
                            <notes>$conceptual_darwin_2003_1_0_Notes</notes>
314
                            <plantobservation>
315
                                <collectionnumber>
316 316
                                    <_alt>
317
                                        <0>$dwc_curatorial_FieldNumber</0>
318
                                        <1>$dwc_terms_fieldNumber</1>
319
                                        <2>$conceptual_darwin_2003_1_0_FieldNumber</2>
320
                                        <3>$dwc_curatorial_FieldNumber</3>
321
                                        <4>$dwc_terms_fieldNumber</4>
322
                                        <5>$conceptual_darwin_2003_1_0_FieldNumber</5>
317
                                        <1>$dwc_terms_recordNumber</1>
318
                                        <2>
319
                                            <_alt>
320
                                                <0>$dwc_curatorial_FieldNumber</0>
321
                                                <1>$dwc_terms_fieldNumber</1>
322
                                                <2>$conceptual_darwin_2003_1_0_FieldNumber</2>
323
                                                <3>$dwc_curatorial_FieldNumber</3>
324
                                                <4>$dwc_terms_fieldNumber</4>
325
                                                <5>$conceptual_darwin_2003_1_0_FieldNumber</5>
326
                                            </_alt>
327
                                        </2>
328
                                        <3>
329
                                            <_alt>
330
                                                <0>$dwc_curatorial_CollectorNumber</0>
331
                                                <1>$conceptual_darwin_2003_1_0_CollectorNumber</1>
332
                                            </_alt>
333
                                        </3>
323 334
                                    </_alt>
324
                                </2>
325
                                <3>
326
                                    <_alt>
327
                                        <0>$dwc_curatorial_CollectorNumber</0>
328
                                        <1>$conceptual_darwin_2003_1_0_CollectorNumber</1>
329
                                    </_alt>
330
                                </3>
331
                            </_alt>
332
                        </collectionnumber>
333
                        <definedvalue fkey="tablerecord_id">
334
                            <userdefined_id>
335
                                <userdefined>
336
                                    <tablename>plantobservation</tablename>
337
                                    <userdefinedname>sex</userdefinedname>
338
                                </userdefined>
339
                            </userdefined_id>
340
                            <definedvalue>
341
                                <_alt>
342
                                    <0>$dwc_dwcore_Sex</0>
343
                                    <1>$dwc_terms_sex</1>
344
                                    <2>$conceptual_darwin_2003_1_0_Sex</2>
345
                                </_alt>
346
                            </definedvalue>
347
                        </definedvalue>
348
                        <specimenreplicate>
349
                            <catalognumber_dwc>
350
                                <_alt>
351
                                    <0>$dwc_dwcore_CatalogNumber</0>
352
                                    <1>$dwc_terms_catalogNumber</1>
353
                                    <2>$conceptual_darwin_2003_1_0_CatalogNumber</2>
354
                                </_alt>
355
                            </catalognumber_dwc>
356
                            <collectioncode_dwc>
357
                                <_join>
358
                                    <1>
335
                                </collectionnumber>
336
                                <definedvalue fkey="tablerecord_id">
337
                                    <userdefined_id>
338
                                        <userdefined>
339
                                            <tablename>plantobservation</tablename>
340
                                            <userdefinedname>sex</userdefinedname>
341
                                        </userdefined>
342
                                    </userdefined_id>
343
                                    <definedvalue>
359 344
                                        <_alt>
360
                                            <0>$dwc_dwcore_CollectionCode</0>
361
                                            <1>$dwc_terms_collectionCode</1>
362
                                            <2>$conceptual_darwin_2003_1_0_CollectionCode</2>
345
                                            <0>$dwc_dwcore_Sex</0>
346
                                            <1>$dwc_terms_sex</1>
347
                                            <2>$conceptual_darwin_2003_1_0_Sex</2>
363 348
                                        </_alt>
364
                                    </1>
365
                                    <2>$dwc_terms_collectionID</2>
366
                                </_join>
367
                            </collectioncode_dwc>
368
                            <institution_id>
369
                                <party>
370
                                    <organizationname>
349
                                    </definedvalue>
350
                                </definedvalue>
351
                                <specimenreplicate>
352
                                    <catalognumber_dwc>
371 353
                                        <_alt>
372
                                            <0>$dwc_dwcore_InstitutionCode</0>
373
                                            <1>$dwc_terms_institutionCode</1>
374
                                            <2>$conceptual_darwin_2003_1_0_InstitutionCode</2>
354
                                            <0>$dwc_dwcore_CatalogNumber</0>
355
                                            <1>$dwc_terms_catalogNumber</1>
356
                                            <2>$conceptual_darwin_2003_1_0_CatalogNumber</2>
375 357
                                        </_alt>
376
                                    </organizationname>
377
                                </party>
378
                            </institution_id>
379
                            <sourceaccessioncode>$dwc_dwcore_GlobalUniqueIdentifier</sourceaccessioncode>
380
                        </specimenreplicate>
381
                    </plantobservation>
382
                </aggregateoccurrence>
383
                <authortaxoncode>
384
                    <_alt>
385
                        <1>
358
                                    </catalognumber_dwc>
359
                                    <collectioncode_dwc>
360
                                        <_join>
361
                                            <1>
362
                                                <_alt>
363
                                                    <0>$dwc_dwcore_CollectionCode</0>
364
                                                    <1>$dwc_terms_collectionCode</1>
365
                                                    <2>$conceptual_darwin_2003_1_0_CollectionCode</2>
366
                                                </_alt>
367
                                            </1>
368
                                            <2>$dwc_terms_collectionID</2>
369
                                        </_join>
370
                                    </collectioncode_dwc>
371
                                    <institution_id>
372
                                        <party>
373
                                            <organizationname>
374
                                                <_alt>
375
                                                    <0>$dwc_dwcore_InstitutionCode</0>
376
                                                    <1>$dwc_terms_institutionCode</1>
377
                                                    <2>$conceptual_darwin_2003_1_0_InstitutionCode</2>
378
                                                </_alt>
379
                                            </organizationname>
380
                                        </party>
381
                                    </institution_id>
382
                                    <sourceaccessioncode>$dwc_dwcore_GlobalUniqueIdentifier</sourceaccessioncode>
383
                                </specimenreplicate>
384
                            </plantobservation>
385
                        </aggregateoccurrence>
386
                        <authortaxoncode>
386 387
                            <_alt>
387
                                <1>$dwc_terms_recordNumber</1>
388
                                <1>
389
                                    <_alt>
390
                                        <1>$dwc_terms_recordNumber</1>
391
                                        <2>
392
                                            <_alt>
393
                                                <0>$dwc_curatorial_FieldNumber</0>
394
                                                <1>$dwc_terms_fieldNumber</1>
395
                                                <2>$conceptual_darwin_2003_1_0_FieldNumber</2>
396
                                                <3>$dwc_curatorial_FieldNumber</3>
397
                                                <4>$dwc_terms_fieldNumber</4>
398
                                                <5>$conceptual_darwin_2003_1_0_FieldNumber</5>
399
                                            </_alt>
400
                                        </2>
401
                                        <3>
402
                                            <_alt>
403
                                                <0>$dwc_curatorial_CollectorNumber</0>
404
                                                <1>$conceptual_darwin_2003_1_0_CollectorNumber</1>
405
                                            </_alt>
406
                                        </3>
407
                                    </_alt>
408
                                </1>
388 409
                                <2>
389 410
                                    <_alt>
390
                                        <0>$dwc_curatorial_FieldNumber</0>
391
                                        <1>$dwc_terms_fieldNumber</1>
392
                                        <2>$conceptual_darwin_2003_1_0_FieldNumber</2>
393
                                        <3>$dwc_curatorial_FieldNumber</3>
394
                                        <4>$dwc_terms_fieldNumber</4>
395
                                        <5>$conceptual_darwin_2003_1_0_FieldNumber</5>
411
                                        <0>$dwc_dwcore_ScientificName</0>
412
                                        <1>$dwc_terms_scientificName</1>
413
                                        <2>$conceptual_darwin_2003_1_0_ScientificName</2>
396 414
                                    </_alt>
397 415
                                </2>
398
                                <3>
399
                                    <_alt>
400
                                        <0>$dwc_curatorial_CollectorNumber</0>
401
                                        <1>$conceptual_darwin_2003_1_0_CollectorNumber</1>
402
                                    </_alt>
403
                                </3>
404 416
                            </_alt>
405
                        </1>
406
                        <2>
407
                            <_alt>
408
                                <0>$dwc_dwcore_ScientificName</0>
409
                                <1>$dwc_terms_scientificName</1>
410
                                <2>$conceptual_darwin_2003_1_0_ScientificName</2>
411
                            </_alt>
412
                        </2>
413
                    </_alt>
414
                </authortaxoncode>
415
                <taxondetermination>
416
                    <party_id>
417
                        <party>
418
                            <givenname>
419
                                <_namePart>
420
                                    <first>
421
                                        <_alt>
422
                                            <0>$dwc_curatorial_IdentifiedBy</0>
423
                                            <1>$dwc_terms_identifiedBy</1>
424
                                            <2>$conceptual_darwin_2003_1_0_IdentifiedBy</2>
425
                                        </_alt>
426
                                    </first>
427
                                </_namePart>
428
                            </givenname>
429
                            <middlename>
430
                                <_namePart>
431
                                    <middle>
432
                                        <_alt>
433
                                            <0>$dwc_curatorial_IdentifiedBy</0>
434
                                            <1>$dwc_terms_identifiedBy</1>
435
                                            <2>$conceptual_darwin_2003_1_0_IdentifiedBy</2>
436
                                        </_alt>
437
                                    </middle>
438
                                </_namePart>
439
                            </middlename>
440
                            <surname>
441
                                <_namePart>
442
                                    <last>
443
                                        <_alt>
444
                                            <0>$dwc_curatorial_IdentifiedBy</0>
445
                                            <1>$dwc_terms_identifiedBy</1>
446
                                            <2>$conceptual_darwin_2003_1_0_IdentifiedBy</2>
447
                                        </_alt>
448
                                    </last>
449
                                </_namePart>
450
                            </surname>
451
                        </party>
452
                    </party_id>
453
                    <plantconcept_id>
454
                        <plantconcept>
455
                            <plantname_id>
456
                                <_simplifyPath>
457
                                    <next>parent_id</next>
458
                                    <path>
459
                                        <plantname>
460
                                            <rank>binomial</rank>
461
                                            <plantname>
417
                        </authortaxoncode>
418
                        <taxondetermination>
419
                            <party_id>
420
                                <party>
421
                                    <givenname>
422
                                        <_namePart>
423
                                            <first>
462 424
                                                <_alt>
463
                                                    <0>$dwc_dwcore_ScientificName</0>
464
                                                    <1>$dwc_terms_scientificName</1>
465
                                                    <2>$conceptual_darwin_2003_1_0_ScientificName</2>
425
                                                    <0>$dwc_curatorial_IdentifiedBy</0>
426
                                                    <1>$dwc_terms_identifiedBy</1>
427
                                                    <2>$conceptual_darwin_2003_1_0_IdentifiedBy</2>
466 428
                                                </_alt>
467
                                            </plantname>
468
                                            <parent_id>
429
                                            </first>
430
                                        </_namePart>
431
                                    </givenname>
432
                                    <middlename>
433
                                        <_namePart>
434
                                            <middle>
435
                                                <_alt>
436
                                                    <0>$dwc_curatorial_IdentifiedBy</0>
437
                                                    <1>$dwc_terms_identifiedBy</1>
438
                                                    <2>$conceptual_darwin_2003_1_0_IdentifiedBy</2>
439
                                                </_alt>
440
                                            </middle>
441
                                        </_namePart>
442
                                    </middlename>
443
                                    <surname>
444
                                        <_namePart>
445
                                            <last>
446
                                                <_alt>
447
                                                    <0>$dwc_curatorial_IdentifiedBy</0>
448
                                                    <1>$dwc_terms_identifiedBy</1>
449
                                                    <2>$conceptual_darwin_2003_1_0_IdentifiedBy</2>
450
                                                </_alt>
451
                                            </last>
452
                                        </_namePart>
453
                                    </surname>
454
                                </party>
455
                            </party_id>
456
                            <plantconcept_id>
457
                                <plantconcept>
458
                                    <plantname_id>
459
                                        <_simplifyPath>
460
                                            <next>parent_id</next>
461
                                            <path>
469 462
                                                <plantname>
470
                                                    <rank>authority</rank>
463
                                                    <rank>binomial</rank>
471 464
                                                    <plantname>
472 465
                                                        <_alt>
473
                                                            <1>$dwc_terms_scientificNameAuthorship</1>
474
                                                            <2>$conceptual_darwin_2003_1_0_ScientificNameAuthor</2>
475
                                                            <3>$dwc_dwcore_AuthorYearOfScientificName</3>
466
                                                            <0>$dwc_dwcore_ScientificName</0>
467
                                                            <1>$dwc_terms_scientificName</1>
468
                                                            <2>$conceptual_darwin_2003_1_0_ScientificName</2>
476 469
                                                        </_alt>
477 470
                                                    </plantname>
478 471
                                                    <parent_id>
479 472
                                                        <plantname>
480
                                                            <rank>subspecies</rank>
473
                                                            <rank>authority</rank>
481 474
                                                            <plantname>
482 475
                                                                <_alt>
483
                                                                    <0>$dwc_dwcore_InfraspecificEpithet</0>
484
                                                                    <1>$dwc_terms_infraspecificEpithet</1>
485
                                                                    <2>$conceptual_darwin_2003_1_0_Subspecies</2>
476
                                                                    <1>$dwc_terms_scientificNameAuthorship</1>
477
                                                                    <2>$conceptual_darwin_2003_1_0_ScientificNameAuthor</2>
478
                                                                    <3>$dwc_dwcore_AuthorYearOfScientificName</3>
486 479
                                                                </_alt>
487 480
                                                            </plantname>
488 481
                                                            <parent_id>
489 482
                                                                <plantname>
490
                                                                    <rank>species</rank>
483
                                                                    <rank>subspecies</rank>
491 484
                                                                    <plantname>
492 485
                                                                        <_alt>
493
                                                                            <0>$conceptual_darwin_2003_1_0_Species</0>
494
                                                                            <1>$dwc_dwcore_SpecificEpithet</1>
495
                                                                            <2>$dwc_terms_specificEpithet</2>
486
                                                                            <0>$dwc_dwcore_InfraspecificEpithet</0>
487
                                                                            <1>$dwc_terms_infraspecificEpithet</1>
488
                                                                            <2>$conceptual_darwin_2003_1_0_Subspecies</2>
496 489
                                                                        </_alt>
497 490
                                                                    </plantname>
498 491
                                                                    <parent_id>
499 492
                                                                        <plantname>
500
                                                                            <rank>genus</rank>
493
                                                                            <rank>species</rank>
501 494
                                                                            <plantname>
502 495
                                                                                <_alt>
503
                                                                                    <0>$dwc_dwcore_Genus</0>
504
                                                                                    <1>$dwc_terms_genus</1>
505
                                                                                    <2>$conceptual_darwin_2003_1_0_Genus</2>
496
                                                                                    <0>$conceptual_darwin_2003_1_0_Species</0>
497
                                                                                    <1>$dwc_dwcore_SpecificEpithet</1>
498
                                                                                    <2>$dwc_terms_specificEpithet</2>
506 499
                                                                                </_alt>
507 500
                                                                            </plantname>
508 501
                                                                            <parent_id>
509 502
                                                                                <plantname>
510
                                                                                    <rank>family</rank>
503
                                                                                    <rank>genus</rank>
511 504
                                                                                    <plantname>
512 505
                                                                                        <_alt>
513
                                                                                            <0>$dwc_dwcore_Family</0>
514
                                                                                            <1>$dwc_terms_family</1>
515
                                                                                            <2>$conceptual_darwin_2003_1_0_Family</2>
506
                                                                                            <0>$dwc_dwcore_Genus</0>
507
                                                                                            <1>$dwc_terms_genus</1>
508
                                                                                            <2>$conceptual_darwin_2003_1_0_Genus</2>
516 509
                                                                                        </_alt>
517 510
                                                                                    </plantname>
518 511
                                                                                    <parent_id>
519 512
                                                                                        <plantname>
520
                                                                                            <rank>order</rank>
513
                                                                                            <rank>family</rank>
521 514
                                                                                            <plantname>
522 515
                                                                                                <_alt>
523
                                                                                                    <0>$dwc_dwcore_Order</0>
524
                                                                                                    <1>$dwc_terms_order</1>
525
                                                                                                    <2>$conceptual_darwin_2003_1_0_Order</2>
516
                                                                                                    <0>$dwc_dwcore_Family</0>
517
                                                                                                    <1>$dwc_terms_family</1>
518
                                                                                                    <2>$conceptual_darwin_2003_1_0_Family</2>
526 519
                                                                                                </_alt>
527 520
                                                                                            </plantname>
528 521
                                                                                            <parent_id>
529 522
                                                                                                <plantname>
530
                                                                                                    <rank>class</rank>
523
                                                                                                    <rank>order</rank>
531 524
                                                                                                    <plantname>
532 525
                                                                                                        <_alt>
533
                                                                                                            <0>$dwc_dwcore_Class</0>
534
                                                                                                            <1>$dwc_terms_class</1>
535
                                                                                                            <2>$conceptual_darwin_2003_1_0_Class</2>
526
                                                                                                            <0>$dwc_dwcore_Order</0>
527
                                                                                                            <1>$dwc_terms_order</1>
528
                                                                                                            <2>$conceptual_darwin_2003_1_0_Order</2>
536 529
                                                                                                        </_alt>
537 530
                                                                                                    </plantname>
538 531
                                                                                                    <parent_id>
539 532
                                                                                                        <plantname>
540
                                                                                                            <rank>subkingdom</rank>
533
                                                                                                            <rank>class</rank>
541 534
                                                                                                            <plantname>
542 535
                                                                                                                <_alt>
543
                                                                                                                    <0>$dwc_dwcore_Phylum</0>
544
                                                                                                                    <1>$dwc_terms_phylum</1>
545
                                                                                                                    <2>$conceptual_darwin_2003_1_0_Phylum</2>
536
                                                                                                                    <0>$dwc_dwcore_Class</0>
537
                                                                                                                    <1>$dwc_terms_class</1>
538
                                                                                                                    <2>$conceptual_darwin_2003_1_0_Class</2>
546 539
                                                                                                                </_alt>
547 540
                                                                                                            </plantname>
548 541
                                                                                                            <parent_id>
549 542
                                                                                                                <plantname>
550
                                                                                                                    <rank>kingdom</rank>
543
                                                                                                                    <rank>subkingdom</rank>
551 544
                                                                                                                    <plantname>
552 545
                                                                                                                        <_alt>
553
                                                                                                                            <0>$dwc_dwcore_Kingdom</0>
554
                                                                                                                            <1>$dwc_terms_kingdom</1>
555
                                                                                                                            <2>$conceptual_darwin_2003_1_0_Kingdom</2>
546
                                                                                                                            <0>$dwc_dwcore_Phylum</0>
547
                                                                                                                            <1>$dwc_terms_phylum</1>
548
                                                                                                                            <2>$conceptual_darwin_2003_1_0_Phylum</2>
556 549
                                                                                                                        </_alt>
557 550
                                                                                                                    </plantname>
551
                                                                                                                    <parent_id>
552
                                                                                                                        <plantname>
553
                                                                                                                            <rank>kingdom</rank>
554
                                                                                                                            <plantname>
555
                                                                                                                                <_alt>
556
                                                                                                                                    <0>$dwc_dwcore_Kingdom</0>
557
                                                                                                                                    <1>$dwc_terms_kingdom</1>
558
                                                                                                                                    <2>$conceptual_darwin_2003_1_0_Kingdom</2>
559
                                                                                                                                </_alt>
560
                                                                                                                            </plantname>
561
                                                                                                                        </plantname>
562
                                                                                                                    </parent_id>
558 563
                                                                                                                </plantname>
559 564
                                                                                                            </parent_id>
560 565
                                                                                                        </plantname>
......
572 577
                                                        </plantname>
573 578
                                                    </parent_id>
574 579
                                                </plantname>
575
                                            </parent_id>
576
                                        </plantname>
577
                                    </path>
578
                                </_simplifyPath>
579
                            </plantname_id>
580
                        </plantconcept>
581
                    </plantconcept_id>
582
                    <determinationdate>
583
                        <_alt>
584
                            <1><_date><date><_dateRangeStart><value>$dwc_terms_dateIdentified</value></_dateRangeStart></date></_date></1>
585
                            <2>
586
                                <_date>
587
                                    <day>
588
                                        <_nullIf>
589
                                            <null>0</null>
590
                                            <type>float</type>
591
                                            <value>$conceptual_darwin_2003_1_0_DayIdentified</value>
592
                                        </_nullIf>
593
                                    </day>
594
                                    <month>
595
                                        <_nullIf>
596
                                            <null>0</null>
597
                                            <type>float</type>
598
                                            <value>$conceptual_darwin_2003_1_0_MonthIdentified</value>
599
                                        </_nullIf>
600
                                    </month>
601
                                    <year>
602
                                        <_nullIf>
603
                                            <null>0</null>
604
                                            <type>float</type>
605
                                            <value>$conceptual_darwin_2003_1_0_YearIdentified</value>
606
                                        </_nullIf>
607
                                    </year>
608
                                </_date>
609
                            </2>
610
                        </_alt>
611
                    </determinationdate>
612
                    <notes>$dwc_dwcore_Remarks</notes>
613
                </taxondetermination>
614
                <verbatimcollectorname>
615
                    <_alt>
616
                        <0>$dwc_dwcore_Collector</0>
617
                        <1>$conceptual_darwin_2003_1_0_Collector</1>
618
                        <2>$dwc_terms_recordedBy</2>
619
                    </_alt>
620
                </verbatimcollectorname>
621
            </taxonoccurrence>
622
            <waterdepth>
623
                <_avg>
624
                    <max>
625
                        <_units>
626
                            <default>m</default>
627
                            <to>m</to>
628
                            <to></to>
629
                            <value>
630
                                <_replace>
631
                                    <\bca\.?></\bca\.?>
580
                                            </path>
581
                                        </_simplifyPath>
582
                                    </plantname_id>
583
                                </plantconcept>
584
                            </plantconcept_id>
585
                            <determinationdate>
586
                                <_alt>
587
                                    <1><_date><date><_dateRangeStart><value>$dwc_terms_dateIdentified</value></_dateRangeStart></date></_date></1>
588
                                    <2>
589
                                        <_date>
590
                                            <day>
591
                                                <_nullIf>
592
                                                    <null>0</null>
593
                                                    <type>float</type>
594
                                                    <value>$conceptual_darwin_2003_1_0_DayIdentified</value>
595
                                                </_nullIf>
596
                                            </day>
597
                                            <month>
598
                                                <_nullIf>
599
                                                    <null>0</null>
600
                                                    <type>float</type>
601
                                                    <value>$conceptual_darwin_2003_1_0_MonthIdentified</value>
602
                                                </_nullIf>
603
                                            </month>
604
                                            <year>
605
                                                <_nullIf>
606
                                                    <null>0</null>
607
                                                    <type>float</type>
608
                                                    <value>$conceptual_darwin_2003_1_0_YearIdentified</value>
609
                                                </_nullIf>
610
                                            </year>
611
                                        </_date>
612
                                    </2>
613
                                </_alt>
614
                            </determinationdate>
615
                            <notes>$dwc_dwcore_Remarks</notes>
616
                        </taxondetermination>
617
                        <verbatimcollectorname>
618
                            <_alt>
619
                                <0>$dwc_dwcore_Collector</0>
620
                                <1>$conceptual_darwin_2003_1_0_Collector</1>
621
                                <2>$dwc_terms_recordedBy</2>
622
                            </_alt>
623
                        </verbatimcollectorname>
624
                    </taxonoccurrence>
625
                    <waterdepth>
626
                        <_avg>
627
                            <max>
628
                                <_units>
629
                                    <default>m</default>
630
                                    <to>m</to>
631
                                    <to></to>
632 632
                                    <value>
633
                                        <_alt>
634
                                            <0>$conceptual_darwin_2003_1_0_MaximumDepth</0>
635
                                            <1>$dwc_dwcore_MaximumDepthInMeters</1>
636
                                            <2>$dwc_terms_maximumDepthInMeters</2>
637
                                        </_alt>
633
                                        <_replace>
634
                                            <\bca\.?></\bca\.?>
635
                                            <value>
636
                                                <_alt>
637
                                                    <0>$conceptual_darwin_2003_1_0_MaximumDepth</0>
638
                                                    <1>$dwc_dwcore_MaximumDepthInMeters</1>
639
                                                    <2>$dwc_terms_maximumDepthInMeters</2>
640
                                                </_alt>
641
                                            </value>
642
                                        </_replace>
638 643
                                    </value>
639
                                </_replace>
640
                            </value>
641
                        </_units>
642
                    </max>
643
                    <min>
644
                        <_units>
645
                            <default>m</default>
646
                            <to>m</to>
647
                            <to></to>
648
                            <value>
649
                                <_replace>
650
                                    <\bca\.?></\bca\.?>
644
                                </_units>
645
                            </max>
646
                            <min>
647
                                <_units>
648
                                    <default>m</default>
649
                                    <to>m</to>
650
                                    <to></to>
651 651
                                    <value>
652
                                        <_alt>
653
                                            <0>$conceptual_darwin_2003_1_0_MinimumDepth</0>
654
                                            <1>$dwc_dwcore_MinimumDepthInMeters</1>
655
                                            <2>$dwc_terms_minimumDepthInMeters</2>
656
                                        </_alt>
652
                                        <_replace>
653
                                            <\bca\.?></\bca\.?>
654
                                            <value>
655
                                                <_alt>
656
                                                    <0>$conceptual_darwin_2003_1_0_MinimumDepth</0>
657
                                                    <1>$dwc_dwcore_MinimumDepthInMeters</1>
658
                                                    <2>$dwc_terms_minimumDepthInMeters</2>
659
                                                </_alt>
660
                                            </value>
661
                                        </_replace>
657 662
                                    </value>
658
                                </_replace>
659
                            </value>
660
                        </_units>
661
                    </min>
662
                </_avg>
663
            </waterdepth>
664
        </locationevent>
665
        <locationnarrative>
666
            <_alt>
667
                <0>$dwc_dwcore_Locality</0>
668
                <1>$dwc_terms_locality</1>
669
                <2>$conceptual_darwin_2003_1_0_Locality</2>
670
            </_alt>
671
        </locationnarrative>
672
    </location>
663
                                </_units>
664
                            </min>
665
                        </_avg>
666
                    </waterdepth>
667
                </locationevent>
668
                <locationnarrative>
669
                    <_alt>
670
                        <0>$dwc_dwcore_Locality</0>
671
                        <1>$dwc_terms_locality</1>
672
                        <2>$conceptual_darwin_2003_1_0_Locality</2>
673
                    </_alt>
674
                </locationnarrative>
675
            </location>
676
        </path>
677
    </_simplifyPath>
673 678
</VegBIEN>
674 679
Inserted 40 new rows into database

Also available in: Unified diff