Wild And Scenic Rivers (State Designations Only) - California [ds950] by US Government | Environmental and Climate Sciences

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: 2024-03-30T02:34:57.683415
Tags: california-department-of-fish-and-wildlife, cdfw, ds095020221202wm, 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__148c01b4.table_1

416.97 KB
11580 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
);