[postgis-users] Calculate area shperoid

[luzbrigitte]

Hi, anyone knows how can I calculate area to polygons ?  We work with WGS84
system,  srid -1 and PostGis 0.9

 

I tried :

 

SELECT area2d(transform(GeometryFromText( 'POLYGON((-76.4208295964
3.45224215247, -76.4455829596 3.45275784753, -76.4419730942 3.4264573991,
-76.4161883408 3.4264573991, -76.4208295964 3.45224215247))', -1 ),
["WGS84",6378137,298.25728]')) AS area;

 

 

Thanks a lot for your help, 

 

 

Brigitte Pedraza

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050826/143c6c3f/attachment.html>