Database of cities, countries and regions without duplicates in English?

Question

Database

Does anyone have or has anyone found a database of cities and countries with regions without duplicate cities? I can't find one like that. Please share if anyone has...

Answer 1

https://github.com/x88/i18nGeoNamesDB
234 countries
3,721 regions
2,246,813 localities
Russian, Ukrainian, Belarusian, English, Spanish, Portuguese, German, French, Italian, Polish, Japanese, Lithuanian, Latvian , Czech
Encoding - utf8

Answer 2

Will this work?
http://www.maxmind.com/app/worldcities There's a free download
button . google -> world cities and regions database

Answer 3

www.geonames.org/

Answer 4

There are in Russia - districts, regions, cities,. Cities have geo coordinates, time zone, name in transliteration for links.
Accurate, in Russia, without coordinates http://api.vbiyske.ru/db/rabota.sql
CIS and may be part of Europe, but the links are not transliterated (in md5) and there may be overlays at the coordinates http://api.vbiyske .ru/db/alogist.sql.zip

Answer 5

It all depends on what size base you need. There is a base for 93489 cities (presumably with a population of up to 5 thousand). Only cities have names in English, but I don't think that's a problem. For details in private

Answer 6

sn4ke, I downloaded this database - there are a lot of duplicates, for example: Sofia, Sofiya, etc.
fso, yes, that’s exactly what you need a base for cities and countries of the world in English (Russia is not important by and large)
I found several bases, I liked one more or less - not big, everything is there, there are no duplicates, though there are no regions, but only region codes. ( netload.biz/2011/01/24/geoip3/ )
geo.webnabor.com/ - a good base, but a lot of extra fields - but it can be solved. And I didn’t like that the names of cities in Bulgaria, for example, are not in English, and in some other language ( Yurucuá - what a dash above “a” - you can’t type this ...)

Answer 7

askbahar.com/2010/07/02/world-city-locations-database/ (World Cities Locations)
more.

Answer 8

Complete database of cities, countries, regions in Russian and English with GPS coordinates, divided into regions, and districts htmlweb.ru/geo/geo.php
At the moment Countries: 255, regions: 8756, districts within regions: 43854, Cities : 1 308 956