Created
July 6, 2018 06:26
-
-
Save jquery404/446c868230adbd7e7f66de1944c70ab1 to your computer and use it in GitHub Desktop.
Here's the SQL statement that will find the closest 20 locations that are within a radius of 25 miles to the 37, -122 coordinate. It calculates the distance based on the latitude/longitude of that row and the target latitude/longitude, and then asks for only rows where the distance value is less than 25, orders the whole query by distance, and l…
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT id, ( 3959 * acos( cos( radians(37) ) * cos( radians( lat ) ) | |
* cos( radians( lng ) - radians(-122) ) + sin( radians(37) ) * sin(radians(lat)) ) ) AS distance | |
FROM markers | |
HAVING distance < 25 | |
ORDER BY distance | |
LIMIT 0 , 20; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment