views:

91

answers:

1

Hello,

I've been unsuccessful in trying to find a US metropolitan area (e.x. San Francisco Bay Area, South Bay, The Berkshires, Upstate New York, etc.) database that is defined by cities.

Does anyone know if such a thing exists?

Wikipedia has a list of "Intrastate Regions" here:

http://en.wikipedia.org/w/index.php?title=List_of_regions_of_the_United_States#Intrastate_regions

Except it would be a pain going through each 50 states, and then pulling out the area's article to find what cities said area is composed of.

The MSA and CSA lists from the Feds doesn't help since its based around statistical groupings and not common names.

Thanks much in advance,

-- Michael

+1  A: 

http://www.census.gov/population/www/metroareas/lists/2008/List2.txt ?

List4.txt and List5.txt list the counties that are associated with each MSA (and Micropolitan SA). With a way to map each city to its county, would that be enough?

mobrule
As I said, the problem is the lists compiled by census.gov are based around statistical groupings.What I'm looking for is a list of cities grouped common names.
Michael
Common names are ambiguous and subjective. See http://en.wikipedia.org/wiki/Silicon_Valley, for example: everyone agrees that Santa Clara is part of Silicon Valley, but people can and will argue about, say, Menlo Park or Santa Cruz. The Wikipedia page you link to is about as authoritative as you can get. Good luck with your project.
mobrule