0

I managed to write a query which extracts all windfarms:

[out:json][timeout:150];
(
{{geocodeArea:"Lüneburg"}};
{{geocodeArea:"Nienburg/Weser"}}; 
{{geocodeArea:"Uslar"}};
{{geocodeArea:"Dassel"}};
{{geocodeArea:"Einbeck"}}; 
{{geocodeArea:"Northeim"}};
{{geocodeArea:"Moringen"}};
{{geocodeArea:"Hardegsen"}};
{{geocodeArea:"Bad Gandersheim"}}; 
{{geocodeArea:"Oldenburg"}};
{{geocodeArea:"Dötlingen"}};
{{geocodeArea:"Ganderkesee"}};
{{geocodeArea:"Großenkneten"}};
{{geocodeArea:"Hatten"}};
{{geocodeArea:"Hude"}};
{{geocodeArea:"Wardenburg"}};
{{geocodeArea:"Wildeshausen"}};
{{geocodeArea:"Osnabrück"}};
{{geocodeArea:"Osterholz"}};
{{geocodeArea:"Peine"}};
{{geocodeArea:"Rotenburg (Wümme)"}};
{{geocodeArea:"Salzgitter"}};
{{geocodeArea:"Schaumburg"}};
{{geocodeArea:"Stade"}};
{{geocodeArea:"Uelzen"}};
{{geocodeArea:"Vechta"}};
{{geocodeArea:"Verden"}};
{{geocodeArea:"Brake"}}; 
{{geocodeArea:"Butjadingen"}};
{{geocodeArea:"Wilhelmshaven"}}; 
{{geocodeArea:"Wittmund"}}; 
{{geocodeArea:"Wolfenbüttel"}};
{{geocodeArea:"Wolfsburg"}};
)->.myArea;

node["generator:source"="wind"](area.myArea);
out meta;

The Problem is, that some of the administrative regions have the sam e Name as a City in this Region. Unfortunately overpass takes the name of the city instead of the region, so that only the wind farms in the City are selected.

Is there a way I can make clear, that I am searching for the Region and not for a single City?

  • Easier method, yet with some gaps in the data: get the excel from bundesnetzagentur.de/DE/Sachgebiete/ElektrizitaetundGas/…, save it as csv and import it. – Erik Feb 8 '19 at 9:41
  • Thank you, I am beware of this method, but I am trying it to do it with overpass :) – Hannes Feb 8 '19 at 10:01
  • Since there are not that many wind turbines, you could limit the data types you want to receive to "point" and then do the whole state? For Mecklenburg it worked. – Erik Feb 8 '19 at 10:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.