Both sides previous revision Previous revision Next revision | Previous revision Next revisionBoth sides next revision |
project:klumpenrisiko [2016/04/08 21:42] – [Team] wnstnsmth | project:klumpenrisiko [2016/04/11 08:44] – [Team] philippkueng |
---|
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/ |
===== Methodology ===== | ===== Methodology ===== |
| |
* @mhertach | * @mhertach |
* @philshem | * @philshem |
* @harii | * @HaRii66666 |
* @gialo | |
* @gluckstaler | * @gluckstaler |
* @satuk34 | * @satuk34 |
* @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/ |
| |
===== Sideprojects ===== | ===== Sideprojects ===== |
An awesome map by @davidoesch showing municipal and regional dependency on power suppliers. | An awesome map by @davidoesch showing municipal and regional dependency on power suppliers. |
| |
https://map.geo.admin.ch/?topic=are&lang=de&bgLayer=ch.swisstopo.pixelkarte-grau&catalogNodes=954,959,965&X=185609.71&Y=659624.21&zoom=1&layers_visibility=false,false,true | 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 ===== | ===== Links ===== |
| |
* Tools you used ... | * Tools you used ... |
| |
{{tag>status:concept needs:dev needs:design needs:data needs:expert}} | {{tag>status:concept needs:dev needs:design needs:data needs:expert energy}} |
| |