About this Dataset

Interstate Highways

Roadway Street Blocks representing Interstates, Freeways, Expressways in the District, This data set was created to act as a basis for public and private institutions to improve their policy and decision making; promote economic development; and enhance the quality of life for residents and businesses. For more information please visit DDOT's wiki page.
Organization: District of Columbia
Last updated: 2024-04-30T19:16:34.233512
Tags: ddot, district-of-columbia, highway, interstate, linear-referencing, lrs, nhs, retiredcenterline, roadway-block, roadwayhub, street-block, street-centerline, transportation, washington-dc

Tables

Table 1

@usgov.district_of_columbia_interstate_highways.table_1

30.73 kB
61 rows
34 columns

CREATE TABLE table_1 (
  "roadtype" BIGINT,
  "streettype" VARCHAR,
  "quadrant" BIGINT,
  "ownership" BIGINT,
  "nhstype" VARCHAR,
  "routeid" VARCHAR,
  "routename" VARCHAR,
  "blockkey" VARCHAR,
  "totaltravellanes" BIGINT,
  "totaltravellanewidth" BIGINT,
  "totaltravellanesinbound" BIGINT,
  "totaltravellanesoutbound" BIGINT,
  "summarydirection" VARCHAR,
  "fhwafunctionalclass" BIGINT,
  "nhscode" BIGINT,
  "speedlimits_ib" VARCHAR,
  "speedlimits_ob" DOUBLE,
  "streetname" VARCHAR,
  "block_name" VARCHAR,
  "mar_id" DOUBLE,
  "blockid" VARCHAR,
  "dcfunctionalclass" BIGINT,
  "ward_id" BIGINT,
  "anc_id" VARCHAR,
  "smd_id" VARCHAR,
  "surface_type" BIGINT,
  "aadt_combination" DOUBLE,
  "aadt_combination_year" DOUBLE,
  "aadt_single_unit" DOUBLE,
  "aadt_single_unit_year" DOUBLE,
  "objectid" BIGINT,
  "dc_maintenance_operations" BIGINT,
  "maintenance_operations" BIGINT,
  "shapelen" BIGINT
);