Transit On-Time Performance Data Archive

Every Winnipeg Transit bus is equipped with an on-board computer and GPS that logs whether or not it is on time as it leaves a bus stop.

This raw data is available for download, showing the scheduled departure time from each bus stop, as well as the deviation (+/- in seconds; negative indicates late, and positive indicates early) from this scheduled departure time.

Data is collected from buses on a daily basis. However, due to transmission problems and data issues, a small percentage of bus data may be missing from Winnipeg Transit’s data set. As well, due to GPS and other errors, a small percentage of bus data may contain erroneous data. This data set contains the data as it is reported by the on-board computer.

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 \"winnipeg-ca/transit-ontime-performance-data-archive-cymk-nyei\".\"transit_ontime_performance_data_archive\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.