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 *
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
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
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
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
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
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()