Traffic Speed Studies
The Traffic, Parking &Transportation department has conducted over 600 speed studies since 1987. Some locations have been studied more than once. The speed of each passing vehicle is recorded by radar for an hour each in the morning rush hour, evening rush hour, and midday. From these results, we find the 85th percentile speed for each one-hour period. The 85th percentile speed describes a speed that 85% of drivers are traveling slower than (and 15% of people are driving faster than). Traffic engineers use 85th percentile speed for most traffic safety analyses and design standards. In this dataset, the speed reported is the highest 85th percentile speed for all three one-hour periods studied.
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/traffic-speed-studies-k7qr-u489\".\"traffic_speed_studies\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.