[postgis-users] polygon from multilinestrings

[Michael Fuhr]

On Wed, Jul 04, 2007 at 11:31:37AM +1000, Craig Feuerherdt wrote:
> I have a table that has 275 individual multilinestrings. The geometries have
> come from a variety of tables and represent a bounding area.
> I wish to create a single polygon from them.

Have you tried something like this?

select buildarea(geomunion(geom)) from tablename;

-- 
Michael Fuhr