Aba Rem Non-Mainline Points by US Government | Demographics and Population Studies

About this Dataset

Aba Rem Non-Mainline Points

This layer displays all the connected and to be connected non-mainline points within the City of Seattle (and the former service area north of the City limits) regardless of ownership. The data source is DWW.non_mainline_pt_pv with the following data query, NMNLPT_LIFECYCLE_CODE IN( 'C' , 'UNK' , 'T' ,'TBC', 'U', 'PC') AND NMNLPT_FEATYPE_CODE <> 'WQS'. The layer is symbolized on the attribute FEATYPE. The labels are based on the attribute FEATYPE. This layer does not display when zoomed out beyond 1:899. Maintained by SPU GIS DWW Data Maintenance staff.

Refreshed weekly.
Organization: City of Seattle
Last updated: 2025-02-28T23:38:32.587662
Tags: catch-basin, downspouts, inlets, junction-point, lateral-points, nodes, seattle-gis-open-data, side-sewer-points, stack-plumbing, wyes

Tables

Table 1

@usgov.city_of_seattle_aba_rem_non_mainline_points.table_1

12.92 MB
161134 rows
27 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "fea_key" BIGINT,
  "featype" VARCHAR,
  "featype_desc" VARCHAR,
  "owner" VARCHAR,
  "nmnlpt_owner_name" VARCHAR,
  "lifecycle" VARCHAR,
  "nmnlpt_lifecycle_stat" VARCHAR,
  "cvr_elev_ref" VARCHAR,
  "cvr_elev_ref_desc" VARCHAR,
  "depth_ref" VARCHAR,
  "depth_ref_desc" VARCHAR,
  "nmnlpt_frcd_mn_flag" VARCHAR,
  "depth_ft" DOUBLE,
  "cvr_elev_ft" DOUBLE,
  "dist_ll_mh" DOUBLE,
  "dist_lr_mh" DOUBLE,
  "dist_ur_mh" DOUBLE,
  "dist_ul_mh" DOUBLE,
  "rotation" DOUBLE,
  "symbol" BIGINT,
  "junpt_mnl_feature_key" DOUBLE,
  "junpt_grph_key" DOUBLE,
  "junpt_role_code" VARCHAR,
  "globalid" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);