The video of the Conference "We extract juice from open data" is available
In the framework of theOpen Data Day 2022, the AOC Consortium, in collaboration with Tarragona City Council, Miravet City Council and Garcia City Council, held an online conference on March 10 where various experiences were presented to deepen knowledge of the data that administrations publish on their open data portals.
In a first speech, the data analyst and computer engineer of Tarragona City Council, Felipe Ruiz, showed the Tarragona open data portal and its resources, and made a first analysis from a set of grant data, to get to know the entities with the most grants in the municipality of Tarragona.
The Head of Open Government Service of the AOC Consortium, Ferran Farriol, advanced with another set of data: municipal debt. And based on a news item, he showed how to get to the data, and how to process it until the end of the year by making a map of municipal debt per capita.
Then it was the turn of the secretary-intervenor of Garcia City Council, Ivy Vidal, and the secretary-auditor of the Miravet City Council, Anna Jornet. With a very didactic experience, they explained how their councils are publishing data of interest to the public. Specifically, their experience was based on the publication of water quality data and how, since obtaining the data from the concessionaire, they worked on the publication and detailed visualizations (even from maps) in the portal.
Ferran Farriol spoke again with a second experience also focused on the field of the environment, to find out the expenses of the municipalities in the environment from the open budget data. This second experience was more focused on showing in detail the processes of preparation, transformation and loading of data, basic to be able to process the information. At the end of the experiment we were able to show in a simple way the detail of the per capita expenditures of the environmental bodies.
Felipe Ruiz then made a second intervention designed to teach different graphic resources that can enrich an open data portal. To do this, he focused his demographics on the city of Tarragona, and while browsing his portal he gave very interesting examples, all made from demographics available in the open on the open data portal of his city.
Finally, the head of service in the Strategy and Innovation Subdirectorate of the AOC Consortium, David Pastor explained an experience from the set of budget data, to answer whether municipalities with the promotion of e-government have managed to reduce paper spending. A very interesting and didactic example where open data was combined with advanced analysis solutions.
Open Data Day is a 10-year global initiative where groups from around the world create local events and use open data in their communities to create applications, visualize, open data, or publish. analysis. This is an annual event that seeks to promote open data knowledge worldwide.
