About this Dataset

Non-Mainline Detention Polygons

Active, proposed, abandoned and removed secondary sewer and storm pipes that are not part of the mainline system (i.e. side sewers, service drains, etc.). Side Sewers are wastewater pipes from buildings and establishments that connect to mainline pipes. Service drains are stormwater pipes from buildings that connect to mainline pipes. Probable flow is the derived use classification based on what is the best estimation of usage broken out by drainage and sanitary.

Refreshed weekly.
Organization: City of Seattle
Last updated: 2025-02-28T23:46:58.046659
Tags: aba-rem-non-mainlines, detention-lines, detention-polygons, non-mainlines, proposed-non-mainlines, seattle-gis-open-data, spu-non-mainlines

Tables

Table 1

@usgov.city_of_seattle_non_mainline_detention_polygons_40ce9.table_1

1.1 MB
13,253 rows
24 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "fea_key" BIGINT,
  "dww_feature_key" BIGINT,
  "ply_dww_feature_assetnum" DOUBLE,
  "featype" VARCHAR,
  "featype_desc" VARCHAR,
  "dww_featype" VARCHAR,
  "dww_featype_desc" VARCHAR,
  "dww_role" VARCHAR,
  "dww_role_desc" VARCHAR,
  "owner" VARCHAR,
  "owner_desc" VARCHAR,
  "lifecycle" VARCHAR,
  "lifecycle_desc" VARCHAR,
  "description" VARCHAR,
  "dww_geometry_type" VARCHAR,
  "area_sqft" DOUBLE,
  "area_acres" DOUBLE,
  "length_ft" DOUBLE,
  "width_ft" DOUBLE,
  "height_ft" DOUBLE,
  "globalid" VARCHAR,
  "shape_area" DOUBLE  -- Shape, Area,
  "shape_length" DOUBLE  -- Shape, Length
);