Traffic Signal Audits

This dataset describes planned and completed traffic signal audits across the City of Mesa managed transportation system. A traffic signal audit is a formal examination of the number of signalized intersections maintained by the City of Mesa. They are checked for proper programming and operation on a quarterly basis by a formal internal team. The data recorded includes the date by which each intersection needed to be audited, as well as the date the audit was completed.

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 \"citydata-mesaaz-gov/traffic-signal-audits-98rh-32pr\".\"traffic_signal_audits\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.