Icon for Socrata external plugin
Open repository in Console
Updated 5 hours ago
Indexed 3 hours ago

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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"cambridgema-gov/ecototem-broadway-bicycle-count-q8v9-mcfg\".\"ecototem_broadway_bicycle_count\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • ecototem_broadway_bicycle_count
Upstream Metadata