calgary-ca/calgary-transit-fleet-list-ekzc-4ss8
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 2 months ago
Indexed 1 month ago

Calgary Transit Fleet List

Calgary Transit’s fleet (buses and CTrains), updated weekly.

Data includes vehicle number, garage location, vehicle type (Community Shuttle, standard bus, articulated bus, CTrain), vehicle model and how the vehicle facilitates a bicycle (bike rack, or front/back door)

*Note: Bikes are not allowed on CTrains during peak hours (6.30am to 9am and 3pm to 6pm)

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/calgary-transit-fleet-list-ekzc-4ss8\".\"calgary_transit_fleet_list\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • calgary_transit_fleet_list
     
     
     
     
     
Upstream Metadata