Data Dictionary

ID
count_id
Type
int4
Aprašymas

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

ID
count_date
Type
date
Aprašymas

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

ID
location_name
Type
text
Aprašymas

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

ID
longitude
Type
float8
Aprašymas

Longitude GPS coordinate

ID
latitude
Type
float8
Aprašymas

Latitude GPS coordinate

ID
centreline_type
Type
text
Aprašymas

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
Type
int4
Aprašymas

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
Type
int4
Aprašymas

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
count_duration
Type
text
Aprašymas

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

ID
total_vehicle
Type
int4
Aprašymas

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

ID
total_bike
Type
int4
Aprašymas

Total bicycle volume over the count duration

ID
total_heavy_pct
Type
float8
Aprašymas

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

ID
total_pedestrian
Type
int4
Aprašymas

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.

ID
am_peak_start
Type
timestamp
Aprašymas

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.

ID
am_peak_vehicle
Type
int4
Aprašymas

Volume of motor vehicles observed during the AM peak hour

ID
am_peak_bike
Type
int4
Aprašymas

Volume of bicycles observed during the AM peak hour

ID
am_peak_heavy_pct
Type
float8
Aprašymas

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

ID
pm_peak_start
Type
timestamp
Aprašymas

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.

ID
pm_peak_vehicle
Type
int4
Aprašymas

Volume of motor vehicles observed during the PM peak hour

ID
pm_peak_bike
Type
int4
Aprašymas

Volume of bicycles observed during the PM peak hour

ID
pm_peak_heavy_pct
Type
float8
Aprašymas

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

ID
n_appr_vehicle
Type
int4
Aprašymas

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

ID
n_appr_bike
Type
int4
Aprašymas

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

ID
n_appr_heavy_pct
Type
float8
Aprašymas

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

ID
e_appr_vehicle
Type
int4
Aprašymas

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

ID
e_appr_bike
Type
int4
Aprašymas

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

ID
e_appr_heavy_pct
Type
float8
Aprašymas

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

ID
s_appr_vehicle
Type
int4
Aprašymas

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

ID
s_appr_bike
Type
int4
Aprašymas

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

ID
s_appr_heavy_pct
Type
float8
Aprašymas

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

ID
w_appr_vehicle
Type
int4
Aprašymas

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

ID
w_appr_bike
Type
int4
Aprašymas

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

ID
w_appr_heavy_pct
Type
float8
Aprašymas

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

Papildoma informacija

Laukas Reikšmė
Data last updated 2025 m. birželio 30 d.
Metadata last updated 2026 m. vasario 20 d.
Sukurtas 2025 m. birželio 30 d.
Formatas CSV
Licencija License not specified
Datastore activeTrue
Datastore cache{'CSV': 'b7ff9375-e215-408f-80a5-ec9e55246e19', 'XML': '4e677b51-a337-4d37-8dca-8cde9ea81243', 'JSON': '0762c46e-eef6-4630-94f3-350867beeb66'}
Datastore cache last updateprieš 2 valandas
Extract jobAirflow: Integration Pipeline traffic-volumes-at-intersections-for-all-modes
Has viewsTrue
Id1364bffa-29a3-4c39-af8a-925d8ca7bf1f
Is previewTrue
Package id811c4c10-7e5d-4c76-8d42-dab4e31c8265
Position1
Record count31 189
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