tmc_raw_data_2000_2009
Descrición do conxunto de datos:
The City of Toronto's Transportation Services Division collects short-term traffic count data across the City on an ad-hoc basis to support a variety of safety initiatives and projects....
Fonte: Traffic Volumes - Multimodal Intersection Turning Movement Counts
Dicionario de datos
- ID
- count_id
- Tipo
- int4
- Descrición
Unique identifier for each count. Join to tmc_summary_data or tmc_most_recent_summary_data for rollup statistics.
- ID
- count_date
- Tipo
- date
- Descrición
Date the count was conducted. For Turning Movement Counts, studies are conducted on one day only.
- ID
- location_name
- Tipo
- text
- Descrición
Human-readable name of the location where the count was conducted (e.g. Bloor Street / Yonge Street)
- ID
- longitude
- Tipo
- float8
- Descrición
Longitude GPS coordinate
- ID
- latitude
- Tipo
- float8
- Descrición
Latitude GPS coordinate
- ID
- centreline_type
- Tipo
- text
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- timestamp
- Descrición
Start time of the 15-minute interval
- ID
- end_time
- Tipo
- timestamp
- Descrición
End time of the 15-minute interval
- ID
- n_appr_cars_r
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
Volume of pedestrians that cross the north leg (approach) of the intersection.
- ID
- s_appr_peds
- Tipo
- int4
- Descrición
Volume of pedestrians that cross the south leg (approach) of the intersection.
- ID
- e_appr_peds
- Tipo
- int4
- Descrición
Volume of pedestrians that cross the east leg (approach) of the intersection.
- ID
- w_appr_peds
- Tipo
- int4
- Descrición
Volume of pedestrians that cross the west leg (approach) of the intersection.
- ID
- n_appr_bike
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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
- Tipo
- int4
- Descrición
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.
Información adicional
| Campo | Valor |
|---|---|
| Última actualización de datos | 30 de xuño de 2025 |
| Última actualización de metadatos | 20 de febreiro de 2026 |
| Creado | 30 de xuño de 2025 |
| Formato | CSV |
| Licenza | License not specified |
| Datastore active | True |
| Datastore cache | {'CSV': 'c3f12672-cd7e-41ec-ae77-79a363183009', 'XML': 'b675c3e8-2596-438f-b7d2-b4e128e61306', 'JSON': 'b5bf0638-2bdf-495c-b35f-759a9b6c8b70'} |
| Datastore cache last update | hai 12 horas |
| Extract job | Airflow: Integration Pipeline traffic-volumes-at-intersections-for-all-modes |
| Has views | True |
| Id | 01aee77d-6c1a-4836-8fe7-b66d93b70ebb |
| Is preview | True |
| Package id | 811c4c10-7e5d-4c76-8d42-dab4e31c8265 |
| Position | 4 |
| Record count | 257.816 |
| State | active |
| Url type | datastore |
| Extract Job | Airflow: Integration Pipeline traffic-volumes-at-intersections-for-all-modes |
| Is Datastore Cache File? | |
| Datastore Cache |
|
| Datastore Cache Last Updated | |
| Datastore resource's ID |