Icon for Socrata external plugin
Open repository in Console
Updated over 9 years ago
Indexed 2 hours ago

Colorado's Highway Conditions Grade

CDOT gives a letter grade to overall roadway condition. It is a combination of the percent of highway pavement determined to have high or moderate Drivability Life and the level of service (LOS) delivered by CDOT’s maintenance program. The Department in 2013 changed its way of evaluating pavement condition. Grades for previous years are not directly comparable.

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 \"colorado-gov/colorados-highway-conditions-grade-vk5i-uf67\".\"colorados_highway_conditions_grade\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • colorados_highway_conditions_grade