Using Toronto Open Data to Analyze Parking Tickets Over 2.8 million parking tickets are generated every year.
-
Download the data (2014 as example) Toronto Tickets 2008-Present
-
Prepare the data (./prepare.sh)
-
Generate the result (./run.sh & script.pig)
This project uses a simple Apache Pig script to load the fine data using LocalJobRunner (non-mapreduce mode) and identify the worst street offenders.
An analysis from Metro News in 2012 highlights some of the problem areas shown here.
The worst 25 by set fines ($):
410 COLLEGE ST,415870.0 - A Church or U of T perhaps
1090 DON MILLS RD,370350.0 - Shops at Don Mills
1 BRIMLEY RD S,367880.0 - Scarborough Bluffs
3401 DUFFERIN ST,235490.0 - Yorkdale
20 EDWARD ST,231190.0 - Atria at Bay, former World's Biggest Bookstore (Eaton Centre)
JAMES ST,187110.0
45 OVERLEA BLVD,185740.0
60 MURRAY ST,183260.0
35 BALMUTO ST,175310.0
2075 BAYVIEW AVE,167935.0
18 GRENVILLE ST,162975.0
80 MILL ST,148610.0
939 LAWRENCE AVE E,143980.0
40 ORCHARD VIEW BLVD,139590.0
1265 MILITARY TRL,128560.0 - U of T Scarborough
555 REXDALE BLVD,122760.0
225 KING ST W,116240.0
40 ASQUITH AVE,115800.0
300 BOROUGH DR,114315.0
70 MILL ST,113360.0
401 COLLEGE ST,111600.0
DORIS AVE,106630.0
100 KING ST W,105410.0
66 WELLINGTON ST W,103880.0
40 MURRAY ST,102875.0