Re: [gdal-dev] SQLite dialect with GeoPackage

2014-10-06 Thread Even Rouault
Le lundi 06 octobre 2014 21:13:04, Stefan Ziegler a écrit : > Ah, still one - hopefully last - question: how can I overwrite a layer in > the gpkg? > > stefan@hatschepsut:~/Downloads$ ogr2ogr -append -f GPKG 2601.gpkg -nln > my_new_layer -lco OVERWRITE=YES -dialect INDIRECT_SQLITE -sql 'SELECT *

Re: [gdal-dev] SQLite dialect with GeoPackage

2014-10-06 Thread Stefan Ziegler
Ah, still one - hopefully last - question: how can I overwrite a layer in the gpkg? stefan@hatschepsut:~/Downloads$ ogr2ogr -append -f GPKG 2601.gpkg -nln my_new_layer -lco OVERWRITE=YES -dialect INDIRECT_SQLITE -sql 'SELECT * FROM bodenbedeckung__bbtext WHERE tid IN (SELECT tid FROM bodenbedeck

Re: [gdal-dev] SQLite dialect with GeoPackage

2014-10-06 Thread Stefan Ziegler
This is awesome! Thanks Even. Stefan On Mon, Oct 6, 2014 at 8:55 PM, Even Rouault wrote: > Le lundi 06 octobre 2014 20:48:02, Stefan Ziegler a écrit : > > Hi Even > > > > thanks! INDIRECT_SQLITE works like a charm. I could not figure out the > > syntax to create a new layer in the very same gpk

Re: [gdal-dev] SQLite dialect with GeoPackage

2014-10-06 Thread Even Rouault
Le lundi 06 octobre 2014 20:48:02, Stefan Ziegler a écrit : > Hi Even > > thanks! INDIRECT_SQLITE works like a charm. I could not figure out the > syntax to create a new layer in the very same gpkg file: > > stefan@hatschepsut:~/Downloads$ ogr2ogr -append -f GPKG 2601.gpkg -nln > my_new_layer -di

Re: [gdal-dev] SQLite dialect with GeoPackage

2014-10-06 Thread Stefan Ziegler
Hi Even thanks! INDIRECT_SQLITE works like a charm. I could not figure out the syntax to create a new layer in the very same gpkg file: stefan@hatschepsut:~/Downloads$ ogr2ogr -append -f GPKG 2601.gpkg -nln my_new_layer -dialect INDIRECT_SQLITE -sql 'SELECT * FROM bodenbedeckung__bbtext WHERE tid

Re: [gdal-dev] SQLite dialect with GeoPackage

2014-10-06 Thread Even Rouault
Le lundi 06 octobre 2014 19:41:43, Stefan Ziegler a écrit : > Hi > > When trying to use SQLite dialect with GeoPackage I get some errors, like: > > stefan@hatschepsut:~/Downloads$ ogrinfo -al -sql 'SELECT > ST_X(ST_SnapToGrid(geom,1)) FROM bodenbedeckung__bbtext LIMIT 1' > 2601.gpkgINFO: Open of

[gdal-dev] SQLite dialect with GeoPackage

2014-10-06 Thread Stefan Ziegler
Hi When trying to use SQLite dialect with GeoPackage I get some errors, like: stefan@hatschepsut:~/Downloads$ ogrinfo -al -sql 'SELECT ST_X(ST_SnapToGrid(geom,1)) FROM bodenbedeckung__bbtext LIMIT 1' 2601.gpkgINFO: Open of `2601.gpkg' using driver `GPKG' successful. ERROR 1: In ExecuteSQL()