[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 08:01:33 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 darkblueb):

 existing data files :
 {{{
 user at ol14b187:~/ne21$ tar xf all_10m_20.tgz
 user at ol14b187:~/ne21$ ls
 all_10m_20.tgz                              ne_10m_lakes/
 ne_10m_admin_0_countries/                   ne_10m_land/
 ne_10m_admin_1_states_provinces/            ne_10m_ocean/
 ne_10m_geography_marine_polys/
 ne_10m_populated_places_simple/
 ne_10m_geography_regions_elevation_points/
 ne_10m_rivers_lake_centerlines/
 ne_10m_geography_regions_points/            ne_10m_urban_areas/
 ne_10m_geography_regions_polys/
 user at ol14b187:~/ne21$ ls -lh *
 -rw-rw-r-- 1 user user  47M Nov 26  2012 all_10m_20.tgz

 ne_10m_admin_0_countries:
 total 11M
 -rw-rw-r-- 1 user user 2.4M Nov 25  2012 ne_10m_admin_0_countries.dbf
 -rw-rw-r-- 1 user user  145 Nov 25  2012 ne_10m_admin_0_countries.prj
 -rw-r--r-- 1 user user  30K Nov 25  2012
 ne_10m_admin_0_countries.README.html
 -rw-rw-r-- 1 user user 8.4M Nov 25  2012 ne_10m_admin_0_countries.shp
 -rw-rw-r-- 1 user user 2.1K Nov 25  2012 ne_10m_admin_0_countries.shx
 -rw-r--r-- 1 user user    5 Nov 25  2012
 ne_10m_admin_0_countries.VERSION.txt

 ne_10m_admin_1_states_provinces:
 total 28M
 -rwxr-xr-x 1 user user 7.6M Nov 25  2012
 ne_10m_admin_1_states_provinces_shp.dbf*
 -rwxr-xr-x 1 user user  145 Nov 25  2012
 ne_10m_admin_1_states_provinces_shp.prj*
 -rw-r--r-- 1 user user  37K Nov 25  2012
 ne_10m_admin_1_states_provinces_shp.README.html
 -rwxr-xr-x 1 user user  20M Nov 25  2012
 ne_10m_admin_1_states_provinces_shp.shp*
 -rwxr-xr-x 1 user user  29K Nov 25  2012
 ne_10m_admin_1_states_provinces_shp.shx*
 -rw-r--r-- 1 user user    5 Nov 25  2012
 ne_10m_admin_1_states_provinces_shp.VERSION.txt

 ne_10m_geography_marine_polys:
 total 1.4M
 -rw-rw-r-- 1 user user 262K Nov 25  2012 ne_10m_geography_marine_polys.dbf
 -rw-r--r-- 1 user user  147 Nov 25  2012 ne_10m_geography_marine_polys.prj
 -rw-r--r-- 1 user user  32K Nov 25  2012
 ne_10m_geography_marine_polys.README.html
 -rw-rw-r-- 1 user user 1.1M Nov 25  2012 ne_10m_geography_marine_polys.shp
 -rw-rw-r-- 1 user user 2.6K Nov 25  2012 ne_10m_geography_marine_polys.shx
 -rw-r--r-- 1 user user    5 Nov 25  2012
 ne_10m_geography_marine_polys.VERSION.txt

 ne_10m_geography_regions_elevation_points:
 total 672K
 -rw-r--r-- 1 user user 602K Nov 25  2012
 ne_10m_geography_regions_elevation_points.dbf
 -rw-r--r-- 1 user user  143 Nov 25  2012
 ne_10m_geography_regions_elevation_points.prj
 -rw-r--r-- 1 user user  32K Nov 25  2012
 ne_10m_geography_regions_elevation_points.README.html
 -rw-rw-r-- 1 user user  20K Nov 25  2012
 ne_10m_geography_regions_elevation_points.shp
 -rw-rw-r-- 1 user user 5.7K Nov 25  2012
 ne_10m_geography_regions_elevation_points.shx
 -rw-r--r-- 1 user user    5 Nov 25  2012
 ne_10m_geography_regions_elevation_points.VERSION.txt

 ne_10m_geography_regions_points:
 total 224K
 -rw-r--r-- 1 user user 170K Nov 25  2012
 ne_10m_geography_regions_points.dbf
 -rw-r--r-- 1 user user  147 Nov 25  2012
 ne_10m_geography_regions_points.prj
 -rw-r--r-- 1 user user  32K Nov 25  2012
 ne_10m_geography_regions_points.README.html
 -rw-rw-r-- 1 user user 6.6K Nov 25  2012
 ne_10m_geography_regions_points.shp
 -rw-rw-r-- 1 user user 2.0K Nov 25  2012
 ne_10m_geography_regions_points.shx
 -rw-r--r-- 1 user user    5 Nov 25  2012
 ne_10m_geography_regions_points.VERSION.txt

 ne_10m_geography_regions_polys:
 total 3.4M
 -rw-rw-r-- 1 user user 677K Nov 25  2012
 ne_10m_geography_regions_polys.dbf
 -rw-r--r-- 1 user user  147 Nov 25  2012
 ne_10m_geography_regions_polys.prj
 -rw-r--r-- 1 user user  32K Nov 25  2012
 ne_10m_geography_regions_polys.README.html
 -rw-rw-r-- 1 user user 2.7M Nov 25  2012
 ne_10m_geography_regions_polys.shp
 -rw-rw-r-- 1 user user 8.4K Nov 25  2012
 ne_10m_geography_regions_polys.shx
 -rw-r--r-- 1 user user    5 Nov 25  2012
 ne_10m_geography_regions_polys.VERSION.txt

 ne_10m_lakes:
 total 3.7M
 -rw-r--r-- 1 user user 1.4M Nov 25  2012 ne_10m_lakes.dbf
 -rw-r--r-- 1 user user  147 Nov 25  2012 ne_10m_lakes.prj
 -rw-r--r-- 1 user user  37K Nov 25  2012 ne_10m_lakes.README.html
 -rw-r--r-- 1 user user 2.2M Nov 25  2012 ne_10m_lakes.shp
 -rw-r--r-- 1 user user  11K Nov 25  2012 ne_10m_lakes.shx
 -rw-r--r-- 1 user user    5 Nov 25  2012 ne_10m_lakes.VERSION.txt

 ne_10m_land:
 total 6.4M
 -rw-r--r-- 1 user user  134 Nov 25  2012 ne_10m_land.dbf
 -rw-r--r-- 1 user user  147 Nov 25  2012 ne_10m_land.prj
 -rw-r--r-- 1 user user  28K Nov 25  2012 ne_10m_land.README.html
 -rw-r--r-- 1 user user 6.3M Nov 25  2012 ne_10m_land.shp
 -rw-r--r-- 1 user user  108 Nov 25  2012 ne_10m_land.shx
 -rw-r--r-- 1 user user    5 Nov 25  2012 ne_10m_land.VERSION.txt

 ne_10m_ocean:
 total 6.4M
 -rw-r--r-- 1 user user  134 Nov 25  2012 ne_10m_ocean.dbf
 -rw-r--r-- 1 user user  147 Nov 25  2012 ne_10m_ocean.prj
 -rw-r--r-- 1 user user  28K Nov 25  2012 ne_10m_ocean.README.html
 -rw-rw-r-- 1 user user 6.3M Nov 25  2012 ne_10m_ocean.shp
 -rw-rw-r-- 1 user user  108 Nov 25  2012 ne_10m_ocean.shx
 -rw-r--r-- 1 user user    5 Nov 25  2012 ne_10m_ocean.VERSION.txt

 ne_10m_populated_places_simple:
 total 30M
 -rw-r--r-- 1 user user  29M Nov 25  2012 ne_10m_populated_places.dbf
 -rw-r--r-- 1 user user  147 Nov 25  2012 ne_10m_populated_places.prj
 -rw-r--r-- 1 user user  32K Nov 25  2012
 ne_10m_populated_places.README.html
 -rw-r--r-- 1 user user 201K Nov 25  2012 ne_10m_populated_places.shp
 -rw-r--r-- 1 user user  58K Nov 25  2012 ne_10m_populated_places.shx
 -rw-r--r-- 1 user user    5 Nov 25  2012
 ne_10m_populated_places.VERSION.txt

 ne_10m_rivers_lake_centerlines:
 total 8.9M
 -rw-r--r-- 1 user user 1.4M Nov 25  2012 ne_10m_lakes.dbf
 -rw-r--r-- 1 user user  147 Nov 25  2012 ne_10m_lakes.prj
 -rw-r--r-- 1 user user  37K Nov 25  2012 ne_10m_lakes.README.html
 -rw-r--r-- 1 user user 2.2M Nov 25  2012 ne_10m_lakes.shp
 -rw-r--r-- 1 user user  11K Nov 25  2012 ne_10m_lakes.shx
 -rw-r--r-- 1 user user    5 Nov 25  2012 ne_10m_lakes.VERSION.txt
 -rw-rw-r-- 1 user user 1.2M Nov 25  2012
 ne_10m_rivers_lake_centerlines.dbf
 -rw-r--r-- 1 user user  147 Nov 25  2012
 ne_10m_rivers_lake_centerlines.prj
 -rw-r--r-- 1 user user  38K Nov 25  2012
 ne_10m_rivers_lake_centerlines.README.html
 -rw-rw-r-- 1 user user 4.0M Nov 25  2012
 ne_10m_rivers_lake_centerlines.shp
 -rw-rw-r-- 1 user user  12K Nov 25  2012
 ne_10m_rivers_lake_centerlines.shx
 -rw-r--r-- 1 user user    5 Nov 25  2012
 ne_10m_rivers_lake_centerlines.VERSION.txt

 ne_10m_urban_areas:
 total 20M
 -rw-rw-r-- 1 user user 859K Nov 25  2012 ne_10m_urban_areas.dbf
 -rw-r--r-- 1 user user  147 Nov 25  2012 ne_10m_urban_areas.prj
 -rw-r--r-- 1 user user  29K Nov 25  2012 ne_10m_urban_areas.README.html
 -rw-rw-r-- 1 user user  19M Nov 25  2012 ne_10m_urban_areas.shp
 -rw-rw-r-- 1 user user  93K Nov 25  2012 ne_10m_urban_areas.shx
 -rw-r--r-- 1 user user    5 Nov 25  2012 ne_10m_urban_areas.VERSION.txt

 }}}

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