Advertisement
Guest User

Untitled

a guest
Aug 1st, 2015
190
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.17 KB | None | 0 0
  1. SELECT *
  2. FROM mytable
  3. WHERE ST_DWithin(
  4. ST_Transform(ST_SetSRID(ST_MakePoint(%lat, %lon), 4326), 3857),
  5. the_geom_webmercator,
  6. %radius / cos(%lat * pi()/180)
  7. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement