http://citieslist.ru/

I need a base of cities in Russia, Belarus, Ukraine and Kazakhstan in full

Found only the link above

still found

http://ekimoff.ru/103/

but gut, there is very little

in the first case I do not like the structure of the tables

let's say I need to look for Vitebsk region in the database

What do you think, is it normal to search by the word, because there are no tables with id fields, all in one table

very strange structure, which is better to convert?

Closed due to the fact that it is necessary to reformulate the question so that you can give an objectively correct answer to the party PashaPash ♦ 2 Apr '17 at 17:53 .

The question gives rise to endless debates and discussions based not on knowledge, but on opinions. To get an answer, rephrase your question so that it can be given an unambiguously correct answer, or delete the question altogether. If the question can be reformulated according to the rules set out in the certificate , edit it .

    1 answer 1

    as for Russia, then there is such a base, which is called KLADR - the Address Classifier of the Russian Federation. It contains a complete (well, almost, with very rare exceptions) list of all settlements (up to the villages). In addition, there is a list of streets, avenues, lanes. In general, your needs will be satisfied with the head. Here it can be found. However, I do not know in what form it lies there, I did not download it myself. As for other countries, I can’t say anything here.