About this Dataset

2007 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:09.273803
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_2007_traffic_volume.table_1

662.6 kB
12,820 rows
29 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "streetsegid" BIGINT,
  "sourceid" BIGINT,
  "ssd_id" BIGINT,
  "registeredname" VARCHAR,
  "streettype" VARCHAR,
  "quadrant" VARCHAR,
  "inservicedate" TIMESTAMP,
  "inset" DOUBLE,
  "repleg" VARCHAR,
  "citywide" BIGINT,
  "labelplacement" VARCHAR,
  "ward" BIGINT,
  "labinrd" DOUBLE,
  "labinvol" DOUBLE,
  "vol2000" BIGINT,
  "cnt2002" DOUBLE,
  "cnt2006" DOUBLE,
  "cnt2007" DOUBLE,
  "cwlabel" BIGINT,
  "frommeasure" DOUBLE,
  "tomeasure" DOUBLE,
  "se_anno_cad_data" VARCHAR,
  "gis_id" VARCHAR,
  "creator" VARCHAR,
  "created" VARCHAR,
  "editor" VARCHAR,
  "edited" VARCHAR,
  "shapelen" BIGINT
);