About this Dataset

Street Segments 2005

Street Centerline Segments 2005. A single line representing each street in the District, segmented at major blocks to preserve geocoding integrity. 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 only the major road types: street centerline. This layer contains complete theoretical address ranges.
Organization: District of Columbia
Last updated: 2024-04-30T17:42:07.120147
Tags: district-of-columbia, planimetrichistoric, planimetrics, pmetric05, street-segments

Tables

Table 1

@usgov.district_of_columbia_street_segments_2005.table_1

1.49 MB
33,915 rows
37 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "roadwaysegid" BIGINT,
  "streetid" DOUBLE,
  "sourceid" DOUBLE,
  "roadtype" VARCHAR,
  "stcode" DOUBLE,
  "sttypeid" DOUBLE,
  "quadcode" BIGINT,
  "stname" VARCHAR,
  "registeredname" VARCHAR,
  "streettype" VARCHAR,
  "usps_abbrev" VARCHAR,
  "isalias" VARCHAR,
  "description" VARCHAR,
  "quadrant" VARCHAR,
  "directionality" VARCHAR,
  "ownership" VARCHAR,
  "nhs" DOUBLE,
  "functionalclass" VARCHAR,
  "fromleftaddress" DOUBLE,
  "toleftaddress" DOUBLE,
  "fromrightaddress" DOUBLE,
  "torightaddress" DOUBLE,
  "leftzipcode" VARCHAR,
  "rightzipcode" VARCHAR,
  "fromlefttheoreticrange" DOUBLE,
  "tolefttheoreticrange" DOUBLE,
  "fromrighttheoreticrange" DOUBLE,
  "torighttheoreticrange" DOUBLE,
  "lifecyclestatus" VARCHAR,
  "inservicedate" TIMESTAMP,
  "outofservicedate" VARCHAR,
  "updatetimestamp" TIMESTAMP,
  "status" VARCHAR,
  "abbreviation" VARCHAR,
  "st_name" VARCHAR,
  "shapelen" BIGINT
);