Data Dictionary

ID
measure_id
Type
float8
Beskrivelse

ID Number assigned to uniquely identify each Measure

ID
measure_name
Type
text
Beskrivelse

Measure Name

ID
interval_type
Type
text
Beskrivelse

Interval Type for measure result collection

ID
value_type
Type
text
Beskrivelse

Value Type of measure result

ID
measure_value
Type
float8
Beskrivelse

Actual value of the measure

ID
year_to_date_variance
Type
float8
Beskrivelse

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
Beskrivelse

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

ID
decimal_accuracy
Type
int4
Beskrivelse

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

ID
desired_direction
Type
text
Beskrivelse

Desired Direction - determines colour and direction of trend arrows

ID
category
Type
text
Beskrivelse

Category to which measure is assigned

ID
data_source_notes
Type
text
Beskrivelse

DataSource Notes to display under the Chart

ID
city_perspective_note
Type
text
Beskrivelse

CityPerspective Note to display under Trend Analysis

ID
year
Type
int4
Beskrivelse

Year

ID
period_number_in_year
Type
int4
Beskrivelse

Period number - Month

ID
target
Type
float8
Beskrivelse

Target value of the measure

ID
note
Type
text
Beskrivelse

Note

Yderligere information

Felt Værdi
Data last updated 20. februar 2026
Metadata last updated 21. februar 2026
Oprettet 9. november 2022
Format CSV
Licens 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 updatefor 3 timer siden
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