About this Dataset

Automated Traffic Enforcement

The Automated Traffic Enforcement (ATE) is a division of the District Department of Transportation (DDOT) that uses photo enforcement cameras as a traffic calming measure to enforce traffic laws, and to reduce violations on DC’s streets and most intersections.

ATE is currently enforcing Posted Speed Limit (Speed), Stop Sign (Failure to come to a complete STOP), Red-Light (Running Red-Light), Bus Lane, Bus Zone, School Bus Stop-Arm, and Truck Restriction routes.
Organization: District of Columbia
Last updated: 2024-04-30T17:37:32.757953
Tags: ate, automated-traffic-enforcement, district-of-columbia, red-light, speed-camera, violation, washington-dc

Tables

Table 1

@usgov.district_of_columbia_automated_traffic_enforcement.table_1

44.8 kB
318 rows
19 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "enforcement_space_code" VARCHAR,
  "site_code" BIGINT,
  "enforcement_type" VARCHAR,
  "location_description" VARCHAR,
  "speed_limit" BIGINT,
  "device_mobility" VARCHAR,
  "camera_status" VARCHAR,
  "active_status" VARCHAR,
  "camera_latitude" DOUBLE,
  "camera_longitude" DOUBLE,
  "camera_easting" DOUBLE,
  "camera_northing" DOUBLE,
  "ward" DOUBLE,
  "anc" VARCHAR,
  "smd" VARCHAR,
  "objectid" BIGINT,
  "globalid" VARCHAR
);