About this Dataset

Intersection Points

The dataset contains locations and attributes of intersections created as part of the Master Address Repository (MAR) for the Office of the Chief Technology Officer (OCTO) and participating DC government agencies. The intersection points - MAR is primarily derived from DC Department of Transportation's (DDOT) intersection table in their Street Spatial Database (SSD). Regular at-grade intersections (TYPE = 'REGULAR') as well as overpasses (TYPE = 'OVERPASS'), underpasses (TYPE = 'UNDERPASS') and ramps (TYPE = 'RAMP') are included. The overpasses, underpasses, and ramps are based on street centerlines from DDOT. More information on the MAR can be found at https://opendata.dc.gov/pages/addressing-in-dc. The data dictionary is available: https://opendata.dc.gov/documents/2a4b3d59aade43188b6d18e3811f4fd3/explore. In the MAR 2, the IntersectionPt is called INTERSECTIONS_PT and is primarily based off of street data from DC Department of Transportation's Roads & Highways database. It also features additional useful information such as created date, last edited date, begin date, and more.
Organization: District of Columbia
Last updated: 2024-04-30T18:37:16.670574
Tags: district-of-columbia, intersection, location, mar, mardata, mardistrict, master-address-repository, octo, street-address, washington-dc

Tables

Table 1

@usgov.district_of_columbia_intersection_points.table_1

1.86 MB
19,160 rows
34 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "mar_id" BIGINT,
  "name" VARCHAR,
  "x_coordinate" DOUBLE,
  "y_coordinate" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "ward" VARCHAR,
  "status" VARCHAR,
  "routeid_1" VARCHAR,
  "routeid_2" VARCHAR,
  "street_1_name" VARCHAR,
  "street_1_type" VARCHAR,
  "street_1_quadrant" VARCHAR,
  "street_1_full" VARCHAR,
  "street_2_name" VARCHAR,
  "street_2_type" VARCHAR,
  "street_2_quadrant" VARCHAR,
  "street_2_full" VARCHAR,
  "intersectionkey" VARCHAR,
  "intersection_type" VARCHAR,
  "national_grid" VARCHAR,
  "source" VARCHAR,
  "before_date" VARCHAR,
  "before_date_source" VARCHAR,
  "begin_date" VARCHAR,
  "begin_date_source" VARCHAR,
  "first_known_date" VARCHAR,
  "first_known_date_source" VARCHAR,
  "created_date" TIMESTAMP,
  "last_edited_date" TIMESTAMP,
  "metadata_id" BIGINT
);