/
2024-05-24, Crash DB Workgroup Meeting

2024-05-24, Crash DB Workgroup Meeting

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

  • Completed Maintenance Windows:

    • May 19 – Monthly server maintenance window.

    • May 15 – 2023 Finalization Window

Prioritized JIRA Issues and Enhancements

Purge and Archiving Processes

  • Purge and Archive processes continuing to run smoothly.

  • 1,103,748 total archived crashes of which 506,184 represent purged crashes (the archive adds approximately 13K crashes per month).  This includes 2,065,756 total image files.

HWYCLASS Working Group

  • Next working group meeting Tuesday, May 28

  • LINK-LINK vs. Route-Milepoint comparison for highway crashes (STN), preliminary analysis / questions for local road crashes (WISLR).

WisTransPortal / Community Maps

  • Community Maps User Spring 2024 Group Meeting:  Wednesday, May 29

  • Community Maps Flags Technical Documents: available on CM Help Page since March

Proposed:

  • Adding the CM flags to the Extracts (future discussion)

  • Crash Database and Resolve System Upgrade (TRCC FY25-FY28)

    • Year 1: 10/2024 – 9/2025

      • Project Planning and Coordination

      • MMUCC 6 Elements and Attributes

    • Year 2: 10/2025 – 9/2026

      • TraCS / Resolve Requirements

      • TraCS / Resolve Development – Phase I

    • Year 3:  10/2026 – 9/2027

      • TraCS / Resolve Development – Phase 2

      • TraCS / Resolve Testing and Acceptance

    • Year 4: 10/2027 – 9/2028

      • Rollout Planning and Outreach

      • TraCS / Resolve Rollout January 1, 2028

      • Post-Rollout Maintenance and Support

Crash Records Unit

Polly Ebbinger / Mike Satteson

Issue Resolution Summary

Issue Type

New since 4/26

Resolved since 4/26

Remaining

Issue Type

New since 4/26

Resolved since 4/26

Remaining

Document # Reuse*

26

35

6

Retransmissions

3

3

0

Potential Duplicate

2

2

2

LE Questions

7

6

1

LEA Question Summary

The following LEA questions were addressed since the last workgroup meeting:

  • Greyed out crash type box

    • Issue: LEA was trying to change a crash report from a standard crash to a lesser crash.

    • Resolution: Reiteration that this ability was removed with the recent TraCS update.

  • Bus crash

    • Issue: How to enter multiple passengers.

    • Resolution: Pointed the agency to the F2 help regarding adding additional individuals as well as the only requirement being entering the injured passengers.

  • Postal carrier van

    • Issue: How to select the correct body style

    • Resolution: Select the one that is most appropriate as there is no validation on this combination.

  • Citations

    • Issue: Officer created citations prior to creating the crash report.

    • Resolution: Provided the F2 help document for adding crash number after the citations are created.

  • Hit & Run:

    • Issue: Entering the H&R unit without all of the pertinent information.

    • Resolution: Provided direction for the requirements and “gotcha” entries that create issues.

  • Non reportable crash

    • Issue: Agency wanted to know how to amend a non reportable crash; no change in reportability.

    • Resolution: While trying to determine why this was needed, the agency indicated that they were able to make the change; since this is non reportable, the issue was closed out.

  • Restricted driver info

    • Issue: LEA requested information on restricting access to a juvenile driver’s information because of “threats” from a party related to the other driver.

    • Resolution (pending): The LEA was provided information related to open records requirements and some considerations regarding this situation. As they have not responded, this issue is currently still open.

DMV Systems and SR

Ken Matthews

ken is unavailable but sends his .

Reference Point Coding

Asadur Rahman

05/16-05/22

Jacob: 750

Jack McCaffrie: 771

Justin Rundle: 16

Lukas Wellenstein: 1,177

Tristan: 236

Thresa Majeski: 600

Total: 3,534

RP coding needed - 2023: 8,036

Crash Data Analysis and Reporting

Valerie Payne

 

Scheduled Topics and Briefing documents

 

 

Close

Informal Closing Discussion

Related content