California Native Fish Species By Watershed [ds1353] Extended Table
State of California
@usgov.ca_gov_california_native_fish_species_by_watershed_ds1_0a10366e
Loading...
Loading...
Loading...
Loading...
About this Dataset
California Native Fish Species By Watershed [ds1353] Extended Table
This dataset was created using the 123 PISCES extant species range layers listed below in the table.
The PISCES datasets were converted to rasters using GIS and then map algebra was used to calculate the total number of species in each huc12 watershed. Using GIS, an extended table was created to provide species lists by watershed using a one to many table relate.
Species presence data was provided by PISCES: Moyle, Quinones and Bell (direct addition), Moyle and Randall (gstpoly), . These layers were generated by PISCES on 10/30/2014. The datasets listed in the table below were used in this analysis.
| Pisces_Code | Common_Name |
|---|---|
| AAM01 | Northern Green Sturgeon |
| AAT01 | White sturgeon |
| CCF01 | Owens Sucker |
| CCO02 | Goose Lake Sucker |
| CCS01 | Klamath Largescale Sucker |
| CCA03 | Clear Lake Prickly Sculpin |
| CCG01 | Riffle Sculpin |
| CCK03 | Upper Klamath Marbled Sculpin |
| CCK01 | Bigeye Marbled Sculpin |
| CCK02 | Lower Klamath Marbled Sculpin |
| CCN02 | Amargosa River Pupfish |
| CCN01 | Saratoga Springs Pupfish |
| CCN04 | Shoshone Pupfish |
| CCS03 | Salt Creek Pupfish |
| PEF01 | Northern California Brook Lamprey |
| PES01 | Klamath River Lamprey |
| PET02 | Goose Lake Lamprey |
| PET01 | Pacific Lamprey |
| CGC01 | Blue Chub |
| CGO01 | Arroyo Chub |
| EHT03 | Clear Lake Tule Perch |
| EHT02 | Russian River Tule Perch |
| EHT01 | Sacramento Tule Perch |
| PLH01 | Kern Brook Lamprey |
| PLL01 | Pit-Klamath Brook Lamprey |
| PLR01 | Western Brook Lamprey |
| CLE01 | Sacramento Hitch |
| CLE03 | Monterey Hitch |
| CLP01 | Gualala Roach |
| CLS06 | Navarro Roach |
| CLS05 | Monterey Roach |
| CLS04 | Clear Lake Roach |
| CLS02 | Red Hills Roach |
| CLS03 | Russian River Roach |
| CLS07 | Tomales Roach |
| CLS01 | Central California Roach |
| CMC01 | HardHead |
| SOC01 | Coastal Cutthroat Trout |
| SOM03 | Klamath Mountains Province Winter Steelhead |
| SOM04 | Klamath Mountains Province Summer Steelhead |
| SOM14 | California Golden Trout |
| SOM12 | Eagle Lake Rainbow Trout |
| SOM13 | Kern River Rainbow Trout |
| SOM10 | McCloud River Redband Trout |
| SOM11 | Goose Lake Redband Trout |
| SOT08 | Central Valley Fall Chinook Salmon |
| SOT07 | Central Valley Late Fall Chinook Salmon |
| SOT03 | Southern Oregon Northern California Coast Fall Chinook Salmon |
| SOT01 | Upper Klamath-Trinity Fall Chinook Salmon |
| SOT02 | Upper Klamath-Trinity Spring Chinook Salmon |
| CCP01 | Lahontan Mountain Sucker |
| CPM01 | Sacramento Splittail |
| SPW01 | Mountain Whitefish |
| CRO06 | Amargosa Canyon Speckled Dace |
| CRO05 | Long Valley Speckled Dace |
| CRO04 | Owens Speckled Dace |
| CRO07 | Santa Ana Speckled Dace |
| CSB03 | Lahontan Lake Tui Chub |
| CSB05 | Eagle Lake Tui Chub |
| CST01 | Goose Lake Tui Chub |
| CST03 | Cow Head Tui Chub |
| AAM02 | Southern Green Sturgeon |
| CCL01 | Lost River Sucker |
| CCM01 | Modoc Sucker |
| CCO04 | Humboldt Sucker |
| CCO03 | Monterey Sucker |
| CCO01 | Sacramento Sucker |
| CCR01 | Klamath Smallscale Sucker |
| CCS02 | Santa Ana Sucker |
| CCT01 | Tahoe Sucker |
| CCB01 | Shortnose Sucker |
| CCA04 | Coastrange Sculpin |
| CCA02 | Prickly Sculpin |
| CCA01 | Rough Sculpin |
| CCB02 | Paiute Sculpin |
| CCP03 | Reticulate Sculpin |
| CCP02 | Pit Sculpin |
| CCM02 | Desert Pupfish |
| CCR02 | Owens Pupfish |
| CCS04 | Cottonball Marsh Pupfish |
| GEN01 | Tidewater Goby |
| CFP01 | California Killfish |
| GGA01 | Coastal Threespine Stickleback |
| GGA02 | Inland Threespine Stickleback |
| GGA04 | Santa Ana (Shay Creek) Stickleback |
| GGA03 | Unarmored Threespine Stickleback |
| OHP01 | Delta Smelt |
| PLA01 | River Lamprey |
| CLE02 | Clear Lake Hitch |
| CLS08 | Northern (Pit) Roach |
| CLA01 | Staghorn Sculpin |
| MMC02 | Striped Mullet |
| SOC03 | Lahontan Cutthroat Trout |
| SOC02 | Paiute Cutthroat Trout |
| SOG01 | Pink Salmon |
| SOK03 | Chum Salmon |
| SOK01 | Central Coast Coho Salmon |
| SOK02 | Southern Oregon Northern California Coast Coho Salmon |
| SOM05 | Central California Coast Winter Steelhead |
| SOM06 | Central Valley Steelhead |
| SOM02 | Northern California Coast Summer Steelhead |
| SOM01 | Northern California Coast Winter Steelhead |
| SOM07 | South Central California Coast Steelhead |
| SOM08 | Southern California Steelhead |
| SOM09 | Coastal Rainbow Trout |
| SOM15 | Little Kern Golden Trout |
| SOT04 | California Coast Fall Chinook Salmon |
| SOT06 | Central Valley Spring Chinook Salmon |
| SOT05 | Central Valley Winter Chinook Salmon |
| COM01 | Sacramento Blackfish |
| PPS01 | Starry Flounder |
| CPG01 | Sacramento Pikeminnow |
| CRO03 | Klamath Speckled Dace |
| CRO02 | Lahontan Speckled Dace |
| CRO01 | Sacramento Speckled Dace |
| CRE01 | Lahontan Redside |
| CSB01 | Klamath Tui Chub |
| CSB04 | Lahontan Stream Tui Chub |
| CSB06 | Owens Tui Chub |
| CST02 | Pit River Tui Chub |
| OST01 | Longfin Smelt |
| OTP01 | Eulachon |
| CXT01 | Razorback Sucker |
| Organization: State of California | |
| Last updated: 2025-07-23T20:47:38.383385 | |
| Tags: boundaries, california-department-of-fish-and-wildlife, cdfw, environment, huc12, huc_12, hucs, inlandwaters, pisces, range, watershed |
Tables
Table 1
@usgov.ca_gov_california_native_fish_species_by_watershed_ds1_0a10366e.table_1
- 164.98 kB
- 18,778 rows
- 9 columns
Loading...
Loading...
CREATE TABLE table_1 (
"objectid" BIGINT,
"huc12_num" BIGINT,
"pisces_code" VARCHAR,
"common_name" VARCHAR,
"scientific_name" VARCHAR,
"bios_link" VARCHAR,
"state_federallylisted" VARCHAR,
"listingstatus" VARCHAR,
"esu_dps" VARCHAR
);