Need database for all countries, state, city

Question

1.33/5 (2 votes)

See more:

.NET3.5

Hello..

Friends help with database for COUNTRY, STATE and, CITY
send me useful links

[edit]Removed urgency: it may be urgent for you, but it isn't for us. Stressing the urgency just gets peoples backs up and can slow responses. - OriginalGriff[/edit]

Posted 7-Feb-11 20:36pm

Vineet_2109

Updated 7-Feb-11 20:48pm

OriginalGriff

v2

Add a Solution

Comments

OriginalGriff 8-Feb-11 2:48am

What kind of database are you looking for?
Have you tried google?

Vineet_2109 8-Feb-11 2:59am

ya tried google but still there..
and kind of web service or asp.net database if possible ..

OriginalGriff 8-Feb-11 3:09am

No, what do you want the database to contain?

Vineet_2109 8-Feb-11 3:18am

full list for country, state and cities either in xml or created database..

Sandeep Mewara 8-Feb-11 3:39am

Is there a problem doing it yourself?

6 solutions

Solution 2

AFAIK, there is no single free source you can get it. You have 2 options
1. You can crawl the net and get all the data you want and create your own database. Then you would need to maintain it to keep up with all the changes.
2. You can buy a geodata from third party companies. There are many who offer such data.

Posted 9-Feb-11 13:11pm

Yusuf

Solution 3

Here you go

MaxMind World Cities with Population[^]

GeoNames Data[^]

Posted 9-Feb-11 13:32pm

thatraja

Solution 5

this is for an example of that for
country table - country_id,country_name
state table - s_id,sname,countryid
city table - cid,cname,sid

DATABASE SCRIPT

Posted 10-Jan-14 5:48am

ashwani soft

Comments

CHill60 11-Jan-14 11:08am

Hitting "Download" when you have no idea of what might be lurking behind is a good way to download malware

Solution 6

The jquery.country plugin may helps, is a plugin for country/state/city dropdown without any use of database. http://oohm-software.github.io/jquery.country/[^]

Posted 14-Apr-14 3:09am

Lucas Oliveira

Comments

[no name] 14-Apr-14 9:18am

There is really no reason to answer 3 year old questions that already have plenty of answers.

Lucas Oliveira 19-Apr-14 22:14pm

There is really no reason to reply a solution for 3 year old question.

But to answer you, this is not a dead post, a lot of people will look for same question.

Ian Klek 12-Sep-17 11:31am

3 years later, I'm looking at it.

Adebayo Adesegun Daniel 27-Apr-18 8:27am

4 years later, I'm still looking at it

Member 14228878 15-May-19 1:24am

5 years later and still looking at it .

[no name] 25-Jan-21 15:01pm

We should always provide the more reliable dataset. Advance changes also matter.

Solution 7

This is what helped me. It's free. Go to http://stackoverflow.com/questions/1794833/list-of-cities-by-country

Posted 7-Feb-15 7:06am

Member 9834754

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Accepted Answer · 2011-02-07T21:14:00

Solution 1

it is unlikely that this information will be available free of charege.
There are certain third parties, however, that provide this sort of information. See here[^], for example.

Sample article using above one found in CP is here
Simple Way to Implement Country/State/City Dropdown List in ASP.NET[^]

Posted 7-Feb-11 21:14pm

Abhinav S

Updated 9-Feb-11 13:04pm

v2

Comments

thatraja 9-Feb-11 19:05pm

Hi, sample article link has been added.

Abhinav S 10-Feb-11 0:26am

Thanks. I did not know an article for this website already existed. :)

thatraja 10-Feb-11 0:30am

welcome.
Neither I too. :-)

Arpit S 11-Jan-18 1:57am

Is it not a slow process to send data request to some other URL for getting this information ? I guess even webpages having such sections also should be adaptive in the fastest way possible...

1. As per the observations from geodatasource https://www.geodatasource.com/software/world-major-cities-drop-down-list-source-codes, it felt a bit slow while loading the information, but then it is obtained that for every selection it is sending an AJAX request to its database server and in return it is giving out a JSON text containing the piece of information which is required to be added in the dropdown for States/Region or for Cities/ Towns

2. Creating Database is also has some cons for Managing and Maintaining which require constant updates for any changes or any other thing.

So, keeping both the points into account, My other question is what we can do in this scenario for making it into an AI for auto updating the content for any changes ???