On 9/19/2020 5:49 PM, karsten wrote:
Yes that works
thanks !
Would anyone have an explanation why the initial query below seems to
intersect the entire two layers and not
each records of table A with geometries of table B ?
Because A, B says intersect ALL records of A against ALL records of B.
Yes that works
thanks !
Would anyone have an explanation why the initial query below seems to
intersect the entire two layers and not
each records of table A with geometries of table B ?
Cheers
Karsten
-Original Message-
From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.o
On 9/19/2020 5:03 PM, karsten wrote:
Hi all,
I have two polygon geometry tables say A and B and trying to find the
ids from Table B
where their geometries intersect for each individual record in table
A. I have tried many things that did not work
and this was my starting point query:
Select ar
Hi all,
I have two polygon geometry tables say A and B and trying to find the ids
from Table B
where their geometries intersect for each individual record in table A. I
have tried many things that did not work
and this was my starting point query:
Select array_agg(B.id) from A ,B where ST_In
