<html>
<head>
<title></title>
<meta content="MSHTML 6.00.6000.16825" name="GENERATOR"></meta>
</head>
<body>
<div>Yes</div>
<div> </div>
<div>That should be no problem. I tried with st_collect and it seems to return the centroid as expected. St_collect will be much faster than unioning all the polygons in groups.</div>
<div> </div>
<div>But there is no guarantee that your point will be on any of your polygons depending on how they are placed in relation to eachother.</div>
<div> </div>
<div>this should work</div>
<div> </div>
<div><br />
select st_centroid(st_collect(the_geom)) as the_geom from theTable group by plantation_name</div>
<div> </div>
<div>/Nicklas</div>
<div><br />
<br />
2009-05-15 benton101 wrote:<br />
<br />
<br />
>Hi,<br />
><br />
>I have a table that contains some 40000 records, these records represent<br />
>plantation boundaries. Is it possible to replace multiple polygons grouped<br />
>by plantation name for instance with one point. So say I have 40000 polygons<br />
>and these represent 500 plantations, I would like the results to have 500<br />
>records.<br />
><br />
>Ben<br />
>-- <br />
>View this message in context: http://www.nabble.com/Replace-multiple-polygons-with-one-centroid-tp23558002p23558002.html<br />
>Sent from the PostGIS - User mailing list archive at Nabble.com.<br />
><br />
>_______________________________________________<br />
>postgis-users mailing list<br />
>postgis-users@postgis.refractions.net<br />
>http://postgis.refractions.net/mailman/listinfo/postgis-users<br />
><br />
></div>
</body>
</html>