Dave Harvey, (Acting TraCS Unit Supervisor)
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.
930,363 total archived crashes of which 312,297 represent purged crashes. This includes 1,729,791 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
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 was abandoned (Invalid EMS Agency ID)
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.
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
Ken Matthews
Ben Rouleau
Valerie Payne and Rebecca Szymkowski