SDOT Collisions All Years by US Government | Demographics and Population Studies

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

20.33 MB
255197 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
);