2023-10-27, Crash DB Workgroup Meeting
- Michael Satteson
- Steven Parker
- Soujanya Jarabana (Unlicensed)
Intro
Informal Opening Discussion
Crash DB Systems Review
TraCS Systems and Crash Form development
Dave Malisch / Geri Polster
Packing last fixes for Fall Pack
Bug fixes for the March Pack
Tracks Users Conference
Underride / Override
TOPS Database and WisTransPortal
Steven Parker / Andi Bill
Maintenance Updates and System Stability
Upcoming Maintenance Windows:
11/22/2023 – November server maintenance window
Completed Maintenance Windows:
10/22/2023 – October server maintenance window
Unplanned Outages
9/27 – 10/17, intermittent
Prioritized JIRA Issues and Enhancements
2022 Finalization
RP coding process for 2022 data is continuing and will be merged into the frozen data set once completed.
October JIRA Cases:
Purge and Archiving Processes
Purge and Archive processes both continuing to run smoothly.
1,021,431 total archived crashes of which 413,938 represent purged crashes (the archive adds approximately 13K crashes per month). This includes 1,909,898 total image files.
FY24 Project Planning
FY24 SPR project underway. Thank you for everyone’s help with the process!!!
HWYCLASS Working Group
Testing and refinement of prototype SQL queries.
Update on testing status later in the meeting.
WisTransPortal / Community Maps
Community Maps in Progress:
Advanced Search performance enhancements
Advanced Search crash flag documentation and filter logic enhancements
User Group survey
Crash Records Unit
Soujanya Jarabana / Mike Satteson
Questions from Law Enforcement Agencies
CRU business unit provided email, phone, and remote support to law enforcement agencies to resolve Validation errors in the DT4000 crash form.
We received 7 LEA questions in the last 4 weeks about different crash scenarios
2 questions are related to transmitting Fatal Supplements.
3 questions are about Non-Reportable Crashes
1 related to an illegally parked vehicle
1 related to the manner of collision clarification
Crash Database & Resolve System Updates
Email issue with DT4000 Daily and Weekly Transmission Report - Intermittent Errors
Issue:
This is regarding the failure of Crash Database and Resolve System to send daily and weekly automated emails to distribution lists (600 + recipients) which is caused by the UW campus email server imposing a limitation of 500 recipients per message.
The problem started on 2023-09-30 and a permanent code fix was implemented on 2023-10-10.
When:
Start Date: 2023-09-30
End Date: 2023-10-17
On 10/17/23, TOPS Lab informed us that UW technologists have resolved email delivery delays.
Impact:
Email Recipients were not able to receive daily and weekly transmission reports.
Resolution:
During the failure period, TOPS lab has sent reports directly to the recipients who have contacted TOPS / CRU.
A code fix was performed on the two email programs to break down email processes into smaller recipient lists.
Change Requests submitted to CAB
In the last four weeks, 1 normal change request and 1 Emergency Change Request were submitted to the Change Advisory Board which includes:
Emergency Change Request to address https://wi-state-patrol.atlassian.net/wiki/spaces/CDD/pages/2227863553
Monthly server maintenance for October 2023 was performed on https://wi-state-patrol.atlassian.net/browse/CRASHDB-1419
Transmission failures
We addressed 20 transmission failures in the last 4 weeks after providing solutions to the agencies.
6 are transmitted
6 was transmitted as other Document (Duplicate Document Number)
8 are pending with the agency.
2023 Badger TraCS User Conference - DT4000 Crash Form
The following topics were covered.
Badger TraCS – Pack updates
Fatal Notification
Fatal Supplement – Vehicle Underride / Override fields
Bug Fixes
Common Transmission Failures
Questions from Agencies
FARS Case Management System Developments
We are finding that basic case setup using Box, Jira and Julia is working well.
A next significant step is to formalize fatal crash screening and evaluation for reportability is proving to be a challenge. The FARS team is in the weeds on the fine details of what constitutes a crash. We are working to accommodate this perspective while at the same time developing practical systems for provisional determinations of reportability for Daily Fatality reporting.
Crash Level Reportability Evaluation
Cause of Death Reportability Evaluation
DMV Systems and SR
Ken Matthews
Ken is out of the Office today, but sends his regards and
Reference Point Coding
Ben Rouleau / Asadur Rahman
Jacob: 4,222
Erickson: 296 (September 21,22)
T Larene: 1,672 (September 23 – October 25)
Total: 6,190
RP coding needed for 2022: 13,502
Crash Data Analysis and Reporting
Valerie Payne
DSP PPA team is growing. Interviews for a 5th analyst.
Data requests for Walworth County,
Crash Stats Cleanup, Crash Sheets to OPA
Fatal Crashes in Milwaukee (Bike Fed)
All crashes in WI for PhD research
Brian Porter
Update to Intersection Inventory Kevin S. screen the state network for crashes to identify intersections needing engineering countermeasures
Testing on AASHTOWare software
Scheduled Topics and Briefing documents
Crash Database Roadway Classification and Ownership Work Group Update (Steven P.)
Meeting Schedule
Lets plan for a combined November December Workgroup meeting on 8 December. I’ve noticed that Friday’s are not good for some workgroup members. Should we consider shifting our meetings to Thursdays starting with the January 2024 meeting?