Summary data from a bike and pedestrian count done in September, 2016.
Bike and pedestrian count data from 2015 can be found in two other datasets:
Bike and Pedestrian Count 2015
https://data.smcgov.org/Transportation/Bike-and-Pedestrian-Count-2015/qhc8-m593
Bike/Pedestrian Intersection Profile 2015
https://data.smcgov.org/Transportation/Bike-Pedestrian-Intersection-Profile-2015/vgnu-6aqg
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/summary-bike-and-pedestrian-count-2016-5cs5-z733\".\"summary_bike_and_pedestrian_count_2016\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.
