Write Blog Post on "Worst State" drivers

[banjtheman]

What is the Task

Create a blog post using the data from the moving violations table to identify truly the worst state drivers

Why do we want to do this

This is a long contested debate in the DMV, can we use data to find out the answer?

How can I get started?

1. Connect to PostGIS Database ask @CharlotteJackson for credentials
2. Do a query to get all moving violations

Example

select issue_date,latitude, longitude,fine_amount, violation_code, violation_process_desc,plate_state, objectid FROM analysis_data.moving_violations

3. Answer the following questions in a blog format
   • Which state had the most violations year over year
   • Which state had most in 5 years
   • What was the most common violation_process_desc for each state
   • Which state had the most speeders?
   • Which state runs the most stop signs
   • Which state does the most illegal U turns
   • What location had the most violations
   • Which state has the most "FAIL TO YIELD RIGHT OF WAY PEDESTRIAN IN ROADWAY"
   • For each state where was the most common location for violations
   • Anything else intresting you find in the data

Here is an example notebook exploring the data https://github.com/CharlotteJackson/DC_Crash_Bot/blob/master/notebooks/Moving_Violations_/Moving%20Violations.ipynb

Definition of Done

Blog post is in GWW

[banjtheman]

From meeting

• Only about 10% of data has state plates?
• Aisling did some cool queries to get data
• Group by violation type, and get count by plate good way to get stats

[lhschwab]

Hi! Hoping to work with Aisling on this!