Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

The data contained in the SPS database are primarily summary data, compiled at the population level. The database also includes a limited number of series representing the aggregate returns to groups of populations (e.g., Lower Granite Dam counts) or counts of spawners within a subsection of a population where expansions to the population level were not feasible. The information used to develop the population level estimates comes from a variety of sources, but mostly originates from the monitoring programs conducted by state and tribal fishery agencies.

The Technical Recovery Teams and Northwest Fisheries Science Center staff have processed this information to provide an estimate of spawning abundance at the population level. A variety of different types of information (e.g., redd counts, dam counts, carcass surveys, tag recoveries, scale analysis) forms the basis of the information in the database, and where possible the database provides references to these information sources. It is important to recognize that spawning abundance values and other information in the SPS database are not 'facts' that are known with certainty. Rather, they are estimates based on a variety of sources of information, some known with greater precision or accuracy than others. Ideally, these estimates would be characterized by a known level of statistical uncertainty. However, for the most part such a statistical characterization is either not possible or has not been attempted, and the database reports only the best estimates of the values. In all cases there is some degree of uncertainty surrounding these estimates. The NWFSC intends to work with our state and tribal partners to keep the SPS database as up-to-date as possible, and new annual estimates will be added as they become available. Disclaimer: Due to the wide variety of data sources that go into the SPS database, the NWFSC does not guarantee the accuracy of any of the data in the SPS database. In particular, neither the U.S. Government, nor any agency or employee thereof, makes any warranties, expressed or implied, with respect to the accuracy of the data, including but not limited to the implied warranties or merchantability and fitness for any particular purpose. In no event shall the U.S. Government, nor any agency or employee thereof, be liable for any direct, indirect, or consequential damage flowing from the use of the data in the SPS database.

Description

The data contained in the SPS database are primarily summary data, compiled at the population level. The database also includes a limited number of series representing the aggregate returns to groups of populations (e.g., Lower Granite Dam counts) or counts of spawners within a subsection of a population where expansions to the population level were not feasible. The information used to develop the population level estimates comes from a variety of sources, but mostly originates from the monitoring programs conducted by state and tribal fishery agencies.

The Technical Recovery Teams and Northwest Fisheries Science Center staff have processed this information to provide an estimate of spawning abundance at the population level. A variety of different types of information (e.g., redd counts, dam counts, carcass surveys, tag recoveries, scale analysis) forms the basis of the information in the database, and where possible the database provides references to these information sources. It is important to recognize that spawning abundance values and other information in the SPS database are not 'facts' that are known with certainty. Rather, they are estimates based on a variety of sources of information, some known with greater precision or accuracy than others. Ideally, these estimates would be characterized by a known level of statistical uncertainty. However, for the most part such a statistical characterization is either not possible or has not been attempted, and the database reports only the best estimates of the values. In all cases there is some degree of uncertainty surrounding these estimates. The NWFSC intends to work with our state and tribal partners to keep the SPS database as up-to-date as possible, and new annual estimates will be added as they become available. Disclaimer: Due to the wide variety of data sources that go into the SPS database, the NWFSC does not guarantee the accuracy of any of the data in the SPS database. In particular, neither the U.S. Government, nor any agency or employee thereof, makes any warranties, expressed or implied, with respect to the accuracy of the data, including but not limited to the implied warranties or merchantability and fitness for any particular purpose. In no event shall the U.S. Government, nor any agency or employee thereof, be liable for any direct, indirect, or consequential damage flowing from the use of the data in the SPS database.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
NMFS_POPID
NUMBER
The unique numeric value for a population as determined by NMFS. This value will not change over time, even if the population name (NWR Population Name) does.
COMMON POPULATION NAME
VARCHAR2
Name of population as people may commonly refer to it.
NWR POPULATION NAME
VARCHAR2
Name of the population as defined by the West Coast Region of NMFS. A group of fish of the same species that spawns in a particular locality at a particular season and does not interbreed substantially with fish from any other group.
RECOVERY DOMAIN
VARCHAR2
After listing 27 Pacific salmon Evolutionarily Significant Units (ESUs) as threatened or endangered under the Endangered Species Act, NMFS initiated a coast wide process to develop recovery plans for these species. An important part of this process was the creation of geographically based Technical Recovery Teams (TRTs) and recovery areas (domains).
MAJOR POPULATION GROUP
VARCHAR2
A group of salmon populations that are geographically and genetically cohesive. The MPG is a level of organization between demographically independent populations and the ESU or DPS.
ESU NAME
VARCHAR2
A group of Pacific salmon or steelhead trout that is (1) substantially reproductively isolated from other conspecific units and (2) represents an important component of the evolutionary legacy of the species.
SPECIES
VARCHAR2
The name of the specie that the population belongs to.
RUN
VARCHAR2
The Season of the Year represented by this viability figure for the population.
START YEAR
NUMBER
The earliest year that viable salmonid population statistics are reported for this population.
END YEAR
NUMBER
The latest year that viable salmonid population statistics are reported for this population.
YEAR
NUMBER
The year that adults enter to the river to spawn.
NUMBER OF SPAWNERS
NUMBER
The total number of fish returning to spawn in the data collection year.
FRACTION WILD
NUMBER
The fraction of the total spawners that are the progeny of naturally-spawning fish.
AGE 1 RETURNS
NUMBER
The fraction of fish who are defined as having an age of 1 that returned to spawn in a given year.
AGE 2 RETURNS
NUMBER
The fraction of fish who are defined as having an age of 2 that returned to spawn in a given year.
AGE 3 RETURNS
NUMBER
The fraction of fish who are defined as having an age of 3 that returned to spawn in a given year.
AGE 4 RETURNS
NUMBER
The fraction of fish who are defined as having an age of 4 that returned to spawn in a given year.
AGE 5 RETURNS
NUMBER
The fraction of fish who are defined as having an age of 5 that returned to spawn in a given year.
AGE 6 RETURNS
NUMBER
The fraction of fish who are defined as having an age of 6 that returned to spawn in a given year.
AGE 7 RETURNS
NUMBER
The fraction of fish who are defined as having an age of 7 that returned to spawn in a given year.
NATURAL SPAWNERS WITH JACKS
NUMBER
Estimated number of natural origin (parents spawned in the wild) spawners contributing to spawning in a particular year. Includes both adults and jacks of natural origin.
TOTAL SPAWNERS WITH JACKS
NUMBER
Estimated total number of fish contributing to spawning in a particular year. Includes both natural origin and hatchery origin returns, adults and jack age classes.
NATURAL SPAWNERS EXCLUDING JACKS
NUMBER
Estimated number of natural origin (parents spawned in the wild) spawners contributing to spawning in a particular year. Includes only adults of natural origin, excluding jacks.
JACK FRACTION OF HATCHERY SPAWNERS
NUMBER
If available, estimate of the relative proportion of hatchery returns to the spawning ground that are jacks (i.e., age 3 fish for stream type chinook populations, age 2 fish for ocean type chinook populations).
ADULT NATURAL HARVEST RATE
NUMBER
The estimated proportion of adult returns removed by harvest in a particular run year. Assumes that all adult age classes are harvested at the same rate. Steelhead and yearling type chinook estimates reflect in-river fisheries. Snake River Fall chinook estimates also include an adjustment to incorporate an index of annual ocean impacts.
NATURAL ORIGIN BROOD STOCK
NUMBER
Fish of natural origin removed from the returning run for use as hatchery brood stock.
CONTACT AGENCY
VARCHAR2
Agency, Tribe or other entity, or person responsible for these data that is the best contact for questions that may arise about this data record.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NWFSC) for inquiries on this record.

Item Identification

Title: SPS Data 1949 to 2015
Short Name: SPS Data 1949 to 2015
Status: Completed
Abstract:

The data contained in the SPS database are primarily summary data, compiled at the population level. The database also includes a limited number of series representing the aggregate returns to groups of populations (e.g., Lower Granite Dam counts) or counts of spawners within a subsection of a population where expansions to the population level were not feasible. The information used to develop the population level estimates comes from a variety of sources, but mostly originates from the monitoring programs conducted by state and tribal fishery agencies.

The Technical Recovery Teams and Northwest Fisheries Science Center staff have processed this information to provide an estimate of spawning abundance at the population level. A variety of different types of information (e.g., redd counts, dam counts, carcass surveys, tag recoveries, scale analysis) forms the basis of the information in the database, and where possible the database provides references to these information sources. It is important to recognize that spawning abundance values and other information in the SPS database are not 'facts' that are known with certainty. Rather, they are estimates based on a variety of sources of information, some known with greater precision or accuracy than others. Ideally, these estimates would be characterized by a known level of statistical uncertainty. However, for the most part such a statistical characterization is either not possible or has not been attempted, and the database reports only the best estimates of the values. In all cases there is some degree of uncertainty surrounding these estimates. The NWFSC intends to work with our state and tribal partners to keep the SPS database as up-to-date as possible, and new annual estimates will be added as they become available. Disclaimer: Due to the wide variety of data sources that go into the SPS database, the NWFSC does not guarantee the accuracy of any of the data in the SPS database. In particular, neither the U.S. Government, nor any agency or employee thereof, makes any warranties, expressed or implied, with respect to the accuracy of the data, including but not limited to the implied warranties or merchantability and fitness for any particular purpose. In no event shall the U.S. Government, nor any agency or employee thereof, be liable for any direct, indirect, or consequential damage flowing from the use of the data in the SPS database.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: SPS
Description:

The data contained in the SPS database are primarily summary data, compiled at the population level. The database also includes a limited number of series representing the aggregate returns to groups of populations (e.g., Lower Granite Dam counts) or counts of spawners within a subsection of a population where expansions to the population level were not feasible. The information used to develop the population level estimates comes from a variety of sources, but mostly originates from the monitoring programs conducted by state and tribal fishery agencies.

The Technical Recovery Teams and Northwest Fisheries Science Center staff have processed this information to provide an estimate of spawning abundance at the population level. A variety of different types of information (e.g., redd counts, dam counts, carcass surveys, tag recoveries, scale analysis) forms the basis of the information in the database, and where possible the database provides references to these information sources. It is important to recognize that spawning abundance values and other information in the SPS database are not 'facts' that are known with certainty. Rather, they are estimates based on a variety of sources of information, some known with greater precision or accuracy than others. Ideally, these estimates would be characterized by a known level of statistical uncertainty. However, for the most part such a statistical characterization is either not possible or has not been attempted, and the database reports only the best estimates of the values. In all cases there is some degree of uncertainty surrounding these estimates. The NWFSC intends to work with our state and tribal partners to keep the SPS database as up-to-date as possible, and new annual estimates will be added as they become available. Disclaimer: Due to the wide variety of data sources that go into the SPS database, the NWFSC does not guarantee the accuracy of any of the data in the SPS database. In particular, neither the U.S. Government, nor any agency or employee thereof, makes any warranties, expressed or implied, with respect to the accuracy of the data, including but not limited to the implied warranties or merchantability and fitness for any particular purpose. In no event shall the U.S. Government, nor any agency or employee thereof, be liable for any direct, indirect, or consequential damage flowing from the use of the data in the SPS database.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
NMFS_POPID NUMBER The unique numeric value for a population as determined by NMFS. This value will not change over time, even if the population name (NWR Population Name) does.
100
COMMON POPULATION NAME VARCHAR2 Name of population as people may commonly refer to it.
100
NWR POPULATION NAME VARCHAR2 Name of the population as defined by the West Coast Region of NMFS. A group of fish of the same species that spawns in a particular locality at a particular season and does not interbreed substantially with fish from any other group.
100
RECOVERY DOMAIN VARCHAR2 After listing 27 Pacific salmon Evolutionarily Significant Units (ESUs) as threatened or endangered under the Endangered Species Act, NMFS initiated a coast wide process to develop recovery plans for these species. An important part of this process was the creation of geographically based Technical Recovery Teams (TRTs) and recovery areas (domains).
100
MAJOR POPULATION GROUP VARCHAR2 A group of salmon populations that are geographically and genetically cohesive. The MPG is a level of organization between demographically independent populations and the ESU or DPS.
100
ESU NAME VARCHAR2 A group of Pacific salmon or steelhead trout that is (1) substantially reproductively isolated from other conspecific units and (2) represents an important component of the evolutionary legacy of the species.
100
SPECIES VARCHAR2 The name of the specie that the population belongs to.
100
RUN VARCHAR2 The Season of the Year represented by this viability figure for the population.
100
START YEAR NUMBER The earliest year that viable salmonid population statistics are reported for this population.
100
END YEAR NUMBER The latest year that viable salmonid population statistics are reported for this population.
100
YEAR NUMBER The year that adults enter to the river to spawn.
100
NUMBER OF SPAWNERS NUMBER The total number of fish returning to spawn in the data collection year.
100
FRACTION WILD NUMBER The fraction of the total spawners that are the progeny of naturally-spawning fish.
100
AGE 1 RETURNS NUMBER The fraction of fish who are defined as having an age of 1 that returned to spawn in a given year.
100
AGE 2 RETURNS NUMBER The fraction of fish who are defined as having an age of 2 that returned to spawn in a given year.
100
AGE 3 RETURNS NUMBER The fraction of fish who are defined as having an age of 3 that returned to spawn in a given year.
100
AGE 4 RETURNS NUMBER The fraction of fish who are defined as having an age of 4 that returned to spawn in a given year.
100
AGE 5 RETURNS NUMBER The fraction of fish who are defined as having an age of 5 that returned to spawn in a given year.
100
AGE 6 RETURNS NUMBER The fraction of fish who are defined as having an age of 6 that returned to spawn in a given year.
100
AGE 7 RETURNS NUMBER The fraction of fish who are defined as having an age of 7 that returned to spawn in a given year.
100
NATURAL SPAWNERS WITH JACKS NUMBER Estimated number of natural origin (parents spawned in the wild) spawners contributing to spawning in a particular year. Includes both adults and jacks of natural origin.
100
TOTAL SPAWNERS WITH JACKS NUMBER Estimated total number of fish contributing to spawning in a particular year. Includes both natural origin and hatchery origin returns, adults and jack age classes.
100
NATURAL SPAWNERS EXCLUDING JACKS NUMBER Estimated number of natural origin (parents spawned in the wild) spawners contributing to spawning in a particular year. Includes only adults of natural origin, excluding jacks.
100
JACK FRACTION OF HATCHERY SPAWNERS NUMBER If available, estimate of the relative proportion of hatchery returns to the spawning ground that are jacks (i.e., age 3 fish for stream type chinook populations, age 2 fish for ocean type chinook populations).
100
ADULT NATURAL HARVEST RATE NUMBER The estimated proportion of adult returns removed by harvest in a particular run year. Assumes that all adult age classes are harvested at the same rate. Steelhead and yearling type chinook estimates reflect in-river fisheries. Snake River Fall chinook estimates also include an adjustment to incorporate an index of annual ocean impacts.
100
NATURAL ORIGIN BROOD STOCK NUMBER Fish of natural origin removed from the returning run for use as hatchery brood stock.
100
CONTACT AGENCY VARCHAR2 Agency, Tribe or other entity, or person responsible for these data that is the best contact for questions that may arise about this data record.

Attribute Details

NMFS_POPID

CC ID: 1203740
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

The unique numeric value for a population as determined by NMFS. This value will not change over time, even if the population name (NWR Population Name) does.

COMMON POPULATION NAME

CC ID: 1203730
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

Name of population as people may commonly refer to it.

NWR POPULATION NAME

CC ID: 1203742
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Name of the population as defined by the West Coast Region of NMFS. A group of fish of the same species that spawns in a particular locality at a particular season and does not interbreed substantially with fish from any other group.

RECOVERY DOMAIN

CC ID: 1203743
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

After listing 27 Pacific salmon Evolutionarily Significant Units (ESUs) as threatened or endangered under the Endangered Species Act, NMFS initiated a coast wide process to develop recovery plans for these species. An important part of this process was the creation of geographically based Technical Recovery Teams (TRTs) and recovery areas (domains).

MAJOR POPULATION GROUP

CC ID: 1203736
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

A group of salmon populations that are geographically and genetically cohesive. The MPG is a level of organization between demographically independent populations and the ESU or DPS.

ESU NAME

CC ID: 1203733
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

A group of Pacific salmon or steelhead trout that is (1) substantially reproductively isolated from other conspecific units and (2) represents an important component of the evolutionary legacy of the species.

SPECIES

CC ID: 1203745
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

The name of the specie that the population belongs to.

RUN

CC ID: 1203744
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

The Season of the Year represented by this viability figure for the population.

START YEAR

CC ID: 1203746
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Scale: 0
Status: Active
Description:

The earliest year that viable salmonid population statistics are reported for this population.

END YEAR

CC ID: 1203732
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Scale: 0
Status: Active
Description:

The latest year that viable salmonid population statistics are reported for this population.

YEAR

CC ID: 1203748
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

The year that adults enter to the river to spawn.

NUMBER OF SPAWNERS

CC ID: 1203741
Seq. Order: 23
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

The total number of fish returning to spawn in the data collection year.

FRACTION WILD

CC ID: 1203734
Seq. Order: 25
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

The fraction of the total spawners that are the progeny of naturally-spawning fish.

AGE 1 RETURNS

CC ID: 1203723
Seq. Order: 29
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

The fraction of fish who are defined as having an age of 1 that returned to spawn in a given year.

AGE 2 RETURNS

CC ID: 1203724
Seq. Order: 30
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

The fraction of fish who are defined as having an age of 2 that returned to spawn in a given year.

AGE 3 RETURNS

CC ID: 1203725
Seq. Order: 31
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

The fraction of fish who are defined as having an age of 3 that returned to spawn in a given year.

AGE 4 RETURNS

CC ID: 1203726
Seq. Order: 32
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

The fraction of fish who are defined as having an age of 4 that returned to spawn in a given year.

AGE 5 RETURNS

CC ID: 1203727
Seq. Order: 33
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

The fraction of fish who are defined as having an age of 5 that returned to spawn in a given year.

AGE 6 RETURNS

CC ID: 1203728
Seq. Order: 34
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

The fraction of fish who are defined as having an age of 6 that returned to spawn in a given year.

AGE 7 RETURNS

CC ID: 1203729
Seq. Order: 35
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

The fraction of fish who are defined as having an age of 7 that returned to spawn in a given year.

NATURAL SPAWNERS WITH JACKS

CC ID: 1203739
Seq. Order: 40
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Estimated number of natural origin (parents spawned in the wild) spawners contributing to spawning in a particular year. Includes both adults and jacks of natural origin.

TOTAL SPAWNERS WITH JACKS

CC ID: 1203747
Seq. Order: 48
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Estimated total number of fish contributing to spawning in a particular year. Includes both natural origin and hatchery origin returns, adults and jack age classes.

NATURAL SPAWNERS EXCLUDING JACKS

CC ID: 1203738
Seq. Order: 49
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Estimated number of natural origin (parents spawned in the wild) spawners contributing to spawning in a particular year. Includes only adults of natural origin, excluding jacks.

JACK FRACTION OF HATCHERY SPAWNERS

CC ID: 1203735
Seq. Order: 51
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

If available, estimate of the relative proportion of hatchery returns to the spawning ground that are jacks (i.e., age 3 fish for stream type chinook populations, age 2 fish for ocean type chinook populations).

ADULT NATURAL HARVEST RATE

CC ID: 1203722
Seq. Order: 52
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

The estimated proportion of adult returns removed by harvest in a particular run year. Assumes that all adult age classes are harvested at the same rate. Steelhead and yearling type chinook estimates reflect in-river fisheries. Snake River Fall chinook estimates also include an adjustment to incorporate an index of annual ocean impacts.

NATURAL ORIGIN BROOD STOCK

CC ID: 1203737
Seq. Order: 53
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Fish of natural origin removed from the returning run for use as hatchery brood stock.

CONTACT AGENCY

CC ID: 1203731
Seq. Order: 62
Data Storage Type: VARCHAR2
Max Length: 200
Required: No
Primary Key: No
Status: Active
Description:

Agency, Tribe or other entity, or person responsible for these data that is the best contact for questions that may arise about this data record.

Catalog Details

Catalog Item ID: 69089
GUID: gov.noaa.nmfs.inport:69089
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2023-01-12 21:09+0000
Metadata Record Last Modified By: Jeffrey W Cowen
Metadata Record Last Modified: 2023-01-12 21:15+0000
Metadata Record Published: 2023-01-12
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2017-11-30
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2018-11-30