Skip to content

Instantly share code, notes, and snippets.

Created Jan 13, 2012
What would you like to do?
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