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
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