Solved

need complete cities and states mysql table

Posted on 2014-09-10
7
209 Views
Last Modified: 2014-09-20
Anyone know of a cities, states, countries mysql table which is free and very complete?
0
Comment
Question by:projects
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 2

Expert Comment

by:Akilandeshwari N
ID: 40315213
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
 

Author Comment

by:projects
ID: 40315235
Cities, States, Countries... as in world wide. This is US only.
0
 
LVL 2

Expert Comment

by:Akilandeshwari N
ID: 40315338
0
Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

 

Author Comment

by:projects
ID: 40316062
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
 
LVL 2

Accepted Solution

by:
Akilandeshwari N earned 500 total points
ID: 40316261
You will have to go for a premium database then
0
 

Author Comment

by:projects
ID: 40318286
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
 

Author Comment

by:projects
ID: 40334460
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

What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question