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.
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
Soujanya Jarabana and Mike Satteson
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.
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.
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
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
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.
Ken Matthews
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.
Valerie Payne and Rebecca Szymkowski
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.
Interim Data package, WI_Annual_Crash_Data_Flyer.pdf
Identify the attributes to be associated with the mapped data when hosted, Jacci