About this Dataset

Aba Rem Surface Drainage Points

Surface drainage points are structures that help direct rainwater in the City’s sub-surface pipe drainage system. The informal drainage system makes up nearly one-third of the City of Seattle footprint. This layer displays connected surface drainage points, regardless of ownership, that cannot be found in other layers. For example, Catch Basins, Junction Boxes, Sandboxes, and Inlets are not included. The data source is DWW.surface_drainline_pt_pv with the following data query: SDP_LIFECYCLE_TEXT IN ( 'Connected' , 'Unknown' , 'Temporary' ,'To Be Connected', 'Under Construction', 'Provisionally Connected', 'Proposed', 'Abandoned', 'Abandoned Temporary', 'Removed') AND SDP_FEA_TYPE_TEXT IN ( 'Area Drain;Area Way;Driveway Drain' ,'Cleanout', 'Flow Control MH' , 'Infall' , 'Maintenance Hole' , 'Overflow MH' , 'Other' , 'Rubber Coupler' , 'Reducer' , 'Surface Cleanout' , 'Sedimentation Chamber;Sand Catcher;Sand Trap' , 'Stand Pipe' , 'Weephole', 'Catch Basin MH', 'Vault', 'Underground Injection Cell; Drilled Drain')

This layer does not display when zoomed out beyond 1:2,000. Labels are based on the attribute SDP_ASSET_ID and only display when zoomed in to 1:1,000 or closer. Only SPU owned assets will have a label.

Refreshed weekly.
Organization: City of Seattle
Last updated: 2025-02-28T23:46:42.756031
Tags: area-drain, area-way, catch-basin-mh, cleanout, driveway-drain, flow-control-mh, infall, maintenance-hole, outfall, overflow-mh, seattle-gis-open-data, sedimentations-chambersand-catchersand-trap, stand-pipe, surface-cleanout, surface-drainage-points, underground-injection-cell-drilled-drain, vault, weephole

Tables

Table 1

@usgov.city_of_seattle_aba_rem_surface_drainage_points.table_1

26.15 KB
112 rows
21 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "sdp_fea_key" BIGINT,
  "sdp_assetnum" DOUBLE,
  "sdp_map_area_id" BIGINT,
  "sdp_lctn_id" VARCHAR,
  "sdp_rc_wtrbdy_name" VARCHAR,
  "sdp_gsip_key" VARCHAR,
  "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" DOUBLE,
  "sdp_depth_ref_text" VARCHAR,
  "sdp_depth_ft_nbr" DOUBLE,
  "sdp_install_date" VARCHAR,
  "sdp_retire_date" VARCHAR,
  "sdp_lst_updt_date" VARCHAR,
  "globalid" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);