Park Attendance

Average visitors per month to San Mateo County parks July 2013 - June 2014. Park attendance information is collected by park rangers on a daily basis and then aggregated to a monthly average.

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 \"performance-smcgov/park-attendance-625x-uh93\".\"park_attendance\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.