colorado-gov/colorado-snow-ice-control-8862-9ctg
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated over 9 years ago
Indexed 1 month 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 https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"colorado-gov/colorado-snow-ice-control-8862-9ctg\".\"colorado_snow_ice_control\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • colorado_snow_ice_control