• Register
Need Any Help in Coding Post your questions here

I need to find Country, State, City Database, Can any one help me?

1 like 0 dislike
asked by karthik
edited by admin
When I was looking for a decent database of world cities for my web project, I tried using all of the free city databases out there. I even paid for a couple of them.

But none of them satisfied me. They either had too much useless information (like longitudes, administrative subdivisions for tiny countries, or thousands and thousands of entries for small countries) or too little.

This is why I decided to create my own database.

After that was done I decided to share the results of my work with the world.

I offer my database both in Excel and SQL formats. It has over 40,000 of U.S. cities and a total of over 70,000 cities. To me it is the perfect balance between completeness and usefulness.

If you are interested, visit http://worldcitiesdatabase.info and see if my database is right for you.

2 Answers

1 like 0 dislike
 
Best answer
Based on the IP address you can get this information . Maxmind is providing a open source API . Here is the URL
http://www.maxmind.com/app/geolitecity

Download the Binary file and use anyone of the  API you liked
http://www.maxmind.com/app/city#api


Hope this helped you..
answered by Elam
0 like 0 dislike
When I was looking for a decent database of world cities for my web project, I tried using all of the free city databases out there. I even paid for a couple of them.

But none of them satisfied me. They either had too much useless information (like longitudes, administrative subdivisions for tiny countries, or thousands and thousands of entries for small countries) or too little.

This is why I decided to create my own database.

After that was done I decided to share the results of my work with the world.

I offer my database both in Excel and SQL formats. It has over 40,000 of U.S. cities and a total of over 70,000 cities. To me it is the perfect balance between completeness and usefulness.

If you are interested, visit http://worldcitiesdatabase.info and see if my database is right for you.
answered by worldcitiesdatabase