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

OSGeoLive trac_osgeolive at osgeo.org
Tue Jan 5 12:23:26 PST 2021


#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 astrid_emde):

 We only have to change the row:
 ​https://github.com/OSGeo/OSGeoLive/blob/master/bin/load_gisdata.sh#L201

 -g the_geom -> new: -g geom


 {{{
   shp2pgsql -W LATIN1 -s 4326 -I -g geom "$n" | \
      sudo -u $POSTGRES_USER psql --quiet natural_earth2
 }}}

-- 
Ticket URL: <https://trac.osgeo.org/osgeolive/ticket/2293#comment:4>
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.


More information about the osgeolive mailing list