How sketchy is your next drive through Philadelphia? Research on the feasibility of safety-aware navigation apps.
We start with the Crime Incidents Dataset from OpenDataPhilly. Every reported incident of crime occupies a row in the table looking something like:
|1||2018-04-08 19:09:00||DRIVING UNDER THE INFLUENCE||39.99825344||-75.12062171|
|2||2017-12-10 04:34:00||Theft from Vehicle||39.993525344||-75.23345171|
|3||2016-08-03 15:22:00||Aggravated Assault Firearm||40.00125535||-75.24001343|
We divide the city into equal size grids and count the number of crimes in each