Hi there, fellow civic web-makers, urban movers-and-shakers and masterpiece creators––
Good news! After having spent a great deal of time and effort trying to obtain crime data in a tabular format from Savannah-Chatham Metropolitan Police Department, I'm happy to let you all know we received the requested data yesterday via email. The only downsides?
The 13 different provided Excel files are far from clean enough to perform much useful analysis easily (there are erroneous images and art splashed around, and far too much summary formatting). We're going to need a team of folks to volunteer to get the spreadsheets cleaned up and exported as
The files do not contain the actual detailed crime summary reports with address approximations (i.e. the 300 block of Bull St.), just the weekly reports. While we can make another request for the full reports, this is a start... for now. One thing we remain resolute on: If that data can be provided to the less-than-transparent vendor 'Lexis-Nexis: Community Crime Maps' (formerly known as RAIDs)
Call to Action:
Who wants to join me in maniupulating/refining this data into more structured schema that we can visualize easily for both analysis purposes and sharing purposes?
If you want to be a data hero for a topic in high-demand from residents, join me in helping clean these Excel files up!