Select to view content in your preferred language

Find properties within 5 miles radius of a single property based on geocodes

1594
3
04-02-2013 06:02 AM
SCraig-Ward
New Contributor
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 🙂
Tags (2)
0 Kudos
3 Replies
JoeBorgione
MVP Emeritus
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 🙂


When you say you have the properties in a database, what type of database? Have you added the points as an event layer and then saved them as a point feature class?

Once you have a set of actual points in your GIS, you could buffer a single point and perform a spatial selection or you could use the near command.  I think you could also create a graphic circle centered on your XY pair and select those points within the graphic...
That should just about do it....
0 Kudos
SCraig-Ward
New Contributor
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.
0 Kudos
JoeBorgione
MVP Emeritus
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.


I suppose so. Knock yourself out.....
That should just about do it....
0 Kudos