About this Dataset

SDOT Collisions Vehicles

SDOT Collisions-Vehicles data provided by WSDOT and stored in the Infor System. Displays the locations and attributes of SDOT Collisions data specific to vehicle(s) involved in the collisions.

Refresh Cycle: Daily Refresh

SDOT Programs: Safe Routes to School, Vision Zero Program

Contact: DOT_IT_GIS@seattle.gov
Organization: City of Seattle
Last updated: 2025-02-28T23:39:23.054229
Tags: collision, sdot, seattle-gis-open-data, transportation, vehicle

Tables

Table 1

@usgov.city_of_seattle_sdot_collisions_vehicles.table_1

16.57 MB
421477 rows
49 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "collisionvehdetkey" BIGINT,
  "coldetkey" BIGINT,
  "added_date" VARCHAR,
  "st_partcpnt_type_code" DOUBLE,
  "st_partcpnt_type_desc" VARCHAR,
  "st_postedspd" DOUBLE,
  "st_rdsurf_code" DOUBLE,
  "st_rdsurf_desc" VARCHAR,
  "st_seq_evnts1" DOUBLE,
  "st_seq_evnts1_desc" VARCHAR,
  "st_seq_evnts2" DOUBLE,
  "st_seq_evnts2_desc" VARCHAR,
  "st_seq_evnts3" DOUBLE,
  "st_seq_evnts3_desc" VARCHAR,
  "st_seq_evnts4" DOUBLE,
  "st_seq_evnts4_desc" VARCHAR,
  "st_trafcontrl" DOUBLE,
  "st_trafcontrl_desc" VARCHAR,
  "st_unit" DOUBLE,
  "st_veh_act_cd" DOUBLE,
  "st_veh_act_desc" VARCHAR,
  "st_veh_act2" DOUBLE,
  "st_veh_act2_desc" VARCHAR,
  "st_veh_act3" VARCHAR,
  "st_veh_act3_desc" VARCHAR,
  "st_veh_cc" DOUBLE,
  "st_veh_cc_desc" VARCHAR,
  "st_veh_cnd2" DOUBLE,
  "st_veh_cnd2_desc" VARCHAR,
  "st_veh_cnd3" DOUBLE,
  "st_veh_cnd3_desc" VARCHAR,
  "st_veh_cnd_cd" DOUBLE,
  "st_veh_cnd_desc" VARCHAR,
  "st_veh_type_cd" DOUBLE,
  "st_veh_type_desc" VARCHAR,
  "st_veh_use" DOUBLE,
  "st_veh_use_desc" VARCHAR,
  "se_anno_cad_data" VARCHAR,
  "source_of_the_collision_report" VARCHAR,
  "source_description" VARCHAR,
  "incident_date" VARCHAR,
  "incident_date_time" VARCHAR,
  "report_number" VARCHAR,
  "added_by_user" VARCHAR,
  "modified_by" VARCHAR,
  "modified_date" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);