SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Wizard WorldNews's Avatar
    Join Date
    Nov 2007
    Posts
    1,033
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Where to find MySQL DB for Country, State & City Tables

    Hello,

    I hope this is the right forum to post this question.
    I could not see where would be better suited than here so I am posting here.

    So what I am looking for is a MySQL DB, preferably free but can pay for it, that has 3 Tables:
    1- All countries of the World
    at least should have: ID, Country name

    2- All States/Provinces of each Country, of course not all countries have states.
    at least should have: ID, country_id, state_name


    2- Cities of each State, can be the Top 50 or 10 cities of each state
    at least should have: ID, state_id, city_name


    Regards,

    Anoox search engine volunteer

    www.anoox.com

  2. #2
    SitePoint Evangelist tangledman's Avatar
    Join Date
    Sep 2005
    Location
    Puerto de Mazarron, Murcia, Spain
    Posts
    426
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I think your best bet for this is:

    http://www.geonames.org

  3. #3
    SitePoint Wizard WorldNews's Avatar
    Join Date
    Nov 2007
    Posts
    1,033
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    ThanX. But this does not give me what I need which is Country then States of that Country and then Cities of that State in a MySQL DB.

    Quote Originally Posted by tangledman View Post
    I think your best bet for this is:

    http://www.geonames.org

    Anoox search engine volunteer

    www.anoox.com

  4. #4
    SitePoint Evangelist tangledman's Avatar
    Join Date
    Sep 2005
    Location
    Puerto de Mazarron, Murcia, Spain
    Posts
    426
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I got all the provinces and all the corresponding municipalities of Spain from it.

    Have a look here it tells you how to get them.

    http://www.geonames.org/export/place-hierarchy.html

  5. #5
    SitePoint Wizard WorldNews's Avatar
    Join Date
    Nov 2007
    Posts
    1,033
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    I checked the URL below, but do not see where there is a Download of what I am looking for! Did I somehow miss it? If so please point me to it. ThanX.

    Quote Originally Posted by tangledman View Post
    I got all the provinces and all the corresponding municipalities of Spain from it.

    Have a look here it tells you how to get them.

    http://www.geonames.org/export/place-hierarchy.html

    Anoox search engine volunteer

    www.anoox.com


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •