Intro

Informal Opening Discussion

Crash DB Systems Review

TraCS Systems and Crash Form development

Dave Malisch / Geri Polster

TOPS Database and WisTransPortal

Steven Parker / Andi Bill

Maintenance Updates and System Stability

• Planned Maintenance Windows:

  • March 20 – Resolve System and Integration Java 11 and server deployment platform upgrade.

  • March 24 – Monthly server maintenance window.

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.

• March JIRA Cases:

  • Completed

    • CRASHDB-1536 – Resolve Pipeline Duplicate Crash Issue

      • Analysis and cleanup of 24+ duplicated crash records arising from the February 7^th production update.

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

    • CRASHDB-1550 – Crash Migration – Resolve and Integration

      • Successful redeployment on March 20 (noted above)

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

  • In Progress

    • CRASHDB-1349 - System Stability (Java 11 / Oracle 19c) Migration:

      • CRASHDB-1367 – Phase 1: Java Migration

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

      • Focus on REST and SOAP web service migration

    • CRASHDB-1543 – Safe at Home Redaction Requirements

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

      • Planning, analysis, and database updates for Safe at Home data privacy requirements.

    • Under Development

      • CRASHDB-1465 - Resolve - CUSTNMBR Enhancements during Migration

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

      • Record history, modulation, assignment workflow

Purge and Archiving Processes

• Purge and Archive processes continuing to run smoothly.

• 1,078,155 total archived crashes of which 486,304 represent purged crashes (the archive adds approximately 13K crashes per month).  This includes 2,016,488 total image files.

HWYCLASS Working Group

• Next workgroup meeting: 3/26.  Focusing on a comparison of the LINK-LINK method for highway crash roadway attribute assignments with a route-milepoint method based on spatial analysis.

WisTransPortal / Community Maps

• Community Maps production updates:

  • New filter selections for tribal areas, hit & run crashes, location type (I,N,PP,PL).

  • Crash flags technical documentation.

• WisTransPortal:

  • New tribal area flags, alignment with CM crash flags technical documentation

  • Data download enhancements in progress.

Crash Records Unit

Polly Ebbinger / Mike Satteson

CRU Issue Statistics:

MMUCC 6 Related Work:

A recent inquiry from the USDOT about crash data led to taking a look at the Work Zone section of the DT4000 as it is related to MMUCC. Because this section is mostly isolated from the rest of the crash report, we decided this would be a good place to start in comparing our data to the new MMUCC 6 standards. The first review of these new standards shows that the biggest change is the addition of a Work Zone Type section that replaces the previous Work Zone flag. The next steps will be to see how these new standards relate to our existing data and the DT4000.

DMV Systems and SR

Ken Matthews

Reference Point Coding

Asadur Rahman

Crash Data Analysis and Reporting

Valerie Payne

Scheduled Topics and Briefing documents

Close

Informal Closing Discussion