datos abiertos

The III National Open Data Meeting (better known by its acronym ENDA) took place on 31 May 2024 in the Gothic Hall of the Papa Luna Castle, in Peñíscola. The event was organised by the Diputación de Castellón, with the collaboration of the Diputación de Barcelona and the Government of Aragón. This Third Meeting took over from those held in Barcelona and Zaragoza in 2022 and 2023, respectively, thus closing the first cycle of meetings and giving way to three new organisers with new ideas and new challenges to face.

The main theme of the day was the promotion of the tourism sector. The objective was to ensure digitisation and easy access to open data in order to offer quality and sustainable tourism experiences.

Crucial issues related to effective management, strategic analysis and implementation of data in an increasingly information-driven world were addressed during the meeting. Round tables and conclusions of work carried out by experts in the months leading up to the congress provided a comprehensive view of the application of open data in the tourism sector and all its associated activities, with the aim of benefiting not only the public administrations themselves, but also the private sector and the general public.

 The III National Open Data Meeting lasted approximately eight hours and was attended by almost 100 people. The organisers decided not to broadcast the event live, as had been done in previous editions, in order to encourage spectators to attend the castle in person.

Start at 08:30 a.m

The event started at 08:30 in the morning with the staggered arrival of attendees and the distribution of accreditations. Half an hour later, at 09:00, the official inauguration of the Meeting was held by Marta Barrachina Mateu, President of the Provincial Council of Castellón. The event welcomed the attendees and thanked the organisers, especially the Diputación de Castellón, for their great work in organising, disseminating and convening the event.

At 09:15 the opening speech was given by José Norberto Mazón López, Professor of Computer Languages and Systems at the University of Alicante. José spoke about the importance of creating a data-driven society, not only at the Spanish level, but also at the European level. He highlighted that there has been an exponential increase in the value of tourism data compared to the first data that started to be collected way back in 2018.

He further stressed that such data is underpinned by 3 main axes, namely public administrations, private businesses and citizens, and that it is crucial that all three entities collaborate with each other to ensure the quality, integrity and reliability of the data.

Table 1: Tourism and the economy: a data space for growth and development

The first round table, entitled "Tourism and economy: a data space to favour growth and development", started at 10:00 and was moderated by Sonia Castro García-Muñoz, Coordinator of the Digital Public Services Department of Red.es. The speakers at this first round table were as follows:

• Sergio Ballentani, Head of the Comunitat Valenciana Geoportal/Tourist Map.

• Desam Garcia Sevilla, Technician of product creation for international promotion and tourism of the Diputación de Valencia.

• José Luis Galar, Head of the Analysis and Strategy Area of Aragon Tourism.

• Francisco Mestre, President of the Network of the Most Beautiful Villages of Spain.

This first round table dealt with the use of geographic data as a driving force for tourism thanks to the interactive services they can offer and which facilitate tourist movement. The need to use European standards to standardise the structure of the datasets and thus optimise the exchange of data between public administrations was also addressed, and it was stressed that Spain is currently the country most visited by tourists and one of the most competitive in the world in the field of tourism, highlighting the role played by private businesses and companies in the sector.

Once the first round table was over, there was a 30-minute break for coffee, stretching the legs and sharing impressions with the speakers and the rest of the attendees.

Table 2: How data can improve experiences and make tourism sustainable

After the break, the second round table, moderated by Borja Colón de Carvajal, Head of the Public Administration and Innovation Service of the Provincial Council of Castellón, began with a debate on how data can improve experiences and make tourism sustainable. This second roundtable featured the following speakers:

• Virginia Ochoa, Manager of the Castellón Provincial Council's Tourist Board

• Luis Falcón, President of the ASEDIE Geospatial Commission.

• Alberto González-Yanes, Deputy Director of Statistical Modernisation of the Canary Islands Statistics Institute (ISTAC).

• Enrique Crespo, Technical Advisor in the Directorate General for Transparency and Quality of Madrid City Council.

• Juan Carlos Lázaro López, Technical Manager of Open Data of the Government of Navarre.

The main topics discussed on this occasion were the use of open data to solve common problems of today's society in the field of tourism and how an intelligent use of these data can offer competitive advantages to administrations. To this end, a comparison was made of the situation in the province of Castellón, in the Canary Islands, in the city of Madrid and in the Community of Navarre.

This second round table discussion also focused on the main reasons why Spain is year after year one of the favourite destinations for tourists, concluding that up to 80% of visitors are attracted by the sun and beach product offered by our country.

Impact of open data

This was followed at around 13:30 by a brief presentation on a series of methodologies for measuring the impact of open data, given by Roberto Magro, coordinator of the Open Data Working Group of the FEMP Network and Deputy Director General for Youth, Children and Adolescents of Alcobendas City Council. Right after, Alberto Abella, Data Modelling Expert at Fiware presented the 4th report on open data in Spain. This round table was chaired by Ana Coroján, Head of Projects and Research at the NovaGob Foundation.

Roberto began by telling us how even today there are many public administrations that do not believe in data and, as such, either share bad data or do not share it at all. In this sense, he encouraged all attendees to make an effort to raise awareness among other public bodies about the importance of sharing reliable, truthful and quality data. It also called on re-users to make use of these data and make them available to citizens through data products such as visualisations and/or mobile applications.

Alberto presented the conclusions of the Cotec Foundation report on the reuse of open data in Spain. The main key points he highlighted in his presentation were that the number of open data portals had remained stable compared to the previous year, increasing the number of datasets available on them, but at the same time reducing the quality of their metadata, as well as the dissemination of this data to the public. Finally, he regretted that there are still 6% of the datasets that are either outdated or not available at all, which in his view is too high a percentage and should be minimised for the following year.

Table 3: Public management: Data-driven public policies to improve tourism activity

The third and last panel of the event took place after lunch, around 15:45 and was moderated by Vicent Rubio, Open Government Technician of the Castellón Provincial Council. This round table dealt with data-driven public policies to improve tourism activity, and consisted of the following speakers:

• María Tormo Casañ, Deputy for Participation and Transparency of the Castellón Provincial Council.

• Montse Giró Torrens, Head of LabTurisme, Diputació de Barcelona.

• Joseba Asiain Albisu, Director General of the Presidency, Open Government and Relations with the Parliament of the Government of Navarre.

This roundtable addressed the main challenges faced by public administrations in opening up data, as well as the key solutions and strategies they have implemented to achieve this, and the benefits these solutions have brought them, especially in the field of tourism.

Among other things, the importance of street surveys was highlighted as a fundamental tool for gaining first-hand knowledge of citizens' impressions, as well as their nationality, motivations and purchasing power, in order to be able to adapt the services offered to their needs.

Conclusions and closing of the event

Finally, the last block of the event was led by Marc Garriga, CEO of DesideDatum and rapporteur of the meeting, in which the main conclusions drawn throughout the session were presented, to finally introduce the next 3 organisers of the next triennium of meetings, which will be, in this order, the Government of the Canary Islands, which will organise the 2025 Meeting, the Government of Navarra, and finally the City Council of Madrid, which will be responsible for hosting the third and final meeting of this second phase.

Finally, as for the challenge for this year, it is still to be defined and the plan is to make it public in the coming weeks, and then include it on the website.

For many people, summer means the arrival of the vacations, a time to rest or disconnect. But those days off are also an opportunity to train in various areas and improve our competitive skills.

For those who want to take advantage of the next few weeks and acquire new knowledge, Spanish universities have a wide range of courses on a variety of subjects. In this article, we have compiled some examples of courses related to data training.

Geographic Information Systems (GIS) with QGIS. University of Alcalá de Henares (link not available).

The course aims to train students in basic GIS skills so that they can perform common processes such as creating maps for reports, downloading data from a GPS, performing spatial analysis, etc. Each student will have the possibility to develop their own GIS project with the help of the faculty. The course is aimed at university students of any discipline, as well as professionals interested in learning basic concepts to create their own maps or use geographic information systems in their activities.

• Date and place: June 27-28 and July 1-2 in online mode.

Citizen science applied to biodiversity studies: from the idea to the results. Pablo de Olavide University (Seville).

This course addresses all the necessary steps to design, implement and analyze a citizen science project: from the acquisition of basic knowledge to its applications in research and conservation projects. Among other issues, there will be a workshop on citizen science data management, focusing on platforms such as Observation.org y GBIF.  It will also teach how to use citizen science tools for the design of research projects. The course is aimed at a broad audience, especially researchers, conservation project managers and students.

• Date and place: From July 1 to 3, 2024 in online and on-site (Seville).

Big Data. Data analysis and machine learning with Python. Complutense University of Madrid.  

This course aims to provide students with an overview of the broad Big Data ecosystem, its challenges and applications, focusing on new ways of obtaining, managing and analyzing data. During the course, the Python language is presented, and different machine learning techniques are shown for the design of models that allow obtaining valuable information from a set of data. It is aimed at any university student, teacher, researcher, etc. with an interest in the subject, as no previous knowledge is required.

• Date and place: July 1 to 19, 2024 in Madrid.

Introduction to Geographic Information Systems with R. University of Santiago de Compostela.

Organized by the Working Group on Climate Change and Natural Hazards of the Spanish Association of Geography together with the Spanish Association of Climatology, this course will introduce the student to two major areas of great interest: 1) the handling of the R environment, showing the different ways of managing, manipulating and visualizing data. 2) spatial analysis, visualization and work with raster and vector files, addressing the main geostatistical interpolation methods. No previous knowledge of Geographic Information Systems or the R environment is required to participate.

• Date and place: July 2-5, 2024 in Santiago de Compostela

Artificial Intelligence and Large Language Models: Operation, Key Components and Applications. University of Zaragoza.

Through this course, students will be able to understand the fundamentals and practical applications of artificial intelligence focused on Large Language Model (LLM). Students will be taught how to use specialized libraries and frameworks to work with LLM, and will be shown examples of use cases and applications through hands-on workshops. It is aimed at professionals and students in the information and communications technology sector.

• Date and place: July 3 to 5 in Zaragoza.

Deep into Data Science. University of Cantabria.

This course focuses on the study of big data using Python. The emphasis of the course is on Machine Learning, including sessions on artificial intelligence, neural networks or Cloud Computing. This is a technical course, which presupposes previous knowledge in science and programming with Python.

• Date and place: From July 15 to 19, 2024 in Torrelavega.

Data management for the use of artificial intelligence in tourist destinations. University of Alicante.  

This course approaches the concept of Smart Tourism Destination (ITD) and addresses the need to have an adequate technological infrastructure to ensure its sustainable development, as well as to carry out an adequate data management that allows the application of artificial intelligence techniques. During the course, open data and data spaces and their application in tourism will be discussed. It is aimed at all audiences with an interest in the use of emerging technologies in the field of tourism.

• Date and place: From July 22 to 26, 2024 in Torrevieja.

The challenges of digital transformation of productive sectors from the perspective of artificial intelligence and data processing technologies. University of Extremadura.

Now that the summer is over, we find this course where the fundamentals of digital transformation and its impact on productive sectors are addressed through the exploration of key data processing technologies, such as the Internet of Things, Big Data, Artificial Intelligence, etc. During the sessions, case studies and implementation practices of these technologies in different industrial sectors will be analyzed. All this without leaving aside the ethical, legal and privacy challenges. It is aimed at anyone interested in the subject, without the need for prior knowledge.

• Date and place: From September 17 to 19, in Cáceres.

These courses are just examples that highlight the importance that data-related skills are acquiring in Spanish companies, and how this is reflected in university offerings. Do you know of any other courses offered by public universities? Let us know in comments.

In the medical sector, access to information can transform lives. This is one of the main reasons why data sharing and open data communities or open science linked to medical research have become such a valuable resource. Medical research groups that champion the use and reuse of data are leading this transformation, driving innovation, improving collaboration and accelerating the advancement of science.

As we saw in the case of FISABIO Fundation, the open data in the health sector foster collaboration between researchers, speed up the process of validating study results and, ultimately, help save lives. This trend not only facilitates faster discoveries, but also helps to create more effective solutions. In Spain, the Consejo Superior de Investigación Científica (CSIC) is committed to open data and some renowned hospitals also share their research results while protecting their patients' sensitive data.

In this post, we will explore how research groups and health communities are sharing and reusing data to drive groundbreaking research and showcase more inspiring use cases. From developing new treatments to identifying trends in public health, data is redefining the medical research landscape and opening up new opportunities to improve global health.

Medical research groups committed to working with shared data

In Spain, there are several research groups and communities that share their findings more freely through platforms and databases that facilitate global collaboration and data reuse in the field of health. Below, we highlight some of the most influential cases, demonstrating how access to information can accelerate scientific progress and improve health outcomes.

• H2O - Health Outcomes Observatory clinical data repository

H2O is a strategic public-private partnership to create a robust data infrastructure and governance model to collect and incorporate patient outcomes at scale into health decision-making at the individual and population level. H2O's approach puts patients in ultimate control of their health and ensures that only they exercise that control  and ensures that only they exercise that control. Hospitals from all over the world participate in this consortium, including the Spanish Hospital Universitario Fundación Jiménez Díaz and the Hospital Vall d'Hebron. The Spain Research Unit collects patient-reported health outcomes and other clinical data to build an observatory to improve patient care.

• Carlos III Health Institute: IMPaCT open science research projects

Within the framework of the IMPaCT infrastructure, different projects are being developed and approved as part of the Action in Health's grants for Precision Personalised Medicine Research Projects:

1. COHORTE Programme - Predictive Medicine
2. DATA programme: Data science
3. GENOMICS Programme - Genomic medicine

The information, data, metadata and scientific products generated in IMPaCT are open access, to make science more accessible, efficient, democratic and transparent. Hospitals and research institutes from all over Spain are participating in this project.

• POP Health Data: medical research project of the Instituto de Salud Carlos III (ISCIII) and the Platform of Patients' Organisations (POP)

This is a data project developed collaboratively between ISCIII and POP to improve knowledge and evidence on the clinical, occupational and social reality of chronic patients, and social reality of chronic patients, which is crucial for us. This initiative involves 36 national patient organisations, 16 scientific societies and 3 public administrations, including the Ministry of Social Rights and Agenda 2030, the Carlos III Health Institute and the Spanish Agency for Medicines and Health Products.

• European Cancer Imaging Initiative european project to provide cancer imaging and support cancer research.

One of the objectives of the European Cancer Plan is to maximise the potential of data and digital technologies such as artificial intelligence (AI) or high performance computing (HPC). The cornerstone of the initiative will be a federated European infrastructure for cancer imaging data, developed by the European Federation of Cancer Imaging (EUCAIM). The project starts with 21 clinical centres in 12 countries, including 4 Spanish centres located in Valencia, Barcelona, Seville and Madrid.

• 4CE: Research Consortium

It is an international consortium for the study of the COVID-19 pandemic using electronic health record (EHR) data. The aim of the project - led by the international international academic user group i2b2 - isto inform clinicians, epidemiologists and the general public about COVID-19 patients with data acquired through the healthcare process. The platform offers aggregated data that are available on the project's own website divided between adult and paediatric data. In both cases, the data must be used for academic and research purposes; the project does not allow the use of the data for medical guidance or clinical diagnosis.

In conclusion, the commitment to data sharing and reuse in medical research is proving to be a fundamental catalyst for scientific progress and the improvement of public health. Through initiatives such as H2O, IMPaCT, and the European Cancer Imaging Initiative, we see how accessibility in data management is redefining the way we approach disease research and treatment.

The integration of data analytics practices promises a future where innovation in healthcare is achieved faster, more equitably and efficiently, thus delivering better outcomes for patients globally.

Open data should be inherently accessible, meaning it must be available for free and without barriers that could restrict access and reuse. Accessibility is a fundamental and complex issue because it means that these data sets should not only be available in reusable formats but also that anyone should be able to access and interpret them.

To ensure that access to open data is democratic, it must meet fundamental accessibility criteria that affect both the platform (web) and the way its content is displayed (e.g., through visualizations). In this context, this post delves into the essential principles to ensure that open data is inclusive and useful for a diverse audience. Discover recommendations aimed at improving the accessibility of open data portals and platforms, as well as best practices for data visualization, with a focus on the importance of inclusive design that considers the needs of all users.

Levels of Web Accessibility

When focusing on the platform, open data portals can refer to the web accessibility specifications identified by the World Wide Web Consortium (W3C), the leading international organization for web standardization, which sets guidelines for web accessibility that a website should meet.

1. Perceivable: Information and user interface components must be presented to users in ways they can perceive, regardless of any physical or cognitive disabilities they might have.

2. Operable: User interface components and navigation must be operable. Therefore, users who use the keyboard instead of the mouse must be able to interact correctly with a webpage; no time limit should be imposed on users to complete interactions, and there should be ways to navigate and find content easily.

3. Understandable: Text must be clear and easy to understand, the user interface and navigation must be consistent and predictable, and webpages must help users when they make mistakes filling out a form, for example.

4. Robust: Content must be robust enough to be reliably interpreted by a variety of web browsers and other software, such as screen readers.

Each guideline has compliance criteria that can be tested. These criteria are classified into three levels: A, AA, AAA. The levels, from least to most, are:

• A (Minimum): All non-text content like images and videos must have textual alternatives; videos and audios must have subtitles; navigation should be possible using only the keyboard; the page must have a clear title and assigned language.
• AA (Acceptable): In addition to all level A requirements, other functionalities are added, such as live videos also having subtitles; the contrast ratio between text and background must be at least 4.5:1; text must be resizable up to 200% without losing content or functionality; text images should not be used.
• AAA (Optimal): This level requires all the features of levels A and AA, along with other requirements such as sign language interpretation for videos or a contrast ratio between text and background of at least 7:1.

Accessible Open Data Websites and Visualizations

Considering the conditions and recommendations set by W3C, the European Open Data Portal offers a Data Visualization Guide that includes best practices for accessibility in data visualization. Following the guidelines of this Guide, to respect inclusivity from the design stage, a good data visualization must meet three conditions: it must be perceivable, understandable, and adaptable.

• Perceivable: Colors must be adapted for people with vision problems, and the font size and contrast must be adequate.

• Understandable: The interface must be user-friendly and intuitive. Whenever possible, the graphic should be understandable regardless of the user's background.

• Adaptable: The visualization must be responsive, meaning it adapts to the dimensions of each electronic device, flexible, editable, or with viewing options for people with cognitive disabilities.

Once these three conditions are identified, we can analyze if our graphic meets them by paying attention to issues such as the use of an appropriate color palette for people with vision problems, good contrast, and understandable titles and text. It is also advisable to include alternative text (adapted for people with intellectual disabilities) and, when necessary, a visualization guide to understand the graphic.

Tools to Improve Accessibility

To apply accessibility principles in data visualization, we can use three resources:

• Accessibility Audit Tools: Conducting accessibility audits is a good practice, for example, using Chartability which analyzes websites considering all aspects related to inclusion.

• HTML: The fundamental web markup language was developed with accessibility in mind, so using its elements semantically correctly is a simple way to ensure a basic level of accessibility. This applies to the context of a visualization (which should use elements like headers and paragraphs correctly, for example), interactive elements (like links, buttons, and inputs), and the elements of a visualization itself. It is better to offer a visualization in HTML than in image format (jpg or png) whenever possible. When not possible, it is necessary to provide an accessible alternative (an alternative text, as mentioned earlier).

  • SVG: Scalable Vector Graphics (SVG) is a format for two-dimensional vector graphics, both static and animated, in Extensible Markup Language (XML) format, meaning it is composed of code and its specification is an open standard developed by W3C to generate accessible graphics.

• Datawrapper: Among many data visualization tools, Datawrapper offers the possibility to test accessible color palettes and write alternative descriptions, among other accessibility-related functions.

In summary, data visualization is a method to make a data set and its visualizations more accessible. Taking these accessibility tips into account and incorporating them by default into the design when presenting a data set visually will enrich the result and reach a wider audience.

Content developed based on the Data Visualization Guide from the European Open Data Portal: https://data.europa.eu/apps/data-visualisation-guide/accessibility-of-data-visualisation

The National Centre for Geographic Information publishes open geospatial data from the National Cartographic System, the National Geographic Institute and other organisations through web applications and mobile applications to facilitate access to and consultation of geographic data by citizens.

Geospatial data is published via web services and APIs for reuse, so in the case of high-value datasets, it can be used in a variety of ways high-value datasets such as geographic names, hydrography or addresses as required by the as required by the EUthe EU has already made these datasets available to the public by June 2024 as they are associated with major benefits for society, the environment and the economy.

But in the applications listed below, the geographic data are visualised and consulted through web services, so that for downloading the data, it is possible to use web services and APIs directly, through a platform accessible to any user with a wide range of geographic information, ranging from topographic maps to satellite images.

But not only data can be reused, also application software is reusable, for example, the Solar Energy Potential of Buildings visualiser which is based on a visualiser API, named API-CNIG and allows the same tool to be used for different thematic areas.

Some examples of applications are:

Solar Energy Potential of Buildings

Provides the photovoltaic capacity of a building according to its location and characteristics. It also provides the average over the year and a point grid to identify the best location for solar panels.

National Geographic Gazetteer

It is a toponym search engine that collects the names, official or standardised by the corresponding competent bodies , with geographical references.

Unified postal address calculator

It is a converter that allows to know the geographical coordinates (latitude and longitude in WGS84) of the postal addresses of a place, and vice versa. In both cases, the input file is a CSV file, supporting both coordinates and postal addresses.

Basic Maps of Spain

It facilitates connection to IGN services and to the CNIG download centre to obtain maps and routes. With this mobile application you can follow the routes of the National Parks or the stages of the Camino de Santiago. It allows you to plan excursions using maps, navigate and take guided tours, without the need for an internet connection after downloading data.

Map a la carte

It allows you to create a customised map using the printed series of the National Topographic Map at scales 1:25.000 and 1:50.000. It offers the possibility of defining its area, incorporating contents, personalising the cover, obtaining a pdf file and even acquiring paper copies by post.

IGN Earthquakes

It allows the reception and visualisation of all seismic events in Spain and its surroundings. It provides the distance to the epicentre of the seismic event and epicentral parameters, as well as the geolocation of the user's position and the epicentre.

Maps of Spain

It is a free mobile viewer ideal for hiking, cycling, running, skiing, etc., which uses as background cartography the services of the National Geographic Institute and another set of services from other Ministries, such as the Cadastral information of the plots provided by the General Directorate of Cadastre.

Camino de Santiago

It includes information of a cultural and practical nature on each of the stages (hostels, monuments, etc.), as well as a complete Pilgrim's Guide detailing what you should know before starting out on any of the routes. This application is based on ESRI software.

National Parks

Displays information on the history, fauna, flora and excursions in Spain's National Parks. It includes hundreds of points of interest such as information centres, accommodation, viewpoints, refuges and even routes through the parks, indicating their duration and difficulty. The app is available for download on Android e iOS. This application is based on ESRI software.

GeoSapiens IGN

It presents interactive maps, free to use and free of charge, to study the physical and political geography of Spain and the world. It consists of different games relating to the whole of Spain or by autonomous communities, the whole world and by continent.

In addition to the applications developed by the CNIG, which are also presented in this video this videothere are many other digital solutions developed by third parties that reuse open geospatial data to offer a service to society. For example, in the list of data reusing applications.gob.es you can find from a map that shows the fires that are active in Spain in real time in Spain in real time to an app that shows where the parking spaces for people with reduced mobility parking spaces for people with reduced mobility in each town.

In short, anyone can make use of the open geographic data of the National Cartographic System, the National Geographic Institute and other bodies published by the CNIG , thus extending the advantages offered by the availability of open geographic data. do you know of any other application resulting from the reuse of open data? You can send it to us at dinamizacion@datos.gob.es

The Multisectoral Information Partnership (ASEDIE) has published the twelfth edition of its "Report on the Infomediary Sector", that reviews the initiatives to boost the data economy in the country. In addition, this edition commemorates the 25th anniversary of the association in the sector.

In the 12th Report on the Data Economy in the infomediary sphere, ASEDIE provides accurate figures on the sector in Spain to continue its annual work of highlighting and conveying its size and importance. The presentation of this edition took place at Madrid International Lab's auditorium on 20 March.

The main findings of the study are summarised below.

 Law 37/2007 on the re-use of public sector information makesto have their own data catalogue compulsory for public administrations which, in turn, would contribute to the national catalogue(datos.gob.es). Some regional portals, in addition to hosting datasets, offer content, organise events and sign partnerships to spread the data culture. We analyse the case of Catalonia with its open data portal and its commitment over the last few years.

Open data in Catalonia: history of the last few years

Since the creation of its first open data portal in 2010, the Generalitat de Catalunya has published almost 1,200 open datasets.

It aims to promote the openness and accessibility of the data it holds, collaborating with various sectors of society, including academia, the private sector and civil society, to maximise the value of open data and encourage its use in decision-making and the development of solutions to current societal challenges.

Along these lines, the Generalitat de Catalunya reached a government agreement on open data strategy. This milestone places the openness and reuse of public information at the heart of the relationship between citizens and the Catalan public administration. Among the objectives of this approach, the document highlights the use of collective intelligence and the creation of public policies taking into account the needs of citizens. Since then, the Government of Catalonia has been committed to promoting its open data portal and encouraging its use, always respecting the principles of data governance.

In this sense, in 2022 the Open Data area became part of the Directorate General for Digital Administration, which conceives data as a strategic asset and lever of change for digital administration, with the ultimate aim of improving the public services offered by this administration. It is at this point that the Open Data area is reinforced by the strategic role of data in the framework of this public administration: open data becomes part of the data lifecycle, as an integral and essential element. Data Governance in the Generalitat de Catalunya is carried out through the Data Governance Model, which establishes the guidelines throughout the organisation, promotes the impulse of the data culture and involves all the key agents that must participate in this transformation process.

The document also includes the commitment of the Generalitat de Catalunya to adhere to the principles of the International Open Data Charter promoted by the Open Data Charter (ODC) network, in which more than 170 governments around the world currently participate, and which aims to integrate the culture and practice of open data in governments. Taking into account what ODC states in its International Charter, the data should be:

• Open by default
• Updated
• Accessible and reusable
• Comparable and interoperable
• To improve governance and citizen participation
• For inclusive development and innovation

The Government of Catalonia's commitment to opening up public sector data and promoting reuse was also evident in 2020 when it joined the Open Government Partnership. This organisation, which is committed to transparent, participatory, inclusive and accountable governance, is a global benchmark in terms of highlighting the use of open data for the betterment of society.

The same year in which Open Data Catalunya joins ODC, they also launched the first session of Cafè amb Dades: a series of informative talks in person and online in which a topic related to open data in the Generalitat de Catalunya is addressed.

Cafè amb Dades: a space to spread information about open data

These events organised by the Catalan open data portal are a space designed to share experiences and knowledge about open data and related topics. The lectures last two hours, are held in person and virtually, and the topics addressed depend on the topicality and/or interest of the audience, who can propose their ideas through a contact mailbox. The Àrea de Dades Obertes de la Direcció General d'Administració Digital organises these events based on the following values:

• Pedagogy: to raise awareness of the Catalan Government's open data strategy and its impact in different areas.
• Dynamism: offer short presentations with content that can be understood by everyone.
• Online work: organise participatory, open sessions that invite dialogue to create community.
• Application: to encourage attendees to incorporate the use of open data in their daily lives.

All sessions are recorded and available to the public. The last ones that have been held dealt with such relevant issues as water management using open data or data with a gender perspective.

Facilitating understanding of the data

The Generalitat de Catalunya recognises the importance of publishing data and facilitating searches, as well as promoting understanding of the data. With the aim of facilitating the search for data by Sustainable Development Goals (SDGs), the Government of Catalonia has classified the datasets on the portal by each of the SDGs , which can be accessed from a data viewer.

This classification also provides information on how departmental activity is being aligned around the SDGs and facilitates the search and re-use of SDG-related datasets.

Commitment to the dissemination of data culture

The portal of the autonomous community of Catalonia, in addition to hosting more than a thousand open datasets and disseminating face-to-face and virtual events on the application of its datasets in different areas, offers:

• Content that disseminates the data culture:
  
  • Web sessions, with all the digital news of the administration explained in 30-minute videos presented on the first Thursday of each month.
  • Interviews with experts on open data issues.
  • Specialised publications on eGovernment and Open Government.
  • News, which includes the latest news from the sector.
• Participation and representation in activities such as:
  
  • Open Government Week
  •  Open Data Day events
• Awareness-raising projects and collaboration with civil society
• Interaction with the reuser community
  
  • Contact via a request form
  • Information and resources for developers

The Generalitat de Catalunya's inventory of datasets

On the other hand, the Generalitat de Catalunya, in the process of opening up public data, has carried out an inventory of data, the first phase of which ended in 2022. This inventory, conceived as a single, ordered and descriptive register of datasets, aim to coordinate the data opening processes of this administration.

In this first phase, the inventory provided a tool for easy consultation of all available datasets and their descriptive information, as well as a cross-sectional view of the available information and a single language throughout the organisation.

Work is currently underway on a second phase of the project, which involves updating and maintaining the information collected in the inventory, as well as extending it to public sector entities.

If you don't want to miss anything, you can follow the Catalan open data portal on Twitter.

In summary, the Generalitat de Catalunya has a government agreement on open data strategy, a data governance model in place and a presence in international organisations such as the Open Data Charter or the Open Government Partnership. Its commitment to access and reuse of open data makes it one of the leading public administrations in Spain.

At datos.gob.es we echo the good practices in open data and related technologies that exist throughout Spain. If you would like us to discuss your initiative, please write to us at dinamizacion@datos.gob.es.

This application designed for iOS devices offers a wide range of tourist activities in the Autonomous Community of Castilla y León. It acts as a travel assistant, allowing you to create an itinerary according to the interests of each user.

TUrMISMO allows you to discover activities to do in the area, save your favourite places or plans, and trace your own route. To do this, it offers geolocated information on places as diverse as tourist offices, restaurants and wineries, organised excursions and ski schools, among many others.

The app was presented this year 2024 to the VII Open Data Competition of Castilla y León and uses open data provided by the Junta de Castilla y León.

The   Big Data Test Infrastructure (BDTI) is a tool funded by the European Digital Agenda, which enables public administrations to perform analysis with open data and open source tools in order to drive innovation.

This free-to-use, cloud-based tool was created in 2019 to accelerate digital and social transformation. With this approach and also following the European Open Data Directive, the European Commission concluded that in order to achieve a digital and economic boost, the power of public administrations' data should be harnessed, i.e. its availability, quality and usability should be increased. This is how BDTI was born, with the purpose of encouraging the reuse of this information by providing a free analysis test environment that allows public administrations to prototype solutions in the cloud before implementing them in the production environment of their own facilities.

What tools does BDTI offer?

Big Data Test Infrastructure offers European public administrations a set of standard open source tools for storing, processing and analysing their data. The platform consists of virtual machines, analysis clusters, storage and network facilities. The tools it offers are:

• Databases: to store data and perform queries on the stored data. The BDTI currently includes a relational database(PostgreSQL), a document-oriented database(MongoDB) and a graph database(Virtuoso).
• Data lake: for storing large amounts of structured and unstructured data (MinIO). Unstructured raw data can be processed with deployed configurations of other building blocks (BDTI components) and stored in a more structured format within the data lake solution.
• Development environments: provide the computing capabilities and tools necessary to perform standard data analysis activities on data from external sources, such as data lakes and databases.
  
  • JupyterLab, an interactive, online development environment for creating Jupyter notebooks, code and data.
  • Rstudio, an integrated development environment for R, a programming language for statistical computing and graphics.
  • KNIME, an open source data integration, reporting and analytics platform with machine learning and data mining components, can be used for the entire data science lifecycle.
  • H2O.ai, an open sourcemachine learning ( ML) and artificial intelligence (AI) platform designed to simplify and accelerate the creation, operation and innovation with ML and AI in any environment.
• Advanced processing: clusters and tools can also be created to process large volumes of data and perform real-time search operations(Apache Spark, Elasticsearch and Kibana)
• Display: BDTI also offers data visualisation applications such as Apache Superset, capable of handling petabyte-scale data, or Metabase.
• Orchestration: for the automation of data-driven processes throughout their lifecycle, from preparing data to making data-driven decisions and taking actions based on those decisions, is offered:
  
  • Apache Airflow, an open source workflow management platform that allows complex data pipelines to be easily scheduled and executed.

Through these cloud-based tools, public workers in EU countries can create their own pilot projects to demonstrate the value that data can bring to innovation. Once the project is completed, users have the possibility to download the source code and data to continue the work themselves, using environments of their choice. In addition, civil society, academia and the private sector can participate in these pilot projects, as long as there is a public entity involved in the use case.

Success stories

These resources have enabled the creation of various projects in different EU countries. Some examples of use cases can be found on the BDTI website. For example, Eurostat carried out a pilot project using open data from internet job advertisements to map the situation of European labour markets. Other success stories included the optimisation of public procurement by the Norwegian Agency for Digitisation, data sharing efforts by the European Blood Alliance and work to facilitate understanding of the impact of COVID-19 on the city of Florence .

In Spain, BDTI enabled a data mining project atthe  Conselleria de Sanitat de la Comunidad Valenciana. Thanks to BDTI, knowledge could be extracted from the enormous amount of scientific clinical articles, a task that supported clinicians and managers in their clinical practices and daily work.

Courses, newsletter and other resources

 In addition to publishing use cases, theBig Data Test Infrastructure website offers an free online course to learn how to get the most out of BDTI. This course focuses on a highly practical use case: analysing the financing of green projects and initiatives in polluted regions of the EU, using open data from data.europa.eu and other open sources.

In addition, a monthly  newsletter on the latest BDTI news, best practices and data analytics opportunities for the public sector has recently been launched .

In short, the re-use of public sector data (RISP) is a priority for the European Commission and BDTI(Big Data Test Infrastructure) is one of the tools contributing to its development. If you work in the public administration and you are interested in using BDTI register here.

The Provincial Council of Bizkaia the University of the Basque Country (UPV/EHU) and the Bilbao City Council collaborate in the Bilbao Bizkaia Open Data Classroom an initiative that aims to develop the use of open data from the two Biscayan institutions (Provincial Council and City Council) for use in university projects. The ultimate goal is that, thanks to this re-use, public services can be improved and new knowledge can be generated to contribute to the resolution of social problems.

The initiative, aimed at university students as well as teaching and research staff, was born as a way to research staff, was born as a a collaboration agreement between the three administrations (Provincial Council of Bizkaia, Bilbao City Council and UPV/EHU). For this purpose, other agreements made with the Bilbao School of Engineering for the creation of Business Classrooms were taken as a reference, but in this case it will be an open data classroom, which will promote the opening of data generated and the reuse of public information.

The Bilbao Bizkaia Open Data Classroom has been in operation since 2022 and its operation is similar to that of the twelve Business Classrooms that were already in operation at the Bilbao School of Engineering. These company classrooms are laboratory-classrooms within the school, created and financed by companies and institutions to promote their innovation activities. In this sense, as the organisers of the Aula state, "they are an effective instrument of collaboration between the Departments of the Bilbao School of Engineering and the business world, both in activities related to research, technological development and innovation and in everything related to training".

Open data for innovation in the classroom

 In addition to developing projects based on the reuse of open data that improve the services provided by the regional and municipal authorities, the Aula also creates data visualisations based on open information processing initiatives proposed by the university community with the aim of improving the welfare of citizens. Another of its areas of work is the implementation of training activities that contribute to the improvement of the digital skills of the university community.

During the first edition of the Bilbao-Bizkaia Open Data Classroom, in the 2022-2023 academic year, the students developed projects on the reuse of data on recycling or outdoor activities, among others. All of them were created using regional data. You can consult the projects here: https://sites.google.com/view/opendatabilbaobizkaia/home?authuser=0.

How can I join Aula Open Data Bilbao-Bizkaia?

The Aula Open data Bilbao Bizkaia has its own space in the headquarters of the Bilbao School of Engineering, in San Mamés. This space has been fitted out thanks to a grant awarded by the Provincial Council of Bizkaia and the City Council of Bilbao, which also collaborate by financing the management costs of the classroom.

The programme is aimed at engineering bachelor's and master's degree students carrying out their bachelor's and master's degree final projects, respectively. However, it is not necessary to be in the final year of a Bachelor's or Master's degree to participate in the Aula. The initiative is open to anyone with an interest in data.

Training in Power BI and data analysis toolsis provided at the beginning of the course.

The programme is free of charge, and students working under the agreement are paid. The selection process is by CV.

In the following link you can find all the information about the Classroom.

https://www.aulaopendatabilbaobizkaia.eus/aula_es.html