About this Dataset

SPU DWW Mainline End Points

SPU DWW Mainline Points is a Group Layer containing all Lifecycles, Ownerships, and other variations of Drainage and Wastewater Mainlines Points.

Proposed Mainline End Points are planned but not yet installed or as-built.

SPU DWW Aba Rem Mainline End Points refers to Abandoned and Removed Mainline End Points.

Force Mainline End Points are Mainline End Points under pressure. Detention Lines and Polygons refer to Mainline End Points for Detention Infrastructure.

DWW Mainline Connection Points Wyes refer to side sewer and lateral connection points on mainlines.

The data is refreshed weekly and is maintained by the SPU GIS Data Maintenance Team.
Organization: City of Seattle
Last updated: 2025-02-28T23:39:38.754847
Tags: dww, endpoints, external, mainline, points, seattle-gis-open-data, sewer, spu

Tables

Table 1

@usgov.city_of_seattle_spu_dww_mainline_end_points_952e1.table_1

5.64 MB
65688 rows
40 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "mnlep_fea_key" BIGINT,
  "mnlep_eqnum_id" DOUBLE,
  "mnlep_s_endpt_id" VARCHAR,
  "mnlep_d_endpt_id" VARCHAR,
  "mnlep_npdes_id" VARCHAR,
  "mnlep_pmp_stn_id" VARCHAR,
  "mnlep_cb_id" VARCHAR,
  "mnlep_outfall_id" DOUBLE,
  "mnlep_map_area_id" VARCHAR,
  "mnlep_cso_desc" VARCHAR,
  "mnlep_featype_code" VARCHAR,
  "mnlep_featype_text" VARCHAR,
  "mnlep_owner_code" VARCHAR,
  "mnlep_owner_name" VARCHAR,
  "mnlep_lifecycle_code" VARCHAR,
  "mnlep_lifecycle_stat" VARCHAR,
  "mnlep_depth_ref_code" VARCHAR,
  "mnlep_depth_ref_text" VARCHAR,
  "mnlep_cvr_elev_ref_code" VARCHAR,
  "mnlep_cvr_elev_ref_text" VARCHAR,
  "mnlep_frcd_mn_flag" VARCHAR,
  "mnlep_depth_ft_nbr" DOUBLE,
  "mnlep_cvr_elev_ft_nbr" DOUBLE,
  "mnlep_elev1_ft_nbr" DOUBLE,
  "mnlep_elev2_ft_nbr" DOUBLE,
  "mnlep_elev3_ft_nbr" DOUBLE,
  "mnlep_elev4_ft_nbr" DOUBLE,
  "mnlep_rotation_nbr" DOUBLE,
  "mnlep_sym_num" DOUBLE,
  "mnlep_install_date" TIMESTAMP,
  "mnlep_retire_date" TIMESTAMP,
  "mnlep_lst_updt_date" TIMESTAMP,
  "mnlep_x_coord" DOUBLE,
  "mnlep_y_coord" DOUBLE,
  "mnlep_mxm_adrs_text" VARCHAR,
  "mnlep_cso_id" VARCHAR,
  "mnlep_cso_flw_mntr_flag" VARCHAR
);