Stream Habitat Reach Summary - Russian River [ds77] by US Government | Environmental and Climate Sciences

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: 2024-03-30T01:54:21.686763
Tags: authcdfw, california-department-of-fish-and-wildlife, california-natural-resources-agency, caopendata, cdfw, ds007720041109wm, fish, habitat-attributes, inventory, management, planning, vegetation

Tables

Table 1

@usgov.ca_gov_stream_habitat_reach_summary_russian_river_ds77_8ccd7.table_1

180.82 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
);