Data Dictionary

Column Type Label 描述
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

其他信息

价值
Data last updated 2025年6月6日
Metadata last updated 2025年6月7日
创建的 2022年11月9日
格式 CSV
授权 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 update2天前
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