USA states and cities sql dump

Discussion in 'PHP' started by Masetek, Aug 18, 2006.

0
  1. #1
    Does anyone have a mysql db with the USA states and cities in it? I am after a mysql dump of all the us states and cities for my new db (I dont really fancy entering them in by hand!). What would be really good if the cities were linked to states (ie. city_id = LA state_id = CA)

    Can anyone help me out with it?

    Thanks!
     
    Masetek, Aug 18, 2006 IP
  2. Henny

    Henny Peon

    Messages:
    2,118
    Likes Received:
    241
    Best Answers:
    0
    Trophy Points:
    0
    #2
    I think I might have one, will check when I get home.
     
    Henny, Aug 18, 2006 IP
    Mia and Halobitt like this.
  3. Masetek

    Masetek Peon

    Messages:
    820
    Likes Received:
    32
    Best Answers:
    0
    Trophy Points:
    0
    #3
    That would be gr8 m8 - cheers!
     
    Masetek, Aug 18, 2006 IP
  4. jroxonline

    jroxonline Peon

    Messages:
    15
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #4
    That's gotta be quite a large number of cities....
     
    jroxonline, Aug 18, 2006 IP
  5. Masetek

    Masetek Peon

    Messages:
    820
    Likes Received:
    32
    Best Answers:
    0
    Trophy Points:
    0
    #5
    yeah, true. Even the capitals would be ok really. Or main cities
     
    Masetek, Aug 18, 2006 IP
  6. Henny

    Henny Peon

    Messages:
    2,118
    Likes Received:
    241
    Best Answers:
    0
    Trophy Points:
    0
    #6
    I think the one i had was populations over 50k
     
    Henny, Aug 18, 2006 IP
  7. Masetek

    Masetek Peon

    Messages:
    820
    Likes Received:
    32
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Yeah that would be perfect :)
     
    Masetek, Aug 18, 2006 IP