Itineraries to facilitate the publication of local open data using the AOC portal (3/3)
This post is over 1 year old. Content may not be up to date.
OPEN DATA: AN OPPORTUNITY
The open data, the data sets produced or collected by public bodies that are made available to the public, have great potential value and are essential to ensure the transparency of public administrations, efficiency and equal opportunities in of creating wealth.
This is the latest publication, out of a total of three, with which we wanted to show you an overview of the state of data open to the local world and propose an itinerary based on three phases to encourage the use of data open to your body.
OPEN DATA AND ITINERARIES PROPOSED BY THE AOC
Third phase: we begin to reap the benefits of linking open data and transparency
Open data to comply with the law of data reuse, to be more transparent, offer a series of public information to the public in open format… In this last stage we want to start remove internal fruit to the open data that is published and make life easier for transparency publishers.
In this last phase we want to encourage the automated relationship of the information published in open data with the items of the transparency portal: this need long claimed from the local world is already possible.
We automate transparency automatically and from the source
The AOC's transparency portal makes it easy to link automatic views (such as data tables, graphs, or maps o), created in the open data environment, to any transparency item. This option is available on all the sets of items in the transparency portal, be they items that are offered by default to comply with Law 19/14, as on items of own creation.
To explain this functionality we will do so using the example of theCity Council of Sant Just Desvern and the automation of municipal facilities:
Sant Just Desvern has a manual maintenance item on its transparency portal called “municipal facilities”
The city council wants to improve the information of the item while optimizing its flows from its back office and improving its views. To do so will be helped by open data.
Sant Just Desvern has the AOC's open data portal with self-management capacity.
He has created an equipment CSV that publishes to open data automatically and has made two views: a table and a map.
And how will the City Council link these open data resources to the transparency item in question?
Just go to the transparency editing environment. Enter the item and associate the different available open data resources:
You will need to select “Add open data view”, Select“Municipal facilities”And link to it, for example the map generated from the open data environment. Specifically:
Once selecting the data set (Equipment) you will need to define the detail of the selected resource (in this case a map, but it could be the table, a graph…):
The result is a perfect relationship between the Open Data Portal and the Transparency item and all in an automated way:
Finally, we incorporate three real examples of automated transparency items via open data. In this case they are all from theCastellar del Vallès Town Council, a pioneer in the use of this evolution.
CASE 1: List of suppliers, contractors and / or contractors (family: contracts, agreements and subsidies)
Before: Manual publication of an excel annually by the transparency editor based on information provided by the accounting team.
After: Automatic integration with the management database, with the addition of information to the CSV and automatic publication, and automated, to the transparency item.
Example of Castellar del Vallès: list of suppliers, contractors or contractors
CASE 2: “Directory of associations and entities” (family: participation)
Before: Manual publication of an excel (annually)
After: Obtaining the information via the database of the municipal website (in external hosting), and publication in the transparency item.
Example of Castellar del Vallès: Directory of associations and entities
CASE 3: “Free wi-fi internet access point” (own item to family of services and procedures)
Before: Manual publication of an excel annually
After: Obtaining the information via the database of the municipal website (in external hosting), and publication in the transparency item.
Example of Castellar del Vallès: Free internet access points
conclusions
Enhancing open data is no easy task. Open government in general, and obligations regarding transparency and open data publication in particular, mean that public administrations move out of the comfort zone with the consequent resistance to change and innovation, and often the approach that it is done to a minimum towards a mere observance of the laws.
And we could go on with other arguments that do nothing more than put "sticks in the wheels" to encourage the reuse of public sector data. Such as lack of technical knowledge, human or economic resources. We could also cite the potential technological or organizational problems such as the need to have standards, roadmaps… to, finally, also enter into more "pilgrim" arguments such as the feeling of "unnecessary" or "passing fad", extremely important due to the difficulty involved in managing change, and which are often used from both technical and political levels.
But we need to make progress and not because specific laws such as the reuse of public sector information or transparency laws say so, but because more data reuse can be synonymous with greater transparency, better accountability, improved credibility. of our institutions, and even of a higher quality citizen participation, that is, the foundations of open government.
And to all these arguments from the AOC we add a new one: to advance in the open data to be more efficient, automating the information to transparency from the origin: to do the work alone and to incorporate in the items of transparency good graphical resources such as data tables, graphs or maps that, coming from the open data portal, are updated daily.
So we put at your disposal a wide range of resources. Starting with the AOC's own open data portal at no cost, completely adaptable to your needs so that you can start creating your own data sets and relate them also transparently, to manuals, guides, models, etc. We hope that this whole series of resources will help you to make a firm commitment to promoting open data in your organizations.