Answer the question
In order to leave comments, you need to log in
Where can I get the database of regions and cities of Russia and Ukraine?
When registering on the site, you must indicate the region and city. I don’t even know how to google to find a database like on dating sites with a country, region and city.
Maybe someone will tell?
Answer the question
In order to leave comments, you need to log in
It is good practice to use geoip to determine the user's geography by ip. For example, from the same maxmind.com - there are both paid and free databases. Actually the list of regions and cities from there.
We define by default by ip with the ability to change the list.
May be suitable https://github.com/livestreet/livestreet/blob/master/install/geo_base.sql
www.google.com.ua/search?q=geoip+database+mysql
or parse from the same dating sites
In Ukraine, we use the Ukrposhta database. The hierarchy is good up to the streets and the fact that the prefix of the phone number is used as the ID (for example, the ID of Kyiv is 38044, Odessa is 38044, Boyarka is 3804598).
Where to get - buy from Ukrposhta.
In Ukraine, KOATUU is available in the public domain
uk.wikipedia.org/wiki/KOATUU
You can take the database of cities and regions of Ukraine http://alg.bl.ee/sql-base-cities-and-o...
https://tech.yandex.ru/locator/ --> https://tech.yandex.ru/maps/doc/geocoder/
I recently needed something like this! I took from here habrahabr.ru/post/21949 a pretty good base! I redesigned the structure for myself!
For business, you can buy, for example, here - www.dmsolutions.com.ua
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question