Correlation Analysis for Citation data between fatal and serious injury crashes

[atdservicebot]

Name

Xavier Apostol

What application are you using?

Other / Not Sure

Describe the problem.

We would like to see if there are any correlations between citation data and fatal (K) or serious injury (A) crashes.

Describe the solution you have in mind.

Do some deeper analysis of existing data using some AI techniques that can assist in our understanding of the relationship between citations and KA crashes.

How will we know that our solution is successful?

A report of the analysis is produced with the understanding of the correlation.

Users

Vision Zero Team

Sponsorship

Lewis Leff

Which Strategic Direction 2023 “Mobility” indicators would this new application impact?

['Safety']

Which Austin Strategic Mobility Plan goals would this new application support?

['Health & Safety — Protect Austinites by lowering the risk of travel-related injury and promoting public health.']

Describe any workarounds you currently have in place or alternative solutions you've considered.

N/A I did do some historical analysis to see numbers over time, but nothing substantial. The file (GIS Analysis.xlsx) can be found here: G:\ATD\ACTIVE TRANS\Vision Zero\Data\VZ Xavier Backup\Data Files\Muni Data Analysis

Is there anything else we should know?

12/31/2022

How have other divisions/departments/cities addressed similar challenges?

N/A

Requested By Xavier A.

Request ID: DTS22-105115

[Charlie-Henry]

• Comprehensive valuation of citations and injury severity
• The effect citations have on crashes, hypothesis that more citations=less crashes
• Roll up to some geospatial analysis

https://data.austintexas.gov/browse?q=Municipal%20Court%20Caseload%20Information%20FY&sortBy=relevance

Xavier A. has 2015-2022 data and will share with me

[Charlie-Henry]

I've geocoded about 95% of the records that Xavier provided. Will set up another follow up with him to go over what to do next.

[patrickm02L]

In Dev Planning 11/30/22, John mentioned looking at speed data. DSDD. Ask Xavier if he knows where to find this.

[patrickm02L]

01/05/23, VZ Sprint Review

• Work with Shelby Smith at TED to get an account to login to DSDD analysis.
• Xavier has a on-pager that speaks to the analysis on citations that has been lonely previously.
  • The work here can be used in a Discovery phase of research.
  • Potential to roll this into a research paper.
  • Set up meeting with Lewis, Xavier, and Charlie to go over what to do next.

[Charlie-Henry]

Lewis:

Citation correlation analysis: key research question - is there any relationship with totals of serious injuries + fatalities and the totals of speeding citations per year? Look into just ASMP level 3, 4, 5 as that would be most relevant.

Will add ASMP street level to this analysis and try to look at time of day + day of week effects.

[johnclary]

@Charlie-Henry i assume this work has completed but let me know if not 👍