Data description
AKFIN Answers is an Oracle BI tool used for distributing data to stock assessors and other users. Usernames and passwords are distinct from direct AKFIN database credentials.
Data tables
AKFIN_AGECOMP
This table is a copy of GAP_PRODUCTS.AGECOMP and does not have any other object dependencies. These data are produced 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. These data were last updated April 10, 2024.
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. |
AKFIN_AREA
This table is a copy of GAP_PRODUCTS.AREA and does not have any other object dependencies. These data are produced 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. These data were last updated April 10, 2024.
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. |
AKFIN_BIOMASS
This table is a copy of GAP_PRODUCTS.BIOMASS and does not have any other object dependencies. These data are produced 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. These data were last updated April 10, 2024.
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. |
AKFIN_CATCH
snapshot table for snapshot GAP_PRODUCTS.AKFIN_CATCH
Number of rows: 954,613
Number of columns: 6
| Column name from data | Descriptive column Name | Units | Oracle data type | Column description |
|---|---|---|---|---|
| CATCHJOIN | Catch observation ID | ID key code | NUMBER(38,0) | Unique integer ID assigned to each survey, vessel, year, and catch observation combination. |
| COUNT | Taxon count | count, whole number resolution | NUMBER(38,0) | Total whole number of individuals caught in haul or samples collected. |
| CRUISEJOIN | Cruise ID | ID key code | NUMBER(38,0) | Unique integer ID assigned to each survey, vessel, and year combination. |
| 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. |
AKFIN_CPUE
This table is a copy of GAP_PRODUCTS.CPUE and does not have any other object dependencies. These data are produced 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. These data were last updated April 10, 2024.
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. |
AKFIN_CRUISE
This is the cruise data table. These data are produced 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. These data were last updated April 10, 2024.
Number of rows: 170
Number of columns: 10
| Column name from data | Descriptive column Name | Units | Oracle data type | Column description |
|---|---|---|---|---|
| CRUISE | Cruise Name | ID key code | NUMBER(38,0) | This is a six-digit integer identifying the cruise number of the form: YYYY99 (where YYYY = year of the cruise; 99 = 2-digit number and is sequential; 01 denotes the first cruise that vessel made in this year, 02 is the second, etc.). |
| CRUISEJOIN | Cruise ID | ID key code | NUMBER(38,0) | Unique integer ID assigned to each survey, vessel, and year combination. |
| DATE_END | End date | YYYY-MM-DD | DATE | The date (YYYY-MM-DD) of the end of the event (e.g., cruise). |
| DATE_START | Start date | YYYY-MM-DD | DATE | The date (YYYY-MM-DD) of the beginning of the event (e.g., cruise). |
| SPONSOR_ACRONYM | NA | NA | NA | NA |
| 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. |
| SURVEY_NAME | Survey name official | text | VARCHAR2(255 BYTE) | Long name of the survey conducted |
| VESSEL_ID | Vessel ID | ID key code | NUMBER(38,0) | ID number of the vessel used to collect data for that haul. The column ‘vessel_id’ is associated with the ‘vessel_name’ column. Note that it is possible for a vessel to have a new name but the same vessel id number. For a complete list of vessel ID key codes, review the code books. |
| VESSEL_NAME | Vessel name | text | VARCHAR2(255 BYTE) | Name of the vessel used to collect data for that haul. The column ‘vessel_name’ is associated with the ‘vessel_id’ column. Note that it is possible for a vessel to have a new name but the same vessel id number. For a complete list of vessel ID key codes, review the code books. |
| YEAR | Survey year | year | NUMBER(10,0) | Year the observation (survey) was collected. |
AKFIN_HAUL
snapshot table for snapshot GAP_PRODUCTS.AKFIN_HAUL
Number of rows: 33,606
Number of columns: 25
| Column name from data | Descriptive column Name | Units | Oracle data type | Column description |
|---|---|---|---|---|
| ACCESSORIES | Type of gear accessories used on the net | ID key code | NUMBER(38,0) | Type of accessories used on net. For a complete list of accessories ID key codes, review the code books. |
| BOTTOM_TYPE | Seafloor bottom type code | ID key code | NUMBER(38,0) | Bottom type on sea floor at haul location. For a complete list of bottom type ID key codes, review the code books. |
| CRUISEJOIN | Cruise ID | ID key code | NUMBER(38,0) | Unique integer ID assigned to each survey, vessel, and year combination. |
| DATE_TIME_START | Start date and time | MM/DD/YYYY HH::MM | TIMESTAMP | The date (MM/DD/YYYY) and time (HH:MM) of the beginning of the haul. All dates and times are in Alaska time (AKDT) of Anchorage, AK, USA (UTC/GMT -8 hours). |
| DEPTH_GEAR_M | Depth of gear (m) | degrees Celsius | NUMBER(38,1) | Depth of gear (meters). |
| DEPTH_M | Depth (m) | degrees Celsius | NUMBER(38,1) | Bottom depth (meters). |
| DISTANCE_FISHED_KM | Distance fished (km) | degrees Celsius | NUMBER(38,3) | Distance the net fished (thousands of kilometers). |
| DURATION_HR | Tow duration (decimal hr) | hours | NUMBER(38,1) | This is the elapsed time between start and end of a haul (decimal hours). |
| GEAR | Type of gear used on the net | ID key code | NUMBER(38,0) | Type of gear used on net. For a complete list of gear ID key codes, review the code books. |
| GEAR_TEMPERATURE_C | Gear temperature (degrees Celsius) | degrees Celsius | NUMBER(38,1) | Temperature recorded by net gear (tenths of a degree Celsius); NA indicates removed or missing values. |
| HAUL | Haul number | ID key code | NUMBER(38,0) | This number uniquely identifies a sampling event (haul) within a cruise. It is a sequential number, in chronological order of occurrence. |
| HAULJOIN | Haul ID | ID key code | NUMBER(38,0) | This is a unique numeric identifier assigned to each (vessel, cruise, and haul) combination. |
| HAUL_TYPE | Haul sampling type | ID key code | NUMBER(38,0) | Type of haul sampling method. For a complete list of haul type ID key codes, review the code books. |
| LATITUDE_DD_END | End latitude (decimal degrees) | decimal degrees | NUMBER(38,6) | Latitude (one hundred thousandth of a decimal degree) of the end of the haul. |
| LATITUDE_DD_START | Start latitude (decimal degrees) | decimal degrees | NUMBER(38,6) | Latitude (one hundred thousandth of a decimal degree) of the start of the haul. |
| LONGITUDE_DD_END | End longitude (decimal degrees) | decimal degrees | NUMBER(38,6) | Longitude (one hundred thousandth of a decimal degree) of the end of the haul. |
| LONGITUDE_DD_START | Start longitude (decimal degrees) | decimal degrees | NUMBER(38,6) | Longitude (one hundred thousandth of a decimal degree) of the start of the haul. |
| NET_HEIGHT_M | Net height (m) | meters | NUMBER(38,1) | Measured or estimated distance (meters) between footrope and headrope of the trawl. |
| NET_MEASURED | Net measured during haul | logical | BINARY_DOUBLE | Logical, describing if the net was measured (TRUE) or not (FALSE) by wheelhouse and marport programs during the haul. |
| NET_WIDTH_M | Net width (m) | meters | NUMBER(38,1) | Measured or estimated distance (meters) between wingtips of the trawl. |
| PERFORMANCE | Haul performance code | category | NUMBER(38,0) | This denotes what, if any, issues arose during the haul. For more information, review the code books. |
| STATION | Station ID | ID key code | VARCHAR2(255 BYTE) | Alpha-numeric designation for the station established in the design of a survey. |
| 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. |
| SURFACE_TEMPERATURE_C | Surface temperature (degrees Celsius) | degrees Celsius | NUMBER(38,1) | Surface temperature (tenths of a degree Celsius); NA indicates removed or missing values. |
| WIRE_LENGTH_M | Trawl wire length | meters | NUMBER(38,0) | Length of wire deployed during a given haul in meters. |
AKFIN_LENGTH
snapshot table for snapshot GAP_PRODUCTS.AKFIN_LENGTH
Number of rows: 4,373,452
Number of columns: 7
| Column name from data | Descriptive column Name | Units | Oracle data type | Column description |
|---|---|---|---|---|
| FREQUENCY | Count of observation | count | NUMBER(38,0) | Frequency, or count, of an observation. |
| HAULJOIN | Haul ID | ID key code | NUMBER(38,0) | This is a unique numeric identifier assigned to each (vessel, cruise, and haul) combination. |
| LENGTH_MM | Length of a specimen | millimeters | NUMBER(10,0) | Length bin in millimeters. |
| LENGTH_TYPE | Length type | ID key code | NUMBER(38,0) | How the taxon was measured (e.g., fork length, carapace width). For a complete list of length_type ID key codes, review the code books. |
| SAMPLE_TYPE | Sample type | ID key code | NUMBER(38,0) | Sampling information on how the taxon was sampled. For a complete list of length_type ID key codes, review the code books. |
| 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. |
AKFIN_METADATA_COLUMN
This table is a copy of GAP_PRODUCTS.METADATA_COLUMN and does not have any other object dependencies. These data are produced 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. These data were last updated April 10, 2024.
Number of rows: 161
Number of columns: 5
| Column name from data | Descriptive column Name | Units | Oracle data type | Column description |
|---|---|---|---|---|
| METADATA_COLNAME | Column name | text | VARCHAR2(4000 BYTE) | Name of the column in a table. |
| METADATA_COLNAME_DESC | Column description | text | VARCHAR2(4000 BYTE) | Description of the column. |
| METADATA_COLNAME_LONG | Column name spelled out | text | VARCHAR2(4000 BYTE) | Long name for the column. |
| METADATA_DATATYPE | Oracle datatype code | text | VARCHAR2(4000 BYTE) | Oracle data type of data column. |
| METADATA_UNITS | Units | category | VARCHAR2(4000 BYTE) | Units of the column. |
AKFIN_SIZECOMP
This table is a copy of GAP_PRODUCTS.SIZECOMP and does not have any other object dependencies. These data are produced 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. 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. |
AKFIN_SPECIMEN
snapshot table for snapshot GAP_PRODUCTS.AKFIN_SPECIMEN
Number of rows: 576,760
Number of columns: 12
| 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. |
| AGE_DETERMINATION_METHOD | Aging method | ID key code | NUMBER(10,0) | Numeric code corresponding to the method of age determination. For a complete list of age determination codes, review the code books. |
| GONAD_G | Weight of gonads (g) | grams | NUMBER(38,1) | Weight of specimen gonads (grams). |
| HAULJOIN | Haul ID | ID key code | NUMBER(38,0) | This is a unique numeric identifier assigned to each (vessel, cruise, and haul) combination. |
| LENGTH_MM | Length of a specimen | millimeters | NUMBER(10,0) | Length bin in millimeters. |
| MATURITY | Specimen maturity code | ID key code | NUMBER(38,0) | The maturity code or the condition identified by the maturity code. |
| 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. |
| SPECIMEN_ID | Specimen unique ID | ID key code | NUMBER(38,0) | Each individual examined must have a number assigned to it that is unique within each haul (0001 to 9999), though specimen numbers may be repeated between hauls |
| SPECIMEN_SAMPLE_TYPE | Specimen sample type | ID key code | NUMBER(38,0) | The specimen sample type ID key code as defined in the RACE_DATA.SPECIMEN_SAMPLE_TYPES table. For a complete list of Specimen sample type ID key codes, review the code books. |
| SPECIMEN_SUBSAMPLE_METHOD | Specimen subsample method | ID key code | NUMBER(38,0) | For a complete list of specimen subsample method ID key codes, review the code books. |
| WEIGHT_G | Specimen weight (g) | grams | NUMBER(38,1) | Weight of specimen (grams). |
AKFIN_STRATUM_GROUPS
This table is a copy of GAP_PRODUCTS.STRATUM_GROUPS and does not have any other object dependencies. These data are produced 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. These data were last updated April 10, 2024.
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. |
AKFIN_SURVEY_DESIGN
This table is a copy of GAP_PRODUCTS.SURVEY_DESIGN and does not have any other object dependencies. These data are produced 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. These data were last updated April 10, 2024.
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. |
AKFIN_TAXONOMIC_CLASSIFICATION
NAThese data are produced 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. These data were last updated April 10, 2024.
Number of rows: 2,699
Number of columns: 19
| Column name from data | Descriptive column Name | Units | Oracle data type | Column description |
|---|---|---|---|---|
| CLASS_TAXON | Class phylogenetic rank | category | VARCHAR2(255 BYTE) | Phylogenetic latin rank of class of a given species. |
| COMMON_NAME | Taxon common name | text | VARCHAR2(255 BYTE) | The common name of the marine organism associated with the ‘scientific_name’ and ‘species_code’ columns. For a complete species list, review the code books. |
| DATABASE | Database source | category | VARCHAR2(255 BYTE) | Taxonomic database source, either ITIS or WoRMS. |
| DATABASE_ID | Species ID in database | ID key code | VARCHAR2(255 BYTE) | Species ID key code of a species in the taxonomic “DATABASE” source. |
| FAMILY_TAXON | Family phylogenetic rank | category | VARCHAR2(255 BYTE) | Phylogenetic latin rank of family of a given species. |
| GENUS_TAXON | Genus phylogenetic rank | category | VARCHAR2(255 BYTE) | Phylogenetic latin rank of genus of a given species. |
| ID_RANK | Lowest taxonomic rank | text | VARCHAR2(255 BYTE) | Lowest taxonomic rank of a given species entry. |
| KINGDOM_TAXON | Kingdom phylogenetic rank | category | VARCHAR2(255 BYTE) | Phylogenetic latin rank of kingdom of a given species. |
| ORDER_TAXON | Order phylogenetic rank | category | VARCHAR2(255 BYTE) | Phylogenetic latin rank of order of a given species. |
| PHYLUM_TAXON | Phylum phylogenetic rank | category | VARCHAR2(255 BYTE) | Phylogenetic latin rank of phylum of a given species. |
| 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. |
| SPECIES_NAME | Scientific name of species | text | VARCHAR2(255 BYTE) | Scientific name of species. |
| SUBCLASS_TAXON | Subclass phylogenetic rank | category | VARCHAR2(255 BYTE) | Phylogenetic latin rank of subclass of a given species. |
| SUBFAMILY_TAXON | Subfamily phylogenetic rank | category | VARCHAR2(255 BYTE) | Phylogenetic latin rank of subfamily of a given species. |
| SUBORDER_TAXON | Suborder phylogenetic rank | category | VARCHAR2(255 BYTE) | Phylogenetic latin rank of suborder of a given species. |
| SUBPHYLUM_TAXON | Subphylum phylogenetic rank | category | VARCHAR2(255 BYTE) | Phylogenetic latin rank of subphylum of a given species. |
| SUPERCLASS_TAXON | Superclass phylogenetic rank | category | VARCHAR2(255 BYTE) | Phylogenetic latin rank of superclass of a given species. |
| SUPERFAMILY_TAXON | Superfamily phylogenetic rank | category | VARCHAR2(255 BYTE) | Phylogenetic latin rank of superfamily of a given species. |
| SUPERORDER_TAXON | Superorder phylogenetic rank | category | VARCHAR2(255 BYTE) | Phylogenetic latin rank of superorder of a given species. |