Post-Disaster Electrical Network Optimization
A data engineering and geospatial analysis project developed at HETIC Paris. Objective: rational and optimized planning for electrical network restoration after a major storm.
~1.4M€
Total project cost
5
Work phases
35.2h
Hospital deadline
4
Max workers / infra
Context and Objectives
Following major storms, significant electrical infrastructure was damaged. The municipality mandated a study to propose a rational restoration plan.
Primary Objective
Restore electricity to the maximum number of citizens as quickly as possible, prioritizing critical infrastructure (hospital).
Secondary Objective
Minimize total work cost while guaranteeing infrastructure safety and respecting the allocated budget.
Methodology
Data preparation (Python / pandas / geopandas)
Processing shapefiles, CSV tables, logical network topology. Cleaning, normalization, dataset consolidation.
Difficulty metric definition
Difficulty(infra) = length(m) / connected buildings. Buildings ranked by sum of infrastructure difficulties.
Cost estimation (material + labor)
Aerial 500/m, Semi-aerial 750/m, Conduit 900/m. Labor: 37.5/h. Total: ~1.4M euros.
QGIS visualization and spatial analysis
Enriched shapefiles exported to QGIS. Color coding by phase, line thickness by cost, transparency by difficulty.
Work Phases
Phase 0 — Hospital (Priority)
Secured within 35.2h (44h autonomy with 20% safety margin)
Phase 1 — Simple buildings (~40% budget)
Phase 2 — Intermediate buildings (~20% budget)
Phase 3 — Intermediate buildings (~20% budget)
Phase 4 — Complex buildings (~20% budget)
Budget Breakdown
Material cost
~1 100 000 €
Aerial, semi-aerial, conduit infrastructures
Labor cost
~300 000 €
37.5/h, max 4 workers/infra, parallel work
Total project
~1 400 000 €
Within expected range of 1.0 to 1.5M euros