===== 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}}