← sources

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

source: reddit (reddit:developersIndia)published 2026-11-01 06:41ingested 2026-11-02 02:38

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