Hi, When doing intersections between two tables containing many polygons the resulting table often contains geometrycollections of points, polylines and polygons. You have to clean such a table of point and lines if you want to export it as a polygon shapefile.
Isn't there a function in PostGIS to remove line and points from a table of geometrycollections? SELECT ST_ExtractPolygons(geom) FROM mymessyresults ? Thanks Pierre _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
