About this Dataset

Automatic Traffic Safety Cameras (ATSC) - (ACTIVE)

View Layer of Automatic Traffic Safety Camera (ATSC) Cameras layer display the sites of ATSC cameras. Maintained by Seattle Department of Transportation.

Refresh Cycle: Static, manually updated as required on periodic basis.

Contact: Vision Zero team
Organization: City of Seattle
Last updated: 2025-10-11T22:18:17.258832
Tags: gis, sdot, traffic-safety-cameras, vision-zero

Tables

Table 1

@usgov.city_of_seattle_automatic_traffic_safety_cameras_atsc_active.table_1

60.09 kB
116 rows
64 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "site_id" VARCHAR,
  "location_id" VARCHAR,
  "snd_site_name_intersection_or" VARCHAR  -- SND Site Name, Intersection Or,
  "camera_direction_traffic_movem" VARCHAR  -- Camera Direction, Traffic Movem,
  "midblock_location_for_red_light" VARCHAR,
  "school_name" VARCHAR,
  "spd_camera_name" VARCHAR,
  "camera_type" VARCHAR,
  "first_warning" VARCHAR,
  "last_warning" VARCHAR,
  "first_ticket_date" VARCHAR,
  "removal_end_ticket_date" VARCHAR  -- Removal, End Ticket, Date,
  "deactivation_period_1_begin" TIMESTAMP,
  "deactivation_period_1_end" TIMESTAMP,
  "deactivation_period_2_begin" VARCHAR,
  "deactivation_period_2_end" VARCHAR,
  "cam_lat" DOUBLE,
  "cam_long" DOUBLE,
  "loc_lat" VARCHAR,
  "loc_long" VARCHAR,
  "beacon_asset_id" VARCHAR,
  "f2024_rsei_composite_quintile_s" VARCHAR,
  "f2024_rsei_composite_quintile_l" VARCHAR,
  "data" VARCHAR,
  "f2006_tickets" VARCHAR,
  "f2006_warnings" VARCHAR,
  "f2007_tickets" VARCHAR,
  "f2007_warnings" VARCHAR,
  "f2008_tickets" VARCHAR,
  "f2008_warnings" VARCHAR,
  "f2009_tickets" VARCHAR,
  "f2009_warnings" VARCHAR,
  "f2010_tickets" VARCHAR,
  "f2010_warnings" VARCHAR,
  "f2011_tickets" VARCHAR,
  "f2011_warnings" VARCHAR,
  "f2012_tickets" VARCHAR,
  "f2012_warnings" VARCHAR,
  "f2013_tickets" VARCHAR,
  "f2014_tickets" VARCHAR,
  "f2014_warnings" VARCHAR,
  "f2015_tickets" VARCHAR,
  "f2015_warnings" VARCHAR,
  "f2016_tickets" VARCHAR,
  "f2016_warnings" VARCHAR,
  "f2017_tickets" VARCHAR,
  "f2017_warnings" VARCHAR,
  "f2018_tickets" VARCHAR,
  "f2018_warnings" VARCHAR,
  "f2019_tickets" VARCHAR,
  "f2019_warnings" VARCHAR,
  "f2020_tickets" VARCHAR,
  "f2020_warnings" VARCHAR,
  "f2021_tickets" VARCHAR,
  "f2021_warnings" VARCHAR,
  "f2022_tickets" VARCHAR,
  "f2022_warnings" VARCHAR,
  "f2023_tickets" VARCHAR,
  "f2023_warnings" VARCHAR,
  "f2024_tickets" VARCHAR,
  "f2024_warnings" VARCHAR,
  "objectid" BIGINT
);