Icon for Socrata external plugin
Open repository in Console
Updated over 9 years ago
Indexed 27 minutes ago

Colorado Snow Ice Control

CDOT’s maintenance program establishes a target letter grade it expects to achieve for snow and ice control each year. During the winter, CDOT maintenance workers complete surveys to grade their performance using established criteria based on the year’s budget. Higher grades are typically achieved during lower-cost, milder winters.

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/colorado-snow-ice-control-8862-9ctg\".\"colorado_snow_ice_control\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • colorado_snow_ice_control