Classify Addresses By Location
March 30, 2008
I have an MS SQL database (can output to an Excel spreadsheet, if necessary) with 15,000 addresses (city, state and zip code) in the United States. I need some way to determine the number of people closest to each metropolitan area (http://www.neweconomyindex.org/metro/major_cities.html). For example, I need to know how many people are within 40 miles of Seattle, Los Angeles, Atlanta, New York City, Boston, etc. You will need to find a list of all metropolitan cities in the US and do the calc…