Eco-Totem Broadway Bicycle Count

The “Eco-Totem” counter (made by the Montreal-based company Eco-Counter) counts cyclists via in-ground loop detectors embedded under the pavement of Broadway near Kendall Square. The device displays on a monitor how many cyclists pass by, and data is transferred in 15 minute increments daily from the device to Cambridge's Open Data Portal. Funding for this project was generously provided by the Helen & William Mazer Foundation.

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/ecototem-broadway-bicycle-count-q8v9-mcfg\".\"ecototem_broadway_bicycle_count\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.