About this Dataset

Street Centerlines 2005

Street Centerlines 2005. 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. This layer contains complete theoretical address ranges.
Organization: District of Columbia
Last updated: 2024-04-30T18:09:36.424884
Tags: district-of-columbia, planimetrichistoric, planimetrics, pmetric05, street-centerline, washington-dc

Tables

Table 1

@usgov.district_of_columbia_street_centerlines_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
);