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


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

Reply via email to