Travel Delays In Congested Highway Segments

Congestion measurements are defined by travel-time delay, which is the difference between the travel time on highways at the free flow speed and the time spent in current traffic. In 2012, the average travel-time delay on all congested corridors was 17.2 minutes per traveler, per day. A highway is considered congested when the peak traffic volume is 85 percent or greater than what the highway was designed to sustain.

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 \"colorado-gov/travel-delays-in-congested-highway-segments-7vr4-tk3z\".\"travel_delays_in_congested_highway_segments\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.