Non-SPU Owned Non-Mainlines by US Government | Demographics and Population Studies

About this Dataset

Non-SPU Owned Non-Mainlines

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:21:02.176901
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_spu_owned_non_mainlines.table_1

103.89 MB
1900912 rows
37 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "fea_key" BIGINT,
  "ups_feature_key" DOUBLE,
  "dns_feature_key" DOUBLE,
  "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
);