tmc_raw_data_2000_2009
Opis skupa podataka:
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....
Izvor: Traffic Volumes - Multimodal Intersection Turning Movement Counts
Rječnik podataka
- ID
- count_id
- Vrsta
- int4
- Opis
Unique identifier for each count. Join to tmc_summary_data or tmc_most_recent_summary_data for rollup statistics.
- ID
- count_date
- Vrsta
- date
- Opis
Date the count was conducted. For Turning Movement Counts, studies are conducted on one day only.
- ID
- location_name
- Vrsta
- text
- Opis
Human-readable name of the location where the count was conducted (e.g. Bloor Street / Yonge Street)
- ID
- longitude
- Vrsta
- float8
- Opis
Longitude GPS coordinate
- ID
- latitude
- Vrsta
- float8
- Opis
Latitude GPS coordinate
- ID
- centreline_type
- Vrsta
- text
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- timestamp
- Opis
Start time of the 15-minute interval
- ID
- end_time
- Vrsta
- timestamp
- Opis
End time of the 15-minute interval
- ID
- n_appr_cars_r
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
Volume of pedestrians that cross the north leg (approach) of the intersection.
- ID
- s_appr_peds
- Vrsta
- int4
- Opis
Volume of pedestrians that cross the south leg (approach) of the intersection.
- ID
- e_appr_peds
- Vrsta
- int4
- Opis
Volume of pedestrians that cross the east leg (approach) of the intersection.
- ID
- w_appr_peds
- Vrsta
- int4
- Opis
Volume of pedestrians that cross the west leg (approach) of the intersection.
- ID
- n_appr_bike
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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
- Vrsta
- int4
- Opis
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.
Dodatne informacije
| Polje | Vrijednost |
|---|---|
| Zadnje ažuriranje podataka | 30. juni 2025. |
| Zadnje ažuriranje meta podataka | 20. februar 2026. |
| Kreirano | 30. juni 2025. |
| Format | CSV |
| Licenca | 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 | prije 20 sati |
| 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 |