Skip to content

Instantly share code, notes, and snippets.

@jatorre

jatorre/nycbigapps

Created November 12, 2011 16:18
Show Gist options
  • Save jatorre/1360752 to your computer and use it in GitHub Desktop.
Save jatorre/1360752 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
nycbigapps
http://demo.cartodb.com/api/v1/sql?q=select ST_X(ST_Centroid(the_geom)) as longitude,ST_Y(ST_Centroid(the_geom)) as latitude,bathroom,class,comfortsta,comments,descriptio,name,organizati,status,ST_Distance(the_geom::geography,ST_PointFromText('POINT(-73.999548 40.71954)', 4326)::geography) as distance from bathrooms ORDER BY distance ASC LIMIT 10
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment