About this Dataset

Non-Mainline Detention Lines

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:47:53.788059
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_lines.table_1

545.43 KB
6142 rows
37 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "fea_key" BIGINT,
  "ups_feature_key" BIGINT,
  "dns_feature_key" BIGINT,
  "assetnum" DOUBLE,
  "map_area_id" VARCHAR,
  "featype" VARCHAR,
  "featype_desc" VARCHAR,
  "owner" VARCHAR,
  "owner_desc" VARCHAR,
  "prbl_flow" VARCHAR,
  "prbl_flow_desc" VARCHAR,
  "material_code" VARCHAR,
  "material_desc" VARCHAR,
  "pipe_shp" VARCHAR,
  "pipe_shp_desc" VARCHAR,
  "lifecycle" VARCHAR,
  "lifecycle_desc" VARCHAR,
  "destination_type" VARCHAR,
  "inspect_flag" VARCHAR,
  "pump_flag" VARCHAR,
  "casing_flag" VARCHAR,
  "perf_pipe_flag" VARCHAR,
  "length_ft" DOUBLE,
  "width_in" DOUBLE,
  "height_in" DOUBLE,
  "ups_elev_ft" DOUBLE,
  "dns_elev_ft" DOUBLE,
  "prbl_flow_symbol" VARCHAR,
  "symbol" BIGINT,
  "install_date" VARCHAR,
  "retire_date" VARCHAR,
  "stream_name" VARCHAR,
  "lining_flag" VARCHAR,
  "nmnl_updt_trans_type" VARCHAR,
  "globalid" VARCHAR,
  "shape_length" DOUBLE
);