OpenStreetMap

Overpass API - counting addr:housenumber nodes in EU member states

Posted by mmd on 30 September 2016 in English (English). Last updated on 7 August 2021.

Query

[out:csv(name, count)];

rel(2668952);rel(r);

map_to_area -> .areas;

foreach.areas->.area (
  node["addr:housenumber"](area.area);
  make data count = count(nodes),
            name = area.set(t["name"]);
  out;
)

Result

name	count
Nederland	9307881
France	5746147
Portugal	125216
España	818926
Éire / Ireland	15707
Hrvatska	87719
Italia	3795595
Бългaрия	13497
Ελλάς	58460
Malta	762
Κύπρος - Kıbrıs	1918
Österreich	413787
Danmark	2543375
Deutschland	3577852
Česko	2856166
Sverige	226873
België / Belgique / Belgien	136592
Lëtzebuerg	12261
Slovenija	54326
Magyarország	143186
Polska	3569364
Latvija	12956
România	221791
Slovensko	212013
Lietuva	462917
Suomi / Finland	108568
Eesti	6968

Query runtimes

Instance runtime
kumi.systems: Gateway timeout after 1h
overpass-api.de Gateway timeout after 2h
0.7.59_mmd 30s

Login to leave a comment