Skip to content

Instantly share code, notes, and snippets.

@akozlik

akozlik/Lat Lng Radius Search Query

Created December 8, 2013 03:56
Show Gist options
  • Save akozlik/7853184 to your computer and use it in GitHub Desktop.
Save akozlik/7853184 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Lat Lng Radius Search Query
SELECT *, (3959 * acos(cos(radians('".$lat."')) * cos(radians(lat)) * cos( radians(long) - radians('".$lng."')) + sin(radians('".$lat."')) *
sin(radians(lat))))
AS distance
FROM carpark WHERE distance < 15 ORDER BY distance LIMIT 0 , 10
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment