When the supermarket hopes that the winter weather and snow fall not just freezes the roads but also your brain…..

Five kilos of road salt sold at E5,99 or 1,20 per kilo as ‘special offer’. Special indeed, as immediately opposite in the same aisle kitchen salt goes for 0,36 per kilo. Even though the kitchen salt is refined and cleaned, it is still two thirds cheaper than the untreated ‘road salt’. Not surprising then that the staff who tried to remove the ice from sidewalk in front of the supermarket were using the kitchen salt, not the salt from their own ‘special offer’.

road salt, 1,20 per kilo

kitchen salt, 0,36 per kilo

no wonder staff used kitchen salt, and not the high-end priced road salt

Today I gave short presentation at the Citizen Science Koppelting conference in Amersfoort. Below is the transcript and the slidedeck.

I’ve worked on opening data, mainly with governments worldwide for the past decade. Since 2 years I’ve been living in Amersfoort, and since then I’ve been a participant in the Measure Your City network, with a sensor kit. I also run a LoRaWan gateway to provide additional infrastructure to people wanting to collect sensor data. Today I’d like to talk to you about using open data. What it is, what exists, where to find it, and how to get it. Because I think it can be a useful resource in citizen science.

What is open data? It is data that is published by whoever collected it in such a way, so that anyone is permitted to use it. Without any legal, technical or financial barriers.

This means an open license, such as Creative Commons 0, open standards, and machine readable formats.
Anyone can publish open data, simply by making it available on the internet. And plenty people, academics, and companies do. But mostly open data means we’re looking at government for data.

That’s because we all have a claim on our government, we are all stakeholders. We already paid for the data as well, so it’s all sunk costs, while making it available to all as infrastructure does not increase the costs a lot. And above all: governments have many different tasks, and therefore lots of different data. Usually over many years and at relatively good quality.

The legal framework for open data consists of two parts. The national access to information rules, in NL the WOB, which says everything government has is public, unless it is not.
And the EU initiated regulation on re-using, not just accessing, government material. That says everything that is public can be re-used, unless it can’t. Both these elements are passive, you need to request material.

A new law, the WOO, makes publication mandatory for more things. (For some parts publication is already mandated in laws, like in the WOB, the Cadastre law, and the Company Register)

Next to that there are other elements that play a role. Environmental data must be public (Arhus convention), and INSPIRE makes it mandatory for all EU members to publish certain geographic data. A new EU directive is in the works, making it mandatory for more organisations to publish data, and for some key data sets to be free of charge (like the company register and meteo data)

Next to the legal framework there are active Dutch policies towards more open data: the Data Agenda and the Open Government action plan.

The reason open data is important is because it allows people to do new things, and more importantly it allows new people, who did not have that access before, to do new things. It democratises data sources, that were previously only available to a select few, often those big enough to be able to pay for access. This has now been a growing movement for 10-15 years.

That new agency has visible effects. Economically and socially.In fact you probably already use open data on a daily basis without noticing. When you came here today by bike, you probably checked Buienradar. Which is based on the open data of the KNMI. Whenever in Wikipedia you find additional facts in the right hand column, that informations doesn’t come from Wikipedia but is often directly taken from government databases. The same is true for a lot of the images in Wikipedia, of monuments, historic events etc. They usually come from the open collections of national archives, etc.

When Google presents you with traffic density, like here the queues in front of the traffic lights on my way here, it’s not Google’s data. It’s government data, that is provided in near real-time from all the sensors in the roads. Google just taps into it, and anyone could do the same.You could do the same.

There are many big and small data sets that can be used for a new specific purpose. Like when you go to get gas for the car. You may have noticed at manned stations it takes a few seconds for the gas pump to start? That’s because they check your license plate against the make of the car, in the RDW’s open database. Or for small practical issues. Like when looking for a new house, how much sunshine does the garden get. Or can I wear shorts today (No!).

But more importantly for today’s discussion, It can be a powerful tool for citizen scientists as well. Such as in the public discussion about the Groningen earth quakes. Open seismological data allowed citizens to show their intuition that the strength and frequency of quakes was increasing was real. Using open data by the KNMI.Or you can use it to explore the impact of certain things or policies like analysing the usage statistics of the Utrecht bicycle parking locations.A key role open data can play is to provide context for your own questions. Core registers serve as infrastructure, key datasets on policy domains can be the source for your analysis. Or just a context or reference.

Here is a range of examples. The AHN gives you heights of everything, buildings, landscape etc.
But it also allows you to track growth of trees etc. Or estimate if your roof is suitable for solar panels.This in combination with the BAG and the TOP10NL makes the 3d image I started with possible. To construct it from multiple data sources: it is not a photograph but a constructed image.

The Sentinel satellites provide you with free high resolution data. Useful for icebreakers at sea, precision agriculture, forest management globally, flooding prevention, health of plants, and even to see if grasslands have been damaged by feeding geese or mice. Gas mains maintainer Stedin uses this to plan preventative maintenance on the grid, by looking for soil subsidence. Same is true for dams, dikes and railroads. And that goes for many other subjects. The data is all there. Use it to your advantage. To map your measurements, to provide additional proof or context, to formulate better questions or hypotheses.

It can be used to build tools that create more insigt. Here decision making docs are tied to locations. 38 Amersfoort council issues are tied to De Koppel, the area we are in now. The same is true for many other subjects. The data is all there. Use it to your advantage. To map your measurements, to provide additional proof or context, to formulate better questions or hypotheses.

Maybe the data you need isn’t public yet. But it might be. So request it. It’s your right. Think about what data you need or might be useful to you.
Be public about your data requests. Maybe we can for a Koppelting Data Team. Working with data can be hard and disappointing, doing it together goes some way to mitigate that.

[This post was created using a small hack to export the speaking notes from my slidedeck. Strangely enough, Keynote itself does not have such an option. Copying by hand takes time, by script it is just a single click. It took less than 10 minutes to clean up my notes a little bit, and then post the entire thing.]

Today is national apple picking day. We had a tree full of apples this year. We ate a few apples during summer, but the drought, wasps and birds took most of them. So despite the many apples the tree carried early in the summer, the harvest in the end was smaller than last year.

The apples are very tasty though. Just the right mix of sweet and tangy. And Y was rather impressed one day sitting at the table in the garden, when she asked for an apple, and I simply reached above me and picked one.

I spent more time pruning the tree, then picking the few remaining unspoilt apples today.

Pruning the tree

20180915_152947The very limited remaining harvest

Do You Have Any Diodes? ….. …. Is probably the most unlikely question I got ever asked out of the blue at a birthday party. However the answer turned out to be yes, I did have two diodes. I didn’t think I did, but taking a look in the one box I suspected might have some electronic components in them, proved me wrong.

The diodes were needed to increase the strength of the scary noises an evil robot was emitting. This evil robot was being created just outside our front door where the enormous Frysklab truck, containing a mobile FabLab, was completely filling the courtyard. Representing everything that is wrong and evil about some of the devices that are marketed as necessary for a ‘smart home’, the evil robot then got ritually smashed into pieces by Elmine, wielding a gigantic hammer, named ‘The Unmaker’ that a colleague brought with him. That was the official closing act of our unconference “Smart Stuff That Matters“.

Around all this our 40 or so guests, friends, family members, clients, colleagues, peers, were weaving a rich tapestry of conversations and deepening connections. Something that our friend Peter put into words extremely well. Elmine and I are in awe of the effort and time all who joined us have put into coming to our home and participate in our slightly peculiar way of celebrating birthdays. Birthday parties where evil robots, a hyperloop to send messages from the courtyard to the garden, mythical German bbq-sausages, friendship, philosophy, web technology, new encounters and yes diodes, are all key ingredients to help create a heady mix of fun, inspiration, connection, and lasting memories.

Thank you all so much for making it so.




August 31st Elmine and I host the 4th Birthday Unconference and BBQ-Party in our home in Amersfoort. The unconference is titled “Smart Stuff that Matters”.

So what is Smart, and what Matters?

A year ago we moved to Amersfoort. A different house, a different neighbourhood, a different city. The city where our daughter will grow up.

A new environment means lots of exploration. What makes a house a home? How can you smartly adapt your house to your needs? Who lives in the neighbourhood, how do you settle in it? What makes a city your city? Which existing initiatives appeal to you, and in what ways can you contribute to them?
Whether it’s a new habit, a new device in your home, your contacts and networks, or your approach: what are smart ways to act and contribute to your residence and environment so it supports you and the others in it? In the context of much wider developments and global issues, that is. Both social and technological, at home, in your neighbourhood, your city. It’s important to approach things in ways that create meaning, enable the important things, both for you and others. Smart Stuff That Matters therefore.

Our house, in the middle of our street

A full day long we’ll explore ‘smart’ in all its facets.
Smart homes (and around the home), smart neighbourhoods, smart cities.
Socially, how do we learn, communicate, organise and share? How do we act, how do we contribute? How do we find the power of collaborative agency.
And also technologically, which technologies help us, which only pretend to do so, and are these technologies sufficiently ours?
We will have the Frysklab Team joining us again with their mobile FabLab, and have plenty of space to experiment with technology that way. Such as sensors, internet of things and programming. Or to build non-digital hacks for around the home.

Frysklab in da house!
Frysklab’s truck parked at our old home in Enschede during the previous unconference

Together we’ll explore what smart means to you and us.
Bring your small and big experiences and skills, but above all bring your curiosity, and let yourself be surprised with what the others bring.
Do you have ideas about what you’d like to show, discuss, present or do?
Have ideas about what you would like to hear from others about? Let us know! We’ll build the program together!

You’ll find all relevant information about the unconference on this site. You’re also welcome to join our Facebook group for the event.

Today 100 households in Amersfoort turn their gardens into a stage for in total 300 performances. Two blocks down our road a few neighbours opened up their garden too. Turns out they were both actually part of the band programmed to play there. They played in their own garden 🙂

struinen in de tuinen

Great weather, good opportunity to meet some neighbours for the first time.

Forgotten Literature

There’s a book on the window sill, next to the balcony. One can easily imagine someone reading in the open window while enjoying the sun, then putting the book down to answer the door for a friend passing by who invited the reader to a drink outside on a terrace. Returning home later in the evening, the reader closed the windows and drew the curtains. The book forgotten on the sill. Maybe if the reader wakes up, sometime after we finish our morning coffee on the terrace across the street, and opens the curtains and windows, the book will be found.

(Amersfoort city center this morning)

struinen in de tuinen

Next Sunday the yearly ‘garden jaunts’ event takes place in Amersfoort. Over 100 households open their garden to the public, and in each garden there will be performances of a local artist, musician, band or author. A paper was provided door to door with an overview, allowing everyone to plan a route. For every part of town the open garden and the programmed artists are listed. We’ll likely go to see a band play in a garden just down our street. A fun way to explore the city and meet more of our neighbours.

struinen in de tuinen
Routes in every part of town.
struinen in de tuinen
The route in our area, Vathorst

Our local gas station has a charity support system instead of a loyalty points system. Early last week I mentioned it to Patrick when we met in London, in a conversation about the various channels charities have to reach people. He asked me for pictures of the system, and today I needed to get some gas for the car, so I took some.

Next to the cash register there’s a large ‘score board’ that cycles through screens showing charities with the biggest donations, or showing different categories of charities and the accumulated donations this year.

The ‘scoreboard’ of “Tank & Schenk”, which rhymes and means ‘fill up and donate’. The screen here is showing donations to national charities. At the bottom is the total donated, some 33.000 Euro

When you pay, there’s a tablet on the counter where you get the option to choose any local club/charity or national charity to donate your points to. The local list contains all the clubs and associations in the village and city (like the football club, or the carnival club etc), and all museums, music venues and marching bands in the city and region, as well as local charities such as foodbanks, homeless shelters etc.

My 40 points mentioned at the top can be donated to various categories. Local music, local sports clubs, local cultural institutions, local charities, and underneath (smaller) national charities

Opening the list of local cultural groups and institutions

When you select a charity you get a thank you screen that also shows you how much that specific charity already received this year.

This time I selected the museum in the birth home of Piet Mondriaan, which brought the total donation to 78,41 Euro

Now that we moved from Enschede to Amersfoort two weeks ago, we are starting to participate in local activities. Today I joined a workshop to build a sensor-hut for the ‘Measure your city‘ project. Initiated by amongst others ‘De War‘, also the people who started FabLab Amersfoort, it is a project to crowdsource measurements to track climate and climate changes inside the city.

The national metereological institute does not measure inside cities as it does not provide data that can be compared with other measurements across the country. By building a dense grid of sensors across the city it becomes possible however to track the emergence of ‘heat islands’ or see how paving over gardens or making them greener influences the city’s microclimates.

The sensor-hub I built this afternoon is based on Arduino, and uses LoRaWan, by means of the The Things Network, to communicate. It currently holds sensors for temperature and humidity, but is prepared to also measure sunlight exposure, rain fall and soil humidity / aridity. It also has a GPS antenna, to capture the location of the device correctly.

It had been a good while since I last handled a soldering iron, but following the ‘fit for all’ building instructions after a while I ended up with a ready device. After loading the right software, it became sensor 51 in the Measure Your City network. The second stage was building a hut for the sensor device, so it measures adequately: shielded from direct sunlight, with air allowed to float around it. This so it matches up with the standards that normal metereological measurements adhere to. After a few hours me and half a dozen or so others had their own sensor-hut to install at home.

the finished device

the hut for the sensors

I haven’t properly installed the device yet: the hut still needs a white coat of paint to reflect sunlight, before mounting it in our garden at about 2 meters height. It is already taking measurements however, and it can be followed through the online database of the network’s measurements. If you look at the current data for my sensor 51, you see it also hasn’t measured its location yet. If that persists as I properly mount it outside, there might be something wrong with the GPS antenna. The temp readings are still in-house readings, and do not reflect outside temperatures.

hello world: first data log entries

I will be running a The Things Network gateway in the near future (when the Kickstarter project delivers) as well, and helped initiate a LoRaWan/The Things Network group in my previous home city Enschede. Building this sensor-hut is the first foray into exploring how I will use that cheap IoT infrastructure currently emerging in the Netherlands. I am looking to add other sensors, along the lines of what e.g. FabLab Barcelona and Waag Society have created with the smart citizen kit, or this project from Freiburg measuring particulate matter in the air.

UPDATE: GPS is working now that the sensor is placed outside. Still need to paint it white though.

Meetjestad.nl sensorhut
Sensor hut in its intended spot in the garden