[postgis-users] Collect overlapping polygon IDs
Andreas Forø Tollefsen
andreasft at gmail.com
Thu Sep 30 01:27:56 PDT 2010
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
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?
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users