Data Sources

DATA SOURCES

combined_data_v4.csv

This data is used for the graphs.

• Columns: OKR,date_or_period,category_or_dept,variable,value
  • OKR is a string that defined the objective and key result ex. "obj1kr1"
  • date_or_period is a number that states what date in the fiscal year it is(1-12) or what the date is in UNIX time. Ex. 1 or 1559534400.
  • category_or_dept is a string that says what department the data is for. Ex. "fire_response"
  • variable is a string that is the descriptor of the value column.
  • value is a number; the data point.

combined_percentage_data.csv

This data is used for the indicator numbers on the left of rows and the middle value.

• Columns: OKR,category_or_dept,variable,value,on_time,out_of_total
  • OKR is a string that defined the objective and key result ex. "obj1kr1"
  • category_or_dept is a string that says what department the data is for. This is used for the row title. Ex. "fire_response"
  • variable is a string that is the descriptor of the value column.
  • value is a number; the data point for the middle value.
  • on_time is a number and is used as a numerator.
  • out_of_total is a number and is used as a denominator.

keyResultBannerData.csv

This data is used for key result2 banners data.

• Columns: OKR,category_or_dept,variable,value,on_time,out_of_total
  • OKR is a string that defined the objective and key result ex. "obj1kr1"
  • category_or_dept is a string that says what department the data is for. This is used for the row title. Ex. "fire_response"
  • variable is a string that is the descriptor of the value column.
  • value is a number; the data point for the middle value.
  • on_time is a number and is used as a numerator.
  • out_of_total is a number and is used as a denominator.

FiscalObjective2.csv

This data is used for objective 1 key result financial data.

• Columns: OKR,category_or_dept,variable,project_dollars,authorized_dollars,spent_dollars,unspent_dollars,value
  • OKR is a string that defined the objective and key result ex. "obj1kr1"
  • category_or_dept is a string that says what department the data is for. Ex. "General City Projects "
  • variable is a string that is the descriptor of the value column.
  • project_dollars is a number and is used for project dollars row.
  • authorized_dollars is a number and is used for authorized dollars row.
  • spent_dollars is a number and is used for spent dollars row.
  • unspent_dollars is a number and is used for unspent dollars row.
  • value is a number; the data point for the middle value.

FiscalObjective3.csv

This data is used for objective 1 key result 3 financial data.

• Columns: OKR,category_or_dept,variable,project_dollars,authorized_dollars,spent_dollars,unspent_dollars,value
  • OKR is a string that defined the objective and key result ex. "obj1kr1"
  • category_or_dept is a string that says what department the data is for. Ex. "General City Projects "
  • variable is a string that is the descriptor of the value column.
  • project_dollars is a number and is used for project dollars row.
  • authorized_dollars is a number and is used for authorized dollars row.
  • spent_dollars is a number and is used for spent dollars row.
  • unspent_dollars is a number and is used for unspent dollars row.
  • value is a number; the data point for the middle value.

mainPageData.csv

This data is used for index.html

• Columns: obj,OKR,cardDescription,on_time,out_of_total,dataDescription,timeDescription,movement
  • obj is a string that states what objective it's for. Ex. "obj1"
  • OKR is a string that defined the objective and key result ex. "obj1kr1"
  • cardDescriptionis a string that says what card is for. Ex. "Reduce the general fund budget variance from 11% to 5% "
  • on_time is a number and is used as a numerator.
  • out_of_total is a number and is used as a denominator.
  • dataDescription is a string and describes the data. Ex. "Departments Complying"
  • timeDescription is a string that descripes the time in use. Ex. "since last month"
  • movement is a number and is used for determining what arrow to put and what color for the box. -1 is a downward trend, 0 is stable, and 1 is upward.

Settings

settings.json

This data is used to set parameters for each key result that are loaded into generatekeyresult

• values:
  • lastModifiedDate is a string value: Ex. "July 30".
  • objective1/2/3/4 is a map of values
    • keyResult1/2/3/4 is a map of values
      • key is a string that corresponds with the key in the CSVs for each objective/key result. Ex. obj1kr1.
      • TargetName is the name value of the intended target div.
      • mode is a number value for the generatekeyresult. 1/2/3
      • keyMode is a number value for the generatekeyresult. 1/2
      • money is a number value for the generatekeyresult. 0/1
      • indicatorRange is an array value for generatekeyresult. [MID, HIGH]
      • lastModifiedDate is a string value: Ex. "July 30".