[postgis-users] polygon from multilinestrings

[Craig Feuerherdt]

Michael,

I did try that however the resultant table does not contain a polygon.

I added a small rectangle to the layer using uDig (through geoserver) and
attempted the query again. A polygon was generated.
I checked the layer using isclosed(geom) and it returned false. How do I
determine where the the line is broken and then rectify the error?

Craig



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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070705/d94a8f79/attachment.html>