blocks|key|913412|text|有相当多的可用的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|913413|以下是2,401,039个城市的数据库|913414|http://www.geodatasource.com/world-cities-database/free|offset|length|913415|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|1J|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Q|8|@]|9|@$F|R|G|S|1|T]]|A|$]]|$1|H|3|-4|5|6|7|U|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|E]]]]

There are quite a few available.

The following has database for 2,401,039 cities

<a href="http://www.geodatasource.com/world-cities-database/free" rel="noreferrer">http://www.geodatasource.com/world-cities-database/free</a>

blocks|key|1128308|text|http://cldr.unicode.org/+-通用标准多语言数据库，包括国家/地区列表和其他可本地化的数据。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1128309|entityMap|0|LINK|mutability|MUTABLE|url|http://cldr.unicode.org/^0|0|O|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

<a href="http://cldr.unicode.org/" rel="nofollow noreferrer">http://cldr.unicode.org/</a> - common standard multi-language database, includes country list and other localizable data.

blocks|key|1128503|text|https://code.google.com/p/worlddb/downloads/list|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1128504|Open+World+Database+alpha|1128505|这个数据库有多种语言的国家名称，地区名称，城市名称和他们的纬度和经度号码和国家的alpha2代码。|1128506|entityMap|0|LINK|mutability|MUTABLE|url|1^0|0|1C|0|0|0|P|1|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]]|C|$]]|$1|F|3|G|5|6|7|X|8|@]|9|@]|C|$]]|$1|H|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|4]]|O|$5|K|L|M|C|$N|4]]]]

<a href="https://code.google.com/p/worlddb/downloads/list" rel="nofollow">https://code.google.com/p/worlddb/downloads/list</a>

<a href="https://code.google.com/p/worlddb/downloads/list" rel="nofollow">Open World Database alpha</a>

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

blocks|key|913711|text|位于mdb、csv或txt的联合国地点列表：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|913712|欢迎使用：http://www.unece.org/cefact/locode/welcome.html|offset|length|913713|Choose+the+downloads+link+from+the+above+link+or+just+click+here.|913714|entityMap|0|LINK|mutability|MUTABLE|url|http://www.unece.org/cefact/locode/welcome.html|1|http://www.unece.org/cefact/codesfortrade/codes_index.html^0|0|5|1B|0|0|0|1T|1|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]]|A|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@$D|X|E|Y|1|Z]]|A|$]]|$1|H|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]|P|$5|K|L|M|A|$N|Q]]]]

United Nations list of locations in mdb, csv or txt:

Welcome:
<a href="http://www.unece.org/cefact/locode/welcome.html" rel="nofollow">http://www.unece.org/cefact/locode/welcome.html</a>

<a href="http://www.unece.org/cefact/codesfortrade/codes_index.html" rel="nofollow">Choose the downloads link from the above link or just click here.</a>

blocks|key|913543|text|你可以在这里使用数据库-|type|unstyled|depth|inlineStyleRanges|entityRanges|data|913544|http://myip.ms/info/cities_sql_database/|offset|length|913545|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;|code-block|syntax|javascript|913546|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|14|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]]|A|$]]|$1|F|3|G|5|H|7|W|8|@]|9|@]|A|$I|J]]|$1|K|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|C]]]]

You can use database from here -

<a href="http://myip.ms/info/cities_sql_database/" rel="nofollow">http://myip.ms/info/cities_sql_database/</a>

<pre><code>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;
</code></pre>

blocks|key|1128423|text|我比较了worldcitiesdatabae.info和www.worldcitiesdatabase.com，后者似乎更有资源。然而，maxmind有一个免费的数据库，所以为什么要购买一个城市数据库。只需获得免费的一个，在互联网上有很多关于maxmind+db的帮助。如果你付出额外的努力，那么你可以节省这几块钱:)|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1128424|entityMap|0|LINK|mutability|MUTABLE|url|http://www.worldcitiesdatabase.com/^0|S|R|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I was comparing worldcitiesdatabae.info with <a href="http://www.worldcitiesdatabase.com" rel="nofollow">www.worldcitiesdatabase.com</a> 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 :)

blocks|key|1128627|text|此服务将任何国家的国家(名称、代码)和城市作为REST、SErvice返回。您还可以下载数据库和示例REST服务|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1128628|http://tecorange.com/content/world-countries-and-cities-restjson-service-12-months-subscription|offset|length|1128629|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|2N|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@$D|O|E|P|1|Q]]|A|$]]|$1|F|3|-4|5|6|7|R|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|C]]]]

This service returns Countries (name,code) and cities for any country as REST, SErvice. You can also download database and sample REST service

<a href="http://tecorange.com/content/world-countries-and-cities-restjson-service-12-months-subscription" rel="nofollow">http://tecorange.com/content/world-countries-and-cities-restjson-service-12-months-subscription</a>

I need a database of Countries and their Cities.

Any idea where I can get such a list?

Of Countries and their Cities

数据库

我需要一个国家和他们的城市的数据库。你知道我在哪里能拿到这样的名单吗？

问国家及其城市的
EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问国家及其城市的EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问国家及其城市的
EN