I have this query :

SELECT ST_AREA(geom::geography) FROM region

The (geom) contains polygons from a shapefile imported into PostGIS with shp2pgsql. I've appended ::geography, else the result of the function was displayed in degrees. Now, I have this kind of answer :


How can I know in which units it is displayed ? square/meters ? square/foot ? I want it to be displayed in square/meters (m²) ou square/kilometers (km²)

How can I do that ?

1 Answer 1


The PostGIS Docs for ST_Area() say:

For "geography" area is in square meters.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.