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 <[email protected]>: > >> 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 >>> [email protected] >>> http://lists.osgeo.org/mailman/listinfo/qgis-user >>> >> >> _______________________________________________ >> Qgis-user mailing list >> [email protected] >> http://lists.osgeo.org/mailman/listinfo/qgis-user >> > > > > _______________________________________________ > Qgis-user mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/qgis-user > _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
