Analysis Process 7/11/2022

Isolating those tickets in the dataset that begin with either ‘F’ or ‘D’ reveals a subset of 6,484,450, or about 88% of all tickets. Of those, 4,321,029 are tagged with a value under the ATE_TYPE column generated by the algorithm (about 67% of those tagged with ‘F’ or ‘D’). Looking for those ticket values NOT starting with ‘F’ or ‘D’ reveals a subset of 486,051 or about 7.5% of those starting with ‘F’ or ‘D.’ If those without ticket number data are dropped, the number of ATE_TYPE drops to zero.

Most of the top violations in the ‘F’ or ‘D’ subset match the stated purposes of the cameras with a few insignificant outliers at the bottom of the list:

VIOLATION_PROCESS_DESCNumber of ViolationsPercentage of Violations
SPEED 11-15 MPH OVER THE SPEED LIMIT4,635,15471.48%
SPEED 16-20 MPH OVER THE SPEED LIMIT937,11514.45%
FAIL TO STOP PER REGULATIONS FACING RED SIGNAL303,5344.68%
PASSING STOP SIGN WITHOUT COMING TO A FULL STOP276,2624.26%
SPEED 21-25 MPH OVER THE SPEED LIMIT168,5882.60%
TURN RIGHT ON RED WITHOUT COMPLETE STOP97,7291.51%
SPEED 26-30 MPH OVER THE SPEED LIMIT20,0070.31%
OVER 25 MPH IN EXCESS OF LIMIT ON NON-CONTROLLED A17,7870.27%
OVER 25 MPH IN EXCESS OF LIMIT ON CONTROLLED ACCES15,5410.24%
RIGHT TURN ON RED, VIOLATION NO TURN ON RED SIGN9,3230.14%
SPEED UP TO TEN MPH OVER THE SPEED LIMIT1,8720.03%
TRUCK RESTRICTED ROUTE1,4810.02%
TURN RIGHT ON RED WHEN PROHIBITED370.00%
FAIL TO CLEAR INTERSECTION150.00%
FAIL TO KEEP IN LANE50.00%