Juvenile Salmon Survival in the Snake and Columbia Rivers

Northwest Fisheries Science Center
Entity (ENT) | ID: 36830 | Published / External
Created: 2017-02-16   |   Last Modified: 2022-08-09

Parent: Survival estimates - Survival estimates for the passage of juvenile salmonids through Snake and Columbia River dams and reservoirs
Data Set (DS) | ID: 20567

ID: 36830
Entity (ENT)

* Discovery
• First Pass
» Metadata Rubric

Item Identification

* » Title Juvenile Salmon Survival in the Snake and Columbia Rivers
Short Name Juvenile Salmon Survival in the Snake and Columbia Rivers
* Status Planned
Creation Date  
Revision Date  
• Publication Date  
* » Abstract

This table contains estimates of juvenile survival from a number of years and for various reaches within the Snake and Columbia rivers, for Chinook salmon and steelhead trout.
* Purpose
Notes
Other Citation Details
• Supplemental Information
DOI (Digital Object Identifier)  
DOI Registration Authority  
DOI Issue Date  

Keywords

Theme Keywords

Thesaurus Keyword
   
   
   

Temporal Keywords

Thesaurus Keyword
   
   
   

* Spatial Keywords

Thesaurus Keyword
   
   
   

Stratum Keywords

Thesaurus Keyword
   
   
   

Instrument Keywords

Thesaurus Keyword
   
   
   

Platform Keywords

Thesaurus Keyword
   
   
   

Physical Location

• » Organization  
• » City  
• » State/Province  
• Country  
• » Location Description

Entity Information

Entity Type Spreadsheet
Active Version? Y
Alias  
Schema Name PARR
» Description

This table contains estimates of juvenile survival from a number of years and for various reaches within the Snake and Columbia rivers, for Chinook salmon and steelhead trout.
Change Summary

Data Attributes

Attribute Summary

Score Req'd? PKey? » Name Data Storage Type Description
100 Yes No SPECIES VARCHAR2 The name of the species of fish for which survival was estimated. Units for values are NA.
100 Yes No REARTYPE VARCHAR2 The rearing type of the fish for which survival was estimated. Units for values are NA.
100 Yes No BASIN VARCHAR2 The basin of origin of fish used for the survival estimate. Units for values are NA.
100 Yes No YEAR NUMBER The year for which the survival estimate was generated.
100 Yes No REACH VARCHAR2 The geographical portion of the river (start point and end point) which is covered by the survival estimate. Units for values are NA.
100 No No SURVIVAL NUMBER The estimated survival of juvenile fish (Cormack-Jolly-Seber model). Units for values are proportion.
100 No No STANDARD_ERROR NUMBER The standard error of the survival estimate.

Attribute Details

Attribute Name SPECIES
Seq. Order 1
Data Storage Type VARCHAR2
Max Length 20
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

The name of the species of fish for which survival was estimated. Units for values are NA.
General Data Type VARCHAR2
Unit of Measure NA
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values "Chinook" or "Steelhead"
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name REARTYPE
Seq. Order 2
Data Storage Type VARCHAR2
Max Length 20
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

The rearing type of the fish for which survival was estimated. Units for values are NA.
General Data Type VARCHAR2
Unit of Measure NA
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values "Wild", "Hatchery", "HatcheryWild"
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BASIN
Seq. Order 3
Data Storage Type VARCHAR2
Max Length 20
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

The basin of origin of fish used for the survival estimate. Units for values are NA.
General Data Type VARCHAR2
Unit of Measure NA
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values "Snake" or "UpperColumbia"
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name YEAR
Seq. Order 4
Data Storage Type NUMBER
Max Length  
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

The year for which the survival estimate was generated.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name REACH
Seq. Order 5
Data Storage Type VARCHAR2
Max Length 100
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

The geographical portion of the river (start point and end point) which is covered by the survival estimate. Units for values are NA.
General Data Type VARCHAR2
Unit of Measure NA
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SURVIVAL
Seq. Order 6
Data Storage Type NUMBER
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale 3
Status Active
Description

The estimated survival of juvenile fish (Cormack-Jolly-Seber model). Units for values are proportion.
General Data Type NUMBER
Unit of Measure proportion
Case Restriction  
Display Example  
Format Mask  
Null Value NA
Null Value Meaning

Data was not sufficient to generate an estimate for this specific reach/species/rearype in this specific year
Allowed Values >0
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name STANDARD_ERROR
Seq. Order 7
Data Storage Type NUMBER
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale 3
Status Active
Description

The standard error of the survival estimate.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value NA
Null Value Meaning

Data was not sufficient to generate an estimate for this specific reach/species/rearype in this specific year
Allowed Values >0
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Support Roles

» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions

Extents

Currentness Reference  

Extent Group 1

Extent Description

Extent Group 1 / Geographic Area

* » W° Bound
* » E° Bound
* » N° Bound
* » S° Bound
* » Description

Extent Group 1 / Vertical Extent

EPSG Code
Vertical Minimum
Vertical Maximum

Extent Group 1 / Time Frame

* » Time Frame Type
* » Start
End
Alternate Start as of Info
Alternate End as of Info
Description

Access Information

* » Security Class  
* Security Classification System  
 
Security Handling Description  
 
• Data Access Policy  
 
» Data Access Procedure  
 
• » Data Access Constraints  
 
• Data Use Constraints  
 
Metadata Access Constraints  
 
Metadata Use Constraints  
 

Distribution Information

Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status

Activity Log

Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description

Issues

Issue Date
Author
Issue
Issue Date
Author
Issue
Issue Date
Author
Issue

FAQs

Date
Author
Question
Answer

Child Items

Rubric scores updated every 15m

Score Type Title
     
     
     

Related Items

Item Type Relationship Type Title
     
     
     

Catalog Details

Catalog Item ID 36830
Metadata Record Created By Jeffrey W Cowen
Metadata Record Created 2017-02-16 19:25+0000
Metadata Record Last Modified By SysAdmin InPortAdmin
» Metadata Record Last Modified 2022-08-09 17:11+0000
Metadata Record Published 2018-02-27
Owner Org NWFSC
Metadata Publication Status Published Externally
Do Not Publish? N
Metadata Workflow State Published / External
Metadata Last Review Date 2018-02-27
Metadata Review Frequency 1 Year
Metadata Next Review Date 2019-02-27
Tags