Through the Help Me Investigate site , I came across an investigation regarding parking tickets, with the aim to find the most ticketed street in Birmingham in FY09. It sounded interesting, and I was delighted to see a FOI request from Heather Brooke (here it is on What Do They Know)
Data, it’s a rather ambiguous term. Anything can be seen as being a form of data, if you can ‘track’ it and put it in a spreadsheet then it sounds like data to me. The issue with data is that it can be rather hard to infer anything meaningful, especially if you are provided with a lot of data.
This is what happened with the data we were provided, it was in 3 separate excel files due the volume of tickets issued – a staggering 135,656 in a single year. To make it more manageable for everyone I consolidated the data into one single text file. So that the data could be ‘mined’ using a database, or in my case visualised. If you are interested the data is freely available.
The joy of data visualisation, is that you an instantly see and drill down into patterns, trend and other interesting items that you spot. This can make it easier and quicker to get some good solid numbers. You can see some graphs that I produced.
So what do we find? Of the 135,656 tickets issued between 1st April 2008 – 31st March 2009, we can see that the most ticketed street in Birmingham was Alum Rock Rd, Washwood Heath (in Liam Byrne’s constituency) with 3,995 tickets.
That itself is a lot of tickets, but what is more surprising, is that if you take the 5th most ticketed spot (Alcester Road, Moseley) only 1,545 tickets were issued. Quite a difference.
The other interesting point on location, is that Livery Street Car Park (by Snowhill station) is the second most ticketed spot at 3,439. Yet this is a carpark, the majority of private sector carparks allow you to pay in full the amount required for your stay. Unfortunately Livery is a pay in advance, so if you get distracted shopping you are likely to be ticketed for overstaying.
One might expect that all staff are issuing tickets ‘fairly’ and in accordance with the rules. Though it’s surprising to see that the warden BM739, issued 5,080 tickets. The next ‘top’ ticketer issued 3,559. This shocked me, as that’s a LOT of extra tickets by BM739.
You can see the tweet I sent:
“Look out for parking enforcer BM739, top ticketer, mainly ladywood and city centre”
In general, we can see that the amount of tickets being issued over the year increased, month on month. Which suggests that either Birmingham parking wardens are being told to be more strict, that there are more wardens out and about or everyone is being told to be like BM739!
So that’s a quick run through what I found. I will be putting the data out in a form that will allow others to interact with it, and I’m also considering the value of seeing both the historic data held. As well as some additional fields, such as if the ticket was disputed. Do the tickets that BM739 issue get disputed the most?. Is there a particular parking infraction that is successfully appealed 80% of the time etc.
If you have any specific questions, add them as a comment, or email me on email@example.com. The software used to create the graphs, is available for a 15 day trial at http://www.tableausoftware.com/, the table is from Google Fusion (Birmingham Tickets Table), why not give it a go yourself?