About this Dataset

Stairways

Displays stairways maintained by the Seattle Department of Transportation.

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

Refresh Cycle: Daily

Feature Class: SDOT.V_STAIRWAY
Organization: City of Seattle
Last updated: 2025-02-28T23:25:23.340933
Tags: common-data-layers, sdot, seattle-gis-open-data, stairways, transportation

Tables

Table 1

@usgov.city_of_seattle_stairways_26263.table_1

120.36 kB
631 rows
46 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "compkey" BIGINT,
  "unitid" VARCHAR,
  "unitdesc_asset" VARCHAR,
  "stairwaycondition" VARCHAR,
  "comptype" BIGINT,
  "segkey" BIGINT,
  "unitdesc_seg" VARCHAR,
  "unittype" VARCHAR,
  "install_date" VARCHAR,
  "ownership" VARCHAR,
  "current_status" VARCHAR,
  "primarydistrictcd" VARCHAR,
  "secondarydistrictcd" VARCHAR,
  "overrideyn" VARCHAR,
  "maintained_by" VARCHAR,
  "maintfinancialresp" VARCHAR,
  "stairwayrating" DOUBLE,
  "railrating" DOUBLE,
  "railcondition" VARCHAR,
  "inspectionkey" DOUBLE,
  "inspcompdate" VARCHAR,
  "slideprone" VARCHAR,
  "stairwaytype" VARCHAR,
  "railtype" VARCHAR,
  "stairwaylength" BIGINT,
  "stairwaywidth" DOUBLE,
  "nbr_stairlanding" DOUBLE,
  "nbr_stairriser" DOUBLE,
  "bikerunnel" VARCHAR,
  "overridecomment" VARCHAR,
  "expby" VARCHAR,
  "adddttm" VARCHAR,
  "moddttm" VARCHAR,
  "current_status_date" 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,
  "num_attachments" BIGINT,
  "shape_length" DOUBLE  -- Shape, Length
);