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>$CoordinatePrecision</value></_noCV></coordsaccuracy> |
| 118 | 118 |
<footprintgeometry_dwc>$BoundingBox</footprintgeometry_dwc> |
| 119 | 119 |
<latitude> |
| ... | ... | |
| 130 | 130 |
<value>$Longitude</value> |
| 131 | 131 |
</_nullIf> |
| 132 | 132 |
</longitude> |
| 133 |
<namedplace_id> |
|
| 134 |
<namedplace> |
|
| 135 |
<rank>county</rank> |
|
| 136 |
<placename>$County</placename> |
|
| 137 |
<parent_id> |
|
| 138 |
<namedplace> |
|
| 139 |
<rank>stateProvince</rank> |
|
| 140 |
<placename>$StateProvince</placename> |
|
| 141 |
<parent_id> |
|
| 142 |
<namedplace> |
|
| 143 |
<rank>country</rank> |
|
| 144 |
<placename>$Country</placename> |
|
| 145 |
<parent_id> |
|
| 146 |
<namedplace> |
|
| 147 |
<rank>continent</rank> |
|
| 148 |
<placename>$ContinentOcean</placename> |
|
| 149 |
</namedplace> |
|
| 150 |
</parent_id> |
|
| 151 |
</namedplace> |
|
| 152 |
</parent_id> |
|
| 153 |
</namedplace> |
|
| 154 |
</parent_id> |
|
| 155 |
</namedplace> |
|
| 156 |
</namedplace_id> |
|
| 157 |
</locationdetermination> |
|
| 133 |
</locationcoords> |
|
| 158 | 134 |
<locationevent> |
| 159 | 135 |
<taxonoccurrence> |
| 160 | 136 |
<aggregateoccurrence> |
| ... | ... | |
| 328 | 304 |
</3> |
| 329 | 305 |
</_merge> |
| 330 | 306 |
</locationnarrative> |
| 307 |
<locationplace> |
|
| 308 |
<namedplace_id> |
|
| 309 |
<namedplace> |
|
| 310 |
<rank>county</rank> |
|
| 311 |
<placename>$County</placename> |
|
| 312 |
<parent_id> |
|
| 313 |
<namedplace> |
|
| 314 |
<rank>stateProvince</rank> |
|
| 315 |
<placename>$StateProvince</placename> |
|
| 316 |
<parent_id> |
|
| 317 |
<namedplace> |
|
| 318 |
<rank>country</rank> |
|
| 319 |
<placename>$Country</placename> |
|
| 320 |
<parent_id> |
|
| 321 |
<namedplace> |
|
| 322 |
<rank>continent</rank> |
|
| 323 |
<placename>$ContinentOcean</placename> |
|
| 324 |
</namedplace> |
|
| 325 |
</parent_id> |
|
| 326 |
</namedplace> |
|
| 327 |
</parent_id> |
|
| 328 |
</namedplace> |
|
| 329 |
</parent_id> |
|
| 330 |
</namedplace> |
|
| 331 |
</namedplace_id> |
|
| 332 |
</locationplace> |
|
| 331 | 333 |
</location> |
| 332 | 334 |
</path> |
| 333 | 335 |
</_simplifyPath> |
| 334 | 336 |
</VegBIEN> |
| 335 |
Inserted 30 new rows into database |
|
| 337 |
Inserted 32 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