How to parse city coordinates?

Question

Google

I have a large number of city names that I successfully received through vk api. My task is that for these cities I need coordinates, country, and region (if any). People who know parsing, tell me where you can parse this data ?
Api maps like geopy, geocoder will not help because there is a limit on requests per day, and a database of cities for several million names. right side plz

Answer 1

Try pulling data from the openstreetmap database.
A snapshot of their database is available for free.
Here is a thing to import into posgtres. I must say that in addition to it, there is also osm2pgsql , which does about the same thing.
On the OSM Wiki , you can find tags that mark city points. And then you, perhaps, will not need your list of names, they are all (these cities) there, and in several languages.
By the way , there was even a question about filtering on this resource.

Answer 2

via wikipedia you can do it

Answer 3

use openstreetmap, luk !!
there is a free nominatim geocoder in osm, study its api
https://nominatim.openstreetmap.org/search.php?q=%...