Traffic Signal Network Device Status Log

The Austin Transportation Department manages thousands of IP-enabled devices which enable traffic signal operations. Devices include traffic cameras, battery backup systems, signal controllers, and vehicle detectors.

This dataset, updated daily, serves as a log of attempts to communicate with the various various devices on the traffic signals network.

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 \"datahub-austintexas-gov/traffic-signal-network-device-status-log-pj7k-98z2\".\"traffic_signal_network_device_status_log\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.