Bike/Pedestrian Intersection Profile 2015

Profile information for the bike and pedestrian count that took place in September, 2015.

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/bikepedestrian-intersection-profile-2015-vgnu-6aqg\".\"bikepedestrian_intersection_profile_2015\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.