Differences

This shows you the differences between two versions of the page.

--- project:klumpenrisiko [2016/04/09 10:15] – [Sideprojects] davidoesch
+++ project:klumpenrisiko [2016/04/12 19:58] – [Results] cype
@@ Line 7: / Line 7: @@
 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/
 ===== Methodology =====
@@ Line 31: / Line 35: @@
   * @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.
-Goal:
+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: <html>
+<span style="color:red;font-size:100%;">Romande Energie SA </span>,
+<span style="color:#ffff00;font-size:100%;">Groupe E SA </span>,
+<span style="color:#ff9900;font-size:100%;">BKW Energie AG </span>,
+<span style="color:#00ffff;font-size:100%;">Centralschweizerische Kraftwerke AG CKW </span>,
+<span style="color:#0000ff;font-size:100%;">Elektrizitätswerke des Kantons Zürich EKZ </span>,
+<span style="color:#00ff00;font-size:100%;">AEW Energie AG </span>
+</html>
+**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: <html>
+<span style="color:red;font-size:100%;">Romande Energie SA </span>,
+<span style="color:#ffff00;font-size:100%;">Groupe E SA </span>,
+<span style="color:#ff9900;font-size:100%;">BKW Energie AG </span>,
+<span style="color:#00ffff;font-size:100%;">Centralschweizerische Kraftwerke AG CKW </span>,
+<span style="color:#0000ff;font-size:100%;">Elektrizitätswerke des Kantons Zürich EKZ </span>,
+<span style="color:#00ff00;font-size:100%;">AEW Energie AG </span>,
+</html>
+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: <html>
+<span style="color:red;font-size:100%;">Romande Energie SA </span>,
+<span style="color:#ffff00;font-size:100%;">Groupe E SA </span>,
+<span style="color:#ff9900;font-size:100%;">BKW Energie AG </span>,
+<span style="color:#00ffff;font-size:100%;">Centralschweizerische Kraftwerke AG CKW </span>,
+<span style="color:#0000ff;font-size:100%;">Elektrizitätswerke des Kantons Zürich EKZ </span>,
+<span style="color:#00ff00;font-size:100%;">AEW Energie AG </span>,
+</html>
+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: <html>
+<span style="color:red;font-size:100%;">Romande Energie SA </span>,
+<span style="color:#ffff00;font-size:100%;">Groupe E SA </span>,
+<span style="color:#ff9900;font-size:100%;">BKW Energie AG </span>,
+<span style="color:#00ffff;font-size:100%;">Centralschweizerische Kraftwerke AG CKW </span>,
+<span style="color:#0000ff;font-size:100%;">Elektrizitätswerke des Kantons Zürich EKZ </span>,
+<span style="color:#00ff00;font-size:100%;">AEW Energie AG </span>,
+</html>
 ===== Links =====