Consult2code
Login
Register
All Activity
Q&A
Questions
Hot!
Tags
Categories
Ask a Question
Need Any Help in Coding Post your questions here
All categories
Technical
(3)
C#
(0)
ASP.NET
(1)
I need to find Country, State, City Database, Can any one help me?
1
like
0
dislike
geographical-data
world-state-city
ipaddress
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