[postgis-users] polygon from multilinestrings
craigfeuerherdt at gmail.com
Wed Jul 4 16:47:23 PDT 2007
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?
On Wed, Jul 04, 2007 at 11:31:37AM +1000, Craig Feuerherdt wrote:
> > I have a table that has 275 individual multilinestrings. The geometries
> > 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...
More information about the postgis-users