[postgis-users] polygon from multilinestrings

Michael Fuhr mike at fuhr.org
Wed Jul 4 00:11:56 PDT 2007

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

More information about the postgis-users mailing list