Skip to content

v.1.21.0 Exposition Blvd
Compare
Choose a tag to compare
@mateoclarke mateoclarke released this 22 Jul 15:13
v1.21.0
7ef6abe
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Verified
Learn about vigilant mode.

camp_mabry

Vision Zero Database

  • Add trigger to set austin_full_purpose (#1007) @mateoclarke
  • Resolve comprehensive cost sum for locations (#1004) @frankhereford
  • Re-write get_location_totals() (#1003) @frankhereford
    • get_locations_totals() received a signature change during this release; one no longer specifies the comprehensive cost of a non-CR3 crash in its invocation; it will find the correct value out of atd_txdot__est_comp_cost_crash_based.
  • Address issue in get_location_totals() function (#1002) @frankhereford

Vision Zero Editor

Vision Zero Events

  • Update to lambda function to associate SVRD, directional crashes to polygons (#1013) @frankhereford

Vision Zero Viewer

Library version maintenance

Deployment Notes

Changes to the database

  • Add new column to atd_txdot_blueform (SQL)
    • Grant editor INSERT, SELECT & UPDATE in Hasura for new field.
    • Grant readonly SELECT on new field.
  • Add new column to atd_txdot_crashes (SQL)
    • Grant editor INSERT, SELECT & UPDATE in Hasura for new field.
    • Grant readonly SELECT on new field.
  • Create and populate atd_txdot__est_comp_cost_crash_based (SQL)
    • Track this in Hasura and grant SELECT to editor and readonly
  • Update the atd_txdot_crashes_updates_audit_log() function (SQL)
    • We had discussed the need to drop and recreate the trigger that invokes this function, but the CREATE AND REPLACE syntax avoids this requirement.
  • Cause the audit log function to be invoked on every crash in the database.
    • Most easily, this query will do this task, but consideration should be taken with regards to load on the database at the time of the operation. Based on testing in the staging database, a 20 minute execution time should not be unexpected.
    • update atd_txdot_crashes set est_comp_cost_crash_based = 1;
  • Update the view_location_injry_count_cost_summary view (SQL)
  • Update the view_location_crashes_global view (SQL)
  • Update the get_location_totals() function. This will need to be untracked in Hasura, dropped, and recreated due to the signature change resulting from the removal of one of this functions arguments. (SQL)
  • Create cr3_nonproper_crashes_on_mainlane (SQL)
    • Track this view in Hasura and grant SELECT permission to EDITOR and READONLY

Contributors

frankhereford, mateoclarke, and 2 other contributors
Assets 2
Loading