[Qgis-user] spatialite (and postgis) queries

[Giuseppe Sucameli]

Hi Ricardo,

On Thu, Sep 30, 2010 at 2:15 PM, Ricardo Filipe Soares Garcia da <
ricardo.garcia.silva at gmail.com> wrote:

> Some questions on building querys with spatialite and postgis:


You can use the RT Sql Layer plugin, but for postgis layers only.
In this moment there is no way to do the same thing with spatialite layers.

Cheers.


>
> 1 - Is it possible to build a query where two (or more) layers are
> involved? Something like:
>
> SELECT a.*
> FROM a, b
> WHERE Contains(b, a)
>
> and get a visual result in the main Qgis display? I know I can do such
> a query using the spatialite manager, but the return value is
> visualized only as tabular data.
>
> 2 - Is it possible to dynamically create new geometries? For example,
> write a custom query that creates a buffer around a point and store it
> in a temporary layer?
>
> >From what I have been investigating it seems that these things are not
> possible. Am I wrong? This kind of functionality would be really
> awesome.
>
> --
> ___________________________ ___ __
> Ricardo Garcia Silva
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>



-- 
Giuseppe Sucameli
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20100930/f4bc7ede/attachment.html>