Insert Image Size must be less than < 1MB.
    Ask a Question
    Cancel
    Train

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

    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 Answers