The previous post was all about an open data / open source strategy.
There’s plenty of data available from public sites that can be turned into useful tools, and one of the sources we’ve focused on recently is police response data.
Winston-Salem Police Department publishes a simple text file daily, containing information about all the responses from the previous day: report number, address, time of day, and the type of issue (for example, vandalism, motor vehicle theft, arson, etc.).
But the interface isn’t very useful: no aggregation, no filtering, no visualization, nothing but daily text files.
WSPD does contract with crimemapping.com to display individual responses on a map, which can be filtered going back several months, and users can even receive email alerts for activity within a specified radius of any address.
That’s great! But of course we wondered if an open-source tool would be possible.
So we’ve released a minimal version of a Shiny dashboard as an example:
https://shiny.modernresearchconsulting.com/wspd-response-dashboard/
And we’ve also released the source code here:
https://github.com/modernresearchconsulting/wspd-response-dashboard