About this Dataset

2006 Traffic Volume

Traffic volume of Roadway Blocks. The dataset contains traffic volume data, created as part of the District of Columbia, Department of Transportation (DDOT) Roads and Highways database. A database provided by the District of Columbia, Department of Transportation identified traffic volume. Count data is collected (both direction) at pre-selected locations on Highway Performance Monitoring System (HPMS) Sections on a three-year cycle. These counts are converted to Annual Average Daily Traffic (AADT).
Organization: District of Columbia
Last updated: 2024-04-30T19:18:11.254627
Tags: aadt, annual-average-daily-traffic, dc, ddot, district-of-columbia, federal-highway-administration, fha, highway-performance-management-system, hpms, traffic-volume, transportation, washington-dc

Tables

Table 1

@usgov.district_of_columbia_2006_traffic_volume.table_1

546.83 KB
13376 rows
27 columns


CREATE TABLE table_1 (
  "streetsegid" BIGINT,
  "sourceid" BIGINT,
  "registeredname" VARCHAR,
  "streettype" VARCHAR,
  "quadrant" VARCHAR,
  "representativeleg" VARCHAR,
  "ward" BIGINT,
  "labelinroad" DOUBLE,
  "labelinvolume" DOUBLE,
  "vol2000" BIGINT,
  "aadt_thsd_tnh_00" DOUBLE,
  "aadt_thsd_tnh_02" DOUBLE,
  "aadt_thsd_tnh_06" DOUBLE,
  "citywidelabel" BIGINT,
  "citywide" BIGINT,
  "inset" BIGINT,
  "frommeasure" BIGINT,
  "tomeasure" DOUBLE,
  "ishpms" BIGINT,
  "fc" DOUBLE,
  "objectid" BIGINT,
  "gis_id" VARCHAR,
  "creator" VARCHAR,
  "created" VARCHAR,
  "editor" VARCHAR,
  "edited" VARCHAR,
  "shapelen" BIGINT
);