PDA

View Full Version : Finding number of pins from distance from central point

n_caskey
02-17-2011, 04:08 AM
Finding number of pins from central point distance central point

Hi guys

Hope you can help with a work problem

I have imported over 5000 addresses and want to find out some data from a central point.

i.e. I want to take an address as a reference point and basically (if possible) draw a circle aprox 4 miles radius as see who falls with in that catchment area.

If that is possible I would like to export the members that fall in this catchment area into excel

Would really appreciate some help guys,

Many thanks

Norman

jsdoyle
06-06-2011, 12:42 PM
Any luck with this? I'm working on a very similar project and haven't been able to figure it out. I have 2 sets of pins. One set is over 3000 locations, while the other is about 200 locations. I want to know which of the 3000 locations are within a certain radius (say within 50 miles) of any of the other 200 locations.

Eric Frost
06-06-2011, 05:12 PM
For the size of the datasets you are working with, if you can export all the lat/lon's for both sets out of MapPoint and do some work in Access, I think that would be fastest (assuming you don't need driving distance, and straight line distance is OK). Do you want to post a sample PTM file, maybe with 5 points from one dataset and 25 in the other, and I could recommend an approach with Excel VBA.

Eric

jasper7
10-26-2011, 05:47 PM
If you can code then this is how I did it

Draw a circle with your Radius set and the Location set to your Adddress

Querry the Circle

Export the Data set.

Unforuntaly the basic code in on my work laptop.

to Answer JS Doyle

You use the Dataset name for the 200 and only draw around those Pins using the Location info from the Pin, to set the Circle Location.

Name the Circle to help identify the Data during export, I used the Pin Name plus some extra info.

Then you querry each Circle Circle, producing a Dataset

Then export the Records, where the Pin dataset name does not match the 200 Dataset Name.

if the file isn't to big, post it and I can run it through my tool or PM me

steve