About this Dataset

Sidewalks

The sidewalk inventory was developed to assist staff in planning walkway development and to prioritize sidewalk improvements and maintenance. Sidewalk locations will be based on the locations of the assets on either side of the street segments. Expired assets are excluded. The sidewalk system consists of paved walkways (concrete, asphalt, and pavers), a few soft-surface pathways.

Displays sidewalks maintained by the Seattle Department of Transportation.

Views: Link, adds recommended definition query for general use: 'CURRENT_STATUS IN(INSVC, PLNRECON) OR CURRENT_STATUS is empty string'

Refresh Cycle: Daily

Feature Class: SDOT.V_SIDEWALKS
Organization: City of Seattle
Last updated: 2025-02-28T23:49:48.444108
Tags: common-data-layers, sdot, seattle-gis-open-data, sidewalks, transportation

Tables

Table 1

@usgov.city_of_seattle_sidewalks_86eed.table_1

4.31 MB
46,334 rows
58 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "compkey" DOUBLE,
  "comptype" DOUBLE,
  "segkey" DOUBLE,
  "unitid" VARCHAR,
  "unittype" VARCHAR,
  "unitdesc" VARCHAR,
  "adddttm" VARCHAR,
  "asblt" VARCHAR,
  "condition" VARCHAR,
  "condition_assessment_date" VARCHAR,
  "curbtype" VARCHAR,
  "current_status" VARCHAR,
  "current_status_date" VARCHAR,
  "fillertype" VARCHAR,
  "fillerwid" DOUBLE,
  "install_date" VARCHAR,
  "sw_width" DOUBLE,
  "maintained_by" VARCHAR,
  "matl" VARCHAR,
  "moddttm" VARCHAR,
  "ownership" VARCHAR,
  "side" VARCHAR,
  "surftype" VARCHAR,
  "buildercd" VARCHAR,
  "gsitypecd" VARCHAR,
  "hansen7id" VARCHAR,
  "attachment_1" VARCHAR,
  "attachment_2" VARCHAR,
  "attachment_3" VARCHAR,
  "attachment_4" VARCHAR,
  "attachment_5" VARCHAR,
  "attachment_6" VARCHAR,
  "attachment_7" VARCHAR,
  "attachment_8" VARCHAR,
  "attachment_9" VARCHAR,
  "primarydistrictcd" VARCHAR,
  "secondarydistrictcd" VARCHAR,
  "overrideyn" VARCHAR,
  "overridecomment" VARCHAR,
  "srts_sidewalk_rank" DOUBLE,
  "num_attachments" DOUBLE,
  "primarycrossslope" DOUBLE,
  "minimumvariablewidth" DOUBLE,
  "sw_category" VARCHAR,
  "maintenance_group" VARCHAR,
  "last_verify_date" VARCHAR,
  "color" VARCHAR,
  "ownership_date" VARCHAR,
  "nature_of_maint_resp" VARCHAR,
  "maint_financial_resp" VARCHAR,
  "variablewidthyn" VARCHAR,
  "maintbyrdwystructyn" VARCHAR,
  "swincompleteyn" VARCHAR,
  "multiplesurfaceyn" VARCHAR,
  "date_mvw_last_updated" VARCHAR,
  "expdate" VARCHAR,
  "shape_length" DOUBLE  -- Shape, Length
);