18495 Juvenile Salmonid Metrics (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. Lab Lengths, weight, genetics, IGF-1 (growth), and otolith microchemistry from juvenile salmonids. Raw/field data Loaded by batch 4436, 02-20-2013 17:04 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 Unknown Instrument Platform Animal and Plant Collection Device Northwest Fisheries Science Center Seattle WA USA Data Set Access Database Table (digital) Unknown Instrument Water based Platforms - Watercraft - Manned Watercraft - Vessel (Ship) - Fishing Vessels Animal and Plant Collection Device 35565 Ocean Juvenile Salmon Metrics Published / External Planned Metrics for Salmon Collected in Ocean Salmon Surveys. Spreadsheet Yes PARR Metrics for 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 date Month/Day/Year 3 YEAR date No No Active The year the data were collected date Year 4 Vessel_Name text No No Active The name of the vessel used to collect the data text 5 Transect_Name text No No Active The name of the location where the data were collected text 6 Dist_Offshore_Nautical_Miles number No No Active The distance offshore the data were collected number nautical miles 7 Station_Depth_Meters number No No Active The bottom depth of the station where the data were collected number Meters 8 Station_Code text No No Active The code created to name the date and location when and where the data were collected text 9 Start_Time_Local time No No Active The local time trawl started collecting data time hh:mm (24 hour) 10 Start_Lat_Decimal_Deg_North number No No Active The latitude recorded at start of trawl sampling number decimal degrees North 11 Start_Long_Decl_Deg_West number No No Active The longitude recorded at start of trawl sampling number decimal degrees West 12 Salmon_ID_Number text No No Active The unique identifier of the salmon in sequence of research performed text 13 Common_Name text No No Active The common name of fishes and invertebrates captured in the trawl text 14 Genus_Species text No No Active The Latin name of fishes and invertebrates captured in the trawl text 15 Age_ClassByLength text 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 text 16 Tagged_Code text No No Active The list of codes assigned to salmon as identifying marks such as coded wire tags text 17 Tagged_Description text No No Active The descriptions of codes assigned to salmon as identifying marks such as coded wire tags text 18 Count number No No Active The count of each fish or invertebrate number whole number 19 Field_Length_millimeters number No No Active The field length recorded number milimeters 20 Type_of_Length text No No Active The type of the length measurement recorded text 21 Length_Description text No No Active The description of the type of the length measurement text 22 Method_Saved text No No Active The description of how fishes and invertebrates were retained text 23 Lab_Fork_Length_millimeters number No No Active The fork length recorded in the lab number millimeters 24 Lab_Weight_grams number No No Active The salmon weight recorded in the lab number grams 25 PIT_Code text No No Active PIT Tag for individual fish text 26 Coded_Wire_Tag_Number text No No Active The number assigned to a coded wire tag text 27 Genetic_Stock_Best_Estimate text No No Active The best estimate at genetic stock text 28 Genetic_Stock_Best_Est_Prob number No No Active The probability of correct assignment of genetic stock number Probability 29 Genetic_Stock_2nd_Best_Est text No No Active The second best estimate at genetic stock text 30 Genetic_Stock_2nd_Bst_Est_Prob number No No Active The probability of correct assignment with second best estimate of genetic stock number Probability 31 Insulin_Like_Grwth_Fct_1_ng_ml number No No Active The measurement of hormone level in salmon from laboratory analysis number nanograms per milliliter 32 Pct_Based_Tag_Hatchery_Asgn text No No Active The genetically assigned hatchery using parentage based tags text 33 Pct_Based_Tag_Prob number No No Active The probability of correct assignment of hatchery using parentage based tags number Probability 34 FkLn_mm_FreshW_Emg_Otolith number No No Active The fork length at freshwater emmigration, estimated using otoliths number millimeters 35566 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 date Month/Day/Year 3 YEAR date No No Active The year the data were collected date Year 4 Vessel_Name text No No Active The name of the vessel used to collect the data text 5 Transect_Name text No No Active The name of the location where the data were collected text 6 Dist_Offshore_Nautical_Miles number No No Active The distance offshore the data were collected number nautical miles 7 Station_Depth_Meters number No No Active The bottom depth of the station where the data were collected number Meters 8 Station_Code text No No Active The code created to name the date and location when and where the data were collected text 9 Start_Time_Local time No No Active The local time trawl started collecting data time hh:mm (24 hour) 10 Start_Lat_Decimal_Deg_North number No No Active The latitude recorded at start of trawl sampling number decimal degrees North 11 Start_Long_Decl_Deg_West number No No Active The longitude recorded at start of trawl sampling number decimal degrees West 12 Salmon_ID_Number text No No Active The unique identifier of the salmon in sequence of research performed text 13 Common_Name text No No Active The common name of fishes and invertebrates captured in the trawl text 14 Genus_Species text No No Active The Latin name of fishes and invertebrates captured in the trawl text 15 Age_ClassByLength text 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 text 16 Tagged_Code text No No Active The list of codes assigned to salmon as identifying marks such as coded wire tags text 17 Tagged_Description text No No Active The descriptions of codes assigned to salmon as identifying marks such as coded wire tags text 18 Salmon_Field_Length_mm number No No Active The length of the fish as measured in the field. number mm 19 Type_of_Length text No No Active The type of the length measurement recorded text 20 Length_Description text No No Active The description of the type of the length measurement text 21 Salmon_Lab_Length_mm number No No Active The Length of the fish as measured in the Laboratory number mm 22 Salmon_Lab_Weight_g number No No Active The weight of the fish as measured in the Laboratory number g 23 Stomach_Condition_Description text No No Active Descriptions of the condition of stomach contents text 24 Prey_Item_Genus_species text No No Active The latin classification assigned to stomach content text 25 Prey_Item_Common_Name text No No Active The common name assigned to stomach content text 26 Prey_Item_Life_History_Stage text No No Active The life history stage determined for stomach content text 27 Prey_Item_Count number No No Active The count of each prey item in stomach content number whole number 28 Prey_Item_Weight_grams number No No Active The weight of each prey item in stomach content number grams 29 Prey_Item_Condition_Desc text No No Active Comments on prey item condition and description text 37571 Ocean Juvenile Salmon Metrics Published / External Planned Metrics for Salmon Collected in Ocean Salmon Surveys. Spreadsheet Yes PARR Metrics for 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 Count NUMBER No No Active The count of each fish or invertebrate. Units for values are whole number. NUMBER whole number 19 Field_Length_millimeters NUMBER No No Active The field length recorded. Units for values are milimeters. NUMBER milimeters 20 Type_of_Length VARCHAR2 No No Active The type of the length measurement recorded. VARCHAR2 21 Length_Description VARCHAR2 No No Active The description of the type of the length measurement. VARCHAR2 22 Method_Saved VARCHAR2 No No Active The description of how fishes and invertebrates were retained. VARCHAR2 23 Lab_Fork_Length_millimeters NUMBER No No Active The fork length recorded in the lab. Units for values are millimeters. NUMBER millimeters 24 Lab_Weight_grams NUMBER No No Active The salmon weight recorded in the lab. Units for values are grams. NUMBER grams 25 PIT_Code VARCHAR2 No No Active PIT Tag for individual fish. VARCHAR2 26 Coded_Wire_Tag_Number VARCHAR2 No No Active The number assigned to a coded wire tag. VARCHAR2 27 Genetic_Stock_Best_Estimate VARCHAR2 No No Active The best estimate at genetic stock. VARCHAR2 28 Genetic_Stock_Best_Estimate_Probability NUMBER No No Active The probability of correct assignment of genetic stock. Units for values are Probability. NUMBER Probability 29 Genetic_Stock_Second_Best_Estimate VARCHAR2 No No Active The second best estimate at genetic stock. VARCHAR2 30 Genetic_Stock_Second_Best_Estimate_Probability NUMBER No No Active The probability of correct assignment with second best estimate of genetic stock. Units for values are Probability. NUMBER Probability 31 Insulin_Like_Growth_Factor_One_nanograms_per_milliliter NUMBER No No Active The measurement of hormone level in salmon from laboratory analysis. Units for values are nanograms per milliliter. NUMBER nanograms per milliliter 32 Parentage_Based_Tag_Hatchery_Assignment VARCHAR2 No No Active The genetically assigned hatchery using parentage based tags. VARCHAR2 33 Parentage_Based_Tag_Probability NUMBER No No Active The probability of correct assignment of hatchery using parentage based tags. Units for values are Probability. NUMBER Probability 34 Fork_Length_millimeter_Freshwater_Emmigration_Otolith NUMBER No No Active The fork length at freshwater emmigration, estimated using otoliths. Units for values are millimeters. NUMBER millimeters 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_metrics/data/page/ 2015-10-01 Organization Northwest Fisheries Science Center https://ror.org/05r7z1k40 Ocean Juvenile Salmon Metrics (RESTful) Metrics for Salmon Collected in Ocean Salmon Surveys. https://www.webapps.nwfsc.noaa.gov/apex/parrdata/inventory/tables/table/ocean_juvenile_salmon_metrics 2015-10-01 Organization Northwest Fisheries Science Center https://ror.org/05r7z1k40 Ocean Juvenile Salmon Metrics Metrics for Salmon Collected in Ocean Salmon Surveys. https://www.webapps.nwfsc.noaa.gov/apex/parrdata/inventory/datasets/dataset/6972 Juvenile Salmonid Metrics Online Resource Web site NWFSC Dataset Information page. Lab Lengths, weight, genetics, IGF-1 (growth), and otolith microchemistry from juvenile salmonids 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. 35565 Entity 37571 Entity 35566 Entity gov.noaa.nmfs.inport:18495 Jeffrey Cowen 2013-02-20T17:04:01 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