About this Dataset

SDOT Street Signs

Displays the locations and attributes of SDOT street signs on block faces throughout the City by sign category.

Refresh Cycle: Daily Refresh

Feature Class: V_SIGNS

Street Sign Definition Query:

To view the INSVC, or PLNRECON, or ' ' status, use

CURRENT_STATUS = 'INSVC' OR CURRENT_STATUS ='PLNRECON' OR CURRENT_STATUS = ' '
Organization: City of Seattle
Last updated: 2025-02-28T23:26:37.872754
Tags: sdot, seattle-gis-open-data, sign, street, transportation

Tables

Table 1

@usgov.city_of_seattle_sdot_street_signs.table_1

29.48 MB
213,724 rows
45 columns

CREATE TABLE table_1 (
  "n__objectid" VARCHAR  -- OBJECTID,
  "compkey" VARCHAR,
  "comptype" VARCHAR,
  "segkey" VARCHAR,
  "intkey" DOUBLE,
  "elmntkey" VARCHAR,
  "distance" VARCHAR,
  "width" VARCHAR,
  "unitid" VARCHAR,
  "unittype" VARCHAR,
  "signtype" VARCHAR,
  "category" VARCHAR,
  "categorydescr" VARCHAR,
  "unitdesc" VARCHAR,
  "facing" VARCHAR,
  "supportkey" DOUBLE,
  "supportid" VARCHAR,
  "support" VARCHAR,
  "supportdescr" VARCHAR,
  "color1" VARCHAR,
  "signsz" VARCHAR,
  "reflectiveyn" VARCHAR,
  "fieldnotes" VARCHAR,
  "custom" VARCHAR,
  "startday" VARCHAR,
  "endday" VARCHAR,
  "starttime" VARCHAR,
  "endtime" VARCHAR,
  "side" VARCHAR,
  "ownership" VARCHAR,
  "current_status" VARCHAR,
  "condition" VARCHAR,
  "text" VARCHAR,
  "adddttm" VARCHAR,
  "moddttm" VARCHAR,
  "instdate" VARCHAR,
  "expdate" VARCHAR,
  "primarydistrictcd" VARCHAR,
  "secondarydistrictcd" VARCHAR,
  "overrideyn" VARCHAR,
  "overridecomment" VARCHAR,
  "shape_lng" DOUBLE,
  "shape_lat" DOUBLE,
  "x" DOUBLE,
  "y" DOUBLE
);