2024-10-25, Crash DB Workgroup Meeting
Intro
Informal Opening Discussion
Crash DB Systems Review
TraCS Systems and Crash Form development
Dave Malisch / Geri Polster
Likely Final of development for the Fall Pack with a tentative release in November.
Badger TraCS conference, recording is available.
TOPS Database and WisTransPortal
Steven Parker / Andi Bill
Maintenance Updates and System Stability
CRASHDB-1670: Server Maintenance, October 20
Prioritized JIRA Issues and Enhancements
JIRA In Progress
CRASHDB-1651: Meta Data – Review / Update Data Captured for DB and Extracts
New CRU metadata extract in production, pending review
CRASHDB-1570: Pipeline work on SOAP and REST
Deployed TST and UAT to new DevOps environment.
CRASHDB-1651: Duplicate Failure Message: Retransmission vs. Reuse
Pending CRASHDB-1570.
RP Planning
2023 RP Refinalization
Incorporate offline processing from DTIM
CRASHDB-1665: Data Model – New Field – RP Requested
Other RP JIRA Cases:
Data Catalog / S-FAS
CRASHDB-1671: Crash Data Catalogue – ICDG Access to Crash Database
Confluence: High Level Crash Data Flows
Purge and Archiving Processes
Purge and Archive processes continuing to run smoothly.
1,165,152 total archived crashes of which 552,897 represent purged crashes (the archive adds approximately 13K crashes per month). This includes 2,182,684 total image files.
HWYCLASS Working Group
Canceled October Meeting due to Conflict
Phase 2 Prototype Testing Rollup
Phase 3 Implementation Planning
[JIRA] (ITID-1838) Deer Crash Transmissions - Missing TLT links – FUTURE PACK
WisTransPortal / Community Maps
Tribal Crash Mapping Presentation at Wisconsin Tribal Transportation Conference
Community Maps citations and warnings data layer in progress – six agencies
BTO AASHTOWare Crash Data Automation Completed
City of Madison (Citian) Crash Data Automation Completed
Crash Records Unit
Brad Richter / Polly Ebbinger / Mike Satteson
Document Number Reuse/Retransmission Issues
We have been working with the TraCS Help Desk on these issues over the last month.
Once the updated error messages are live, this work will require less analysis to resolve.
MMUCC 6 Work
Early stages of work related to MMUCC 6.
Emphasis right now is on finding gaps between the current data and the MMUCC 6 standards.
Focused on preparing short- and long-term goals for implementing the new standards.
The FARS Test Board
Using a WIP, Internal to the FARS team Dashboard show the current status and strategies for improvement in Wisconsin FARS and fatal crash reporting.
DMV Systems and SR
Ken Matthews
Reference Point Coding
Ben Rouleau / Asadur Rahman
09/26-10/23 period summary
Jack McCaffrie: 2,548
Lukas Wellenstein: 3,582
Tristan: 799
Thresa Majeski: 1,659
Total: 8,588
RP coding needed - 2024: 5,440.
Crash Data Analysis and Reporting
Valerie Payne
Scheduled Topics and Briefing documents
A November / December Meeting
As usual, let’s consolidate the November and December Workgroup Meetings. Any Objections to scheduling the meeting on 13 December from 10:30 to 11:30?