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_DESC | Number of Violations | Percentage of Violations |
---|---|---|
SPEED 11-15 MPH OVER THE SPEED LIMIT | 4,635,154 | 71.48% |
SPEED 16-20 MPH OVER THE SPEED LIMIT | 937,115 | 14.45% |
FAIL TO STOP PER REGULATIONS FACING RED SIGNAL | 303,534 | 4.68% |
PASSING STOP SIGN WITHOUT COMING TO A FULL STOP | 276,262 | 4.26% |
SPEED 21-25 MPH OVER THE SPEED LIMIT | 168,588 | 2.60% |
TURN RIGHT ON RED WITHOUT COMPLETE STOP | 97,729 | 1.51% |
SPEED 26-30 MPH OVER THE SPEED LIMIT | 20,007 | 0.31% |
OVER 25 MPH IN EXCESS OF LIMIT ON NON-CONTROLLED A | 17,787 | 0.27% |
OVER 25 MPH IN EXCESS OF LIMIT ON CONTROLLED ACCES | 15,541 | 0.24% |
RIGHT TURN ON RED, VIOLATION NO TURN ON RED SIGN | 9,323 | 0.14% |
SPEED UP TO TEN MPH OVER THE SPEED LIMIT | 1,872 | 0.03% |
TRUCK RESTRICTED ROUTE | 1,481 | 0.02% |
TURN RIGHT ON RED WHEN PROHIBITED | 37 | 0.00% |
FAIL TO CLEAR INTERSECTION | 15 | 0.00% |
FAIL TO KEEP IN LANE | 5 | 0.00% |