Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Database of US metropolitan area names?

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

like image 851
Michael Avatar asked Sep 18 '09 18:09

Michael


1 Answers

To add more up-to-date information to this post, here's a pair of links on Wikipedia that show complete information on metropolitan statistical areas, including the city names:

  • List of Metropolitan Statistical Areas: https://en.wikipedia.org/wiki/List_of_Metropolitan_Statistical_Areas

  • List of metropolitan areas of the United States (this list includes "principal cities") https://en.wikipedia.org/wiki/List_of_metropolitan_areas_of_the_United_States

I hope this is helpful to others who come across this post!

like image 173
Mike Zavarello Avatar answered Sep 27 '22 20:09

Mike Zavarello