The ACS is geographically organized by hierarchy–block groups at the most granular level, followed by census tracts, counties, states, regions and the nation as a whole. Census tracts are a common grouping used in geographic analysis since they are specifically designed for this purpose. Tracts are small, relatively permanent statistical subdivisions of a given geographic… Continue reading DC Gender Map Part II
Author: admin
DC Gender Map Part I
Dating in DC is notoriously difficult; and (depending on who you ask), it’s especially difficult for straight (cishet) women. According to Census Bureau data gathered in the American Community Survey (ACS) the city’s demographics make a strong argument for this case. The overall male-to-female gender ratio (number of males divided by number of females) is… Continue reading DC Gender Map Part I
Geopandas and GIS exploration
Got some good feedback and response from the reddit post and now I’m game to try some mapping functionality out using geopandas and matplotlib. Getting geopandas installed was a pain, but I did learn how to set up a new environment specifically for geographic analysis in the process. Also fetched the TIGER shape files from… Continue reading Geopandas and GIS exploration
Reddit post
Does it feel like the cops aren’t really doing traffic enforcement anymore? Last week I read this comment about MPD not enforcing traffic violations and it inspired me to look at some data I’ve been analyzing over the past few weeks. I pulled more than seven million moving violation citations from DC Open Data‘s API.… Continue reading Reddit post
Exploring MD Drivers’ DISPOSITION_TYPE
There are 6,306 violations with an ATE_TYPE (those that are likely to be issued by automated traffic cameras). 3,093 of these have been paid (about 49%). ATE_TYPE % Speed Safety Camera Enforcement Sites 4,863 77.12 Red Light Safety Camera Enforcement Sites 912 14.46 Stop Sign Safety Camera Enforcement Sites 531 8.42 Looking at the DISPOSITION_TYPE… Continue reading Exploring MD Drivers’ DISPOSITION_TYPE
Some changes to previous analysis
Given the lack of ticket numbers in 2022, I am going to limit the analysis to 2017-2021. Also there is a stunningly low number of license plate information to work with. Huge amounts of the dataset have no state drivers license or license plate information: plate_and_lic_combined % 6,028,469 81.76 DC 1,130,953 15.34 MD 122,663 1.66… Continue reading Some changes to previous analysis
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… Continue reading Analysis Process 7/11/2022
Woke up this morning and wrote myself some code
The dataset did not specify whether the moving violation was assessed through an automated process by traffic camera. In DC this is called Automated Traffic Enforcement (ATE). According to Open Data DC, 138 cameras are managed by the District Department of Transportation (DDOT). The cameras, which are scattered throughout the city, are used as a… Continue reading Woke up this morning and wrote myself some code
Sum of fines YoY
Fines over the 1/1/17-5/30/22 period totaled $893,151,204. Breakdown by year and violation type below: 2017: $137,300,588 2018: $148,798,179 2019: $171,205,768 2020: $178,392,212 2021: $187,954,122 2022: $69,500,335 Here’s the top ten moving violations by total dollar amount in that time: SPEED 11-15 MPH OVER THE SPEED LIMIT: $531,245,415 SPEED 16-20 MPH OVER THE SPEED LIMIT: $168,137,690… Continue reading Sum of fines YoY
Top most violations
Analyzing @opendatadc @DCVisionZero data. From Jan 1, 2017 to May 30, 2022 #DC issued 7,385,750 tickets for moving violations. What are the top five most common? SPEED 11-15 MPH OVER THE SPEED LIMIT: 5,015,385 SPEED 16-20 MPH OVER THE SPEED LIMIT: 1,019,346 PASSING STOP SIGN WITHOUT COMING TO A FULL STOP: 374,539 FAIL TO STOP… Continue reading Top most violations