18499 Juvenile Salmonid Trophic Data (Ocean Survival of Salmonids) Data Set Published / External 17697 FE (Fish Ecology) Division Project In Work 1998-06-01 2017-03-20 FY20 will mark the 23nd year of sampling, making the Juvenile Salmon and Ocean Ecosystem Survey (JSOES) the longest running salmon survey on the west coast. JSOES has clearly demonstrated correlations between ocean conditions and the distribution, abundance, and survival of juvenile Columbia River (CR) salmon in the Northern California Current (NCC) nearshore ecosystem. For example, our ocean indicators provide managers from the federal and state governments, tribes, and other agencies/groups the ability to forecast adult returns one to two years in advance for coho and spring/summer Chinook salmon. We continue to show the importance of evaluating ocean conditions to support management decisions and to provide context for efforts by the Northwest Power and Conservation Council (NWPCC) and BPA to restore and enhance salmon production. The primary goal of our work is to develop a mechanistic understanding of how trophic dynamics and conditions in the ocean and CR plume affect survival of juvenile salmonids. This knowledge will allow us to improve forecasts in a quantitative rather than qualitative manner, and decouple the effects of mitigation efforts in the freshwater environment from the effects of a changing ocean environment. These improved forecasts will lead to well-informed recommendations for an ecosystem approach to management strategies based on the full suite of river, plume, and ocean environments. Stomach Contents from juvenile salmonids, primarily Chinook and Coho. Raw/field data Loaded by batch 4439, 02-20-2013 17:21 Subject to Public Access to Research Results (PARR): Yes Theme Columbia River Theme Marine survival Theme climate change Theme marine ecosystems Theme oceanography Theme salmon Spatial Newport Spatial Northern California Current Instrument Instrument Not Applicable Platform Animal and Plant Collection Device Northwest Fisheries Science Center Seattle WA USA Data Set Access Database Table (digital) Instrument Not Applicable Water based Platforms - Watercraft - Manned Watercraft - Vessel (Ship) - Fishing Vessels Animal and Plant Collection Device 35564 Ocean Juvenile Salmon Stomach Contents Published / External Planned Stomach Contents of Juvenile Salmon Collected in Ocean Salmon Surveys. Spreadsheet Yes PARR Stomach Contents of Juvenile Salmon Collected in Ocean Salmon Surveys. 1 Cruise_Number NUMBER No No Active The numerical designation of the cruise in sequence of research performed. NUMBER 2 Sample_Date_Local DATE No No Active The local time data were collected. Units for values are Month/Day/Year. DATE Month/Day/Year MM/DD/YYYY 3 Year NUMBER No No Active The year the data were collected. Units for values are Year. NUMBER Year 4 Vessel_Name VARCHAR2 No No Active The name of the vessel used to collect the data. VARCHAR2 5 Transect_Name VARCHAR2 No No Active The name of the location where the data were collected. VARCHAR2 6 Distance_Offshore_Nautical_Miles NUMBER No No Active The distance offshore the data were collected. Units for values are nautical miles. NUMBER nautical miles 7 Station_Depth_Meters NUMBER No No Active The bottom depth of the station where the data were collected. Units for values are Meters. NUMBER Meters 8 Station_Code VARCHAR2 No No Active The code created to name the date and location when and where the data were collected. VARCHAR2 9 Start_Time_Local DATE No No Active The local time trawl started collecting data. Units for values are hh:mm (24 hour). DATE hh:mm (24 hour) HH24:MI 10 Start_Latitude_Decimal_Degrees_North NUMBER No No Active The latitude recorded at start of trawl sampling. Units for values are decimal degrees North. NUMBER decimal degrees North 11 Start_Longitude_Decimal_Degrees_West NUMBER No No Active The longitude recorded at start of trawl sampling. Units for values are decimal degrees West. NUMBER decimal degrees West 12 Salmon_ID_Number VARCHAR2 No No Active The unique identifier of the salmon in sequence of research performed. VARCHAR2 13 Common_Name VARCHAR2 No No Active The common name of fishes and invertebrates captured in the trawl. VARCHAR2 14 Genus_Species VARCHAR2 No No Active The Latin name of fishes and invertebrates captured in the trawl. VARCHAR2 15 Age_ClassByLength VARCHAR2 No No Active The age class of salmon based on their length, which may not be their actual age, but is our best estimate from length. VARCHAR2 16 Tagged_Code VARCHAR2 No No Active The list of codes assigned to salmon as identifying marks such as coded wire tags. VARCHAR2 17 Tagged_Description VARCHAR2 No No Active The descriptions of codes assigned to salmon as identifying marks such as coded wire tags. VARCHAR2 18 Salmon_Field_Length_millimeters NUMBER No No Active The length of the fish as measured in the field. Units for values are mm. NUMBER mm 19 Type_of_Length VARCHAR2 No No Active The type of the length measurement recorded. VARCHAR2 20 Length_Description VARCHAR2 No No Active The description of the type of the length measurement. VARCHAR2 21 Salmon_Lab_Length_millimeters NUMBER No No Active The Length of the fish as measured in the Laboratory. Units for values are mm. NUMBER mm 22 Salmon_Lab_Weight_grams NUMBER No No Active The weight of the fish as measured in the Laboratory. Units for values are g. NUMBER g 23 Stomach_Condition_Description VARCHAR2 No No Active Descriptions of the condition of stomach contents. VARCHAR2 24 Prey_Item_Genus_species VARCHAR2 No No Active The latin classification assigned to stomach content. VARCHAR2 25 Prey_Item_Common_Name VARCHAR2 No No Active The common name assigned to stomach content. VARCHAR2 26 Prey_Item_Life_History_Stage VARCHAR2 No No Active The life history stage determined for stomach content. VARCHAR2 27 Prey_Item_Count NUMBER No No Active The count of each prey item in stomach content. Units for values are whole number. NUMBER whole number 28 Prey_Item_Weight_grams NUMBER No No Active The weight of each prey item in stomach content. Units for values are grams. NUMBER grams 29 Prey_Item_Condition_Description VARCHAR2 No No Active Comments on prey item condition and description. VARCHAR2 Data Steward 2015-10-01 Person Morgan, Cheryl Cheryl.Morgan@noaa.gov 541-867-0428 Distributor 2015-10-01 Organization Northwest Fisheries Science Center NWFSC nmfs.nwfsc.metadata@noaa.gov https://ror.org/05r7z1k40 2725 Montlake Boulevard East Seattle WA 98112 USA 206-860-3200 https://www.nwfsc.noaa.gov NWFSC Home Online Resource Metadata Contact 2015-10-01 Organization Northwest Fisheries Science Center NWFSC nmfs.nwfsc.metadata@noaa.gov https://ror.org/05r7z1k40 2725 Montlake Boulevard East Seattle WA 98112 USA 206-860-3200 https://www.nwfsc.noaa.gov NWFSC Home Online Resource Originator 2015-10-01 Person Morgan, Cheryl Cheryl.Morgan@noaa.gov 541-867-0428 Point of Contact 2015-10-01 Person Morgan, Cheryl Cheryl.Morgan@noaa.gov 541-867-0428 -124.0472 -122.3027 47.9491 44.6229 Newport: Newport Field Station, in Central Oregon Continuing 1998-06-01 -122.3062 -122.3062 47.6449 47.6449 Northern California Current: Northern Washington to Central Oregon field sites Continuing 1998-06-01 Unclassified At this time, contact the Data Manager for information on obtaining access to this data set. In the near future, the NWFSC will strive to provide all data resources as a web service in order to meet the NOAA Data Access Policy Directive (https://nosc.noaa.gov/EDMC/PD.DA.php). NA https://www.webapps.nwfsc.noaa.gov/apex/parr/ocean_juvenile_salmon_stomach_contents/data/page/ 2015-10-01 Organization Northwest Fisheries Science Center https://ror.org/05r7z1k40 Ocean Juvenile Salmon Stomach Contents (RESTful) Stomach Contents of Juvenile Salmon Collected in Ocean Salmon Surveys. https://www.webapps.nwfsc.noaa.gov/apex/parrdata/inventory/tables/table/ocean_juvenile_salmon_stomach_contents 2015-10-01 Organization Northwest Fisheries Science Center https://ror.org/05r7z1k40 Ocean Juvenile Salmon Stomach Contents Stomach Contents of Juvenile Salmon Collected in Ocean Salmon Surveys. https://www.webapps.nwfsc.noaa.gov/apex/parrdata/inventory/datasets/dataset/6971 Juvenile Salmonid Trophic Data Online Resource Web site NWFSC Dataset Information page. Stomach Contents from juvenile salmonids, primarily Chinook and Coho RDBMS (Oracle, SQL Server, etc.) High These data were collected and processed in accordance with established protocols and best practices under the direction of the project’s Principal Investigator. Contact the dataset Data Manager for full QA/QC methodology. No 10 Yes No No 365 Time to process and work up samples after collection. NCEI-MD 365 The Northwest Fisheries Science Center facilitates backup and recovery of all data and IT components which are managed by IT Operations through the capture of static (point-in-time) backup data to physical media. Once data is captured to physical media (every 1-3 days), a duplicate is made and routinely (weekly) transported to an offsite archive facility where it is maintained throughout the data's applicable life-cycle. Entry into access/xl from datasheets. 35564 Entity gov.noaa.nmfs.inport:18499 Jeffrey Cowen 2013-02-20T17:21:07 SysAdmin InPortAdmin 2026-03-04T19:17:17 2019-06-04 Northwest Fisheries Science Center NWFSC 2725 Montlake Boulevard East Seattle WA 98112 USA 206-860-3200 https://www.nwfsc.noaa.gov 1001 Public No No 2019-06-04 1 Year 2020-06-04