Base GeoIP - countries and cities, January 2011

A new version of the Russian-language database of countries and cities has been published. Major changes:
- The Google Maps API was used to translate city names ( chernikov idea)
- geobaza.ru database (idea derketzer ) is connected to search in the CIS countries
The result of this work is available for free download.

The database is distributed in two versions: " Countries and cities " (22Mb, after installing ~ 123Mb) and " Only countries " (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 ~ 95%. 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 - determining your city by IP in the form of a flight 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.

Ideas to improve the translation and improve the quality of the database are welcome.

Some statistics

In the current version of the base 93,342 settlements.

The number of settlements in different countries:

A country	amount
Germany	18,255
USA	15.525
Italy	6.595
Austria	6.357
Spain	5.678
Australia	5,128
France	4.635
Russia	3.186
Canada	3,036
Poland	2,768
Brazil	2,333
Switzerland	1,795
Belgium	1.562
Japan	1,411
Portugal	1,271
Ireland	1,119
Argentina	1,084
Mexico	1,060
Ukraine	715
China	689
Bulgaria	603
Great Britain	572
Colombia	545
Luxembourg	358
India	357
South Africa	332
Norway	329
Turkey	293
New Zealand	279
Hungary	260
Serbia	221
Chile	202
Kazakhstan	194
Philippines	185
Romania	166
Czech	159
The Republic of Korea	155
Netherlands	152
Slovakia	152
Ecuador	141
Croatia	138
Sweden	128
Guatemala	124
Venezuela	120
Honduras	118
Finland	115
Belarus	102
Greece	94
Iran	91
Lithuania	90
Israel	90
Latvia	87
Moldova	85
Estonia	85
Trinidad and Tobago	79
Peru	69
Barbados	56
Jamaica	56
Costa Rica	55
Indonesia	54
Dominican Republic	53
Mauritius	51
Egypt	46
Denmark	45
Morocco	42
Macedonia	41
Armenia	39
Algeria	38
Nigeria	37
Uruguay	36
Panama	36
Salvador	33

For the rest of the countries less than 30 settlements.