Proposed Non-Mainline Points
City of Seattle
@usgov.city_of_seattle_proposed_non_mainline_points
City of Seattle
@usgov.city_of_seattle_proposed_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:39:01.195246
Tags: catch-basin, downspouts, inlets, junction-point, lateral-points, nodes, seattle-gis-open-data, side-sewer-points, stack-plumbing, wyes
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" BIGINT,
"symbol" BIGINT,
"junpt_mnl_feature_key" DOUBLE,
"junpt_grph_key" BIGINT,
"junpt_role_code" VARCHAR,
"globalid" VARCHAR,
"x" DOUBLE,
"y" DOUBLE
);Anyone who has the link will be able to view this.