By Ryan McGreal
Published September 24, 2009
As part of an article I'm working on, I've been compiling crime statistics for Ward 1. I'm basically grabbing the numbers by month, neighbourhood and crime type from these PDF reports on Councillor Brian McHattie's website to insert into a database table in the following form:
|2008||3||1||Kirkendall||Break & Enter||8|
The data comes from Sgt. Jo-Ann Savoie, the Ward 1 (or "West Town" in police parlance) crime manager. Apparently each ward has an assigned crime manager who works with the ward councillor and neighbourhood associations to address crime and safety proactively.
It occurs to me that this could be a valuable resource for the entire city, and I confess to be inspired by Vancouver's open data platform.
Unfortunately, the City of Hamilton has not yet committed to an open, accessible data platform and I don't have time to go hunting down PDFs for each ward of the city and then manually extracting the numbers - so here's my proposal:
If you are willing to grab the data for your ward and email it to me in a spreadsheet or CSV file, I'll add it to the table and make it publicly available.
The data will be available here: http://raisethehammer.org/data/city_crime_stats.asp.
Note: right now the data for May 2009 are missing. I have asked Sgt. Savoie if she can provide them.
Make sure to post a comment under this blog entry to let others know which ward you grabbed so that someone else doesn't accidentally duplicate your efforts.
You must be logged in to comment.