About this Dataset

Pavement Marking

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:56:29.057973
Tags: crosswalk, dc, ddot, district-of-columbia, pavement-marking, roadway, street, traffic-calming, transportation, washington-dc

Tables

Table 1

@usgov.district_of_columbia_pavement_marking.table_1

5.12 MB
60,094 rows
18 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "streetjunctionid" BIGINT,
  "streetsegid" DOUBLE,
  "facilityid" BIGINT,
  "markingid" BIGINT,
  "markingtype" BIGINT,
  "markingcondition" BIGINT,
  "markingdetail" DOUBLE,
  "comments" VARCHAR,
  "gis_id" VARCHAR,
  "objectid" BIGINT,
  "se_anno_cad_data" VARCHAR,
  "creator" VARCHAR,
  "created" VARCHAR,
  "editor" VARCHAR,
  "edited" VARCHAR,
  "globalid" VARCHAR
);