v1.11.0 Cesar Chavez St

VZx v1.11.0 Cesar Chavez St Release Notes

photo credit © 2019 Viewfinder Heart

VZE

• Make Death Count & Serious Injuries editable fields for Units & Persons on Crash Details Page PR #853

VZD

• Documents changes to conflict resolution table: Added Crash Date, Record Unique ID, and updates on indexing PR #853

VZV

• Accessibility Improvements PR #857
• Fixes Summary view By Time of Day visualization bug that reversed the totals of the days of the week PR #850
• Fixes several bugs with the map date range picker as well as updating the icon displayed to the right of the date range in the sidebar PR #851
• Updates the content of the Summary banner to share efforts of ATD’s Vision Zero program PR #858

ETL

• Downloads CR3s for all records PR #859
• Updated process to allow creation of branches for our code PR #847

Deploy Notes

v1.10.0 Congress Ave

VZx v1.10.0 Congress Ave Release Notes

Image Source: Austin American-Statesman

VZE

• Crashes now shows a full purpose list (full purpose flag or city_id = 22 and position = null) PR #830
• Only display edit button for non-read only users for Unit Details Card PR #843
• Make atd_fatality_flag editable in VZE PR #842

VZD

• Allows PRs for SQS Hasura Events PR #845
• Adds original_city_id to crashes table PR #837
• Fixed error on insertions for SQS PR #839
• Add atd_fatality_flag to Crash table PR #842

VZV

• Fixes mobile popups on the map view to appear within the user device’s view when a crash point is tapped PR #819
• Updates High Injury Network map layer with High Injury Roadways, styles network and roadways to highlight focused segments PR #833

ETL

• Improves Socrata ETL with more detailed logging, truncates Socrata tables before upserted the complete dataset on each run, and adds time of crash to the crash_date column in the demographics dataset PR #827
• Modifies Socrata ETL GraphQL queries to filter on Austin Full Purpose flag = Y OR ( City ID = 22 AND position = null ) PR #834
• Updates to ETL CR3 Process, it now downloads CR3 PDFs for full purpose flag records or city_id = 22 and position = null) PR #846

Deploy Notes

v1.9.0 Bouldin Ave

VZx v1.9.0 Bouldin Ave Release Notes

Image Source Link

VZE

• Non-CR3 Record upload tool #799
• Conflict Resolution Tool #558
• Fixes bug where app redirected user to dashboard when visiting a link or bookmark if login was required to reach it PR #802
• Add new fields for Location Details crashes export PR #804 & #807
• Reorganize sidebar PR #813
• Disable Location polygon edit mode PR #814
• Update label “Serious Injuries” to “Suspected Serious Injuries” PR #815
• Unit Card updates including new “direction” and “movement” fields PR #803

VZD

• Fixes to CircleCI pipeline for SQS/Lambda #801
• Additional indexing to blueform columns #800
• Additional indexing for crash date: #790
• Hasura Events: SQS/Lambda Handlers #794

VZV

• SQL Views for data quality checking #798
• Fixes map date-picker buttons on Windows (FireFox, Chrome) #788
• Adds Google Analytics to track user navigation and crash severity filter events PR #783
• Updated header styles to align with mobile behavior of content, improve mobile experience, and fix multiple scrollbar bug in Summary view PR #787
• Updates all popover content using language approved by Vision Zerto Team PR #792
• Adds Race/Ethnicity popover with clarifying language when user selects Race/Ethnicity tab in Demographics visualization PR #795
• Fixes styling issue in Firefox where X axis labels are covered up by chart PR #796
• Added footer to Summary view with CoA seal and important links PR #797
• Improves map styles to resize crash points with zoom level, limits map navigation to Travis County, and improves polygon tool hover text PR #793
• Update warning banner and version number PR #791
• Fixes iOS Safari bug that made Map view scrollable and hid the controls PR #805
• Adds a Map info box to display fatalities and serious injuries inside a drawn polygon PR #809

ETL

• Fixes to crash upserts #786

Deploy Notes

• See notes in atd-vzd/migrations/migration_units_2020_06_02--0215.sql

v1.8.0 Barbara Jordan Blvd

VZx v1.8.0 Barbara Jordan Blvd Release Notes

VZV

• Updates heights of By Mode and By Month components so they are both the same PR #776
• Updates default map data to span the first day of the current year to the last day of the month two months prior to the current date PR #777
• Adds a popover info component to the Map Traffic Crashes section, the Map Overlays section, and the Summary Years of Life Lost widget; fixes bug where mobile side drawer remained open when transitioning from mobile to desktop or landscape view PR #778
• Updates the global sliding window of data to span the first day of the year that is four years ago to the last day of the month that two months two months prior to the current date PR #780
• Updates the City Council District layer’s source to Socrata in order to decrease the resource size; improved the map layer ordering to better visualize the crash points, roads, and overlays when displayed together PR #781
• Adds disclaimer banner with last time data was updated, geographic boundaries and a link to the popover that describes methodology PR #782
• Adds data quality disclaimer modal PR #784

ETL

• Changes ETL data gathering from files in emails to files in an SFTP server. This has been done in a separate repository (atd-airflow).
• Updates the ETL processing logic to be more efficient. PR #770

VZE

• n/a

VZD

• n/a

Deploy Notes

• n/a

v1.7.0 Burnet Rd

VZx v1.7.0 Burnet Rd Release Notes

VZE

• Fixes bug in Location crash summary counts PR #766

VZD

• Updated comprehensive economic costs calculation formula to include unknown injuries and multiply each by $51,000 PR #773
• The read replica now supports long queries by making use of postgres’ hot_standby_feedback feature, with some adjustments made on the back end to allow for safe use of this practice. Not a PR since there is no code involved, but an issue is found in this link. Issue #2487

VZV

• Updates Map fatalities and serious injuries crash point styles to differentiate them, adds Map navigation controls and user geolocation feature PR #757
• Updates Map crash point hover info box format for better readability, adds new mobile tap popup info box to avoid covering map controls on mobile screens PR #762
• Updates By Month visualization by adding custom interactive legend that displays each year label, total fatalities and/or serious injuries for each year, and associated chart color; allows users to click legend items to remove and add them to the chart, with legend colors being updated accordingly; Adds hover indicators to legend items; Improves overall styling PR #763
• Updates By Mode visualization by adding custom interactive legend that displays mode data for all years in grid format; Adds clickable mode labels using colored symbols for user to turn on or off modes in chart display; Adds mobile responsiveness: Displays words and symbols for labels on larger screens and symbols only on smaller screens; Adds tooltips and screen reader text describing symbols for accessibility; Adds new "Other" symbol PR #764
• Removed By Jurisdiction visualization PR 771
• Updates the styles of the Map controls sidebar with improved designs (buttons, colors, font size), updates crash type filter buttons to match those in the Summary view visualizations PR #765
• Fixes Summary “By Month/Year” chart bug that prevented data from populating until a record for a month existed (leaving potential gaps in data points) PR #772

ETL

• n/a

Deploy Notes

• n/a

v1.6.0 Berkman Dr

VZx v1.6.0 Berkman Drive Release Notes

VZE

• Added inconsistent crash numbers report. PR #737
• Added date range helper text to Locations table. PR #758
• Updated Locations summary counts on Locations Index Page. PR #756
• Reorder sidebar items and update admin vs non-admin nav & routing. PR #760

VZD

• Added index to city_id in crashes. This should help a little bit with query performance. PR #752

VZV

• Updates date range picker in the Map component for better date navigation and overall usability. PR #717
• Updates Vision Zero Viewer Dashboard colors using consistent colors scheme. PR #729
• Updates crash type selector to be simple buttons rather than toggles, updates headers, adds line breaks after buttons, and redesigns secondary selectors (year, demographic type) to match crash type buttons. PR #735
• Updates Time of Day visualization with intensity gradient that matches overall Vision Zero View color scheme. PR #736
• Moves navigation header items to the right of view to follow better design patterns PR #738
• Updates Summary view widgets with better design patterns and also compares current year-to-date totals with year-to-date totals of the previous year PR #734
• Updates the Summary view to only display the sidebar on mobile view for navigation PR #739
• Adds and applies the same Prettier auto-formatting config that is used in VZE PR #739
• Makes all Chart.js visualizations responsive, updates styling for mobile optimization, redesigns By Month component and chart legend, removes “"As of {month} {year}, there have been ..." narrative element to conserve vertical space PR #742
• Updates Time of Day visualization scale so that 0 is always represented by the lowest color in the intensity range, adds a legend for better context, and updates styling PR #746
• Replaces Vision Zero logo PNG files with optimized SVG file PR #748
• Implements minor styling changes to make spacing consistent on all components PR #750
• Adds a tool to draw a polygon on the VZV map and filter to crashes within that polygon. PR #743
• Adds dimensions to Vision Zero logo SVG to address styling issues PR #753
• Integrates custom tooltip on Time of Day chart to show times when there have not been any crashes as “0” rather than a null value PR #754
• Adds alert banner: “This site is a work in progress. The information displayed may be outdated or incorrect. Check back later for live Vision Zero data.” PR #755

ETL

• Changes to the ETL that allow for the crashes table to update automatically if the crash record has not been edited by a human. PR #737
• Fixes a bug in 737 where the CR3 always default to Yes, meaning that the CR3 would never download for new or updated records. Fixed bug in the database as well. PR #741
• Added logic to send crash updates to the Q/A list if the record is edited by a human and death count or serious injuries are different. PR #747
• Added logic to send secondary records to the Q/A list. This enables VZE to insert the entire bundle for a crash once Q/A approves the updates. PR #749

Deploy Notes

• Apply the view table update to atd-vzd/views/view_location_injry_count_cost_summary-schema.sql on the production DB on deployment.

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