About this Dataset

2010 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:08.566181
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_2010_traffic_volume.table_1

1.04 MB
15,961 rows
37 columns

CREATE TABLE table_1 (
  "ssrsegid" BIGINT,
  "sourcesegid" BIGINT,
  "sourceid" VARCHAR,
  "quadcode" BIGINT,
  "roadtype" BIGINT,
  "streetid" BIGINT,
  "segmenttype" BIGINT,
  "fromnodeid" BIGINT,
  "tonodeid" BIGINT,
  "startmeasure" BIGINT,
  "endmeasure" DOUBLE,
  "lifecyclestatus" BIGINT,
  "directionality" BIGINT,
  "ownership" BIGINT,
  "registeredname" VARCHAR,
  "streettype" VARCHAR,
  "quadrant" VARCHAR,
  "fromaddressleft" BIGINT,
  "toaddressleft" BIGINT,
  "fromaddressright" BIGINT,
  "toaddressright" BIGINT,
  "description" VARCHAR,
  "inservicedate" TIMESTAMP,
  "outofservice" VARCHAR,
  "updatetime" TIMESTAMP,
  "fromgrade" BIGINT,
  "tograde" BIGINT,
  "hpmsid" VARCHAR,
  "aadt2010" DOUBLE,
  "source10" VARCHAR,
  "objectid" BIGINT,
  "shapelen" BIGINT,
  "gis_id" VARCHAR,
  "creator" VARCHAR,
  "created" VARCHAR,
  "editor" VARCHAR,
  "edited" VARCHAR
);