SPU DWW Aba Rem Ditches And Culverts by US Government | Demographics and Population Studies

About this Dataset

SPU DWW Aba Rem 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:47:21.894205
Tags: culvert, ditch, dww, public-utility, seattle-gis-open-data, surface-drainline

Tables

Table 1

@usgov.city_of_seattle_spu_dww_aba_rem_ditches_and_culverts.table_1

214.48 KB
2794 rows
39 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "fea_key" BIGINT,
  "grph" DOUBLE,
  "ups_feature_key" DOUBLE,
  "dns_feature_key" DOUBLE,
  "assetnum" DOUBLE,
  "map_area_id" VARCHAR,
  "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
);