Population data and references for the Salmon Population Summary (SPS) Database
Northwest Fisheries Science Center
Entity
(ENT)
| ID: 35856
| Published / External
Created: 2016-12-02
|
Last Modified: 2022-11-21
Data Set (DS) | ID: 17904
ID: 35856
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Population data and references for the Salmon Population Summary (SPS) Database |
---|---|
Short Name | Population data and references for the Salmon Population Summary (SPS) Database |
* Status | Planned |
Creation Date | |
Revision Date | |
• Publication Date | |
* » 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 NWFSC 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. |
* 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 | Data Table |
---|---|
Active Version? | Y |
Alias | |
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 NWFSC 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. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | COMMON_POPULATION_NAME | VARCHAR2 | Name of population as people may commonly refer to it. |
100 | No | No | NWR_POPULATION_NAME | VARCHAR2 | Name of the population as defined by 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 | No | No | GENUS | VARCHAR2 | The name of the genus that the population belongs to. |
100 | No | No | SPECIES | VARCHAR2 | The name of the specie that the population belongs to. |
100 | No | No | STREAM_NAME | VARCHAR2 | Name of the River or drainage identifying or containing the population. |
100 | No | No | RUN_TIMING | VARCHAR2 | The season of the year for the return of the population to its anadromous waters. i.e. Spring, Summer, Winter or Fall |
100 | No | No | START_YEAR | NUMBER | The earliest year that viable salmonid population statistics are reported for this population. |
100 | No | No | END_YEAR | NUMBER | The latest year that viable salmonid population statistics are reported for this population. |
100 | No | No | BROOD_YEAR | NUMBER | The year that adults enter to the river to spawn. |
100 | No | No | VIABILITY_TYPE | VARCHAR2 | The type-classification of this particular population viability figure. |
100 | No | No | RUN | VARCHAR2 | The Season of the Year represented by this viability figure for the population. |
100 | No | No | NUMBER_OF_SPAWNERS | NUMBER | The total number of fish returning to spawn in the data collection year. |
100 | No | No | SPAWNER_NOTES | VARCHAR2 | Comments or other helpful information about the observation of spawners in this viability computation. |
100 | No | No | FRACWILD | NUMBER | The fraction of the total spawners that are the progeny of naturally-spawning fish. |
100 | No | No | HATCHERY_FRACTION | NUMBER | A value between 0 and 1 that is the fraction of natural origin spawners. Natural origin spawners are spawners whose parents spawned in the wild. The fracWild is equal to one minus the fraction of first generation hatchery fish spawning in a given year. If all hatchery fish are marked, this value is the fraction of unmarked fish observed in a given year. |
100 | No | No | HATCHERY_FRACTION_NOTES | VARCHAR2 | Comments or other information about the observed or estimated Hatchery fraction of the fish in this viability computation. |
100 | No | No | EFFECTIVE_CATCH | NUMBER | The number of additional wild fish that would have returned to spawn in a given year had there not been a catch (harvest). |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | AGE_1_HARVEST | NUMBER | Proportion of catch composed of age-1 fish. Deprecated. |
100 | No | No | AGE_2_HARVEST | NUMBER | Proportion of catch composed of age-2 fish. Deprecated. |
100 | No | No | AGE_3_HARVEST | NUMBER | Proportion of catch composed of age-3 fish. Deprecated. |
100 | No | No | AGE_4_HARVEST | NUMBER | Proportion of catch composed of age-4 fish. Deprecated. |
100 | No | No | AGE_5_HARVEST | NUMBER | Proportion of catch composed of age-5 fish. Deprecated. |
100 | No | No | AGE_6_HARVEST | NUMBER | Proportion of catch composed of age-6 fish. Deprecated. |
100 | No | No | AGE_7_HARVEST | NUMBER | Proportion of catch composed of age-7 fish. Deprecated. |
100 | No | No | REGIME | NUMBER | Regime is an index of environmental conditions (usually intended as a measure of ocean survival) that should be entered as a decimal number centered on 1. It is used as a multiplier to adjust recruitment to average environmental conditions. When conditions are worse than average (regime < 1), recruits are adjusted upwards, when they are better than average (regime > 1), recruits are adjusted downwards. |
100 | No | No | AGE_NOTES | VARCHAR2 | Comments or other information giving further description of the population's age or age-structure. |
100 | No | No | ABUND_COUNT_EXTERNAL_FILE_1_LI | VARCHAR2 | A web-link to any pertinent external document that relates to this population and year. |
100 | No | No | ABUND_COUNT_EXTERNAL_FILE_2_LI | VARCHAR2 | A web-link to a second pertinent external document that relates to this population and year. |
100 | No | No | 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 | No | No | 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 | No | No | NATURAL_ADULT_ANNUAL_RUN_4_6 | NUMBER | Estimated number of adult spawners of natural origin in a particular year. |
100 | No | No | 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 | No | No | 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 | No | No | NAT_NO_ORIGIN_BROOD_STOCK | NUMBER | Fish of natural origin removed from the returning run for use as hatchery brood stock. |
100 | No | No | ADULT_BROOD_RETURNS | NUMBER | Total future adult returns produced from spawning in a particular brood year. Expressed as returns to the spawning grounds. For chinook, adult brood year returns from year n are calculated as the sum of age 4 returns in year (n+4), age 5 returns in year (n+5) and age 6 returns in year (n+6). |
100 | No | No | SAR_ADJUSTED_ADULT_BRD_RETURNS | NUMBER | Total brood year returns proportionally adjusted to reflect an average annual smolt to adult return rate over a specified range of years. For Interior Columbia analyses, the average SARs are generally calculated for outmigration years 1980 to the most recent complete brood year (e.g., 2001). |
100 | No | No | LINK_REFERENCE_S | NUMBER | Natural log of the ratio of returns to parent spawners. In the ICTRT analyses, both terms are expressed as adults to the spawning grounds. |
100 | No | No | ADJUSTED_LINK_REFERENCE_S | NUMBER | Natural log return/spawner proportionally adjusted to reflect an average SAR.??? For Interior Columbia analyses, the average SARs are generally |
100 | No | No | HATCHERY_RETURN | NUMBER | The number of returning fish that were reared in a hatchery. Currently this data is not provided. |
100 | No | No | AGE_DATA_TYPE | VARCHAR2 | Indicates how age was estimated for a group of fish. Currently this data is not collected. Acceptable values: 1) If population-scale carcass sample size is = 20, apply the Annual Population Age Structure. 2) Else, if population-scale carcass sample size is = 19, apply the Annual Aggregate MPG Age Structure. 3) Else, if MPG-scale carcass sample size is = 19, apply the Long-Term (i.e.19601997) Population Average Age Structure. |
100 | No | No | AGE_DETERMINATION_SAMPLE_SIZE | NUMBER | Number of samples used in age structure determination. |
100 | No | No | 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 | No | No | 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 | No | No | NMFS_POPID | NUMBER | The foreign key to pull in the Population Name for the source database. |
100 | No | No | AGE_TITLE | VARCHAR2 | The recognized title for a piece of reference material. |
100 | No | No | AGE_AUTHOR | VARCHAR2 | The name of the author of a piece of reference material. |
100 | No | No | AGE_PUBYEAR | VARCHAR2 | If the reference material is published, the four-digit year in which the reference material was published. |
100 | No | No | AGE_PUBLISHER | VARCHAR2 | If the reference material is published, the name of the publisher of the reference material. |
100 | No | No | AGE_REF_NOTES | VARCHAR2 | Any comments or other information about the reference material or its publication or use. |
100 | No | No | CATCH_TITLE | VARCHAR2 | The recognized title for a piece of reference material. |
100 | No | No | CATCH_AUTHOR | VARCHAR2 | The name of the author of a piece of reference material. |
100 | No | No | CATCH_PUBYEAR | VARCHAR2 | If the reference material is published, the four-digit year in which the reference material was published. |
100 | No | No | CATCH_PUBLISHER | VARCHAR2 | If the reference material is published, the name of the publisher of the reference material. |
100 | No | No | CATCH_REF_NOTES | VARCHAR2 | Any comments or other information about the reference material or its publication or use. |
100 | No | No | SPAWNER_TITLE | VARCHAR2 | The recognized title for a piece of reference material. |
100 | No | No | SPAWNER_AUTHOR | VARCHAR2 | The name of the author of a piece of reference material. |
100 | No | No | SPAWNER_PUBYEAR | VARCHAR2 | If the reference material is published, the four-digit year in which the reference material was published. |
100 | No | No | SPAWNER_PUBLISHER | VARCHAR2 | If the reference material is published, the name of the publisher of the reference material. |
100 | No | No | SPAWNER_REF_NOTES | VARCHAR2 | Any comments or other information about the reference material or its publication or use. |
100 | No | No | WILD_FRAC_TITLE | VARCHAR2 | The recognized title for a piece of reference material. |
100 | No | No | WILD_FRAC_AUTHOR | VARCHAR2 | The name of the author of a piece of reference material. |
100 | No | No | WILD_FRAC_PUBYEAR | VARCHAR2 | If the reference material is published, the four-digit year in which the reference material was published. |
100 | No | No | WILD_FRAC_PUBLISHER | VARCHAR2 | If the reference material is published, the name of the publisher of the reference material. |
100 | No | No | WILD_FRAC_REF_NOTES | VARCHAR2 | Any comments or other information about the reference material or its publication or use. |
Attribute Details
Attribute Name | RECOVERY_DOMAIN |
---|---|
Seq. Order | 4 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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). |
General Data Type | VARCHAR2 |
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 | ESU_NAME |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR2 |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | VARCHAR2 |
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 | MAJOR_POPULATION_GROUP |
---|---|
Seq. Order | 9 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | VARCHAR2 |
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 | COMMON_POPULATION_NAME |
---|---|
Seq. Order | 10 |
Data Storage Type | VARCHAR2 |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of population as people may commonly refer to it. |
General Data Type | VARCHAR2 |
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 | NWR_POPULATION_NAME |
---|---|
Seq. Order | 11 |
Data Storage Type | VARCHAR2 |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of the population as defined by 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. |
General Data Type | VARCHAR2 |
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 | GENUS |
---|---|
Seq. Order | 14 |
Data Storage Type | VARCHAR2 |
Max Length | 200 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The name of the genus that the population belongs to. |
General Data Type | VARCHAR2 |
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 | SPECIES |
---|---|
Seq. Order | 15 |
Data Storage Type | VARCHAR2 |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The name of the specie that the population belongs to. |
General Data Type | VARCHAR2 |
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 | STREAM_NAME |
---|---|
Seq. Order | 16 |
Data Storage Type | VARCHAR2 |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of the River or drainage identifying or containing the population. |
General Data Type | VARCHAR2 |
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 | RUN_TIMING |
---|---|
Seq. Order | 17 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The season of the year for the return of the population to its anadromous waters. i.e. Spring, Summer, Winter or Fall |
General Data Type | VARCHAR2 |
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 | START_YEAR |
---|---|
Seq. Order | 18 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 0 |
Status | Active |
Description |
The earliest year that viable salmonid population statistics are reported for this population. |
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 | END_YEAR |
---|---|
Seq. Order | 19 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 0 |
Status | Active |
Description |
The latest year that viable salmonid population statistics are reported for this population. |
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 | BROOD_YEAR |
---|---|
Seq. Order | 20 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The year that adults enter to the river to spawn. |
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 | VIABILITY_TYPE |
---|---|
Seq. Order | 21 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The type-classification of this particular population viability figure. |
General Data Type | VARCHAR2 |
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 | RUN |
---|---|
Seq. Order | 22 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The Season of the Year represented by this viability figure for the population. |
General Data Type | VARCHAR2 |
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 | NUMBER_OF_SPAWNERS |
---|---|
Seq. Order | 23 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The total number of fish returning to spawn in the data collection year. |
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 | SPAWNER_NOTES |
---|---|
Seq. Order | 24 |
Data Storage Type | VARCHAR2 |
Max Length | 4000 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Comments or other helpful information about the observation of spawners in this viability computation. |
General Data Type | VARCHAR2 |
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 | FRACWILD |
---|---|
Seq. Order | 25 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The fraction of the total spawners that are the progeny of naturally-spawning fish. |
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 | HATCHERY_FRACTION |
---|---|
Seq. Order | 26 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A value between 0 and 1 that is the fraction of natural origin spawners. Natural origin spawners are spawners whose parents spawned in the wild. The fracWild is equal to one minus the fraction of first generation hatchery fish spawning in a given year. If all hatchery fish are marked, this value is the fraction of unmarked fish observed in a given year. |
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 | HATCHERY_FRACTION_NOTES |
---|---|
Seq. Order | 27 |
Data Storage Type | VARCHAR2 |
Max Length | 4000 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Comments or other information about the observed or estimated Hatchery fraction of the fish in this viability computation. |
General Data Type | VARCHAR2 |
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 | EFFECTIVE_CATCH |
---|---|
Seq. Order | 28 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The number of additional wild fish that would have returned to spawn in a given year had there not been a catch (harvest). |
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 | AGE_1_RETURNS |
---|---|
Seq. Order | 29 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
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 | AGE_2_RETURNS |
---|---|
Seq. Order | 30 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
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 | AGE_3_RETURNS |
---|---|
Seq. Order | 31 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
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 | AGE_4_RETURNS |
---|---|
Seq. Order | 32 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
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 | AGE_5_RETURNS |
---|---|
Seq. Order | 33 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
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 | AGE_6_RETURNS |
---|---|
Seq. Order | 34 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
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 | AGE_7_RETURNS |
---|---|
Seq. Order | 35 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
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 | AGE_1_HARVEST |
---|---|
Seq. Order | 36 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Proportion of catch composed of age-1 fish. Deprecated. |
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 | AGE_2_HARVEST |
---|---|
Seq. Order | 37 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Proportion of catch composed of age-2 fish. Deprecated. |
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 | AGE_3_HARVEST |
---|---|
Seq. Order | 38 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Proportion of catch composed of age-3 fish. Deprecated. |
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 | AGE_4_HARVEST |
---|---|
Seq. Order | 39 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Proportion of catch composed of age-4 fish. Deprecated. |
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 | AGE_5_HARVEST |
---|---|
Seq. Order | 40 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Proportion of catch composed of age-5 fish. Deprecated. |
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 | AGE_6_HARVEST |
---|---|
Seq. Order | 41 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Proportion of catch composed of age-6 fish. Deprecated. |
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 | AGE_7_HARVEST |
---|---|
Seq. Order | 42 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Proportion of catch composed of age-7 fish. Deprecated. |
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 | REGIME |
---|---|
Seq. Order | 43 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Regime is an index of environmental conditions (usually intended as a measure of ocean survival) that should be entered as a decimal number centered on 1. It is used as a multiplier to adjust recruitment to average environmental conditions. When conditions are worse than average (regime < 1), recruits are adjusted upwards, when they are better than average (regime > 1), recruits are adjusted downwards. |
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 | AGE_NOTES |
---|---|
Seq. Order | 44 |
Data Storage Type | VARCHAR2 |
Max Length | 4000 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Comments or other information giving further description of the population's age or age-structure. |
General Data Type | VARCHAR2 |
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 | ABUND_COUNT_EXTERNAL_FILE_1_LI |
---|---|
Seq. Order | 45 |
Data Storage Type | VARCHAR2 |
Max Length | 500 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A web-link to any pertinent external document that relates to this population and year. |
General Data Type | VARCHAR2 |
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 | ABUND_COUNT_EXTERNAL_FILE_2_LI |
---|---|
Seq. Order | 46 |
Data Storage Type | VARCHAR2 |
Max Length | 500 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A web-link to a second pertinent external document that relates to this population and year. |
General Data Type | VARCHAR2 |
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 | TOTAL_SPAWNERS_WITH_JACKS |
---|---|
Seq. Order | 48 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
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 | NATURAL_SPAWNERS_WITH_JACKS |
---|---|
Seq. Order | 49 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
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 | NATURAL_ADULT_ANNUAL_RUN_4_6 |
---|---|
Seq. Order | 50 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Estimated number of adult spawners of natural origin in a particular year. |
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 | JACK_FRAC_OF_HATCHERY_SPAWNERS |
---|---|
Seq. Order | 51 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
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 | ADULT_NATURAL_HARVEST_RATE |
---|---|
Seq. Order | 52 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
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 | NAT_NO_ORIGIN_BROOD_STOCK |
---|---|
Seq. Order | 53 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Fish of natural origin removed from the returning run for use as hatchery brood stock. |
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 | ADULT_BROOD_RETURNS |
---|---|
Seq. Order | 54 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Total future adult returns produced from spawning in a particular brood year. Expressed as returns to the spawning grounds. For chinook, adult brood year returns from year n are calculated as the sum of age 4 returns in year (n+4), age 5 returns in year (n+5) and age 6 returns in year (n+6). |
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 | SAR_ADJUSTED_ADULT_BRD_RETURNS |
---|---|
Seq. Order | 55 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Total brood year returns proportionally adjusted to reflect an average annual smolt to adult return rate over a specified range of years. For Interior Columbia analyses, the average SARs are generally calculated for outmigration years 1980 to the most recent complete brood year (e.g., 2001). |
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 | LINK_REFERENCE_S |
---|---|
Seq. Order | 56 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Natural log of the ratio of returns to parent spawners. In the ICTRT analyses, both terms are expressed as adults to the spawning grounds. |
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 | ADJUSTED_LINK_REFERENCE_S |
---|---|
Seq. Order | 57 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Natural log return/spawner proportionally adjusted to reflect an average SAR.??? For Interior Columbia analyses, the average SARs are generally |
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 | HATCHERY_RETURN |
---|---|
Seq. Order | 58 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The number of returning fish that were reared in a hatchery. Currently this data is not provided. |
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 | AGE_DATA_TYPE |
---|---|
Seq. Order | 59 |
Data Storage Type | VARCHAR2 |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates how age was estimated for a group of fish. Currently this data is not collected. Acceptable values: 1) If population-scale carcass sample size is = 20, apply the Annual Population Age Structure. 2) Else, if population-scale carcass sample size is = 19, apply the Annual Aggregate MPG Age Structure. 3) Else, if MPG-scale carcass sample size is = 19, apply the Long-Term (i.e.19601997) Population Average Age Structure. |
General Data Type | VARCHAR2 |
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 | AGE_DETERMINATION_SAMPLE_SIZE |
---|---|
Seq. Order | 60 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of samples used in age structure determination. |
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 | TOTAL_SPAWNERS_WITHOUT_JACKS |
---|---|
Seq. Order | 61 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
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 | CONTACT_AGENCY |
---|---|
Seq. Order | 62 |
Data Storage Type | VARCHAR2 |
Max Length | 200 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
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 | NMFS_POPID |
---|---|
Seq. Order | 63 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The foreign key to pull in the Population Name for the source database. |
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 | AGE_TITLE |
---|---|
Seq. Order | 64 |
Data Storage Type | VARCHAR2 |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The recognized title for a piece of reference material. |
General Data Type | VARCHAR2 |
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 | AGE_AUTHOR |
---|---|
Seq. Order | 65 |
Data Storage Type | VARCHAR2 |
Max Length | 400 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The name of the author of a piece of reference material. |
General Data Type | VARCHAR2 |
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 | AGE_PUBYEAR |
---|---|
Seq. Order | 66 |
Data Storage Type | VARCHAR2 |
Max Length | 45 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
If the reference material is published, the four-digit year in which the reference material was published. |
General Data Type | VARCHAR2 |
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 | AGE_PUBLISHER |
---|---|
Seq. Order | 67 |
Data Storage Type | VARCHAR2 |
Max Length | 200 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
If the reference material is published, the name of the publisher of the reference material. |
General Data Type | VARCHAR2 |
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 | AGE_REF_NOTES |
---|---|
Seq. Order | 68 |
Data Storage Type | VARCHAR2 |
Max Length | 2000 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Any comments or other information about the reference material or its publication or use. |
General Data Type | VARCHAR2 |
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 | CATCH_TITLE |
---|---|
Seq. Order | 69 |
Data Storage Type | VARCHAR2 |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The recognized title for a piece of reference material. |
General Data Type | VARCHAR2 |
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 | CATCH_AUTHOR |
---|---|
Seq. Order | 70 |
Data Storage Type | VARCHAR2 |
Max Length | 400 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The name of the author of a piece of reference material. |
General Data Type | VARCHAR2 |
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 | CATCH_PUBYEAR |
---|---|
Seq. Order | 71 |
Data Storage Type | VARCHAR2 |
Max Length | 45 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
If the reference material is published, the four-digit year in which the reference material was published. |
General Data Type | VARCHAR2 |
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 | CATCH_PUBLISHER |
---|---|
Seq. Order | 72 |
Data Storage Type | VARCHAR2 |
Max Length | 200 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
If the reference material is published, the name of the publisher of the reference material. |
General Data Type | VARCHAR2 |
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 | CATCH_REF_NOTES |
---|---|
Seq. Order | 73 |
Data Storage Type | VARCHAR2 |
Max Length | 2000 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Any comments or other information about the reference material or its publication or use. |
General Data Type | VARCHAR2 |
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 | SPAWNER_TITLE |
---|---|
Seq. Order | 74 |
Data Storage Type | VARCHAR2 |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The recognized title for a piece of reference material. |
General Data Type | VARCHAR2 |
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 | SPAWNER_AUTHOR |
---|---|
Seq. Order | 75 |
Data Storage Type | VARCHAR2 |
Max Length | 400 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The name of the author of a piece of reference material. |
General Data Type | VARCHAR2 |
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 | SPAWNER_PUBYEAR |
---|---|
Seq. Order | 76 |
Data Storage Type | VARCHAR2 |
Max Length | 45 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
If the reference material is published, the four-digit year in which the reference material was published. |
General Data Type | VARCHAR2 |
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 | SPAWNER_PUBLISHER |
---|---|
Seq. Order | 77 |
Data Storage Type | VARCHAR2 |
Max Length | 200 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
If the reference material is published, the name of the publisher of the reference material. |
General Data Type | VARCHAR2 |
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 | SPAWNER_REF_NOTES |
---|---|
Seq. Order | 78 |
Data Storage Type | VARCHAR2 |
Max Length | 2000 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Any comments or other information about the reference material or its publication or use. |
General Data Type | VARCHAR2 |
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 | WILD_FRAC_TITLE |
---|---|
Seq. Order | 79 |
Data Storage Type | VARCHAR2 |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The recognized title for a piece of reference material. |
General Data Type | VARCHAR2 |
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 | WILD_FRAC_AUTHOR |
---|---|
Seq. Order | 80 |
Data Storage Type | VARCHAR2 |
Max Length | 400 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The name of the author of a piece of reference material. |
General Data Type | VARCHAR2 |
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 | WILD_FRAC_PUBYEAR |
---|---|
Seq. Order | 81 |
Data Storage Type | VARCHAR2 |
Max Length | 45 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
If the reference material is published, the four-digit year in which the reference material was published. |
General Data Type | VARCHAR2 |
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 | WILD_FRAC_PUBLISHER |
---|---|
Seq. Order | 82 |
Data Storage Type | VARCHAR2 |
Max Length | 200 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
If the reference material is published, the name of the publisher of the reference material. |
General Data Type | VARCHAR2 |
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 | WILD_FRAC_REF_NOTES |
---|---|
Seq. Order | 83 |
Data Storage Type | VARCHAR2 |
Max Length | 2000 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Any comments or other information about the reference material or its publication or use. |
General Data Type | VARCHAR2 |
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 | |
---|---|
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
* » 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 | 35856 |
---|---|
Metadata Record Created By | Jeffrey W Cowen |
Metadata Record Created | 2016-12-02 15:28+0000 |
Metadata Record Last Modified By | Jeffrey W Cowen |
» Metadata Record Last Modified | 2022-11-21 19:59+0000 |
Metadata Record Published | 2017-11-30 |
Owner Org | NWFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2017-11-30 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2018-11-30 |
Tags |
---|