[OSGeoLive] #2293: natural_earth2 database import: change geometry column name to geom instead of the_geom

[OSGeoLive]

#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.