About this Dataset

Aba Rem 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:47:21.873597
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_aba_rem_non_mainlines.table_1

12.26 MB
166,687 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  -- Shape, Length
);