Performance Metrics - Transportation - Stop Sign Out

Due to vehicular accidents, theft and normal wear and tear, City stop signs occasionally need to be replaced or repaired. The Department of Transportation (CDOT) responds to damaged or missing stop signs reported through 311’s Customer Service Requests (CSR) system on a case-by-case basis. Total number of requests fulfilled per week is also available by mousing over columns. Due to the public safety importance of stop signs, the target time to respond to stop sign requests is within 1 day. To report a missing or damaged stop sign, call 311 or see http://www.cityofchicago.org/city/en/depts/cdot/provdrs/signs_and_pavementmarkings/svcs/stop_sign.html

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-stop-sign-out-hybd-quwr\".\"performance_metrics_transportation_stop_sign_out\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.