About this Dataset

Water Services

A grouped feature layer that includes Water Mains, Water Services, Same Side Tap Only and No New Taps layers.

Water Mains are large buried pipes that distribute water from a supply source ultimately to customer's service lines.
Water Services are lines representing a water service delivered from a watermain to a property.
Same Side Tap Only and No New Taps are water main restrictions which represent the availability or access to water main assets. Same Side Tap Only are lines representing where water services are only allowed to be tapped on one side of the water main.
No New Taps are lines representing water mains where new water services are no longer permitted to tap into the water main.

This data provides a limited view of Seattle's water infrastructure. For example, the data does not include transmission pipelines or feeder mains for reasons of water system network security. The data may show water mains that are not eligible for new water service connections (e.g., obsolete or "no-tap" water mains).
Organization: City of Seattle
Last updated: 2025-02-28T23:50:49.906208
Tags: mains, no-new-taps, same-side-tap-only, seattle-gis-open-data, services, water, water-main, water-mains, water-services

Tables

Table 1

@usgov.city_of_seattle_water_services.table_1

17.27 MB
182,521 rows
68 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "svc_feakey" BIGINT,
  "eqnum" DOUBLE,
  "fea_type" VARCHAR,
  "fea_desc" VARCHAR,
  "arc_lngth" DOUBLE,
  "wmn_feakey" DOUBLE,
  "maint_code" VARCHAR,
  "maint_desc" VARCHAR,
  "owner_code" VARCHAR,
  "owner_desc" VARCHAR,
  "lifecycle" VARCHAR,
  "lfcycl_dsc" VARCHAR,
  "prsrzn_id" VARCHAR,
  "symbol" VARCHAR,
  "mpbk_sheet" VARCHAR,
  "swd_tile" DOUBLE,
  "entry_mthd" VARCHAR,
  "entmth_dsc" VARCHAR,
  "documents" VARCHAR,
  "projects" VARCHAR,
  "plans" VARCHAR,
  "map_crctns" VARCHAR,
  "lastupdate" VARCHAR,
  "install_dt" VARCHAR,
  "install_yr" DOUBLE,
  "location" VARCHAR,
  "op_status" VARCHAR,
  "mtr_eqnum" DOUBLE,
  "renewal_dt" VARCHAR,
  "retire_dt" VARCHAR,
  "material" VARCHAR,
  "mtrl_desc" VARCHAR,
  "diameter" DOUBLE,
  "tap_loc" VARCHAR,
  "tap_id" VARCHAR,
  "tap_type" VARCHAR,
  "mxmcomment" VARCHAR,
  "wmn2mtr" DOUBLE,
  "mtr2union" DOUBLE,
  "wmn_eqnum" DOUBLE,
  "psi" DOUBLE,
  "topshutoff" VARCHAR,
  "prem_svc" VARCHAR,
  "cnfndspace" VARCHAR,
  "cnfnd_dsc" VARCHAR,
  "premise_id" VARCHAR,
  "service_id" VARCHAR,
  "mtr_num" VARCHAR,
  "life_suprt" VARCHAR,
  "svc_type" VARCHAR,
  "read_instr" VARCHAR,
  "route" DOUBLE,
  "read_seq" VARCHAR,
  "acct_types" VARCHAR,
  "p_hisb_id" VARCHAR,
  "hisb_id" VARCHAR,
  "surveys" VARCHAR,
  "mxmo_wos" VARCHAR,
  "pin" VARCHAR,
  "alt_route" VARCHAR,
  "alt_reading_seq" VARCHAR,
  "amr_flag" VARCHAR,
  "uirdial_module_number_wtr1" VARCHAR,
  "uirdial_module_number_wtr2" VARCHAR,
  "uirdial_module_number_wtr3" VARCHAR,
  "mxm_wo_open" VARCHAR,
  "shape_length" DOUBLE  -- Shape, Length
);