In this section we want to give visibility to the Case stories made with the data published in Open Data BCN in:
Public administration environment
Tuesday, 26th May, 2020
The website COVID-19 tracker in Barcelona shows a global graphic view of the evolution of COVID-19 in the city of Barcelona. It is a list of indicators from different areas such as health, mortality, meteorology, mobility, prices, the labor market, the stock market, consumption, housing, opinion and neighborhood support initiatives, among others.
The data in reusable format can be downloaded in the dataset Indicators to measure the impact of COVID-19 on the city of Barcelona.
Thursday, 16 April, 2020
The Viewer of the Survey on Municipal Services allows you to interactively consult the historical and detailed evolution of all indicators and variables of this face-to-face quantitative study made on an annual basis, and with a universe of Barcelona residents of 18 years and over.
This survey collects the perception of citizens about their city and its neighbourhood (degree of satisfaction, problems and demands, evolution, etc.) and their opinion with regards to municipal management.
The data source can be found in the dataset Survey on Municipal Services of Barcelona's City - Evolution from the Open Data BCN portal.
Influencia y desafíos del Open Data en la sociedad europea del siglo XXI: una mirada comparativa a su desarrollo en España y Francia
Monday, 20th July, 2020
With the sentence from Barack Obama, ex president of the United States of America as introduction, “We will work together to ensure the public trust and establish a system of transparency, public participation, and collaboration. Openness will strengthen our democracy and promote efficiency and effectiveness in government”, the lawyer Pierre Jean Thil publishes the interesting report "Influencia y desafíos del Open Data en la sociedad europea del siglo XXI: una mirada comparativa a su desarrollo en España y Francia" where he mentions the Barcelona City Council's open data portal, Open Data BCN, as a practical example of open public information.
Thursday, 7th May, 2020
Pilar Escobar is an associate professor and researcher at the University of Alicante, who regularly works in the domain of linked open data. With her research group, and using datasets published on the Open Data BCNportal, she has applied a semantic enrichment methodology and link with external data, generating advanced descriptions of the data, based on Web standards, and representing the information in a dashboard that makes the data management easier for end users.
That process of transforming open data into linked open data (Linked Data) exemplifies excellence in data interoperability and enrichment.
In the article "Adding value to Linked Open Data using a multidimensional model approach based on the RDF Data Cube vocabulary" you can see the methodology and infrastructure used, as well as the results obtained with real-time data from the Open Data BCN portal's dataset State of critical cleaning spots in the city of Barcelona.
A good opportunity to see the data published on the Open Data BCN portal within the 5 * Tim Berners-Lee quality level.
"An analysis of the distribution of wifi hotspots in the city of Barcelona" by a group of student of UPF Barcelona School of Management
Wednesday, 15 April, 2020
Magdalena Paula Brück, Kristelle Domingo and Jacqueline Raffel, a group of students from UPF Barcelona School of Management, have analyzed the distribution of free wifi hotspots in the city of Barcelona provided by the Barcelona City Council, and proposed new potential locations for this service.
The study has been based on the Wifi hotspots of the city of Barcelona data available in Open Data BCN, related to users data, both, local citizens and tourists.
“Analyzing the Demand of Social Service Centers in Barcelona”, an analysis project elaborated by a group of students of UPF Barcelona School of Management
Tuesday, 14 April, 2020
Enrique Arvelo, Mohamed Murad and Yannick Altmeyer, a group of MSc in Management students from UPF University of Barcelona, has analyzed the supply and demand of Barcelona’s social service system by evaluating the locations of Barcelona’s social service centers in regards to much of its population.
A comprehensive database of Barcelona’s demographics was compiled through combining several datasets from Open Data BCN.
Through the analysis they were able to detect some minor inefficiencies within the system thus allowing them to provide recommendations for action.
Berta de las Cuevas, 2nd year Baccalaureate student at the Ferran Tallada Institute in Barcelona, presents her research work with open data
Monday, 13 January, 2020
Student Berta de las Cuevas presented the research work to an evaluating court on Friday, January 10, under the title ‘La influència de creuers en la contaminació de la ciutat de Barcelona’. It has been performed based on the analysis of open data of the Open Data BCN, Open data of the Generalitat de Catalunya, Meteorological Service of Catalonia and Port de Barcelona portals.
Using a quantitative methodology and data on air quality, rainfall and wind from the nearest weather stations to the port of Barcelona, he obtains conclusive results on the importance of pollution caused by cruise ships arriving at the port of Barcelona city. Berta has carefully researched the open data available from various sources, debugged and cross-linked them for analysis, and concluded that she finally presented in a structured and visual way.
The members of the evaluation panel congratulated him on highlighting the rigor of the analysis and the innovation involved in the incorporation of new tools and sources of information in the performance of the research work in the second year of high school.
The Institut Ferran Tallada of the city of Barcelona, which currently teaches more than 600 students between ESO and Baccalaureate, was the winner of the First edition 2018 of the Barcelona Data Open Challenge and Berta de las Cuevas was one of the members of the team of students representing the school. Both the director of the center, Gemma Torres, and the teacher and guide in the execution of the work presented, David Sánchez, show the very positive influence of the Barcelona Dades Obertes Challenge initiative on the training of the participating students.
Berta de las Cuevas is a wonderful example, she is the future.
Congratulations Berta! Congratulations Ferran Tallada!
Wednesday, 13 February, 2019
A group of students from the International Business Economics bachelor of the Universitat Pompeu Fabra(UPF) has worked, during the first term of the 3rd year, the project "A logistic analysis of Bicing", an analysis of the Bicing service of the city of Barcelona. This study, in which the dataset Bicing stations of the city of Barcelona (Mechanics and electrics) of the Open Data BCN portal has been used, among other resources, has been coordinated by the business logistics professor, Dra.Helena Ramalhinho to whom they “thank the help and the opportunity she gave them to learn in a different way”, as they state in the introduction of the study.
Prediction of critical points of traffic accidents in the city of Barcelona with spatial data science
Tuesday, 22 December, 2020
Miguel Álvarez, data scientist on the CARTO platform, has carried out a geospatial analysis of the traffic accidents in 2019 in the city of Barcelona. The base datasets used correspond to the accident rate data published in the Open Data BCN portal, which has been related to road signs, weather and mobility, among others.
Thursday, 12 March, 2020
Xavier Vivancos, Business Intelligence analyst, presents the package baRcelona which he has developed in R language using the API of the Open Data BCN portal. This development allows to consult the datasets catalogue and all of its resources asides from filtering by topic and subtopic to ease the search.
It also offers the possibility of loading any file in csv format directly within an RStudio environment.
The documentation is available to all interested citizens in the GitHub repository.
"Analysis of car accidents in Barcelona using Pandas, Matplotlib, and Folium", an analysis project elaborated by Amanda Iglesias Moreno, engineer in Akka Technologies
Monday, 28 October, 2019
Amanda Iglesias Moreno, engineer in Akka Technologies published at Towards Data Science, a web for sharing concepts, ideas, and code, an "Analysis of car accidents in Barcelona using Pandas, Matplotlib, and Folium". This very interesting project allows everybody to answer some questions about the time, the type and the location of the car accidents in 2017 in the city of Barcelona.
Wednesday, 9 May, 2018
BACC is a non-profit and transparent association formed by bicycle users that represents the interests of cyclists. They develop promotional campaigns, and propose solutions to cities and towns that want to introduce bicycle for transport and leisure in urban mobility.
Within the accident analysis, with the collaboration of the CARTO platform, that this collective began to do this year, datasets of Accidents managed by de local police in the city of Barcelona have been analyzed and created maps about injured people on bicycles, motorcycles or mopeds, as well as run over pedestrians...
BACC invites all citizens and research groups to use this data to put the accident rate in context in Barcelona, to identify the concurrent factors in accidents and reduce them in future.
Friday, 16 June, 2017
Everything begins at Barcelona Challenge Canodrom, a pioneering innovation event organized by the City Council in co-operation with Sónar+D which aims to involve the creative sector of the city in the creation of public policy.
With this idea, the project led by Arsgames and named “Juegos del común”, passed the first round of the Barcelona Challenge Canodrom achieving the highest score among the 60 different approaches that where presented. The projects were valued according to their suitability to concepts such as citizen science, collaborative economy, social and artistic innovation, technopolitics and use of open data. The participants of the selected project enjoyed tutoring by the Barcelona City Council.
What is Juegos del común and who are Arsgames?
Juegos del común is a project of data gamification based on the concept of data games, aiming to introduce a new approach in the reuse of open data rather than the mostly know uses such of apps, visualizations of data and data journalism. This interactive experience arranges game structures in order to leverage citizens’ participation.
Arsgames, on the other hand, is a cultural association which thinks of and experiences with videogames, organizing events and undertaking new projects.
In this context, they develop an API relating 4 different datasets from Open Data BCN in order to allow users to navigate easily and effectively through the data. The datasets used are the Average area of rented housing, the Average monthly rent, Tourist housing in the city of Barcelona, and finally one dataset about Cultural festivals data in the city of Barcelona.
The API created was offered to artists and developers so that they could make videogames out of it. 4 different projects originated from it:
- Rambla Rush: A runner in ‘La Rambla’ of Barcelona.
- Flatsweeper: A minesweeper about renting in Barcelona.
- PimPamPom: A pinball where you need to win in order to be able to pay the rent.
- Last Hope: A simulation about the daily life of a homeless.
All those games have been presented in Sónar+D.