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!).