About this Dataset

Aba Rem Polygons

This layer displays the footprint of various structures associated with mainline and is described within the descriptive text column of the feature class. It does not include pump stations, vaults, or detention systems. Data source is DWW. polygon_plgn_pv and uses the following query, (PLY_LIFECYCLE_CODE IN ('C', 'UNK', 'T', 'TBC', 'U', 'PC') And PLY_DWW_ROLE_CODE IN ('MNL', 'CONNPT', 'ENDPT', 'NONMAIN', 'SURFDRN') And PLY_DWW_FEATYPE_CODE NOT IN ('PST', 'VLT', 'WQS', 'DTS', 'DTC', 'DTL', 'PIT') And PLY_FEATYPE_CODE NOT IN ('PND', 'LIN')) Or (PLY_FEATYPE_CODE = 'MSC' And PLY_DESC_TEXT NOT LIKE '%Green Roof%' And PLY_DESC_TEXT NOT LIKE '%Modular%' And PLY_LIFECYCLE_CODE IN ('C', 'UNK', 'T', 'TBC', 'U', 'PC')). This layer does not display when zoomed out beyond 1:7,000. Labels are based on the attribute DESCRIPTION.

Refreshed daily.
Organization: City of Seattle
Last updated: 2025-02-28T23:38:50.111823
Tags: detention-systems, misc-structure, pump-station, seattle-gis-open-data, vault

Tables

Table 1

@usgov.city_of_seattle_aba_rem_polygons.table_1

33.95 kB
197 rows
23 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "fea_key" BIGINT,
  "dww_feature_key" BIGINT,
  "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,
  "width_ft" DOUBLE,
  "height_ft" DOUBLE,
  "globalid" VARCHAR,
  "shape_area" DOUBLE  -- Shape, Area,
  "shape_length" DOUBLE  -- Shape, Length
);