[postgis-users] Collect overlapping polygon IDs

[Nicklas Avén]

Something like this should work:  
SELECT count(*) as number_of_conflicts, array_agg(b.id) as id_of_conflicts FROM conflict_zoones a , vector_grid b WHERE ST_Intersects(a.the_geom, b.the_geom) GROUP BY b.id; array_agg will give you an array looking something like:{13, 23, 54}   HTHNicklas 

2010-09-30 Andreas Forø Tollefsen wrote:

Hi all,>

>>
I have a table of circular polygons which represents conflict zones within countries and a global vector grid with 0.5 x 0.5 decimal degree grid cells (square polygons).>

>>
What i need to figure out is for each 0.5 x 0.5 grid cell, how many of these conflict zones intersect, and the ID of each of them.>
Preferably the result should be a column with the number of intersecting circular conflict polygons, and a column with the id of all of them separated by a comma.>

>>
I cannot get my head around how to structure this?>

>>
Any ideas?>

>>
Andreas>

>>

>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100930/49463dad/attachment.html>