About this Dataset

Dynamic Message Signs (DMS)

This dataset contains information on the handful of dynamic message signs (DMS) deployed across the City of Austin. The data is updated every hour and is maintained by the Arterial Management Division of the City of Austin Transportation and Public Works Department.

We do not retain any historical data pertaining to these assets. The asset updates once an hour and the messaging may change more than once during that window. Should connectivity issues occur, the signs may still display old messages that differ from the ones reflected in this dataset.

This dataset is currently under active development and is subject to change at any time. Please note that it may contain incomplete or inaccurate information.

For Austin area dynamic messages signs maintained by Texas Department of Transportation (TxDOT), see https://its.txdot.gov/its/District/AUS/dms-messages
Organization: City of Austin
Last updated: 2020-11-12T13:21:44.972883
Tags: amd, arterial-management, division, dms, dynamic-message-sign, public-works, safety, signs, tpw, transportation

Tables

Table 1

@usgov.city_of_austin_dynamic_message_signs_dms.table_1

12.93 kB
20 rows
15 columns

CREATE TABLE table_1 (
  "atd_location_id" VARCHAR,
  "dms_id" BIGINT,
  "dms_direction" VARCHAR,
  "turn_on_date" VARCHAR,
  "dms_status" VARCHAR,
  "comment" VARCHAR,
  "modified_date" TIMESTAMP,
  "created_date" TIMESTAMP,
  "dms_message" VARCHAR,
  "message_time" VARCHAR,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "location_name" VARCHAR,
  "id" VARCHAR,
  "location" VARCHAR
);