JRNL 3165 - Assignment #4: Data Update 3

Chart

Unanswered Question

The dataset I used is quite comprehensive, but it is missing one data point that could lead to some very interesting analysis: the location of the issued ticket. One question that I would be very curious to see an answer to is related to the subset of tickets issued for 'Street Traffic' bylaws - Where in Port Moody are you the most likely to receive a parking ticket? Given the depth of the data that I already have, the analysis could go even deeper. Further topics like when you are the most likely to receive a parking ticket at a specific location, or why certain areas see more tickets than others could also be explored.

How would you get the data?

It is very likely that Port Moody already stores the ticket location alongside the rest of the bylaw ticket information that they have publicly available. I believe that it would be possible to obtain the location information as an addition to the existing dataset that I am using. Bylaw enforcement in Port Moody is carried out by their Bylaw division. As such, they would likely be the best place to initially reach out to regarding that addition to the dataset. Failing that, Port Moody is subject to Freedom of Information requests, so one could be submitted using the information provided on their website.

JRNL 3165 - Assignment #3: Data Update 2

Lead

The number of tickets issued for Port Moody's most frequent bylaw infractions saw monthly increases of up to 66% during the Summer, according to City of Port Moody data.

Excel Workbook and Explanation

Port Moody Bylaw Tickets - Raw data & Slice

The above Excel workbook contains two sheets, the first being the raw data from the City of Port Moody, and the second being a small slice of data which was used for analysis. The slice of data is based on total bylaw tickets issued for the 'Rocky Point boat launch & Parking Regulation' and 'Street Traffic & Public Places' categories. These categories were chosen as they were the two most frequently ticketed infractions in the data set.

The slice makes use of two tables: one for the monthly percentage of total bylaw tickets issued for each bylaw description, and the other for the change in percentage each month. Comparing these two tables allows for a reasonable analysis of which monthly increases were significant and not based on smaller numbers (e.g. for a 0.5% to 0.9% increase).

Original Dataset Link

I am using the 'Bylaw Tickets' dataset from Port Moody's Open Data Portal.

News Story Link and Brief Summary

A Tri City News article notes that Port Moody bylaw officers were moving from warnings to fines at Rocky Point during the summer of 2015. The article also notes that the city now has extra bylaw officers, one of which is stationed at Rocky Point to monitor parking on the weekends. This increase in enforcement can help explain why parking enforcement at Rocky Point was part of the second most frequently ticketed bylaw description.