About this Dataset

DWW Mainline Connection Points Wyes

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:40:24.797762
Tags: dww, endpoints, external, mainline, points, seattle-gis-open-data, sewer, spu

Tables

Table 1

@usgov.city_of_seattle_dww_mainline_connection_points_wyes_24fd2.table_1

15.05 MB
328119 rows
29 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "mnlcp_fea_key" BIGINT,
  "mnlcp_mnl_feature_key" DOUBLE,
  "mnlcp_map_area_id" VARCHAR,
  "mnlcp_featype_code" VARCHAR,
  "mnlcp_featype_text" VARCHAR,
  "mnlcp_owner_code" VARCHAR,
  "mnlcp_owner_name" VARCHAR,
  "mnlcp_lifecycle_code" VARCHAR,
  "mnlcp_lifecycle_stat" VARCHAR,
  "mnlcp_depth_ref_code" VARCHAR,
  "mnlcp_depth_ref_text" VARCHAR,
  "mnlcp_cvr_elev_ref_code" VARCHAR,
  "mnlcp_cvr_elev_ref_text" VARCHAR,
  "mnlcp_frcd_mn_flag" VARCHAR,
  "mnlcp_depth_ft_nbr" DOUBLE,
  "mnlcp_cvr_elev_ft_nbr" DOUBLE,
  "mnlcp_dist_ll_mh_nbr" DOUBLE,
  "mnlcp_dist_lr_mh_nbr" DOUBLE,
  "mnlcp_dist_ur_mh_nbr" DOUBLE,
  "mnlcp_dist_ul_mh_nbr" DOUBLE,
  "mnlcp_rotation_nbr" BIGINT,
  "mnlcp_sym_num" DOUBLE,
  "mnlcp_install_date" TIMESTAMP,
  "mnlcp_retire_date" TIMESTAMP,
  "mnlcp_lst_updt_date" TIMESTAMP,
  "se_anno_cad_data" VARCHAR
);