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

v1.35.0 Nueces Street

📸 image

Nueces is Spanish for nuts, early settlers named the Nueces river after the numerous pecan trees along it's banks. In Austin, Nueces Street runs along the east side of the Google "Sail" building in the Green Water Redevelopment area of downtown.

Vision Zero Editor

• Escape double quotes and ensure properly formatted CSV (#1248) @roseeichelmann
• Update injury severity badgeColor in the VZE People tab (#1249) @RR216
• Update Crash Data by Location widget link (#1259) @patrickm02L

Vision Zero ETLs

• CRIS import in a docker image (#1235) @frankhereford
• Dockerized EMS & AFD import scripts for Airflow 2 (#1241) @frankhereford
• Move CR3 extract OCR narrative script from airflow repo to vz-data (#1250) @chiaberry
• Update github action versions and change CR3 extract to build on master (#1251) @chiaberry
• Local Socrata ETL development (#1252) @mddilley
• Update CR3 download script (#1254) @mddilley
• Migrate VZ Socrata ETL to Airflow v2 (#1258) @mddilley
• Retrieve the CR3 download secrets with 1PW (#1262) @mddilley
• Update Socrata ETL GitHub Action (#1263) @mddilley

Vision Zero Database

• Update crash mode trigger, socrata python script (#1233) @tillyw
• Replace lambda function to make sure austin_full_purpose (AFP) is flagged correctly (#1247) @roseeichelmann
• Replace lambda function to update city_id (#1253) @roseeichelmann
• Add Council District Areas to the VZ database (#1255) @roseeichelmann
• Update local Hasura port from 8080 to 8084 (#1260) @mddilley

Vision Zero Viewer

• Add Contact Info to bottom of Vision Zero Viewer map (#1256) @RR216

v1.34.0 Mount Bonnell Drive

📸 Image

Mount Bonnell, also known as Covert Park, is a prominent point alongside the Lake Austin portion of the Colorado River in Austin, Texas. It has been a popular tourist destination since the 1850s. The mount provides a vista for viewing the city of Austin, Lake Austin, and the surrounding hills. It was designated a Recorded Texas Historic Landmark in 1969, bearing Marker number 6473, and was listed on the National Register of Historic Places in 2015.

Vision Zero Editor

• Update Comprehensive Cost link (#1243) @patrickm02L
• Add Engineering Areas to the FTT Index (#1239) @roseeichelmann
• Make Onsys Flag editable only on temporary records (#1238) @roseeichelmann
• Add Engineering Areas to the VZ database (#1234) @roseeichelmann
• Refinements to Fatalities Advanced Search (#1232) @roseeichelmann
• Implement FTT Index Advanced Search (#1229) @roseeichelmann

v1.33.0 Limon Street (Calle Limon)

📷 Image

The Limon family has a rich history in Austin, spanning several generations and deeply rooted in the city's cultural fabric. The Limon family story began with one man — Jose Limon. He left Mexico for Austin back in 1889. He and his wife had 11 children. Many of the Limon's live on the same street - Calle Limon. If you've ever been to Austin, Texas, you might have met a Limon. After all, there are 2,000 Limons in the city, and they're all part of the same amazing family.

Viewer Zero Editor

• Add Victim Names to the FTT Index (#1215) @roseeichelmann
• Fix Person Badge Colors (#1220) @frankhereford
• Update crash table UI to make vehicle type and body style editable (#1223) @tillyw
• Add New FTT fields to the crash export (#1224) @roseeichelmann
• Adds new micromobility and e-scooter types (#1225) @tillyw
• Adds scooter and motorcycle filters to crash table (#1226) @tillyw
• Update Victim Name display in FTT Index Page (#1227) @roseeichelmann
• Fix bug location page export not working (#1228) @roseeichelmann
• Implement FTT Index Advanced Search (#1229) @roseeichelmann

v.1.32.0 Kerbey Ln

📷 https://kerbeylanecafe.com/locations

Vision Zero Viewer

• Add an address search feature to the VZV map (#1217) @mddilley
• Update VZV map info box to show accurate crash time (#1212) @mddilley

Vision Zero Editor

• Add CR3 code sheet link to support menu (#1216) @patrickm02L
• Add pagination to user list (#1214) @tillyw
• Write script to backfill Law enforcement number (#1210) @roseeichelmann
• Adjust FTT index page records to coincide with the 10-year retention policy (#1209) @roseeichelmann
• Add Law Enforcement Number to the FTT Index (#1202) @roseeichelmann

Other

• Add special handling of a float from CRIS in the new speed limit column (#1218) @frankhereford
• Update local stack env var and replace Hasura metadata (#1213) @mddilley
• Augment local storage key name (#1207) @frankhereford
• Improve secret exchange between VZ Hasura event triggers and CR3 API (#1205) @mddilley