Data Dictionary

ID
measure_id
Typ
float8
Beskrivning

ID Number assigned to uniquely identify each Measure

ID
measure_name
Typ
text
Beskrivning

Measure Name

ID
interval_type
Typ
text
Beskrivning

Interval Type for measure result collection

ID
value_type
Typ
text
Beskrivning

Value Type of measure result

ID
measure_value
Typ
float8
Beskrivning

Actual value of the measure

ID
year_to_date_variance
Typ
float8
Beskrivning

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
Beskrivning

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

ID
decimal_accuracy
Typ
int4
Beskrivning

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

ID
desired_direction
Typ
text
Beskrivning

Desired Direction - determines colour and direction of trend arrows

ID
category
Typ
text
Beskrivning

Category to which measure is assigned

ID
data_source_notes
Typ
text
Beskrivning

DataSource Notes to display under the Chart

ID
city_perspective_note
Typ
text
Beskrivning

CityPerspective Note to display under Trend Analysis

ID
year
Typ
int4
Beskrivning

Year

ID
period_number_in_year
Typ
int4
Beskrivning

Period number - Month

ID
target
Typ
float8
Beskrivning

Target value of the measure

ID
note
Typ
text
Beskrivning

Note

Mer information

Fält Värde
Data senast uppdaterad 3 juni 2026
Metadata senast uppdaterad 4 juni 2026
Skapad 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 updateför 20 timmar sedan
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 797
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