/
2023-03-24, Crash DB Workgroup Meeting

2023-03-24, Crash DB Workgroup Meeting

Owned by Soujanya Jarabana (Unlicensed)
Last updated: Mar 24, 2023 by Michael Satteson
4 min read

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

  • 2/26/2023 Last monthly server maintenance window

  • 3/26/2023 Next monthly server maintenance window

  • Ongoing coordination with UW DoIT Oracle Licensing Team

    • Existing Oracle license extended through April 29, 2024.

    • Discounted CPU based licensing under consideration.

Prioritized JIRA Issues and Enhancements

  • Completed:

    • 3/15/2023 Resolve System Update

      • CRASHDB-995: System Stability - Provide beautified xml & pdf download capability for each record displayed.

      • CRASHDB-1039: System Stability - provide for CSV Download of Search Results.

      • CRASHDB-1047: System Stability - Results not time ordered for a given document number.

      • CRASHDB-1053: System Stability - Search End Date Ought to be Inclusive.

      • CRASHDB-1054: System Stability - Document Number Search - Enable Simple Wild Card Specification.

      • CRASHDB-1055: System Stability - Add a View Button for Search Results.

  • In Progress:

    • System Stability Follow-Up Items

      • CRASHDB-1251: Duplicate Records

      • CRASHDB-1255: View Button

    • Resolve Search Enhancements

      • CRASHDB-999: Agency Search

      • CRASHDB-1253: Government Property Damage Tag

      • CRASHDB-1254: Search by Roadway

    • Crash Database Archive

      • Refactored incremental and full archiving processes to improve performance.

      • Scheduling IT meeting to establish secure network access

      • What (additional) data agreements are needed?

  • In Queue:

    • 2021 RP Finalization

    • Migrate to the VxRail Oracle 19c

    • Customer Number Assignment Logic and Enhancements

Purge and Archiving Processes

  • Purge and Archive processes both continuing to run smoothly.

  • 940,768 total archived crashes of which 327,640 represent purged crashes.  This includes 1,750,300 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

  • 4/4 Working Group Meeting (moved due to conflict)

  • BSHP / BITS working on STN / WISLR data mappings

  • Next Steps: Prototype (TLT/WISLR/STN/LINK-LINK)

WisTransPortal / Community Maps

  • Community Maps:

    • March 29 User Group Planning (with Green Lake County SO) - 142 registered so far

  • Recent / In Progress:

    • 2022 DNR ATV Crashes (Completed)

    • 2021 US Census Tribal Boundaries (Test Server)

    • Crash Comparison Dashboard (In Progress)

  • WisTransPortal: No updates this period

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 9 LEA questions in the last 4 weeks with 2 Hit and Run Crashes and 1 about Crash Diagram Tool.

Transmission failures:

  • We addressed 17 transmission failures between Feb 24th until now after providing solution to the agencies.

    • 7 are transmitted

    • 6 are transmitted as other Document (Duplicate Document Number)

    • 3 are pending with agencies

    • 1, CRUBIZ-11, was abandoned. This was an Invalid EMS Agency ID failure of a 2021-09-23 , having an initial failure date of 2021-09-30.

About half of our transmission failures are caused by document number reuse, a failure mode that we began tracking at the strt of this year. Of these about half are from one machine at one agency. We are working with Badger TraCS to try to get that machine reconfigured to avoid the document number reuse.

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.

  • Since the start of this process 239 Fatal Crashes have been reviewed, 9 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 1 crash from Racine PD

Enhancements to Crash Database & Resolve System

  • Currently in development phase is search by Agency in Resolve System and bug fixes to the System Stability tool. https://wi-state-patrol.atlassian.net/browse/CRASHDB-1185  

  • In the last four weeks, 2 change requests were submitted which includes:

    • 1 change request for monthly server maintenance

    • 1 change request for adding new features to System Stability

Partial DROC Outage, 2023-03-22/23 (problems submitting multi-unit crashes)

On Wednesday, the BITS DROC team deployed a new version of this application to address address issues with the state of issuance field that occur in some cases when Apple devices are used to complete the form. On Thursday morning the CRU began receiving calls from the public complaining about difficulties completing DROC crashes involving 2 or more units. On Thursday afternoon, the BITS DROC team made an emergency change to revert to the previous DROC version. The CRU was able to reproducer the issue in production when it was live, but could not do so in the test environment. Failure analysis from the BITS DROC team is pending.

DMV Systems and SR

Ken Matthews

 

Reference Point Coding

Asadur Rahman

Erickson coded: 556

Jacob coded: 1,409

Total: 1,965

Erickson, our LTE RP coder had to cut back on his hour over the past 2 weeks because he had nearly exhausted the hours under his initial appointment. Renewal of his appointment proved difficult and had to be resolved at the Bureau Director level. But we did get renewal, effective 2023-03-27.

Crash Data Analysis and Reporting

Valerie Payne and Rebecca Szymkowski

 

Scheduled Topics and Briefing documents

Informal discussion of hosting our annual crash data on WisDOT GIS Open Data as mapped data with a selection of fields and as tabulated dataset in the format that had been provided as a piad subscription service. The subscription service has been discontinued, and the data sets are now available on Box.

 

 

Close

Informal Closing Discussion

Related content