Ulla Jelpke, Jan van Aken and Christine Buchholz (German MPs – die Linke), today published a document about public recruiting events of the German army. Events like this, especially if targeted on school children and teenagers, have been the subject of fierce public discussions for quite some time.
We filtered the given information to show the location of the people attending the events and not the venue. A first look at the map shows a slight accumulation of events in rural regions (possibly related to higher unemployment rates). It would be interesting to correlate the data with other sources.
We extracted the tables from the pdf file using tabula, a helpful little tool, which lets you convert pdfs directly on your computer (great for sensitive data). The next step was to clear and categorize the data, geocode it and upload it to cartodb.
The aim of this blog post is not to show you the best possible map design but to point out that with today’s tools everything is mappable – even on a very short notice: The whole process took us about 1,5 hours (so there could still be errors in the data!).
Some of you may have heard of Code for America
. It’s an awesome program that encourages civic hackers, developers and designers to use their skills for the public good. Similar programs exist in several other countries – and now there is a German divison
Mappable was excited to support the launch by organizing the Hamburg Open Data Day on February, 22 together with Marco Maas
. The event was a full success with close to 30 people coding, mapping and discussing the whole day (and into the night). Some results can be found on the Open Data Day Hackdash
Encouraged by the event we are now in the process of organizing a regular monthly meetup and forming an ‘OK Lab Hamburg’ (equivalent to the Code for America Brigades). The first one will take place on April 7. So drop by if you’re in town.
We’ve received a lot of (mostly positive) feedback for our last project “Atlas der Nichtwähler / The Geography of Nonvoters” which visualized the spatial distribution of nonvoters for the German federal election in 2009.
One weakness of the presentation was the lack of information about the relative number of nonvoters for each voting district. Basically, by mapping every nonvoter we produced a map which looks almost the same as a visualization of the current population density.
As a consequence we’ve decided to vary the style of our map for the results of the 2013 election by additionally displaying the percentage of nonvoters for each district by diverging colors.
The results are quite interesting: More than two decades after the reunification there is still a significant gap between voters in the eastern and western parts of Germany. Especially rural parts of eastern Germany have a considerably low turnout. This is sad but in no way surprising given their demographic, economic and social situation. The refusal to cast a vote is directly connected to factors like wealth and education. The suburban regions around cities like Berlin, Hamburg or Munich therefore show higher turnouts.
Interesting and somehow surprising is the fact that some counties in Bavaria had quite low turnouts as well. Maybe voters were overly convinced that the CSU-party (who received over 50 % of the votes in Bavaria) would win anyway.
As Patrick already wrote, I’m now officially part of mappable.info and excited about the things lying ahead. My name is Achim Tack and my professional background is quite similar to Patrick’s: just like him I’m an urban planner. I’m currently working for a small Hamburg based consulting company. I spend most of my time on research projects, especially focusing on technical and social infrastructure systems in the context of demographic change.
To me it`s all about data – ways to acquire, clean and structure it and finally draw conclusions from it. Today data is generated everywhere – from mobile phones to sensor systems for traffic control or environmental monitoring – and a lot of it is mappable. This is why I’m joining this blog.
As well as complex, long-term projects, I enjoy working on spontaneous ideas and mini projects for fun (some of them can be found on my personal website) and from today on I will publish some of them here.