About this Dataset

Roadway Intersection Approach

Intersection Approach Segments are short segments of the route that approach an intersection, in other words, a short section of the road leading up to an intersection.

Roads and Highways manages intersections, however they are not singular points; RH creates a series of points - one for each intersecting road at that intersection. For DDOT, it is more useful to have a single intersection point representing the intersection. Through a custom DDOT script,the series of intersection points is reduced into a single representative point.

For more information please visit DDOT's wiki page.
Organization: District of Columbia
Last updated: 2024-04-30T18:45:11.897246
Tags: dc, ddot, district-of-columbia, intersection, intersection-approach, linear-referencing, lrs, roadway, roadway-block, roadwayhub, transportation

Tables

Table 1

@usgov.district_of_columbia_roadway_intersection_approach.table_1

10.7 MB
67,316 rows
98 columns

CREATE TABLE table_1 (
  "routeid" VARCHAR,
  "frommeasure" DOUBLE,
  "tomeasure" DOUBLE,
  "routename" VARCHAR,
  "roadtype" BIGINT,
  "approachid" 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_dual_buffered" VARCHAR,
  "bikelane_protected" VARCHAR,
  "bikelane_buffered" VARCHAR,
  "doubleyellow_line" VARCHAR,
  "sectionflags" VARCHAR,
  "loc_error" VARCHAR,
  "midmeasure" VARCHAR,
  "intersectionid" VARCHAR,
  "aadt" DOUBLE,
  "aadt_year" DOUBLE,
  "approach_card_direction" VARCHAR,
  "approach_int_direction" VARCHAR,
  "approach_leg_angle" VARCHAR,
  "fhwafunctionalclass" DOUBLE,
  "hpmssectiontype" DOUBLE,
  "id" VARCHAR,
  "iri" DOUBLE,
  "iri_date" TIMESTAMP,
  "nhscode" DOUBLE,
  "ownership" DOUBLE,
  "pci_condcategory" VARCHAR,
  "pci_lastinspected" TIMESTAMP,
  "pci_score" DOUBLE,
  "quadrant" 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,
  "streetname" VARCHAR,
  "streettype" VARCHAR,
  "subblockid" VARCHAR,
  "blockid" VARCHAR,
  "blockkey" VARCHAR,
  "dcfunctionalclass" DOUBLE,
  "nhstype" VARCHAR,
  "subblockkey" VARCHAR,
  "angle" DOUBLE,
  "directionality" VARCHAR,
  "intersectiondirection" BIGINT,
  "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,
  "rightturn_exclusive" VARCHAR,
  "leftturn_exclusive" VARCHAR,
  "hpmsid" VARCHAR,
  "buslane_outbound" VARCHAR,
  "buslane_inbound" VARCHAR,
  "fromstreet" VARCHAR,
  "tostreet" VARCHAR,
  "ward_id" BIGINT,
  "anc_id" VARCHAR,
  "smd_id" VARCHAR,
  "aadt_combination" DOUBLE,
  "aadt_combination_year" DOUBLE,
  "aadt_single_unit" DOUBLE,
  "aadt_single_unit_year" DOUBLE,
  "objectid" BIGINT,
  "shape" VARCHAR,
  "shapelen" BIGINT
);