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
"}
EOFSee the Splitgraph documentation
for more information.
