v1.13.0 Capital of Texas Hwy

VZx v1.13.0 Capital of Texas Hwy

📸 : BrianDooley.com

VZE

• Temporary Crash Record Creator UI Updates PR #895
• VZE: Fixes Crash location id not showing correctly PR #899

VZD

• Created new column for Non-CR3s (blueform table) for position and position indexing, and automatic update triggers. PR #896
• Created functions to help identify main-lanes (CR3, Non-CR3): find_cr3_mainlane_crash PR #896
• Created views to help identify Main-lanes (CR3, Non-CR3): PR #896

VZV

• Add social sharing metatags PR #888
• Adds a By Population chart to visualize traffic-related fatalities and serious injuries per 100,000 residents PR #882
• Fixes bug where Map view type filter buttons overlapped in Windows when using Chrome PR #890
• Updates the README with details of the project PR #891
• Improves responsiveness of Summary view widgets, fixes bug where demographics visualization legend colors failed to update properly PR #897
• Updates the Map view to default to records within the global date range, improves API requests by selecting only necessary columns PR #898

ETL

• Daily Main-lane dissociation script enabled in production. PR #22
• Daily crash location association for CR3/Non-CR3 enabled in production PR #22
• Added unit-testing for SQS Events PR #896

Deploy Notes

• These release notes include updates shipped as patches in VZx versions 1.12.1 through 1.12.4

v1.12.0 Cameron Rd

VZx v1.12.0 Cameron Rd Release Notes

photo credit: arch-ive.org

VZE

• Temporary Crash Record Creator UI PR #875
• Make Crashes & Location Crashes fields match for CSV exports PR #879
• Global crash data export for a location: PR #870
• Fixes to Non-CR3 upload tool PR #860
• Give Editors access to Changes pages PR #881

VZD

• Update “INCAPACITATING INJURY” to “SUSPECTED SERIOUS INJURY” PR #880
• Renamed blueform column from call_num to crash_id, renames call_num index accordingly, and updates function find_location_for_noncr3_collision. PR #860

VZV

• Adds definitions to crash data info modal PR #863
• Adds additional content to the By Year visualization info modal PR #864
• Reorders the charts in the Summary demographics visualization PR #866
• Updates all popovers to modals to improve responsiveness PR #867
• Fixes date picker bug where mobile virtual keyboards opened on tablets PR #868
• Updates By Year & Month visualization with a bar chart, compares 5 year averages to current year totals PR #871 and PR #874
• Remove data quality Alert Banners PR #865 & PR #869

ETL

• Fixed the time limit of the data being exported to Socrata: PR #873
• There are now two processes that search for crashes (CR3 or Non-CR3) that do not have a location assigned to them and attempt to associate locations. Different repo (atd-airflow), merged straight to master. Example.

Deploy Notes

• We need to run the migration for updating the injury lookup table in production DB during/after deployment
• We need to run a series of migrations that updates one internal SQL function, renames a table column and renames the name of an index for the blueform table. This will cause the production page to break momentarily while the changes are being applied. PR #860
• There have been updates to the data redrive policy (failed events) for all SQS events (Tech Debt) PR #876

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