select "NAME_GEO", ST_AsText(the_geom) from "Lakes"; select "NAME_GEO", ST_AsText(the_geom) from "Lakes" WHERE ST_Area(the_geom)/100000 >200; select "NAME_GEO", the_geom from "Lakes" WHERE ST_Area(the_geom)/100000 >200; select ST_Area(ST_Intersection (l.the_geom, z.the_geom))/100000 from "Lakes" as l, zone as z where ST_Intersects(l.the_geom, z.the_geom);