If your query is very common, you might want to consider making a
database VIEW, so you can add the dynamic layer whenever you want. To
do this, just tailor your SELECT statement so it shows the right
columns, including geometry and a unique integer column (this can be
tricky).
For PostGIS, I'd su
Hi all
Thanks for your positive (and fast!) replies.
I'll be giving the RT Sql layer plugin a try and I'll also investigate
whether this functionality is available (using python scripting) with
spatialite layers.
Jurgen:
thanks for the SQL EXISTS tip. I have to brush up on my SQL ;)
Still I didn
Hi Carson,
On Thu, 30. Sep 2010 at 13:18:46 +0100, Carson Farmer wrote:
> http://www.carsonfarmer.com/?p=713
> and the RT Sql Layer plugin
> > 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)
Hi Ricardo,
On Thu, Sep 30, 2010 at 2:15 PM, Ricardo Filipe Soares Garcia da <
ricardo.garcia.si...@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
Have a look at this:
http://www.carsonfarmer.com/?p=713
and the RT Sql Layer plugin
Carson
On 30 September 2010 13:15, Ricardo Filipe Soares Garcia da
wrote:
> Hi list
> Some questions on building querys with spatialite and postgis:
>
> 1 - Is it possible to build a query where two (or more) l
Hi list
Some questions on building querys with spatialite and postgis:
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 s