WhoBuiltThisRoad

When a road gets potholes three months after it's built, people are angry but stuck. Who built it? Is it still under warranty? Which engineer signed off? How much was spent? It's all public record, just buried in government portals and PDFs most people will never find.

A search box for Bengaluru roads. Type a road name and see the contractor, the engineer, the money spent, and whether the warranty (the defect liability period) is still active, with a link to the original government source. Share it straight to WhatsApp or X. It is deliberately not a complaint app: it does one thing, connecting a road to its public record.

• The right tool for each job: Python to pull and clean the government data, Go for a fast, simple API, React for the search.
• Typo-friendly search: Postgres trigram matching, so "indranagar" still finds Indiranagar.
• Warranty status is never stale: it's calculated at read time in the database, so "active", "expiring soon" or "expired" is always correct today.
• Every fact links to its source: a citizen can check the original government document themselves.

Getting the data out. The records are spread across portals and PDFs with inconsistent formats, so I built a Python pipeline to parse, clean and normalise them, with 127 tests guarding it. If the data is wrong, the whole idea fails.

More roads, and ward-level browsing using OpenCity's open data.

v0.4.0 stable, 408 road records, 100 frontend + 25 Go + 127 ETL tests.