Revision 4726
Added by Aaron Marcuse-Kubitza about 12 years ago
| test.xml.ref | ||
|---|---|---|
| 113 | 113 |
</to> |
| 114 | 114 |
</_range> |
| 115 | 115 |
</elevationrange> |
| 116 |
<locationdetermination>
|
|
| 116 |
<locationcoords>
|
|
| 117 | 117 |
<coordsaccuracy><_noCV><value>$coordinateUncertaintyInMeters</value></_noCV></coordsaccuracy> |
| 118 | 118 |
<footprintgeometry_dwc>$footprintWKT</footprintgeometry_dwc> |
| 119 | 119 |
<latitude> |
| ... | ... | |
| 152 | 152 |
</2> |
| 153 | 153 |
</_alt> |
| 154 | 154 |
</longitude> |
| 155 |
<namedplace_id> |
|
| 156 |
<namedplace> |
|
| 157 |
<rank>county</rank> |
|
| 158 |
<placename>$county</placename> |
|
| 159 |
<parent_id> |
|
| 160 |
<namedplace> |
|
| 161 |
<rank>stateProvince</rank> |
|
| 162 |
<placename>$stateProvince</placename> |
|
| 163 |
<parent_id> |
|
| 164 |
<namedplace> |
|
| 165 |
<rank>country</rank> |
|
| 166 |
<placename>$country</placename> |
|
| 167 |
<parent_id> |
|
| 168 |
<namedplace> |
|
| 169 |
<rank>continent</rank> |
|
| 170 |
<placename>$continent</placename> |
|
| 171 |
</namedplace> |
|
| 172 |
</parent_id> |
|
| 173 |
</namedplace> |
|
| 174 |
</parent_id> |
|
| 175 |
</namedplace> |
|
| 176 |
</parent_id> |
|
| 177 |
</namedplace> |
|
| 178 |
</namedplace_id> |
|
| 179 |
</locationdetermination> |
|
| 155 |
</locationcoords> |
|
| 180 | 156 |
<locationevent> |
| 181 | 157 |
<method_id><method><name>$samplingProtocol</name></method></method_id> |
| 182 | 158 |
<obsenddate><_date><date><_dateRangeEnd><value>$eventDate</value></_dateRangeEnd></date></_date></obsenddate> |
| ... | ... | |
| 252 | 228 |
</3> |
| 253 | 229 |
</_merge> |
| 254 | 230 |
</locationnarrative> |
| 231 |
<locationplace> |
|
| 232 |
<namedplace_id> |
|
| 233 |
<namedplace> |
|
| 234 |
<rank>county</rank> |
|
| 235 |
<placename>$county</placename> |
|
| 236 |
<parent_id> |
|
| 237 |
<namedplace> |
|
| 238 |
<rank>stateProvince</rank> |
|
| 239 |
<placename>$stateProvince</placename> |
|
| 240 |
<parent_id> |
|
| 241 |
<namedplace> |
|
| 242 |
<rank>country</rank> |
|
| 243 |
<placename>$country</placename> |
|
| 244 |
<parent_id> |
|
| 245 |
<namedplace> |
|
| 246 |
<rank>continent</rank> |
|
| 247 |
<placename>$continent</placename> |
|
| 248 |
</namedplace> |
|
| 249 |
</parent_id> |
|
| 250 |
</namedplace> |
|
| 251 |
</parent_id> |
|
| 252 |
</namedplace> |
|
| 253 |
</parent_id> |
|
| 254 |
</namedplace> |
|
| 255 |
</namedplace_id> |
|
| 256 |
</locationplace> |
|
| 255 | 257 |
</location> |
| 256 | 258 |
</path> |
| 257 | 259 |
</_simplifyPath> |
| 258 | 260 |
</VegBIEN> |
| 259 |
Inserted 26 new rows into database |
|
| 261 |
Inserted 28 new rows into database |
|
Also available in: Unified diff
schemas/vegbien.sql: Split locationdetermination into locationcoords and locationplace, so that coordinate determinations can be made separately from place determinations