===== Klumpenrisiko =====
We are on an insane mission to find the **real** owners of the 10 biggest water power plants in Switzerland.
The ultimate goal of this project is a visualization that brings real ownership transparency to a complex and often intransparent economic sector.
In the end, we'd like to show which cantons and municipalities own what parts of power companies - and how they would be affected by a bankruptcy of the latter.
GitHub Repo: https://github.com/grimseltor/klumpenrisiko
Prototype with data from the 10 biggest players and their shareholders: http://energyhackday.pkstudio.ch/
Who owns the Alpiq? http://www.energiestadtfinder.ch/wemgehoertdiealpiq/
===== Methodology =====
* We take the water power plants as roots and go forth: Let's take Innertkirchen I as example
* Who maintain it? KWO
* Who owns the maintainer? BKW, EWB, etc.
* Who owns the owner of the maintainer? City of Berne, Canton of Berne, etc etc etc.
* etc.
===== Data =====
* All collected by ourselves from company websites and Wikipedia etc.
===== Team =====
* @grssnbchr
* @davidoesch
* @mhertach
* @philshem
* @HaRii66666
* @gluckstaler
* @satuk34
* @mikeschudel
* @scruggia
* @philippkueng
===== Results =====
The owners of one of the biggest suppliers in Switzerland, Alpiq, are shown in an interactive data-visualization based on d3js.
Who owns the Alpiq? http://www.energiestadtfinder.ch/wemgehoertdiealpiq/
Github: https://github.com/cype/who-owns-Alpiq
===== Sideprojects =====
An awesome map by @davidoesch showing municipal and regional dependency on power suppliers.
We addressed here the following question:
**"Which municipalities depend on only one power network operator - and which one operators are therefore to big to fail?"**
* __Methodology__
Data [[https://www.elcom.admin.ch/elcom/en/home/topics/electricity-tariffs/basic-data-for-tariffs-of-the-swiss-distribution-network-operato.html|Schweizerische Gemeinden und zuständige Stromnetzbetreiber]] provided by Federal Electricity Commission ElComFederal Electricity Commission (ElCom). We added col Count_NB counting the number of served municipalities by operator assigend a color for the top 5 operator (color_NB ) and identified the number of operators serving a municipality (Count_Vggemeinde): ([[https://docs.google.com/spreadsheets/d/12DiVn1BEb_mDlkHX93SClt2p13Z2DvsQ0RPJTl4k9Mg/edit?usp=sharing|RawData]]
Following the tutorial [[https://docs.google.com/presentation/d/1kEfLko7IcPd17fHyFgds8EwpDogJ33wGo_2uEfFuPQg/edit#slide=id.p|tutorial]] to create a map with map.geo.admin.ch we exported all municipalities which have only one power network provider as an [[http://www.opengeospatial.org/standards/kml| OGC KML]] and made it available [[https://gist.githubusercontent.com/davidoesch/f93fa74dbdae5b1ff3c6bfcf485a4a73/raw/37a174129e1de28b8efe27e2c9b92a32fdeedfa5/Stromnetzbetreiber_risiko.kml|KML result]]. This file has then embeded in the map viewer of the federal geoportal as URL source according to this [[http://help.geo.admin.ch/?id=63&lang=en|step]] map has been embed in this site following this guide [[http://www.geo.admin.ch/iframe|www.geo.admin.ch/iframe]]
* __Results__ (//your speed for loading the map may vary on the speed of your network connection//)
**A)5 Top power network operators for municipalities with only one power network operator**. Details in the tooltip incl the "too big to fail" number
{{url>https://map.geo.admin.ch/embed.html?topic=ech&lang=en&bgLayer=ch.swisstopo.pixelkarte-farbe&layers=KML%7C%7Chttps:%2F%2Fgist.githubusercontent.com%2Fdavidoesch%2Ff93fa74dbdae5b1ff3c6bfcf485a4a73%2Fraw%2F37a174129e1de28b8efe27e2c9b92a32fdeedfa5%2FStromnetzbetreiber_risiko.kml&X=185609.71&Y=659624.21&zoom=1}}
Legend:
Romande Energie SA ,
Groupe E SA ,
BKW Energie AG ,
Centralschweizerische Kraftwerke AG CKW ,
Elektrizitätswerke des Kantons Zürich EKZ ,
AEW Energie AG
**B) 5 Top power network operators cover NOT isolated cities, **. Adding the [[http://www.geocat.ch/geonetwork/srv/eng/metadata.show?uuid=44c22568-642c-40bf-a9de-5d865800bed2&currTab=simple|"Density of employment"]] dataset, we see that large cities/Central business districts have usually more than one power network operator
{{url>https://map.geo.admin.ch/embed.html?topic=ech&lang=en&bgLayer=voidLayer&layers=ch.swisstopo.swisstlm3d-karte-farbe,KML%7C%7Chttps:%2F%2Fgist.githubusercontent.com%2Fdavidoesch%2Ff93fa74dbdae5b1ff3c6bfcf485a4a73%2Fraw%2F37a174129e1de28b8efe27e2c9b92a32fdeedfa5%2FStromnetzbetreiber_risiko.kml,ch.bfe.stauanlagen-bundesaufsicht,ch.bfe.energiestaedte,ch.bfe.statistik-wasserkraftanlagen,ch.are.bevoelkerungsdichte,ch.are.beschaeftigtendichte,ch.are.agglomerationen_isolierte_staedte,ch.are.gemeindetypen&catalogNodes=696,692,702,727&layers_opacity=1,0.6,1,0.6,1,0.75,0.75,1,1&layers_visibility=true,true,false,false,false,false,true,false,false&X=185609.71&Y=659624.21&zoom=1}}
Legend:
Romande Energie SA ,
Groupe E SA ,
BKW Energie AG ,
Centralschweizerische Kraftwerke AG CKW ,
Elektrizitätswerke des Kantons Zürich EKZ ,
AEW Energie AG ,
Density of employment - business census
{{https://api3.geo.admin.ch/static/images/legends/ch.are.beschaeftigtendichte_en.png}}
**C) 5 Top power network operators cover Agglomeration, **. Adding the [[http://www.geocat.ch/geonetwork/srv/eng/metadata.show?uuid=c1a563a5-3af3-4fd6-b2fd-1e4b010f0fc4&currTab=simple|"Agglomerations and isolated cities"]] dataset, we see that agglomeration usually depend on one power network operator: Zurich, Bern, Lausanne...
{{url>https://map.geo.admin.ch/embed.html?topic=ech&lang=en&bgLayer=voidLayer&layers=ch.bafu.hydrologie-hintergrundkarte,ch.bfe.stauanlagen-bundesaufsicht,ch.bfe.energiestaedte,ch.bfe.statistik-wasserkraftanlagen,ch.are.bevoelkerungsdichte,ch.are.beschaeftigtendichte,ch.are.agglomerationen_isolierte_staedte,KML%7C%7Chttps:%2F%2Fgist.githubusercontent.com%2Fdavidoesch%2Ff93fa74dbdae5b1ff3c6bfcf485a4a73%2Fraw%2F37a174129e1de28b8efe27e2c9b92a32fdeedfa5%2FStromnetzbetreiber_risiko.kml,ch.are.gemeindetypen&catalogNodes=696,692,702,727&layers_opacity=1,1,0.6,1,0.75,0.75,0.95,0.4,1&layers_visibility=true,false,false,false,false,false,true,true,false&X=185609.71&Y=659624.21&zoom=1}}
Legend:
Romande Energie SA ,
Groupe E SA ,
BKW Energie AG ,
Centralschweizerische Kraftwerke AG CKW ,
Elektrizitätswerke des Kantons Zürich EKZ ,
AEW Energie AG ,
Agglomerations and isolated cities
{{https://api3.geo.admin.ch/static/images/legends/ch.are.agglomerationen_isolierte_staedte_en.png}}
**See also**: https://www.google.com/fusiontables/data?docid=1NLjW96_WVG4zPzwgiIS6X92b-tzefvSzsqgZU5X9#map:id=3
{{url>https://map.geo.admin.ch/embed.html?topic=are&lang=de&bgLayer=ch.swisstopo.pixelkarte-grau&catalogNodes=954,959,965,974&X=203750.00&Y=675000.00&zoom=1&layers=ch.swisstopo.swisstlm3d-karte-farbe,ch.are.bevoelkerungsdichte,KML%7C%7Chttps:%2F%2Fdl.dropboxusercontent.com%2Fu%2F20075478%2FElektrizitaetswerke.kml&layers_opacity=1,1,0.6,1,0.75,0.75,0.95,0.4,1&layers_visibility=true,false,false,false,false,false,true,true,false&X=185609.71&Y=659624.21&zoom=1}}
Legend:
Romande Energie SA ,
Groupe E SA ,
BKW Energie AG ,
Centralschweizerische Kraftwerke AG CKW ,
Elektrizitätswerke des Kantons Zürich EKZ ,
AEW Energie AG ,
===== Links =====
* Relevant documentation ...
* Blog or forum posts ...
* Tools you used ...
{{tag>status:concept needs:dev needs:design needs:data needs:expert energy}}