Open repository in Console
Readme
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 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.
Upstream Metadata