About this Dataset

Roadway Functional Classification

Roadway Street Block by Functional Class. A single line, segmented at all intersections (alley, service road, drive, street, and driveway centerline types), representing each street in the District. They follow the general trend of the street and do not deviate due to parking lanes, turning lanes, etc. and contain address ranges for geocoding. The street GIS database includes five different street road types: Collector, Interstate, Local, Minor Arterial, Other Freeway and Expressway, Principal Arterial

For more information please visit DDOT's wiki page.
Organization: District of Columbia
Last updated: 2024-04-30T18:24:51.136542
Tags: ddot, district-of-columbia, linear-referencing, lrs, nhs, roadway-block, roadwayhub, street-block, street-centerline, transportation, washington-dc

Tables

Table 1

@usgov.district_of_columbia_roadway_functional_classification.table_1

1.37 MB
13,846 rows
29 columns

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