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.