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

v.1.31.0 Jester Circle

🗒️ Jester Circle is the main road leading around the Jester residence halls at UT campus
📷 https://jimnicar.com/images-2/postcards-3-1950s-1970s/

Vision Zero Viewer

• 11327 council district layer in vzv does not render (#1204) @tillyw
• Undo manual override for 2022 pedestrian mode (#1185) @mddilley
• Manually adjust 2022 pedestrian fatalities (#1175) @tillyw

Vision Zero Editor

• Show level 5 polygons on Location view map (#1203) @mddilley
• Add new widget in the VZE dashboard (#1201) @patrickm02L
• Resolve AFP toggle naming confusion in crash index advanced filters (#1200) @roseeichelmann
• Exclude private drive crashes by default (#1198) @roseeichelmann
• Create tailored view for locations listing page (#1196) @frankhereford
• Devise mechanism for YTD columns in FTT index page (#1189) @roseeichelmann
• Address injury severity change for a person (#1188) @roseeichelmann
• Fill fatalities table with data from existing crash information (#1181) @roseeichelmann
• Database -- automate insertion into fatalities table (#1179) @roseeichelmann
• Create MVP of FTT Index (#1164) @roseeichelmann

Dependency Updates

• Bump local stack's graphql-engine version to 2.20.1 (#1194) @frankhereford
• VZ Suite Dependabot Round Up (Python) (#1170) @frankhereford
• VZV Dependabot Round Up (#1169) @frankhereford
• VZE Dependabot Round Up (JS Frontend) (#1168) @frankhereford

Other

• Add a .nvmrc to the VZ apps (#1199) @roseeichelmann
• Update VZ Github Actions so that we can manually trigger them (#1195) @mddilley
• Update events README with up-to-date CI details (#1192) @mddilley
• Readme update to trigger GH Action for SQS Lambda (#1190) @mddilley
• Update VZ ETLs to use a bastion host to connect to the VZDB (#1187) @frankhereford
• Add list of skippable crash IDs to CR3 download script (#1183) @mddilley
• VZ Development Environment fast-track into master (#1178) @frankhereford
• Add docker compose & python tooling, dockerize VZ stack (#1150) @frankhereford
• Workaround for CR3 PDF retrieval, with user supplied session tokens / cookies (#1048) @frankhereford
• Check file type in CR3 download script before updating crash record and storing file in S3 (#1171) @mddilley

v1.30.0 Iguana Circle

Iguana Circle is a residential street adjacent to Old Bee Cave Rd.
📷 image

Vision Zero Viewer

• Last column in By Time of Day visualization that should be hidden is hiding inconsistently (#1163) @mddilley
• Show textual delta for year-on-year metrics at the top of the VZV enve when the previous year is zero (#1158) @frankhereford
• Add a fallback value to By opulation year ratios (#1145) @mddilley
• Add missing year of population data for VZV (#1148) @frankhereford
• Change gender to sex in demographics section and info popup (#1128) @roseeichelmann
• Change gender to sex in persons table (#1126) @roseeichelmann

Vision Zero Editor

• "Confirm Save" modal is activated when trying to use "X" button to close "Success" modal (#1161) @roseeichelmann
• Non-CR3 uploads enhancement - validate lat/lons (#1155) @roseeichelmann
• Cascade delete crash notes when parent record is deleted (#1146) @roseeichelmann
• Add Race/Ethnicity and Sex to people tab (#1125) @roseeichelmann

Dependency Updates

• Bump json5 from 1.0.1 to 1.0.02 in /atd-vze (#1154) @dependabot
• Bump json5 from 1.0.1 to 1.0.02 in /atd-vzv (#1153) @dependabot
• Bump async from 2.6.3 to 2.6.4 in /atd-vze (#1072) @dependabot
• Bump terser from 4.8.0 to 4.8.1 in /atd-vze (#1082) @dependabot
• Bump moment and handsontable in /atd-vze (#116) @dependabot

Other

• Use Tyler Tech data hub endpoint (#1160) @johnclary
• Remove errant package-lock.json file from root of repository (#1121) @frankhereford
• Update README with up-to-date CI details to trigger CI (#1151) @mddilley

v1.29.0 Hyacinth Drive

Hyacinth Drive - Version 1.29.0

Scilloideae Hyacinthus

🗒 Hyacinth Drive, a residential street in the Gracywoods neighborhood, is a short walk from the North Star Greenbelt city park.
📸 https://daily.jstor.org/plant-of-the-month-hyacinth/

What’s Changed

• Migrate recommendation partners to new table (#1118) @roseeichelmann
• Support multiple recommendation partners (#1110) @roseeichelmann
• Replace moment.js with date-fns (#1114) @roseeichelmann

Deployment Notes

• Create the recommendations_partners table
• Run the partners migration script to fill table with recommendation/partner data
• Delete coordination_partners_id column in the recommendations table

Versioning Consideration

• Netlify recognized that no substantive changes were made to the VZV application and therefore did not build a new deployment. 1.28.0 remains in place for the Vision Zero Viewer as intended.

v1.28.0 Guadalupe St.

📸 The University of Texas at Austin

The Drag, a part of Guadalupe St., runs along the west side of the University of Texas at Austin campus

What’s Changed

• AFD & EMS DB change requests and Prefect Flows (#1095) @mateoclarke @frankhereford
• Update Vision Zero database to PostgreSQL 14.4 @frankhereford
• Update fatality and serious injury counts for accuracy (#1111) @mddilley
• Refactor notes component (#1107) @roseeichelmann
• Alphabetize partners (#1109) @roseeichelmann
• Update the MapGL configuration when in edit mode for a crash location (#1106) @frankhereford
• CRIS Import ETL rewrite (#1096) @frankhereford
• Adds street labels on top of nearmap tiles (#1100) @johnclary
• Patch related records underneath crash narrative (#1101) @chiaberry
• Moved Related Records underneath the Crash Narrative (#1099) @patrickm02L

Database Schema & Lookup Data Changes

• @roseeichelmann: Add Arterial Management and Austin Police Department to the atd__coordination_partners_lkp table
• @mddilley: Add generated columns for years_of_life_lost for persons and primarypersons tables

v1.27.0 FM 2222

📸 Source: Wikipedia.org

Vision Zero Editor

• Add nearmap layer to crash map (#1097) @chiaberry
• Implement edit/delete functionality of Fatality Review Board Recommendations (#1091) @roseeichelmann @mddilley
• Add Location Notes (#1090) @roseeichelmann
• Enhancement so users can only edit notes if they created it (#1089) @roseeichelmann
• Add Fatality Review Board Recommendations section for Crashes (#1083) @roseeichelmann

Vision Zero Viewer

• Update years and percentage in VZV map overlays popover (#1094) @patrickm02L
• Updates high injury network and roadways in VZV (#1093) @tillyw
• Bug fixes for white screen flash on City Council overlay (#1092) @tillyw
• Prevents drawing polygon from crashing VZV (#1088) @tillyw

Vision Zero Database

• Add SQL files describing the migration and creation (same action today) of notes and updating stored metadata (#1087) @frankhereford

v1.26.0 Finley Drive

📸 Source: Rock Rose Blog

Vision Zero Editor

• Add new "Notes" section to Crash Details page (#1073) @mateoclarke
• Add ability edit and delete notes (#1081) @roseeichelmann
• Add ability create new note (#1079) @roseeichelmann

Vision Zero Database

• Add imported_at as a field to record when a crash record is created in the VZDB (#1070) @frankhereford

Dependency Updates

• Remove node-sass for sass (#1074) @mateoclarke

v.1.25.0 Fruth Street

📸 Source

What’s Changed

• Change data delay to two weeks ago (#1065) @Charlie-Henry
• Add tool for extracting movement and direction changes from the change log (#1064) @frankhereford

v.1.24.0 Eva Street

Eva Street is a residential street located one block west of S. Congress. Herb-bar located on Eva St. was founded 1986 and is home to herbal products for humans and pets.

📸 Source

Vision Zero Editor

• Update Crash Changes business logic (#1051) @chiaberry
• Update PowerBI links on dashboard (#1050) @chiaberry

Vision Zero ETLs

• Have CR3s downloaded in order of crash date (#1053) @frankhereford