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

v1.43 Vista Verde Dr

What’s Changed

Editor

• Refine field edit inputs (#1390) @johnclary
• Make the fatalities page load quickly after the first time you visit the page (#1392) @johnclary
• Hide the Edit Coordinates button for read-only users (#1389) @roseeichelmann

Database + APIs

• Update conflict detection system to protect all editable fields (#1393) @frankhereford
• Upgrade the Socrata ETL to support leap days 🐸 (#1388) @johnclary
• Create separate permission group for VZE Admins (#1385) @mddilley

v1.42.0 Utopia Ct

Source: Nearmap

What’s Changed

Editor

• [Bug] Unable to save Changes for some crashes (#1373) @roseeichelmann
• [Bug] Years of Life Lost is not being displayed on VZ Editor (#1372) @mddilley
• [Bug] One password plug-in appears on date-picker fields (#1374) @mddilley
• [Bug] Street/satellite layer toggle doesn't work in Crash location edit map (#1355) @mddilley

Database

• [Tech debt] Add and update lookup tables and values to get VZDB up to date with CRIS v27 (#1371) @roseeichelmann
• [Bug] Crashes by mode tabulations do not match reality (#1384) @mddilley
• [Enhancement] Update the person experiencing homelessness flag with data from CRIS CSVs (#1353) @frankhereford

v1.41.0 Toomey Road

The Toomey Road, where Urban Transportation is located, was the original building that the Data & Technology Services team called home.

Vision Zero Editor

• Add tooltip to reset crash diagram zoom button (#1334) @mddilley
• Add confirmation to delete notes on the Location page and Crash page (#1339) @mddilley
• Fix WSOD in VZE when interacting with data widgets on crash listing page (#1344) @roseeichelmann
• Expand CR3 export permissions (#1349) @tillyw

Vision Zero Viewer

• Display annual totals for all, fatalities, and serious injuries for the year (#1340) @roseeichelmann
• Update VZ Dashboard (#1345) @xavierapostol
• Reposition Fatality and Serious Injury counts pop-up when boundary box is activated (#1350) @mddilley

Vision Zero Database

• Update comprehensive costs for 2024 ( to account for inflation ) (#1341) @roseeichelmann
• Add new near trauma center fields to crashes table (#1348) @roseeichelmann

Dependabot

• Process Dependabot PRs for VZV (#1335) @frankhereford
• Rework requirements.txt and remove _request_ctx_stack use from CR3 API service (#1338) @frankhereford

v1.40.0 Shiner Street

Image: Shiner, TX City Hall provided by Patrick McDonnell

Shiner Street is a residential street in the Bancroft Woods neighborhood close to the Apple Campus, and Rattan Creek Park.

Vision Zero Editor

• Update Unhoused description in People card (#1332) @roseeichelmann

Vision Zero Viewer

• Replace moment.js with date-fns for VZV (#1323) @roseeichelmann
• Make VZV council districts accurately represent polygons with holes in them (#1325) @frankhereford

Vision Zero Database

• Remove part of VZDB readme that uses the Hasura CLI (#1330) @mddilley
• Add ems id to the person and primary persons table (#1319) @roseeichelmann

Vision Zero ETL

• Isolate the file metadata generation script into its own DAG to align with others (#1328) @frankhereford

v1.39.0 Red River St

Image wikipedia - Stubbs BBQ is located at 801 Red River.

Christopher B. "Stubb" Stubblefield, Sr. (March 7, 1931 – May 27, 1995) was an American barbecue, restaurateur, music patron and a Barbecue Hall of Famer, known for his barbecue sauces, rubs and marinades distributed by Stubb's Legendary Kitchen, Inc.

Vision Zero Database

• Make manner of collision editable on temp records (#1317) @roseeichelmann
• Create a new field peh_fl in the database for a Person Experiencing Homelessness (#1318) @roseeichelmann

Vision Zero Viewer

• Update VZV population figures (#1315) @frankhereford

Vision Zero ETL

• Invalidate CR3 metadata to cause them to be redownloaded when updated by CRIS (#1316) @frankhereford
• Remove vestigial docker image for VZ ETLs (#1320) @frankhereford

v.1.38.0 Quail Blvd

Quail Blvd feeds into Quail Creek Neighborhood Park just north of Runberg Ln
photo: https://www.rawpixel.com/image/11499481/image-art-vintage-illustration

Vision Zero Database

• CI workflow for applying migrations and metadata (#1299) @mddilley
• HAProxy for VZ Read Replica (#1302) @frankhereford
• Remove CR3 and non-CR3 crash location housekeeping ETLs (#1304) @mddilley
• Fix issue with VZE reaching local Hasura engine (#1307) @mddilley
• Fix the location listing view such that a location is represented if it has one of, but not both, CR3 & non-CR3 crashes (#1312) @frankhereford

Vision Zero Editor

• Add user email export button (#1294) @roseeichelmann @tillyw

v1.37.0 Pease Road

📷 source - Treehouse at Pease Park

The parcel of land that is now Pease Park was named after and donated to the city of Austin by Texas Governor Elisha M. Pease and his wife in 1875. On October 16, 2019 ground broke on the US$15 million dollar 10 acres Kingsbury Commons, the most significant upgrade to Pease Park in a century, as part of a larger Master Plan. Construction concluded in June 2021. - wikipedia

Vision Zero Editor

• Removes micromobility device flag (#1284) @tillyw
• Update url in dashboard page (#1297) @frankhereford
• Implement custom 404 page (#1291) @roseeichelmann

Vision Zero Database

• Replace Lambda function blueform_location_from_latlon with trigger (#1269) @mddilley
• Extend the local stack script to pg_dump and restore the local DB (#1280) @mddilley
• Migration for blueform location triggers (#1286) @mddilley
• VZDB readme edits (#1287) @mddilley
• Migrations for cr3 location triggers (#1290) @roseeichelmann

Vision Zero Viewer

• Add micromobility to vzv chart (#1261) @tillyw
• Adds e-scooter rider to vzv map (#1283) @tillyw
• Change url to Austin crash report dataset (#1295) @chiaberry
• Update VZ branding for the VZV (#1296) @roseeichelmann

Other

• Update the atd-vzd readme (#1285) @mddilley
• Move CircleCI jobs to GH Actions (#1289) @mddilley
• Cleanup code for Hasura event triggers, SQS, and related CI (#1292) @mddilley

v1.36.0 Onion Creek Parkway

📸 Image and Description

Onion Creek is a small tributary stream of the Colorado River in Texas. It begins 12 mi (19 km) southeast of Johnson City, Blanco County, Texas, and flows approximately 79 mi (127 km) eastward into the Colorado River, 2 mi (3.2 km) northwest of Garfield in Travis County, Texas.[1]

Vision Zero Editor

• Add council districts to crash & fatality export (#1267) @roseeichelmann
• Resolve Download CR3 button "NoSuchKey The specified key does not exist" error (#1272) @roseeichelmann
• Fixed bugs in crash listing filters (#1273) @tillyw
• Add 'Other' toggle to crashes and fatalities tables (#1277) @tillyw

Vision Zero ETLs

• VZ ETLs for CR3 PDF maintenance & location association maintenance (#1257) @frankhereford

Vision Zero Database

• Fix duplicate filters on VZ Socrata people query (#1265) @mddilley
• Add crash ID 144720068 to skip list in CR3 download script (#1271) @mddilley
• Bring local graphql-engine version into sync with production / latest version (#1275) @frankhereford
• Hasura migrations (#1276) @mddilley

Vision Zero Viewer

• Fix overlap in age groups on VZV (#1268) @RR216

Note

• We bumped the RDS cluster to t3.medium