About this Dataset

Dynamic Message Signs

Displays dynamic message signs maintained by the Seattle Department of Transportation.

Views: Link, which adds the recommended filter for general use of the dataset: 'CURRENT_STATUS = 'INSVC''

Refresh Cycle: Daily

Feature Class: SDOT.V_DMS
Organization: City of Seattle
Last updated: 2025-02-28T23:44:17.493042
Tags: common-data-layers, dynamic-message-signs, sdot, seattle-gis-open-data, transportation

Tables

Table 1

@usgov.city_of_seattle_dynamic_message_signs_eec98.table_1

46.68 KB
116 rows
46 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "compkey" BIGINT,
  "comptype" BIGINT,
  "segkey" BIGINT,
  "elmntkey" BIGINT,
  "distance" DOUBLE,
  "width" DOUBLE,
  "unitid" VARCHAR,
  "unittype" VARCHAR,
  "unitdesc" VARCHAR,
  "ownership" VARCHAR,
  "condition" VARCHAR,
  "condition_assessment_date" VARCHAR,
  "current_status" VARCHAR,
  "side" VARCHAR,
  "current_status_date" VARCHAR,
  "category" VARCHAR,
  "manufacturer" VARCHAR,
  "install_date" VARCHAR,
  "installercd" VARCHAR,
  "support" VARCHAR,
  "supportdescr" VARCHAR,
  "electr_wire_loc" VARCHAR,
  "protocol_loc" VARCHAR,
  "warranty_end_date" VARCHAR,
  "mount" VARCHAR,
  "cntrl_housing_loc" VARCHAR,
  "aux_housing_loc" VARCHAR,
  "control_model" VARCHAR,
  "air_filter" VARCHAR,
  "lpr_function" VARCHAR,
  "wireless_comm_type" VARCHAR,
  "comments" VARCHAR,
  "pos1_panc_disc_dirfac1" VARCHAR,
  "pos2_panc_disc_dirfac1" VARCHAR,
  "pos3_panc_disc_dirfac1" VARCHAR,
  "pos4_panc_disc_dirfac1" VARCHAR,
  "pos5_panc_disc_dirfac1" VARCHAR,
  "pos6_panc_disc_dirfac1" VARCHAR,
  "primarydistrictcd" VARCHAR,
  "secondarydistrictcd" VARCHAR,
  "overrideyn" VARCHAR,
  "overridecomment" DOUBLE,
  "serno" DOUBLE,
  "x" DOUBLE,
  "y" DOUBLE
);