Site Specific Summary Bike Pedestrian Count 2016

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

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/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.