[Geocoding] help

[Sarah Hoffmann]

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