About this Dataset

SDOT Collisions Persons

SDOT Collisions-Persons data provided by WSDOT and stored in the Infor System. Displays the locations and attributes of SDOT Collisions data specific to person(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:45:58.023835
Tags: collision, person, sdot, seattle-gis-open-data, transportation

Tables

Table 1

@usgov.city_of_seattle_sdot_collisions_persons.table_1

24.33 MB
546,943 rows
68 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "collisionpsndetkey" BIGINT,
  "coldetkey" BIGINT,
  "added_date" VARCHAR,
  "st_age" DOUBLE,
  "st_arbg_stat" DOUBLE,
  "st_arbg_stat_desc" VARCHAR,
  "st_alchl_tst_rslts" DOUBLE,
  "st_alchl_tst_rslts_desc" VARCHAR,
  "st_cited" VARCHAR,
  "st_clthng_vsblty" DOUBLE,
  "st_clthng_vsblty_desc" VARCHAR,
  "st_contrbcir_cd1" DOUBLE,
  "st_contrbcir1_desc" VARCHAR,
  "st_contrbcir_cd2" DOUBLE,
  "st_contrbcir2_desc" VARCHAR,
  "st_contrbcir_cd3" DOUBLE,
  "st_contrbcir3_desc" VARCHAR,
  "st_dir_fm" DOUBLE,
  "st_dir_fm_desc" VARCHAR,
  "st_dir_to" DOUBLE,
  "st_dir_to_desc" VARCHAR,
  "st_dre1" DOUBLE,
  "st_dre1_desc" VARCHAR,
  "st_dre2" DOUBLE,
  "st_dre2_desc" VARCHAR,
  "st_driver_misc_act_cd1" VARCHAR,
  "st_driver_misc_act1_desc" VARCHAR,
  "st_driver_misc_act_cd2" VARCHAR,
  "st_driver_misc_act2_desc" VARCHAR,
  "st_drvr_actns3" VARCHAR,
  "st_drvr_actns3_desc" VARCHAR,
  "st_ejctn" DOUBLE,
  "st_ejctn_desc" VARCHAR,
  "st_gender" VARCHAR,
  "st_gender_desc" VARCHAR,
  "st_hzmt_ind" DOUBLE,
  "st_hzmt_ind_desc" VARCHAR,
  "st_helmet" DOUBLE,
  "st_helmet_desc" VARCHAR,
  "st_injry_clss" DOUBLE,
  "st_injry_clss_desc" VARCHAR,
  "st_partcpnt_type" BIGINT,
  "st_partcpnt_type_desc" VARCHAR,
  "st_ped_act_cd" DOUBLE,
  "st_ped_act_desc" VARCHAR,
  "st_ped_type" DOUBLE,
  "st_ped_type_desc" VARCHAR,
  "st_ped_was_using_cd" DOUBLE,
  "st_ped_was_using_desc" VARCHAR,
  "st_restraint" DOUBLE,
  "st_restraint_desc" VARCHAR,
  "st_sobriety_cd" DOUBLE,
  "st_sobriety_desc" VARCHAR,
  "st_st_pston" DOUBLE,
  "st_st_pston_desc" VARCHAR,
  "st_unit" BIGINT,
  "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
);