[mailto:postgis-users-boun...@lists.osgeo.org] On Behalf
Of Stephen Woodbridge
Sent: Saturday, September 19, 2020 14:39
To: postgis-users@lists.osgeo.org
Subject: Re: [postgis-users] intersect two tables one row at a time
On 9/19/2020 5:03 PM, karsten wrote:
Hi all,
I have two polygon geometry tables
...@lists.osgeo.org] On Behalf
Of Stephen Woodbridge
Sent: Saturday, September 19, 2020 14:39
To: postgis-users@lists.osgeo.org
Subject: Re: [postgis-users] intersect two tables one row at a time
On 9/19/2020 5:03 PM, karsten wrote:
> Hi all,
> I have two polygon geometry tables say A and B and trying to fi
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
