#2293: natural_earth2 database import: change geometry column name to geom
instead
of the_geom
-------------------------+--------------------------
Reporter: astrid_emde | Owner: osgeolive@…
Type: task | Status: new
Priority: normal | Milestone:
Component: OSGeoLive | Resolution:
Keywords: |
-------------------------+--------------------------
Comment (by darkblueb):
passing attempt at new data:
{{{
$pg_dump natural_earth2 | sed -e 's/the_geom/geom/g' > ne2_geom.sql
$createdb natural_earth21
$psql natural_earth21 -c 'create extension postgis'
$psql -f ne2_geom.sql natural_earth21
$pg_dump -Fc natural_earth21 > ne21.dump ## restore will generate non-
fatal errors
$pg_dump natural_earth21 -t ne_10m_admin_0_countries -t \
ne_10m_admin_1_states_provinces_shp -t ne_10m_geography_marine_polys -t
\
ne_10m_geography_regions_elevation_points -t
ne_10m_geography_regions_points -t \
ne_10m_geography_regions_polys -t ne_10m_lakes -t ne_10m_land -t
ne_10m_ocean -t \
ne_10m_populated_places -t ne_10m_rivers_lake_centerlines -t
ne_10m_urban_areas >
ne21_tables.sql
$bzip2 ne21_tables.sql
}}}
--
Ticket URL: <https://trac.osgeo.org/osgeolive/ticket/2293#comment:2>
OSGeoLive <https://live.osgeo.org/>
self-contained bootable DVD, USB thumb drive or Virtual Machine based on
Lubuntu, that allows you to try a wide variety of open source geospatial
software without installing anything.
_______________________________________________
osgeolive mailing list
osgeolive@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/osgeolive
