in Czechia we have unique house numbering, Slovakia has too, but two numbers are everywhere where are named streets and all other buildings have address, but in Czechia have address usually main building in plot. Addresses have street name conscription number/street number.
I need to search same number values in address, which are occuring as conscription number in one address and as street number in second address in same street, for example, Jungmannova 35/29 and Jungmannova 29/19, where 29 is equivocal.
I only have so far search address with two same numbers, like 1/1.
/*
This query looks for nodes, ways and relations
with the given key.
Choose your region and hit the Run button above!
*/
[out:json][timeout:25];
// gather results
nwr["addr:street"]["addr:conscriptionnumber"]["addr:streetnumber"]
(if: t["addr:street"]+t["addr:conscriptionnumber"] == t["addr:street"]+t["addr:streetnumber"])({{bbox}});
// print results
out geom;
It seems to find many objects, but not all. In the linked area this one should be found as well but is missing in the output: Way: 61004753 | OpenStreetMap
Great, and the processing time of this query is for centre of Prague too long. I added key ref:ruian:addr which should shorten a bit, but it is unnecessary to search in streets where no one street number is bigger than one conscription number and no one conscription number is smaller than one street number (values of č.p. “číslo popisné” and č.o. “číslo orientační”) don’t cross in same street. But I don’t know whether it will short processing time or not. I put timeout 25000, I hope it should be enough. But thanks for this base