About this Dataset

2017 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:17:29.930601
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_2017_traffic_volume.table_1

2.51 MB
22,484 rows
17 columns

CREATE TABLE table_1 (
  "routeid" VARCHAR,
  "frommeasure" DOUBLE,
  "tomeasure" DOUBLE,
  "fromdate" TIMESTAMP,
  "todate" VARCHAR,
  "eventid" VARCHAR,
  "aadt" BIGINT,
  "aadt_year" BIGINT,
  "gis_id" VARCHAR,
  "locerror" VARCHAR,
  "objectid" BIGINT,
  "shapelen" BIGINT,
  "globalid" VARCHAR,
  "creator" VARCHAR,
  "created" VARCHAR,
  "editor" VARCHAR,
  "edited" TIMESTAMP
);