locked
Ful list of countries, states and cities RRS feed

  • Question

  • User-1877113880 posted

    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?

    Monday, March 23, 2015 3:26 AM

Answers

  • User724169276 posted

    use yahoo's GeoPlanet : 

    https://developer.yahoo.com/geo/geoplanet/

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, March 23, 2015 3:56 AM
  • User1508394307 posted

    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 

    http://dev.maxmind.com/geoip/geoip2/geolite2/ 

    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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, March 23, 2015 4:16 AM

All replies

  • User724169276 posted

    use yahoo's GeoPlanet : 

    https://developer.yahoo.com/geo/geoplanet/

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, March 23, 2015 3:56 AM
  • User1508394307 posted

    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 

    http://dev.maxmind.com/geoip/geoip2/geolite2/ 

    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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, March 23, 2015 4:16 AM