Open

Intro

Informal Opening Discussion

Crash DB Systems Review

TraCS Systems and Crash Form development

Dave Harvey, (Acting TraCS Unit Supervisor)

TOPS Database and WisTransPortal

Steven Parker and Andi Bill

Maintenance Updates and System Stability

• 12/18/2022 Monthly server maintenance window

• 1/29/2023 Next monthly server maintenance window

• End of year maintenance and testing (CRASHDB-1157)

• Ongoing coordination with UW DoIT Oracle Licensing Team

Prioritized JIRA Updates and Enhancements

• Completed

  • CRASHDB-1127: Restricted Crash Reports - Develop Feature to Set Manually.https://wi-state-patrol.atlassian.net/browse/CRASHDB-1127

• In Progress:

  • CRASHDB-1113: Resolve System Stability Enhancements. https://wi-state-patrol.atlassian.net/browse/CRASHDB-1113

• In Queue:

  • FMCSA Enhancements, 2021 RP Finalization (need Jira case)

  • BITS redevelopment of NIC crash reports payment mechanism

Purge and Archiving Processes

• Purge and Archive processes both continuing to run smoothly.

• Investigating the ability to run the process hourly instead over nightly.

• 917,772 total archived crashes of which 298,067 represent purged crashes.  This includes 1,705,393 total image files.

2021 Crash Finalization

• Plan is to incorporate the results of the 2021 final RP coding and generate the final extracts early 2023.

• Statistical frozen 2021 data set available on WisTransPortal and Community Maps.

HWYCLASS Working Group

• 1/24 Working Group Meeting (4^th Tuesday)

• Finalized Data Dictionary (attached):

  • Roadway functional classification

  • Roadway ownership

  • Retired Elements

  • Deferred Elements

• Next steps:

  • Define data mappings to WISLR / STN

  • Prototype (TLT/WISLR/STN/LINK-LINK)

• May need to be a formal project

WisTransPortal / Community Maps

• Community Maps:

  • March User Group Planning (with Green Lake County SO)

  • Two January Updates:

    • Enhanced Deer Crash Selection

    • New Winter Road Flag

    • Improved Hot Spot Detection

    • Various other fixes and updates

• WisTransPortal:

  • Completed:

    • Special Study - for BTO Flex Lane analysis

    • Vehicle Year and Make

    • Fixed a performance issue with the DT4000 data source

Crash Records Unit

Soujanya Jarabana and Mike Satteson

Questions from Law Enforcement Agencies:

CRU business unit provided email and remote support to law enforcement agencies to resolve Validation errors in the DT4000 crash form. 

Received 12 LEA questions in the last six weeks with 5 of them related to Hit and Run Crashes.

FTP requests:

The shared folders setup in the DOT FTP server for TOPS lab & State Lab hygiene is successfully used for uploading documents.

Transmission failures:

• We addressed 15 transmission failures between Dec 9th and now

  • Out of it, 10 are transmitted after providing solution to the agencies

  • 2 are transmitted as other documents

  • 3 are still pending with the agencies

Badger TraCS January 2023 Pack updates related to Crash Form

• Table Updates - Hospital Names Changed:

  • ST CLARES HOSP-WESTON changed to Marshfield Medical Center – Weston

  • Appleton Medical Center changed to ThedaCare Regional Medical Center – Appleton

  • Chippewa Valley Hospital changed to AdventHealth Durand

• Bug Fixes & Highlights:

  • Transfer Form button for DT4000 & DT3480 - to show only active users.

  • Crash Form: Bug fix to validate Amended Deer crash.

  • A printed version of the Law Enforcement Crash Involvement email

  • Tested for Ambulance and Insurance company updates for January 2023 pack.

DT4000 Fatal Crashes:

Quality Check process for DT4000 fatal crashes is performed which comes in Resolve. The process starts with creating a Jira issue for DT4000 basic check and then and assigned to the FARS team,

• FARS team performs quality check for

  • All Fatal Injuries Shown

  • DT3480 Available

  • Diagram Good

  • Narrative Good

  • Sequence of Events Good

• Based on the results of the quality check process the agency is contacted to amend the crash report. (Currently, 5 fatal crashes are under agency review)

• Tracking is done for missing DT4000 fatal crashes, and the agency is contacted when a 3-week due date is met from the crash date.

• Currently, we are missing 2 crashes from Racine PD and Wauwatosa PD.

Enhancements to Crash Database & Resolve system

• Developed Test cases in JIRA and performed testing for Restricted Crashes and bug fixes which was deployed in the December development cycle.

• Currently working on testing new features in System Stability in the TST environment.

• In the last 6 weeks, attended CAB for 3 change requests which includes

  • 2 monthly server maintenance scheduled on December 18^th and January 29^th

  • 1 Resolve Enhancement for Restricted crashes and Bug Fixes scheduled on December 21^st

DMV Systems and SR

Ken Matthews

Reference Point Coding

Asadur Rahman (Ben Rouleau as backup)

• Jacob, 700; Erickson 400 1 week

• 7600 since last meeting

• 5000 left, end of February

• 2022

• 2nd LTE coder

Crash Data Analysis and Reporting

Valerie Payne and Rebecca Szymkowski

• need to replace Bob, in best fit for replacement

• crash facts, 2017 to 2021

Scheduled Topics and Briefing documents

Close

Informal Closing Discussion

Appendix

Current membership (According to Cayosoft). I’ll cancel the meetings and redo to get the invite in sync with this list. Please feel free to add otherers to this list.

• Valerie Payne

• Soujanya Jarabana

• Jennifer Fedie

• Rosalba Martinez

• Mike Schwendau

• Andi Bill

• Carolyn Hunt

• Asadur Rahman

• Ken Matthews

• Ben Rouleau

• David Esse

• Kenia Valenzuela

• Adam Feidt

• Dan Brugman

• Steven parker

• Rebessa Szymkowski

• David Harvey

• John Tyson

• Dennis Miller

• Kelly Schieldt

• David Pabst