Class A Signal Preventive Maintenance

This is a record of every Class A performed at signalized intersections maintained by the City of Mesa. Class A traffic signal maintenance is defined as the preventive and responsive activities to preserve traffic signal infrastructure and control devices necessary for the safe and efficient utilization of arterial, collector, and local roadways. This includes doing an AC/DC voltage check, cleaning the cabinet, checking the controller and monitor programming and operation, checking pedestrian and vehicle detection operation, checking for signal indication outages, checking equipment inventory, checking communications to the traffic management center, and checking wiring

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/class-a-signal-preventive-maintenance-46nc-ukaa\".\"class_a_signal_preventive_maintenance\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.