[Qgis-user] Spatialite VIEW in QGIS question

[Alex Mandel]

Maybe I'm unclear on the issue. If it's just how to get a view with
geometry to show up, I've found you often have register view with
spatialite metadata:

INSERT INTO views_geometry_columns
(view_name, view_geometry, view_rowid, f_table_name, f_geometry_column)
VALUES (theview, thegeometry, view_rowid, tablenamethegeomcomesfrom,
the_geometry_column);


Thanks,
Alex

On 02/19/2014 11:02 AM, Olivier Dalang wrote:
> Dear Bernd,
> 
> I encountered some similar problems with Spatialite views, but in the end I
> had it working (sometimes) both in 2.0 and in master... I used the manual
> method from the spatialite cookbook though (not the Spatialite GUI).
> 
> I have no time to test now, but from what I recall, this does not work :
> CREATE VIEW AS SELECT name, geometry FROM table
> while this works :
> CREATE VIEW AS SELECT ROWID, name, geometry FROM table
> 
> Maybe you want to give it a last try. I can testify I have some working
> spatialite views here. Let us know if this works, if not I may give it a
> better look when I have some time.
> 
> Another method is running a SELECT query in the DB Manager in QGIS, and
> then choosing "Add to map canvas". This is not an actual sqlite view, but
> depending on what you need, it could be enough.
> 
> Good luck !
> 
> Olivier
> 
> 
> 
> 
> 
> 2014-02-19 19:54 GMT+01:00 Bernd Vogelgesang <bernd.vogelgesang at gmx.de>:
> 
>> Am 19.02.2014 19:14, schrieb Steve G:
>>
>>  This does not directly answer your question about spatialite views, but
>>> you
>>> might be able to use relationships directly in QGIS in the near future (I
>>> think this is a 2.1 update).  See:
>>>
>>> http://blog.vitu.ch/10112013-1201/qgis-relations
>>>
>>>
>>> -Steve
>>>
>>
>> Hi Steve,
>> Actually I do not care by which means I reach my destination, but I had
>> the, maybe wrong; impression that using a spatial database would do the
>> trick.
>> Anyway ...
>> I already installed latest master cause I read about this relation manager
>> thing a while ago ... but I was left quite clueless about how to use it.
>> Searched the web for nearly an hour about any info but to no avail, so
>> many thanks for sharing the link!!
>>
>> Will have a look at it ASAP, maybe thats kind of a solution.
>>
>> Cheers
>> Bernd
>>
>>
>>
>>  --
>>> View this message in context: http://osgeo-org.1560.x6.
>>> nabble.com/Spatialite-VIEW-in-QGIS-question-tp5104565p5104775.html
>>> Sent from the Quantum GIS - User mailing list archive at Nabble.com.
>>> _______________________________________________
>>> Qgis-user mailing list
>>> Qgis-user at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>>
>>
>> _______________________________________________
>> Qgis-user mailing list
>> Qgis-user at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>
> 
> 
> 
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>