I built a PostGIS pipeline that finds the officials responsible for any spot in India, plus a GPT-5.4 mini agent that routes complaints to them
retained text
Check it out: [https://www.accountable.social/](https://www.accountable.social/download) **The problem** When something breaks on your street (a pothole, garbage, a dead streetlight), the hard part is finding who can fix it: most of us don't know which ward officer, engineer or municipal department handles that exact spot. So since March, I've been building Accountable. Drop a pin and it resolves every boundary covering that point and the officials responsible. A GPT-5.4 mini agent then triages the issue and sends it to the office responsible. **How it works** * Maps never have full polygons: the API simplifies each boundary to a vertex budget and caches each detail level. **What broke** * Data: boundary sources disagree, and officer rosters go stale after every transfer. * Maps on budget Android phones lagged and crashed until I stopped map instances leaking and kept hidden tabs idle.
document fetched 2026-11-02 00:24 · canonical https://reddit.com/r/developersIndia/comments/1xkw7by/i_built_a_postgis_pipeline_that_finds_the