All house numbers in given zip and street

Question

I'm a very beginner with overpass. I need to get all possible house numbers in area with given zip and a part of street.

For example. All houses for: 10178 alex

The result should be or similar to:

Alex-Wedding-Straße, 10178 Berlin
Tunnel Alexanderplatz, 10178 Berlin
Alexanderplatz, 10178 Berlin
Alexanderplatz 1, 10178 Berlin
Kleine Alexanderstraße 1, 10178 Berlin
Alexanderstraße 1, 10178 Berlin
Alexanderplatz 2, 10178 Berlin

I tried the next query, but it returned no results.

area[postal_code=10178][boundary=postal_code]->.a;
way(area.a)["highway"~"^(primary|secondary|tertiary|residential|living_street)$"]["name"~"^alex.*"]->.street;
(
  node["addr:housenumber"](area.street);
  way["addr:housenumber"](area.street);
  relation["addr:housenumber"](area.street);
);
(._;>;);out;

What am I doing wrong?

Answer 1

This query assumes that

• you want all addresses that match both your zip code and specified part of the street name
• case insensitivity is preferred (alex filter should match also Alex, AleX etc)
• postal_code tag is tagged on area with boundary=postal_code (AFAIK not true everywhere)
• address is using addr:street and addr:housenumber tags

    area[postal_code=10178][boundary=postal_code]->.code;
    (
      node["addr:housenumber"]["addr:street"~"alex",i](area.code);
      way["addr:housenumber"]["addr:street"~"alex",i](area.code);
      relation["addr:housenumber"]["addr:street"~"alex",i](area.code);
    );
    (._;>;);out;