Juvenile Salmon Survival in the Snake and Columbia Rivers
Entity (ENT) | Northwest Fisheries Science Center (NWFSC)GUID: gov.noaa.nmfs.inport:36830 | Updated: August 9, 2022 | Published / External
Entity Information
| Entity Type: | Spreadsheet |
|---|---|
| Active Version?: | Yes |
| 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. |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
SPECIES | VARCHAR2 | The name of the species of fish for which survival was estimated. Units for values are NA. | |
|
100
|
REARTYPE | VARCHAR2 | The rearing type of the fish for which survival was estimated. Units for values are NA. | |
|
100
|
BASIN | VARCHAR2 | The basin of origin of fish used for the survival estimate. Units for values are NA. | |
|
100
|
YEAR | NUMBER | The year for which the survival estimate was generated. | |
|
100
|
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
|
SURVIVAL | NUMBER | The estimated survival of juvenile fish (Cormack-Jolly-Seber model). Units for values are proportion. | |
|
100
|
STANDARD_ERROR | NUMBER | The standard error of the survival estimate. |
Attribute Details
SPECIES
| Seq. Order: | 1 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 20 |
| Required: | Yes |
| Primary Key: | No |
| 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 |
| Allowed Values: | "Chinook" or "Steelhead" |
REARTYPE
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 20 |
| Required: | Yes |
| Primary Key: | No |
| 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 |
| Allowed Values: | "Wild", "Hatchery", "HatcheryWild" |
BASIN
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 20 |
| Required: | Yes |
| Primary Key: | No |
| 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 |
| Allowed Values: | "Snake" or "UpperColumbia" |
YEAR
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | NUMBER |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
The year for which the survival estimate was generated. |
| General Data Type: | NUMBER |
REACH
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 100 |
| Required: | Yes |
| Primary Key: | No |
| 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 |
SURVIVAL
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | NUMBER |
| Required: | No |
| Primary Key: | No |
| 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 |
| 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 |
STANDARD_ERROR
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | NUMBER |
| Required: | No |
| Primary Key: | No |
| Scale: | 3 |
| Status: | Active |
| Description: |
The standard error of the survival estimate. |
| General Data Type: | NUMBER |
| 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 |
Catalog Details
| Catalog Item ID: | 36830 |
|---|---|
| GUID: | gov.noaa.nmfs.inport: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 Last Review Date: | 2018-02-27 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2019-02-27 |