[postgis-users] ST_AREA(geom) returns incorrect area

Simon Greener simon at spatialdbadvisor.com
Fri Jun 12 16:43:13 PDT 2020

Are you using geometry or geography?

Try the latter.

⁣Get BlueMail for Android ​

On 13 Jun 2020, 09:31, at 09:31, Clifford Snow <clifford at snowandsnow.us> wrote:
>When I run st_area(geom) against a geom in WGS84, my understanding is
>postgis returns the area in square meters. It's not. Instead it returns
>something much smaller. The areas I'm interested in are small bounding
>boxes so spherical measurements should be all that different.
>I verified that the table SRID is 4326. The boxes all display correctly
>both Pgadmin4 and QGIS.
>For example, a bbox around a house returns 9.84003999925341e-09. Yet
>calculates it as 113.73 sqm. The QGIS calculation seems to be more
>I know I'm doing something very wrong. Any help would be appreciated.
>OpenStreetMap: Maps with a human touch
>postgis-users mailing list
>postgis-users at lists.osgeo.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200613/31596ba4/attachment.html>

More information about the postgis-users mailing list