April 6, 2012 8:47 AM Subscribe
MapFilter: How can I narrow down a list of ~1000 essentially random cities to only those that are within a given radius of another
list of ~50 cities?
posted by aheckler to computers & internet (6 answers total) 2 users marked this as a favorite
My supervisor has given me a large Excel spreadsheet of potential clients we'd like to market to. It's a list of 1200 or so, and it includes the city and state for each one (e.g., Columbus, OH).
However, for other reasons I won't go into, we only want to market to those potential customers that are within a 50 mile radius of a major airport. So I've also obtained an Excel file that lists city, state info for the top 50 airports in the U.S.
My question is: how can I combine the two? How can I use Google Maps API or some other similar system to effectively cull the large list of clients that are >50 miles distant from one of those airports? Is this even possible?