Data Dictionary

ID
location_dir_id
Typ
text
Beskrivning

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

ID
location_name
Typ
text
Beskrivning

Short description of sensor location.

ID
direction
Typ
text
Beskrivning

Closest cardinal direction of bike flow.

ID
linear_name_full
Typ
text
Beskrivning

Linear name full from Toronto Centreline (TCL)

ID
side_street
Typ
text
Beskrivning

Nearest side street to sensor flow.

ID
longitude
Typ
float8
Beskrivning

Approximate longitude of sensor.

ID
latitude
Typ
float8
Beskrivning

Approximate latitude of sensor.

ID
centreline_id
Typ
int4
Beskrivning

centreline_id corresponding to Toronto Centreline (TCL)

ID
bin_size
Typ
text
Beskrivning

Size of smallest datetime bin recorded by sensor.

ID
latest_calibration_study
Typ
date
Beskrivning

Date of latest calibration study.

ID
first_active
Typ
date
Beskrivning

The earliest date the sensor produced data.

ID
last_active
Typ
date
Beskrivning

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

ID
date_decommissioned
Typ
date
Beskrivning

Date decommissioned.

ID
technology
Typ
text
Beskrivning

Technology of permanent sensor.

Mer information

Fält Värde
Data senast uppdaterad 30 juni 2025
Metadata senast uppdaterad 12 maj 2026
Skapad 30 juni 2025
Format CSV
Licens 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 updateför 3 veckor sedan
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