2.4.0 Euphorbia corollata

Source: Lady Bird Johnson Wildflower Center

What’s Changed

• Upgrade the user management and CR3 API and migrate to new infrastructure (#1597) @frankhereford
• Publish the crash-components table to the open data portal (#1600) @johnclary
• Create equity action zones layer in the dastabase (#1601) @johnclary
• Rename is_non_coa_roadway to is_coa_roadway (#1598) @johnclary
• Create ETL that joins crashes and Moped components (#1596) @Charlie-Henry
• Crash details page: enable users to collapse the record history card (#1599) @chiaberry
• Create database table to store crash-component lookup table (#1588) @roseeichelmann

2.3.0 Echinacea purpurea

Source: Lady Bird Johnson Wildflower Center

What's Changed

Editor

• Ability to nullify CRIS-provided values by @roseeichelmann in #1572

Documentation

• Add dbdocs interactive database documentation by @frankhereford

Database

• Squash migrations @frankhereford in #1569
• Remove crashes edits layer by @roseeichelmann in #1572
• Add new geospatial layers, trigger-managed attribute columns, and a fancy new AGOL helper by @johnclary in #1571

2.2.0 Datura wrightii

Source: Lady Bird Johnson Wildflower Center

What’s Changed

• Return of the OCR'd crash narrative (#1568) @johnclary
• Enable address editing (#1564) @roseeichelmann
• Restores helper script's ability to download db data (#1567) @johnclary
• Ability to swap primary and secondary address (#1551) @roseeichelmann
• More documentation updates (#1565) @johnclary
• Rename repo to vision-zero (#1566) @johnclary
• Exclude test accounts when copying email addresses (#1562) @johnclary
• Update a few outdated references to folders (#1563) @chiaberry

2.1.0 Callicarpa americana

Source: Lady Bird Johnson Wildflower Center

Features and enhancements

• Editor: Add global crash search (#1549) @johnclary
• Database: Add a non-coa roadways layer to the database (#1545) @roseeichelmann
• Database: Add drvr_lic_type_id and veh_hnr_fl columns (#1546) @johnclary
• Database: Migrate pre-2014 crashes into the new data model (#1534) @johnclary

Bug fixes

• Fix timezone bug in VZE fatalities view and fix engineering area label (#1547) @roseeichelmann
• Fix WSOD on location details page (#1550) @roseeichelmann

Developer operations + Tech debt

• Rename top level directories (#1552) @frankhereford
• Fix various things in the crash recommendations form (#1542) @roseeichelmann
• Implement soft deletes for crash notes (#1540) @roseeichelmann
• Database: Refactor lookup table helper and apply CRIS v28 changes (#1541) @johnclary
• Update documentation for v2.0 (#1523) @johnclary
• CRIS import ETL: check if crash report directory exists (#1544) @johnclary
• Cleanup toolbox and update readme (#1543) @johnclary

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

v1.48.0 - Asclepias incarnata

Source: Lady Bird Johnson Wildflower Center

What’s Changed

• Fix a small VZV timestamp bug (#1474) @Charlie-Henry
• Set the minimum crash date to be OCR'd to 2020-01-01 (#1469) @johnclary
• Fix the paths-filter configuration in our GIthub deployment action (#1455) @johnclary

v1.47.0 - Zinnia grandiflora

Source: Lady Bird Johnson Wildflower Center

What’s Changed

• [BUG] Crash coordinates render as NaN when they should be blank (#1448) @mddilley
• Refactor CRIS import script to use S3 and log activities (#1445) @frankhereford
• Ensure that temporary records are not removed by the import script (#1446) @frankhereford

v1.46 - Yucca rupicola

Source: Native Plant Society of Texas

Vision Zero Editor

• Remove duplicate "NO DATA" options in Body Style edit drop down (#1435) @roseeichelmann

Vision Zero Viewer

• Update description of 'Other' modes in by travel mode modal (#1442) @johnclary
• Fix Broken and old links in VZV and VZE (#1431) @roseeichelmann
• Add loading spinners to cards (#1428) @roseeichelmann

Vision Zero Database

• Use simplified engineering areas geometries (#1444) @johnclary
• Thread cr3 file metadata ETL (#1436) @frankhereford
• Thread cr3 downloader (#1419) @frankhereford
• Add details to readme (#1438) @chiaberry
• Skip CRIS import record updates if a key column is missing a value (#1437) @mddilley

v1.45.0

What’s Changed

Vision Zero Editor

• Persist the navigation sidebar visibility between sessions (#1424) @mddilley
• Fix a bug that resulted in street labels being hidden from the map on the crash details page (#1420) @mddilley
• Show a banner at the top of the screen when using a non-production environment (#1414) @roseeichelmann

Vision Zero Viewer

• Make the Vision Zero metric cards be the same height (#1425) @roseeichelmann

v1.44 - Wildcat Hollow

What’s Changed

Editor

• Prevent the UI from shifting when advanced search filteres are applied (#1411) @roseeichelmann
• Make Crash ID the default search field on the crashes list (#1409) @mddilley
• Restore the ability to delete temporary crash records (#1413) @frankhereford
• Change the default landing page to Crashes instead of Dashboard (#1410) @roseeichelmann
• Increase change log modal width and wrap text (#1403) @mddilley
• Prevent scroll capture on crash and location maps (#1398, #1399, #1400) @mddilley
• Add thousands separator to crashes and locations lists (#1404) @roseeichelmann

Viewer

• Add tooltips to explain what each mode type indicates (#1412) @tillyw

Database

• Update timeout in the read replica haproxy configuration (#1397) @frankhereford