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

[Simon Greener]

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
>that
>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
>in
>both Pgadmin4 and QGIS.
>
>For example, a bbox around a house returns 9.84003999925341e-09. Yet
>QGIS
>calculates it as 113.73 sqm. The QGIS calculation seems to be more
>accurate.
>
>I know I'm doing something very wrong. Any help would be appreciated.
>
>Best,
>Clifford
>
>-- 
>@osm_washington
>www.snowandsnow.us
>OpenStreetMap: Maps with a human touch
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at lists.osgeo.org
>https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200613/31596ba4/attachment.html>