Data Dictionary

ID
measure_id
Typ
float8
Opis

ID Number assigned to uniquely identify each Measure

ID
measure_name
Typ
text
Opis

Measure Name

ID
interval_type
Typ
text
Opis

Interval Type for measure result collection

ID
value_type
Typ
text
Opis

Value Type of measure result

ID
measure_value
Typ
float8
Opis

Actual value of the measure

ID
year_to_date_variance
Typ
float8
Opis

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

ID
budget_variance
Typ
float8
Opis

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

ID
decimal_accuracy
Typ
int4
Opis

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

ID
desired_direction
Typ
text
Opis

Desired Direction - determines colour and direction of trend arrows

ID
category
Typ
text
Opis

Category to which measure is assigned

ID
data_source_notes
Typ
text
Opis

DataSource Notes to display under the Chart

ID
city_perspective_note
Typ
text
Opis

CityPerspective Note to display under Trend Analysis

ID
year
Typ
int4
Opis

Year

ID
period_number_in_year
Typ
int4
Opis

Period number - Month

ID
target
Typ
float8
Opis

Target value of the measure

ID
note
Typ
text
Opis

Note

Dodatkowe informacje

Pole Wartość
Data last updated 30 czerwca 2026
Metadata last updated 1 lipca 2026
Created 9 listopada 2022
Format CSV
Licencja 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 update10 godzin temu
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 802
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