2012 Traffic Volume by US Government | Transportation and Logistics

About this Dataset

2012 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:52.188145
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_2012_traffic_volume.table_1

1014.51 KB
15961 rows
38 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "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,
  "aadt2012" DOUBLE,
  "source12" VARCHAR,
  "se_anno_cad_data" VARCHAR,
  "gis_id" VARCHAR,
  "creator" VARCHAR,
  "created" VARCHAR,
  "editor" VARCHAR,
  "edited" VARCHAR,
  "shapelen" BIGINT
);