v1.5.0 Brazos St

VZV

• Added whole numbers to the Demographics visualization tool tips

VZE

• Fix element shifting in Crash Details page when related records accordions expand/collapse
• Fix issue where redirect after login does not work in staging/prod
• Set up roles-based permissions
• Established user admin interface to add, edit, and delete users
• Added rules for which accounts could view and edit permissions
• Updated roles for existing users
• Created shared test users by role
• Removed locations that are outside City of Austin
• Added non-CR3 values to the summed Comprehensive Cost columns on the Locations Index page
• Added Estimated Comprehensive Cost column to the Crash Index Page
• Added ability to hide columns on VZE tables

VZD

• Update Units Table to include atd_mode_category
• Update ETL to add atd_mode_category_metadata value on crash record creation or update
• Improved the way VZD compares formatting of existing records to formatting from the new records in CRIS
• Reinserted all time data for the following tables: person, primary person, charges, units
• Updated ETLs for these tables to process all edits from CRIS

Deployment Requirements:

• Update SQL function atd-vzd/triggers/get_location_totals.sql in Prod DB
• Update SQL view atd-vzd/views/view_location_injry_count_cost_summary-schema.sql in Prod DB
• Check user roles in Auth0 dashboard
• Notify VZ team that they need to log out of VZE and log back in after release

v1.4.0 Arrow Dr

VZE

• Fix bug where Location view broke when there were no CR3 or blue form crashes in the 5 years history for comprehensive cost and total crashes aggregates
• Fix speed management points and cost calculations bug

VZD

• Imported locations polygon layer
• Replicated the joining process between the locations polygon layer and Vision Zero data
• Automation of locations associations to crash records (CR3 & non-CR3s)
• Add ETL email processing error handling
• Add atd_mode_category_metadata column to crash table
• Update ETL to publish atd_mode_category_metadata to Socrata
• Update ETL to publish fatalities and serious injury totals by mode

VZV

• Add the Map component with crash points plotted
• Add compass loading icon to map
• Add mode filters for map data
• Add date range filter for map data
• Add crash type filters for map data
• Add ASMP Street level overlay to map
• Add High Injury network overlay to map
• Add Austin City Council districts overlay to map
• Add Dynamic Time of Day chart/filter to map
• Add summary view quick view count widgets
• Add Fatalities and Serious Injuries filters on summary visualizations
• Add Fatalities by Time of Day visualization to summary view
• Add Demographics visualization to summary view
• Add Fatalities and Serious Injuries by Jurisdiction visualization to summary view
• Add “Other” mode category to map and summary view visualizations
• Update map and summary views to consume new fatality and serious injury by mode columns from Socrata
• Add rules for summary page formatting of visualizations
• Create mobile styles and navigation behavior
• Create rules to update map and summary components to handle year changes and enforce time window of data dynamically
• Remove legacy summary view components
• Add “Work in Progress” disclaimer
• Fix routing to work with production url pathname

v1.3.0 Adelaide Dr

VZE

• Fix incorrect values displaying in the VZE Dashboard
• Fix null values displaying in VZE Dashboard due to new year of data
• Fix lookup value mismatch bug that was causing some crash records to not load
• Fix Crash Details so that the Edit Coordinates saved lat/lon matches the static map view
• Add updated_by to map coordinates edits so that they show up in the Change Log
• Add units data to crash record export
• Update Details component in Locations Details page to only include data from previous 5 years
• Add new table for nonCR3 crashes in Locations Details page
• Fix LocationCrashes table export data for Unit Description to match table data
• Fix bug where locations pages were not loading
• Copy & label changes for data fields

VZD

• Update Socrata ETL to enable GeoJSON fetch from Socrata
• Geocoded new import of crash records
• Automated geocoding for any new crash records moving forward
• Add bounding box for geocodes to improve results
• Add Geocoding ETL and handling for 'MatchLevel'
• Update Socrata demographics data with mode
• Add atd-agol-util to docker
• Added coalesce wrapper for location_injry_count_cost_summary view
• Added new lookup tables
• Fixed problem with strings containing delimiters
• Associate Locations to non-CR3 collisions & update script

VZV

• Create app routes for dashboard and map
• Add traffic fatalities by mode visualization
• Add Summary Quick Views

v1.2.0 Armadillo Rd

In this release we:

VZE

• Update dashboard queries to reflect APD confirmed fatalities
• Add advanced filters for "Exclude Private Driveway Crashes", "APD Confirmed Deaths" and "CRIS Deaths"
• Update headers to be more explicit were also added to Crashes and Locations tables
• Add Geocoding Source above Crash Location map component and update Location association label
• Replace Geocoding Provider ID with human readable label.
• Add a column to the Crashes index table for seeing the Geocode Provider for each record and updates geocode provider labels for language consistency
• Fixes GridTable search query bug

VZD

• Lots of ETL work
• ETL to push data to Socrata

VZV

• Add disclaimer about data accuracy
• 5 year comparison of traffic deaths visualization

v1.1.0 Allandale Rd

In this release we:

• Replace ruby-based Capybara automation for extracting CR3s with python-based Splinter and major refactors of ETL processes now being deployed to Airflow.
• Update labels, fields displayed, data reset/confirm feature, and backend triggers related to CRIS and APD confirmed death counts and fatality flags.
• Fix "No Latitude and Longitude" filter and refactor associated advanced filters.
• Add Speed Management table and points calculation to Crash records table.
• Update economic and comprehensive costs values in lookup table, recalculate and update related backend triggers.
• Database/infrastructure migration to austinmobility AWS servers.

v1.0.1 Azie Morton Rd

Our v1 release is named in honor of Azie Taylor Morton, an Austinite, civil servant, and trailblazer.

Features, enhancements, and bugs addressed in this release include:

New URLs:

• Production: https://visionzero.austin.gov/editor
• Staging: https://visionzero-staging.austinmobility.io/editor

Routing for /editor and /viewer #346

• Implement basic/static VZ dashboard at https://visionzero.austin.gov/viewer

Locations details page major enhancements::

• summary stats dynamically driven by filters and table queries #246
• Badges to indicate filters enabled #352
• Add “Total Comprehensive Cost” widget to Location details page, replaces “Total Units” #311
• Add horizontal bar chart of crashes by mode (top 4) in place of type of vehicle pie cart #372
• Implement ASMP Levels editable dropdown #306
• Implement Advanced filters on Location Crashes grid table #333

Crash details page major enhancements:

• Download CR3s from Crash details page #330
• Security considerations, further scraping and ETL automation #369
• Implement micromobility device flag #306

Query improvements:

• Query serious injuries through Crash table instead of Person table #293
• VZV: Get data for all of last year in line graph #356

Other minor enhancements or bug fixes:

• Nearmap API key for Location details map #228
• Fix edit coordinates “cancel” button bug #377
• “Modified by” in change log #234
• Fix SQL Trigger on fatality flag #313
• Fix inaccurate charges counts on Crash details accordion #395
• Fix bug with new records displaying null values #400
• Fix page crash on Edit Polygon #388

v1.0 A STREET TO BE NAMED

This release marks first production deployment of the Vision Zero Editor.