About this Dataset

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.
Organization: City of Austin
Last updated: 2021-11-29T08:52:44.118903
Tags: communications, traffic-signals, transportation

Tables

Table 1

@usgov.city_of_austin_traffic_signal_network_device_status_log.table_1

59.48 MB
4001348 rows
11 columns


CREATE TABLE table_1 (
  "record_id" VARCHAR,
  "device_id" BIGINT,
  "device_database_id" VARCHAR,
  "device_type" VARCHAR,
  "location_id" VARCHAR,
  "location_name" VARCHAR,
  "signal_id" DOUBLE,
  "timestamp" VARCHAR,
  "status_code" BIGINT,
  "status_description" VARCHAR,
  "delay" DOUBLE
);