Hi, On Tue, Aug 18, 2020 at 12:48:16PM +0300, Марія Завертайло wrote: > Hi! I'm successfully working with Nominatim API. But it's hard for me to > find any information about your database. I have 784 tables (country_name, > location_area, import_status...) and no info about how to use it. I want to > find the old names of cities in Ukraine. How should I write this query?
The main table of interest here is placex. It contains information about all the places that Nominatim has saved. The available names are in the 'name' column. There in particular you would be intersted in 'old_name'. Nominatim only has available what is mapped in OSM. I don't know how common it is in the Ukrain to map old names. On a general note: using Nominatim sounds a bit like overkill for this particular task. Have a look at Overpass API where you can simply download all objects with a place tag within the Ukraine and then extract the same information. Kind regards Sarah _______________________________________________ Geocoding mailing list [email protected] https://lists.openstreetmap.org/listinfo/geocoding
