• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 211
  • Last Modified:

need complete cities and states mysql table

Anyone know of a cities, states, countries mysql table which is free and very complete?
0
projects
Asked:
projects
  • 4
  • 3
1 Solution
 
Akilandeshwari NCommented:
You can download the comma separated data freely using the below link.

http://www.populardata.com/downloads/zip_codes.zip

Create the table and just load this file into your database.
0
 
projectsAuthor Commented:
Cities, States, Countries... as in world wide. This is US only.
0
 
Akilandeshwari NCommented:
0
Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

 
projectsAuthor Commented:
I saw this a while back but the license talked about not being able to use it on a commercial site I believe. It's possible that the client could use it in some commercial manner however, it's not in any geo way, it's only to make sure that people pick consistent city/state/country info.
0
 
Akilandeshwari NCommented:
You will have to go for a premium database then
0
 
projectsAuthor Commented:
I have to believe there is a good complete one out there. It's the geo data that costs money and I don't need any of those things. I just want users to pick rather than free hand enter otherwise we'll end up with a number of variations for one city or state, etc
0
 
projectsAuthor Commented:
I've requested that this question be deleted for the following reason:

I have opted to build my own solution so the question is moot.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now