15_DATAQUEENS

Inspiration

The project was inspired by the need to improve urban mobility in Barcelona, connecting major hubs while addressing gaps in coverage and accessibility. Observing the challenges of daily commuters and the limitations of the current metro network, we wanted to design a solution that could reduce travel times, improve intermodal connections, and enhance the overall passenger experience.

During this project, we learned how to collect, clean, and analyze multiple public datasets, perform geospatial analysis, and design transit solutions based on real-world demand and coverage data. The main challenge was integrating heterogeneous data sources, dealing with inconsistencies, and ensuring that our proposed metro line would have a tangible impact on the network.

Project Approach

The project was structured in three main phases:

Analysis of the current system: We collected and processed public datasets from TMB, Ajuntament de Barcelona, IDESCAT, and Open Data BCN. We unified information about stations, lines, passenger demand, and coverage areas, cleaning and harmonizing the data to ensure consistency. This allowed us to analyze the network structurally, geographically, and functionally.

Simulation of network expansion: Based on the analysis, we proposed an extension to an existing metro line, adding new stations to improve connectivity and reduce imbalances in the system. We evaluated the potential impact on travel times, passenger flows, and accessibility.

Design of a new metro line: We designed a new metro line connecting the airport, key city hubs, and strategic neighborhoods, ensuring smooth integration with existing transport modes. The design focused on coverage, intermodal connections, and socio-economic impact, giving the line a clear strategic role in the network.

Challenges

Some of the main challenges included dealing with incomplete or inconsistent datasets, deciding which indicators were most relevant for analysis, and balancing technical feasibility with user-centered design principles. Additionally, we had to consider the broader impact on the metro network and ensure our proposals were realistic and data-driven.

Built With

• ajuntament-de-barcelona
• basic
• csv-for-data-preprocessing
• gis-for-mapping
• idescat
• languages:-python
• matplotlib
• numpy
• open-data-bcn-other-tools:-excel
• qgis-data-sources:-tmb-open-data
• seaborn
• simulation
• sql-data-analysis-&-visualization:-pandas