Documentation of Strategic Goals Indexes

This story was created by BIO-WEST and is intended to document all source tables, calculations, scripts, methodology, and other information used to calculate index values used in the Strategic Direction pages for SAFETY, INFRASTRUCTURE, and MOBILITY. 

Measures

SAFETY

  • Traffic Fatalities
  • Traffic Serious Crashes
  • Traffic Crashes
  • UDOT Internal Fatalities
  • UDOT Internal Injuries
  • UDOT Equipment Damage

MOBILITY

  • Reliability
  • Delay
  • Snow
  • Mode Split

INFRASTRUCTURE

  • Pavement
  • Bridges
  • ATMS
  • Signals

Definitive Table Strategic Goals Indexes

Table of current indexes. Contains the three composite indexes as well as the component indexes that are weighted and summed to create the component indexes.
Display or use of indexes should link to this table and not try to calculate them. See examples below.

HTML to Display Indexes & Status Graphs

The HTML code from the following examples can be copied and used in Socrata stories as "HTML Embed".
These examples use HTML code to get the index and build status graphs from the "Definitive" table and display it using the UDOT desired blue style.

Zero Fatalities Index

Optimize Mobility Index

Preserve Infrastructure Index

Archive of Strategic Goals Indexes

This is a live table owned by BIO-WEST  and maintained via R-script which tracks index values over time (daily).  Annual values are calculated from the average daily values for each year.
Phil Nacamuli has a similar table (weekly) which is not currently being updated (as of Aug. 08, 2018. We are not using this table.

Targets, Weights, and Index Values

The Strategic Direction planning process established targets for each measure. A weighting system was also used to assign a relative weight based on each measures importance. Within each measure, the combined weights should equal 100.  Finally, Index Values are calculated base on how close UDOT is to meeting measure targets as follows. If all targets are met for a measure, the total index value would be 100.
Index Value = ((Measure/Target ) * Weight ) * 100

or

Index Value = 100-((Measure-Target)/(Max Value-Target)) * 100

Weights and Targets Table

Statewide and Regional
Edit this table to change the assigned weights and targets.  Scripts running in the background will update all calculations based on values in this table.
Comment field indicates which weights and targets are used in the calculations. Safety only uses weights, as targets are dynamically calculated based on data. 

SAFETY

Traffic Fatalities, Traffic Serious Injuries, and Traffic Crashes

Statewide and Regional
This is a live table updated nightly. All three measures use this table.
Script: uses latest year, queries table using Category field ('fatalities', 'injuries', or 'crashes') and calculates index value from the Actual,  Target and 3 Year Average plus 25% (maximum).


Internal Fatalities

Statewide and Regional
This is a STATIC table maintained by BIO-WEST. There is no update schedule but updated as necessary.
Script: uses latest year,
If count = 0 Index = 100
If count > 0 Index = 0

Internal Injury Rate and Equipment Damage

Statewide and Regional
This is a live table updated nightly. Both measures use this table. 
Script: uses CHART_DISPLAY field to determine months to use, calculates index value from Injury_Rate and Injury Target or Damage_Rate and Damage_Target

Mobility

Delay (I-15 Delay Hour) Statewide

Statewide table owned by Andrea Moser is updated monthly via script from Grant Thorton. 
Script: uses score field.

Delay Regions

Live table for regional Delay values with monthly updates owned by Phil Nacamuli. As of August 02, 2018 table did not contain goals or scores.
Using Statewide data for Region indexes.

Reliability Score Statewide

Table originally from an Excel file via email. Table Link
Script: uses normalized_score or regional score field.

Reliability Score Regions

Live table with monthly updates owned by Phil Nacamuli. As of August 02, 2018 table did not contain statewide values or goals.
Using Statewide data for Region indexes.

Mode Split

Statewide and Regional
This table maintained by BIO-WEST and updated as data becomes available.
Script: uses auto_trips and transit_trips fields.
Statewide data is old and needs to be updated.
Regional data is not yet available. Using statewide data for Regions for now.

Snow

Statewide and Regional
Live data maintained by Paul Legler. Updated on a monthly basis during snow season. 
Script: where performance_2 field is equal to "Exceptional" or "Acceptable" script uses performance_1 or regional performance field.
Regional data not yet available. Using statewide data for Regions for now.

Infrastructure

Pavement (Statewide)

Statewide pavement condition is a static table owned by HDR. It is updated periodically. Do not display future conditions in graphs.
Script: use fair and good fields

Pavement (Regions)

Regional pavement condition is a static table owned by HDR. It is updated periodically.
Script: use fair and good fields
NOTE: Graphs use filter on year set at 2017.

Bridges

Statewide and Regional
The dynamic table is maintained by phil.nacamuliBridge Index is calculated for each category, NHS, State and Local.
Script: uses combined_avg field
A live statewide and regional strucutre table with conditions is available 

Signals 

Statewide and Regional
This is a STATIC table maintained by BIO-WEST from a Google Drive table provided by Jamie Mackey. Update schedule is variable but usually indicated by an email to Glen.
Script: uses Percent Good and Average

ATMS

Statewide and Regional
This is a STATIC table maintained by BIO-WEST. Original data is an Excel file ATMS Device ATMS Device Summary.xlsx from Rob Clayton via email.
Script: uses % Operational
Regional data is not yet available. Using statewide value for regions for now.

Values used in latest calculations