About this Dataset

Speed Cushions

Speed Cushions are a set of small speed humps with space in between used in low volume arterial streets and on non-arterial streets that have been designated as an emergency fire route. The purpose of these assets is to slow down cars, which improves safety and encourages the use of other modes of transportation. Spacing is designed to allow wider-axle emergency vehicles to pass through without slowing down.

Displays speed cushions maintained by the Seattle Department of Transportation.

Views: Link, adds recommended definition query for general use: 'CURRENT_STATUS =INSVC'

Refresh Cycle: Daily

Feature Class: SDOT.V_SpeedCushion
Organization: City of Seattle
Last updated: 2025-02-28T23:26:15.457630
Tags: common-data-layers, sdot, seattle-gis-open-data, speed-cushions, transportation

Tables

Table 1

@usgov.city_of_seattle_speed_cushions.table_1

50.69 KB
87 rows
57 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "compkey" BIGINT,
  "comptype" BIGINT,
  "segkey" BIGINT,
  "unitid" VARCHAR,
  "unittype" VARCHAR,
  "unitdesc" VARCHAR,
  "category" VARCHAR,
  "material" VARCHAR,
  "style" VARCHAR,
  "asset_height" BIGINT,
  "asset_width" BIGINT,
  "install_date" VARCHAR,
  "asblt" VARCHAR,
  "maintained_by" VARCHAR,
  "maintenance_financial_resp" VARCHAR,
  "maintenance_agreement" VARCHAR,
  "comments" VARCHAR,
  "dirfromxst" VARCHAR,
  "disttohigh" BIGINT,
  "disttolow" BIGINT,
  "side" VARCHAR,
  "onstreet" VARCHAR,
  "xstrhigh" VARCHAR,
  "xstrlow" VARCHAR,
  "meas_from_high" VARCHAR,
  "meas_from_low" VARCHAR,
  "measurement_origin" VARCHAR,
  "log_comment_1" VARCHAR,
  "log_comment_2" VARCHAR,
  "log_comment_3" 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,
  "current_status" VARCHAR,
  "current_status_date" VARCHAR,
  "condition" VARCHAR,
  "condition_assessment_date" VARCHAR,
  "last_verify_date" VARCHAR,
  "ownership" VARCHAR,
  "ownership_date" VARCHAR,
  "adddttm" VARCHAR,
  "moddttm" VARCHAR,
  "date_mvw_last_updated" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);