Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Population Summary Archives
Short Name: Population Summary Archives
Status: Completed
Abstract:

Publicly available compilation of salmon abundance as reported at the salmon population level

Notes:

Loaded by batch 8351, 03-16-2016 13:08

Entity Information

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

Compilation of salmon abundance for spawners as reported at the salmon population level

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
POPULATION_DB_ID NUMBER Internal database ID that identifies a population.
100
DETAIL_DB_ID NUMBER Internal database ID that identifies the detailed record.
100
ESU_MAP VARCHAR2 Internal code used for displaying the ESU on a map.
100
ESU_DB_ID NUMBER Internal database ID that identifies the ESU.
100
COMMON_POPULATION_NAME VARCHAR2 Common name of the taxon of fish.
100
NWR_POPULATION_NAME VARCHAR2 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
NMFS_POPID NUMBER Unique ID associated with the ESU/DPS, population name and run time.
100
RECOVERY_DOMAIN VARCHAR2 Discrete geographic areas for which comprehensive recovery plans are being developed: Puget Sound, Willamette/Lower Columbia, Interior Columbia (including the Mid-Columbia, Upper Columbia, and Snake River sub-domains), Oregon Coast, and Southern/Oregon Northern California Coast.
100
MAJOR_POPULATION_GROUP VARCHAR2 Major Population Group, as defined by the NWR. Groups of populations within an ESU/DPS that are more similar to each other than they are to other populations. They are based on similarities in genetic characteristics, demographic patterns and habitat types and on geographic structure.
100
ESU_NAME VARCHAR2 For populations listed under the federal ESA, this is the name of a defined Evolutionary Significant Unit (ESU) or Distinct Population Segment (DPS) as defined by NMFS Northwest Region or by USFWS.
100
SPECIES VARCHAR2 Salmon species name.
100
RUN VARCHAR2 Run of fish, generally determined on the basis of the time of year at which adults enter fresh water to spawn. (Spring, Summer, Spring/Summer, Fall, Winter, early, or late)
100
START_YEAR NUMBER The first date the data was collected.
100
END_YEAR NUMBER The latest date the data was collected.
100
BROOD_YEAR NUMBER The year that adults enter the river to spawn.
100
FRACWILD 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
REGIME NUMBER Obsolete column.
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
TOTAL_SPAWNERS_WITHOUT_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_FRAC_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
NAT_NO_ORIGIN_BROOD_STOCK NUMBER Fish of natural origin removed from the returning run for use as hatchery broodstock.
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.
100
ARCHIVE_DB_ID NUMBER Internal database ID that identifies the archive.
100
ARCHIVE_NAME VARCHAR2 The name of the archive.
100
ARCHIVE_NOTE VARCHAR2 Any special notes about the archive.
100
ARCHIVE_DATE DATE The date the archive was created.

Attribute Details

POPULATION_DB_ID

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

Internal database ID that identifies a population.

General Data Type: NUMBER

DETAIL_DB_ID

CC ID: 305501
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Internal database ID that identifies the detailed record.

General Data Type: NUMBER

ESU_MAP

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

Internal code used for displaying the ESU on a map.

General Data Type: VARCHAR2

ESU_DB_ID

CC ID: 305519
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Internal database ID that identifies the ESU.

General Data Type: NUMBER

COMMON_POPULATION_NAME

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

Common name of the taxon of fish.

General Data Type: VARCHAR2

NWR_POPULATION_NAME

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

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.

General Data Type: VARCHAR2

NMFS_POPID

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

Unique ID associated with the ESU/DPS, population name and run time.

General Data Type: NUMBER

RECOVERY_DOMAIN

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

Discrete geographic areas for which comprehensive recovery plans are being developed: Puget Sound, Willamette/Lower Columbia, Interior Columbia (including the Mid-Columbia, Upper Columbia, and Snake River sub-domains), Oregon Coast, and Southern/Oregon Northern California Coast.

General Data Type: VARCHAR2

MAJOR_POPULATION_GROUP

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

Major Population Group, as defined by the NWR. Groups of populations within an ESU/DPS that are more similar to each other than they are to other populations. They are based on similarities in genetic characteristics, demographic patterns and habitat types and on geographic structure.

General Data Type: VARCHAR2

ESU_NAME

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

For populations listed under the federal ESA, this is the name of a defined Evolutionary Significant Unit (ESU) or Distinct Population Segment (DPS) as defined by NMFS Northwest Region or by USFWS.

General Data Type: VARCHAR2

SPECIES

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

Salmon species name.

General Data Type: VARCHAR2

RUN

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

Run of fish, generally determined on the basis of the time of year at which adults enter fresh water to spawn. (Spring, Summer, Spring/Summer, Fall, Winter, early, or late)

General Data Type: VARCHAR2

START_YEAR

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

The first date the data was collected.

General Data Type: NUMBER

END_YEAR

CC ID: 305495
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

The latest date the data was collected.

General Data Type: NUMBER

BROOD_YEAR

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

The year that adults enter the river to spawn.

General Data Type: NUMBER

FRACWILD

CC ID: 305497
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

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

General Data Type: NUMBER

AGE_1_RETURNS

CC ID: 305498
Seq. Order: 17
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.

General Data Type: NUMBER

AGE_2_RETURNS

CC ID: 305499
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

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

General Data Type: NUMBER

AGE_3_RETURNS

CC ID: 305500
Seq. Order: 19
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.

General Data Type: NUMBER

AGE_4_RETURNS

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

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

General Data Type: NUMBER

AGE_5_RETURNS

CC ID: 305503
Seq. Order: 21
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.

General Data Type: NUMBER

AGE_6_RETURNS

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

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

General Data Type: NUMBER

AGE_7_RETURNS

CC ID: 305505
Seq. Order: 23
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.

General Data Type: NUMBER

REGIME

CC ID: 305506
Seq. Order: 24
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Obsolete column.

General Data Type: NUMBER

NATURAL_SPAWNERS_WITH_JACKS

CC ID: 305507
Seq. Order: 25
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.

General Data Type: NUMBER

TOTAL_SPAWNERS_WITH_JACKS

CC ID: 305508
Seq. Order: 26
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
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.

General Data Type: NUMBER

TOTAL_SPAWNERS_WITHOUT_JACKS

CC ID: 305509
Seq. Order: 27
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.

General Data Type: NUMBER

JACK_FRAC_OF_HATCHERY_SPAWNERS

CC ID: 305510
Seq. Order: 28
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
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).

General Data Type: NUMBER

ADULT_NATURAL_HARVEST_RATE

CC ID: 305511
Seq. Order: 29
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.

General Data Type: NUMBER

NAT_NO_ORIGIN_BROOD_STOCK

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

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

General Data Type: NUMBER

CONTACT_AGENCY

CC ID: 305514
Seq. Order: 31
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.

General Data Type: VARCHAR2

ARCHIVE_DB_ID

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

Internal database ID that identifies the archive.

General Data Type: NUMBER

ARCHIVE_NAME

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

The name of the archive.

General Data Type: VARCHAR2

ARCHIVE_NOTE

CC ID: 305517
Seq. Order: 34
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Any special notes about the archive.

General Data Type: VARCHAR2

ARCHIVE_DATE

CC ID: 305518
Seq. Order: 35
Data Storage Type: DATE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

The date the archive was created.

General Data Type: DATE

Catalog Details

Catalog Item ID: 31377
GUID: gov.noaa.nmfs.inport:31377
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2016-03-16 13:08+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2016-05-11
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2017-05-12