All the cities in the world

Hi there,

I need a database of most of the cities in the world for my application. I know about the city database http://www.geonames.org , so I looked around, and found this plugin for Ruby on Rails:

http://github.com/joho/geonames-rails

I’m not sure if anyone has experience with something like this?

The catch is: I need the cities to have an association with countries, like Countries has many cities, and cities has many countries. I’m not sure if that plugin is capable of doing that.

Anyone used that plugin before? Does anyone have any ideas?

Thanks in advance.

-David

I need a database of most of the cities in the world for my application. I know about the city database http://www.geonames.org , so I looked around, and found this plugin for Ruby on Rails:

http://github.com/joho/geonames-rails

I’m not sure if anyone has experience with something like this?

The catch is: I need the cities to have an association with countries, like Countries has many cities, and cities has many countries. I’m not sure if that plugin is capable of doing that.

Anyone used that plugin before? Does anyone have any ideas?

Years ago I bookmarked this. Never actually used it, but it might do what you want…

http://amrelgarhytech.blogspot.com/2008/08/list-of-countries-cities-languages.html

-philip

I just did a quick install and setup for the plugin on a test app. Looking at the table migration and model code it has the country to city association already created in there. I would say that this plugin is going to do exactly what you want it to do.

B.

Hi,

Anyone have tried to use the GeoNames WebService?.

It seems to be the more practical way. I have the same request as Zhu
and just evaluating this option.

Have anyone else tried it?

Agustin