[postgis-users] ST_area returning wrong results (and stretched polygon in the screen)

[Nicolas Ribot]

On 21 July 2011 15:44, p valdes <p.valdes334 at gmail.com> wrote:
> mmmh... I see
>
> Thanks a lot for your advice Nicolas, I will follow your clue and
> investigate about how to do this
>

Something like:

SELECT st_area(st_transform(mytable.perimeter, 32630)) AS square_meters
FROM mytable
WHERE name = 'myname';

Should give you areas in square meters.

Nicolas