Dave Harvey, (Acting TraCS Unit Supervisor)
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.
In Progress:
CRASHDB-1113: Resolve System Stability Enhancements.
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 (4th 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
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 18th and January 29th
1 Resolve Enhancement for Restricted crashes and Bug Fixes scheduled on December 21st
Ken Matthews
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
Valerie Payne and Rebecca Szymkowski
need to replace Bob, in best fit for replacement
crash facts, 2017 to 2021
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