Cities to Metropolitan areas
- by user325377
Hi all,
I have a database of cities (in both the US and the rest of the world).
The database entries are simple text strings.
Currently the database contains even small cities (population 10,000).
I wish to use a larger scale database instead, by assigning the cities into larger geographical\metropolitan areas.
An example can be the Metropolitan areas in Google's AdWords API:
http://code.google.com/intl/iw-IL/apis/adwords/docs/developer/adwords_api_us_metros.html
but I have no problem using other databases instead.
I'd be grateful for any advice on how this can be performed using existing databases\APIs!