Data Dictionary

ID
measure_id
Type
float8
Opis

ID Number assigned to uniquely identify each Measure

ID
measure_name
Type
text
Opis

Measure Name

ID
interval_type
Type
text
Opis

Interval Type for measure result collection

ID
value_type
Type
text
Opis

Value Type of measure result

ID
measure_value
Type
float8
Opis

Actual value of the measure

ID
year_to_date_variance
Type
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
Type
float8
Opis

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

ID
decimal_accuracy
Type
int4
Opis

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

ID
desired_direction
Type
text
Opis

Desired Direction - determines colour and direction of trend arrows

ID
category
Type
text
Opis

Category to which measure is assigned

ID
data_source_notes
Type
text
Opis

DataSource Notes to display under the Chart

ID
city_perspective_note
Type
text
Opis

CityPerspective Note to display under Trend Analysis

ID
year
Type
int4
Opis

Year

ID
period_number_in_year
Type
int4
Opis

Period number - Month

ID
target
Type
float8
Opis

Target value of the measure

ID
note
Type
text
Opis

Note

Dodаtne informаcije

Polje Vrijednost
Data last updated 20. veljače 2026.
Metadata last updated 21. veljače 2026.
Kreirаno 9. studenoga 2022.
Formаt CSV
Licencа 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 updateprije 1 dan
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.630
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