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>
>>
>
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
