[postgis-users] ST_Polygonize

[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 (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 <http://www.michiganwxsystem.com>
AllisonHouse <http://www.allisonhouse.com>
GRLevelXStuff <http://www.grlevelxstuff.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121008/df8b51bc/attachment.html>