I wrote a simple report mining tool, Klupu, designed to extract and visualize data from meeting minutes of various governing bodies of city of Jyväskylä. Klupu is a Finnish word for flail; a tool used for separating grains from husks. Grains of knowledge, in this case.
Klupu can be seen in action at klupu.tjjr.fi.
The idea for this project came from the student union of the university of Jyväskylä (JYY) and it's newspaper, Jylkkäri. I read about the call-for-data-journalism-volunteers, made by the editor-in-chief, Jarno Liski in his blog post. One of the goals was to extract relevant information from the meeting minutes into a database and to find out how the decisions are made and by whom. (For example, how often decisions are based solely on proposals made by city officials?) In a bigger picture, the goal is to unite software developers and journalists for various data-journalistic purposes.
Following steps were taken to create the map:
- Fetch street addresses (in nominative case) from Itella's zipcode service.
- For each address, generate multiple grammatical cases with great decliner tool made by Joel Lehtonen.
- Search meeting minutes for addresses, taking into account all generated cases.
- Geocode all found addresses to coordinates.