views:

52

answers:

2

I need a database of Countries and their Cities.

any idea where i can get it. or any one can share it with me ?

Like this http://www.worldcitiesdatabase.com/world-cities.aspx

+1  A: 

Check this out:

Cities of the world database donated by MaxMind.com

The company MaxMind.com1 has agreed to release their cities of the world database under the GPL. The database contains locations by country, city, latitude and longitude. There are over 3,047,000 records in the database. For those of you who have tried the location.module with the zipcodes database from CivicSpace, you will recognize how cool it is and how well this fits with that project and therefore Drupal.

Here's another free one that might help you get started.

Creating and maintaining such a database is quite a bit of work - so anyone who's done it is likely keeping it to themselves, or offering it for a fee.

marc_s
thats neat. only problem is how to get around getting the country names into that. they just have abrev :(
Harsha M V
Well, it's free and thus could be a starting point. Based on the abbrev., you should have no trouble finding the country names for those 200 countries or so and add them to your database table...
marc_s
cool. guess.. makes sense :D
Harsha M V
+1  A: 

There are quite a few available.

The following has database for 2,401,039 cities

http://www.geodatasource.com/cities-free.html

pyfunc
thanks a lot :D its not an over kill :D
Harsha M V