# 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 record

> Retained reddit record from reddit:developersIndia.

Canonical: https://highsignal.app/data/records/ea7e99d73845103b

[← sources](https://highsignal.app/data)


source: [reddit](https://highsignal.app/data/reddit) (reddit:developersIndia)  published 2026-11-01 06:41 ingested 2026-11-02 02:38

[original source ↗](https://www.reddit.com/r/developersIndia/comments/1xkw7by/i_built_a_postgis_pipeline_that_finds_the/)

## 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
