The open data portal of the Provincial Deputation of Cádiz, supported by OGoov, awarded best Open Government project in 2017 CNIS.

On February 24, during the CNIS 2017 Congressional awards ceremony, the Open Data portal of the Provincial Deputation of Cadiz, supported by OGoov – our Open Government solution – was recognized as the best project in the Government category Open: Transparency, Citizen Participation and Collaboration. We wanted to dedicate some lines to this award received by one of the clients of our platform.

The new Open Data Portal of the Provincial Deputation of Cadiz was selected as the best Open Government project in its category, competing with other very attractive proposals presented to the VII National Congress of Innovation and Public Services -CNIS 2017-.

In this seventh edition of the CNIS, 61 candidatures of 38 different institutions have been presented, so the award granted to the Provincial Deputation of Cadiz has a special value.

About the CNIS Awards

CNIS awards are a recognition of the good practices and experiences made by pioneering public institutions in different categories such as:

  • The application of the National Schemes
  • Innovation
  • Smart Cities
  • Electronic management
  • Open Government, Transparency and Participation

Likewise, accommodates any other area of development that adds value to public services, allowing a more efficient management of it. In this call, a total of 14 awards have been given, the Provincial Deputation of Cadiz, with its new Open Data Portal has been recognized as the best Open Government project.

The New Open Data Portal of the Provincial Deputation of Cadiz supported by OGoov, the best Open Government project.

The new Open Data Portal of the Provincial Deputation of Cadiz has been migrated to the OGoov platform, in order to comply with all the requirements established by current legislation (Royal Decree 1495/2011 of October 24 and the Resolution of February 19 2013, of the Secretary of State for Public Administration, which approves the Technical Rule for Interoperability of Re-use of Information Resources).

With this migration to the OGoov platform, in addition to complying with the current legislation, the Provincial Deputation of Cadiz  wanted its Open Data portal to comply these objectives

  • Generate and stimulate the economy
  • Improve Transparency
  • Reuse public information
  • Being a source of innovation

All this is possible thanks in part to the technological features that OGoov has, our Open Government solution.

What makes OGoov special?

What differentiates OGoov from other platforms is its easy use and extensive facilities for the citizen to access and analyze the data that the Administration opens. The platform is composed of several open source components which we will describe below. With these components, data sets can be loaded very easily while providing a powerful interface for visualization and analysis of them.

CKAN

The  CKAN data catalog manager is supported by a broad user and developer community and is used by the most representative portals worldwide. Without touching the core of CKAN in OGoov an extension is added that personalizes all NTI metadata (mandatory and optional) and at the same time offers multi-language facilities to sets and distributions in CKAN.

WordPress

CKAN is enriched with a presentation layer supported by the most well-known and used in the market CMS (Content Management System), WordPress, with a very simple user interaction and a very important support of the community to offer an attractive and powerful presentation layer, incorporating the use of a powerful library of tables and visualizations.

Apache Marmotta

The platform has a semantic server (Apache Marmotta) that allows it to be able to store and manage semantic data and the publication of a SPARQL point for semantic queries.

Real Time Open Data (RTOD)

RTOD  is a middleware that facilitates the consumption of dynamic content staying in different vendor systems from a single access point.

There is, in any organization, a great system heterogeneity, products and back-ends whose information is susceptible of being published in the Portal of Open Government / Open Data. These systems manage the information in different structures and media, using on the one hand their own sets of metadata, norms for the structuring and ordering of the contents and on the other, different mechanisms to access information by other systems.

Therefore, the main problem that resolves RTOD is the automated extraction of content from different institutional back-ends to incorporate them into an open data catalog.

Currently RTOD offers different alternatives for the extraction and automated updating of contents through drivers.

It is known as RTOD driver that implementation that allows the communication between the RTOD server and a backend provider, so that the information available in the second can be made available to the systems interested in the first.

RTOD currently has drivers for the following vendor systems:

  • SQL (MySQL, PostgreSQL, Oracle Database, Microsoft SQL Server and Microsoft Access)
  • Rest (XML / JSON)
  • FIWARE (Orion Context Broker)
  • Binary Files (images, compressed formats, etc.)

Another major advantage of RTOD is its ability to add semantics to content extracted from providers. That is, RTOD is able to offer content providers in formats with semantic loading such as RDF/XMLTurtle or N3 for later storage in a Triplestore

RTOD provides users / reusers with a REST interface for the content query. The main advantage of this interface is its ability to offer content in nine different serializations: XML, RDF / XML, RDF / N3, RDF / TURTLE, JSON-LD, HTML, JSON, CSV and ATOM.

The portal developed from the components described in the previous paragraphs is also federable in a natural way by strictly conforming to all the requirements of the NTI: semantics and glossary, schema of catalog URIs and metadata, data sets and distributions (both mandatory as optional).

Practically all institutional levels have or will have open data portals in the near future that can be enriched by federating data from lower-level portals.

The platform is prepared to generate the necessary file so that the Open Data Portal can be federated by any regional, national or supranational portal. In particular we generate a RDF / XML based on the DCATNTI to federate with the Spanish open data portal and through it in the European data portal.

Likewise, a DCAT-AP is generated that describes public sector data sets in Europe, expanding the possibilities of federation.

To conclude, we would like to point out that, although currently the Open Data portal of theProvincial Deputation of Cadiz that has been awarded like the best Open Government project, has 25 data sets and 96 distributions, this number will increase rapidly during the current year increasing both in quantity as well as in the quality of the datasets taking advantage of the potential that RTOD provides to the OGoov platform.