v2.0.0 Bignonia capreolata

Source: Lady Bird Johnson Wildflower Center

What’s Changed

This release introduces the so-called layer data model for managing crash data. Designed to bring stability and scalability to our crash data system and informed by more than 5-years of experience working with TxDOT crash data, this is a total overhaul of the Vision Zero database.

Database improvements

• Preserve the integrity of CRIS records and user edits by storing them in separate tables
• Add comprehensive record change logging and record modification timestamps
• Eliminate redundant fields for tracking crash injuries. Whereas as the previous database had at least seven places to maintain a crash injury, there is now only one.
• Eliminate the re-use of temporary crash IDs
• Use a single person record table instead of a primary and non-primary persons table
• Automate the process to identify crash victims who may be homeless
• Create an authoritative view of crash injury metrics that can be used in all reporting
• Eliminate tables and columns that are not used by Vision Zero staff. This includes removing 87 lookup tables and 255 table columns from the crashes, units, charges, and person tables.

Integration + automation improvements

• Automate the processing of CR3 PDFs and crash diagrams
• Eliminate the need to extract crash narratives from PDFs
• Increase speed of CRIS data import and improve daily logging of record inserts and updates
• Enforce data quality checks which prevent CRIS from sending unknown/unsupported lookup values

Bug fixes

• Fix bug that was preventing crash location IDs to update if only the reported road type ID was changed
• Fix bug that was causing duplicate person records to be created under certain conditions
• Fix bug that was preventing unit and person records from receiving updates from CRIS

Vision Zero Editor + Viewer improvements

• Add total person comp cost to the crash details page (#1513) @roseeichelmann
• Remove "Search by" from the grid table search menu items (#1508) @roseeichelmann
• Remove page and record counts from grid table pagination controls (#1507) @roseeichelmann
• Remove empty components from various pages (#1509) @roseeichelmann
• Add alert banner indicating when a crash does not meet the Vision Zero program's reporting requirements (#1503) @roseeichelmann
• Improve locations list performance (#1501) @johnclary
• Improve the fatalities list performance (#1490) @roseeichelmann
• Make the Dashboard page compatible with the new data model and improve performance (#1493) @roseeichelmann
• Overhaul ability to create temporary crashes (#1484) @roseeichelmann
• Add maintenance banner view to VZV (#1517) @chiaberry

Misc tech debt

• Create a toolbox script to block/unblock all users (#1520) @johnclary
• Set VZV dataset endpoints based on environment (#1512) @johnclary
• Remove Inconsistent KSI and changes views from the DB (#1510) @roseeichelmann
• Remove the "Inconsistent KSI Counts" and "Changes" features (#1491) @roseeichelmann
• Remove unused components from VZE (#1483) @roseeichelmann

Additional contributors: @frankhereford @mddilley @tillyw @patrickm02L @xavierapostol @MiladMAK