Proposed Polygons by US Government | Demographics and Population Studies

About this Dataset

Proposed 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:39:42.764207
Tags: detention-systems, misc-structure, pump-station, seattle-gis-open-data, vault

Tables

Table 1

@usgov.city_of_seattle_proposed_polygons.table_1

23.91 KB
82 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_length" DOUBLE
);