Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
project:klumpenrisiko [2016/04/09 10:22] – [Sideprojects] davidoeschproject:klumpenrisiko [2016/05/01 11:37] (current) – [Klumpenrisiko] 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.  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 ===== ===== Methodology =====
  
Line 31: Line 37:
   * @mikeschudel   * @mikeschudel
   * @scruggia   * @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 ===== ===== Sideprojects =====
  
Line 37: Line 51:
  
 We addressed here the following question: We addressed here the following question:
-**"Which municipalities depend on only one power network operator - and which one operators are therfore to big to fail?"**+ 
 +**"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}} {{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 ===== ===== Links =====
  
  • project/klumpenrisiko.1460190166.txt.gz
  • Last modified: 2016/04/09 10:22
  • by davidoesch