[postgis-users] Polygon area in meters

ibrahim saricicek ibrahimsaricicek at gmail.com
Tue Feb 9 05:46:39 PST 2010


one method...
ST_Distance_Spheroid(point_x, point_y, 'SPHEROID["WGS

the other method create a new geometry (the_geom_epsg) column ansd find the
exaxt EPSG code for your region (i prefer 2321 for middle Turkiye ED50 /TM

update table set the_geom_epsg=st_transform(the_geom, epsg)
then use st_area..


On Tue, Feb 9, 2010 at 3:40 PM, Kemal Bayram <kemal at cins.co.uk> wrote:

>  Hi,
> I'm current working with data in long/lat (wgs84) format and using
> st_distance_spheroid to calculate the length of my linestrings in meters.  I
> now need to calculate the area of my polygons and am wondering what the
> easiest way of doing this would be?
> I am thinking projecting the polygon with an equal area projection and then
> using st_area on the result.  Anyone have any ideas on suitable
> projections/SRIDS?
> Regards
> Kemal
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100209/b672df68/attachment.html>

More information about the postgis-users mailing list