2024-08-23, Crash DB Workgroup Meeting
Intro
Informal Opening Discussion
Crash DB Systems Review
TraCS Systems and Crash Form development
Dave Malisch / Geri Polster
No update this month.
TOPS Database and WisTransPortal
Steven Parker / Andi Bill
Maintenance Updates and System Stability
Upcoming Maintenance Windows:
August 25 – Monthly server maintenance window.
Completed Maintenance Windows
July 31 - Low-Risk Resolve Update Window
Production Change Freeze:
August 5 – 16, Fall Primary
Integration service stalled on August 13
Prioritized JIRA Issues and Enhancements
JIRA Completed
CRASHDB-989 - RP Coding - Implement Omit List Functionality in the Crash DB
CRASHDB-1610 – Bug/Enhancement: Error when Processing Amendment
JIRA In Progress
CRASHDB-1637 – Resolve – 503 Error
Focused on new application server environment.
JIRA On Deck:
CRASHDB-1626 – 2023 Finalization – Open Data Extracts
CRASHDB-1627 – 2023 Finalization – CODES Extracts
CRASHDB-1570 – Pipeline work on SOAP and REST (UAT)
Purge and Archiving Processes
Purge and Archive processes continuing to run smoothly.
1,138,874 total archived crashes of which 531,976 represent purged crashes (the archive adds approximately 13K crashes per month). This includes 2,132,673 total image files.
HWYCLASS Working Group
Working group meeting Tuesday, August 27
Focus on functional class for 2023 HSIP
Comparison to 2022 HSIP values
WisTransPortal / Community Maps
Community Maps ATSIP TRF Presentations, GCHS Session
Working with BTO (AASHTOWare)
City of Madison (Citian)
Crash Records Unit
Polly Ebbinger / Mike Satteson
Issue Resolution Summary
Issue Type | New since 7/26 | Resolved since 7/26 | Remaining |
|---|---|---|---|
Document # Reuse* | 21 | 12 | 14 |
Retransmissions | 10 | 10 | 0 |
Potential Duplicate | 5 | 21 | 0 |
LE Questions | 3 | 8 | 0 |
FARS
Continuing to work with the new case management system.
Beginning work on updating reports.
DMV Systems and SR
Ken Matthews
No update this month.
Reference Point Coding
Ben Rouleau / Asadur Rahman
07/25-08/21 period summary
Jacob: 1,268
Jack McCaffrie: 1,753
Lukas Wellenstein: 2,408
Tristan: 1,561
Thresa Majeski: 946
Total: 7,936
RP coding needed - 2023: 12,162. Jack completed 413 crashes from 2023.
RP coding needed - 2024: 16,362.
Crash Data Analysis and Reporting
Valerie Payne
Updated county profiles
Factsheets being reviewed by OPA
Pursuit data report
Seatbelt data finalized
Scheduled Topics and Briefing documents
Municodes Discussion
Stephanie Voller
If anyone wants a copy of the updated MUNICODE list, so they can update their copy of the data dictionary.
Data dictionary will be updated.
If anyone wants to be added to the distribution list from the DMV to be notified when MUNICODES are updated.
DOT DSP Crash Database crash.database@dot.wi.gov & DOT BadgerTraCS BadgerTraCS@dot.wi.gov get notifications already. We will have the BOTS analysts added soon. It may be good to see if there are any other interested parties.
Anyone else interested in being notified should contact the DMV: Barb Okonski.