Data Dictionary

ID
location_dir_id
Type
text
Description

Unique ID for location and direction for joining to data tables.

ID
location_name
Type
text
Description

Short description of sensor location.

ID
direction
Type
text
Description

Closest cardinal direction of bike flow.

ID
linear_name_full
Type
text
Description

Linear name full from Toronto Centreline (TCL)

ID
side_street
Type
text
Description

Nearest side street to sensor flow.

ID
longitude
Type
float8
Description

Approximate longitude of sensor.

ID
latitude
Type
float8
Description

Approximate latitude of sensor.

ID
centreline_id
Type
int4
Description

centreline_id corresponding to Toronto Centreline (TCL)

ID
bin_size
Type
text
Description

Size of smallest datetime bin recorded by sensor.

ID
latest_calibration_study
Type
date
Description

Date of latest calibration study.

ID
first_active
Type
date
Description

The earliest date the sensor produced data.

ID
last_active
Type
date
Description

The most recent date of available data produced by the sensor.

ID
date_decommissioned
Type
date
Description

Date decommissioned.

ID
technology
Type
text
Description

Technology of permanent sensor.

Additional Information

Field Value
Data last updated 30 June 2025
Metadata last updated 7 July 2026
Created 30 June 2025
Format CSV
License License not specified
Datastore activeTrue
Datastore cache{'CSV': '217a6e7f-c980-46ab-ba06-6d10b5499194', 'XML': '0a9ff532-4fda-4470-9376-8294435a2bf9', 'JSON': '9df3125d-51ae-4910-85e1-caba4bdb0128'}
Datastore cache last update5 days ago
Extract jobAirflow: Integration Pipeline permanent-bicycle-counters
Has viewsTrue
Id3de6bec4-221c-4f9e-aebc-780b6841e55c
Is previewTrue
Package idff7e7369-cbba-4545-9e26-e5a5ef6a123c
Position0
Record count43
Stateactive
Url typedatastore
Extract Job Airflow: Integration Pipeline permanent-bicycle-counters
Is Datastore Cache File?
Datastore Cache
  1. CSV
  2. XML
  3. JSON
Datastore Cache Last Updated
Datastore resource's ID