Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
Maptime Seattle Postgis - Problem 1
SELECT name, ST_Area(geom, true) * 3.86102e-7 as area_square_miles
FROM geo.states_ne
WHERE admin='United States of America'
ORDER BY ST_Area(geom, true) DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment