[postgis-users] Postgis Area size problem

Paulius J paulius at digitalwork.lt
Wed Mar 12 07:39:41 PDT 2008


Thank you for your quick reply Nicolas,

Now I get the results which are more likely to be the truth, but they differ
from reality quiet a lot.
Maybe it can be a problem that I got these coordinates from Google Maps? If
I am correct, the polygon which I posted as example should be about 64 000
square kilometers.

Paulius J


Nicolas Ribot wrote:
> 
> On 11/03/2008, Paulius J <paulius at digitalwork.lt> wrote:
>>
>>  Hello,
>>
>>  I have such a problem. Here is my polygon and it looks that everthing is
>>  allright:
>>  POLYGON((56.05364 21.06079,56.43213 22.12646,56.27386 24.55444,56.41998
>>  24.88403,56.17002 25.10376,55.6528 26.63086,54.965 26.25732,54.78168
>>  25.75195,54.31652 25.62012,54.14957 25.74097,54.18173 25.53223,54.28447
>>  25.47729,53.90434 24.37866,53.96255 23.47778,54.25881 23.20313,54.35496
>>  22.77466,54.78802 22.82959,54.95239 22.65381,55.26034 21.32446,56.0475
>>  21.0498,56.05364 21.06079))
>>
>>  But when i want to find the area of it using Area i get the result:
>>  9.04832470074997
>>  I do not know how to get the area size in square meters or something
>> similar
>>  to this? Maybe i should use some other function, but according the
>> postgis
>>  manual I use Area or ST_Area and have such problem...
>>
>>  P.S. i am using SRID = 4326 for the Geometry column.
>>
> 
> ST_area computes the area in geometry's units. Here square degrees.
> Repreject your data in a metric reference system (like UTM for
> instance) with st_transform(), then compute the area.
> 
> Something like:
> 
> select st_area(st_transform(geometryFromText('POLYGON((56.05364
> 21.06079,56.43213 22.12646,56.27386 24.55444,56.41998
> 24.88403,56.17002 25.10376,55.6528 26.63086,54.965 26.25732,54.78168
> 25.75195,54.31652 25.62012,54.14957 25.74097,54.18173 25.53223,54.28447
> 25.47729,53.90434 24.37866,53.96255 23.47778,54.25881 23.20313,54.35496
> 22.77466,54.78802 22.82959,54.95239 22.65381,55.26034 21.32446,56.0475
> 21.0498,56.05364 21.06079))', 4326), 32640));
> 
> Nico
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 

-- 
View this message in context: http://www.nabble.com/Postgis-Area-size-problem-tp15988337p16002553.html
Sent from the PostGIS - User mailing list archive at Nabble.com.




More information about the postgis-users mailing list