For a city of Radebeul, located in the federal state Saxony in Germany, I am looking for a list with all addresses, something like
id | Street | Nr | PLZ | City 1 | Meißner Straße | 266 | 01445 | Radebeul 2 | Heinrich-Zille-Straße | 25 | 01445 | Radebeul . | ... | ... | 01445 | Radebeul
What are those options/sources of data?
I somehow think about deploying overpass-turbo or Nominatim as was suggested in this thread Return all elements associated with address - Overpass API. But perhaps there are other free/open solutions which will somehow differ from OSM data basic.
There was also an idea to extract all points (keeping in mind a certain category/amenity) and all buildings as polygons from OpenStreetMap (e.g. using QGIS, as described in this thread Searching and Downloading OpenStreetMap Data), making geocentoids out of buildings, then defining
($x, $y) for each building feature and each point, and finally put all that coordinates into one common list and proceed via geocoding engine, like HERE Geocoding API or Python Geocoder by means of reverse geocoding.
I am aware of this question is partially related to the "geocoding" topic but I am wondering if I can somehow extract the full list of all addresses, something like a reference list from the geocoding library/solution. Unluckily some resources for Germany were demolished, found in this topic Mass Geocoding Requests for Germany?.