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 30 January 2025
Metadata last updated 6 May 2025
Created 30 January 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 update1 month 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