Data from specific locations where bike and pedestrian counts were completed 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/site-specific-summary-bike-pedestrian-count-2016-mf7e-384t\".\"site_specific_summary_bike_pedestrian_count_2016\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.
