These are flat files that you can edit into an importable format: http://geonames.usgs.gov/domestic/download_data.htm
They are US only and contain every place name in the US that appears on a USGS map. For places outside the US go here: http://earth-info.nga.mil/gns/html/namefiles.htm Personally, I think the best solution is to use Postgresql with the PostGIS extension. Then you can import shapefiles that not only contain names but also boundaries. You can then do spatial queries which far exceed what mysql is capable of. Mark On Tue, Jun 9, 2009 at 1:15 AM, Timo Ziemann<[email protected]> wrote: > > Maybe Google Maps would be a solution for you? > > It´s not really a database, but it´s nice to use anyways :) > > > sinkingfish wrote: >> >> Hi, >> >> Not strictly zf related but thought it would be a good place to ask. Does >> anyone know of a good source for an international database containing >> countries, and also town cities, county's states, etc? >> >> I remember looking at the mysql world database before but not being blown >> away by its individual country listings. >> >> Just putting it out there. >> >> Brian >> > > -- > View this message in context: > http://www.nabble.com/World%2C-Country%2C-town-city-database-tp23925508p23937444.html > Sent from the Zend Framework mailing list archive at Nabble.com. > > -- Have fun or die trying - but try not to actually die.
