5 ms·
That's 54 things fixed per day, that's quite a lot. Props to Detroit on making their data so explorable[1], according to the data[2] it looks like the app is wo
by orf 11y ago
That's 54 things fixed per day, that's quite a lot. Props to Detroit on making their data so explorable[1], according to the data[2] it looks like the app is working.
Also this heatmap[3] absolutely destroys my Firefox.
1. https://data.detroitmi.gov/Government/Improve-Detroit-Submitted-Issues/fwz3-w3yn https://data.detroitmi.gov/Government/Improve-Detroit-Submit...
2. https://data.detroitmi.gov/resource/fwz3-w3yn.json?$select=issue_type,COUNT%28ticket_id%29%20as%20opened,COUNT%28ticket_closed_date_time%29%20as%20closed&$group=issue_type&$ORDER=opened%20DESC https://data.detroitmi.gov/resource/fwz3-w3yn.json?$select=i...
2. https://data.detroitmi.gov/Government/Improve-Detroit-Submitted-Issues-Heat-Map/as66-mrdx https://data.detroitmi.gov/Government/Improve-Detroit-Submit...
Edit: That's embarrassing, I originally said 5.4 things fixed a day (which is not that good)
- rockarage 11y ago10,000 plus fixed issues within 6 months does not equal "5.4 fixed issues per day"
- function_seven 11y agoOP clearly meant to say 5.4*10^1 issues per day. :P
- deleted 11y ago[deleted]
- msujaws 11y agoHow did you get 5.4 things fixed per day? They said over 10,000 issues fixed in six months. 10,000 / 182 = 54.94. It looks like you had a decimal error.
- mcnnowak 11y agoThis would be a lot more powerful if they posted an 'after' picture as well. Good to see all that data though.
- benberkowitz 11y agoyou can do that through the app! Thoughts on how we could encourage residents to do that?
- orf 11y agoMake it part of the process, send a push notification once their issue has been fixed and ask them to take a photograph of the fixed tree/rubbish free space etc to "verify that the work was done".