Last post Mar 23, 2015 04:16 AM by smirnov
Mar 23, 2015 03:26 AM|Harrison.Scott|LINK
I'm looking for a full database that contains Countries, states and cities which are mapped by relationship.
I cannot for the life of me find a decent resource, I don't mind paying if that needs to be the case as long as the end result is what I'm after can anyone shed any light on where I can get this from?
Mar 23, 2015 03:56 AM|Ashim Chatterjee|LINK
use yahoo's GeoPlanet :
Mar 23, 2015 04:16 AM|smirnov|LINK
You could obtain countries, states and cities from some of MaxMind databases offered for free
For example you could download GeoLite2 City in csv format and import it to your database
Example of data
AU Australia SA South Australia Windsor
AU Australia WA Western Australia Wiluna
DE Germany ST Saxony-Anhalt Friedensau
DE Germany RP Rheinland-Pfalz Friedelsheim
Hope this helps.