Sankey Diagrams

A reader of the blog alerted me about a new report that contains Sankey diagrams for the United Kingdom’s 2007 and 2050 energy flows. Thanks, Neil!

The report is about heat demand and CHP (Building a roadmap for heat. 2050 scenarios and heat delivery in the UK) and was prepared by University of Surrey and Imperial College for the Combined Heat and Power Association (CHPA). On p. 18 it has the following Sankey diagram. I have shown a similar diagram for the UK in this post.

Data is from the Digest of UK Energy Statistics. All flows are in millions of tonnes of oil equivalent (MTOE). Primary energy demand in 2007 was 237 MTOE.

The second Sankey diagram presented (on page 23) is a scenario for 2050. It was calculated using the MARKAL model.

One must read all the assumptions made for the model to be able to interpret it, but you can see immediately that the “energy system in 2050 is signifcantly altered under the common assumptions presented in all-electricity scenarios. In particular, final energy consumption in 2050 will be reduced by 46% against 2007 figures under the assumptions used in the CCC 80% CO2 reduction scenario”.

I invite you to read chapters 3.3. and 3.4 of the report to better understand the 2050 Sankey diagram. Note that the overall primary energy demand is significantly lower, but power generation almost doubles compared to the current situation. Losses from oil refineries are omitted in this scenario due to lack of data.

A great Sankey diagram by the research group made up from researchers from ICEPT (Imperial Centre for Energy Policy and Technology) and Centre for Environmental Strategy at the University of Surrey.

kulturometer.org presented a fantastic diagram that shows the municipality of Madrid’s spendings in cultural activities in 2009. By compiling data from numerous tables, tender calls, and administrative bulletins, they managed to stunningly visualize what one commenter called an ‘information overload’ (‘apagón informativo’). Click on the diagram to enlarge.

This is a breakdown diagram, or ‘diagrama de brazos’, that shows the distribution of the overall cultural budget (182 Mio Euros in 2009) by sectors, sub-sectors, and even into individual types of activities or projects.

It somewhat reminds me of Nicholas Rapp’s AIG bailout diagram, even though less colorful…

Each branch of the diagram is labeled with the relative weight in percent, as well as the absolute value in millions of Euros. The color scale indicates the reliability of the data, either non detailed estimate (light grey), published estimate (grey), or published budgeted data (black).

- Here is the full diagram in large scale (PDF) with an additional breakdown of one particular section (Medialab) at another scale and full legend and annotations
- Watch a slide show to learn more about the diagram (starting p 19)
- And finally, a blowup detail of a diagram section:

Polyethylene terephthalate is something everyone of us uses almost every day. Better known by its acronym PET it is used for plastic film and soft drink bottles.

The following Sankey diagram is from a presentation on PET beverage bottle recycling by Brandon Kuczenski and Roland Geyer of Donald Bren School of Environmental Science and Management at the University of California, Santa Barbara. It was held on the First Symposium on Industrial Ecology for Young Professionals (SIEYP) in Tempe, AZ on May 17, 2009.

The Sankey diagram shows PET flows in million metric tons in the U.S. in 2006. 4.29 mio tons of pet flakes are being produced, of which 2.63 mio tons are transformed into PET bottles (other products are PET film and PET fiber). Only 22.4% of these bottles could be recovered after use. This “loss” is being represented by the blue flow which has only a fourth to a fifth of the width of the red entry flow. Recovered PET bottles are exported or reclaimed, closing the loop at least for a fraction of the PET flows.

Interesting Sankey diagram. Congratulations to Kuczenski/Geyer for visualizing this so clearly. Your comments appreciated

Just back from a holiday, and in order not to keep you waiting for new Sankey diagams … shuffle, shuffle, draw … here are two more one from the Mondays with Minard series at the Cartographia blog (see previous post).

The first one shows French wine exports in 1864. A lot of the good stuff goes to European neighbours, the U.S., to Brasil, Uruguay and Argentina [the latter today an exporter of great wines themself]. But there are also some gourmants that appreciate ‘un verre de bon rouge’ in remote places such as India, China, and of course the outer French territories (Mauritius and Reunion). Not sure what the unit of flow is, as the image is to small to read.

The second one is a map of France that shows the transport of wine and spirits in 1857. Most of the good stuff is shipped to Paris along rivers (green) and major railway lines (pink). Road transport seems to have been excluded. You can also see the transports to the ports for exports (yellow). Flows are in tonnes, but the band itself shows transports in both directions. This national map could be seen as an inset into the above map.

An interesting project summary can be found on the energyech.at pages, “a virtual exhibition and information platform” by the Federal Ministry of Traffic, Innovation and Technology (Department for Energy and Environmental Technologies) and the Austrian Energy Agency”. A PV-diesel hybrid energy generation system was installed at mountain refuge “Klagenfurter Hütte” in southern Austria to secure power supply and reduce dependency on diesel fuel, and to bring down energy costs.

The Sankey diagram shows the energy flows over a 30-month test period from July 1993 to December 1995. Out of the 4981 kWh of energy, 2124 kWh were produced by the diesel engine, while 2857 kWh came from the 18 sqm installed PV modules. A storage battery is installed, and the diesel generator can be used to recharge it if there is no sunshine. The overall efficiency of the system was 61% over the testing period, but could be higher after the energy measuring equipment (consuming 499 kWh itself) was removed after the testing period.

The Sankey diagram shows actually measured values in kWh. It has a top-to-bottom orientation. Diesel is on the left side, the photovoltaic system on the right. Losses branch out horizontally. The battery is the blue box labeled “DC-Ges.” in the middle.

Gabor Doka has relased an updated version of his freeware tool Sankey Helper. The new version 2.4 has a macro for one-step default diagram generation, as well as enhanced colouring features such as using colours from data cells, and creation of colour hue variations. I haven’t tested the new release myself, but will keep you posted after doing so.

A presentation from 2005 on the French energy flows included the Sankey diagram below (I prefer not to name the author or the link to the original source, in order not to embarass anybody).

This Sankey diagram is pretty much messed up, and definitely a candidate for the “Worst Sankey Diagram Contest” that has already been called for. It took me a few seconds to understand that the flows dangling vertically below the blue arrow are actually a breakdown of the 177 mtep consommation finale. Vraiment … j’ai vu mieux que ça!

This is more or less how I would do it. Less colors, a breakdown of the blue flow into the five consumption sectors.

The report about the Material Flows on the Big Island of Hawai’Ii I blogged about a while ago has another Sankey diagram which is interesting and I thought I share this one too.

The diagram shows the input/output flows of material in the Mauna Loa macadamia nut processing plant. Annual production is 3.4 tons.

“From a materials standpoint the plant exhibits an impressive import/export ratio, relying on imports to the island for only a small portion of its total production requirements.”

All flows are in Gg (that’s 10E9 grams, or 1000 tons). Apparently a tiny problem with the recycled biomass loop flows, but otherwise a nice one. Small and trace flows not to scale for good.