Select coordinates which fall within a radius of a central point?

Report
Question

Please briefly explain why you feel this question should be reported .

Report
Cancel

I have a database of coordinates in the schema:

ID:Latitude:Longitude:name:desc

I’ve set up my google maps application to show the markers effectively on the screen. However I need to add another feature whereby the user can view all pointers that fall within the radius from a central point.

How would I write up a sql statement of the kind:

Select all pointers that fall within a 10 mile radius of X & Y

0
Rohit 8 months 0 Answers 127 views Guest 0

Leave an answer

Captcha Click on image to update the captcha .