Skip to content

Instantly share code, notes, and snippets.

@jatorre

jatorre/gist:1608196

Created January 13, 2012 19:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jatorre/1608196 to your computer and use it in GitHub Desktop.
Save jatorre/1608196 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
http://vizzuality.cartodb.com/api/v1/sql?q=
SELECT * FROM (SELECT lat,lon,name, ST_Distance(ST_SetSRID(ST_MakePoint(-73.9967,40.724805),4326)::geography,the_geom::geography) as distance_meters FROM com_vizzuality_nycbathrooms) as q WHERE distance_meters < 1500
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment