Data Dictionary

Column Type Label Description
location_dir_id text

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

location_name text

Short description of sensor location.

direction text

Closest cardinal direction of bike flow.

linear_name_full text

Linear name full from Toronto Centreline (TCL)

side_street text

Nearest side street to sensor flow.

longitude float8

Approximate longitude of sensor.

latitude float8

Approximate latitude of sensor.

centreline_id int4

centreline_id corresponding to Toronto Centreline (TCL)

bin_size text

Size of smallest datetime bin recorded by sensor.

latest_calibration_study date

Date of latest calibration study.

first_active date

The earliest date the sensor produced data.

last_active date

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

date_decommissioned date

Date decommissioned.

technology text

Technology of permanent sensor.

Additional Information

Field Value
Data last updated January 30, 2025
Metadata last updated May 6, 2025
Created January 30, 2025
Format CSV
License License not specified
Datastore activeTrue
Datastore cache{'CSV': 'e0c3c33b-a779-4f4f-8e42-354b7b220a76', 'XML': 'a05731e1-e66f-4f1b-8d8e-be56057691b3', 'JSON': '50bba0d7-ba7d-4265-b25b-11402c5e5c4b'}
Datastore cache last update4 days ago
Extract jobAirflow: Integration Pipeline permanent-bicycle-counters
Has viewsTrue
Idcb97300f-dbc8-4c35-8e54-38968f2a7b20
Is previewTrue
Mimetypetext/csv
Package idpermanent-bicycle-counters
Position0
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