cambridgema-gov/traffic-speed-studies-historical-k7qr-u489
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 1 month ago
Indexed 2 hours ago

Traffic Speed Studies (Historical)

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-historical-k7qr-u489\".\"traffic_speed_studies_historical\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • traffic_speed_studies_historical
     
     
     
     
     
Upstream Metadata