Data Dictionary

Column Type Label Description
count_id int4

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

count_date date

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

location_name text

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

longitude float8

Longitude GPS coordinate

latitude float8

Latitude GPS coordinate

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/).

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.

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/).

start_time timestamp

Start time of the 15-minute interval

end_time timestamp

End time of the 15-minute interval

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

n_appr_peds int4

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

s_appr_peds int4

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

e_appr_peds int4

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

w_appr_peds int4

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

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.

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.

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.

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.

Additional Information

Field Value
Data last updated January 30, 2025
Metadata last updated May 9, 2025
Created January 30, 2025
Format CSV
License License not specified
Datastore activeTrue
Datastore cache{'CSV': '8c4601a5-f76d-4e59-8b32-7ea2b4c4e324', 'XML': '17e6505c-3ed6-44e1-b457-c42f5aa3c330', 'JSON': 'a301f331-f2e4-4bd4-9857-a149a5c55f13'}
Datastore cache last update4 minutes ago
Extract jobAirflow: Integration Pipeline traffic-volumes-at-intersections-for-all-modes
Has viewsTrue
Idf18d78f9-7d09-44b1-9f04-b856c05e86a8
Is previewTrue
Mimetypetext/csv
Package idtraffic-volumes-at-intersections-for-all-modes
Position25
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