[Qgis-developer] Geospackage Slow in QGIS

[Andrea Peri]

Hi Stefan,

More information to explain better:

The code is available in qgis.
But don't work.

I try it using a spatialite 4.2.0 created with spatialite-gui.
And having a table with two geometry fields.
One of type Polygon and another of type Point (the centroids of the
polygons geometries).

Using the OGR provider it see both the geometry, but when load them
the point layer don't work.

My point is just to say that actually the only stable solution to
access to a spatialite db is using the spatialite provider.

A.


2014-08-18 20:20 GMT+02:00 Stefan Keller <sfkeller at gmail.com>:
> Hi Andrea
>
>> 2014-08-18 16:52 GMT+02:00 Andrea Peri <aperi2007 at gmail.com>:
>>> ...
>>> Infact I discovered just now that gdal driver for spatialite don't
>>> seem to support tables with more than 1 geometrt field.
>>> Almost on QGIS.
>
> I'm almost certain that there's code - or at least knowhow - available
> for GDAL to add support for more than one table also for Spatialite.
> @Pirmin: What do you think?
>
> -S.
>
>
> 2014-08-18 16:56 GMT+02:00 Andrea Peri <aperi2007 at gmail.com>:
>> Just to explain why this is an important question.
>>
>> On a sqlite db is impossible to remove a field.
>> So if a table is with two geometry field, it is never see-able from qgis.
>> Because is not possible a command like:
>>
>> alter table remove filed geometry-2;
>>
>> Bye,
>>
>> Andrea Peri.
>>
>>
>> 2014-08-18 16:52 GMT+02:00 Andrea Peri <aperi2007 at gmail.com>:
>>> Hi,
>>>
>>> I have changed my opinin.
>>> From +1 to +0
>>>
>>> Infact I discovered just now that gdal driver for spatialite don't
>>> seem to support tables with more than 1 geometrt field.
>>> Almost on QGIS.
>>>
>>> Andrea
>>>
>>>
>>> 2014-05-17 22:19 GMT+02:00 Jeremy Palmer <JPalmer at linz.govt.nz>:
>>>> I'm wondered why QGIS needs a native SpatiaLite provider and connection dialogue any 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 not just use GDAL/OGR for both Geopackage and Spatialite?
>>>>
>>>> Cheers
>>>> Jeremy
>>>> ________________________________________
>>>> From: Stefan Keller [sfkeller at gmail.com]
>>>> Sent: Sunday, 18 May 2014 12:24 a.m.
>>>> To: Martin Dobias
>>>> Cc: Jeremy Palmer; qgis-developer at 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 <wonder.sk at gmail.com<mailto:wonder.sk at gmail.com>>:
>>>> Hi
>>>>
>>>> On Sat, May 17, 2014 at 2:32 PM, Jeremy Palmer <JPalmer at linz.govt.nz<mailto:JPalmer at linz.govt.nz>> 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 renders a new map view or executes a feature info it re-opens the Geopackage file in QgsOgrFeatureIterator via OGROpen, and the Geopackage driver open method runs PRAGMA integrity_check which is very slow (4 secs with my 2GB test file). This integrity check is actually a Geopackage requirement.
>>>>>
>>>>> How can this be fixed? At the in QGIS or GDAL/OGR level?
>>>>
>>>> Actually I am wondering how different is the format of GeoPackage from
>>>> the format of SpatiaLite... we could use our native SpatiaLite
>>>> provider also for GeoPackage files if they are close enough. Any
>>>> ideas?
>>>>
>>>> Regards
>>>> Martin
>>>> _______________________________________________
>>>> Qgis-developer mailing list
>>>> Qgis-developer at lists.osgeo.org<mailto:Qgis-developer at lists.osgeo.org>
>>>> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>>>>
>>>> This message contains information, which may be in confidence and may be subject to legal privilege. If you are not the intended recipient, you must not peruse, use, disseminate, distribute or copy this message. If you have received this message in error, please notify us immediately (Phone 0800 665 463 or info at linz.govt.nz) and destroy the original message. LINZ accepts no responsibility for changes to this email, or for any attachments, after its transmission from LINZ. Thank You.
>>>> _______________________________________________
>>>> Qgis-developer mailing list
>>>> Qgis-developer at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>>>
>>>
>>>
>>> --
>>> -----------------
>>> Andrea Peri
>>> . . . . . . . . .
>>> qwerty àèìòù
>>> -----------------
>>
>>
>>
>> --
>> -----------------
>> Andrea Peri
>> . . . . . . . . .
>> qwerty àèìòù
>> -----------------



-- 
-----------------
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-----------------