GeoIP - countries and cities, December 2010

A new version of the Russian-language database of countries and cities has been published. Major changes:
- base maxmind.com was merged with the base of Russian cities ipgeobase.ru (the idea of sky_lord )
- With the help of Google Translate, ~ 60,000 names were translated into Russian (the idea of neytrino ), and then with the help of Yandex.Map artifacts like “Yin young” and “Aviators village” were eliminated
- doubles were removed and the base structure was optimized.
The result of this work is available for free download.

The database is distributed in two versions: “ Countries and cities ” (14Mb, ​​after installing ~ 77Mb) and “ Countries only ” (1Mb, after installing ~ 6Mb). Also in the archives is a small example of using the database in php.

The accuracy of determining the country ~ 99%, the accuracy of determining the cities on average ~ 95%, Russia ~ 98%, Ukraine ~ 90%. Whether it is a lot or a little depends on the tasks that you are going to solve with the help of this base.
')
Test demo - determine your country and city by IP-address

Work demo - city ​​substitution by IP in the form of air ticket search

To install the database, I recommend using programs like mysqldumper or via ssh to execute
mysql –p –user database <file.sql

I do not recommend installing a database of cities on a shared hosting, it will not sustain the load.

I am aware of the rudeness of the translation of geographical names and I hope that professional geographers do not read this article. There are several ideas for implementing a more accurate and scientifically-based translation; if successful, I’ll tell you about this in the next issue.

Added by:
Fixed a bug in the database "Countries and Cities", the file was updated.

Tell me:
For Ukraine, there is an analogue of ipgeobase.ru ?