Thread by @wjfarr

To follow up on yesterday's repeat red light violation analysis, here is some more horrifying data from the same source regarding drivers repeatedly speeding in school zones. #VisionZero

It should go without saying, but considering how few speed cameras are permitted in NYC and how constrained their hours and locations are, this captures a minuscule fraction of the reckless driving in our city.

Even still, there are *hundreds of thousands* of drivers who have been caught driving dangerously 3 or more times! *Thousands* of drivers have accumulated *dozens* of violations. They are without doubt a menace on our streets, and likely to kill with their recklessness.

Even if their identities can't be confirmed to personally charge them with a crime, there is abundant evidence to prove that their property is being used in the commission of deadly crimes. As such, @nysdmv ought to revoke their vehicle registration.

sees fit to confiscate #ebikes from overworked and exploited delivery cyclists, yet hardly bats an eye when *hundreds of thousands* of deadly vehicles cause *actual* harm to New Yorkers every day with impunity. @BikingPublic

Data footnote: I learned how to sum repeated plate numbers within the NYC Open Data Portal, so was able to exclude single offenders, which allowed me to work within the Excel row constraint. data.cityofnewyork.us/City-Governmen…

Chart footnote: I plotted the results on a semilog axis to both capture both the magnitude of violators at the lower end of repeat offenders as well as the magnitude of offenses at the higher end of repeat offenders.

I will also add these offenses are summed over about 3 years (since we're still early 2018), which is about twice the length of time that it takes for points to be removed from you license. Even still, half of that sum is a horrifying number of errant drivers.

Some overall stats:
844,726 (61%) single offenders committed 844,726 violations (32%)
538,086 (39%) repeat offenders committed 1,762,236 violations (68%)
In total, 1,382,812 offenders committed 2,606,962 violations.
The data was still quite unwieldy, so I welcome any checks.