About this Dataset

Roadway Block

For a city, street blocks are a very common way in which to organize and relate work (e.g. 'I need to fix a pothole on the 1600 Block of Pennsylvania Ave'). Although driveways or alleys may intersect streets, this representation requires that the segment remain unbroken. Road types include streets. Previously Called Street Segments. Note that there are no from/to address fields. We will not be maintaining them in our data. There also will be no generating a 'streetname' list.

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

Tables

Table 1

@usgov.district_of_columbia_roadway_block.table_1

2.67 MB
13,843 rows
101 columns

CREATE TABLE table_1 (
  "routeid" VARCHAR,
  "frommeasure" DOUBLE,
  "tomeasure" DOUBLE,
  "routename" VARCHAR,
  "roadtype" BIGINT,
  "blockkey" VARCHAR,
  "totaltravellanes" BIGINT,
  "totalparkinglanes" BIGINT,
  "totalraisedbuffers" BIGINT,
  "totaltravellanewidth" BIGINT,
  "totalcrosssectionwidth" BIGINT,
  "totalparkinglanewidth" BIGINT,
  "totalraisedbufferwidth" 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_protected" VARCHAR,
  "bikelane_buffered" VARCHAR,
  "doubleyellow_line" VARCHAR,
  "sectionflags" VARCHAR,
  "loc_error" VARCHAR,
  "midmeasure" VARCHAR,
  "aadt" DOUBLE,
  "aadt_year" DOUBLE,
  "fhwafunctionalclass" BIGINT,
  "hpmsid" VARCHAR,
  "hpmssectiontype" BIGINT,
  "id" VARCHAR,
  "iri" DOUBLE,
  "iri_date" TIMESTAMP,
  "nhscode" DOUBLE,
  "ownership" BIGINT,
  "pci_condcategory" VARCHAR,
  "pci_lastinspected" TIMESTAMP,
  "pci_score" DOUBLE,
  "quadrant" BIGINT,
  "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,
  "streetname" VARCHAR,
  "streettype" VARCHAR,
  "block_name" VARCHAR,
  "address_range_high" DOUBLE,
  "address_range_low" DOUBLE,
  "address_range_right_high" DOUBLE,
  "address_range_left_high" DOUBLE,
  "address_range_right_low" DOUBLE,
  "mar_id" DOUBLE,
  "address_range_left_low" DOUBLE,
  "blockid" VARCHAR,
  "dcfunctionalclass" BIGINT,
  "nhstype" VARCHAR,
  "snowroute_ddot" VARCHAR,
  "snowroute_dpw" VARCHAR,
  "snowsection_ddot" VARCHAR,
  "snowzone_ddot" DOUBLE,
  "snowzone_dpw" 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,
  "bikelane_dual_buffered" VARCHAR,
  "rightturn_exclusive" VARCHAR,
  "leftturn_exclusive" VARCHAR,
  "buslane_inbound" VARCHAR,
  "buslane_outbound" VARCHAR,
  "fromstreet" VARCHAR,
  "tostreet" VARCHAR,
  "ward_id" BIGINT,
  "anc_id" VARCHAR,
  "smd_id" VARCHAR,
  "surface_type" DOUBLE,
  "parkingzone_rop" DOUBLE,
  "parkingzone_rpp" DOUBLE,
  "aadt_combination" DOUBLE,
  "aadt_combination_year" DOUBLE,
  "aadt_single_unit" DOUBLE,
  "aadt_single_unit_year" DOUBLE,
  "speedhump_present" VARCHAR,
  "objectid" BIGINT,
  "dc_maintenance_operations" BIGINT,
  "maintenance_operations" BIGINT
);