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!