Intro

Informal Opening Discussion

Crash DB Systems Review

TraCS Systems and Crash Form development

Dave Malisch / Geri Polster

End of March “Spring Pack”

TOPS Database and WisTransPortal

Steven Parker / Andi Bill

Maintenance Updates and System Stability

• CRASHDB-1742: Server Maintenance, February 23

  • https://wi-state-patrol.atlassian.net/browse/CRASHDB-1742   

Prioritized JIRA Issues and Enhancements

• Completed

  • CRASHDB-1732: Resolve Browser cache Issue for DT4002 Merge

    • https://wi-state-patrol.atlassian.net/browse/CRASHDB-1732

  • CRASHDB-1737: Resolve DB2 -> DB3 Migration task

    • https://wi-state-patrol.atlassian.net/browse/CRASHDB-1737  

• JIRA In Progress

  • CRASHDB-1739: RP Re-Finalization 2023

    • https://wi-state-patrol.atlassian.net/browse/CRASHDB-1739

    • Cleaning 42 Remaining RP Omit Flag Records

  • CRASHDB-1570: SOAP and REST Server Migration

    • https://wi-state-patrol.atlassian.net/browse/CRASHDB-1570

    • Investigating issue with IROC TST and UAT Processing

  • Ongoing JIRA Bug Reports per the Weekly TOPS / CRU IT Meetings

• In the Queue

  • RP Enhancements

    • https://wi-state-patrol.atlassian.net/browse/CRASHDB-1665

    • https://wi-state-patrol.atlassian.net/browse/CRASHDB-1586

    • https://wi-state-patrol.atlassian.net/browse/CRASHDB-210

  • CRASHDB-1651: Duplicate Failure Message: Retransmission vs. Reuse

    • https://wi-state-patrol.atlassian.net/browse/CRASHDB-1541

    • Pending CRASHDB-1570.

Purge and Archiving Processes

• Purge and Archive processes continuing to run smoothly.

• 1,221,341 total archived crashes of which 600,068 represent purged crashes (the archive adds approximately 13K crashes per month).  This includes 2,286,255 total image files.

FY26 SPR Project Planning

• Waiting on application process to commence.

HWYCLASS Working Group

• March 3 – BSHP Annual Meeting Presentation

• March 4 – Work Group Meeting

  • Phase 3 Implementation Planning

  • Automation Program Development

  • Goal to support 2024 HSIP Submittal

WisTransPortal / Community Maps

• Community Maps citations and warnings data layer in progress

  • 25 county / local agencies, 7 State Patrol in progress

• S-FAS Data Integration Planning

Crash Records Unit

Brad Richter / Polly Ebbinger / Mike Satteson

2024 Fatalities and Finalization

Our goal is to finalize the 2024 crash data on 2025-05-09 and to make the statically analysis extracts available to analysts on 2025-05-19.

We continue our work towards 100% FARS reportability verification of 2024 cases before finalization. In most cases this verification hinges on the availability of death certificate information. The bulk of the death records that we need come in the form of monthly DHS extracts.

2024 Verification Status Counts

2024 Fatalities Needing Verification by Month of Death

The January fatality was never born, so we do not expect a death record. There are 2 out of state deaths that require assistance from that state’s FARS team. Of the 29 fatalities in need of verification but with the death record identified, 23 are marked as pending, meaning that the coroner or medical examiner has not yet concluded their investigation of the death.

2024 Fatalities, Reasons Dismissed or Withdrawn

Dismissals are not FARS reportable fatalities that were not included in a Daily Fatality Report. Withdrawals were announced in a Daily Fatality and had to be withdrawn after they were found not to be reportable.

DMV Systems and SR

Ken Matthews

Reference Point Coding

Ben Rouleau / Asadur Rahman

2024Testing to end on 5 March. 7 March packaging.

Jack McCaffrie: 582

Lukas Wellenstein: 2,120

Tristan: 650

Thresa Majeski: 1,371

Total: 4,723

RP coding needed - 2023: 1,432

RP coding needed - 2024: 3,411

Crash Data Analysis and Reporting

Valerie Payne

306 2024 Analysis requests

58 so far for 2025

Analyzing request categories to develop an understanding of the types of requests.

Scheduled Topics and Briefing documents

Close

Informal Closing Discussion