Getting area of WGS-84 geometries in SqKm

<span title='2021-07-17 00:00:00 +0000 UTC'>July 17, 2021</span> · 1 min | Edit

Getting area of geometries in WGS-84/EPSG:4326 in square kilometers:

1
2
3
4
SELECT
  ST_Area(geometry, false) / 10^6 sq_km
FROM
  my_table