Unify addresses with street on node or associatedStreets relation

[Phyks]

[out:json];
nwr({{bbox}})["addr:housenumber"]["addr:street"];
convert x
  "addr:housenumber"=::,"addr:street"=::,
  type=type(),
  ::geom=center(geom());
out geom;
rel({{bbox}})[type="associatedStreet"]->.assoc;
foreach.assoc->.rel(
  node(r.rel);
  convert x
    "addr:housenumber"=t["addr:housenumber"],
    "addr:street"=rel.u(t["name"]),
    type="rel_node",
    ::geom=center(geom());
  out geom;
);

provided by Roland from Overpass API.