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:

inputs/CTFS/SubplotObservation/test.xml.ref
1 1
Put template:
2 2
<VegBIEN>
3
    <location id="-1">
4
        <parent_id><location><sourceaccessioncode>$PlotID</sourceaccessioncode></location></parent_id>
5
        <authorlocationcode>$QuadratID</authorlocationcode>
6
        <locationevent>
7
            <parent_id>
3
    <_simplifyPath id="-1">
4
        <next>parent_id</next>
5
        <path>
6
            <location>
7
                <parent_id><location><sourceaccessioncode>$PlotID</sourceaccessioncode></location></parent_id>
8
                <authorlocationcode>$QuadratID</authorlocationcode>
8 9
                <locationevent>
9
                    <location_id><location><sourceaccessioncode>$PlotID</sourceaccessioncode></location></location_id>
10
                    <sourceaccessioncode>$CensusID</sourceaccessioncode>
10
                    <parent_id>
11
                        <locationevent>
12
                            <location_id><location><sourceaccessioncode>$PlotID</sourceaccessioncode></location></location_id>
13
                            <sourceaccessioncode>$CensusID</sourceaccessioncode>
14
                        </locationevent>
15
                    </parent_id>
11 16
                </locationevent>
12
            </parent_id>
13
        </locationevent>
14
    </location>
17
            </location>
18
        </path>
19
    </_simplifyPath>
15 20
</VegBIEN>
16 21
Inserted 7 new rows into database
inputs/FIA/Organism/VegBIEN.csv
1
FIA[Veg+],VegBIEN:,Comments
1
FIA[Veg+],VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 2
PlotCD,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
3 3
PlotCD,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",
4 4
PlotCD,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
inputs/SALVIAS/plotMetadata/test.xml.ref
1 1
Put template:
2 2
<VegBIEN>
3
    <location id="-1">
4
        <authorlocationcode>$SiteCode</authorlocationcode>
5
        <sourceaccessioncode>$PlotID</sourceaccessioncode>
6
        <area>$plot_area_ha</area>
7
        <elevation>
8
            <_alt>
9
                <1>
10
                    <_replace>
11
                        <\bca\.?></\bca\.?>
12
                        <value>$Elev</value>
13
                    </_replace>
14
                </1>
15
                <2>
16
                    <_avg>
17
                        <max>
3
    <_simplifyPath id="-1">
4
        <next>parent_id</next>
5
        <path>
6
            <location>
7
                <authorlocationcode>$SiteCode</authorlocationcode>
8
                <sourceaccessioncode>$PlotID</sourceaccessioncode>
9
                <area>$plot_area_ha</area>
10
                <elevation>
11
                    <_alt>
12
                        <1>
13
                            <_replace>
14
                                <\bca\.?></\bca\.?>
15
                                <value>$Elev</value>
16
                            </_replace>
17
                        </1>
18
                        <2>
19
                            <_avg>
20
                                <max>
21
                                    <_units>
22
                                        <default>m</default>
23
                                        <to>m</to>
24
                                        <to></to>
25
                                        <value>
26
                                            <_replace>
27
                                                <\bca\.?></\bca\.?>
28
                                                <value>$elev_max_m</value>
29
                                            </_replace>
30
                                        </value>
31
                                    </_units>
32
                                </max>
33
                                <min>
34
                                    <_units>
35
                                        <default>m</default>
36
                                        <to>m</to>
37
                                        <to></to>
38
                                        <value>
39
                                            <_rangeStart>
40
                                                <value>
41
                                                    <_replace>
42
                                                        <\bca\.?></\bca\.?>
43
                                                        <value>$elev_min_m</value>
44
                                                    </_replace>
45
                                                </value>
46
                                            </_rangeStart>
47
                                        </value>
48
                                    </_units>
49
                                </min>
50
                            </_avg>
51
                        </2>
52
                    </_alt>
53
                </elevation>
54
                <elevationrange>
55
                    <_range>
56
                        <from>
18 57
                            <_units>
19 58
                                <default>m</default>
20 59
                                <to>m</to>
21 60
                                <to></to>
22 61
                                <value>
23
                                    <_replace>
24
                                        <\bca\.?></\bca\.?>
25
                                        <value>$elev_max_m</value>
26
                                    </_replace>
27
                                </value>
28
                            </_units>
29
                        </max>
30
                        <min>
31
                            <_units>
32
                                <default>m</default>
33
                                <to>m</to>
34
                                <to></to>
35
                                <value>
36 62
                                    <_rangeStart>
37 63
                                        <value>
38 64
                                            <_replace>
......
43 69
                                    </_rangeStart>
44 70
                                </value>
45 71
                            </_units>
46
                        </min>
47
                    </_avg>
48
                </2>
49
            </_alt>
50
        </elevation>
51
        <elevationrange>
52
            <_range>
53
                <from>
54
                    <_units>
55
                        <default>m</default>
56
                        <to>m</to>
57
                        <to></to>
58
                        <value>
59
                            <_rangeStart>
72
                        </from>
73
                        <to>
74
                            <_units>
75
                                <default>m</default>
76
                                <to>m</to>
77
                                <to></to>
60 78
                                <value>
61
                                    <_replace>
62
                                        <\bca\.?></\bca\.?>
63
                                        <value>$elev_min_m</value>
64
                                    </_replace>
65
                                </value>
66
                            </_rangeStart>
67
                        </value>
68
                    </_units>
69
                </from>
70
                <to>
71
                    <_units>
72
                        <default>m</default>
73
                        <to>m</to>
74
                        <to></to>
75
                        <value>
76
                            <_alt>
77
                                <1>
78
                                    <_replace>
79
                                        <\bca\.?></\bca\.?>
80
                                        <value>$elev_max_m</value>
81
                                    </_replace>
82
                                </1>
83
                                <2>
84
                                    <_rangeEnd>
85
                                        <value>
79
                                    <_alt>
80
                                        <1>
86 81
                                            <_replace>
87 82
                                                <\bca\.?></\bca\.?>
88
                                                <value>$elev_min_m</value>
83
                                                <value>$elev_max_m</value>
89 84
                                            </_replace>
90
                                        </value>
91
                                    </_rangeEnd>
92
                                </2>
93
                            </_alt>
94
                        </value>
95
                    </_units>
96
                </to>
97
            </_range>
98
        </elevationrange>
99
        <locationdetermination>
100
            <latitude>
101
                <_nullIf>
102
                    <null>0</null>
103
                    <type>float</type>
104
                    <value>$LatDec</value>
105
                </_nullIf>
106
            </latitude>
107
            <longitude>
108
                <_nullIf>
109
                    <null>0</null>
110
                    <type>float</type>
111
                    <value>$LongDec</value>
112
                </_nullIf>
113
            </longitude>
114
            <namedplace_id>
115
                <_simplifyPath>
116
                    <next>parent_id</next>
117
                    <path>
118
                        <namedplace>
119
                            <rank>county</rank>
120
                            <placename>$pol2</placename>
121
                            <parent_id>
85
                                        </1>
86
                                        <2>
87
                                            <_rangeEnd>
88
                                                <value>
89
                                                    <_replace>
90
                                                        <\bca\.?></\bca\.?>
91
                                                        <value>$elev_min_m</value>
92
                                                    </_replace>
93
                                                </value>
94
                                            </_rangeEnd>
95
                                        </2>
96
                                    </_alt>
97
                                </value>
98
                            </_units>
99
                        </to>
100
                    </_range>
101
                </elevationrange>
102
                <locationdetermination>
103
                    <latitude>
104
                        <_nullIf>
105
                            <null>0</null>
106
                            <type>float</type>
107
                            <value>$LatDec</value>
108
                        </_nullIf>
109
                    </latitude>
110
                    <longitude>
111
                        <_nullIf>
112
                            <null>0</null>
113
                            <type>float</type>
114
                            <value>$LongDec</value>
115
                        </_nullIf>
116
                    </longitude>
117
                    <namedplace_id>
118
                        <_simplifyPath>
119
                            <next>parent_id</next>
120
                            <path>
122 121
                                <namedplace>
123
                                    <rank>stateProvince</rank>
124
                                    <placename>$PolDiv1</placename>
122
                                    <rank>county</rank>
123
                                    <placename>$pol2</placename>
125 124
                                    <parent_id>
126 125
                                        <namedplace>
127
                                            <rank>country</rank>
128
                                            <placename>$Country</placename>
126
                                            <rank>stateProvince</rank>
127
                                            <placename>$PolDiv1</placename>
129 128
                                            <parent_id>
130 129
                                                <namedplace>
131
                                                    <rank>continent</rank>
132
                                                    <placename>$MajorGeo</placename>
130
                                                    <rank>country</rank>
131
                                                    <placename>$Country</placename>
132
                                                    <parent_id>
133
                                                        <namedplace>
134
                                                            <rank>continent</rank>
135
                                                            <placename>$MajorGeo</placename>
136
                                                        </namedplace>
137
                                                    </parent_id>
133 138
                                                </namedplace>
134 139
                                            </parent_id>
135 140
                                        </namedplace>
136 141
                                    </parent_id>
137 142
                                </namedplace>
138
                            </parent_id>
139
                        </namedplace>
140
                    </path>
141
                </_simplifyPath>
142
            </namedplace_id>
143
        </locationdetermination>
144
        <locationevent>
145
            <method_id><method><name>$PlotMethod</name></method></method_id>
146
            <project_id><project><sourceaccessioncode>$project_id</sourceaccessioncode></project></project_id>
147
            <commclass>
148
                <commdetermination>
149
                    <commconcept_id>
150
                        <commconcept>
151
                            <commname_id><commname><commname>$life_zone_code</commname></commname></commname_id>
152
                            <commdescription>$life_zone</commdescription>
153
                        </commconcept>
154
                    </commconcept_id>
155
                </commdetermination>
156
            </commclass>
157
            <obsenddate><_date><date>$date_finish</date></_date></obsenddate>
158
            <obsstartdate><_date><date>$date_start</date></_date></obsstartdate>
159
            <precipitation>$Precip</precipitation>
160
            <soilobs>
161
                <acidity>
162
                    <_units>
163
                        <default>%</default>
164
                        <to></to>
165
                        <value>
166
                            <_map>
167
                                <<0.05>0</<0.05>
168
                                <*>*</*>
169
                                <value>$soil_acidity</value>
170
                            </_map>
171
                        </value>
172
                    </_units>
173
                </acidity>
174
                <basesaturation>
175
                    <_units>
176
                        <default>%</default>
177
                        <to></to>
178
                        <value>$soil_base</value>
179
                    </_units>
180
                </basesaturation>
181
                <calcium>
182
                    <_units>
183
                        <default>%</default>
184
                        <to></to>
185
                        <value>$soil_Ca</value>
186
                    </_units>
187
                </calcium>
188
                <carbon>
189
                    <_units>
190
                        <default>%</default>
191
                        <to></to>
192
                        <value>$soil_C</value>
193
                    </_units>
194
                </carbon>
195
                <cationexchangecapacity>$soil_cation_cap</cationexchangecapacity>
196
                <clay>
197
                    <_units>
198
                        <default>%</default>
199
                        <to></to>
200
                        <value>$clay_percent</value>
201
                    </_units>
202
                </clay>
203
                <conductivity>$soil_conductivity</conductivity>
204
                <magnesium>
205
                    <_units>
206
                        <default>%</default>
207
                        <to></to>
208
                        <value>$soil_Mg</value>
209
                    </_units>
210
                </magnesium>
211
                <nitrogen>
212
                    <_units>
213
                        <default>%</default>
214
                        <to></to>
215
                        <value>$soil_N</value>
216
                    </_units>
217
                </nitrogen>
218
                <organic>
219
                    <_units>
220
                        <default>%</default>
221
                        <to></to>
222
                        <value>$organic_percent</value>
223
                    </_units>
224
                </organic>
225
                <ph>$pH</ph>
226
                <phosphorus>
227
                    <_units>
228
                        <default>%</default>
229
                        <to></to>
230
                        <value>
231
                            <_map>
232
                                <<1,5>0</<1,5>
233
                                <*>*</*>
234
                                <value>$soil_P</value>
235
                            </_map>
236
                        </value>
237
                    </_units>
238
                </phosphorus>
239
                <potassium>
240
                    <_units>
241
                        <default>%</default>
242
                        <to></to>
243
                        <value>$soil_K</value>
244
                    </_units>
245
                </potassium>
246
                <sand>
247
                    <_units>
248
                        <default>%</default>
249
                        <to></to>
250
                        <value>$sand_percent</value>
251
                    </_units>
252
                </sand>
253
                <silt>
254
                    <_units>
255
                        <default>%</default>
256
                        <to></to>
257
                        <value>$silt_percent</value>
258
                    </_units>
259
                </silt>
260
                <sodium>
261
                    <_units>
262
                        <default>%</default>
263
                        <to></to>
264
                        <value>$soil_Na</value>
265
                    </_units>
266
                </sodium>
267
                <texture>
268
                    <_units>
269
                        <default>%</default>
270
                        <to></to>
271
                        <value>$soil_texture</value>
272
                    </_units>
273
                </texture>
274
            </soilobs>
275
            <temperature>$Temp</temperature>
276
        </locationevent>
277
        <locationnarrative>$Locality_Description</locationnarrative>
278
        <slopeaspect><_compass><value>$slope_aspect</value></_compass></slopeaspect>
279
        <slopegradient>$slope_gradient</slopegradient>
280
    </location>
143
                            </path>
144
                        </_simplifyPath>
145
                    </namedplace_id>
146
                </locationdetermination>
147
                <locationevent>
148
                    <method_id><method><name>$PlotMethod</name></method></method_id>
149
                    <project_id><project><sourceaccessioncode>$project_id</sourceaccessioncode></project></project_id>
150
                    <commclass>
151
                        <commdetermination>
152
                            <commconcept_id>
153
                                <commconcept>
154
                                    <commname_id><commname><commname>$life_zone_code</commname></commname></commname_id>
155
                                    <commdescription>$life_zone</commdescription>
156
                                </commconcept>
157
                            </commconcept_id>
158
                        </commdetermination>
159
                    </commclass>
160
                    <obsenddate><_date><date>$date_finish</date></_date></obsenddate>
161
                    <obsstartdate><_date><date>$date_start</date></_date></obsstartdate>
162
                    <precipitation>$Precip</precipitation>
163
                    <soilobs>
164
                        <acidity>
165
                            <_units>
166
                                <default>%</default>
167
                                <to></to>
168
                                <value>
169
                                    <_map>
170
                                        <<0.05>0</<0.05>
171
                                        <*>*</*>
172
                                        <value>$soil_acidity</value>
173
                                    </_map>
174
                                </value>
175
                            </_units>
176
                        </acidity>
177
                        <basesaturation>
178
                            <_units>
179
                                <default>%</default>
180
                                <to></to>
181
                                <value>$soil_base</value>
182
                            </_units>
183
                        </basesaturation>
184
                        <calcium>
185
                            <_units>
186
                                <default>%</default>
187
                                <to></to>
188
                                <value>$soil_Ca</value>
189
                            </_units>
190
                        </calcium>
191
                        <carbon>
192
                            <_units>
193
                                <default>%</default>
194
                                <to></to>
195
                                <value>$soil_C</value>
196
                            </_units>
197
                        </carbon>
198
                        <cationexchangecapacity>$soil_cation_cap</cationexchangecapacity>
199
                        <clay>
200
                            <_units>
201
                                <default>%</default>
202
                                <to></to>
203
                                <value>$clay_percent</value>
204
                            </_units>
205
                        </clay>
206
                        <conductivity>$soil_conductivity</conductivity>
207
                        <magnesium>
208
                            <_units>
209
                                <default>%</default>
210
                                <to></to>
211
                                <value>$soil_Mg</value>
212
                            </_units>
213
                        </magnesium>
214
                        <nitrogen>
215
                            <_units>
216
                                <default>%</default>
217
                                <to></to>
218
                                <value>$soil_N</value>
219
                            </_units>
220
                        </nitrogen>
221
                        <organic>
222
                            <_units>
223
                                <default>%</default>
224
                                <to></to>
225
                                <value>$organic_percent</value>
226
                            </_units>
227
                        </organic>
228
                        <ph>$pH</ph>
229
                        <phosphorus>
230
                            <_units>
231
                                <default>%</default>
232
                                <to></to>
233
                                <value>
234
                                    <_map>
235
                                        <<1,5>0</<1,5>
236
                                        <*>*</*>
237
                                        <value>$soil_P</value>
238
                                    </_map>
239
                                </value>
240
                            </_units>
241
                        </phosphorus>
242
                        <potassium>
243
                            <_units>
244
                                <default>%</default>
245
                                <to></to>
246
                                <value>$soil_K</value>
247
                            </_units>
248
                        </potassium>
249
                        <sand>
250
                            <_units>
251
                                <default>%</default>
252
                                <to></to>
253
                                <value>$sand_percent</value>
254
                            </_units>
255
                        </sand>
256
                        <silt>
257
                            <_units>
258
                                <default>%</default>
259
                                <to></to>
260
                                <value>$silt_percent</value>
261
                            </_units>
262
                        </silt>
263
                        <sodium>
264
                            <_units>
265
                                <default>%</default>
266
                                <to></to>
267
                                <value>$soil_Na</value>
268
                            </_units>
269
                        </sodium>
270
                        <texture>
271
                            <_units>
272
                                <default>%</default>
273
                                <to></to>
274
                                <value>$soil_texture</value>
275
                            </_units>
276
                        </texture>
277
                    </soilobs>
278
                    <temperature>$Temp</temperature>
279
                </locationevent>
280
                <locationnarrative>$Locality_Description</locationnarrative>
281
                <slopeaspect><_compass><value>$slope_aspect</value></_compass></slopeaspect>
282
                <slopegradient>$slope_gradient</slopegradient>
283
            </location>
284
        </path>
285
    </_simplifyPath>
281 286
</VegBIEN>
282 287
Inserted 23 new rows into database
inputs/SALVIAS/stems/VegBIEN.csv
1
SALVIAS,VegBIEN:,Comments
1
SALVIAS,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 2
PlotObsID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
3 3
NoInd,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount,
4 4
basal_diam,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/basaldiameter,
inputs/MT/Specimen/VegBIEN.csv
1
MT[Veg+],VegBIEN:,Comments
1
MT[Veg+],VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 2
id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1",
3 3
institutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/1",
4 4
collectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/1",
inputs/MT/Specimen/test.xml.ref
1 1
Put template:
2 2
<VegBIEN>
3
    <location id="-1">
4
        <authorlocationcode>
5
            <_alt>
6
                <1>$id</1>
7
                <2>
8
                    <_join>
9
                        <1>$institutionCode</1>
3
    <_simplifyPath id="-1">
4
        <next>parent_id</next>
5
        <path>
6
            <location>
7
                <authorlocationcode>
8
                    <_alt>
9
                        <1>$id</1>
10 10
                        <2>
11 11
                            <_join>
12
                                <1>$collectionCode</1>
13
                                <2>$collectionID</2>
12
                                <1>$institutionCode</1>
13
                                <2>
14
                                    <_join>
15
                                        <1>$collectionCode</1>
16
                                        <2>$collectionID</2>
17
                                    </_join>
18
                                </2>
14 19
                            </_join>
15 20
                        </2>
16
                    </_join>
17
                </2>
18
            </_alt>
19
        </authorlocationcode>
20
        <locationdetermination>
21
            <namedplace_id>
22
                <_simplifyPath>
23
                    <next>parent_id</next>
24
                    <path>
25
                        <namedplace>
26
                            <rank>county</rank>
27
                            <parent_id>
21
                    </_alt>
22
                </authorlocationcode>
23
                <locationdetermination>
24
                    <namedplace_id>
25
                        <_simplifyPath>
26
                            <next>parent_id</next>
27
                            <path>
28 28
                                <namedplace>
29
                                    <rank>stateProvince</rank>
29
                                    <rank>county</rank>
30 30
                                    <parent_id>
31 31
                                        <namedplace>
32
                                            <rank>country</rank>
32
                                            <rank>stateProvince</rank>
33 33
                                            <parent_id>
34 34
                                                <namedplace>
35
                                                    <rank>continent</rank>
36
                                                    <placename>$continent</placename>
35
                                                    <rank>country</rank>
36
                                                    <parent_id>
37
                                                        <namedplace>
38
                                                            <rank>continent</rank>
39
                                                            <placename>$continent</placename>
40
                                                        </namedplace>
41
                                                    </parent_id>
37 42
                                                </namedplace>
38 43
                                            </parent_id>
39 44
                                        </namedplace>
40 45
                                    </parent_id>
41 46
                                </namedplace>
42
                            </parent_id>
43
                        </namedplace>
44
                    </path>
45
                </_simplifyPath>
46
            </namedplace_id>
47
        </locationdetermination>
48
        <locationevent>
49
            <taxonoccurrence>
50
                <aggregateoccurrence>
51
                    <count>$individualCount</count>
52
                    <plantobservation>
53
                        <specimenreplicate>
54
                            <collectioncode_dwc>
55
                                <_join>
56
                                    <1>$collectionCode</1>
57
                                    <2>$collectionID</2>
58
                                </_join>
59
                            </collectioncode_dwc>
60
                            <institution_id><party><organizationname>$institutionCode</organizationname></party></institution_id>
61
                            <sourceaccessioncode>$id</sourceaccessioncode>
62
                        </specimenreplicate>
63
                    </plantobservation>
64
                </aggregateoccurrence>
65
                <iscultivated>
66
                    <_map>
67
                        <cultivated>t</cultivated>
68
                        <wild>f</wild>
69
                        <*></*>
70
                        <value>$establishmentMeans</value>
71
                    </_map>
72
                </iscultivated>
73
                <isnative>
74
                    <_map>
75
                        <native>t</native>
76
                        <exotic>f</exotic>
77
                        <*></*>
78
                        <value>$establishmentMeans</value>
79
                    </_map>
80
                </isnative>
81
                <taxondetermination>
82
                    <plantconcept_id>
83
                        <plantconcept>
84
                            <plantname_id>
85
                                <_simplifyPath>
86
                                    <next>parent_id</next>
87
                                    <path>
88
                                        <plantname>
89
                                            <rank>binomial</rank>
90
                                            <parent_id>
47
                            </path>
48
                        </_simplifyPath>
49
                    </namedplace_id>
50
                </locationdetermination>
51
                <locationevent>
52
                    <taxonoccurrence>
53
                        <aggregateoccurrence>
54
                            <count>$individualCount</count>
55
                            <plantobservation>
56
                                <specimenreplicate>
57
                                    <collectioncode_dwc>
58
                                        <_join>
59
                                            <1>$collectionCode</1>
60
                                            <2>$collectionID</2>
61
                                        </_join>
62
                                    </collectioncode_dwc>
63
                                    <institution_id><party><organizationname>$institutionCode</organizationname></party></institution_id>
64
                                    <sourceaccessioncode>$id</sourceaccessioncode>
65
                                </specimenreplicate>
66
                            </plantobservation>
67
                        </aggregateoccurrence>
68
                        <iscultivated>
69
                            <_map>
70
                                <cultivated>t</cultivated>
71
                                <wild>f</wild>
72
                                <*></*>
73
                                <value>$establishmentMeans</value>
74
                            </_map>
75
                        </iscultivated>
76
                        <isnative>
77
                            <_map>
78
                                <native>t</native>
79
                                <exotic>f</exotic>
80
                                <*></*>
81
                                <value>$establishmentMeans</value>
82
                            </_map>
83
                        </isnative>
84
                        <taxondetermination>
85
                            <plantconcept_id>
86
                                <plantconcept>
87
                                    <plantname_id>
88
                                        <_simplifyPath>
89
                                            <next>parent_id</next>
90
                                            <path>
91 91
                                                <plantname>
92
                                                    <rank>authority</rank>
92
                                                    <rank>binomial</rank>
93 93
                                                    <parent_id>
94 94
                                                        <plantname>
95
                                                            <rank>subspecies</rank>
95
                                                            <rank>authority</rank>
96 96
                                                            <parent_id>
97 97
                                                                <plantname>
98
                                                                    <rank>species</rank>
98
                                                                    <rank>subspecies</rank>
99 99
                                                                    <parent_id>
100 100
                                                                        <plantname>
101
                                                                            <rank>genus</rank>
102
                                                                            <plantname>$genus</plantname>
101
                                                                            <rank>species</rank>
103 102
                                                                            <parent_id>
104 103
                                                                                <plantname>
105
                                                                                    <rank>family</rank>
106
                                                                                    <plantname>$family</plantname>
104
                                                                                    <rank>genus</rank>
105
                                                                                    <plantname>$genus</plantname>
106
                                                                                    <parent_id>
107
                                                                                        <plantname>
108
                                                                                            <rank>family</rank>
109
                                                                                            <plantname>$family</plantname>
110
                                                                                        </plantname>
111
                                                                                    </parent_id>
107 112
                                                                                </plantname>
108 113
                                                                            </parent_id>
109 114
                                                                        </plantname>
......
113 118
                                                        </plantname>
114 119
                                                    </parent_id>
115 120
                                                </plantname>
116
                                            </parent_id>
117
                                        </plantname>
118
                                    </path>
119
                                </_simplifyPath>
120
                            </plantname_id>
121
                        </plantconcept>
122
                    </plantconcept_id>
123
                </taxondetermination>
124
            </taxonoccurrence>
125
        </locationevent>
126
        <locationnarrative>$locality</locationnarrative>
127
    </location>
121
                                            </path>
122
                                        </_simplifyPath>
123
                                    </plantname_id>
124
                                </plantconcept>
125
                            </plantconcept_id>
126
                        </taxondetermination>
127
                    </taxonoccurrence>
128
                </locationevent>
129
                <locationnarrative>$locality</locationnarrative>
130
            </location>
131
        </path>
132
    </_simplifyPath>
128 133
</VegBIEN>
129 134
Inserted 22 new rows into database
inputs/XAL/Specimen/VegBIEN.csv
1
"XAL[Veg+,darwin:]:/content/record/",VegBIEN:,Comments
1
"XAL[Veg+,darwin:]:/content/record/",VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 2
institutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/1",
3 3
collectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/1",
4 4
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else",
inputs/TEAM/VL/VegBIEN.csv
1
TEAM[Veg+],VegBIEN:,Comments
1
TEAM[Veg+],VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 2
subplot,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2",
3 3
1haPlotCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
4 4
id,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1",
inputs/TEAM/VL/test.xml.ref
1 1
Put template:
2 2
<VegBIEN>
3
    <location id="-1">
4
        <parent_id><location><authorlocationcode>$1haPlotCode</authorlocationcode></location></parent_id>
5
        <authorlocationcode>$Subplot</authorlocationcode>
6
        <locationdetermination>
7
            <latitude>
8
                <_nullIf>
9
                    <null>0</null>
10
                    <type>float</type>
11
                    <value>$Latitude</value>
12
                </_nullIf>
13
            </latitude>
14
            <longitude>
15
                <_nullIf>
16
                    <null>0</null>
17
                    <type>float</type>
18
                    <value>$Longitude</value>
19
                </_nullIf>
20
            </longitude>
21
        </locationdetermination>
22
        <locationevent>
23
            <method_id><method><name>$Method</name></method></method_id>
24
            <project_id><project><projectname>$SiteName</projectname></project></project_id>
25
            <obsenddate><_date><date><_dateRangeEnd><value>$ObservationDate</value></_dateRangeEnd></date></_date></obsenddate>
26
            <obsstartdate><_date><date><_dateRangeStart><value>$ObservationDate</value></_dateRangeStart></date></_date></obsstartdate>
27
            <taxonoccurrence>
28
                <aggregateoccurrence>
29
                    <plantobservation>
30
                        <specimenreplicate><sourceaccessioncode>$ID</sourceaccessioncode></specimenreplicate>
31
                        <stemobservation>
32
                            <diameterbreastheight>$dbh</diameterbreastheight>
33
                            <stemtag>
34
                                <iscurrent>true</iscurrent>
35
                                <tag>$TreeNumber</tag>
36
                            </stemtag>
37
                            <xposition>$X_1haPlot</xposition>
38
                            <yposition>$Y_1haPlot</yposition>
39
                        </stemobservation>
40
                    </plantobservation>
41
                </aggregateoccurrence>
42
                <taxondetermination>
43
                    <plantconcept_id>
44
                        <plantconcept>
45
                            <plantname_id>
46
                                <_simplifyPath>
47
                                    <next>parent_id</next>
48
                                    <path>
49
                                        <plantname>
50
                                            <rank>binomial</rank>
51
                                            <parent_id>
3
    <_simplifyPath id="-1">
4
        <next>parent_id</next>
5
        <path>
6
            <location>
7
                <parent_id><location><authorlocationcode>$1haPlotCode</authorlocationcode></location></parent_id>
8
                <authorlocationcode>$Subplot</authorlocationcode>
9
                <locationdetermination>
10
                    <latitude>
11
                        <_nullIf>
12
                            <null>0</null>
13
                            <type>float</type>
14
                            <value>$Latitude</value>
15
                        </_nullIf>
16
                    </latitude>
17
                    <longitude>
18
                        <_nullIf>
19
                            <null>0</null>
20
                            <type>float</type>
21
                            <value>$Longitude</value>
22
                        </_nullIf>
23
                    </longitude>
24
                </locationdetermination>
25
                <locationevent>
26
                    <method_id><method><name>$Method</name></method></method_id>
27
                    <project_id><project><projectname>$SiteName</projectname></project></project_id>
28
                    <obsenddate><_date><date><_dateRangeEnd><value>$ObservationDate</value></_dateRangeEnd></date></_date></obsenddate>
29
                    <obsstartdate><_date><date><_dateRangeStart><value>$ObservationDate</value></_dateRangeStart></date></_date></obsstartdate>
30
                    <taxonoccurrence>
31
                        <aggregateoccurrence>
32
                            <plantobservation>
33
                                <specimenreplicate><sourceaccessioncode>$ID</sourceaccessioncode></specimenreplicate>
34
                                <stemobservation>
35
                                    <diameterbreastheight>$dbh</diameterbreastheight>
36
                                    <stemtag>
37
                                        <iscurrent>true</iscurrent>
38
                                        <tag>$TreeNumber</tag>
39
                                    </stemtag>
40
                                    <xposition>$X_1haPlot</xposition>
41
                                    <yposition>$Y_1haPlot</yposition>
42
                                </stemobservation>
43
                            </plantobservation>
44
                        </aggregateoccurrence>
45
                        <taxondetermination>
46
                            <plantconcept_id>
47
                                <plantconcept>
48
                                    <plantname_id>
49
                                        <_simplifyPath>
50
                                            <next>parent_id</next>
51
                                            <path>
52 52
                                                <plantname>
53
                                                    <rank>authority</rank>
53
                                                    <rank>binomial</rank>
54 54
                                                    <parent_id>
55 55
                                                        <plantname>
56
                                                            <rank>subspecies</rank>
56
                                                            <rank>authority</rank>
57 57
                                                            <parent_id>
58 58
                                                                <plantname>
59
                                                                    <rank>species</rank>
60
                                                                    <plantname>$SpecificEpithet</plantname>
59
                                                                    <rank>subspecies</rank>
61 60
                                                                    <parent_id>
62 61
                                                                        <plantname>
63
                                                                            <rank>genus</rank>
64
                                                                            <plantname>$Genus</plantname>
62
                                                                            <rank>species</rank>
63
                                                                            <plantname>$SpecificEpithet</plantname>
65 64
                                                                            <parent_id>
66 65
                                                                                <plantname>
67
                                                                                    <rank>family</rank>
68
                                                                                    <plantname>$Family</plantname>
66
                                                                                    <rank>genus</rank>
67
                                                                                    <plantname>$Genus</plantname>
68
                                                                                    <parent_id>
69
                                                                                        <plantname>
70
                                                                                            <rank>family</rank>
71
                                                                                            <plantname>$Family</plantname>
72
                                                                                        </plantname>
73
                                                                                    </parent_id>
69 74
                                                                                </plantname>
70 75
                                                                            </parent_id>
71 76
                                                                        </plantname>
......
75 80
                                                        </plantname>
76 81
                                                    </parent_id>
77 82
                                                </plantname>
78
                                            </parent_id>
79
                                        </plantname>
80
                                    </path>
81
                                </_simplifyPath>
82
                            </plantname_id>
83
                        </plantconcept>
84
                    </plantconcept_id>
85
                </taxondetermination>
86
                <verbatimcollectorname>$Collectors</verbatimcollectorname>
87
            </taxonoccurrence>
88
        </locationevent>
89
    </location>
83
                                            </path>
84
                                        </_simplifyPath>
85
                                    </plantname_id>
86
                                </plantconcept>
87
                            </plantconcept_id>
88
                        </taxondetermination>
89
                        <verbatimcollectorname>$Collectors</verbatimcollectorname>
90
                    </taxonoccurrence>
91
                </locationevent>
92
            </location>
93
        </path>
94
    </_simplifyPath>
90 95
</VegBIEN>
91 96
Inserted 23 new rows into database
inputs/TEAM/VT/VegBIEN.csv
1
TEAM[Veg+],VegBIEN:,Comments
1
TEAM[Veg+],VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 2
subplot,"/location/_if[@name=""if subplot""]/cond/_exists/_first/2",
3 3
1haPlotCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
4 4
ID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1",
inputs/TEAM/VT/test.xml.ref
1 1
Put template:
2 2
<VegBIEN>
3
    <location id="-1">
4
        <parent_id><location><authorlocationcode>$1haPlotCode</authorlocationcode></location></parent_id>
5
        <authorlocationcode>$Subplot</authorlocationcode>
6
        <locationdetermination>
7
            <latitude>
8
                <_nullIf>
9
                    <null>0</null>
10
                    <type>float</type>
11
                    <value>$Latitude</value>
12
                </_nullIf>
13
            </latitude>
14
            <longitude>
15
                <_nullIf>
16
                    <null>0</null>
17
                    <type>float</type>
18
                    <value>$Longitude</value>
19
                </_nullIf>
20
            </longitude>
21
        </locationdetermination>
22
        <locationevent>
23
            <method_id><method><name>$Method</name></method></method_id>
24
            <project_id><project><projectname>$SiteName</projectname></project></project_id>
25
            <obsenddate><_date><date><_dateRangeEnd><value>$ObservationDate</value></_dateRangeEnd></date></_date></obsenddate>
26
            <obsstartdate><_date><date><_dateRangeStart><value>$ObservationDate</value></_dateRangeStart></date></_date></obsstartdate>
27
            <taxonoccurrence>
28
                <aggregateoccurrence>
29
                    <plantobservation>
30
                        <specimenreplicate><sourceaccessioncode>$ID</sourceaccessioncode></specimenreplicate>
31
                        <stemobservation>
32
                            <diameterbreastheight>$dbh</diameterbreastheight>
33
                            <stemtag>
34
                                <iscurrent>true</iscurrent>
35
                                <tag>$TreeNumber</tag>
36
                            </stemtag>
37
                            <xposition>$X_1haPlot</xposition>
38
                            <yposition>$Y_1haPlot</yposition>
39
                        </stemobservation>
40
                    </plantobservation>
41
                </aggregateoccurrence>
42
                <taxondetermination>
43
                    <plantconcept_id>
44
                        <plantconcept>
45
                            <plantname_id>
46
                                <_simplifyPath>
47
                                    <next>parent_id</next>
48
                                    <path>
49
                                        <plantname>
50
                                            <rank>binomial</rank>
51
                                            <parent_id>
3
    <_simplifyPath id="-1">
4
        <next>parent_id</next>
5
        <path>
6
            <location>
7
                <parent_id><location><authorlocationcode>$1haPlotCode</authorlocationcode></location></parent_id>
8
                <authorlocationcode>$Subplot</authorlocationcode>
9
                <locationdetermination>
10
                    <latitude>
11
                        <_nullIf>
12
                            <null>0</null>
13
                            <type>float</type>
14
                            <value>$Latitude</value>
15
                        </_nullIf>
16
                    </latitude>
17
                    <longitude>
18
                        <_nullIf>
19
                            <null>0</null>
20
                            <type>float</type>
21
                            <value>$Longitude</value>
22
                        </_nullIf>
23
                    </longitude>
24
                </locationdetermination>
25
                <locationevent>
26
                    <method_id><method><name>$Method</name></method></method_id>
27
                    <project_id><project><projectname>$SiteName</projectname></project></project_id>
28
                    <obsenddate><_date><date><_dateRangeEnd><value>$ObservationDate</value></_dateRangeEnd></date></_date></obsenddate>
29
                    <obsstartdate><_date><date><_dateRangeStart><value>$ObservationDate</value></_dateRangeStart></date></_date></obsstartdate>
30
                    <taxonoccurrence>
31
                        <aggregateoccurrence>
32
                            <plantobservation>
33
                                <specimenreplicate><sourceaccessioncode>$ID</sourceaccessioncode></specimenreplicate>
34
                                <stemobservation>
35
                                    <diameterbreastheight>$dbh</diameterbreastheight>
36
                                    <stemtag>
37
                                        <iscurrent>true</iscurrent>
38
                                        <tag>$TreeNumber</tag>
39
                                    </stemtag>
40
                                    <xposition>$X_1haPlot</xposition>
41
                                    <yposition>$Y_1haPlot</yposition>
42
                                </stemobservation>
43
                            </plantobservation>
44
                        </aggregateoccurrence>
45
                        <taxondetermination>
46
                            <plantconcept_id>
47
                                <plantconcept>
48
                                    <plantname_id>
49
                                        <_simplifyPath>
50
                                            <next>parent_id</next>
51
                                            <path>
52 52
                                                <plantname>
53
                                                    <rank>authority</rank>
53
                                                    <rank>binomial</rank>
54 54
                                                    <parent_id>
55 55
                                                        <plantname>
56
                                                            <rank>subspecies</rank>
56
                                                            <rank>authority</rank>
57 57
                                                            <parent_id>
58 58
                                                                <plantname>
59
                                                                    <rank>species</rank>
60
                                                                    <plantname>$SpecificEpithet</plantname>
59
                                                                    <rank>subspecies</rank>
61 60
                                                                    <parent_id>
62 61
                                                                        <plantname>
63
                                                                            <rank>genus</rank>
64
                                                                            <plantname>$Genus</plantname>
62
                                                                            <rank>species</rank>
63
                                                                            <plantname>$SpecificEpithet</plantname>
65 64
                                                                            <parent_id>
66 65
                                                                                <plantname>
67
                                                                                    <rank>family</rank>
68
                                                                                    <plantname>$Family</plantname>
66
                                                                                    <rank>genus</rank>
67
                                                                                    <plantname>$Genus</plantname>
68
                                                                                    <parent_id>
69
                                                                                        <plantname>
70
                                                                                            <rank>family</rank>
71
                                                                                            <plantname>$Family</plantname>
72
                                                                                        </plantname>
73
                                                                                    </parent_id>
69 74
                                                                                </plantname>
70 75
                                                                            </parent_id>
71 76
                                                                        </plantname>
......
75 80
                                                        </plantname>
76 81
                                                    </parent_id>
77 82
                                                </plantname>
78
                                            </parent_id>
79
                                        </plantname>
80
                                    </path>
81
                                </_simplifyPath>
82
                            </plantname_id>
83
                        </plantconcept>
84
                    </plantconcept_id>
85
                </taxondetermination>
86
                <verbatimcollectorname>$Collectors</verbatimcollectorname>
87
            </taxonoccurrence>
88
        </locationevent>
89
    </location>
83
                                            </path>
84
                                        </_simplifyPath>
85
                                    </plantname_id>
86
                                </plantconcept>
87
                            </plantconcept_id>
88
                        </taxondetermination>
89
                        <verbatimcollectorname>$Collectors</verbatimcollectorname>
90
                    </taxonoccurrence>
91
                </locationevent>
92
            </location>
93
        </path>
94
    </_simplifyPath>
90 95
</VegBIEN>
91 96
Inserted 23 new rows into database
inputs/NY/Specimen/VegBIEN.csv
1
NY[Veg+],VegBIEN:,Comments
1
NY[Veg+],VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 2
UniqueNYInternalRecordNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1",
3 3
institutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/1",
4 4
collectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/1",
inputs/NY/Specimen/test.xml.ref
1 1
Put template:
2 2
<VegBIEN>
3
    <location id="-1">
4
        <authorlocationcode>
5
            <_alt>
6
                <1>$UniqueNYInternalRecordNumber</1>
7
                <2>
8
                    <_join>
9
                        <1>$InstitutionCode</1>
10
                        <2>$CollectionCode</2>
11
                        <3>$CatalogNumber</3>
12
                    </_join>
13
                </2>
14
            </_alt>
15
        </authorlocationcode>
16
        <elevation>
17
            <_avg>
18
                <max>
19
                    <_units>
20
                        <default>m</default>
21
                        <to>m</to>
22
                        <to></to>
23
                        <value>
24
                            <_replace>
25
                                <\bca\.?></\bca\.?>
26
                                <value>$MaximumElevation</value>
27
                            </_replace>
28
                        </value>
29
                    </_units>
30
                </max>
31
                <min>
32
                    <_units>
33
                        <default>m</default>
34
                        <to>m</to>
35
                        <to></to>
36
                        <value>
37
                            <_rangeStart>
3
    <_simplifyPath id="-1">
4
        <next>parent_id</next>
5
        <path>
6
            <location>
7
                <authorlocationcode>
8
                    <_alt>
9
                        <1>$UniqueNYInternalRecordNumber</1>
10
                        <2>
11
                            <_join>
12
                                <1>$InstitutionCode</1>
13
                                <2>$CollectionCode</2>
14
                                <3>$CatalogNumber</3>
15
                            </_join>
16
                        </2>
17
                    </_alt>
18
                </authorlocationcode>
19
                <elevation>
20
                    <_avg>
21
                        <max>
22
                            <_units>
23
                                <default>m</default>
24
                                <to>m</to>
25
                                <to></to>
38 26
                                <value>
39 27
                                    <_replace>
40 28
                                        <\bca\.?></\bca\.?>
41
                                        <value>
42
                                            <_nullIf>
43
                                                <null>.</null>
44
                                                <value>$MinimumElevation</value>
45
                                            </_nullIf>
46
                                        </value>
29
                                        <value>$MaximumElevation</value>
47 30
                                    </_replace>
48 31
                                </value>
49
                            </_rangeStart>
50
                        </value>
51
                    </_units>
52
                </min>
53
            </_avg>
54
        </elevation>
55
        <elevationrange>
56
            <_range>
57
                <from>
58
                    <_units>
59
                        <default>m</default>
60
                        <to>m</to>
61
                        <to></to>
62
                        <value>
63
                            <_rangeStart>
32
                            </_units>
33
                        </max>
34
                        <min>
35
                            <_units>
36
                                <default>m</default>
37
                                <to>m</to>
38
                                <to></to>
64 39
                                <value>
65
                                    <_replace>
66
                                        <\bca\.?></\bca\.?>
40
                                    <_rangeStart>
67 41
                                        <value>
68
                                            <_nullIf>
69
                                                <null>.</null>
70
                                                <value>$MinimumElevation</value>
71
                                            </_nullIf>
42
                                            <_replace>
43
                                                <\bca\.?></\bca\.?>
44
                                                <value>
45
                                                    <_nullIf>
46
                                                        <null>.</null>
47
                                                        <value>$MinimumElevation</value>
48
                                                    </_nullIf>
49
                                                </value>
50
                                            </_replace>
72 51
                                        </value>
73
                                    </_replace>
52
                                    </_rangeStart>
74 53
                                </value>
75
                            </_rangeStart>
76
                        </value>
77
                    </_units>
78
                </from>
79
                <to>
80
                    <_units>
81
                        <default>m</default>
82
                        <to>m</to>
83
                        <to></to>
84
                        <value>
85
                            <_alt>
86
                                <1>
87
                                    <_replace>
88
                                        <\bca\.?></\bca\.?>
89
                                        <value>$MaximumElevation</value>
90
                                    </_replace>
91
                                </1>
92
                                <2>
93
                                    <_rangeEnd>
54
                            </_units>
55
                        </min>
56
                    </_avg>
57
                </elevation>
58
                <elevationrange>
59
                    <_range>
60
                        <from>
61
                            <_units>
62
                                <default>m</default>
63
                                <to>m</to>
64
                                <to></to>
65
                                <value>
66
                                    <_rangeStart>
94 67
                                        <value>
95 68
                                            <_replace>
96 69
                                                <\bca\.?></\bca\.?>
......
102 75
                                                </value>
103 76
                                            </_replace>
104 77
                                        </value>
105
                                    </_rangeEnd>
106
                                </2>
107
                            </_alt>
108
                        </value>
109
                    </_units>
110
                </to>
111
            </_range>
112
        </elevationrange>
113
        <locationdetermination>
114
            <coordsaccuracy><_noCV><value>$CoordinatePrecision</value></_noCV></coordsaccuracy>
115
            <footprintgeometry_dwc>$BoundingBox</footprintgeometry_dwc>
116
            <latitude>
117
                <_nullIf>
118
                    <null>0</null>
119
                    <type>float</type>
120
                    <value>$Latitude</value>
121
                </_nullIf>
122
            </latitude>
123
            <longitude>
124
                <_nullIf>
125
                    <null>0</null>
126
                    <type>float</type>
127
                    <value>$Longitude</value>
128
                </_nullIf>
129
            </longitude>
130
            <namedplace_id>
131
                <_simplifyPath>
132
                    <next>parent_id</next>
133
                    <path>
134
                        <namedplace>
135
                            <rank>county</rank>
136
                            <placename>$County</placename>
137
                            <parent_id>
78
                                    </_rangeStart>
79
                                </value>
80
                            </_units>
81
                        </from>
82
                        <to>
83
                            <_units>
84
                                <default>m</default>
85
                                <to>m</to>
86
                                <to></to>
87
                                <value>
88
                                    <_alt>
89
                                        <1>
90
                                            <_replace>
91
                                                <\bca\.?></\bca\.?>
92
                                                <value>$MaximumElevation</value>
93
                                            </_replace>
94
                                        </1>
95
                                        <2>
96
                                            <_rangeEnd>
97
                                                <value>
98
                                                    <_replace>
99
                                                        <\bca\.?></\bca\.?>
100
                                                        <value>
101
                                                            <_nullIf>
102
                                                                <null>.</null>
103
                                                                <value>$MinimumElevation</value>
104
                                                            </_nullIf>
105
                                                        </value>
106
                                                    </_replace>
107
                                                </value>
108
                                            </_rangeEnd>
109
                                        </2>
110
                                    </_alt>
111
                                </value>
112
                            </_units>
113
                        </to>
114
                    </_range>
115
                </elevationrange>
116
                <locationdetermination>
117
                    <coordsaccuracy><_noCV><value>$CoordinatePrecision</value></_noCV></coordsaccuracy>
118
                    <footprintgeometry_dwc>$BoundingBox</footprintgeometry_dwc>
119
                    <latitude>
120
                        <_nullIf>
121
                            <null>0</null>
122
                            <type>float</type>
123
                            <value>$Latitude</value>
124
                        </_nullIf>
125
                    </latitude>
126
                    <longitude>
127
                        <_nullIf>
128
                            <null>0</null>
129
                            <type>float</type>
130
                            <value>$Longitude</value>
131
                        </_nullIf>
132
                    </longitude>
133
                    <namedplace_id>
134
                        <_simplifyPath>
135
                            <next>parent_id</next>
136
                            <path>
138 137
                                <namedplace>
139
                                    <rank>stateProvince</rank>
140
                                    <placename>$StateProvince</placename>
138
                                    <rank>county</rank>
139
                                    <placename>$County</placename>
141 140
                                    <parent_id>
142 141
                                        <namedplace>
143
                                            <rank>country</rank>
144
                                            <placename>$Country</placename>
142
                                            <rank>stateProvince</rank>
143
                                            <placename>$StateProvince</placename>
145 144
                                            <parent_id>
146 145
                                                <namedplace>
147
                                                    <rank>continent</rank>
148
                                                    <placename>$ContinentOcean</placename>
146
                                                    <rank>country</rank>
147
                                                    <placename>$Country</placename>
148
                                                    <parent_id>
149
                                                        <namedplace>
150
                                                            <rank>continent</rank>
151
                                                            <placename>$ContinentOcean</placename>
152
                                                        </namedplace>
153
                                                    </parent_id>
149 154
                                                </namedplace>
150 155
                                            </parent_id>
151 156
                                        </namedplace>
152 157
                                    </parent_id>
153 158
                                </namedplace>
154
                            </parent_id>
155
                        </namedplace>
156
                    </path>
157
                </_simplifyPath>
158
            </namedplace_id>
159
        </locationdetermination>
160
        <locationevent>
161
            <taxonoccurrence>
162
                <aggregateoccurrence>
163
                    <collectiondate>
164
                        <_date>
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff