Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT *
- FROM mytable
- WHERE ST_DWithin(
- ST_Transform(ST_SetSRID(ST_MakePoint(%lat, %lon), 4326), 3857),
- the_geom_webmercator,
- %radius / cos(%lat * pi()/180)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement