Revision 5861
Added by Aaron Marcuse-Kubitza about 12 years ago
| test.xml.ref | ||
|---|---|---|
| 38 | 38 |
</2> |
| 39 | 39 |
</_alt> |
| 40 | 40 |
</elevation_m> |
| 41 |
<locationcoords> |
|
| 42 |
<coordsaccuracy_deg><_noCV><value>$coordinateUncertaintyInMeters</value></_noCV></coordsaccuracy_deg> |
|
| 43 |
<footprintgeometry_dwc>$footprintWKT</footprintgeometry_dwc> |
|
| 44 |
<latitude_deg> |
|
| 45 |
<_nullIf> |
|
| 46 |
<null>0</null> |
|
| 47 |
<type>float</type> |
|
| 48 |
<value>$decimalLatitude</value> |
|
| 49 |
</_nullIf> |
|
| 50 |
</latitude_deg> |
|
| 51 |
<longitude_deg> |
|
| 52 |
<_nullIf> |
|
| 53 |
<null>0</null> |
|
| 54 |
<type>float</type> |
|
| 55 |
<value>$decimalLongitude</value> |
|
| 56 |
</_nullIf> |
|
| 57 |
</longitude_deg> |
|
| 58 |
<verbatimlatitude>$verbatimLatitude</verbatimlatitude> |
|
| 59 |
<verbatimlongitude>$verbatimLongitude</verbatimlongitude> |
|
| 60 |
</locationcoords> |
|
| 61 | 41 |
<locationevent> |
| 62 | 42 |
<method_id><method><name>$samplingProtocol</name></method></method_id> |
| 63 | 43 |
<obsenddate><_date><date><_dateRangeEnd><value>$eventDate</value></_dateRangeEnd></date></_date></obsenddate> |
| ... | ... | |
| 276 | 256 |
<locationplace> |
| 277 | 257 |
<place_id> |
| 278 | 258 |
<place> |
| 259 |
<coordinates_id> |
|
| 260 |
<coordinates> |
|
| 261 |
<coordsaccuracy_deg><_noCV><value>$coordinateUncertaintyInMeters</value></_noCV></coordsaccuracy_deg> |
|
| 262 |
<footprintgeometry_dwc>$footprintWKT</footprintgeometry_dwc> |
|
| 263 |
<latitude_deg> |
|
| 264 |
<_nullIf> |
|
| 265 |
<null>0</null> |
|
| 266 |
<type>float</type> |
|
| 267 |
<value>$decimalLatitude</value> |
|
| 268 |
</_nullIf> |
|
| 269 |
</latitude_deg> |
|
| 270 |
<longitude_deg> |
|
| 271 |
<_nullIf> |
|
| 272 |
<null>0</null> |
|
| 273 |
<type>float</type> |
|
| 274 |
<value>$decimalLongitude</value> |
|
| 275 |
</_nullIf> |
|
| 276 |
</longitude_deg> |
|
| 277 |
<verbatimlatitude>$verbatimLatitude</verbatimlatitude> |
|
| 278 |
<verbatimlongitude>$verbatimLongitude</verbatimlongitude> |
|
| 279 |
</coordinates> |
|
| 280 |
</coordinates_id> |
|
| 279 | 281 |
<continent>$continent</continent> |
| 280 | 282 |
<country>$country</country> |
| 281 | 283 |
<county>$county</county> |
| ... | ... | |
| 288 | 290 |
</path> |
| 289 | 291 |
</_simplifyPath> |
| 290 | 292 |
</VegBIEN> |
| 291 |
Inserted 36 new rows into database |
|
| 293 |
Inserted 34 new rows into database |
|
Also available in: Unified diff
mappings/VegCore-VegBIEN.csv: Remapped latitude/longitude to new coordinates table