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 associated to the polygon. You could test for a linestring to be within a polygon's exterior to associate each linestring to a polygon.
Nicolas On 8 October 2012 14:50, Jeff Lake <j...@michiganwxsystem.com> wrote: > 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 (SELECT the_geom FROM maxt) AS test)AS test2; > > > now how do I identify the value of each Polygon I have?? > There is another column that identifies value of the LINESTRING > > -- > Jeff Lake > MichiganWxSystem > AllisonHouse > GRLevelXStuff > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
