winnipeg-ca/recent-transit-ontime-performance-data-gp3k-am4u
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 1 month ago
Indexed 1 month ago

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.

 
Preview
  • recent_transit_ontime_performance_data
     
     
     
     
     
Upstream Metadata