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 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): (RawData Following the tutorial tutorial to create a map with map.geo.admin.ch we exported all municipalities which have only one power network provider as an OGC KML and made it available KML result. This file has then embeded in the map viewer of the federal geoportal as URL source according to this step map has been embed in this site following this guide 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

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 "Density of employment" dataset, we see that large cities/Central business districts have usually more than one power network operator

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

C) 5 Top power network operators cover Agglomeration, . Adding the "Agglomerations and isolated cities" dataset, we see that agglomeration usually depend on one power network operator: Zurich, Bern, Lausanne…

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

See also: https://www.google.com/fusiontables/data?docid=1NLjW96_WVG4zPzwgiIS6X92b-tzefvSzsqgZU5X9#map:id=3

Legend: Romande Energie SA , Groupe E SA , BKW Energie AG , Centralschweizerische Kraftwerke AG CKW , Elektrizitätswerke des Kantons Zürich EKZ , AEW Energie AG ,

  • Relevant documentation …
  • Blog or forum posts …
  • Tools you used …