Re: [postgis-users] ST_Polygonize

2012-10-08 Thread Nicolas Ribot
Hi, I think it will depend on the way your linestrings are related to each other. If each linestring forms a closed polygon, then it will be easy to add the appropriate column(s) in your select. If several lines can form one polygon, then you will have to choose which linestring attribute will be a

[postgis-users] ST_Polygonize

2012-10-08 Thread Jeff Lake
Be gentle just learning all this I have successfully learned how to use ST_Polygonize to convert a LINESTRING table to POLYGON using this syntax, maybe could be neater.. SELECT ST_AsEWKT((ST_Dump(test2.polycoll)).geom) AS geomtextrep FROM (SELECT ST_Polygonize(the_geom) AS polycoll FROM (SELEC