About this Dataset

Traffic Pole

The dataset contains location and attributes of traffic controls features 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. These traffic contorl devices are part the data sets tables and are related to there particular pole. 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:03.558457
Tags: dc, ddot, district-of-columbia, traffic-control-agency, traffic-monitoring, traffic-pole, transportation, washington-dc

Tables

Table 1

@usgov.district_of_columbia_traffic_pole.table_1

2.77 MB
28,219 rows
26 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "poleid" BIGINT,
  "facilityid" BIGINT,
  "streetjunctionid" BIGINT,
  "streetsegid" BIGINT,
  "poletype" BIGINT,
  "polematerial" BIGINT,
  "poleheight" DOUBLE,
  "polecondition" BIGINT,
  "basetype" BIGINT,
  "ispower" BIGINT,
  "isaps" BIGINT,
  "noofheads" DOUBLE,
  "comments" VARCHAR,
  "folderdirectory" VARCHAR,
  "picture" VARCHAR,
  "picturepath" VARCHAR,
  "gis_id" VARCHAR,
  "objectid" BIGINT,
  "se_anno_cad_data" VARCHAR,
  "globalid" VARCHAR,
  "creator" VARCHAR,
  "created" VARCHAR,
  "editor" VARCHAR,
  "edited" VARCHAR
);