Platform Asset Manual Update Requirements


Program Delivery Dashboard

Schedule


Banner: Advertising Performance
Rollover Month: July
Action: Modify Socrata API call/query to report data for the current state fiscal year
  1. All Regions page
  2. Region 1 page
  3. Region 2 page
  4. Region 3 page
  5. Region 4 page
Table: Advertising Performance History
Rollover Month: July
Action: Modify HTML and Socrata API call/query to report data for the three (3) previous state fiscal years
  1. All Regions page
  2. Region 1 page
  3. Region 2 page
  4. Region 3 page
  5. Region 4 page
Chart: Current Preconstruction Schedule – Committed vs. Actual Advertise Date
Rollover Month: July
Action: Modify the chart filter to display data starting 6 months prior to the beginning of the current state fiscal year, and ending 6 months after the end of the current state fiscal year
  1. All Regions page
  2. Region 1 page
  3. Region 2 page
  4. Region 3 page
  5. Region 4 page
Chart: Current Preconstruction Schedule – Project Advertising (Submit Date)
Rollover Month: July
Action: Modify the chart filter to display data starting 6 months prior to the beginning of the current state fiscal year, and ending 6 months after the end of the current state fiscal year
Note: This chart may show projects prior to the filtered period, if a project had a submit for advertising date in the period, but was actually advertised prior to the beginning of the period
  1. All Regions page
  2. Region 1 page
  3. Region 2 page
  4. Region 3 page
  5. Region 4 page
Chart: 3-Year Advertising Results
Rollover Month: July
Action: Modify the chart filter to display data for the previous three (3) state fiscal years, and the current state fiscal year
  1. All Regions page
  2. Region 1 page
  3. Region 2 page
  4. Region 3 page
  5. Region 4 page

Budget


Chart: Obligations Goal Status
Rollover Month: October
Action: Modify the SQL query epm_curpgm_fndobl_curobl-vw.sql, to reflect new Federal obligation targets for the program as a whole, and for each region. Values to modify are found in lines 727-732 and 826-831.
  1. All Regions page
  2. Region 1 page
  3. Region 2 page
  4. Region 3 page
  5. Region 4 page

Chart: Current Year Federal Estimate and Obligation Total
Rollover Month: October
Action: Modify chart targets (viz annotations) to reflect current year goals; these are provided by the Program Management Lead (currently Dave Schwartz)
  1. All Regions page
  2. Region 1 page
  3. Region 2 page
  4. Region 3 page
  5. Region 4 page

Chart: Project Values – Awarded/Advertised
Rollover Month: October
Action: Modify the chart filter (STIP_Yr) to reflect the current Federal fiscal year
  1. All Regions page
  2. Region 1 page
  3. Region 2 page
  4. Region 3 page
  5. Region 4 page

Scope


Chart: Final Construction Expenditures vs. Original Contract Amount Trend
Rollover Month: July
Action: Modify the chart filter to include the current state fiscal year, and the four (4) previous fiscal years
  1. All Regions page
  2. Region 1 page
  3. Region 2 page
  4. Region 3 page
  5. Region 4 page


Table: Final Construction Expenditures vs. Original Contract Amount Trend
Rollover Month: July
Action: Modify the Socrata API calls/queries to display data for the current and previous four (4) state fiscal years
  1. All Regions page
  2. Region 1 page
  3. Region 2 page
  4. Region 3 page
  5. Region 4 page

Transportation Commission

Zero Fatalities


Chart: Traffic - Fatalities
Rollover Month: January
Action: Modify the chart filter to display the current and previous five (5) years of data

Table: Traffic - Fatalities
Rollover Month: January
Action: Modify the Socrata API call/query to display the current and previous five (5) years of data

Chart: Traffic - Serious Injuries
Rollover Month: January
Action: Modify the chart filter to display the current and previous five (5) years of data

Table: Traffic - Serious Injuries
Rollover Month: January
Action: Modify the Socrata API call/query to display the current and previous five (5) years of data

Chart: Traffic - Crashes
Rollover Month: January
Action: Modify the chart filter to display the current and previous five (5) years of data

Table: Traffic - Crashes
Rollover Month: January
Action: Modify the Socrata API call/query to display the current and previous five (5) years of data

Project Development


Banner: Current FY Advertising Performance
Rollover Month: July
Action: Modify the Socrata API call/query to display the current state fiscal year
Note: Both of the banners shown below are in the same content frame; only the API call(s)/query(ies) for advertising performance need to be modified

Chart: Advertising Status
Rollover Month: July
Action: Modify the chart filter to begin 6 months prior to the start of the current state fiscal year, and end 6 months following the end of the current state fiscal year

Chart: Project Count & Construction Contracts
Rollover Month: This chart requires updating, each month a Transportation Commission meeting is scheduled
Action: Modify the chart period to reflect the most recent 12 (actually 13) months of data. 

Chart: Contract Award vs. Engineer's Estimate
Rollover Month: This chart requires updating, each month a Transportation Commission meeting is scheduled
Action: Modify the chart period to reflect the most recent 12 months of data. 


Maintenance Tactical Measures


Table: Current Year Code 1 Maintenance
Rollover Month: July
Action: Modify the SoQL api query to extract for the current FY 
Table: Current Year Snow Removal Budget Execution
Rollover Month: July
Action: Modify the SoQL api query to extract for the current FY