Readme
Updated 1 day ago
‧ Indexed 3 hours ago
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.
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| Record ID | id | id | Text | The unique ID of this row. Created as a concat of the device ID, the device type, and the epoch timestamp of the record's created date |
| Device ID | device_id | device_id | Number | The unique identifier of this device asset amongst all devices of this type |
| Status Code | status_code | status_code | Number | A numeric code indicating the status of the device. 1 (online), -1 (timeout), -2 (invalid_hostname), -3 (unknown_error) |
| Delay | delay | delay | Number | The communication response time in milliseconds |
| Timestamp | timestamp | timestamp | Calendar date | The timestamp (in UTC) of the device's communications status |
| Location Name | location_name | location_name | Text | The location's name |
| Location ID | location_id | location_id | Text | The device's location identifier |
| Device Database ID | knack_id | knack_id | Text | The globally unique ID which uniquely identifies this device asset in the source database |
| Status Description | status_desc | status_desc | Text | A description of the comm status |
| Device Type | device_type | device_type | Text | The type of device |
| Signal ID | signal_id | signal_id | Number | The ID of the traffic signal at which the device is located |
Upstream Metadata