データディクショナリ

ID
count_id
タイプ
int4
説明

Unique identifier for each count. Join to tmc_summary_data or tmc_most_recent_summary_data for rollup statistics.

ID
count_date
タイプ
date
説明

Date the count was conducted. For Turning Movement Counts, studies are conducted on one day only.

ID
location_name
タイプ
text
説明

Human-readable name of the location where the count was conducted (e.g. Bloor Street / Yonge Street)

ID
longitude
タイプ
float8
説明

Longitude GPS coordinate

ID
latitude
タイプ
float8
説明

Latitude GPS coordinate

ID
centreline_type
タイプ
text
説明

Intersection node or Midblock segment. Spatial geometry can be found by using centreline_type and centreline_id to lookup spatial information in the Toronto Centreline and Intersection File datasets. If the centreline_type is Intersection, cross-reference centreline_id with INTERSECTION_ID in the Intersection File dataset (https://open.toronto.ca/dataset/intersection-file-city-of-toronto/). If the centreline_type is Midblock, cross-reference centreline_id with CENTRELINE_ID in the Toronto Centreline dataset (https://open.toronto.ca/dataset/toronto-centreline-tcl/).

ID
centreline_id
タイプ
int4
説明

Unique location identifier that corresponds to the Toronto Centreline or Intersection File datasets. Join to the Toronto Centreline dataset for segments. Join to the Intersection File dataset for nodes.

ID
px
タイプ
int4
説明

If there is a traffic control signal at the location, this is the unique identifier for the signal. Join to Traffic Signals Tabular (https://open.toronto.ca/dataset/traffic-signals-tabular/).

ID
start_time
タイプ
timestamp
説明

Start time of the 15-minute interval

ID
end_time
タイプ
timestamp
説明

End time of the 15-minute interval

ID
n_appr_cars_r
タイプ
int4
説明

Volume of cars that enter the intersection from the north leg (approach), in a southbound direction of travel, and make a right turn.

ID
n_appr_cars_t
タイプ
int4
説明

Volume of cars that enter the intersection from the north leg (approach), in a southbound direction of travel, and continue through.

ID
n_appr_cars_l
タイプ
int4
説明

Volume of cars that enter the intersection from the north leg (approach), in a southbound direction of travel, and make a left turn.

ID
s_appr_cars_r
タイプ
int4
説明

Volume of cars that enter the intersection from the south leg (approach), in a northbound direction of travel, and make a right turn.

ID
s_appr_cars_t
タイプ
int4
説明

Volume of cars that enter the intersection from the south leg (approach), in a northbound direction of travel, and continue through.

ID
s_appr_cars_l
タイプ
int4
説明

Volume of cars that enter the intersection from the south leg (approach), in a northbound direction of travel, and make a left turn.

ID
e_appr_cars_r
タイプ
int4
説明

Volume of cars that enter the intersection from the east leg (approach), in a westbound direction of travel, and make a right turn.

ID
e_appr_cars_t
タイプ
int4
説明

Volume of cars that enter the intersection from the east leg (approach), in a westbound direction of travel, and continue through.

ID
e_appr_cars_l
タイプ
int4
説明

Volume of cars that enter the intersection from the east leg (approach), in a westbound direction of travel, and make a left turn.

ID
w_appr_cars_r
タイプ
int4
説明

Volume of cars that enter the intersection from the west leg (approach), in a eastbound direction of travel, and make a right turn.

ID
w_appr_cars_t
タイプ
int4
説明

Volume of cars that enter the intersection from the west leg (approach), in a eastbound direction of travel, and continue through.

ID
w_appr_cars_l
タイプ
int4
説明

Volume of cars that enter the intersection from the west leg (approach), in a eastbound direction of travel, and make a left turn.

ID
n_appr_truck_r
タイプ
int4
説明

Volume of trucks that enter the intersection from the north leg (approach), in a southbound direction of travel, and make a right turn.

ID
n_appr_truck_t
タイプ
int4
説明

Volume of trucks that enter the intersection from the north leg (approach), in a southbound direction of travel, and continue through.

ID
n_appr_truck_l
タイプ
int4
説明

Volume of trucks that enter the intersection from the north leg (approach), in a southbound direction of travel, and make a left turn.

ID
s_appr_truck_r
タイプ
int4
説明

Volume of trucks that enter the intersection from the south leg (approach), in a northbound direction of travel, and make a right turn.

ID
s_appr_truck_t
タイプ
int4
説明

Volume of trucks that enter the intersection from the south leg (approach), in a northbound direction of travel, and continue through.

ID
s_appr_truck_l
タイプ
int4
説明

Volume of trucks that enter the intersection from the south leg (approach), in a northbound direction of travel, and make a left turn.

ID
e_appr_truck_r
タイプ
int4
説明

Volume of trucks that enter the intersection from the east leg (approach), in a westbound direction of travel, and make a right turn.

ID
e_appr_truck_t
タイプ
int4
説明

Volume of trucks that enter the intersection from the east leg (approach), in a westbound direction of travel, and continue through.

ID
e_appr_truck_l
タイプ
int4
説明

Volume of trucks that enter the intersection from the east leg (approach), in a westbound direction of travel, and make a left turn.

ID
w_appr_truck_r
タイプ
int4
説明

Volume of trucks that enter the intersection from the west leg (approach), in a eastbound direction of travel, and make a right turn.

ID
w_appr_truck_t
タイプ
int4
説明

Volume of trucks that enter the intersection from the west leg (approach), in a eastbound direction of travel, and continue through.

ID
w_appr_truck_l
タイプ
int4
説明

Volume of trucks that enter the intersection from the west leg (approach), in a eastbound direction of travel, and make a left turn.

ID
n_appr_bus_r
タイプ
int4
説明

Volume of buses that enter the intersection from the north leg (approach), in a southbound direction of travel, and make a right turn.

ID
n_appr_bus_t
タイプ
int4
説明

Volume of buses that enter the intersection from the north leg (approach), in a southbound direction of travel, and continue through.

ID
n_appr_bus_l
タイプ
int4
説明

Volume of buses that enter the intersection from the north leg (approach), in a southbound direction of travel, and make a left turn.

ID
s_appr_bus_r
タイプ
int4
説明

Volume of buses that enter the intersection from the south leg (approach), in a northbound direction of travel, and make a right turn.

ID
s_appr_bus_t
タイプ
int4
説明

Volume of buses that enter the intersection from the south leg (approach), in a northbound direction of travel, and continue through.

ID
s_appr_bus_l
タイプ
int4
説明

Volume of buses that enter the intersection from the south leg (approach), in a northbound direction of travel, and make a left turn.

ID
e_appr_bus_r
タイプ
int4
説明

Volume of buses that enter the intersection from the east leg (approach), in a westbound direction of travel, and make a right turn.

ID
e_appr_bus_t
タイプ
int4
説明

Volume of buses that enter the intersection from the east leg (approach), in a westbound direction of travel, and continue through.

ID
e_appr_bus_l
タイプ
int4
説明

Volume of buses that enter the intersection from the east leg (approach), in a westbound direction of travel, and make a left turn.

ID
w_appr_bus_r
タイプ
int4
説明

Volume of buses that enter the intersection from the west leg (approach), in a eastbound direction of travel, and make a right turn.

ID
w_appr_bus_t
タイプ
int4
説明

Volume of buses that enter the intersection from the west leg (approach), in a eastbound direction of travel, and continue through.

ID
w_appr_bus_l
タイプ
int4
説明

Volume of buses that enter the intersection from the west leg (approach), in a eastbound direction of travel, and make a left turn.

ID
n_appr_peds
タイプ
int4
説明

Volume of pedestrians that cross the north leg (approach) of the intersection.

ID
s_appr_peds
タイプ
int4
説明

Volume of pedestrians that cross the south leg (approach) of the intersection.

ID
e_appr_peds
タイプ
int4
説明

Volume of pedestrians that cross the east leg (approach) of the intersection.

ID
w_appr_peds
タイプ
int4
説明

Volume of pedestrians that cross the west leg (approach) of the intersection.

ID
n_appr_bike
タイプ
int4
説明

Volume of bicycles that enter the intersection from the north leg (approach). NOTE: For counts conducted September 2023 and after, this includes bicycles on the road riding into the intersection from the north leg, i.e. in a southbound direction, plus bicycles riding in the crosswalk area across the west leg.

ID
s_appr_bike
タイプ
int4
説明

Volume of bicycles that enter the intersection from the north leg (approach). NOTE: For counts conducted September 2023 and after, this includes bicycles on the road riding into the intersection from the south leg, i.e. in a northbound direction, plus bicycles riding in the crosswalk area across the east leg.

ID
e_appr_bike
タイプ
int4
説明

Volume of bicycles that enter the intersection from the north leg (approach). NOTE: For counts conducted September 2023 and after, this includes bicycles on the road riding into the intersection from the east leg, i.e. in a westbound direction, plus bicycles riding in the crosswalk area across the north leg.

ID
w_appr_bike
タイプ
int4
説明

Volume of bicycles that enter the intersection from the north leg (approach). NOTE: For counts conducted September 2023 and after, this includes bicycles on the road riding into the intersection from the west leg, i.e. in a eastbound direction, plus bicycles riding in the crosswalk area across the south leg.

追加情報

フィールド
最終更新日 2025年6月30日
メタデータ最終更新日時 2026年2月20日
作成日 2025年6月30日
データ形式 CSV
ライセンス License not specified
Datastore activeTrue
Datastore cache{'CSV': '2d9d26f4-d7c3-4a07-b239-1b9ff9acd18e', 'XML': 'f0ea4230-bfee-4f7d-98eb-405599def79f', 'JSON': '21f617a0-21f7-467e-b752-0c7178ff25a8'}
Datastore cache last update8 時間前
Extract jobAirflow: Integration Pipeline traffic-volumes-at-intersections-for-all-modes
Has viewsTrue
Idce5ea7df-ee82-450e-aceb-2977ceeef66a
Is previewTrue
Package id811c4c10-7e5d-4c76-8d42-dab4e31c8265
Position3
Record count163,963
Stateactive
Url typedatastore
Extract Job Airflow: Integration Pipeline traffic-volumes-at-intersections-for-all-modes
Is Datastore Cache File?
Datastore Cache
  1. CSV
  2. XML
  3. JSON
Datastore Cache Last Updated
Datastore resource's ID