OSM: Going Back in Time

I’ve been playing around with the full planet file to look at going back in time in OSM. Mainly, this is to look at how Ramani Huria’s data has evolved over time and is all part of extracting more value from Ramani Huria’s data.

I’ve been playing around with the full planet file to look at going back in time in OSM. Mainly, this is to look at how Ramani Huria’s data has evolved over time and is all part of extracting more value from Ramani Huria’s data. This process wasn’t as straightforward as I had hoped, but eventually got there – also, this isn’t to say that this is the only or best way. It’s the one that worked for me!

To do this, you’ll need a pretty hefty machine – I’ve used a Lenovo x230 Intel i5 quad core 2.6ghz, 16gb of ram with over 500gb of free space – This is to deal with the large size of the files that you’ll be downloading. This is all running on Ubuntu 16.04.

Firstly, download the OSM Full History file. I used the uGet download manager to deal with the 10 hour download of a 60gb+ file over 10meg UK broadband connection. Leaving it overnight, I had a full file downloaded and ready for use. Now to set up the machine environment.

The stack is a combination of OSMIUM and OSMconvert. On paper, the OSMIUM tool should be the only tool needed. However, for reasons that I’ll come to, it didn’t work, so I found a workaround.

OSMconvert is easily installed:

sudo apt-get install osmctools

This installs OSMconvert other useful OSM manipulation tools. Installing OSMIUM is slightly more complicated and needs to be done through compiling by source.

Firstly, install LibOSMIUM – I found not installing the header files meant that compilation of OSMIUM proper would fail. Then use the OSMIUM docs to install OSMIUM. While there is a package included in Ubuntu for OSMIUM, it’s of a previous version which doesn’t allow the splitting of data by a timeframe. Now things should be set up and ready for pulling data out.

Dar es Salaam being the city of interest, has the bounding box (38.9813,-7.2,39.65,-6.45) – you’d replace these with the South West, North West point coordinates of your place of interest, and use OSMconvert, in the form:

$ osmcovert history_filename bounding_box o=output_filename

osmconvert history-170206.osm.pbf -b=38.9813,-7.2,39.65,-6.45 -o=clipped_dar_history-170206.pbf

This clips the full history file to that bounding box. It will take a bit of time. Now we can use OSMIUM to pull out the data from a date of our choice in the form:

$ osmium time-filter clipped_history_filename timestamp -o output_filename

osmium time-filter clipped_dar_history-170206.pbf 2011-09-06T00:00:00Z -o clipped_dar_history-170206-06092011.pbf 

This gives a nicely formatted .pbf file that can be used in QGIS (drag and drop), POSTGIS or anything else. As the contrast below illuminates!

Tandale, Dar es Salaam, Tanzania – 1st August 2011
Tandale, Dar es Salaam, Tanzania – 13th February 2017

Enjoy travelling back in time!

All map data © OpenStreetMap contributors.

Data Driven Governance

At the Africa Open Data Conference I was fortunate to have a chat with Juliana Letara, the Town Planner for Kinondoni Municipality and Osiligi Lossai, the Ward Executive Officer of Tandale. We discussed the recent community mapping, how they are beginning to use the maps and the data and some unexpected outcomes.

A longer blog will be incoming on how data is being used to support governance in Dar es Salaam. Personally, I’m still digesting some of the implications and potential of what they’re discussing, regarding the potential impact that Ramani Huria (also here http://ramanihuria.org) could have and is having in Dar es Salaam.

Starting Ramani Huria – Mapping The Flood Prone Areas In Dar es Salaam

Four years ago, in August 2011 I was fortunate to manage the community mapping of Tandale. It was an experience that irrevocably changed my professional direction and interests. Over a month I trained and worked alongside brilliant students and community members, who were all focused on getting an open map of Tandale, something that had never been accomplished previously. When it was done, the reception across civil society and government was positive and intentions on scaling the pilot to the city were mooted but for one reason or another it never quite made it. Then in December, floods hit the city. In dense informal urban environments such as Tandale these floods are fatal and dramatically change the landscape as well as causing mass damage to survivor’s livelihoods and assets. Mitigating these floods are hard – where do you start in the fastest growing city in Africa? The population as of the 2012 census currently stands of 5 million, with projections showing it could grow to 10 million by 2030.

This rapid and unplanned urbanisation is in part the cause of flooding: the infrastructure with which to cope with high rainfall, such as drains and culverts, were not built alongside residential dwellings. This is especially acute in the unplanned, informal urban settlements where a majority of Dar es Salaam’s residents reside. The theory here is quite simple: If that if you can identify where it floods, you can either install or upgrade infrastructure to ameliorate the situation for residents. Unpacking this, the crux of the issue falls to two main points, governance and data.

Ramani Huria – Swahili for “Open Mapping” – is a operationalization of this theory of change. In March 2015, a coalition from across Tanzanian society, composed of the City Council of Dar es Salaam, the Tanzanian Commission for Science and Technology (COSTECH – under the Ministry of Science, Communication and Technology), the University of Dar es Salaam, Ardhi University, Buni Innovation Hub supported by the Red Cross and World Bank supported the inception of Ramani Huria, with the goal of mapping flood prone areas in Dar es Salaam, making this data openly available and supporting the use of this data into government where decisions can be made to mitigate flooding.

Mapping Phases
Mapping Phases

It is a far cry from 2011 where just mapping the ward of Tandale was a large task. Ramani Huria consists of a pilot phase and four subsequent phases. To pilot, the wards Ndugumbi, Tandale and Mchikichini, with a combined population of over 100,000 residents were mapped in series. This process combined 15 students matched with community members, leading to maps of all features within that community. This information, focusing on drainage and water ways, is critically needed to help understand and locate flood prone areas; this is high priority in Dar es Salaam due to the damage that annual floods wreak upon the city and its residents. In this piloting phase, conducted from March to the end of June these three wards were mapped, in part to generate the data that will generate flood inundation models and exposure layers but also to pilot the data model and gel the team, prior to Phase One.

Scale Up Workshop
Scale Up Workshop – https://www.facebook.com/ramanihuria

Phase one on paper is quite simple. Take 150 students from the University of Dar es Salaam’s Department of Geography and Ardhi University’s School of Urban and Regional Planning on industrial training, hold an inception workshop, deploy this contingent across six wards and work with community members to replicate the pilots, but running in parallel. At the time of writing, mapping is ongoing in six communities: Msasani, Keko, Makumbusho, Mabibo, Makurumla and Mburahati. According to the 2012 NBS census, these wards have a combined population of over 280,000 residents. Phase one was kicked off on the 6th of July and will run until the 14th of August.

Field Survey - https://www.facebook.com/ramanihuria
Field Survey – https://www.facebook.com/ramanihuria

Phases Two and Three, will integrate community volunteers from the Red Cross, these volunteers are committed to creating community level resilience plans. These plans will use the data produced by the mapping to create resident evacuation routes and aid Ward Exective Officers with planning decisions among many other uses. Additionally, with embedded long term volunteers monitoring change in their wards, this will hopefully result in detailed up-to-date maps in rapidly changing urban areas.

InaSAFE Training - https://www.facebook.com/ramanihuria
InaSAFE Training – https://www.facebook.com/ramanihuria

Phase Four unfortunately sees the students depart from the project, due to their graduation. With a remaining contingent of around 30 mappers, mapping will continue until February 2016. These phases cover the data component, consequently alongside these phases are dedicated training events aimed at building capacity to use and deploy this data in real world situations. On the 20th July the first such workshop series took place, with representatives from the Prime Minister’s Office for Disaster Management Department being trained in spatial analysis in QGIS and risk modelling using the QGIS plugin InaSAFE. A series of these workshops will take place, placing the data into the hands of those responsible for the city.

While this is ongoing in Dar es Saalam, you could get involved wherever you are in the world, through the Missing Maps project. Missing Maps is a collaboration between the Red Cross, Doctors Without Borders and Humanitarian OpenStreetMap Team, aimed at digitising “the most vulnerable places in the developing world”, but primarily do so by crowdsourcing the digitisation of aerial imagery. At the moment, there are three tasks for Dar es Salaam:

By helping digitise the buildings and roads, using the recent drone and aerial imagery, the process of mapping is faster, allowing the community mappers to focus on the detail of flood data. Additionally, the data from Ramani Huria is all placed into OpenStreetMap, its code is on Github and content available from Flickr and Facebook, all with an open licence. Please get involved!


Written on a plane somewhere between Tanzania and the United Kingdom


On the 3rd to the  5th of April I attended GISRUK (Geospatial Information Research in the United Kingdom) to give a paper on Community Mapping as a Socio-Technical Work Domain. In keeping with Christoph Kinkeldey‘s love of 1990s pop stars Vanilla Ice made a second slide appearance, leveraging the fact it’s a very technical academic title. In short I’m using Cognitive Work Analysis (CWA) to create a structural framework to assess the quality (currently defined by ISO 19113:Geographic Quality Principles – well worth a read…) where there is no comparative dataset.

CWA is used to assess the design space in which a system exists, not the system itself. In taking a holistic view and not enforcing constraints on the system you can understand what components and physical objects you would need to achieve the values of the system and vice-versa. In future iterations I’m going to get past first base and look at decision trees and strategic trees to work out how to establish the quality of volunteered geographic data without a comparative dataset. Building quality analysis into day one, as opposed to being an after thought.

Written and submitted from Home (52.962339,-1.173566)


Dictator/Benevolent: Janus, Dichotomy?

Taarifa is one of the best things I’ve been involved in. In various forms it’s had shout outs in the New York Times to Random Hack Of Kindness. One of my tasks is to help deploy it in Uganda soon. I recently sent this email to the Taarifa development mailing list. I feel that the role of a founder in a project always needs to be considered. I’m wondering what other people think?


Taarifa is a platform that is fix my street for slums. I’m unsure whether this post is a massive shout out to my ego or what. However I want to start a discussion on the role of the founder in community projects, be them open source or not. I do so mindful of a line from ‘Batman: The Dark Knight’ ringing loud and clear; “You either die a hero or you live long enough to see yourself become the villain.”

At this juncture I should point out my love for another open source project, Open Street Map. I owe a lot to many members of the OSM community, either directly or indirectly. The OSM project and its community has shaped who I am over the years. From an exchange student dragging his local girlfriend mapping because she had local knowledge to going down some deep rabbit warrens elsewhere in the world. I love OSM, I love what it stands for and I love its community to the point where at one stage my health was severely compromised. However things within haven’t been plain sailing with a simple comment of “We are the Board! Shape the project!” effectively a call to arms for the project’s betterment taken as a powergrab by the board -nb I’m not singling people out for this one, the thread is included for reference, good luck if you reach the end!

In my eyes the OSM and its foundation OSMF are making the world better. Viewing it like accounts, they’re contributing more to the black column than the red. In my eyes Taarifa is doing the same, and should continue to do the same until something better comes along, or the project is dead. A lot of people in the skype channel and email have thanked me for organising Taarifa, going to talk to people and the such like. The truth is I’m just a loud, talky person. At times when things are starting maybe that is what’s needed. In future probably not. Taarifa is potentially going to be a foundation, at the very least it needs to do something around it’s identity and outward communications. It’s to be discussed at the coming hackathon and I think we should welcome it! We need to discuss what we want our structure to be, is it anarchy, benevolent dictator, committee? I don’t know, but together we should. Future plans regarding funding, grants, deployments all come under this, at it’s core where do we see this going?

My input now I think is to create the culture or influence it. I want people to love Taarifa as I do. I think the community and what we’ve done and accomplished is phenomenal. As such I’d like to shout a call-to-arms to Taarifans and other developers looking at Taarifa to JFDI if they believe strongly enough into it. Make things better, by consensus. If that isn’t working, fork the project and show why your solution is better. Then pull. Also difference is good. I believe it is ingrained in the Taarifa community’s inception that by defending and debating our positions this makes OUR project better; Remember the whiteboard sesssions! Which as it’s a humanitarian project, enables better usage and happier users which does ‘GOOD’. We’re getting new members who weren’t at the hackathon – hello there! – joining. Every person I speak to, sees how Taarifa can make a big difference, people in Uganda are hopeful, in some small way, the world is watching!

So what about the position of the founder and the quote at the beginning? Is founder the best way description; in some ways you on this list now are founders. I want to be involved in Taarifa for as long as I can, but not at the forefront. People change, they loose their hunger, they get different skills sets. And this is a good thing! One of the most contentious things I have is a business card where I’m purported to be a “Geospatial Innovation Consultant”. Geospatial Consultant fine, using ‘Innovation’ however is esoteric and buzzword bingo. At some stage in my life I innovated, I took a risk and though it cost me very dearly it apparently paid off. Now I don’t really innovate, I research, I just ‘do’. Not necessarily innovation, that baton has been taken up by someone younger, better looking with ‘nicer’ hair than I. My role should be to help them – whoever they are – to innovate bigger and better than before. I guess I’m seen at the forefront of Taarifa at the moment. But as an open note, if you think you can do it better do it. The project is bigger than me, you and the community. At the moment very deep decisions are being made or will have to be made, and they’re made with the information we have now, not 20:20 hindsight. The best team at the time should be guiding and shaping those decisions, not yesterdays team. At the hackathon, I remember drinking some cola, looking at each of the developers hacking and thinking ” I’m the dumbest guy in the room”. Everywhere on our table people created frameworks or made coordinate reference systems. Really smart things and all of you should be damn proud.

The time will come where I will need to step aside as being shouty. This is a natural process, not requiring politicking or a ‘nasty’ process. So I rally “You are the founders, shape the project, own it”. Personally I’ve only ever been able to see as far because I stood on the shoulders of giants. Your shoulders. Thank you my friends.

Will see YOU at the hackathon!


Tanzanian Flooding/Start Of The Response

On the 22nd of December heavy rains and flooding hit Dar Es Salaam. Around 20 (that we know have died), leaving many thousands more homeless. This is clearly an issue. Over the short term there are issues with businesses, consumable goods and buildings destroyed. Over a longer term food shortages and public health issues like cholera and typhoid (caused by lack of access to water and clean sanitation) could become apparent.

As such gaining a view of what is going on ‘now’ is important, as this will help organisations like GFDRR and the World Bank among many other institutions make better decisions for the response. Common in disasters and crises has been the Ushahidi tool, however Tanzania has unique qualities which can be exploited in this situation. Step forward Envaya.

Envaya is a non-profit organisation based in the USA and in Tanzania developing and deploying software to aid community based organisations and civil society organisations in developing countries. For the past week or so I’ve been working with Envaya on various projects, importantly a questionnaire which will go out to Envaya’s network of CBO/CSOs to gain situational awareness many factors, including damage and access to water. From this information and data about the damage should then filter from the bottom to the agencies and organisations at the top to aid in their response.

Involvement of Community Organisations

Community Based Organisations Learning About Our Project
Community Based Organisations Learning About Our Project

The first community forum went well. It was deal breaker for the project in the sense that if we didn’t get the community to share our ideals and objectives, making them their own, then the project would fail. Now the map is basically complete for first draft. We have enough of a basemap so we can now support platforms like Ushahidi and enable blogs to be geolocated.

Collecting the data and producing the map, as I’ve previously mentioned is only a first step. The same can be said for involving the students and community members. By creating a small nucleus of highly engaged people, proficient in mapping and storytelling techniques understand the project, they can evangelise the project to others in their community. This ‘infects’ the community from the inside allowing for more people to interact and share the project without ‘outside’ involvement. This will in time hopefully reach a plateau where the entire process of updating the map, reporting and blogging becomes self-sustaining using only the initial equipment and investment.

With this in mind, in the build up to the final community forum of the project (where presentations will be made to the community as a whole ie. interested citizens, civil servants and politicians) we gave a ‘pre-release’ talk to ten community based organisations. The format for this was quite simple, the students introduced the map with it’s features and intended functionality and the community members introduced the storytelling elements.

Within this process I spent most of it being a photographer and an observer. It wasn’t quite seeing the monster you created evolve but when presenting both students and the community are owning the process. The community organisations engaged in a Q&A session then participated in reporting using Ushahidi.

During the Q&A many questions dropped out regarding the future of the project and how the map can be used further. Because we are still formulating the future strategy it is difficult to say what the next step will be, but it will be along the lines of franchising to other areas overseen by community, NGO/CBO and Ground Truth, constructing this framework will be taking place for much of the coming week.

We are also printing the map and distributing it. This is key; in using Open Street Map, the collected data is freely available for viewing and data analysis without restrictions like a prohibitive licence. However accessibility to computers and internet understandably is a problem in communities like Tandale. To enable the community to view their map we will be printing A2 maps for placement in the sub-ward offices and printing A4 sub-ward handouts.

By placing it in a communal areas for each of the communities, we aim to reduce the barrier of people using the map by making it accessible. This process has started with our small nucleus of students and community, expanded by involving community based organisations and will be expanded further by integrating the map into governmental offices at the sub-ward level. Having the map built into the fabric of the community from the beginning of the project should make further incremental additions easier.

Community organisations being fully involved in the project is the next step, the process has been started and the ball is rolling. However Eid is coming in the next week, so everything is going pole pole, Swahili for slowly slowly. However tangible results are starting to become very clear, on all levels with all stakeholders.

Written and submitted from Slipway, Dar Es Salaam (-6.75174,39.27117)