About this Dataset

Roadway SubBlock

SubBlock represent the near-full extent of our centerline network (only driveways are excluded). SubBlock is the finest grained, 'base' segments from which all other segmentation patterns can be constructed (including Blocks). SubBlock is the original source features for our DDOT Street Centerlines data. Road types include streets, Alleys, Ramps, Service Roads, and Trails. Previously called Roadway Segments.

For more information please visit DDOT's wiki page.
Organization: District of Columbia
Last updated: 2024-04-30T18:37:24.246958
Tags: ddot, district-of-columbia, linear-referencing, lrs, roadway-hub, roadway-subblock, street-subblock, transportation, washington-dc

Tables

Table 1

@usgov.district_of_columbia_roadway_subblock.table_1

5.15 MB
34964 rows
90 columns


CREATE TABLE table_1 (
  "routeid" VARCHAR,
  "frommeasure" DOUBLE,
  "tomeasure" DOUBLE,
  "routename" VARCHAR,
  "roadtype" BIGINT,
  "subblockkey" VARCHAR,
  "totaltravellanes" BIGINT,
  "totalparkinglanes" BIGINT,
  "totalraisedbuffers" BIGINT,
  "totaltravellanewidth" BIGINT,
  "totalcrosssectionwidth" BIGINT,
  "totalparkinglanewidth" BIGINT,
  "totaltravellanesinbound" BIGINT,
  "totaltravellanesoutbound" BIGINT,
  "totaltravellanesbidirectional" BIGINT,
  "totaltravellanesreversible" BIGINT,
  "summarydirection" VARCHAR,
  "bikelane_parkinglane_adjacent" VARCHAR,
  "bikelane_throughlane_adjacent" VARCHAR,
  "bikelane_pocketlane_adjacent" VARCHAR,
  "bikelane_contraflow" VARCHAR,
  "bikelane_conventional" VARCHAR,
  "bikelane_dual_protected" VARCHAR,
  "bikelane_dual_buffered" VARCHAR,
  "bikelane_protected" VARCHAR,
  "bikelane_buffered" VARCHAR,
  "doubleyellow_line" VARCHAR,
  "sectionflags" VARCHAR,
  "loc_error" VARCHAR,
  "midmeasure" VARCHAR,
  "aadt" DOUBLE,
  "fhwafunctionalclass" DOUBLE,
  "hpmsid" VARCHAR,
  "hpmssectiontype" DOUBLE,
  "id" VARCHAR,
  "iri" DOUBLE,
  "iri_date" TIMESTAMP,
  "nhscode" DOUBLE,
  "ownership" DOUBLE,
  "pci_condcategory" VARCHAR,
  "pci_lastinspected" TIMESTAMP,
  "pci_score" DOUBLE,
  "sidewalk_ib_pavtype" VARCHAR,
  "sidewalk_ib_width" VARCHAR,
  "sidewalk_ob_pavtype" VARCHAR,
  "sidewalk_ob_width" VARCHAR,
  "speedlimits_ib" VARCHAR,
  "speedlimits_ib_alt" VARCHAR,
  "speedlimits_ob" DOUBLE,
  "speedlimits_ob_alt" DOUBLE,
  "subblockid" VARCHAR,
  "blockid" VARCHAR,
  "blockkey" VARCHAR,
  "dcfunctionalclass" DOUBLE,
  "nhstype" VARCHAR,
  "quadrant" DOUBLE,
  "streetname" VARCHAR,
  "streettype" VARCHAR,
  "snowroute_dpw" VARCHAR,
  "snowzone_dpw" DOUBLE,
  "snowroute" VARCHAR,
  "snowsection" VARCHAR,
  "snowzone" DOUBLE,
  "leftturn_curblane_excl" VARCHAR,
  "leftturn_curblane_excl_len" BIGINT,
  "rightturn_curblane_excl" VARCHAR,
  "rightturn_curblane_excl_len" BIGINT,
  "totalbikelanes" BIGINT,
  "totalbikelanewidth" BIGINT,
  "rppdirection" DOUBLE,
  "rppside" VARCHAR,
  "slowstreetinfo" VARCHAR,
  "totalraisedbufferwidth" BIGINT,
  "aadt_year" DOUBLE,
  "rightturn_exclusive" VARCHAR,
  "leftturn_exclusive" VARCHAR,
  "buslane_inbound" VARCHAR,
  "buslane_outbound" VARCHAR,
  "fromstreet" VARCHAR,
  "tostreet" VARCHAR,
  "ward_id" BIGINT,
  "smd_id" VARCHAR,
  "anc_id" VARCHAR,
  "network_logical_end" VARCHAR,
  "aadt_combination" DOUBLE,
  "aadt_combination_year" DOUBLE,
  "aadt_single_unit" DOUBLE,
  "aadt_single_unit_year" DOUBLE,
  "objectid" BIGINT,
  "shapelen" BIGINT
);