Both sides previous revision Previous revision Next revision | Previous revision Next revisionBoth sides next revision |
project:bake_open_data [2012/04/28 11:34] – loleg | project:bake_open_data [2013/08/15 23:20] – tagged loleg |
---|
| |
{{http://farm8.staticflickr.com/7092/6974720172_cfbaaeef07.jpg}} | {{http://farm8.staticflickr.com/7092/6974720172_cfbaaeef07.jpg}} |
[[Photo gallery|http://www.flickr.com/photos/dakt/tags/bakeopendata/]] | [[http://www.flickr.com/photos/dakt/tags/bakeopendata/|Photo gallery]] |
| |
We will bake an **open data cake**, i.e. a pie chart you can actually eat! We will use food statistics from the Swiss Open Government Data portal to decorate it. The cake will be served as dessert for the participants of the [[bern:en|Bern Open Data Camp]]. | We are baking an **open data cake**, i.e. a pie chart that actually tastes good! Nutrition statistics from the Swiss Open Government Data portal will be used to decorate it. The cake will be served as dessert for the participants of the [[bern:en|Bern Open Data Camp]]. |
| |
| - Find a delicious recipe [[http://www.bettybossi.ch/de/pdf/detail_SchwerpunktthemaTourdesuisse_pdf_109.pdf|Rüeblitorte - süsser Gruss aus dem Aargau]] (PDF) |
| - Obtain the ingredients and baking materials |
| - Prepare the cake mixtures, beat it nice and smooth |
| - Bake in the oven for about an hour, it's ready when your dip comes out clean |
| - Let it sit overnight, meanwhile analyse the data and prepare your infographic |
| - Once the cake is cool transfer your graphics onto the cake with marzipan and sugar paint |
| |
| Processed //"Nahrungsmittelverbrauch nach Art der Nahrungsmittel"// spreadsheet with our graph: [[https://www.dropbox.com/s/no7rz3r75sx2c86/je-d-07.01.02.01.ods|LibreOffice]] [[https://www.dropbox.com/s/uqlxwakx2vjbbsv/je-d-07.01.02.01.xls|XLS]] |
| |
===== Data ===== | ===== Data ===== |
| |
* [[Statistics portal of the Swiss government|http://www.bfs.admin.ch/bfs/portal/de/index/themen.html]] | * [[http://www.bfs.admin.ch/bfs/portal/de/index/themen.html|Statistics portal of the Swiss government]] |
* [[Nahrungsmittelverbrauch nach Art der Nahrungsmittel|http://www.bfs.admin.ch/bfs/portal/de/index/themen/07/03/blank/data/01/04.Document.21047.xls]] (XLS) | * [[http://www.bfs.admin.ch/bfs/portal/de/index/themen/07/03/blank/data/01/04.Document.21047.xls|Nahrungsmittelverbrauch nach Art der Nahrungsmittel]] (XLS) < what we used |
* [[Kalorientabelle|http://www.novafeel.de/ernaehrung/kalorientabelle/kalorientabelle.htm]] | * [[http://www.novafeel.de/ernaehrung/kalorientabelle/kalorientabelle.htm|Kalorientabelle]] |
* [[Suissebalance|http://www.suissebalance.ch/logicio/pmws/indexDOM.php?client_id=suissebalance&page_id=intern_41&lang_iso639=de]] | * [[http://www.suissebalance.ch/logicio/pmws/indexDOM.php?client_id=suissebalance&page_id=intern_41&lang_iso639=de|Suissebalance]] |
* [[Ernährung in der Schweiz|http://www.bag.admin.ch/themen/ernaehrung_bewegung/05141/05145/index.html?lang=de&download=NHzLpZeg7t,lnp6I0NTU042l2Z6ln1acy4Zn4Z2qZpnO2Yuq2Z6gpJCFeoJ7fWym162epYbg2c_JjKbNoKSn6A--]] 2006 report | * [[http://www.bag.admin.ch/themen/ernaehrung_bewegung/05141/05145/index.html?lang=de&download=NHzLpZeg7t,lnp6I0NTU042l2Z6ln1acy4Zn4Z2qZpnO2Yuq2Z6gpJCFeoJ7fWym162epYbg2c_JjKbNoKSn6A--|Ernährung in der Schweiz]] 2006 report |
| |
===== Team ===== | ===== Team ===== |
* [[user:loleg|Oleg Lavrovsky]] | * [[user:loleg|Oleg Lavrovsky]] |
| |
===== Links ===== | ===== Inspirations ===== |
| |
| * [[information:quickstart|Open Data Quickstart]] |
| * [[http://make.opendata.ch/archive/hannes30/|WebGL data cake]] by [[user:loleg]] |
| * [[http://www.audreelapierre.com/nutritionalfactspackaging.htm|Nutritional Facts Packaging]] |
| |
| {{tag>status:demo hardware dataviz}} |
| |
* Processed spreadsheet with graph: [[https://www.dropbox.com/s/no7rz3r75sx2c86/je-d-07.01.02.01.ods|LibreOffice]] [[https://www.dropbox.com/s/uqlxwakx2vjbbsv/je-d-07.01.02.01.xls|XLS]] | |