Why not just use GDAL/OGR for both Geopackage and Spatialite?
Cheers
Jeremy
From: Stefan Keller [sfkel...@gmail.com]
Sent: Sunday, 18 May 2014 12:24 a.m.
To: Martin Dobias
Cc: Jeremy Palmer; qgis-developer@lists.osgeo.org
Subject: Re: [Qgis-developer
ta. Why not just use GDAL/OGR for both
Geopackage and Spatialite?
Cheers
Jeremy
From: Stefan Keller [sfkel...@gmail.com]
Sent: Sunday, 18 May 2014 12:24 a.m.
To: Martin Dobias
Cc: Jeremy Palmer; qgis-developer@lists.osgeo.org
Subject: Re: [Qgis-developer]
y more. Unlike other database providers such as PostGIS,
>>>> Oracle, MSSQL the SpatiaLite provider doesn't seem to have anything
>>>> special that requires a QGIS provider. From a users perspective it just
>>>> adds to the confusion and complexity for adding data. Why n
t; requires a QGIS provider. From a users perspective it just adds to the
>>> confusion and complexity for adding data. Why not just use GDAL/OGR for
>>> both Geopackage and Spatialite?
>>>
>>> Cheers
>>> Jeremy
>>> ___
efan Keller [sfkel...@gmail.com]
>> Sent: Sunday, 18 May 2014 12:24 a.m.
>> To: Martin Dobias
>> Cc: Jeremy Palmer; qgis-developer@lists.osgeo.org
>> Subject: Re: [Qgis-developer] Geospackage Slow in QGIS
>>
>> Hi Martin
>>
>> It has a different b
-developer@lists.osgeo.org
> Subject: Re: [Qgis-developer] Geospackage Slow in QGIS
>
> Hi Martin
>
> It has a different binary encoding compared to Spatialite.
> And in addition it integrates raster tiles (MBTiles) and metadata.
>
> -S.
>
>
> 2014-05-17 14:10 GMT+
Hi all,
just a cumulative reply to this thread:
Le samedi 17 mai 2014 10:46:39, Stefan Keller a écrit :
Looks strange to me why a single file check woold be the bottlenet
since
this should be a single call.
I would have expected that some repeated calls (like reading
objects/records and chec
+1
___
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-developer
-developer@lists.osgeo.org
Subject: Re: [Qgis-developer] Geospackage Slow in QGIS
Hi Martin
It has a different binary encoding compared to Spatialite.
And in addition it integrates raster tiles (MBTiles) and metadata.
-S.
2014-05-17 14:10 GMT+02:00 Martin Dobias
mailto:wonder...@gmail.com>>:
Hi
48 p.m.
To: qgis-developer@lists.osgeo.org
Cc: Stefan Keller; Jeremy Palmer
Subject: Re: [Qgis-developer] Geospackage Slow in QGIS
Le samedi 17 mai 2014 10:46:39, Stefan Keller a écrit :
> So it's this code fragment?
> 419 /* Requirement 6: The SQLite PRAGMA integrity_check SQL command
2014-05-17 16:04 GMT+02:00 Andrea Peri :
> Hi Giovanni.
>
> You have point an interesting question.
> The question is:
>
> geopackage and spatialite will be binary compatible (almost in the blob
> where there are store the geometry) ?
> I guess no because I don't realize how a geopackage spec coul
Hi Giovanni.
You have point an interesting question.
The question is:
geopackage and spatialite will be binary compatible (almost in the blob
where there are store the geometry) ?
I guess no because I don't realize how a geopackage spec could support some
different binary formats.
If this is tru
>
> The spatialite will never to be a real interchange format if the only
> software to use it is qgis and the same qgis is not real compatible with
> the original spatialite spec.
>
> So the spatialite actually is a really good and strong work format .
>
> Instead surely geopackage are no one stro
Hi Martin
It has a different binary encoding compared to Spatialite.
And in addition it integrates raster tiles (MBTiles) and metadata.
-S.
2014-05-17 14:10 GMT+02:00 Martin Dobias :
> Hi
>
> On Sat, May 17, 2014 at 2:32 PM, Jeremy Palmer
> wrote:
> > I've just been using the new implementati
Ciao A.
You wrote:
> Instead surely geopackage are no one strong point in elaboration so I'm
not surprise that it is slow.
The bottleneck has been identified and Even resolved it.
As Jeremy reported it was the PRAGMA integrity_check which checked the
whole file(!) when opening.
Now it remains to
Hi
On Sat, May 17, 2014 at 2:32 PM, Jeremy Palmer wrote:
> I've just been using the new implementation of Geopackage in QGIS :) However
> each map render or feature info is very slow for large database files - even
> with the new GDAL/OGR Geopackage spatial index support. Each time QGIS
> rend
I have really difficulty to write of a so complex question in english.
:(
However try to explain.
The shapefile is absolutely a bad solution for interchange usage.
We experiment every day troubles. Sometimes the troubles was discovered
after many time.
The shapefile born as a simply format for
Le samedi 17 mai 2014 10:46:39, Stefan Keller a écrit :
> So it's this code fragment?
> 419 /* Requirement 6: The SQLite PRAGMA integrity_check SQL command
> SHALL return â??okâ? */
> 420/* http://opengis.github.io/geopackage/#_file_integrity */
> 421if( strncmp(pszFilename, "/vsicurl/
OT: there was already a nice, and very well supporyed, spatial Sqlite
extension before this Geopackage lobby made its way in OGC... What a pity.
giovanni
Il 17/mag/2014 11:24 "Paolo Cavallini" ha scritto:
> Il 17/05/2014 11:03, Andrea Peri ha scritto:
> > Do you know the requirements of gpkg ?
>
Il 17/05/2014 11:03, Andrea Peri ha scritto:
> Do you know the requirements of gpkg ?
They should be really minimal.
This could help understanding speed issues:
http://openjump.blogspot.fi/2014/02/openjump-plus-reads-ogc-geopackages.html
All the best.
--
Paolo Cavallini - www.faunalia.eu
Corsi QG
Do you know the requirements of gpkg ?
Il 17/mag/2014 10:46 "Paolo Cavallini" ha scritto:
> Il 17/05/2014 10:04, Andrea Peri ha scritto:
> > More probably there is some optimal adjust chance, but the geopackage
> format is for
> > exchange data. It is sub optimal for work daily.
>
> Hi Andrea,
>
Hi Jeremy
Is this PRAGMA integrity_check really the bottle neck?
Is it an integrity check on a data type (e.g. integer - its probably
actually an integrity check on SRID)?
Can you point to the code?
Yours, Stefan
2014-05-17 9:32 GMT+02:00 Jeremy Palmer :
> I've just been using the new impleme
Il 17/05/2014 10:04, Andrea Peri ha scritto:
> More probably there is some optimal adjust chance, but the geopackage format
> is for
> exchange data. It is sub optimal for work daily.
Hi Andrea,
gpkg seems to aim at a complete replacement of shp:
http://www.geopackage.org/
not only for data trans
..@gmail.com]
> Sent: Saturday, 17 May 2014 8:20 p.m.
> To: Jeremy Palmer
> Cc: qgis-developer@lists.osgeo.org
> Subject: Re: [Qgis-developer] Geospackage Slow in QGIS
>
> Hi Jeremy
>
> Is this PRAGMA integrity_check really the bottle neck?
> Is it an integrity check on a d
il.com]
Sent: Saturday, 17 May 2014 8:20 p.m.
To: Jeremy Palmer
Cc: qgis-developer@lists.osgeo.org
Subject: Re: [Qgis-developer] Geospackage Slow in QGIS
Hi Jeremy
Is this PRAGMA integrity_check really the bottle neck?
Is it an integrity check on a data type (e.g. integer - its probably actual
More probably there is some optimal adjust chance, but the geopackage
format is for exchange data. It is sub optimal for work daily.
Il 17/mag/2014 09:40 "Jeremy Palmer" ha scritto:
> I've just been using the new implementation of Geopackage in QGIS :)
> However each map render or feature info i
I've just been using the new implementation of Geopackage in QGIS :) However
each map render or feature info is very slow for large database files - even
with the new GDAL/OGR Geopackage spatial index support. Each time QGIS renders
a new map view or executes a feature info it re-opens the Geopa
27 matches
Mail list logo
