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

[Clifford Snow]

Simon,
I'm using geometry but have cast it as a geometry using
ST_AREA(geom::geometry) with no real change.



On Fri, Jun 12, 2020 at 4:51 PM Simon Greener <simon at spatialdbadvisor.com>
wrote:

> Are you using geometry or geography?
>
> Try the latter.
>
> Get BlueMail for Android <http://www.bluemail.me/r?b=15860>
> On 13 Jun 2020, 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
>>
>> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users



-- 
@osm_washington
www.snowandsnow.us
OpenStreetMap: Maps with a human touch
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200612/e78d19df/attachment.html>