Bike and Pedestrian Count 2015

Counts of bike and pedestrian road use at locations around San Mateo County.

Bike and pedestrian count data from 2016 can be found in two other datasets:

Summary Bike and Pedestrian Count 2016

https://data.smcgov.org/Transportation/Summary-Bike-and-Pedestrian-Count-2016/5cs5-z733

Site Specific Summary Bike Pedestrian Count 2016

https://data.smcgov.org/Transportation/Site-Specific-Summary-Bike-Pedestrian-Count-2016/mf7e-384t

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 \"datahub-smcgov/bike-and-pedestrian-count-2015-qhc8-m593\".\"bike_and_pedestrian_count_2015\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.