Solved

country, state, city and zip code

Posted on 2011-03-12
5
1,202 Views
Last Modified: 2013-12-24
Hi,

Any one know all country names with states and their cities. If possible, then zip code as well. Any database(SQL Server, MySQL) or txt or cvs file?

I have to use with c# code.

Thanks
0
Comment
Question by:sindhuxyz
5 Comments
 
LVL 38

Expert Comment

by:Aaron Tomosky
ID: 35118561
States I get from USPS. Countries I get from CIA world factbook. Zips ad cities I get from us census but it's a big list.

I haven't even tried to get other countries cities states and zips, it would be huge.
0
 
LVL 33

Expert Comment

by:Todd Gerbert
ID: 35119806
The US Postal Service sells a database you might find useful...it's name escapes me at the moment, but I'm sure you could find it on their website (http://www.usps.com/).
0
 
LVL 4

Expert Comment

by:mawni
ID: 35120268
ISO-3166-Country-Codes.xls
This is all world country list in Excel file, I don't remember the site which I downloaded this file from, I think it contained all the info you needed
0
 
LVL 4

Accepted Solution

by:
mawni earned 500 total points
ID: 35120277
0
 
LVL 5

Author Closing Comment

by:sindhuxyz
ID: 35227523
thanks
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

I've been asked to discuss some of the UX activities that I'm using with my team. Here I will share some details about how we approach UX projects.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

919 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now