Skip to content

Instantly share code, notes, and snippets.

@nurey
Created February 27, 2017 19:40
Show Gist options
  • Save nurey/e4f81861c68f2d4ce39557513afc6794 to your computer and use it in GitHub Desktop.
Save nurey/e4f81861c68f2d4ce39557513afc6794 to your computer and use it in GitHub Desktop.
select ST_Area(the_geom), ST_Area(the_geom::geography) from geospatial_lookup where id = 23578;
st_area | st_area
--------------------+------------------
0.0706906461999737 | 632842160.137236
(1 row)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment