0

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 :

544163926.22948

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 ?

3

The PostGIS Docs for ST_Area() say:

For "geography" area is in square meters.

  • Thanks a lot, so stupid of me for not seeing that. – Stranded Kid Jan 7 '14 at 13:53
  • You're welcome, glad to help! – bennos Jan 7 '14 at 15:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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