Use ST_Polygonize() or ST_BuildArea() depending on your preference.
ie.
SELECT attribute1, attribute2, ST_BuildArea(ST_Collect(my_line_geom))
FROM my_line_table
GROUP BY attribute1, attribute2;
-- Kevin
Stefan Donath wrote:
Hi
I need to create polygons from lines. Using OpenJUMP it works fine
with the geometry but I'm loosing all attribute data!
Could anyone please tell me how to do that in PostGIS!
Thanks a lot - Stefan.
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
