Hi,
I have a database of properties in the UK and each property has a longitude and latitude assigned to it. What I am trying to do is find out how many other properties are within a certain radius (in miles or kilometers) of a single property that is selected.
The question is, if I have a longitude of 53.915100 and latitude of -1.945800 for example. And I wanted to find other properties in a 5 miles radius of this one, is there a simple calculation I can do to measure 2.5 miles either side of the longitude and 2.5 miles either side of the latitude?
Many thanks for looking. Hopefully someone out there has had to do this 🙂
Thanks for your reply. This is a very new area to me so the terminology goes over my head a little.
I have an SQL 2005 database and have managed to find the longitude and latitude for the 10,000 property records i have, those are stored in fields called "longitude" and "latitude".
I was going to use JavaScript and the Google API to plot the results once i had found the properties in the radius I am searching. I was hoping i could take my starting properties long and lat and from there do a few JavaScript functions to calculate the miles/degrees to search in my SQL database, return the properties within x amount of degrees east to west and the same north to south. With those results push them to the Google API and i have all my results pinpointed.
Does that sound possible?
Thanks again.