One of the economic sectors that is experiencing a high growth in our country is the real estate market. Deciding on a property involves a lot of small decisions: Rent or purchase? In what zone? What services do I need nearby? What is the market price?

As we saw a few months ago, open data can help us make this decision in the most informed way, based on evidence and proven information. In Spain, this trend is also spreading, and more and more public bodies and companies are creating products and services based on public information to facilitate the search for housing.

A business with future potential

In the era of technology and information, real estate agencies are having to incorporate tools that allow them to know the market situation, something that is giving rise to new business models: companies that combine open data with analytics and Big Data to show in a simple way (through visualizations, dashboards, etc.) the market behaviour. Let's see some examples of Spanish companies that are emerging in this sector:

• Urban Data Analytics (uDA) is one of the companies that has emerged in recent years dedicated to segregating and geolocated knowledge of the real estate sector. Through Big Data and Business Intelligence tools, it provides a service of 190 indicators through APIs and an application. These indicators allow instant knowledge of both market and portfolio of a company´s real estate, and are very helpful to real estate agents who seek to make their investments profitable.
• Clicpiso, for his part, is a Spanish startup specializing in homes sale, with a peculiarity that differentiates it from its competitors: Clicpiso carries out the transaction in less than 7 days. For this, it use a valuation algorithm based on Big Data, which also automatically learns from itself to ensure that the processes and valuations of each property are optimized with each new registry.
• Another example is Strabi, who offers dashboards to keep track of home sales in Spain, both free and protected. Thanks to its web quevalemicasa.es citizens will be able to know quickly if their home was well valued at the time of purchase and in what situation it is now (above or below its reference price). This application relies on the use of open data and Business Intelligence tools, based on Open Source technology, for model development, data loading and analytical exploitation.

The involvement of public bodies

But, despite the positive growth data of the sector, we must also take into account the difficulties of a large part of the population in accessing housing, a concern that affects young people above all. The society is demanding measures from public agencies and these measures go through knowing how supply and demand are being managed. The Government of Aragon and the Madrid City Council, among others, have launched tools in recent years that allow integrating all this information:

• Inmuebles de alquiler, Aragón is the application created by the Government of Aragon in 2017 to know the prices of house and premises renting throughout the Autonomous Community. Thanks to it, citizens can search by street name or geolocation, as well as make comparisons through historical data. The objective: that the citizen knows if the price they offer adapts to the reality of the market.
• The Puerta de Alcalá Urban Planning Platform was created by the Madrid City Council in 2018 to collect all the information related to the different areas of the city and manage its urban cycle, from planning to construction. In this way, citizens, companies or administrations have more accessible, transparent, reliable and up-to-date information on municipal action in urban planning.

It is clear that we are facing a complex market, whose future is to boost economic growth while respecting the basic rights of access to housing. The knowledge of the sector, analyzing historical data and preparing future predictions, will allow to better adapt the offer to the demand, promoting a housing stock that responds to the needs of all citizens.

Close your eyes and try to get on without seeing what is around you. Seat you in a wheelchair and determine if it is easy to access public transport and visit your favourite restaurant.

Perhaps you have not tried to live these experiences, but you could imagine the result. Public administrations are making an effort to make our environment more accessible, but it is true that there is still work to be done and people with disabilities face barriers that limit their movements.

To try to make these daily situations easier, simple applications have emerged in recent years that provide useful information about the environment using open data. The objective: to make the daily life of people with disabilities easier.

Here are some examples:

• Lazzus is an assistant created by Neosentec that accompanies blind and visually impaired people in their daily journeys, creating an auditory field of vision. The application provides relevant information about the environment, such as the situation of crosswalks, crossroads, stairs, nearby establishments, etc. Simply point a direction with the mobile to inform you about the elements around. It also allows you to customize searches, activating filters or saving frequent points as favourites.
• Mapcesible is an initiative of Fundación Telefónica, COCEMFE and ILUNION. It is a collaborative platform that allows mapping the accessibility of different places so that people with reduced mobility can plan their daily trips. Information is obtained in two ways. The application incorporates 14 datasets from official bodies such as the Ministry of Agriculture and Environment or different municipalities. In addition, any citizen, with or without reduced mobility, can assess the accessibility of the places they visit. They just have to register with an email and answer a series of simple questions that allow to quickly define how accessible a place is. Some examples of questions are “Is it close to public transport?” or “Has it an adapted toilet?”. There are currently more than 22,000 mapped spaces.
• Disable park is a web platform and mobile application created by 3dids, which offers all available information on the exact location of parking spaces for people with reduced mobility. Its objective is not only to improve the day-to-day life of people with reduced mobility and their companions, but also seeks to raise awareness among companies and individuals through the “sponsorship of places”: users who wish can pay an amount per year to put their name, or a friend´s name, to a parking space. The application also allows to report when a place is occupied by a vehicle without accreditation or add new parking spaces that were not previously mapped in the application.
• Sin barreras is a web application consisting of a search engine for accessible spaces, adapted parking lots and architectural barriers. The user only has to enter a location or short description to see the results or add new elements not previously included in the application. Sinbarrera.es received a grant in the form of a Project Construction Grant from the Youth Initiative Cabinet of the Junta de Extremadura, and was also awarded with the Otaex Universal Accessibility Award 2012.

These 4 examples of applications demonstrate what can be done from the open data. An opportunities increase if we also enrich the public data available with the information collected by anonymous citizens through citizen science initiatives. All this information not only help people with disabilities to move in an easier way, but it can also help to determine the gaps and take the necessary measures to get cities without barriers.

Do you know more examples of applications that can improve the lives of people with disabilities? Tell us in the comments.

By 2020, the amount of data stored in IT systems will be doubled compared to 2018. Given this scenario, it seems logical that the demand for professionals with analytical and data management capabilities is growing, something we have already spoken about on numerous occasions.

One way to boost the learning of these skills is through open data and its use in the classroom as another educational resource. The development of collaborative projects where students have to search and filter information, analyse data or generate visualizations have a place in almost all subjects. With this type of project, students can acquire a great diversity of capacities: from the use of technological tools and the capacity for analysis and argumentation, to the improvement of so-called soft skills such as teamwork - also fundamental for professional development -.

The first step: train teachers

One of the fundamental pillars for open data to be integrated into classrooms is the previous training of teachers. In this sense, programs such as Use (Open Research) Data in Teaching project (UDIT) try to help higher education professors to be able to use open research data in their classes. Among other activities, the website offers courses that show good practices and examples of learning activities based on the reuse of open data.

Along the same lines, the National Library of Spain and Red.es have created the BNEscolar educational platform with digital content prepared from the documentary collection of the Hispanic Digital Library. The website includes a search engine to facilitate the location of the desired resources, as well as workshops, videos, educational sequences and interactive challenges (such as an escape game). The contents of BNEscolar are aimed at pre-university students, with special focus on the latest levels of Primary and Secondary Education.

Contests and activities to boost the use of data in classrooms

In addition to these platforms, concrete activities, contests and challenges that seek to promote the use of open data among the youngest citizens are also increasingly common. Examples are the Reto BCN Dades Obertes or the Open Data Contest of Castilla y León, which included a special prize for students in each of the main categories, as well as a specific category for the creation of teaching resources that could be used in the classrooms. Another example is Escuelas Comciencia initiative, created by the Observatory of Scientific Communication and the Cyberimaginary research group, where students learn to carry out a research project using open data.

But we can also find such initiatives internationally. The programs developed by Technovation stand out here, aimed at identifying problems in student communities and solving them using disruptive technologies. An example is Technovation Girls, aimed at girls around the world. This program seeks to teach girls how to identify a problem and brainstorm ideas to solve it, and create an application to launch a business. Also noteworthy is the AI ​​Family challenge contest, which brings learning to the family environment, another of the fundamental foundations of children's education. The AI ​​Family Challenge invites families to learn about Artificial Intelligence (AI) technology and solve a problem using data tools and AI systems. The original approach of the contest, in which parents and children combine their abilities and learn together in a fun way, has driven the success: 7,500 people from 13 countries participated in the first edition. The deadline for submitting to the second edition will be open until February 2020.

The importance of government involvement

The results obtained in all the previously highlighted activities have been very positive, clearly showing the benefits of incorporating open data in classrooms: the improvement of technological and analytical capabilities, but also of critical thinking.

But if you want to go one step further, it would be advisable to incorporate open data directly into educational plans. This is what Switzerland has done through the Lehrplan21 plan, adopted to standardize education in the 21 German-speaking and multilingual cantons. The plan includes the learning of basic concepts related to data in the educational itinerary: structures, formats, management and analysis of databases, etc.

These types of measures are essential if we want to promote more active learning, where open data helps students to better understand their environment, in a reasoned way, to become the professionals that our future needs.

Open data is one of the key elements of smart cities. The collection of information, its analysis and its use make possible to address many of the challenges facing cities today, such as the creation of public services that respond to a growing population.

Among all the open datasets that are published related to cities, real-time data provides multiple advantages. Knowing the situation of our cities in real time can serve to make decisions and improve efficiency in urban mobility, energy management or environmental conditions, among other aspects.

In this context, the report "Open data in real time: use cases for smart cities" seeks to boost the opening of this type of data showing the advantages of its use. The report analyses the relationship between open data and smart cities, and shows a series of datasets that local entities should publish in real time, according to the report “Open Data 2019 - 40 datasets to be published by Local Entities”,  elaborated by the FEMP (Spanish Federation of Municipalities and Provinces). These data sets belong to the fields of transport and mobility - public car park, public bicycles, traffic, public transport - and the environment - air quality and noise pollution.

Each dataset has been analysed highlighting some use cases and reuse examples, paying special attention to the positive impact they have on citizens. The technologies involved in its deployment, the stakeholders or future challenges, among other factors, have also been addressed.

The conclusions of the analysis are collected in each of the files that you can see below:

Datasets

 

You can also download the full report and other additional materials using the following links:

In the digital world, data becomes a fundamental asset for companies. Thanks to them, they can better understand their environment, business and competition, and make convenient decisions at the right time.

In this context, it is not surprising that an increasing number of companies are looking for professional profiles with advanced digital capabilities. Workers who are able to search, find, process and communicate exciting stories based on data.

The report "How to generate value from data: formats, techniques and tools to analyse open data" aims to guide those professionals who wish to improve the digital skills highlighted above. It explores different techniques for the extraction and descriptive analysis of the data contained in the open data repositories.

The document is structured as follows:

• Data formats. Explanation of the most common data formats that can be found in an open data repository, paying special attention to csv and json.
• Mechanisms for data sharing through the Web. Collection of practical examples that illustrate how to extract data of interest from some of the most popular Internet repositories.
• Main licenses. The factors to be considered when working with different types of licenses are explained, guiding the reader towards their identification and recognition.
• Tools and technologies for data analysis. This section becomes slightly more technical. It shows different examples of extracting useful information from open data repositories, making use of some short code fragments in different programming languages.
• Conclusions. A technological vision of the future is offered, with an eye on the youngest professionals, who will be the workforce of the future.

The report is aimed at a general non-specialist public, although those readers familiar with data treatment and sharing o in the web world will find a familiar and recognizable reading.

Next, you can then download the full text, as well as the executive summary and a presentation.

Note: The published code is intended as a guide for the reader, but may require external dependencies or specific settings for each user who wishes to run it.

In the current context of digital transformation, all sectors are adapting to respond to the efficiency and agility improvement needs that society demands today. One of the areas where this change is most necessary is the agricultural and forestry sector.

The growth of the world population, climate change, or the depopulation of rural areas, something of particular concern in the specific case of Spain, make a paradigm shift necessary: a higher quantity of food must be generated, more quickly and sustainable with the environment.

To deepen this problem and its possible solutions, from the Aporta Initiative we have prepared the report “How open data can boost the agricultural and forestry sector”. The objective of the report is to promote the use of open data in the process of digital transformation of the agricultural and forestry sectors. Additionally, the report also focuses on water management as an element of great importance in the value chain.

The report is structured as follows:

• The first part begins with the analysis of the role that digital transformation is playing in solving the main challenges facing the agricultural and forestry sectors, highlighting the open data contribution as part of this process.
• In the second part, a series of repositories are compiled to find open data sets potentially useful to support digital transformation in these sectors.
• For the third part of the report, a series of relevant use cases have been selected in digital transformation in the agricultural and forestry sectors, both nationally and internationally and in which open data have a prominent role.

The report ends with the presentation of a series of conclusions drawn from the analysis work carried out.

It is therefore a must-read document for those interested in promoting improvements in areas such as precision agriculture, promoting a more efficient and sustainable agricultural and forestry sector. It should also be noted its great usefulness as a mechanism to understand the current scenario and source of inspiration for the participants in the Aporta 2019 Challenge.

A few months ago we published a compilation of the main reports, studies, success stories and courses published by the Global Open Data for Agriculture and Nutrition (GODAN). This body seeks the proactive sharing of freely accessible data to make information on agriculture and nutrition available, accessible and usable.

To achieve this goal, GODAN has different teams that work in a coordinated manner for a common goal. One of them is the Capacity Development Work Group, focused on promoting open data knowledge (ongoing initiatives, innovations and good practices), as well as the development of new capacities. All of them to guarantee a more effective accessibility, use, engagement and understanding of open data.

In 2017, this group launched Godan webinar services, in order to offer a series of webinars organized in collaboration with the Technical Centre for Agricultural and Rural Co-operation (CTA). The videos, which last between 40 minutes and one hour, help to delve into different concepts: they explain how an open data initiative on agriculture should work, or how to tell stories with data to raise organizations and citizens’ awareness. Some of the organizations that have participated in the preparation of the contents are the Open Data Institute (ODI), Wageningen UR or The Land Portal Foundation, among others.

Here are some of the resources that can be found in Godan webinar services:

In addition to these more general webinars, Godan webinar services also offers specific resources, where different initiatives tell their experience when publishing or reusing open data on agriculture and nutrition. An example is the Regional Centre for Mapping of Resources for Development (RCMRD), which shows some of the projects in which it is involved in one of the videos.

In short, whether you are a public body that wants to start or consolidate an open data initiatives on agriculture, or a reuser looking for examples and success stories to inspire you, Godan webinar services can provide resources and information of interest.

Why are open data important? What is their relationship with open government? How can I start an initiative of this kind? Who can I take as a reference? These are some of the questions that the Open Data Guide: Publication and reuse of Open Data as an initiative of Open Government in the Administration tries to answer

Prepared by the Ministry of Development and Environment of the Junta de Castilla y León, this guide is part of the Rural Digital Community (CRD), a collaboration project between Public Administrations of Portugal and Spain. The objective of the project is to improve the technological innovation of rural institutions, promoting cooperation and competitiveness.

The guide is divided into 5 sections: introduction to open data, current status of open government and open data, open data implementation , innovative solutions and success stories, and conclusions.

In the first introductory section, perfect for those unfamiliar with the open data world, some basic concepts are reviewed. The report focuses on open government as a sociopolitical mode of interaction based on 4 pillars - transparency, accountability, participation and collaboration - which can be promoted and improved thanks to open data. All this is explained in this section, which also describes the principles that data must meet to be considered open.

Next, the report address the current situation of open government and open data in Spain, Portugal and Europe, including existing regulations. In the case of Spain, the report highlights the existence of almost 300 initiatives, included in the initiatives map of datos.gob.es, as well as more than 660 companies that reuse information, with a business volume higher than 1,700 million euros per year. These data, together with the good position of Spain in the European Open Data Maturity Landscaping 2018 report, show the good momentum of open data in our country.

The third section of the report focuses on the implementation of open data in an organization. To facilitate this process, the authors of the guide have drawn up a plan with a series of stages that are detailed in the report:

Finally, the report shows several examples of innovative solutions and success stories, based on 2 criteria:

• Examples of open data portals, which stand out for their functionality, such as Aragon Open Data or the download center of the National Geographic Institute (IGN), among others.
• Examples of good practices regarding reuse, due to their innovative nature and the economic or social value they generate. Examples of different sectors are included, such as real estate (TerceroB), meteorological (Meteogrid), public procurement (EuroAlert) or data journalism and public transparency (Civio).

The report concludes with a series of conclusions, such as the need to improve the training of both public employees who are immersed in data opening and companies and individuals to promote the use and analysis of data.

Below you can download the full report and delve into all of these sections.

In 2017, the Spanish Federation of Municipalities and Provinces (FEMP) published the guide "Open data: strategic guide for its implementation and minimum datasets to be published", which included a series of recommendations and guidelines for public data opening with the aim of driving its publication and reuse. In addition to information related to legal framework or governance model, the guide also included 20 datasets considered as "the most interesting, possible and easier to publish by public administrations".

After the guide success, the FEMP has continued working on expanding these datasets, identifying 20 new ones that will make possible to standardize the publication of open data and facilitate its management. For this, the FEMP count on the help of a multidisciplinary working group where different interest groups were represented: cities, citizens, companies, universities and public bodies.

The result is a new document, entitled Open Data FEMP 2019: 40 datsets to be published by the Local Entities, whose objective is to provide a "common open data model that facilitates interoperability and the reuse of public sector information", as well as to bring Spanish local entities’ commitment to normalize open data closer to the international community.

This new guide addresses not only what datasets should be published by local entities, but also how they should be published to make them more useful for citizens and reusers. Using different tabs - one for each recommended dataset – the report indicated the recommended format or update frequency when publishing each dataset. The guide also indicates each dataset reuse value or complexity (based on a scale from 1 to 5), as well as some recommended visualization to make easier citizens access to information.

The document is mainly oriented to medium to large cities, although smaller municipalities can also use it as a knowledge framework. It can help companies, citizens, universities, entrepreneurs, researchers, data journalists, students, etc. interested in the subject, although, the roles that can make the most of the information are:

• Those responsible for developing or that have to develop open data policies.
• Those responsible for Open Government policies (transparency, participation, accountability, collaboration).
• Those responsible for the development of Information Technology.
• Those responsible for "Smart Cities" and Innovation projects.

The following image shows which are the 40 datasets recommended in the document:

Here you can download the full report (in Spanish, with an executive summary in English):

The Global Open Data for Agriculture and Nutrition Initiative, known by the acronym GODAN, aims to support "the proactive sharing of open data to make information about agriculture and nutrition available, accessible and usable." To this end, GODAN fosters dialogue and cooperation in agricultural activities between more than 760 members, including governments, private companies, international organizations or NGOs.

Through different working groups, GODAN contributes to share ideas and experiences to solve key problems and challenges in the agriculture and nutrition sectors, using open data. Some of these challenges are ridding the world of famine, ensuring food security, improving nutrition or facilitating sustainable agriculture.

In order to help more companies, organizations and citizens to be aware of the importance of open data to solve these challenges, GODAN promotes the creation and dissemination of resources that drive both providers and users reflection on agricultural open data. Among these documents, we can find:

• Reports, which analyze different challenges and include recommendations or good practices aimed at enriching the available information about agriculture and nutrition, encouraging their analysis and reuse.
• Success stories, which can be used as an example for those organizations interested in being part of this ecosystem, but do not know how to take advantage of open data to generate new initiatives that add value to the sector and solve the aforementioned challenges.
• Courses aimed at strengthening data producers and consumers capacity to manage and use open data in agriculture and nutrition sector.

We have compiled some of these resources, described in the following table:

To learn more about GODAN resources, you can visit their website publications section. In this section, which is periodically updated with new publications, users will find more documents and reports related to open data in agriculture. The dissemination of these contents can help develop high-level policies, and support the private sector for opening more data, which is fundamental to overcome important challenges for humanity.