About this Dataset

Markings Condition Assessment - Yellow Lines

Yellow thermoplastic pavement markings conditions along with 2019 and 2022 condition values. The data was collected in 2022 and delivered in 2023 capturing all yellow markings for the 2,808 miles of markings in the District. The data is used to determine maintenance needs and activities by the Operations Administration.
Organization: District of Columbia
Last updated: 2024-08-06T19:39:36.614014
Tags: dc, ddot, district-of-columbia, lane-markings, retroreflectivity, thermoplastic-markings, washington-dc, white-lines

Tables

Table 1

@usgov.district_of_columbia_markings_condition_assessment_yellow_lines.table_1

899.36 kB
13,462 rows
18 columns

CREATE TABLE table_1 (
  "wrm_2022" DOUBLE,
  "yrm_2022" DOUBLE,
  "wrm_2019" BIGINT,
  "yrm_2019" BIGINT,
  "quadrant" VARCHAR,
  "ward" VARCHAR,
  "dcfunction" BIGINT,
  "wrm_2022_c" VARCHAR,
  "yrm_2022_c" VARCHAR,
  "wrm_2019_c" VARCHAR,
  "yrm_2019_c" VARCHAR,
  "routeid" VARCHAR,
  "blockkey" VARCHAR,
  "gis_id" VARCHAR,
  "se_anno_cad_data" VARCHAR,
  "shape_leng" DOUBLE,
  "objectid" BIGINT,
  "shapelen" BIGINT
);