Skip to content

Instantly share code, notes, and snippets.

@jatorre
Created Nov 12, 2011
Embed
What would you like to do?
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