Re: [gdal-dev] Export to Geopackage

2019-03-14 Thread Randal Hale
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

Re: [gdal-dev] Export to Geopackage

2019-03-14 Thread Even Rouault
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$

Re: [gdal-dev] Export to Geopackage

2019-03-14 Thread Dan Little
Set `-nlt` ? On Thu, Mar 14, 2019 at 10:12 AM Dan Little wrote: > > Set `-nlt` ? > > On Thu, Mar 14, 2019 at 10:12 AM 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 "ad

[gdal-dev] Export to Geopackage

2019-03-14 Thread Randal Hale
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.gpk