Urban Watercourses by US Government | Environmental and Climate Sciences

About this Dataset

Urban Watercourses

This layer displays the urban watercourses showing open stream channels and flow within culverts, drainage laterals, and drainage mainlines. The Washington State Department of Natural Resources typing code for channel and fish use and the WRIA (Washington State Department of Ecology Water Resource Inventory Area) code are included. Displays data from DWW.stream_ln_pv symbolized on the attribute FEATYPE. The layer has the following definition query, STRM_EXPIRATION_DATE IS NULL. The data will not display when zoomed out beyond 1:200,000. Labels are based on the attribute SHORT_NAME and will not display when zoomed out beyond 1:50,000.

Refreshed weekly. Maintained by DWW Maintenance staff and USM.
Organization: City of Seattle
Last updated: 2025-02-28T23:40:42.345638
Tags: dww, environmental, seattle-gis-open-data, stream, terrain, watercourse, wria

Tables

Table 1

@usgov.city_of_seattle_urban_watercourses_e338a.table_1

207.07 KB
12254 rows
23 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "strm_key" BIGINT,
  "route_key" BIGINT,
  "dww_feature_key" DOUBLE,
  "eqnum_id" DOUBLE,
  "sim_site_id" DOUBLE,
  "featype" VARCHAR,
  "featype_desc" VARCHAR,
  "typing" VARCHAR,
  "typing_desc" VARCHAR,
  "wria" VARCHAR,
  "wria_desc" VARCHAR,
  "sims_reach_code" VARCHAR,
  "stream_code" VARCHAR,
  "short_name" VARCHAR,
  "full_name" VARCHAR,
  "comments" VARCHAR,
  "rec_waterbody_name" VARCHAR,
  "length_ft" DOUBLE,
  "effective_date" VARCHAR,
  "expiration_date" VARCHAR,
  "mxm_location_key" VARCHAR,
  "shape_length" DOUBLE
);