AB617 "Path to Clean Air" - Bus Routes

Source URL:https://www.actransit.org/data-api-resource-center

Where dataset is from: AC Transit, Golden Gate Bus Service (digitized by BAAQMD), Westcat Bus Service (digitized by BAAQMD)

When obtained: 1/13/2022

For what purpose it was obtained: General AB 617 Planning

Additional Information: AC Transit work is licensed under a Creative Commons Attribution 3.0 Unported License

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 \"bayareametro-gov/ab617-path-to-clean-air-bus-routes-mv7a-yd2h\".\"ab617_path_to_clean_air_bus_routes\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.