Data Dictionary

Column Type Label Description
latest_count_id int4

Unique identifier for each Turning Movement Count. Use this ID to cross-reference 15-minute observations in tmc_raw_data files.

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

count_duration text

Duration of count (14, 8R, 8S). 14 = 14-hours of data collected over a continuous period from 6:00am-8:00pm. 8R = 8-hours of data collected during the non-continuous Routine schedule of 7:30 - 9:30 / 10:00 - 12:00 / 13:00 - 15:00 / 16:00 - 18:00. 8S = 8-hours of data collected during the non-continuous School schedule of 7:30 - 9:30 / 10:00 - 11:00 / 12:00 - 13:30 / 14:15 - 15:45 / 16:00 - 18:00

total_vehicle int4

Total motor vehicle volume over the count duration. Motor vehicles include cars, trucks, and buses.

total_bike int4

Total bicycle volume over the count duration

total_heavy_pct float8

Percentage of motor vehicle volume considered heavy vehicles (truck/bus), over the count duration

total_pedestrian int4

Total pedestrian volume crossing any leg of the intersection, over the count duration NOTE: Pedestrians are counted once for each leg of the intersection they cross. For example, if a pedestrian crosses the north leg, then the east leg, they are counted once crossing the north leg, and once crossing the east leg.

am_peak_start timestamp

Start of the AM Peak hour. The AM Peak hour is the continuous one-hour period between 6:30-10:30AM during which the total number of motor vehicles (cars, trucks, buses) that enter the intersection is the greatest.

am_peak_vehicle int4

Volume of motor vehicles observed during the AM peak hour

am_peak_bike int4

Volume of bicycles observed during the AM peak hour

am_peak_heavy_pct float8

Percentage of motor vehicle volume considered heavy vehicles (truck/bus), during the AM peak hour

pm_peak_start timestamp

Start of the PM Peak hour. The PM Peak hour is the continuous one-hour period between 2:00-8:00PM during which the total number of motor vehicles (cars, trucks, buses) that enter the intersection is the greatest.

pm_peak_vehicle int4

Volume of motor vehicles observed during the PM peak hour

pm_peak_bike int4

Volume of bicycles observed during the PM peak hour

pm_peak_heavy_pct float8

Percentage of motor vehicle volume considered heavy vehicles (truck/bus), during the PM peak hour

n_appr_vehicle int4

Volume of motor vehicles that enter the intersection from the north leg (approach), over the count duration

n_appr_bike int4

Volume of bicycles that enter the intersection from the north leg (approach), over the count duration NOTE: For counts conducted September 2023 and after, this includes bicycles on the road riding into the intersection from the north leg, plus bicycles riding in the crosswalk area across the west leg

n_appr_heavy_pct float8

Percentage of motor vehicle volume considered heavy vehicles (truck/bus), that enter the intersection from the north leg (approach), over the count duration

e_appr_vehicle int4

Volume of vehicles that enter the intersection from the east leg (approach), over the count duration

e_appr_bike int4

Volume of bicycles that enter the intersection from the east leg (approach), over the count duration NOTE: For counts conducted September 2023 and after, this includes bicycles on the road riding into the intersection from the east leg, plus bicycles riding in the crosswalk area across the north leg

e_appr_heavy_pct float8

Percentage of motor vehicle volume considered heavy vehicles (truck/bus), that enter the intersection from the east leg (approach), over the count duration

s_appr_vehicle int4

Volume of vehicles that enter the intersection from the south leg (approach), over the count duration

s_appr_bike int4

Volume of bicycles that enter the intersection from the south leg (approach), over the count duration NOTE: For counts conducted September 2023 and after, this includes bicycles on the road riding into the intersection from the south leg, plus bicycles riding in the crosswalk area across the east leg

s_appr_heavy_pct float8

Percentage of motor vehicle volume considered heavy vehicles (truck/bus), that enter the intersection from the south leg (approach), over the count duration

w_appr_vehicle int4

Volume of vehicles that enter the intersection from the west leg (approach), over the count duration

w_appr_bike int4

Volume of bicycles that enter the intersection from the west leg (approach), over the count duration NOTE: For counts conducted September 2023 and after, this includes bicycles on the road riding into the intersection from the west leg, plus bicycles riding in the crosswalk area across the south leg

w_appr_heavy_pct float8

Percentage of motor vehicle volume considered heavy vehicles (truck/bus), that enter the intersection from the west leg (approach), over the count duration

Additional Information

Field Value
Data last updated January 30, 2025
Metadata last updated May 8, 2025
Created January 30, 2025
Format CSV
License License not specified
Datastore activeTrue
Datastore cache{'CSV': '8b475b9b-5509-40cc-bb6d-aca3c194384f', 'XML': 'd2938927-e0be-4295-ad85-5cb34e1eb992', 'JSON': '6c119269-d1ef-4347-bcc9-4718648817d3'}
Datastore cache last update17 hours ago
Extract jobAirflow: Integration Pipeline traffic-volumes-at-intersections-for-all-modes
Has viewsTrue
Id3dcaff21-164c-4cb9-aa6d-7e7bcf044449
Is previewTrue
Mimetypetext/csv
Package idtraffic-volumes-at-intersections-for-all-modes
Position21
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