Open repository in Console
Readme
Updated over 9 years ago
‧ Indexed 42 minutes ago
CDOT Maintenance Report
CDOT measures the overall performance of its maintenance program by assigning letter grades to nine program areas, such as Snow and Ice Removal, Roadway Striping, Sign and Signal Maintenance, and Rest Area Maintenance. The overall grade for maintenance reflects the performance of all nine areas.
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/cdot-maintenance-report-mh72-9v9v\".\"cdot_maintenance_report\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.