for a tool i am programming right now i need to check if certain combinations of zipcode and streetname exists.
After some search i thought that this might be possible with OpenStreetMap. So i downloaded the needed *.osm.bz2 and converted it into an postgre-sql database thanks to osmosis.
But when i am searching through the database for my street-names i often only often only find nodes or ways with the fitting street name as a name-tag but right now i cant see a way to make make a connection between the zip code and the streetname. Except there is a node that has the streetname as tagvalue and the postcode as value.
But somehow it has to be possible to connect street and zip because when i try the search on openstreetmap.org it can connect the street and the zipcode automatically also for ways, nodes without the needed tags.
Is a direct connection between any given node even the ones without postcode tags and its postalcode with the postgresql possible and i am just to stupid to see it or is that impossible?
Thanks for every answer