Street Listings???

JohnLambert1 · 2020-07-28T20:22:08.000Z

Hi there,
Can you help me? I am looking for a complete listing (on a csv file) of the streets in Belgium.

marczoutendijk · 2020-07-29T14:19:25.000Z

If you use this overpass, you’ll get the streets in the town (Leuven in my example) you list in the code.

[out:csv("name";false)];
area[name="Leuven"];
way(area)[highway][name];
out;

For Leuven I got almost 28000 names back.
I wouldn’t try it for the whole country, possibly leading to memory problems.
Please note that you have to filter out all the duplicates yourself…
If a street has more than one (named) segment, you’ll get that name for every segment in the result.

Marek-M · 2020-07-29T19:55:10.000Z

Instead of code @marczoutendijk I propose to use this code in overpass:

[out:csv ("name")][timeout:2500];
{{geocodeArea:Leuven}}->.searchArea;
(
  way["highway"]["name"](area.searchArea);
);
for (t["name"])
{
  make street name=_.val;
  out;
}

http://overpass-turbo.eu/s/WzT
Code above returns street names in Leuven also but each street name is listed only once. In this way for Leuven there is only 1101 street names instead 28000

marczoutendijk · 2020-07-29T20:28:57.000Z

Marek-M:

Instead of code @marczoutendijk I propose to use this code in overpass:

Nice improvement, thanks!