Much thanks to you and Dan again - this ogr statement keeps growing in
complexity and I completely forgot about the nlt option.
Thanks!
Randy
On 3/14/19 11:16 AM, Even Rouault wrote:
On jeudi 14 mars 2019 11:11:42 CET Randal Hale wrote:
If I export a postgis table to geopackage:
ogr2ogr -f GPKG export.gpkg PG:"host=gis1 user=rjhale dbname=dbname
password=pass" -nln "addresspoints" -sql "select id, geom, addresses"
I check the geopackage:
rjhale@gis7:~/temp$ ogrinfo -so -al TCStransport.gpkg
INFO: Open of `TCStransport.gpkg'
using driver `GPKG' successful.
Layer name: addresspoints
*Geometry: Unknown (any)*
Feature Count: 23735
Any idea on what I'm doing wrong - the unknown geometry seems to be
causing an issue in another process. If I export without the SQL
statement everything is fine.
Randy,
You aren't doing something wrong. This is just that the PostGIS driver cannot
retrieve the layer geometry type if using a SQL statement (could perhaps be
improved in simple situations where selecting from a single table without join
or transformation on the geometry). You can force the output layer geometry
type by adding -nlt POINT|LINESTRING|POLYGON|etc.
See doc of -nlt in https://gdal.org/ogr2ogr.html
Even
--
--
Randal Hale
[email protected]
https://www.northrivergeographic.com
(423)653-3611
_______________________________________________
gdal-dev mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/gdal-dev
