Data description
Data tables
AGECOMP
Region-level age compositions by sex/length bin.
Number of rows: 662,289
Number of columns: 10
Column name from data | Descriptive column Name | Units | Oracle data type | Column description |
---|---|---|---|---|
AGE | Taxon age bin (yrs) | integer | NUMBER(38,0) | Age bin of taxon. Age bin of a taxon in years estimated by the age comp estimate. |
AREA_ID | Area ID | ID key code | NUMBER(38,0) | Area ID key code for each statistical area used to produce production estimates (e.g., biomass, population, age comps, length comps). Each area ID is unique within each survey. |
AREA_ID_FOOTPRINT | NA | NA | NA | NA |
LENGTH_MM_MEAN | Mean length at age weighted by numbers at length | numeric | NUMBER(38,3) | Mean length (millimeters) |
LENGTH_MM_SD | Standard deviation of length at age weighted by numbers at length | numeric | NUMBER(38,3) | Variance of mean length. |
POPULATION_COUNT | Estimated population | numeric | NUMBER(38,0) | The estimated population caught in the survey for a species, group, or total for a given survey. |
SEX | Sex of a specimen | ID key code | NUMBER(38,0) | Sex of a specimen where “1” = “Male”, “2” = “Female”, “3” = Unsexed. |
SPECIES_CODE | Taxon code | ID key code | NUMBER(38,0) | The species code of the organism associated with the ‘common_name’ and ‘scientific_name’ columns. For a complete species list, review the code books. |
SURVEY_DEFINITION_ID | Survey ID | ID key code | NUMBER(38,0) | The survey definition ID key code uniquely identifies a survey/survey design. Integer code that uniquely identifies survey. Full list of survey definition IDs are in RACE_DATA.SURVEY_DEFINITIONS. IDs used in GAP_PRODUCTS are: 47 (Gulf of Alaska); 52 (Aleutian Islands); 78 (Bering Sea Slope); 98 (Eastern Bering Sea Shelf); 143 (Northern Bering Sea Shelf). The column ‘survey_definition_id’ is associated with the ‘srvy’ and ‘survey’ columns. For a complete list of surveys, review the code books. |
YEAR | Survey year | year | NUMBER(10,0) | Year the observation (survey) was collected. |
AREA
This table contains all of the information related to the various strata, subareas, INPFC and NMFS management areas, and regions for the Aleutian Islands, Gulf of Alaska, and Bering Sea shelf and slope bottom trawl surveys. These tables are created by the Resource Assessment and Conservation Engineering Division (RACE) Groundfish Assessment Program (GAP) of the Alaska Fisheries Science Center (AFSC). The GitHub repository for the scripts that created this code can be found at https://github.com/afsc-gap-products/gap_products. These data were last updated April 02, 2024. There are no legal restrictions on access to the data. For more information about codes used in the tables, please refer to the survey code books (https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual).
Number of rows: 395
Number of columns: 9
Column name from data | Descriptive column Name | Units | Oracle data type | Column description |
---|---|---|---|---|
AREA_ID | Area ID | ID key code | NUMBER(38,0) | Area ID key code for each statistical area used to produce production estimates (e.g., biomass, population, age comps, length comps). Each area ID is unique within each survey. |
AREA_KM2 | Area (km2) | kilometers squared | NUMBER(38,3) | Area in square kilometers. |
AREA_NAME | Area ID name | text | VARCHAR2(4000 BYTE) | Descriptive name of each AREA_ID. These names often identify the region, depth ranges, or other regional information for the area ID. |
AREA_TYPE | Area ID type description | category | VARCHAR2(255 BYTE) | The type of stratum that AREA_ID represents. Types include: STRATUM (the smallest building-block unit of area in these surveys), REGION, DEPTH, SUBAREA, INPFC BY DEPTH, INPFC, SUBAREA BY DEPTH, REGULATORY AREA, NMFS STATISTICAL AREA. |
DEPTH_MAX_M | Area ID maximum depth (m) | meters | NUMBER(38,3) | Maximum depth (meters). |
DEPTH_MIN_M | Area ID minimum depth (m) | meters | NUMBER(38,3) | Minimum depth (meters). |
DESCRIPTION | Description | text | VARCHAR2(4000 BYTE) | Description of row observation. |
DESIGN_YEAR | Design year | year | NUMBER(10,0) | Year ID associated with a given value AREA_ID. This field describes the changes in the survey design over time. |
SURVEY_DEFINITION_ID | Survey ID | ID key code | NUMBER(38,0) | The survey definition ID key code uniquely identifies a survey/survey design. Integer code that uniquely identifies survey. Full list of survey definition IDs are in RACE_DATA.SURVEY_DEFINITIONS. IDs used in GAP_PRODUCTS are: 47 (Gulf of Alaska); 52 (Aleutian Islands); 78 (Bering Sea Slope); 98 (Eastern Bering Sea Shelf); 143 (Northern Bering Sea Shelf). The column ‘survey_definition_id’ is associated with the ‘srvy’ and ‘survey’ columns. For a complete list of surveys, review the code books. |
BIOMASS
Stratum/subarea/region-level mean CPUE (weight and numbers), total biomass, and total abundance with associated variances.
Number of rows: 2,576,866
Number of columns: 16
Column name from data | Descriptive column Name | Units | Oracle data type | Column description |
---|---|---|---|---|
AREA_ID | Area ID | ID key code | NUMBER(38,0) | Area ID key code for each statistical area used to produce production estimates (e.g., biomass, population, age comps, length comps). Each area ID is unique within each survey. |
BIOMASS_MT | Estimated biomass | numeric | NUMBER(38,6) | The estimated total biomass. |
BIOMASS_VAR | Estimated biomass variance | numeric | NUMBER(38,6) | The estimated variance associated with the total biomass. |
CPUE_KGKM2_MEAN | Mean weight CPUE | kilograms per kilometers squared | NUMBER(38,6) | The mean catch weight (kilograms) per unit effort (area swept by the net, units squared kilometers). |
CPUE_KGKM2_VAR | Variance of the mean weight CPUE | kilograms per kilometers squared | NUMBER(38,6) | The variance of mean catch weight (kilograms) per unit effort (area swept by the net, units squared kilometers). |
CPUE_NOKM2_MEAN | Mean numeric CPUE | count per kilometers squared | NUMBER(38,6) | The mean of numerical catch per unit effort (area swept by the net, units square kilometers). |
CPUE_NOKM2_VAR | Variance of the mean numeric CPUE | count per kilometers squared | NUMBER(38,6) | The variance of mean numerical catch per unit effort (area swept by the net, units square kilometers). |
N_COUNT | Hauls with taxon counts | numeric | NUMBER(38,0) | Total number of hauls with positive count data. |
N_HAUL | Valid hauls | count | NUMBER(38,0) | Total number of hauls. |
N_LENGTH | Hauls with taxon lengths | count | NUMBER(38,0) | Total number of hauls with length data. |
N_WEIGHT | Hauls with catch | count | NUMBER(38,0) | Total number of hauls with positive catch biomass. |
POPULATION_COUNT | Estimated population | numeric | NUMBER(38,0) | The estimated population caught in the survey for a species, group, or total for a given survey. |
POPULATION_VAR | Estimated population variance | numeric | NUMBER(38,6) | The estimated population variance caught in the survey for a species, group, or total for a given survey. |
SPECIES_CODE | Taxon code | ID key code | NUMBER(38,0) | The species code of the organism associated with the ‘common_name’ and ‘scientific_name’ columns. For a complete species list, review the code books. |
SURVEY_DEFINITION_ID | Survey ID | ID key code | NUMBER(38,0) | The survey definition ID key code uniquely identifies a survey/survey design. Integer code that uniquely identifies survey. Full list of survey definition IDs are in RACE_DATA.SURVEY_DEFINITIONS. IDs used in GAP_PRODUCTS are: 47 (Gulf of Alaska); 52 (Aleutian Islands); 78 (Bering Sea Slope); 98 (Eastern Bering Sea Shelf); 143 (Northern Bering Sea Shelf). The column ‘survey_definition_id’ is associated with the ‘srvy’ and ‘survey’ columns. For a complete list of surveys, review the code books. |
YEAR | Survey year | year | NUMBER(10,0) | Year the observation (survey) was collected. |
CPUE
Haul-level zero-filled weight and numerical catch-per-unit-effort.
Number of rows: 21,360,338
Number of columns: 7
Column name from data | Descriptive column Name | Units | Oracle data type | Column description |
---|---|---|---|---|
AREA_SWEPT_KM2 | Area swept (km) | kilometers | NUMBER(38,6) | The area the net covered while the net was fishing (kilometers squared), defined as the distance fished times the net width. |
COUNT | Taxon count | count, whole number resolution | NUMBER(38,0) | Total whole number of individuals caught in haul or samples collected. |
CPUE_KGKM2 | Weight CPUE (kg/km2) | kilograms per kilometers squared | NUMBER(38,6) | Catch weight (kilograms) per unit effort (area swept by the net, units square kilometers). |
CPUE_NOKM2 | Number CPUE (no/km2) | count per kilometers squared | NUMBER(38,6) | Numerical catch per unit effort (area swept by the net, units square kilometers). |
HAULJOIN | Haul ID | ID key code | NUMBER(38,0) | This is a unique numeric identifier assigned to each (vessel, cruise, and haul) combination. |
SPECIES_CODE | Taxon code | ID key code | NUMBER(38,0) | The species code of the organism associated with the ‘common_name’ and ‘scientific_name’ columns. For a complete species list, review the code books. |
WEIGHT_KG | Sample or taxon weight (kg) | kilograms | NUMBER(38,3) | Weight (thousandths of a kilogram) of individuals in a haul by taxon. |
SURVEY_DESIGN
This table contains for a given survey (via SURVEY_DEFINITION_ID) and survey year (YEAR), which version (DESIGN_YEAR) of the AREA_IDs that were used to calculate the various standard data products. These tables are created by the Resource Assessment and Conservation Engineering Division (RACE) Groundfish Assessment Program (GAP) of the Alaska Fisheries Science Center (AFSC). The GitHub repository for the scripts that created this code can be found at https://github.com/afsc-gap-products/gap_products. These data were last updated April 02, 2024. There are no legal restrictions on access to the data. For more information about codes used in the tables, please refer to the survey code books (https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual).
Number of rows: 87
Number of columns: 3
Column name from data | Descriptive column Name | Units | Oracle data type | Column description |
---|---|---|---|---|
DESIGN_YEAR | Design year | year | NUMBER(10,0) | Year ID associated with a given value AREA_ID. This field describes the changes in the survey design over time. |
SURVEY_DEFINITION_ID | Survey ID | ID key code | NUMBER(38,0) | The survey definition ID key code uniquely identifies a survey/survey design. Integer code that uniquely identifies survey. Full list of survey definition IDs are in RACE_DATA.SURVEY_DEFINITIONS. IDs used in GAP_PRODUCTS are: 47 (Gulf of Alaska); 52 (Aleutian Islands); 78 (Bering Sea Slope); 98 (Eastern Bering Sea Shelf); 143 (Northern Bering Sea Shelf). The column ‘survey_definition_id’ is associated with the ‘srvy’ and ‘survey’ columns. For a complete list of surveys, review the code books. |
YEAR | Survey year | year | NUMBER(10,0) | Year the observation (survey) was collected. |
METADATA_TABLE
These columns provide the table metadata for all of the tables and views in GAP_PRODUCTS. These tables are created by the Resource Assessment and Conservation Engineering Division (RACE) Groundfish Assessment Program (GAP) of the Alaska Fisheries Science Center (AFSC). The GitHub repository for the scripts that created this code can be found at https://github.com/afsc-gap-products/gap_products. These data were last updated April 02, 2024. There are no legal restrictions on access to the data. For more information about codes used in the tables, please refer to the survey code books (https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual).
Number of rows: 8
Number of columns: 3
Column name from data | Descriptive column Name | Units | Oracle data type | Column description |
---|---|---|---|---|
METADATA_SENTENCE | Sentence | text | VARCHAR2(4000 BYTE) | Table metadata sentence. |
METADATA_SENTENCE_NAME | Metadata sentence name | text | VARCHAR2(4000 BYTE) | Name of table metadata sentence. |
METADATA_SENTENCE_TYPE | Sentence type | text | VARCHAR2(4000 BYTE) | Type of sentence to have in table metadata. |
STRATUM_GROUPS
This table contains all of strata that are contained within a given subarea, INPFC or NMFS management area, or region for the Aleutian Islands, Gulf of Alaska, and Bering Sea shelf and slope bottom trawl surveys. These tables are created by the Resource Assessment and Conservation Engineering Division (RACE) Groundfish Assessment Program (GAP) of the Alaska Fisheries Science Center (AFSC). The GitHub repository for the scripts that created this code can be found at https://github.com/afsc-gap-products/gap_products. These data were last updated April 02, 2024. There are no legal restrictions on access to the data. For more information about codes used in the tables, please refer to the survey code books (https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual).
Number of rows: 768
Number of columns: 4
Column name from data | Descriptive column Name | Units | Oracle data type | Column description |
---|---|---|---|---|
AREA_ID | Area ID | ID key code | NUMBER(38,0) | Area ID key code for each statistical area used to produce production estimates (e.g., biomass, population, age comps, length comps). Each area ID is unique within each survey. |
DESIGN_YEAR | Design year | year | NUMBER(10,0) | Year ID associated with a given value AREA_ID. This field describes the changes in the survey design over time. |
STRATUM | Stratum ID | ID key code | NUMBER(10,0) | RACE database statistical area for analyzing data. Strata were designed using bathymetry and other geographic and habitat-related elements. The strata are unique to each survey region. Stratum of value 0 indicates experimental tows. |
SURVEY_DEFINITION_ID | Survey ID | ID key code | NUMBER(38,0) | The survey definition ID key code uniquely identifies a survey/survey design. Integer code that uniquely identifies survey. Full list of survey definition IDs are in RACE_DATA.SURVEY_DEFINITIONS. IDs used in GAP_PRODUCTS are: 47 (Gulf of Alaska); 52 (Aleutian Islands); 78 (Bering Sea Slope); 98 (Eastern Bering Sea Shelf); 143 (Northern Bering Sea Shelf). The column ‘survey_definition_id’ is associated with the ‘srvy’ and ‘survey’ columns. For a complete list of surveys, review the code books. |
SIZECOMP
Stratum/subarea/region-level size compositions by sex. This table was created by the Resource Assessment and Conservation Engineering Division (RACE) Groundfish Assessment Program (GAP) of the Alaska Fisheries Science Center (AFSC). There are legal restrictions on access to the data. These data are not intended for public dissemination and should not be shared without the explicit written consent of the data managers and owners (NOAA Fisheries). The GitHub repository for the scripts that created this code can be found at https://github.com/afsc-gap-products/gap_products. For more information about codes used in the tables, please refer to the survey code books (https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual). These data were last updated April 10, 2024.
Number of rows: 3,209,517
Number of columns: 7
Column name from data | Descriptive column Name | Units | Oracle data type | Column description |
---|---|---|---|---|
AREA_ID | Area ID | ID key code | NUMBER(38,0) | Area ID key code for each statistical area used to produce production estimates (e.g., biomass, population, age comps, length comps). Each area ID is unique within each survey. |
LENGTH_MM | Length of a specimen | millimeters | NUMBER(10,0) | Length bin in millimeters. |
POPULATION_COUNT | Estimated population | numeric | NUMBER(38,0) | The estimated population caught in the survey for a species, group, or total for a given survey. |
SEX | Sex of a specimen | ID key code | NUMBER(38,0) | Sex of a specimen where “1” = “Male”, “2” = “Female”, “3” = Unsexed. |
SPECIES_CODE | Taxon code | ID key code | NUMBER(38,0) | The species code of the organism associated with the ‘common_name’ and ‘scientific_name’ columns. For a complete species list, review the code books. |
SURVEY_DEFINITION_ID | Survey ID | ID key code | NUMBER(38,0) | The survey definition ID key code uniquely identifies a survey/survey design. Integer code that uniquely identifies survey. Full list of survey definition IDs are in RACE_DATA.SURVEY_DEFINITIONS. IDs used in GAP_PRODUCTS are: 47 (Gulf of Alaska); 52 (Aleutian Islands); 78 (Bering Sea Slope); 98 (Eastern Bering Sea Shelf); 143 (Northern Bering Sea Shelf). The column ‘survey_definition_id’ is associated with the ‘srvy’ and ‘survey’ columns. For a complete list of surveys, review the code books. |
YEAR | Survey year | year | NUMBER(10,0) | Year the observation (survey) was collected. |