About this Dataset

Automated Traffic Enforcement Table

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.

ATE locations with no coordinates are included in this data 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:35.104504
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.table_1

53.88 kB
719 rows
19 columns

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