Transit Incident Log
Captures incidents at timepoints to determine On Time Performance (OTP). This file was made available to facilitate the 2019 CUTA conference hackathon, and therefore may not be updated.
Bus departed early (>1 minute before schedule)
Bus departed late (>5 minutes after schedule)
Bus departed on schedule (<=1 minute before schedule and <=5 minutes after schedule)
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on
this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \
-H "Content-Type: application/json" \
-d@-<<EOF
{"sql": "
SELECT *
FROM \"calgary-ca/transit-incident-log-9m8z-ibsn\".\"transit_incident_log\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
