About this Dataset

SPU DWW Vaults

This layer displays the location of vaults associated with mainlines and is described within the descriptive text column of the feature class. The graphic is not a footprint of the physical structure. Data source is DWW.polygon_plgn_pv with the following query, PLY_LIFECYCLE_CODE IN ('C', 'UNK', 'T', 'TBC', 'U', 'PC') and PLY_DWW_ROLE_CODE in ('CONNPT', 'ENDPT') and (PLY_FEATYPE_CODE = 'VLT' or PLY_DWW_FEATYPE_CODE in ('DTS', 'VLT')). It is symbolized on the attribute DWW_FEATYPE_DESC. This layer does not display when zoomed out beyond 1:7,000. Labels are based on the attribute DESCRIPTION and do not display when zoomed out beyond 1:2,000.

Maintained by SPU GIS DWW Data Maintenance staff.

Refreshed weekly.
Organization: City of Seattle
Last updated: 2025-02-28T23:44:11.501183
Tags: detention-tank, dts, seattle-gis-open-data, vault, vlt

Tables

Table 1

@usgov.city_of_seattle_spu_dww_vaults.table_1

48.99 kB
334 rows
25 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "fea_key" BIGINT,
  "dww_feature_key" BIGINT,
  "assetnum" DOUBLE,
  "featype" VARCHAR,
  "featype_desc" VARCHAR,
  "dww_featype" VARCHAR,
  "dww_featype_desc" VARCHAR,
  "dww_role" VARCHAR,
  "dww_role_desc" VARCHAR,
  "owner" VARCHAR,
  "owner_desc" VARCHAR,
  "lifecycle" VARCHAR,
  "lifecycle_desc" VARCHAR,
  "description" VARCHAR,
  "dww_geometry_type" VARCHAR,
  "area_sqft" DOUBLE,
  "area_acres" DOUBLE,
  "length_ft" DOUBLE,
  "dww_polygon_plgn_pv_se_anno_cad_data" VARCHAR,
  "width_ft" DOUBLE,
  "height_ft" DOUBLE,
  "globalid" VARCHAR,
  "shape_area" DOUBLE  -- Shape, Area,
  "shape_length" DOUBLE  -- Shape, Length
);