31377 Population Summary Archives Entity Published / External 17904 SPS Abundance - Salmon spawner abundance data compilation and database management Data Set Completed Publicly available compilation of salmon abundance as reported at the salmon population level Loaded by batch 8351, 03-16-2016 13:08 Data View Yes SPS Compilation of salmon abundance for spawners as reported at the salmon population level 1 POPULATION_DB_ID NUMBER 22 No No Active Internal database ID that identifies a population. NUMBER 2 DETAIL_DB_ID NUMBER 22 Yes No 38 Active Internal database ID that identifies the detailed record. NUMBER 3 ESU_MAP VARCHAR2 131 No No Active Internal code used for displaying the ESU on a map. VARCHAR2 4 ESU_DB_ID NUMBER 22 No No 38 Active Internal database ID that identifies the ESU. NUMBER 5 COMMON_POPULATION_NAME VARCHAR2 100 No No Active Common name of the taxon of fish. VARCHAR2 6 NWR_POPULATION_NAME VARCHAR2 255 No No Active 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. VARCHAR2 7 NMFS_POPID NUMBER 22 No No Active Unique ID associated with the ESU/DPS, population name and run time. NUMBER 8 RECOVERY_DOMAIN VARCHAR2 50 No No Active 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. VARCHAR2 9 MAJOR_POPULATION_GROUP VARCHAR2 50 No No Active 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. VARCHAR2 10 ESU_NAME VARCHAR2 100 No No Active 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. VARCHAR2 11 SPECIES VARCHAR2 40 No No Active Salmon species name. VARCHAR2 12 RUN VARCHAR2 50 No No Active 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) VARCHAR2 13 START_YEAR NUMBER 22 No No 0 Active The first date the data was collected. NUMBER 14 END_YEAR NUMBER 22 No No 38 0 Active The latest date the data was collected. NUMBER 15 BROOD_YEAR NUMBER 22 No No Active The year that adults enter the river to spawn. NUMBER 16 FRACWILD NUMBER 22 No No 38 Active The fraction of the total spawners that are the progeny of naturally-spawning fish. NUMBER 17 AGE_1_RETURNS NUMBER 22 No No Active The fraction of fish who are defined as having an age of 1 that returned to spawn in a given year. NUMBER 18 AGE_2_RETURNS NUMBER 22 No No 38 Active The fraction of fish who are defined as having an age of 2 that returned to spawn in a given year. NUMBER 19 AGE_3_RETURNS NUMBER 22 No No Active The fraction of fish who are defined as having an age of 3 that returned to spawn in a given year. NUMBER 20 AGE_4_RETURNS NUMBER 22 No No 38 Active The fraction of fish who are defined as having an age of 4 that returned to spawn in a given year. NUMBER 21 AGE_5_RETURNS NUMBER 22 No No Active The fraction of fish who are defined as having an age of 5 that returned to spawn in a given year. NUMBER 22 AGE_6_RETURNS NUMBER 22 No No 38 Active The fraction of fish who are defined as having an age of 6 that returned to spawn in a given year. NUMBER 23 AGE_7_RETURNS NUMBER 22 No No Active The fraction of fish who are defined as having an age of 7 that returned to spawn in a given year. NUMBER 24 REGIME NUMBER 22 No No 38 Active Obsolete column. NUMBER 25 NATURAL_SPAWNERS_WITH_JACKS NUMBER 22 No No Active 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. NUMBER 26 TOTAL_SPAWNERS_WITH_JACKS NUMBER 22 No No 38 Active 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. NUMBER 27 TOTAL_SPAWNERS_WITHOUT_JACKS NUMBER 22 No No Active 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. NUMBER 28 JACK_FRAC_OF_HATCHERY_SPAWNERS NUMBER 22 No No 38 Active 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). NUMBER 29 ADULT_NATURAL_HARVEST_RATE NUMBER 22 No No Active 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. NUMBER 30 NAT_NO_ORIGIN_BROOD_STOCK NUMBER 22 No No 38 Active Fish of natural origin removed from the returning run for use as hatchery broodstock. NUMBER 31 CONTACT_AGENCY VARCHAR2 200 No No Active 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. VARCHAR2 32 ARCHIVE_DB_ID NUMBER 22 Yes No 38 Active Internal database ID that identifies the archive. NUMBER 33 ARCHIVE_NAME VARCHAR2 50 Yes No Active The name of the archive. VARCHAR2 34 ARCHIVE_NOTE VARCHAR2 4000 No No Active Any special notes about the archive. VARCHAR2 35 ARCHIVE_DATE DATE 8 No No Active The date the archive was created. DATE gov.noaa.nmfs.inport:31377 Jeffrey Cowen 2016-03-16T13:08:02 SysAdmin InPortAdmin 2022-08-09T17:10:58 2016-05-11 Northwest Fisheries Science Center NWFSC 2725 Montlake Boulevard East Seattle WA 98112 USA 206-860-3200 https://www.nwfsc.noaa.gov 1001 Public No 2016-05-11 1 Year 2017-05-11