Skip to content

Instantly share code, notes, and snippets.

@jdgonzalez
Forked from davesherratt/gist:1408695
Created September 5, 2012 20:30
Show Gist options
  • Save jdgonzalez/3644236 to your computer and use it in GitHub Desktop.
Save jdgonzalez/3644236 to your computer and use it in GitHub Desktop.
mysql radius
select asciiname,latitude,longitude, acos(SIN( PI()* 40.7383040 /180 )*SIN( PI()*latitude/180 )
)+(cos(PI()* 40.7383040 /180)*COS( PI()*latitude/180) *COS(PI()*longitude/180-PI()* -73.99319 /180)
)* 3963.191 AS distance
FROM allcountries
WHERE 1=1
AND 3963.191 * ACOS( (SIN(PI()* 40.7383040 /180)*SIN(PI() * latitude/180)) +
(COS(PI()* 40.7383040 /180)*cos(PI()*latitude/180)*COS(PI() * longitude/180-PI()* -73.99319 /180))
) < = 1.5
ORDER BY 3963.191 * ACOS(
(SIN(PI()* 40.7383040 /180)*SIN(PI()*latitude/180)) +
(COS(PI()* 40.7383040 /180)*cos(PI()*latitude/180)*COS(PI() * longitude/180-PI()* -73.99319 /180))
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment