MetroData Datathon – Bordeaux Métropole
Winning project of the “Transition écologique des entreprises” challenge. Interactive indicators and maps that reveal how the local economy is greening.
MetroData – Transition écologique des entreprises
🏆 1st place – Team ECOMETRIC
1. Context & Challenge
MetroData is a datathon organised by Bordeaux Métropole to build new indicators for monitoring the social, ecological and employment transitions of the local economy.
Our 8-person, multidisciplinary team – ECOMETRIC – focused on the “Transition écologique des entreprises” track and delivered a full suite of data-driven indicators and interactive visualisations that convinced the jury.
Quick facts
| Item | Value |
|---|---|
| Participants | 70 + data scientists, developers, economists |
| Duration | 48 h sprint |
| Data sources | Open Data Bordeaux Métropole, INSEE (SIRET, IRIS), Enedis & GRDF (energy), GTFS transport, Eurostat, Agence de l’Eau |
| Our deliverables | 6 calculable indicators, 2 concept indicators, 5 interactive Dash/Leaflet visualisations, a short pitch deck |
| Prize | 🏅 1st place on the ecological transition challenge |
2. Key Questions
- How much energy does the local economy consume, where and in which sectors?
- Is industrial energy demand decreasing over time?
- How does Bordeaux compare to other French métropoles when normalising by jobs?
- Is green mobility supply aligned with employment density?
- Where is industrial vs. agricultural water usage highest?
These questions translated into six flagship indicators summarised below.
3. Indicators & Interactive Dashboards
3.1 Energy footprint map (2021)
Heat-map of electricity + gas demand per IRIS, with locations of companies (> 5 employees).
Insight: industrial hotspots lie in the northern ring; tertiary demand clusters around city centre.
3.2 10-year energy trend (industry)
A dual-axis line chart showing electricity (↓ since 2018) and gas (↓ since 2019).
We checked that the fall is not solely due to plant closures by controlling for headcount.
3.3 Cross-metro energy efficiency (2023)
Bar plot – MWh consumed per employee in 8 French métropoles.
Bordeaux is -43 % below Strasbourg and -108 % below Marseille, on par with Toulouse & Nantes.
3.4 Soft-mobility coverage
A buffer analysis (400 m / 800 m / 1 200 m) around tram & bus stops overlaid on business clusters.
Helps planners target underserved industrial estates for new cycling lanes or shuttle lines.
4. Methodology Snapshot
Stack: Python 3.11 • Pandas • GeoPandas • Plotly • Folium/Leaflet • Dash • GitHub Actions (CI build) • LaTeX (report).
5. Results & Impact
| KPI | Value |
|---|---|
| Indicators delivered | 6 calculable + 2 concepts |
| Interactive dashboards | 5 |
| Execution time | < 48 h from raw opens data to live demo |
| Feedback from jury | ⭐ “High actionability & clear visual storytelling” |
| Reuse | Indicators integrated in Bordeaux Métropole’s open-data portal roadmap (2025) |
Our work provides a ready-to-use toolbox for the municipality: heat-maps for network planning, efficiency benchmarks to engage with businesses, and baseline metrics for the future Observatoire des transitions économiques.
6. What made us win?
- Multidisciplinary approach – data science × economics × GIS.
- Hyper-local open data – IRIS granularity, company headcounts, energy & water per meter.
- Rapid prototyping – Dash + Plotly for live demos (no slideware screenshots).
- Actionable storytelling – every graphic links to a concrete policy lever (energy network, mobility, etc.).
7. Next Steps
- Automate monthly refresh of energy & water data (GitHub Actions + API).
- Drill-down to sub-sector emissions when new granular data become open.
- Integrate Scope 3 (imports/exports freight) once logistics datasets are available.
- Publish interactive site on GitHub Pages as part of the official Bordeaux Métropole data hub.
Credits
Suhaïla Abarkan · Théo Lavandier · Damien Le Ho – Team ECOMETRIC
Mentor: Clara Dupont (Bordeaux Métropole)
Data sources and licences listed in the full MetroData report.