About this Dataset

Street Right Of Way

Roadway SubBlocks - Right of Way Information. A single line, segmented at all intersections (alley and others), representing each street in the District. They follow the general trend of the street and do not deviate due to parking lanes, turning lanes, etc. and contain address ranges for geocoding. The street GIS database includes five different street road types: street centerline, alley, drive, ramp and service road. All DC GIS data is stored and exported in Maryland State Plane coordinates NAD 83 meters. This layer contains complete theoretical address ranges.
Organization: District of Columbia
Last updated: 2024-04-30T19:20:19.253427
Tags: block, right-of-way, roadway, street-centerline, subblock, transportation

Tables

Table 1

@usgov.district_of_columbia_street_right_of_way.table_1

3.41 MB
33,773 rows
45 columns

CREATE TABLE table_1 (
  "roadwaysegid" BIGINT,
  "stcode" DOUBLE,
  "quadrant" VARCHAR,
  "directionality" VARCHAR,
  "ownership" VARCHAR,
  "nhstype" VARCHAR,
  "functionalclass" VARCHAR,
  "lifecyclestatus" VARCHAR,
  "st_name" VARCHAR,
  "row_total" DOUBLE,
  "row_roadway" DOUBLE,
  "row_sidewalk1" DOUBLE,
  "row_sidewalk1_ft" DOUBLE,
  "row_sidewalk2" DOUBLE,
  "row_sidewalk2_ft" DOUBLE,
  "row_parking1" DOUBLE,
  "row_parking1_ft" DOUBLE,
  "row_parking2" DOUBLE,
  "row_parking2_ft" DOUBLE,
  "row_servrd1" DOUBLE,
  "row_servrd1_ft" DOUBLE,
  "row_servrd2" DOUBLE,
  "row_servrd2_ft" DOUBLE,
  "row_treespace1" DOUBLE,
  "row_tree1_ft" VARCHAR,
  "row_treespace2" VARCHAR,
  "row_tree2_ft" VARCHAR,
  "row_island1" DOUBLE,
  "row_island1_ft" DOUBLE,
  "row_island2" DOUBLE,
  "row_island2_ft" DOUBLE,
  "variable" DOUBLE,
  "hyperlink" VARCHAR,
  "issue" DOUBLE,
  "issue_desc" VARCHAR,
  "objectid" BIGINT,
  "shapelen" BIGINT,
  "se_anno_cad_data" VARCHAR,
  "gis_id" VARCHAR,
  "globalid" VARCHAR,
  "creator" VARCHAR,
  "created" TIMESTAMP,
  "editor" VARCHAR,
  "edited" TIMESTAMP,
  "subblockkey" VARCHAR
);