I have a list of points (addresses with lat/long), let's call that the Target List. I have another list of points (more addresses with lat/long) - let's call that the Master List.
How can I find the closest [enter a number] of points from the Master List that are closest to the Target List? So - not every point in a radius, only the closest 100, or 500 or 1,000 points?
Hopefully the result would be a table with Location 1, then 100 matches, then location 2 and 100 matches, etc.
Thank you so much!
Solved! Go to Solution.
not unless you want to iterate the distance for each source location until you get your threshold count for the target layer
even near as table needs a distance and not a count and you would end up with a ridiculously large table for your sample "closest" numbers.
That would leave the iterative coding sorted by distance
You could be right. I have just laid out the feasibility of the process, rather than focusing on the size of the output table. I have left that decision at the discretion of the user.
Thank you again! I tried another, larger list of points, and just to be 100% certain, double checked the resulting table against the map - worked like a charm! What a relief, I was so stumped. You've been an enormous help.