About this Dataset

Street Furnishings

Street furnishings installed and maintained by the Seattle Department of Transportation within the public right of way. Street Furnishings include rails, benches, chairs, tables, and walls in the right-of-way and typically come from capital projects and private developments.

Displays street furnishings maintained by the Seattle Department of Transportation.

Views: Link, adds recommended definition query for general use: 'CURRENT_STATUS = INSVC OR CURRENT_STATUS is empty string'

Refresh Cycle: Daily

Feature Class: SDOT.V_STREETFURN
Organization: City of Seattle
Last updated: 2025-02-28T23:35:48.630324
Tags: common-data-layers, sdot, seattle-gis-open-data, street-furnishing, transportation

Tables

Table 1

@usgov.city_of_seattle_street_furnishings_2a561.table_1

124.65 KB
1039 rows
44 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "compkey" BIGINT,
  "comptype" BIGINT,
  "segkey" BIGINT,
  "distance" DOUBLE,
  "width" BIGINT,
  "unitid" VARCHAR,
  "unittype" VARCHAR,
  "unitdesc" VARCHAR,
  "adddttm" VARCHAR,
  "moddate" VARCHAR,
  "side" VARCHAR,
  "condition" VARCHAR,
  "condition_assessment_date" VARCHAR,
  "ownership" VARCHAR,
  "current_status" VARCHAR,
  "current_status_date" VARCHAR,
  "install_date" VARCHAR,
  "asbuiltplanno" VARCHAR,
  "category" VARCHAR,
  "material" VARCHAR,
  "style" VARCHAR,
  "length" BIGINT,
  "asset_width" BIGINT,
  "height" BIGINT,
  "maintained_by" VARCHAR,
  "primarydistrictcd" VARCHAR,
  "secondarydistrictcd" VARCHAR,
  "overrideyn" VARCHAR,
  "overridecomment" 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_lng" DOUBLE,
  "shape_lat" DOUBLE,
  "x" DOUBLE,
  "y" DOUBLE
);