[14.1] Food Data Expedition

What:Find and clean data sets dealing with food.
When:Saturday, January 14, 2017, 10:00 - 14:00
Where:Bern, Switzerland.
Cost:Free for registered participants.
Bring:A laptop or tablet. Lunch provided.
Register now!
2 seats remaining

We are starting the new year with a Data Expedition, a workshop that can help you become more Adventurous, Benign and Correlational when it comes to understanding the world of Food - and get up to speed for more data challenges in 2017 as we did in past expeditions. We will collect datasets, conquer their schema, and defeat the barriers that stand in the way to understanding and further use. Working in teams, our goal will be to stretch our skills and open data for the upcoming Open Food Hackdays (register separately).

For more background see full announcement. If you would like to suggest datasets for the workshop, please use this form.

How to register

  1. Register and log in to this forum
  2. Click the heart button :blue_heart: under this post
  3. Get a confirmation email :love_letter: from us with details

If all else fails, use our contact form

Hurry, there is limited room on a first-come first-served basis at this free and well catered-to workshop! If you sign up to our forum you can also subscribe to be notified of upcoming Expeditions and other Events.

This Data Expedition will be facilitated by @oleg and @heidi


We got going at Effinger this morning with 15 participants (3 F), starting with an introduction by @florianwieser to food.opendata.ch, a brief history of the School of Data and a brainstorming exercise led by @heidi to come up with and sort through ideas of interests and questions on the topic of food.

We then split into groups, introduced ourselves to each other using our character sheets, and started to look more deeply into the topics we came up with using open data portals, search engines and spreadsheets.

We compiled a list of datasets and did some in-depth work on areas chosen by each group, creating several Data Packages in the process.

Thanks to THES/Raum für Bildung for the chance to use their new classroom, and to Opendata.ch and Engagement Migros for providing the momentum and food to keep us going - and to all our awesome participants who spent part of the weekend to explore food datasets with us!

Hey y’all, it was an interesting session! Will there be any top-down follow-up of the session in light of getting (more) data ready for the Hackathon, or is it up to each individual (or group) to basically continue the effort and contribute independently to the data repository?

On another note, for those interested, here is a list of the topics that were “assigned” to our sustainability/production/environmental sub-group:

  • Information on agriculture (% conventional/bio), per country, per product… => Basic information
  • Production chains (how can we visualize and track changes in the process that brings food from farm to table)
  • How can I reduce energy use by eating the right things
  • Origin of nutrition
  • What’s in a gene: How are the proteins and nutrients in our food affected by the genetic histories
  • Type of food consumed by resident of certain areas (climate dry/humid, demography, city/countryside)
  • Amount of imported food correlating to international relationship on specific year/time
  • Visualisation of import of food to Switzerland
  • Expressing energy in activities in other foods
  • CO2 effect (or Wh energy consumption)
  • Supply chain/traceability/food chainwhich ingredients are prone to not being produced sustainably or in a fair way
  • Scalability of personal choices (e.g. bio meat, local meat)
  • Amount of food (raw, natural products) being produced in tons (+ how much exported & how much stays in country)
  • Which are the most important ingredients / raw materials used for our food and where do they come from

Lovely feedback @sadrejeb, thanks! I hope that many of you will continue working virtually on searching and preparing open datasets for the hackathon, and your contribution will be very valued. This kind of community effort is the basis for open data movements around the world, so you are spot on with the suggestion. Once you’ve prepared a Data Package, uploaded it to a repository like GitHub, and validated it - let me know and I’ll push it to our Datacentral. Thanks very much as well for sharing the topics your group dived into. This will really help others get a glimpse of the thinking that went on during the workshop.