Recent Transit On-Time Performance Data
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, for the most recent month.
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/recent-transit-ontime-performance-data-gp3k-am4u\".\"recent_transit_ontime_performance_data\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.