About this Dataset

Surface Drainage Curb And Gutter

Displays the data from DWW.ditch_culvert_ln_pv with the following query, DCH_LIFECYCLE_CODE IN ( 'C' , 'UNK' , 'T', 'TBC', 'U', 'PC' ) And DCH_FEATYPE_CODE IN ( 'CDC' , 'CRB' , 'SDR' , 'UNK' ). The layer is symbolized on the attribute SYMBOL. Labels are based on the attribute DCH_OWNER_NAME. This layer will not display when zoomed out beyond 1:7,000. Maintained by SPU GIS DWW Data Maintenance staff.

Refreshed weekly.
Organization: City of Seattle
Last updated: 2025-02-28T23:36:00.457147
Tags: cdr, crb, curb, curb-drain-cut, gutter, sdr, seattle-gis-open-data, surface-drainage

Tables

Table 1

@usgov.city_of_seattle_surface_drainage_curb_and_gutter.table_1

2.84 MB
33887 rows
40 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" 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,
  "globalid" VARCHAR,
  "shape_length" DOUBLE
);