About this Dataset

Traffic Camera

The dataset contains location and attributes of traffic controls located at each intersection in the District of Columbia. All traffic poles, pavement markings, traffic cabinets and cameras located within 10 meters of curb face intersections are collected. Poles must support traffic control devices in order to be collected. This includes traffic control signs, traffic signals, traffic arms and cameras. The data set does not include poles supporting only name plate signs and parking enforcement signs.
Organization: District of Columbia
Last updated: 2024-04-30T17:57:36.166575
Tags: dc, ddot, district-of-columbia, traffic-camera, traffic-pole, traffic-signal, transportation, washington-dc

Tables

Table 1

@usgov.district_of_columbia_traffic_camera_a0cad.table_1

40.7 kB
314 rows
17 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "streetjunctionid" BIGINT,
  "streetsegid" BIGINT,
  "facilityid" BIGINT,
  "cameraid" BIGINT,
  "poleid" BIGINT,
  "cameratype" VARCHAR,
  "owner" BIGINT,
  "gis_id" VARCHAR,
  "se_anno_cad_data" VARCHAR,
  "objectid" BIGINT,
  "globalid" VARCHAR,
  "creator" VARCHAR,
  "created" VARCHAR,
  "editor" VARCHAR,
  "edited" TIMESTAMP
);