Transit Ridership

Total trips by mode- SamTrans, Paratransit, Caltrain, and Shuttles

http://www.samtrans.com/Assets/__Agendas+and+Minutes/SamTrans/Board+of+Directors/Presentations/2014/10-1-14+Mobility+Management+Report-End+of+Year+Review.pdf

Presentation from October 1, 2014 Board of Directors meeting, http://www.samtrans.com/about/boardofdirectors/Board_of_Directors_Calendar.html

http://www.samtrans.com/AssetFactory.aspx?did=7816

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 \"performance-smcgov/transit-ridership-e7bt-78pg\".\"transit_ridership\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.