About this Dataset

Roadway SubBlock 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-30T17:40:18.705450
Tags: dc, district-of-columbia, intersection, transportation, washington

Tables

Table 1

@usgov.district_of_columbia_roadway_subblock_intersection.table_1

2.12 MB
20,275 rows
10 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "intersectionid" VARCHAR,
  "routeid" VARCHAR,
  "measure" DOUBLE,
  "intersectionname" VARCHAR,
  "grade" DOUBLE,
  "intersectionkey" VARCHAR,
  "acisa" VARCHAR,
  "objectid" BIGINT
);