I have a table with polygons in EPSG 4326. These polygons are distributed all over the world, for example:
POLYGON((10.7324632658845 59.9253049236956,10.7331908150806 59.9244876816042,10.7342435821189 59.9247242537529,10.7335237442742 59.9255414900176,10.7324632658845 59.9253049236956))
Now I'd like to get the areas of these polygons in square meters. With ST_Area(the_geom)
I get the area in square degrees, right? So I have to do something with ST_Transform
. I got a good result for the above mentioned polygon with the following transformation:
ST_AREA(ST_Transform(ST_GeomFromText(the_geom,4326),31467))
However, the calculation (of course) fails when calculating the area of a polygon outside of the coverage of EPSG 31467 (Fatal error...).
Is there a "universal" area accurate projection for this purpose? Or do I have to check the location of every polygon and individually apply a suitable projection to calculate its area properly?