I mapped Bangkok districts with 100k active public complaints
If you live in Bangkok long enough, you know neighborhood issues are a total coin toss. Some things get fixed, while others sit in a void forever.
Recently I had some free time to spare, so I played around with the public complaints open data (Traffy Fondue) to see which districts are actually clearing their plates and which ones are letting cases rot.
Over 160k active cases from recent years are visualized on an interactive map. The 50 Bangkok districts are ranked using a score based on two main metrics (normalized by district population):
- The volume of their active, unresolved backlog.
- Backlog age (how many days those unresolved cases have been sitting stagnant).
The colors represent how healthy your district is, from best (green) to worst (red).
If you want to see your district: https://yadong.app
For the technical part, the map uses live data that's supposed to refresh automatically every day. So, the leaderboard stays as current as possible. I'm also planning to add more metrics over time as I refine the scoring.