About this Dataset

Guardrails

Guardrails are devices designed to keep pedestrians and motor vehicles from straying off the road into potentially dangerous or off-limit areas of the ROW. Guardrails improve safety and also protect the transportation infrastructure.

Displays guardrails maintained by the Seattle Department of Transportation.

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

Refresh Cycle: Daily

Feature Class: SDOT.V_GUARDRAILS
Organization: City of Seattle
Last updated: 2025-02-28T23:28:05.440907
Tags: common-data-layers, guardrails, sdot, seattle-gis-open-data, transportation

Tables

Table 1

@usgov.city_of_seattle_guardrails_0c320.table_1

146.02 kB
941 rows
37 columns

CREATE TABLE table_1 (
  "objectid" VARCHAR,
  "compkey" BIGINT,
  "unitid" VARCHAR,
  "unitdesc_gdr" VARCHAR,
  "modby" VARCHAR,
  "moddttm" VARCHAR,
  "condition" VARCHAR,
  "conddt" VARCHAR,
  "status" VARCHAR,
  "primarydistrictcd" VARCHAR,
  "secondarydistrictcd" VARCHAR,
  "overrideyn" VARCHAR,
  "comptype" DOUBLE,
  "hansegkey" DOUBLE,
  "unittype" VARCHAR,
  "unitdesc_seg" VARCHAR,
  "instdate" VARCHAR,
  "expdate" VARCHAR,
  "addby" VARCHAR,
  "adddttm" VARCHAR,
  "lstverify" VARCHAR,
  "statusdt" VARCHAR,
  "maintby" VARCHAR,
  "own" VARCHAR,
  "overridecomment" VARCHAR,
  "artclass" DOUBLE,
  "protcttyp" VARCHAR,
  "obstacle" VARCHAR,
  "posttype" VARCHAR,
  "strtshape" VARCHAR,
  "endtrttyp" VARCHAR,
  "nbrends" DOUBLE,
  "postntrvl" VARCHAR,
  "spdlimit" DOUBLE,
  "gdrlength" DOUBLE,
  "num_attachments" DOUBLE,
  "shape_length" DOUBLE  -- Shape, Length
);