About this Dataset

SDOT Collisions All Years

SDOT Collisions All Years is provided by SPD and recorded by Traffic Records. This feature includes all types of collisions and will display at the intersection or mid-block of a segment.

Refresh Cycle: Daily Refresh

Feature Class: SDOT.COLLSN_DET_PT

Definition Query: None
Organization: City of Seattle
Last updated: 2025-02-28T23:42:04.119708
Tags: accidents, bicycle, collisions, collisions-all-years, pedestrian, sdot, seattle-gis-open-data, traffic, vehicle

Tables

Table 1

@usgov.city_of_seattle_sdot_collisions_all_years_2a008.table_1

21.31 MB
255,197 rows
50 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "se_anno_cad_data" VARCHAR,
  "inckey" BIGINT,
  "coldetkey" BIGINT,
  "reportno" VARCHAR,
  "status" VARCHAR,
  "addrtype" VARCHAR,
  "intkey" DOUBLE,
  "location" VARCHAR,
  "exceptrsncode" VARCHAR,
  "exceptrsndesc" VARCHAR,
  "severitycode" VARCHAR,
  "severitydesc" VARCHAR,
  "collisiontype" VARCHAR,
  "personcount" BIGINT,
  "pedcount" BIGINT,
  "pedcylcount" BIGINT,
  "vehcount" BIGINT,
  "injuries" BIGINT,
  "seriousinjuries" BIGINT,
  "fatalities" BIGINT,
  "incdate" VARCHAR,
  "incdttm" VARCHAR,
  "junctiontype" VARCHAR,
  "sdot_colcode" DOUBLE,
  "sdot_coldesc" VARCHAR,
  "inattentionind" VARCHAR,
  "underinfl" VARCHAR,
  "weather" VARCHAR,
  "roadcond" VARCHAR,
  "lightcond" VARCHAR,
  "diagramlink" VARCHAR,
  "reportlink" VARCHAR,
  "pedrownotgrnt" VARCHAR,
  "sdotcolnum" DOUBLE,
  "speeding" VARCHAR,
  "stcolcode" DOUBLE,
  "st_coldesc" VARCHAR,
  "seglanekey" BIGINT,
  "crosswalkkey" BIGINT,
  "hitparkedcar" VARCHAR,
  "spdcaseno" VARCHAR,
  "source_of_the_collision_report" VARCHAR,
  "source_description" VARCHAR,
  "added_date" VARCHAR,
  "modified_date" VARCHAR,
  "sharedmicromobilitycd" VARCHAR,
  "sharedmicromobilitydesc" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);