Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 6 Next »

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

  • 4/23/2023 - Last monthly server maintenance window

  • 5/3/2027 – Planned low-risk maintenance window for Resolve updates

  • CRASHDB-1264 – Intermittent Errors during the Week of 2/4/2023

    • UW-Madison campus network instability: 4/4 – 4/6

    • Impacted web services, customer purchases of crash reports, access to Resolve

    • ECR Pending

  • Ongoing coordination with UW DoIT Oracle Licensing Team

    • Should hear back soon from the UW Oracle team

    • Existing Oracle license extended through April 29, 2024.

    • Discounted CPU based licensing under consideration.

Prioritized JIRA Issues and Enhancements

  • 2021 RP Finalization

    • RP Coding Data Merge Successful

    • CRU & TOPS Extracts Generated

    • Next Steps:

      • Sign-Off from CRU / Workgroup

      • Update WisTransPortal & Community Maps

      • Generate RP file for John Tyson / RP Crash Shapefile

      • Generate Public Extracts

      • Provide to DHS CODES team

  • 2022 Finalization

    • End of May data freeze for federal reporting purposes

    • Anticipate building upon the 2021 process for merging final RP crash coding

  • In Acceptance and Ready for CAB – Planning for May 5 maintenance window

    • System Stability Follow-Up Items

      • CRASHDB-1251: Duplicate Records

      • CRASHDB-1255: View Button

      • CRASHDB-1257: XML Beautification

      • CRASHDB-1260: Query Record Limit

    • Resolve Search Enhancements

      • CRASHDB-999: Search by Agency

      • CRASHDB-1253: Search by Government Property Damage Tag

      • CRASHDB-1263: Update Resolve Contact Page

  • Getting Started / In Progress

    • Customer Number - 2 months

      • Confluence Document and Code Review for Assigning Customer Numbers

      • Adding Customer Number Modulation to Record History

      • Adding Primary DID and Driver Restrictions to Record History

    • Crash Database Archive

      • Scheduling IT meeting to establish secure network access

      • What (additional) data agreements are needed?

    • In Queue

      • Migrate to the VxRail Oracle 19c – 2 months

Purge and Archiving Processes

  • Purge and Archive processes both continuing to run smoothly

  • 952,609 total archived crashes of which 343,103 represent purged crashes (the archive adds approximately 15K crashes per month).  This includes 1,773,194 total image files.

FY24 Project Planning

  • Working on the SPR application and budget for Ben and Mike

  • Requested a budget increase this year to match increases in UW costs

HWYCLASS Working Group

  • 4/4 Working Group Meeting

    • Reviewed STN/WISLR data mappings from Christy and Jeff

    • Prototype planning: offline testing with 2021 Dane County crashes

    • TOPS working on the STN/WSLR/LINK-LINK data request to BSHP

    • Canceled the May meeting due to conflicts and pending data request

    • Onboarding a grad student to help with the effort

WisTransPortal / Community Maps

  • Community Maps

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

      • 119 participants

      • Recording linked to Community Maps

    • Recent / In Progress

      • 2021 US Census Tribal Boundaries (Completed)

      • Crash Comparison Dashboard (Completed)

      • Database Migration to Oracle 19c (Completed)

      • Advanced Search Edit Enhancements (In Progress)

  • WisTransPortal

    • Database Migration to Oracle 19c (Completed)

    • 2021 Final Crash Data Testing (Completed)

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 15 LEA questions in the last 4 weeks involving 1 Hit and Run Fatal Crash, 2 crashes about Crash diagram, 3 Questions about Non-Reportable Crashes.

 

Transmission failures:

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

    • 5 are transmitted

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

    • 2 are pending with Agencies.

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.

  • 5 fatal crashes are under agency review for missing Fatal Supplement & 2 crashes needs Agency Amendment.

  • 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 Washington County SO 

 

Enhancements to Crash Database & Resolve System

  • Currently in ready for production for planned deployment on 2023-05-03 which includes.

CRASHDB-1185

  • Resolve Search by Agency, Government Property Tag, Update contact information in Resolve system and bug fixes in System Stability.

  •  In the last four weeks, 1 change request was submitted which includes:

    • 1 monthly server maintenance on 2023-04-23.

DMV Systems and SR

Ken Matthews

Reference Point Coding

Ben Rouleau

Crash Data Analysis and Reporting

Valerie Payne and Rebecca Szymkowski

Scheduled Topics and Briefing documents

Close

Informal Closing Discussion

  • No labels