Intro
Informal Opening Discussion
Crash DB Systems Review
TraCS Systems and Crash Form development
David Malisch / Geraldine Polster
TOPS Database and WisTransPortal
Maintenance Updates and System Stability
February server maintenance window postponed until March
Prioritized JIRA Issues and Enhancements
2022 Finalization
RP coding process for 2022 data is continuing and will be merged into the frozen data set once completed.
December / January JIRA Cases:
In Progress
CRASHDB-1349 - System Stability (Java 11 / Oracle 19c) Migration:
CRASHDB-1367 – Phase 1: Java Migration
CRASHDB-1367 - Getting issue details... STATUS
Wednesday, February 7th production update was rolled back on Friday, February 9th after an issue was discovered with 24 crashes that were observed to have been created as duplicates.
CRASHDB-1536 - Resolve Pipeline Duplicate Crash Issue
CRASHDB-1536 - Getting issue details... STATUS
JIRA case aggregator to investigate and clean up impacted crash records. Current theory is a configuration mismatch in the time zone settings between the new application server and the database that interfered with the integration process. TOPS will schedule a new maintenance window once the issue has been thoroughly analyzed and resolved.
Under Development
CRASHDB-1465 - Resolve - CUSTNMBR Enhancements during Migration
CRASHDB-1465 - Getting issue details... STATUS
Record history, modulation, assignment workflow
Prioritized JIRA improvements during Migration testing.
Purge and Archiving Processes
Purge and Archive processes both continuing to run smoothly.
1,072,483 total archived crashes of which 472,826 represent purged crashes (the archive adds approximately 13K crashes per month). This includes 2,005,543 total image files.
HWYCLASS Working Group
Next workgroup meeting: 2/27. Will present roadway ownership query results. These elements provide an opportunity to compare derived values to values from the police report.
General concurrence on merit to continue line of investigation.
Follow-up on TLT information in deer crash short form.
WisTransPortal / Community Maps
Community Maps:
User Preferences enhancement moved into production.
Desing for new training video page in progress
Tribal Area filter based on US Census boundaries in progress, along with a few new flags.
Crash flags technical documentation in progress.
WisTransPortal:
Data download enhancement in progress.
Crash Records Unit
Polly Ebbinger / Mike Satteson
Duplicate Crash Reports
75 Potential Duplicate Crashes
14 resolved in last 30 days
61 remaining to resolve
Transmission Failures
(since the 1/26/24)
54 total unique documents failures
42 reuse failures
34 retransmissions
3 reuse, agency fixed
3 reuse, solution provided – 2 outstanding
1 CJIS flag missing or empty
5 Police Report Image is missing or empty
1 Document Number and Crash document Number must be different
1 invalid EMS Agency ID
1 Hwy direction is missing
1 LastName is invalid
1 Airbag invalid
1 PhotosBy invalid
Issues Submitted
BTRSD-6984 Issue - Convert to Amended
BTRSD-6985 Issue - Secondary Crash / Primary Crash Agency
LE Questions
8 LE questions – all related to validation issues of crash reports
1 Bomgar session related to the CJIS flag error
DMV Systems and SR
Ken Matthews
Reference Point Coding
Asadur Rahman
Crash Data Analysis and Reporting
Valerie Payne / Brian Porter
Add Comment