Projects / LAB-05
London Property Map
London house prices layered with schools, transport, green space and energy ratings on one map.
- Part no.
- LAB-05
- Status
- archived
- Platform
- Web
- Year
- 2025
- Stack
- ReactLeafletFlaskPostGISpandas
Back of the napkinRough · not a forecast
Open-data research tool. Commercial property data subscriptions are the comparison.
- Commercial property data subscription£££/mo
- −Land Registry, EPC and ONS open data£0
- =Data cost£0
Running costs
- Storage
- ≈ 50 GB local
- Hosting (if public)
- one small PostGIS box
At 10× / 100×
The ETL is the expensive part and runs once. Serving map tiles from materialized views stays cheap until heavy public traffic.
Verdict
Proves you can build most of a paid property tool from open data. It’s a portfolio piece, not a business.
01
Joining messy datasets
Land Registry price-paid data from 2018 to 2024 is matched to EPC certificates by address.
02
Spatial SQL
PostGIS materialized views and spatial indexes keep map filters fast.