[postgis-users] Polygon area in meters

[ibrahim saricicek]

Hi;

one method...
ST_Distance_Spheroid(point_x, point_y, 'SPHEROID["WGS
84",6378137,298.257223563]');

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
33)

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

Regards..
IBO..

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>