A few weeks ago I edited this page in the Crash wiki: http://www.crashatmine.org/wiki/City_and_Country_Database
I'm still smiling thinking of the problems geocoding solves. To
quote the page:
The country and city database as used in Couchsurfing.com et. al.
uses a country and city database. There are some known problems
with this:
- It doesn't always contain newer countries (Serbia for example), and requires maintenance
- It often only contains major cities (users in smaller cities are forced to choose the closest city)
- It only supports English for city names by default.
- Someone just has to be in a "city"; those closer to the city center are not differentiated.
- Users looking to stay in New York City should also look in neighbouring cities like Jersey City.