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_Intersects(A.geom,B.geom) ; I was expecting to get only the ids of table B that intersect the geometry of one row, but what this query returns seems to be a string of all ids the there entire two layers intersect. I don't understand why that is. How can I restrict the query above further so that I get back only the ids for each row (one geometry of table A at a time with the ids of intersecting polygons from table B) Cheers Karsten
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
