<html>
<head>
<title></title>
<meta name="GENERATOR" content="MSHTML 8.00.6001.18939"></meta>
</head>
<body>Something like this should work:
<div align="left"> </div>
<div align="left"> </div>
<div align="left"><br />
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;</div>
<div align="left"> </div>
<div align="left">array_agg will give you an array looking something like:</div>
<div align="left">{13, 23, 54}</div>
<div align="left"> </div>
<div align="left"> </div>
<div align="left"> </div>
<div align="left">HTH</div>
<div align="left">Nicklas</div>
<div align="left"> </div>
<div align="left"><br />
<br />
2010-09-30 Andreas Forø Tollefsen wrote:<br />
<br />
Hi all,></div>
<div><br />
></div>>
<div>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).</div>>
<div><br />
></div>>
<div>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.</div>>
<div>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.</div>>
<div><br />
></div>>
<div>I cannot get my head around how to structure this?</div>>
<div><br />
></div>>
<div>Any ideas?</div>>
<div><br />
></div>>
<div>Andreas</div>>
<div><br />
></div>>
<div><br />
></div>
</body>
</html>