About this Dataset

SPU DWW Proposed Ditches And Culverts

Ditches are small to moderate depressions that are created to channel water. Culverts are pipes that are open on both ends that conduct water under a road or railway.

Displays data from the feature class DWW.ditch_culvert_ln_pv, SPU DWW Ditches and Culverts uses the following query: (DCH_LIFECYCLE_CODE IN ( 'C' , 'UNK' , 'T', 'TBC', 'U', 'PC') AND DCH_FEATYPE_CODE IN( 'DCH' , 'CUL' ,'PHM'). SPU DWW Proposed Ditches and Culverts uses the following query: DCH_LIFECYCLE_CODE = 'PRO' And DCH_FEATYPE_CODE IN ('DCH', 'CUL', 'PHM'). SPU DWW Aba Rem Ditches and Culverts has the following query: DCH_LIFECYCLE_CODE IN ('A', 'R', 'AT'). This layer does not display when zoomed out beyond 1:7,000. Labels do not display when zoomed out beyond 1:4800. Label is based on the attribute DCH_OWNER_CODE. Maintained by SPU GIS DWW Data Maintenance staff.

Refreshed weekly.
Organization: City of Seattle
Last updated: 2025-02-28T23:30:41.926397
Tags: culvert, ditch, dww, public-utility, seattle-gis-open-data, surface-drainline

Tables

Table 1

@usgov.city_of_seattle_spu_dww_proposed_ditches_and_culverts.table_1

40.24 kB
237 rows
39 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "fea_key" BIGINT,
  "grph" DOUBLE,
  "ups_feature_key" BIGINT,
  "dns_feature_key" BIGINT,
  "assetnum" DOUBLE,
  "map_area_id" BIGINT,
  "featype" VARCHAR,
  "featype_desc" VARCHAR,
  "owner" VARCHAR,
  "dch_owner_name" VARCHAR,
  "prbl_flow" VARCHAR,
  "prbl_flow_desc" VARCHAR,
  "material_code" VARCHAR,
  "dch_material_type" VARCHAR,
  "pipe_shape" VARCHAR,
  "pipe_shape_desc" VARCHAR,
  "lifecycle" VARCHAR,
  "dch_lifecycle_stat" VARCHAR,
  "destination_type" VARCHAR,
  "inspect_flag" VARCHAR,
  "casing_flag" VARCHAR,
  "perf_pipe_flag" VARCHAR,
  "mapset_flag" VARCHAR,
  "length_ft" DOUBLE,
  "width_in" DOUBLE,
  "height_in" DOUBLE,
  "ups_elev_ft" DOUBLE,
  "dns_elev_ft" DOUBLE,
  "prbl_flow_symbol" VARCHAR,
  "symbol" BIGINT,
  "install_date" VARCHAR,
  "retire_date" VARCHAR,
  "last_update_date" VARCHAR,
  "stream_name" VARCHAR,
  "gsi_prjct_name" VARCHAR,
  "lctn_id" VARCHAR,
  "dch_lining_flag" VARCHAR,
  "shape_length" DOUBLE  -- Shape, Length
);