[Qgis-user] Spatialite : problems with spatial views

[Alexandre Neto]

On Fri, Feb 22, 2013 at 12:07 PM, Samy Mezani <samy.mezani at wanadoo.fr>wrote:

> le 22/02/2013 11:57, Alexandre Neto a écrit:
>
>  There, I found out that, for correctly open a spatialite spatial view in
>> QGIS, I would need to have a column named ROWID.
>>
>
> Thanks Alexandre,
>
> My problems are partially resolved with your workaround :
>
> 1. The spatial index still blocks the load of geometry in QGis. I had to
> remove it before.
>
> 2. After adding a rowid, the attributes window show all the values of
> features but I have to wait 70s for 44 features and CPU used at 100%.
>

How long does your query takes to perform outside QGIS?


>
> 3. After adding a rowid, all labels are created.
>
> So Qspatialite should integrate a creation of a rowid to load correctly a
> spatial view in Qgis.
> DB Manager continue to not load the geometry even if a rowid is created.
>
> Thanks a lot.
>
>
> Samy
> ______________________________**_________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/**mailman/listinfo/qgis-user<http://lists.osgeo.org/mailman/listinfo/qgis-user>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20130222/c38b6eec/attachment.html>