About this Dataset

Wild And Scenic Rivers (State Designations Only) - California [ds950]

This dataset represents state designated wild, scenic, and recreational (WSR) streams per California Public Resources Code. The line segments used for this dataset were derived from the California Department of Fish and Wildlife (CDFW) "California Streams" dataset which is based on National Hydrography Dataset (NHD) High Resolution data. Information regarding the "California Streams" dataset is described in that datasets documentation. FEDERALLY DESIGNATED WSR STREAMS ARE NOT INCLUDED IN THIS DATASET.
Organization: State of California
Last updated: 2025-07-24T00:06:33.988685
Tags: california-department-of-fish-and-wildlife, cdfw, ds0950_20221202_wm, legislative-bill, public-resources-code, recreational-rivers, regulation, scenic-rivers, wild-rivers

Tables

Table 1

@usgov.ca_gov_wild_and_scenic_rivers_state_designations_only__09f8063d.table_1

426.98 kB
11,580 rows
15 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "wsr_id" BIGINT,
  "gnis_id" BIGINT,
  "gnis_name" VARCHAR,
  "designator" VARCHAR,
  "public_resources_code" VARCHAR,
  "designation_year" BIGINT,
  "designation_type" VARCHAR,
  "designation_description" VARCHAR,
  "designation_miles" DOUBLE,
  "permanent_identifier" VARCHAR,
  "reachcode" BIGINT,
  "comments" VARCHAR,
  "source" VARCHAR,
  "shape_length" DOUBLE  -- Shape, Length
);