Open City

City Crime Data by Ward, Month, Neighbourhood and Crime Type

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:

year month ward neighbourhood crime count
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. Update: Sgt. Savoie has helpfully provided the May 2009 data, and they are now included.

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.

Ryan McGreal, the editor of Raise the Hammer, lives in Hamilton with his family and works as a programmer, writer and consultant. Ryan volunteers with Hamilton Light Rail, a citizen group dedicated to bringing light rail transit to Hamilton. Ryan writes a city affairs column in Hamilton Magazine, and several of his articles have been published in the Hamilton Spectator. He also maintains a personal website and has been known to post passing thoughts on Twitter @RyanMcGreal. Recently, he took the plunge and finally joined Facebook.

11 Comments

View Comments: Nested | Flat

Read Comments

[ - ]

By bsimons (anonymous) | Posted September 25, 2009 at 00:42:23

I'd love to see a comparison between wards Ryan. I've always wondered just how much more crime there is in the "Dangerous" areas of town, of if it's all perception.

Permalink | Context

[ - ]

By Ryan (registered) - website | Posted September 25, 2009 at 08:46:26

Okay, folks: why do you think about this comment by CordellT?

It's a registered account, meaning a person or a bot filled in the form to create an RTH user account and then clicked the confirmation link in an email that was sent to a working email address.

Was the text of the comment above written by a person or by a clever keyword-parsing bot?

Permalink | Context

[ - ]

By reuben (registered) - website | Posted September 25, 2009 at 09:39:41

it seems a little clever for a bot.

but it is still comment spam.

Permalink | Context

[ - ]

By UrbanRenaissance (registered) | Posted September 25, 2009 at 11:38:31

Regardless of how it was posted, its clearly spam and as such should be removed and the IP that registered it should be permanently banned. You have to take a hard line when it comes to board spam.

Permalink | Context

[ - ]

By Ryan (registered) - website | Posted September 25, 2009 at 16:26:42

Removed.

Now how about those crime stats by ward? :)

Permalink | Context

[ - ]

By Meredith (registered) - website | Posted September 27, 2009 at 00:30:14

Trying to think what the best bets are for finding that information other than councillors and the currently-useless city websites.

Perhaps by contacting the crime managers for each sector within each division? (which includes different neighbourhoods?) - even if one or two get back, they may have an idea of where to find that information.

http://www.hamiltonpolice.on.ca/HPS/Communities/Division+1/ http://www.hamiltonpolice.on.ca/HPS/Comm... http://www.hamiltonpolice.on.ca/HPS/Comm...

---------------------------- Division 1

http://www.hamiltonpolice.on.ca/HPS/Communities/Division+1/Sector1.htm Crime Manager: Sgt. Jo-Ann Savoie Division 1, Sector 1 jsavoie@hamiltonpolice.on.ca 905-546-5093

http://www.hamiltonpolice.on.ca/HPS/Communities/Division+1/Sector2.htm Crime Manager: Sgt. Tina Potter Division 1, Sector 2 tpotter@hamiltonpolice.on.ca 905-546-5093

http://www.hamiltonpolice.on.ca/HPS/Communities/Division+1/Sector3.htm Crime Manager: Sgt. Ron Hayward Division 1, Sector 3 rhayward@hamiltonpolice.on.ca 905-546-6074

http://www.hamiltonpolice.on.ca/HPS/Communities/Division+1/Sector4.htm Crime Manager: Sgt. Chris Zafirides Division 1, Sector 4 czafirides@hamiltonpolice.on.ca 905-546-6074

---------------------------- Division 2

http://www.hamiltonpolice.on.ca/HPS/Communities/Division+2/Sector1.htm Crime Manager: Sgt. Shawn Blaj Division 2, Sector 1 905-546-2949 sblaj@hamiltonpolice.on.ca

http://www.hamiltonpolice.on.ca/HPS/Communities/Division+2/Sector2.htm Crime Manager: A/Sgt. John Heide Division 2, Sector 2 905.540.5179 jheide@hamiltonpolice.on.ca

http://www.hamiltonpolice.on.ca/HPS/Communities/Division+2/Sector3.htm Crime Manager: Sgt. Tim Bower Division 2, Sector 3 905.546.2949 tbower@hamiltonpolice.on.ca

http://www.hamiltonpolice.on.ca/HPS/Communities/Division+2/Sector4.htm (This was the only page to contain any additional information right on the page, but it was 2007, I believe) Crime Manager: Sgt. Laura Wiltshire Division 2, Sector 4 905.540.5179 lwiltshire@hamiltonpolice.on.ca

---------------------------- Division 3 Division 3 - has several newsletters, etc already linked to

http://www.hamiltonpolice.on.ca/HPS/Communities/Division+3/Sector1.htm Crime Manager: Sgt. Mike Senchyshak Division 3, Sector 1 Beats 3130, 3131, 3132, 3134, 3136, 3137 905-546-2447 msenchyshak@hamiltonpolice.on.ca

http://www.hamiltonpolice.on.ca/HPS/Communities/Division+3/Sector2.htm Sgt Paul Evans Division 3, Sector 2 Beats 3238, 3239, 3240, 3241 905-540-5142 pevans@hamiltonpolice.on.ca

http://www.hamiltonpolice.on.ca/HPS/Communities/Division+3/Sector3.htm Sgt David Hennick Division 3, Sector 3 Beats 3342, 3343, 3344, 3345 905-540-2447 dhennick@hamiltonpolice.on.ca

http://www.hamiltonpolice.on.ca/HPS/Communities/Division+3/Sector4.htm David Hennick is also listed as the sector 4 contact

http://www.hamiltonpolice.on.ca/HPS/Communities/Division+3/Sector5.htm Crime Manager: Sgt. Mike Senchyshak Division 3, Sector 5 Beats 3551, 3552 905-546-2447 msenchyshak@hamiltonpolice.on.ca

Permalink | Context

[ - ]

By Meredith (registered) - website | Posted September 28, 2009 at 12:36:11

In e-mail form. though I know the formatting will get a little messed up: "Sgt. Jo-Ann Savoie - Division 1, Sector 1" , "Sgt. Tina Potter - Division 1, Sector 2" , "Sgt. Ron Hayward - Division 1, Sector 3" , "Sgt. Chris Zafirides - Divison 1, Sector 4" , "Sgt. Shawn Blaj - Divison 2, Sector 1" , "A/Sgt. John Heide - Division 2, Sector 2" , "Sgt. Tim Bower - Division 2, Sector 3" , "Sgt. Laura wiltshire - Division 2, Sector 4" , "Sgt. Mike Senchyshak - Division 3, Sectors 1 and 5" , "Sgt. Paul Evans - Division 3, Sector 2" , "Sgt. David Hennick - Division 3, Sectors 3 and 4"

Permalink | Context

[ - ]

By Meredith (registered) - website | Posted September 28, 2009 at 12:36:54

Try this again...

"Sgt. Jo-Ann Savoie - Division 1, Sector 1" jsavoie@hamiltonpolice.on.ca, "Sgt. Tina Potter - Division 1, Sector 2" tpotter@hamiltonpolice.on.ca, "Sgt. Ron Hayward - Division 1, Sector 3" rhayward@hamiltonpolice.on.ca, "Sgt. Chris Zafirides - Divison 1, Sector 4" czafirides@hamiltonpolice.on.ca, "Sgt. Shawn Blaj - Divison 2, Sector 1" sblaj@hamiltonpolice.on.ca, "A/Sgt. John Heide - Division 2, Sector 2" jheide@hamiltonpolice.on.ca, "Sgt. Tim Bower - Division 2, Sector 3" tbower@hamiltonpolice.on.ca, "Sgt. Laura wiltshire - Division 2, Sector 4" lwiltshire@hamiltonpolice.on.ca, "Sgt. Mike Senchyshak - Division 3, Sectors 1 and 5" msenchyshak@hamiltonpolice.on.ca, "Sgt. Paul Evans - Division 3, Sector 2" pevans@hamiltonpolice.on.ca, "Sgt. David Hennick - Division 3, Sectors 3 and 4" dhennick@hamiltonpolice.on.ca

Permalink | Context

[ - ]

By UrbanRenaissance (registered) | Posted September 28, 2009 at 18:23:33

I sent an email to Sgt. Hayward asking how we can get a hold of the information from the "Down Town" area (Central and Beasley neighbourhoods). I figured I should post that fact here so no one else emails him and we end up bombarding the poor Sargent with emails. What I sent is below and I'll post any response I get from him.

Dear Sgt. Hayward,

My name is Ryan * and I'm currently involved in an online collaboration with other Hamiltonians to compile and present actual crime statistics for the various neighbourhoods in the city. The hope is to provide an accurate, non-biased source of information about crime here in Hamilton. It was started with Ward 1 because Councillor McHattie currently posts the reports submitted by the Crime Manager for West Town on his website, ( http://www.brianmchattie.ca/page2.php?id... ), but unfortunately the information for any other neighbourhoods has not been made easily available to the public and our effort has been stalled. You can see what was done with the Ward 1 data at this link, ( http://raisethehammer.org/blog.asp?id=15... ).

As the Crime Manager for Downtown I was curious if you knew how I could get copies of these reports (or even the raw data) for the two Downtown neighbourhoods you are responsible for. It would help our efforts tremendously and help to replace some of the long held myths about crime in this city with facts. Thank you for your time and I look forward to hearing from you soon.

Regards,

Ryan *

Permalink | Context

[ - ]

By Meredith (registered) - website | Posted September 28, 2009 at 21:55:26

Of the three main Divisions (each with subsectors), I've just got a file with all the Division One statistics (for year-end 2008 and some current ones) from Sgt. Chris Zafirides (with some help from Sgt. Savoie as well).

Here's the map of the divisions http://www.hamiltonpolice.on.ca/HPS/Comm...

I'll email the files over to Ryan (and anyone else who wants it).

Permalink | Context

[ - ]

By Ryan (registered) - website | Posted September 29, 2009 at 08:51:04

I just posted an update on the crime data situation:

http://raisethehammer.org/blog/1523

Permalink | Context

View Comments: Nested | Flat

Post a Comment

You must be logged in to comment.

Events Calendar

Recent Articles

Article Archives

Blog Archives

Site Tools

Feeds