Icon for Socrata external plugin
Updated 6 hours ago
Indexed 14 minutes ago

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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"citydata-mesaaz-gov/class-a-signal-preventive-maintenance-46nc-ukaa\".\"class_a_signal_preventive_maintenance\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • class_a_signal_preventive_maintenance
Upstream Metadata