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>
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users