About this Dataset

Traffic Signal Cabinets

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-30T19:12:29.716518
Tags: dc, ddot, district-of-columbia, traffic-signal, traffic-signal-cabinet, transportation, transportation-operation-agency, washington-dc

Tables

Table 1

@usgov.district_of_columbia_traffic_signal_cabinets_89335.table_1

143.36 kB
1,412 rows
17 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "streetjunctionid" BIGINT,
  "streetsegid" BIGINT,
  "facilityid" BIGINT,
  "cabinetid" BIGINT,
  "cabinettype" BIGINT,
  "isbackuppower" BIGINT,
  "acisano" DOUBLE,
  "gis_id" VARCHAR,
  "se_anno_cad_data" VARCHAR,
  "globalid" VARCHAR,
  "creator" VARCHAR,
  "created" VARCHAR,
  "editor" VARCHAR,
  "edited" VARCHAR,
  "objectid" BIGINT
);