[postgis-users] Collect overlapping polygon IDs

[Andreas Forø Tollefsen]

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/1bd12bff/attachment.html>