Database of Countries and their Cities

Question

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

marc_s · Accepted Answer · 2010-10-02 08:58:14Z

up vote18down voteaccepted

There are quite a few available.

The following has database for 2,401,039 cities

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

edited Oct 2 '10 at 8:58

marc_s
363k60644827

answered Oct 2 '10 at 8:54

pyfunc
33.2k37294

thanks a lot :D its not an over kill :D – Harsha M V Oct 2 '10 at 9:08

Is there anyway to know the state/province related to the city with this? – Arya Feb 3 at 8:36

add a comment

Vishnu V Leelakrishnan · Answer 2 · 2012-08-22 05:50:26Z

From all my searching around I strongly say that the most practical, accurate and free data source is provided by http://geonames.org.

You can access their data in 2 ways, 1. The easy way through their free web services. 2. Import their free text files into Database tables and use the data in any way you wish. This method offers much greater flexibility and have found that this method is better.

Ajit Kumar · Answer 3 · 2013-10-22 11:49:11Z

Go through this link http://www.maxmind.com/en/worldcities

It Includes the following fields:

Country Code
ASCII City Name
City Name
Region
Population
Latitude (The latitude and longitude are near the center of the most granular location value returned: postal code, city, region, or country)
Longitude

Is there an information about what the Region codes mean. These are mainly numbers, but sometimes they are not. (Perhaps they are Country abbreviation of the USA.) — Arpad Horvath, Oct 12 '14 at 8:18

Kuvalda.Spb.Ru · Answer 4 · 2011-02-08 09:49:11Z

up vote5down vote

http://cldr.unicode.org/ - ommon standerd multilanguage database include country list and other localizable data.

answered Feb 8 '11 at 9:49

Kuvalda.Spb.Ru
33926

Thank you buddy :) – Harsha M V Feb 8 '11 at 12:39

Question about cities with global permanent ID and localized names is open :( I can't find solution. I plan maintain own application codelist with user contribution. – Kuvalda.Spb.Ru Feb 8 '11 at 15:36

ipinfodb.com/ip_database.php - free community supported geo ip database. Include list of cities with latin names. MaxMind use this database as source. – Kuvalda.Spb.Ru Feb 8 '11 at 15:58

add a comment

marc_s · Answer 5 · 2010-10-02 09:05:35Z

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.

thats neat. only problem is how to get around getting the country names into that. they just have abrev :( — Harsha M V, Oct 2 '10 at 8:54
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, Oct 2 '10 at 8:59

Andy · Answer 6 · 2011-07-22 16:15:56Z

Have a look at WorldCitiesDatabase.Info Depending on what you need the database for, it may be the ideal solution. This one was designed for all sorts of multi-level location selector scripts, and so only contains a manageable amount of entries that would not stall the browser.

nelaar · Answer 7 · 2013-07-26 09:19:36Z

https://code.google.com/p/worlddb/downloads/list

Open World Database alpha

This database has multi languages country names, region names, city names and they's latitude and longitude number and country's alpha2 code .

i ended up using this one it is not an overkill like others with 3 million rows — user1607528, Dec 24 '14 at 5:02

user2253362 · Answer 8 · 2013-04-07 13:29:05Z

You can use database from here -

http://myip.ms/info/cities_sql_database/

CREATE TABLE `cities` (
  `cityID` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `cityName` varchar(50) NOT NULL,
  `stateID` smallint(5) unsigned NOT NULL DEFAULT '0',
  `countryID` varchar(3) NOT NULL DEFAULT '',
  `language` varchar(10) NOT NULL DEFAULT '',
  `latitude` double NOT NULL DEFAULT '0',
  `longitude` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`cityID`),
  UNIQUE KEY `unq` (`countryID`,`stateID`,`cityID`),
  KEY `cityName` (`cityName`),
  KEY `stateID` (`stateID`),
  KEY `countryID` (`countryID`),
  KEY `latitude` (`latitude`),
  KEY `longitude` (`longitude`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

Sneha Javalkar · Answer 9 · 2013-07-03 03:17:18Z

I was comparing worldcitiesdatabae.info with www.worldcitiesdatabase.com and it appears the latter one to be more resourceful. However, maxmind has a free database so then why buy a cities database. Just get the free one and there is lot of help available on internet about maxmind db. If you put in extra efforts then you can save those few bucks :)

Andrew - OpenGeoCode · Answer 10 · 2014-01-29 17:00:10Z

have a cities of the world CSV dataset compiled from the USGS GNIS Server (US) and US NGA GNS Server (non-US), that I have placed into the public domain. Below is a link and metadata of the layout.

Column 1: ISO 3166-1 alpha-2 country code.
Column 2: US FIPS 5-2 1st level administrative division code (e.g., state/province).
Column 3: NGA GNS Feature Description (DSG) code.
Column 4: NGA GNS Unique Feature Identifier (UFI).
Column 5: ISO 639-1 alpha-2/3 code for language corresponding to the feature name.
Column 6: Language script (e.g., latin, arabic, chinese, etc) corresponding to the feature name.
Column 7: Feature name.
Column 8: Latitude coordinate of the area centroid.
Column 9: Longitude coordinate of the area centroid.

http://www.opengeocode.org/download.php#cities

logc · Answer 11 · 2015-03-30 14:29:15Z

up vote1down vote

You can use GeographicDB, it contains about 270,000 major cities across 240+ countries all over the world.

edited Mar 30 at 14:29

logc
1,7151318

answered Mar 30 at 14:00

Ahmed Almazzahy
111

Removed the download link because it seemed redundant with the project's homepage. – logc Mar 30 at 14:05

add a comment

asked	4 years ago
viewed	35821 times
active	12 days ago

Sunday, 12 April 2015