Data Dictionary

Column Type Label Description
measure_id float8

ID Number assigned to uniquely identify each Measure

measure_name text

Measure Name

interval_type text

Interval Type for measure result collection

value_type text

Value Type of measure result

measure_value float8

Actual value of the measure

year_to_date_variance float8

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

budget_variance float8

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

decimal_accuracy int4

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

desired_direction text

Desired Direction - determines colour and direction of trend arrows

category text

Category to which measure is assigned

data_source_notes text

DataSource Notes to display under the Chart

city_perspective_note text

CityPerspective Note to display under Trend Analysis

year int4

Year

period_number_in_year int4

Period number - Month

target float8

Target value of the measure

note text

Note

Additional Information

Field Value
Data last updated May 9, 2025
Metadata last updated May 10, 2025
Created November 9, 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 update3 hours 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
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