Fresh Pond Reservation Usership

The Water Department manages several "people counter" sensors at Fresh Pond Reservation (FPR). The sensors count visitors on the Perimeter Road, the main trail at FPR that circles Fresh Pond. Counters are also located at popular entrances to FPR. Some of the counters record both cyclists and pedestrians. However, most do not differentiate between user types.

The sensors report user counts in 15-minute intervals. This dataset contains hourly aggregations of the 15-minute data. All counts include people moving in both directions past the sensors. The sensors are made by the company Eco-Counter.

The Water Department’s Watershed Division manages Fresh Pond Reservation (FPR). Our primary goals are to preserve drinking water quality, recreational open spaces, natural green spaces, wildlife habitat, and provide a refuge from hectic urban life.

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 \"cambridgema-gov/fresh-pond-reservation-usership-6xy8-cstb\".\"fresh_pond_reservation_usership\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.