Hackathon #ODD 14 Barcelona
On Saturday 22 February, International OpenDataDay, ODD, after the interesting presentations we talked about on our previous post (and also after gulping a sandwich and a cup of coffee – thanks Brian and Marco!), opengov.cat coordinated a hackathon for the first time. It was in the great working space Makers of Barcelona.
A hackathon is a meeting of journalists, programmers and developers to work on a specific project. There were about twenty people and we suggested three challenges to make different information about our Public Administration and autonomous government of Generalitat de Catalunya more accessible . We thought one or two would be chosen but our attendants’ skills were so great that they added a new challenge to our list and we ended up working on all our suggestions!
The budget of our autonomous government for 2014 had been released in a reusable format on the Generalitat opendata portal only a week before, and we had exchanged a few tweets about it even before their final version was passed by Parliament on 23 January. (Translation: Hello, when will your budget dataset be available in opendata? – Will you post your budget 2014 on opendata? – We plan to publish it next week. Thank you – Which day next week? Thank you.)
(The budget is available on our opendata portal – Thank you very much for posting budget 2014)
We continue working with openspending.org and, together with openkratio, we will soon contribute to launching historiasdegasto.org, the Spanish version of spendingstories.org. All of them are projects of the Open Knowledge Foundation.
Enter senior official’s salaries and allowances on a spreadsheet so as to have it in a reusable format.
Such information started to be available in the Government and President section of the Generalitat transparency portal in PDF format last summer, with no metadata about each file. It is not easy to use, but it is better than nothing: the story We’ve won the Grand Prize, 627.45 euros per month derived from it.
Here in retribucions_README you can find the technical explanation about how and with which software the documents were cleaned.
Familiarise ourselves with the Generalitat 2014 budget dataset, the law that regulates them, the concept of chapters, items and other; compare it to the 2012 budget (extended to 2013), to see which concepts are no longer there and work out increases and decreases. Later I was given this interesting link which clearly details everything, straight from the Catalan Public Administration School.
Each budget file has around 12k rows and over 25 columns. We didn’t know how to go about it and it is not easy if you aren’t an expert. As we aren’t, we looked for and found people who are… and they want to help us! Meanwhile, we review basic mathematical and statistical notions.
We are working on budget changes in different Generalitat organizations and we hope to be able to tell you more about it soon.
A girl who attended the morning presentations stated: “I can only do maps. If I can help, I’ll stay for the hackathon.” We quickly rummaged through what we had on ice at opengov.cat and found a half-made map of the Generalitat Departaments buildings, with all the available (or non-available) contact information for each one: address, phone, webpage, email, twitter.
In many cases, a horrible form, one of those that ask for all your personal information but leave no trace of your information request, replaces the contact email. A form like this.
We had made the map some time before but we didn’t like its format, so it remained unpublished. The new one will be better and properly made, from a spreadsheet and using cartodb software.
If you key in”periodismo de datos” and “2013” o “2014” in the search box, you’ll see the videos of all the sessions held since September 2013.
(PUBLICITY – In the first session, in September 2013, we presented this project!)
Just an addition: Thanks everybody who organised, participated and helped (specially @doublebyte), and happy opendata!!