About this Dataset

Surface Drainage Points

This layer contains both connected and proposed underground injection cells, symbolized on lifecycle code.

Underground Injection Cells data source is DWW.surface_drainline_pt_pv with the following data query: SDP_FEA_TYPE_TEXT IS 'Underground Injection Cell; Drilled Drain') and SDP_OWNER_TEXT IS 'Seattle Public Utilities'.

Proposed Underground injection cells data source is DWW.surface_drainline_pt_pv with the following data query: SDP_LIFECYCLE_TEXT IN ('Proposed') AND SDP_FEA_TYPE_TEXT IS 'Underground Injection Cell; Drilled Drain' AND SDP_OWNER_TEXT IS 'Seattle Public Utilities'.

Labels are based on the attribute SDP_ASSET_ID and do not display when zoomed out beyond 1:1,000. Only SPU owned assets will display labels.

Refreshed weekly.
Organization: City of Seattle
Last updated: 2025-10-25T21:42:39.958492
Tags: seattle-gis-open-data, surface-drainage-points, underground-injection-cell-drilled-drain

Tables

Table 1

@usgov.city_of_seattle_surface_drainage_points_d0d29.table_1

18.39 kB
32 rows
21 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "sdp_fea_key" BIGINT,
  "sdp_assetnum" BIGINT,
  "sdp_map_area_id" BIGINT,
  "sdp_lctn_id" VARCHAR,
  "sdp_rc_wtrbdy_name" VARCHAR,
  "sdp_gsip_key" DOUBLE,
  "sdp_gsip_name" VARCHAR,
  "sdp_fea_type_text" VARCHAR,
  "sdp_owner_text" VARCHAR,
  "sdp_lifecycle_text" VARCHAR,
  "sdp_srfc_elev_ref_text" VARCHAR,
  "sdp_srfc_elev_ft_nbr" BIGINT,
  "sdp_depth_ref_text" VARCHAR,
  "sdp_depth_ft_nbr" BIGINT,
  "sdp_install_date" VARCHAR,
  "sdp_retire_date" VARCHAR,
  "sdp_lst_updt_date" VARCHAR,
  "globalid" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);