2025-01-24, Crash DB Workgroup Meeting
Intro
Informal Opening Discussion
Crash DB Systems Review
TraCS Systems and Crash Form development
Dave Malisch / Geri Polster
March Pack being packaged, available by Monday
New baseline in the works (20.01 series), testing needed, including by the CRU expected for the Fall.
It is easy to switch between the old and new baselines
Categories,
F2 help to Confluence?
TOPS Database and WisTransPortal
Steven Parker / Andi Bill
Maintenance Updates and System Stability
CRASHDB-1735: Server Maintenance, February 2
Prioritized JIRA Issues and Enhancements
Completed
2024 End of Year Task List
CRASHDB-1665: RP Data Upload - 2023 Auto V1
CRASHDB-1733: SAS Libraries - Unanticipated Table Naming Scheme Changes
JIRA In Progress
2023 RP Re-Finalization [JIRA Case Pending]
RP Enhancements
CRASHDB-1570: SOAP and REST Server Migration
CRASHDB-1708: Review Resolve Users, Roles, and Permissions
Ongoing JIRA Bug Reports per the Weekly TOPS / CRU IT Meetings
In the Queue
CRASHDB-1651: Duplicate Failure Message: Retransmission vs. Reuse
Pending CRASHDB-1570.
Purge and Archiving Processes
Purge and Archive processes continuing to run smoothly.
1,206,317 total archived crashes of which 588,324 represent purged crashes (the archive adds approximately 13K crashes per month). This includes 2,257,385 total image files.
HWYCLASS Working Group
January 28 Work Group Meeting
Phase 3 Implementation Planning
Initial Automation Program Development
Goal to support 2024 HSIP Submittal
WisTransPortal / Community Maps
Community Maps citations and warnings data layer in progress
13 county / local agencies, State Patrol in progress
New Tribal Profiles - in progress.
Crash Records Unit
Brad Richter / Polly Ebbinger / Mike Satteson
FARS Work
As promised at the previous meeting, we have begun to examine MV1238 coroner reports to determine if and how they might be useful. The answer is that they cab be as source of notification and of cause of death information.
Notification Source for Crash Fatalities Announced in January
Source | 2023 | 2024 | 2025 |
---|---|---|---|
Teletype | 14 | 18 | 18 |
TraCS | 0 | 6 | 6 |
Crash Report | 27 | 4 | 14 |
Coroner Report | 0 | 0 | 7 |
Orphan Fatal supplement | 0 | 0 | 2 |
Non-Routine Activity Report | 0 | 0 | 7 |
DMV Systems and SR
Ken Matthews
Reference Point Coding
Ben Rouleau / Asadur Rahman
6,000 2024 - 7800 - list of auto coded crashes.
700 2023 crashes
Crash Data Analysis and Reporting
Valerie Payne
Scheduled Topics and Briefing documents
2024 Data Finalization
It is not too early to begin discussion of crash year 2024 data finalization
Is end of May still the appropriate target date”?
DROC/DT4000 finalization?
5-year combined data as a package
Let’s get the open data our by end of June