aGet power grid / Masts

General talk
1

Dear forum,

I was looking for a map of high voltage (110kv) powerlines and masts in Germany and found the following map:

http://www.flosm.de/html/Stromnetz.html?lat=49.3526733&lon=10.2668255&r=43961.728&st=1&sw=cabledistributioncabinet,powerbay,powerbusbar,powercompensator,powerconverter,powerline110k,powerpole,powersubstation,powerswitch,powertower,transformer

To see if I find the data, I downloaded the “Bayern” area here: https://download.geofabrik.de/europe/germany.html

I know have a set of shapefiles, but as far as I can see they do not contain the powerlines / grids. Where can I find this information for Germany? My intention is to do some calculations with Alteryx, so Shapefiles would be ideal.

Many thanks
Lukas

2

Use Overpass to get geojson & convert that to shape: http://overpass-turbo.eu/s/HTS

3

Thank you! I’m getting a memory error when trying to extract them for Germany. Is there another way to get the data?

4

This one works fine for me: http://overpass-turbo.eu/s/HUD

5

Thank you very much, that already helps a lot! I indeed made a mistake by not restricting the area correctly.

One more question: I tried the following code to not only get the lines where the 110 kV transmission network goes along, but also the masts points/nodes. It gives me this error: runtime error: Query run out of memory using about 4838 MB of RAM.
Do you know a solution?

[out:xml][maxsize:2000000000];
{{geocodeArea:Deutschland}}->.searchArea;
(
node[“power”=“tower”]“voltage”=“110000”;
<;
);
out meta;

Very much appreciate your help!

6

Nodes with power=tower almost never have a voltage tag, so your query isn’t really meaningful: https://overpass-turbo.eu/s/HV3

Maybe you want something different?

7

Okay, so I would basically not know if the tower belongs to a 110 kV line, right?

If filtering the 100kV masts is not possible I need to extract all of them. But again I’m not able to download the data with this code:
[out:xml][maxsize:2000000000];
{{geocodeArea:Deutschland}}->.searchArea;
(
node"power"=“tower”;
<;
);
out meta;

Any idea? Appreciate it very much!

8

The query in #4 already returns all towers which belong to a 110kV line. In case you need full metadata for the ways and the nodes, you should maybe use the following query:http://overpass-turbo.eu/s/HWl

I’m still not sure what exactly you’re trying to find out.