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
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
