Performance Metrics - Transportation - Traffic Lights Out

The Chicago Department of Transportation (CDOT) receives reports from 311’s Customer Service Requests (CSR) system of traffic light outages. This metric tracks the average number of days CDOT takes to complete traffic light repair requests. Total number of requests fulfilled per week is also available by mousing over columns Due to the public safety importance of traffic signals, the target time to respond to traffic light outages is within 1 day.

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 \"cityofchicago/performance-metrics-transportation-traffic-lights-vfmv-4fbs\".\"performance_metrics_transportation_traffic_lights\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.