About this Dataset

Automated Traffic Enforcement Violation Count By Month

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.

This version of ATE data includes devices with no coordinates and because of that, the data is in table format. Data can be mapped using Lat/Lon or X/Y MD State Plane (Meters) but there will be records with null coordinate values.
Organization: District of Columbia
Last updated: 2024-06-18T18:40:33.945641
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_vio_11506dae.table_1

419.38 kB
22,356 rows
8 columns

CREATE TABLE table_1 (
  "enforcement_space_code" VARCHAR,
  "year_month" TIMESTAMP,
  "camera_status" VARCHAR,
  "num_violations" BIGINT,
  "enforcement_type" VARCHAR,
  "last_record" TIMESTAMP,
  "objectid" BIGINT,
  "globalid" VARCHAR
);