Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 5 of 5
  1. #1
    Regular Coder
    Join Date
    Jul 2002
    Location
    51° 03' -78" N -114° 05' 72" W
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts

    City Province Country Database

    Hello All,

    Does anyone out there have a sql file or a link to a sql file that I could work with that has a cross references all the citys provinces / states and countrys in the world? I have a database that lists all the countrys as there are only 193 per the UN but I dont have all the provinces / states (which is what I am looking for mostly but hey if theres one with citys as well bonus I would think by now in the year 2006 that there would be one already done out there that I could use

    Thanks in advance

  • #2
    New Coder
    Join Date
    Feb 2005
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts
    i have that for portugal only... not the world

  • #3
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,633
    Thanks
    4
    Thanked 148 Times in 139 Posts
    Did you bother to look at the thread titled:
    Country, Regions, City database

    about five or six threads below the one you have posted? Did the last item posted there help you at all?

  • #4
    Regular Coder
    Join Date
    Jul 2002
    Location
    51° 03' -78" N -114° 05' 72" W
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Well that has some good resources but I was hoping to find an open source version. I did grab the countries as I noticed it had 240 countrys and I am interested to see what countrys are not listed in the UN's database, all the other resources cost money which I dont have so I will have to keep researching maybe I will just spend a day or two creating my own

  • #5
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,633
    Thanks
    4
    Thanked 148 Times in 139 Posts
    well that link that had the countries also had over 2,000,000 cities listed too.


  •  

    Posting Permissions

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