The Lost Revenue of the Baltimore Traffic Cameras

January 21, 2015

The title of the dataset I’m working with on Baltimore’s open data portal is “Parking Citations.” I downloaded a snapshot of the dataset which ended up being 2,689,647 total citations through January 12, 2015.

But parking is not the only thing captured in this set. Traffic camera violations are also here (“Fixed Speed Cameras,” “Mobile Speed Cameras,” and probably some “Red Light Violations” and “Right on Red” citations) which were far and away the city’s largest revenue generator out of all of the infraction types captured here. The fixed speed cameras alone issued nearly $28 million in citations over a three year period, until the program was ended. The last two rows appear to be one-off citations. It’s also curious that the last record of a “Snow Emergency Route Violation” was in August. In Baltimore.

Citation descriptions sorted by total fines. Highlighted in red are the least recent dates of the last recorded citation and the shortest data time spans, respectively. Highlighted in green are the largest annual revenue generators. Click here to enlarge.

This all isn’t quite syncing up with what the Baltimore Sun reported about the traffic camera program. According to this article, the traffic camera program generated about $140 million over 10 years. The data contained in Baltimore’s open data portal must be incomplete, since I’m seeing a total of about $127 million for all violation types, not just cameras.

To show this a bit more dramatically, here’s the time series of total monthly citations issued for the top 10 revenue generator categories. It’s pretty clear that the data are incomplete since the traffic camera categories should have dominated for 10 years straight, and we’re seeing no significant records before 2007, even though the earliest start dates shown in the table above show dates typically starting in 2002-2003, with “Red Light Violations” starting in 1999. Unfortunately, the Baltimore open data portal does not provide a data dictionary or substantive description of what all is contained in the dataset and what each field represents. For example, in addition to “violFine,” there are “balance,” “openFine,” and “openPenalty” fields which all include “$” signs in the records to indicate currency. These aren’t defined anywhere.

Total monthly citations for top 10 revenue generators. Click here to enlarge.

I wouldn’t say that the lack of definitions and descriptions of the data render them completely useless, but it does make it more difficult to make apples-to-apples comparisons and draw conclusions.



This is a new section I'm adding, inspired by Ben Wellington's excellent blog I Quant NY.
Data obtained from Open Baltimore.
Analysis conducted using Python, Pandas, and Microsoft Excel.
Inspiration from I Quant NY.

The Lost Revenue of the Baltimore Traffic Cameras - January 21, 2015 - Justin Elszasz