[postgis-users] how to polygonize a not closed linestring?

Stefan Zweig stefanzweig1881 at web.de
Thu Aug 9 06:12:34 PDT 2007


hi arnaud

thanks for your reply. i think using addpoint will be a good way. but i don't how to apply that on a multipolygon where i have maybe some polygons (which are not closed) in one multipolygon. appending one point to such multipolygon would only close one polygon of the multipolygon, wouldn't it? so, is there maybe a good solution for a multipolygon?

regards,

stefan

> 
> I don't know about the polygonize stuff, but 
> 
> Stefan Zweig a écrit :
> > is there maybe another way to insert the first point again after the last point?
> 
> Here you can use ST_AddPoint :
> 
> ST_AddPoint(linestring, point, [<position>])
> Adds a point to a LineString before point <pos> (0-based index). Third parameter can be omitted or set to -1 for appending.
> 
> So "ST_AddPoint(the_geom, ST_PointN(the_geom, 1))" would return the_geom with its first point appended at the end.
> 
> 
> Regards,
> --
> Arnaud
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 


_____________________________________________________________________
Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
http://smartsurfer.web.de/?mc=100071&distributionid=000000000066




More information about the postgis-users mailing list