My goal is to validate an address in Austria. Without a house number, just street, postcode and city(village etc).
I have downloaded and imported austria-latest.osm.pbf from geofabrik.
My approach was to get all postcodes, then all locations for certain postcode and at the end all roads for location. I'm using st_intersects and geometries to connect.
But i'm stuck with "Gemeinden" and can't go deeper. As example "Gemeinde Längenfeld". Google Maps
Wikipedia, german
You don't find "Längenfeld" as location on the address, just "Oberlängenfeld, Unterlängenfeld" and so on, but they only exists as "places" and places are just points, so i cant connect roads to them.
Do you have any hints for me? Thanks you !
P.S. we have our instance of nominatim and use it as fallback
I have found perfect source for my needs. It is official "Statistik Austria". CSV-files can be found here