About this Dataset

Stream Habitat Reach Summary - Russian River [ds77]

Results of in-stream habitat surveys (Downie et al 1998 method), summarized by stream reach, for DFG surveys conducted between 1994 and 2001 (inclusive) in the Russian River Basin (CalWater 2.2.1 hydrologic area), Central Coast Region. Sampled habitat parameters, including pool type, frequency and depth; substrate class; bank vegetation composition and canopy closure; and in-stream cover, were measured at the unit scale and summarized to stream reach.
Organization: State of California
Last updated: 2025-07-23T22:20:32.534300
Tags: auth_cdfw, california-department-of-fish-and-wildlife, california-natural-resources-agency, caopendata, cdfw, ds0077_20041109_wm, fish, habitat-attributes, inventory, management, planning, vegetation

Tables

Table 1

@usgov.ca_gov_stream_habitat_reach_summary_russian_river_ds77_c5b92.table_1

185.16 kB
557 rows
64 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "reachid" VARCHAR,
  "count" BIGINT,
  "first_pnam" VARCHAR,
  "first_pnmc" VARCHAR,
  "first_surv" VARCHAR,
  "max_date" TIMESTAMP,
  "first_reac" BIGINT,
  "sum_length" DOUBLE,
  "first_re_1" BIGINT,
  "embed34" DOUBLE,
  "length" DOUBLE,
  "stream" VARCHAR,
  "reach" BIGINT,
  "st_unit" DOUBLE,
  "end_unit" DOUBLE,
  "chan_typ" VARCHAR,
  "chan_len" BIGINT,
  "side_len" BIGINT,
  "rf_fl_wdth" DOUBLE,
  "pool_dpth" DOUBLE,
  "flow" DOUBLE,
  "lwater" BIGINT,
  "uwater" BIGINT,
  "lair" BIGINT,
  "uair" BIGINT,
  "dom_bk_veg" VARCHAR,
  "veg_cov" DOUBLE,
  "dom_bk_sub" VARCHAR,
  "emb_one" DOUBLE,
  "emb_two" DOUBLE,
  "emb_three" DOUBLE,
  "emb_four" DOUBLE,
  "canopy" DOUBLE,
  "conif" DOUBLE,
  "decid" DOUBLE,
  "pct_pls_ln" DOUBLE,
  "pools_2ft" DOUBLE,
  "pools_3ft" DOUBLE,
  "pol_sh_rtn" DOUBLE,
  "dom_shel" VARCHAR,
  "lod" DOUBLE,
  "dry" DOUBLE,
  "wet" DOUBLE,
  "rf_fl_mean" DOUBLE,
  "pool_area" DOUBLE,
  "cov_under" DOUBLE,
  "cov_swood" DOUBLE,
  "cov_lwood" DOUBLE,
  "cov_root" DOUBLE,
  "cov_tveg" DOUBLE,
  "cov_aveg" DOUBLE,
  "cov_water" DOUBLE,
  "cov_bould" DOUBLE,
  "cov_bed" DOUBLE,
  "lwd_pools" BIGINT,
  "prob_lwdp" BIGINT,
  "pot_lwdp" BIGINT,
  "part_lwdp" DOUBLE,
  "pname" VARCHAR,
  "pnmcd" VARCHAR,
  "reachid_1" VARCHAR,
  "year" DOUBLE,
  "shape_length" DOUBLE  -- Shape, Length
);