Pepijn Van Eeckhoudt vaneeckhoudt.net> writes:
>
> Apolgies up-front for the self promotion...
>
> Jukka,
>
> If you need a basic geopackage enabled sqlite shell, you can compile
> https://bitbucket.org/luciad/libgpkg to get this. One of the outputs is
> the 'gpkg' binary which is the sqlite
eräinen viesti-
Lähettäjä: Even Rouault [mailto:even.roua...@mines-paris.org]
Lähetetty: 18. helmikuuta 2014 11:07
Vastaanottaja: Rahkonen Jukka (Tike)
Kopio: 'gdal-dev@lists.osgeo.org'
Aihe: Re: [gdal-dev] GeoPackage fails after touching it with Spatialite-gui
Hi Jukka,
yes, this is t
Selon "Rahkonen Jukka (Tike)" :
> Hi,
>
> Creating indexes with sqlite3 feels safe. Renaming table is unsafe and leads
> to ogrinfo crash.
>
> sqlite> alter table test rename to test2;
>
> C:ohjelmatsqlite3>ogrinfo kuti.gpkg
> ERROR 1: (null)
> INFO: Open of `kuti.gpkg'
> using driver `GPKG
'gdal-dev@lists.osgeo.org'
> Aihe: Re: [gdal-dev] GeoPackage fails after touching it with Spatialite-gui
>
> Hi Jukka,
>
> yes, this is the same issue. -dialect sqlite is quite powerfull, but can only
> handle
> SELECT / UPDATE / DELETE, no other fancy stuff. T
Hi Jukka,
yes, this is the same issue. -dialect sqlite is quite powerfull, but can only
handle SELECT / UPDATE / DELETE, no other fancy stuff. The GPKG driver should
just have its ExecuteSQL() implementation.
Currently I guess you could open a .gpkg with the sqlite3 binary. I wouldn't
expect it to
Hi,
Is this the same issue about how GPKG is handling ExecuteSQL()? If it is, then
I will make a ticket because a database without indexes is missing a lot. Or is
there some other way how I could create index into GPKG with GDAL? Alessandro
Furieri told already that using spatialite-gui/tools f
On Mon, 17 Feb 2014 16:14:39 +0100, Even Rouault wrote:
Jukka,
I highly suspect that the ALTER TABLE must imply a rewriting of the
file by
spatialite/spatialite-gui, and when doing so, it doesn't preserve the
"application id" (4 bytes in the header of sqlite file), that
geopackage
specificati
Selon Jukka Rahkonen :
> Even Rouault mines-paris.org> writes:
>
> >
> > Jukka,
> >
> > I highly suspect that the ALTER TABLE must imply a rewriting of the file by
> > spatialite/spatialite-gui, and when doing so, it doesn't preserve the
> > "application id" (4 bytes in the header of sqlite file)
Even Rouault mines-paris.org> writes:
>
> Jukka,
>
> I highly suspect that the ALTER TABLE must imply a rewriting of the file by
> spatialite/spatialite-gui, and when doing so, it doesn't preserve the
> "application id" (4 bytes in the header of sqlite file), that geopackage
> specification men
Jukka,
I highly suspect that the ALTER TABLE must imply a rewriting of the file by
spatialite/spatialite-gui, and when doing so, it doesn't preserve the
"application id" (4 bytes in the header of sqlite file), that geopackage
specification mentions to be set to a particular value. Consequently the
Hi,
There are no GUI-tools for managing GeoPackage databases at the moment and
because after all they are only SQLite db files just like Spatialite files I
thought it would be a good idea to do some maintenance work for GPKG
database with Spatialite-gui.
I could do a few things with Spatialite-gu
11 matches
Mail list logo
