About this Dataset

Seattle Streets

Streets data includes: Arterial Classification, Street Names, Block Number, Direction, One-way, Surface Width, Surface Type, Pavement Condition, Speed Limit, Percent Slope. From the Hansen Asset Management System:

The linework is from the SND(Street Network Database) which can be found at our open data site - https://data-seattlecitygis.opendata.arcgis.com/datasets/street-network-database-snd.

| Attribute Information: https://www.seattle.gov/Documents/Departments/SDOT/GIS/Seattle_Streets_OD.pdf

| Update Cycle: Weekly
| Contact Email: DOT_IT_GIS@seattle.gov

---
Common SDOT queries and data downloads
| Arterial Classification: of Seattle Streets
ARTCLASS IN(1,2,3,4)

| Transit Classification: of Seattle Streets
TRANCLASS IN(1,2,3,4,5,6)
Organization: City of Seattle
Last updated: 2025-10-25T21:40:35.033368
Tags: arterial, arterial-classification, block-number, direction, gis, one-way, one-way-streets, pavement-condition, percent-slope, sdot, seattle, seattle-gis-open-data, speed-limit, street-names, surface-type, surface-width, transit, transit-classification

Tables

Table 1

@usgov.city_of_seattle_seattle_streets_438de.table_1

3.02 MB
23,873 rows
53 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "compkey" BIGINT,
  "unitid" DOUBLE,
  "unitid2" DOUBLE,
  "unitidsort" DOUBLE,
  "unitdesc" VARCHAR,
  "stname_ord" VARCHAR,
  "onstreet" VARCHAR,
  "status" VARCHAR,
  "primarydistrictcd" VARCHAR,
  "secondarydistrictcd" VARCHAR,
  "overrideyn" VARCHAR,
  "xstrlo" VARCHAR,
  "xstrhi" VARCHAR,
  "artclass" DOUBLE,
  "artdescript" VARCHAR,
  "owner" VARCHAR,
  "blocknbr" DOUBLE,
  "speedlimit" DOUBLE,
  "segdir" VARCHAR,
  "oneway" VARCHAR,
  "onewaydir" VARCHAR,
  "flow" VARCHAR,
  "seglength" DOUBLE,
  "surfacewidth" DOUBLE,
  "surfacetype_1" VARCHAR,
  "surfacedate_1" VARCHAR,
  "surfacetype_2" VARCHAR,
  "surfacedate_2" VARCHAR,
  "intrlo" VARCHAR,
  "dirlo" VARCHAR,
  "intkeylo" DOUBLE,
  "intrhi" VARCHAR,
  "dirhi" VARCHAR,
  "intkeyhi" DOUBLE,
  "gis_mid_x" DOUBLE,
  "gis_mid_y" DOUBLE,
  "se_anno_cad_data" VARCHAR,
  "sgndbkroute" VARCHAR,
  "nghbrhdgrnwy" VARCHAR,
  "nationhwysys" VARCHAR,
  "streettype" VARCHAR,
  "mjtrk_str_flag" VARCHAR,
  "pvmtcondindx1" DOUBLE,
  "pvmtcondindx2" DOUBLE,
  "tranclass" BIGINT,
  "trandescript" VARCHAR,
  "overridecomment" VARCHAR,
  "block_url" VARCHAR,
  "slope_pct" DOUBLE,
  "pvmtcategory" VARCHAR,
  "parkboulevard" VARCHAR,
  "shape_length" DOUBLE  -- Shape, Length
);