Data Dictionary

ID
measure_id
Type
float8
Description

ID Number assigned to uniquely identify each Measure

ID
measure_name
Type
text
Description

Measure Name

ID
interval_type
Type
text
Description

Interval Type for measure result collection

ID
value_type
Type
text
Description

Value Type of measure result

ID
measure_value
Type
float8
Description

Actual value of the measure

ID
year_to_date_variance
Type
float8
Description

Year To Date Variance to compare % Changed for Current Year-To-Date vs. Previous Year to determine Analysis in Trend Analysis

ID
budget_variance
Type
float8
Description

Budget Variance to compare % Changed for Current Period vs. Budget/Target to determine Analysis in Trend Analysis

ID
decimal_accuracy
Type
int4
Description

Decimal Accuracy - number of decimals to display in the measure result

ID
desired_direction
Type
text
Description

Desired Direction - determines colour and direction of trend arrows

ID
category
Type
text
Description

Category to which measure is assigned

ID
data_source_notes
Type
text
Description

DataSource Notes to display under the Chart

ID
city_perspective_note
Type
text
Description

CityPerspective Note to display under Trend Analysis

ID
year
Type
int4
Description

Year

ID
period_number_in_year
Type
int4
Description

Period number - Month

ID
target
Type
float8
Description

Target value of the measure

ID
note
Type
text
Description

Note

Additional Information

Field Value
Data last updated 2 April 2026
Metadata last updated 2 April 2026
Created 9 November 2022
Format CSV
License License not specified
Datastore activeTrue
Datastore cache{'CSV': 'd4c2d841-2d74-466c-89a8-d8f7eba17050', 'XML': '4adaa89d-e0b2-4674-8977-83ce18ecfd7b', 'JSON': 'aa9774ef-1779-45cb-abe9-0be1a6642185'}
Datastore cache last update14 minutes ago
Extract jobAirflow: toronto-s-dashboard-key-indicators
Has viewsTrue
Id2350d71a-31d1-4387-9e29-4c1cfc866894
Is datastore cache fileFalse
Is previewTrue
Package idc6d64e9b-f85a-4084-be14-60cf18509203
Position0
Record count8,666
Stateactive
Url typedatastore
Extract Job Airflow: toronto-s-dashboard-key-indicators
Is Datastore Cache File? False
Datastore Cache
  1. CSV
  2. XML
  3. JSON
Datastore Cache Last Updated
Datastore resource's ID