About this Dataset

Crash Cushions

A crash cushion is a disposable device used to increase safety for motor vehicle operators and passengers who collide with safety barriers at gore points. Crash cushions improve safety and also help protect the transportation infrastructure.

Displays crash cushions maintained by the Seattle Department of Transportation.

Views: Link, which adds the recommended filter for general use of the dataset: 'CURRENT_STATUS = 'INSVC' OR CURRENT_STATUS is empty string'

Refresh Cycle: Daily

Feature Class: SDOT.V_CRASHCUSHIONS
Organization: City of Seattle
Last updated: 2025-02-28T23:31:37.018943
Tags: common-data-layers, crash-cushions, sdot, seattle-gis-open-data, transportation

Tables

Table 1

@usgov.city_of_seattle_crash_cushions_e9ff0.table_1

40.17 kB
103 rows
42 columns

CREATE TABLE table_1 (
  "objectid_12" BIGINT,
  "compkey" DOUBLE,
  "unitid" VARCHAR,
  "unitdesc_crs" VARCHAR,
  "moddttm" VARCHAR,
  "condition" VARCHAR,
  "condition_assessment_date" VARCHAR,
  "ownership" VARCHAR,
  "current_status" VARCHAR,
  "primarydistrictcd" VARCHAR,
  "secondarydistrictcd" VARCHAR,
  "overrideyn" VARCHAR,
  "intr_compkey" VARCHAR,
  "intr_unitid" VARCHAR,
  "intr_distance" VARCHAR,
  "description" VARCHAR,
  "seg_compkey" VARCHAR,
  "location" VARCHAR,
  "assetid" VARCHAR,
  "comptype" DOUBLE,
  "hansegkey" DOUBLE,
  "unittype" VARCHAR,
  "unitdesc_seg" VARCHAR,
  "install_date" VARCHAR,
  "adddttm" VARCHAR,
  "expdate" VARCHAR,
  "maintby" VARCHAR,
  "current_status_date" VARCHAR,
  "ownership_date" VARCHAR,
  "overridecomment" VARCHAR,
  "subarea" VARCHAR,
  "crstype" VARCHAR,
  "crsdesc" VARCHAR,
  "trafdir" VARCHAR,
  "bckstpwid" DOUBLE,
  "nbrofbays" DOUBLE,
  "spdlimit" DOUBLE,
  "shape_lng" DOUBLE,
  "shape_lat" DOUBLE,
  "num_attachments" BIGINT,
  "x" DOUBLE,
  "y" DOUBLE
);