22008 AFSC/RACE/GAP: RACEBASE Database Data Set Published / External 22291 Groundfish Assessment Program Project In Work The core function of the Resource Assessment and Conservation Engineering (RACE) Division is to conduct quantitative fishery surveys and related ecological and oceanographic research to measure and describe the distribution and abundance of commercially important fish and crab stocks in the eastern Bering Sea, Aleutian Islands, Gulf of Alaska, and, historically, the West Coast.The survey data are stored in a database called RACEBASE. It serves as the repository for both raw and summary data collected from the surveys dating from 1953 to present. It does not hold stream data. The purpose of this record is to document the main entities and attributes of RACEBASE. Loaded by FGDC Metadata Uploader, batch 5038, 07-31-2014 11:27 The following FGDC sections are not currently supported in InPort, but were preserved and will be included in the FGDC export: - Taxonomy (FGDC:taxonomy) - Entity Attribute Information (FGDC:eainfo) RACE BOTTOM TRAWL SURVEY CODEBOOK https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual NOAA Protocols for Groundfish Bottom Trawl Surveys of the Nation's Fishery Resources: chrome-extension://bdfcnmeidppjeaggnmidamkiddifkdib/viewer.html?file=https://spo.nmfs.noaa.gov/sites/default/files/tm65.pdf Theme ISO 19115 Topic Category biota Theme ISO 19115 Topic Category oceans Theme habitat Theme salinity Theme water temperature Temporal fall Temporal summer Temporal winter Spatial Alaska Spatial Alaska, AK, Gulf of Alaska, Bering Sea, Aleutian Islands, Pacific Ocean, Kodiak, Kenai, Chukchi Sea, Prince William Sound, Shumagin Islands, Yakutat, West Coast Spatial Aleutian Islands Spatial Bering Sea Alaska Fisheries Science Center Seattle WA USA Series Oracle Database As Needed Table (digital) The RACE Groundfish and Shellfish Assessment Programs of the NOAA Fisheries Alaska Fisheries Science Center and the crew of the various fishing vessel for their assistance in securing biological, haul, and environmental data for these time series data sets N/A N/A N/A 69746 CATCH Published / External Completed Summary values for organisms caught in the net, summarized by species and haul. Fields contain total weight and number of each species and whether any organisms were collected for voucher specimens Data Table Yes RACEBASE Summary values for organisms caught in the net, summarized by species and haul. Fields contain total weight and number of each species and whether any organisms were collected for voucher specimens 1 CRUISEJOIN NUMBER 22 Yes No 12 0 Active This is a unique numeric identifier assigned to each VESSEL, CRUISE) combination NUMBER 2 HAULJOIN NUMBER 22 Yes No 12 0 Active This is a unique numeric identifier assigned to each (VESSEL, CRUISE, HAUL) combination NUMBER 3 CATCHJOIN NUMBER 22 Yes Yes 12 0 Active This is a unique numeric identifier assigned to each (VESSEL, CRUISE, HAUL, SPECIES_CODE) combination NUMBER 4 REGION VARCHAR2 3 Yes No Active Valid Values: AI=Aleutian Islands, BS=Bering Sea, GOA=Gulf of Alaska, WC=West Coast,HBS=Hydroacoustic Bering Sea, HG=Hydroacoustic Gulf of Alaska, HWC=Hydroacoustic West Coast, TAG=Denotes that no biological data exist for this cruise other than those related to tags released or recovered. VARCHAR2 5 VESSEL NUMBER 22 Yes No 4 0 Active Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual NUMBER 6 CRUISE NUMBER 22 Yes No 6 0 Active This is a six-digit number 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. NUMBER 7 HAUL NUMBER 22 Yes No 4 0 Active This number uniquely identifies a haul within a cruise. It is a sequential number, in chronological order of occurrence. NUMBER 8 SPECIES_CODE NUMBER 22 Yes No 5 0 Active Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual NUMBER 9 WEIGHT NUMBER 22 Yes No 9 3 Active Kilogram (kg). This value is the extrapolated Weight, to nearest thousandth of a kg, for each species in the catch. Collected in pounds in 1993 and prior years and has since been converted to kg NUMBER 10 NUMBER_FISH NUMBER 22 No No 6 0 Active Valid Values: whole numbers, 0, and null. This value is the extrapolated total number of individuals of this species caught in the haul. NUMBER 11 SUBSAMPLE_CODE VARCHAR2 2 No No Active Unused attribute VARCHAR2 12 VOUCHER NUMBER 22 No No 4 0 Active Reference number given to specimens that are collected and preserved for taxonomic identification purposes. These are assigned sequentially beginning with 1 and re-initiated for each haul NUMBER 13 AUDITJOIN NUMBER 22 No No 12 0 Active This is a unique identifier for each record in the base table, to be used in corresponding audit tables to identify the original record in the base table NUMBER 69747 CRUISE Published / External Completed A lookup table for every cruise that is in the RACEBASE database. It summarizes locations, dates, the country performing the survey and cruise name for each cruise Data Table Yes RACEBASE A lookup table for every cruise that is in the RACEBASE database. It summarizes locations, dates, the country performing the survey and cruise name for each cruise 1 CRUISEJOIN NUMBER 22 No No 12 0 Active This is a unique numeric identifier assigned to each (VESSEL,CRUISE) combination NUMBER 2 REGION VARCHAR2 3 Yes No Active Valid Values: AI=Aleutian Islands, BS=Bering Sea, GOA=Gulf of Alaska, WC=West Coast,HBS=Hydroacoustic Bering Sea, HG=Hydroacoustic Gulf of Alaska, HWC=Hydroacoustic West Coast, TAG=Denotes that no biological data exist for this cruise other than those related to tags released or recovered. VARCHAR2 3 VESSEL NUMBER 22 Yes No 4 0 Active Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual NUMBER 4 CRUISE NUMBER 22 Yes No 6 0 Active This is a six-digit number 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.) NUMBER 5 START_DATE DATE 7 Yes No Active Date. This is the date of the first haul of the cruise; this field is populated using a query - select min (start_time)from racebase.haul DATE 6 END_DATE DATE 7 Yes No Active Date. This is the date of the last haul of the cruise; this field is populated value using a query - select max (start_time) from a racebase.haul DATE 7 MIN_LATITUDE NUMBER 22 Yes No 7 5 Active Latitude in decimal degrees. These are the southern bounding coordinates of cruise. NUMBER 8 MAX_LATITUDE NUMBER 22 Yes No 7 5 Active Latitude in decimal degrees. These are the northern bounding coordinates of the cruise. NUMBER 9 MIN_LONGITUDE NUMBER 22 Yes No 8 5 Active Longitude in decimal degrees. These are the eastern bounding coordinates of cruise. NUMBER 10 MAX_LONGITUDE NUMBER 22 Yes No 8 5 Active Longitude in decimal degrees. These are the western bounding coordinates of cruise. NUMBER 11 AGENCY_NAME VARCHAR2 40 Yes No Active Text. Name of country or countries that conducted the cruise VARCHAR2 12 SURVEY_NAME VARCHAR2 80 Yes No Active Text. Description of the survey. VARCHAR2 13 AUDITJOIN NUMBER 22 No No 12 0 Active This is a unique identifier for each record in the base table, to be used in corresponding audit tables to identify the original record in the base table NUMBER 69748 HAUL Published / External Completed Summary values describing each haul (i.e. location, duration, gear depth, distance, net width, net height, bottom type, bottom depth and temperature). Note: For hydroaccoustic data (any record with a region of HBS, HG or HWC) trawls are performed only for target confirmation and should not to be used for calculating CPUE. Data Table Yes RACEBASE Summary values describing each haul (i.e. location, duration, gear depth, distance, net width, net height, bottom type, bottom depth and temperature). Note: For hydroaccoustic data (any record with a region of HBS, HG or HWC) trawls are performed only for target confirmation and should not to be used for calculating CPUE. 1 CRUISEJOIN NUMBER 22 Yes No 12 0 Active This is a unique numeric identifier assigned to each (VESSEL,CRUISE) combination NUMBER 2 HAULJOIN NUMBER 22 Yes Yes 12 0 Active This is a unique numeric identifier assigned to each (VESSEL, CRUISE, HAUL) combination NUMBER 3 REGION VARCHAR2 3 Yes No Active Valid Values: AI=Aleutian Islands, BS=Bering Sea, GOA=Gulf of Alaska, WC=West Coast,HBS=Hydroacoustic Bering Sea, HG=Hydroacoustic Gulf of Alaska, HWC=Hydroacoustic West Coast, TAG=Denotes that no biological data exist for this cruise other than those related to tags released or recovered. VARCHAR2 4 VESSEL NUMBER 22 Yes No 4 0 Active Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual NUMBER 5 CRUISE NUMBER 22 Yes No 6 0 Active This is a six-digit number 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. NUMBER 6 HAUL NUMBER 22 Yes No 4 0 Active This number uniquely identifies a haul within a cruise. It is a sequential number, in chronological order of occurrence. NUMBER 7 HAUL_TYPE NUMBER 22 Yes No 4 0 Active Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual NUMBER 8 PERFORMANCE NUMBER 22 Yes No 3 2 Active Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual NUMBER 9 START_TIME DATE 7 Yes No Active Date. This is the date and time at the beginning of the haul; For groundfish trawl data, this is the on-bottom time which is determined after we have looked at the bottom-contact sensor and net-mensuration plots. For hydroacoustic data, start_time is when the first fish is captured (displayed on the net sounder) or when the net is at target depth and location. DATE 10 DURATION NUMBER 22 No No 6 4 Active Decimal hour. This is the elapsed time between start and end of a haul. The bottom contact sensors showed up in 1994 and were put into service in GOA in 1995 and EBS in 1996. We assume that DURATION is On bottom minus Off bottom started along with BC use NUMBER 11 DISTANCE_FISHED NUMBER 22 No No 5 3 Active kilometers (km) in thousandths of a km NUMBER 12 NET_WIDTH NUMBER 22 No No 5 3 Active Measured or estimated distance (m) between wingtips of the trawl. NUMBER 13 NET_MEASURED VARCHAR2 2 No No Active This is a Y/N field, to indicate whether the NET_WIDTH was measured or estimated: Yes (Y) means that NET_WIDTH was measured and (N) indicates that NET_WIDTH was calculated VARCHAR2 14 NET_HEIGHT NUMBER 22 No No 5 3 Active Measured or estimated distance (m) between footrope and headrope of the trawl. NUMBER 15 STRATUM NUMBER 22 No No 3 0 Active RACE database statistical area for analyzing data. Strata were designed using bathymetry and other measures of habitat and are unique to each survey series. NUMBER 16 START_LATITUDE NUMBER 22 Yes No 7 5 Active The latitude (decimal degrees) at the start of the haul NUMBER 17 END_LATITUDE NUMBER 22 No No 7 5 Active The latitude (decimal degrees) at the end of the haul NUMBER 18 START_LONGITUDE NUMBER 22 Yes No 8 5 Active The longitude (decimal degrees) at the start of the haul. NUMBER 19 END_LONGITUDE NUMBER 22 No No 8 5 Active The longitude (decimal degrees) at the end of the haul NUMBER 20 STATIONID VARCHAR2 10 No No Active Alpha-numeric designation for the Station established in the design of a Survey. VARCHAR2 21 GEAR_DEPTH NUMBER 22 No No 5 0 Active Meters (m). Weighted average depth (m) of trawl measured at the headrope (Groundfish) or footrope (MACE). Prior to (year?), before NET-HEIGHT was regularly measured, this value was used synonymously with BOTTOM_DEPTH. NUMBER 22 BOTTOM_DEPTH NUMBER 22 No No 5 0 Active Meters (m). Weighted average depth (m) and is calculated by adding GEAR_DEPTH to NET_HEIGHT. Prior to (year), before NET_HEIGHT was regularly measured, this value was obtained using either echosounder or bathythermograph. NUMBER 23 BOTTOM_TYPE VARCHAR2 3 No No Active Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual VARCHAR2 24 SURFACE_TEMPERATURE NUMBER 22 No No 3 1 Active Surface temperature, in tenths of a degree, Celsius. Null values indicate temperature not recorded. NUMBER 25 GEAR_TEMPERATURE NUMBER 22 No No 3 1 Active Weighted average temperature (in tenths of a degree Celsius) measured at the maximum depth of the headrope of the trawl. Null values indicate temperature was not recorded. NUMBER 26 WIRE_LENGTH NUMBER 22 No No 6 0 Active meters (m); Length of trawl wire (warp) deployed. NUMBER 27 GEAR VARCHAR2 4 Yes No Active Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual VARCHAR2 28 ACCESSORIES VARCHAR2 3 Yes No Active Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual VARCHAR2 29 SUBSAMPLE VARCHAR2 2 Yes No Active Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual VARCHAR2 30 AUDITJOIN NUMBER 22 No No 12 0 Active This is a unique identifier for each record in the base table, to be used in corresponding audit tables to identify the original record in the base table NUMBER 31 ABUNDANCE_HAUL VARCHAR2 1 No No Active Biomass hauls are defined as positive performance survey trawl hauls (i.e., haul performance considered to be acceptable) from an Alaska Fisheries Science Center bottom trawl survey time-series for which a sampling design, gear type, accessory type, tow duration and survey methodology are standardized such that the distance fished and average net spread from those hauls can be used to calculate an area swept for standardizing catch sample weights and numbers by survey year and by taxon or taxonomic group in terms of Catch per Unit Effort (CPUE). CPUEs are used to derive estimates of biomass, population size, abundance-at-length and abundance-at-age that can be used to index or monitor trends in marine life populations over the span of the respective survey time-series for purposes of stock assessment, ecosystem monitoring or other research. VARCHAR2 69749 LENGTH Published / External Completed Summarizes length frequency by species and sex for each haul Data Table Yes RACEBASE Summarizes length frequency by species and sex for each haul 1 CRUISEJOIN NUMBER 22 Yes No 12 0 Active This is a unique numeric identifier assigned to each (VESSEL,CRUISE) combination NUMBER 2 HAULJOIN NUMBER 22 Yes No 12 0 Active This is a unique numeric identifier assigned to each (VESSEL, CRUISE, HAUL) combination NUMBER 3 CATCHJOIN NUMBER 22 Yes No 12 0 Active This is a unique numeric identifier assigned to each (VESSEL, CRUISE, HAUL, SPECIES_CODE) combination NUMBER 4 REGION VARCHAR2 3 Yes No Active Valid Values: AI=Aleutian Islands, BS=Bering Sea, GOA=Gulf of Alaska, WC=West Coast,HBS=Hydroacoustic Bering Sea, HG=Hydroacoustic Gulf of Alaska, HWC=Hydroacoustic West Coast, TAG=Denotes that no biological data exist for this cruise other than those related to tags released or recovered. VARCHAR2 5 VESSEL NUMBER 22 Yes No 4 0 Active Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual NUMBER 6 CRUISE NUMBER 22 Yes No 6 0 Active This is a six-digit number 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.) NUMBER 7 HAUL NUMBER 22 Yes No 4 0 Active This number uniquely identifies a haul within a cruise. It is a sequential number, in chronological order of occurrence. NUMBER 8 SPECIES_CODE NUMBER 22 Yes No 5 0 Active Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual NUMBER 9 LENGTH NUMBER 22 Yes No 5 0 Active Millimeter (mm) NUMBER 10 FREQUENCY NUMBER 22 Yes No 5 0 Active Must be at least 001 NUMBER 11 SEX NUMBER 22 Yes No 1 0 Active Valid Values: 1=male, 2=female, 3=undetermined NUMBER 12 SAMPLE_TYPE NUMBER 22 No No 1 0 Active Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual NUMBER 13 LENGTH_TYPE NUMBER 22 No No 2 0 Active Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual NUMBER 14 AUDITJOIN NUMBER 22 No No 12 0 Active This is a unique identifier for each record in the base table, to be used in corresponding audit tables to identify the original record in the base table NUMBER 69750 SPECIMEN Published / External Completed Raw, biological specimen data for each haul Data Table Yes RACEBASE Raw, biological specimen data for each haul 1 CRUISEJOIN NUMBER 22 Yes No 12 0 Active This is a unique numeric identifier assigned to each (VESSEL,CRUISE) combination NUMBER 2 HAULJOIN NUMBER 22 No No 12 0 Active This is a unique numeric identifier assigned to each (VESSEL, CRUISE, HAUL) combination NUMBER 3 REGION VARCHAR2 3 Yes No Active Valid Values: AI=Aleutian Islands, BS=Bering Sea, GOA=Gulf of Alaska, WC=West Coast,HBS=Hydroacoustic Bering Sea, HG=Hydroacoustic Gulf of Alaska, HWC=Hydroacoustic West Coast, TAG=Denotes that no biological data exist for this cruise other than those related to tags released or recovered. VARCHAR2 4 VESSEL NUMBER 22 Yes No 4 0 Active Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual NUMBER 5 CRUISE NUMBER 22 Yes No 6 0 Active This is a six-digit number 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. NUMBER 6 HAUL NUMBER 22 Yes No 4 0 Active This number uniquely identifies a haul within a cruise. It is a sequential number, in chronological order of occurrence. NUMBER 7 SPECIMENID NUMBER 22 Yes No 9 0 Active (0001 to 9999; Each individual examined must have a number assigned to it that is unique within each haul. However, specimen numbers may be repeated between hauls NUMBER 8 BIOSTRATUM NUMBER 22 Yes No 3 0 Active Domain: Historical RACE ADP Codebooks; (this attribute is historical and its codeset domain, at present, is unable to be found. This was a stratification scheme for otoliths that is different from geographic stratum. CAUTION: There are cases where the biostratum column field was used for data other than biostratum data. Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual NUMBER 9 SPECIES_CODE NUMBER 22 Yes No 5 0 Active Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual NUMBER 10 LENGTH NUMBER 22 Yes No 5 0 Active Millimeter (mm) NUMBER 11 SEX NUMBER 22 Yes No 1 0 Active Valid Values: 1=male, 2=female, 3=undetermined NUMBER 12 WEIGHT NUMBER 22 No No 6 0 Active Grams (g). NUMBER 13 AGE NUMBER 22 No No 3 0 Active Whole Numbers and null. This value represents the age of fish in years NUMBER 14 MATURITY NUMBER 22 No No 1 0 Active Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual NUMBER 15 MATURITY_TABLE NUMBER 22 No No 2 0 Active Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual NUMBER 16 GONAD_WT NUMBER 22 No No 3 0 Active grams (g) NUMBER 17 AUDITJOIN NUMBER 22 No No 12 0 Active This is a unique identifier for each record in the base table, to be used in corresponding audit tables to identify the original record in the base table NUMBER 18 SPECIMEN_SUBSAMPLE_METHOD NUMBER 22 No No 6 0 Active Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual NUMBER 19 SPECIMEN_SAMPLE_TYPE NUMBER 22 No No 6 0 Active Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual NUMBER 20 AGE_DETERMINATION_METHOD NUMBER 22 No No 6 0 Active Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual NUMBER 21 MINIMUM_AGE NUMBER 22 No No Active NUMBER 22 MAXIMUM_AGE NUMBER 22 No No Active NUMBER 23 COMMENTS VARCHAR2 300 No No Active VARCHAR2 Data Steward 2024 Person Anderson, Chris christopher.anderson@noaa.gov https://orcid.org/0009-0004-1469-344X Distributor 2015 Organization Alaska Fisheries Science Center AFSC afsc.webmaster@noaa.gov https://ror.org/01h7fye62 7600 Sand Point Way N.E., Building 4 Seattle WA 98115 USA (206) 526-4000 (206) 526-4004 https://www.fisheries.noaa.gov/about/alaska-fisheries-science-center AKFSC Home Page Online Resource 0700-1700 Pacific Time Metadata Contact 2025 Person Anderson, Chris christopher.anderson@noaa.gov https://orcid.org/0009-0004-1469-344X Point of Contact 2025 Person Anderson, Chris christopher.anderson@noaa.gov https://orcid.org/0009-0004-1469-344X Ground Condition 161.91167 -117.4167 72.07583 32.36567 Eastern Bering Sea, Aleutian Islands, Gulf of Alaska, and the West Coast Range 1953 2022 Unclassified unknown There are no legal restrictions on access to the data. They reside in public domain and can be freely distributed. User must read and fully comprehend the metadata prior to use. Applications or inferences derived from the data should be carefully considered for accuracy. Acknowledgementof NOAA/NMFS/AFSC, as the source from which these data were obtained in any publications and/or other representations of these, data is suggested. https://www.fisheries.noaa.gov/foss/f?p=215:28:509692610826::::: The Resource Assessment and Conservation Engineering (RACE) Division Groundfish Assessment Program (GAP) of the Alaska Fisheries Science Center (AFSC) conducts fisheries-independent bottom trawl surveys to assess the populations of demersal fish and crab stocks of Alaska. The data presented here are presence-only (non-zero) observations from those surveys and therefore CANNOT be aggregated. Please reach out to survey team leads listed in the metadata if clarification is needed. Selecting all surveys for all years and all species will result in a dataset of approximately 1 million rows and might crash the page. If the entire dataset is required, please use the API or let us know using the Comments page and we'll send the data to you directly. Oracle chrome-extension://bdfcnmeidppjeaggnmidamkiddifkdib/viewer.html?file=https://spo.nmfs.noaa.gov/sites/default/files/tm65.pdf Not applicable. unknown No Unknown No No Yes Unknown NCEI-MD unknown IT Security and Contingency Plan for the system establishes procedures and applies to the functions, operations, and resources necessary to recover and restore data as hosted in the Western Regional Support Center in Seattle, Washington, following a disruption. unknown 69746 Entity 69747 Entity 69748 Entity 69749 Entity 69750 Entity gov.noaa.nmfs.inport:22008 Nancy Roberson 2014-07-31T11:27:26 SysAdmin InPortAdmin 2026-03-04T19:17:18 2023-05-01 Alaska Fisheries Science Center AFSC 7600 Sand Point Way N.E., Building 4 Seattle WA 98115 USA https://www.afsc.noaa.gov 0700-1700 Pacific Time 1001 Public No No 2023-05-01 1 Year 2024-05-01 None invertebrates vertebrates http://www.afsc.noaa.gov/RACE/groundfish/species_codebook.pdf Kingdom Animalia Class Scyphozoa jellyfish Order Octopoda octopus Order Actiniaria sea anemones Phylum Porifera sponge Order Teuthida squid Genus Reinhardtius Species hippoglossoides Greenland turbot Genus Hippoglossus Species stenolepis Pacific halibut Genus Limanda Species aspera yellowfin sole Genus Anoplopoma Species fimbria sablefish Genus Clupea Species pallasi Pacific Herring Genus Gadus Species macrocephalus Pacific cod Genus Theragra Species chalcogramma walleye pollock Genus Pleurogrammus Species monopterygius atka mackerel Genus Thaleichthys Species pacificus eulachon Genus Mallotus Species villosus capelin Genus Oncorhynchus Species tshawytscha chinook salmon Genus Oncorhynchus Species gorbuscha pink salmon Genus Oncorhynchus Species nerka sockeye salmon Genus Oncorhynchus Species mykiss steelhead Genus Sebastes Species alutus Pacific ocean perch Genus Chionoecetes Species bairdi tanner crab Genus Chionoecetes Species opilio snow crab Genus Paralithodes Species camtschaticus red king crab Genus Paralithodes Species platypus blue king crab CATCH Summary values for organisms caught in the net, summarized by species and haul. Fields contain total weight and number of each species and whether any organisms were collected for voucher specimens AFSC CRUISEJOIN This is a unique numeric identifier assigned to each VESSEL, CRUISE) combination AFSC 43 1448298 HAULJOIN This is a unique numeric identifier assigned to each (VESSEL, CRUISE, HAUL) combination AFSC 523 1448357 CATCHJOIN This is a unique numeric identifier assigned to each (VESSEL, CRUISE, HAUL, SPECIES_CODE) combination AFSC 62798 1449486 REGION Valid Values: AI=Aleutian Islands, BS=Bering Sea, GOA=Gulf of Alaska, WC=West Coast, HBS=Hydroacoustic Bering Sea, HG=Hydroacoustic Gulf of Alaska, HWC=Hydroacoustic West Coast AFSC unknown VESSEL Domain: RACE ADP Codebook: Vessel Codes AFSC 1 793 CRUISE This is a six-digit number 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. AFSC 195301 200909 HAUL This number uniquely identifies a haul within a cruise. It is a sequential number, in chronological order of occurrence. AFSC 1 942 SPECIES_CODE Domain: RACE Species Codebook AFSC 1 99999 WEIGHT Kilogram (kg). This value is the extrapolated Weight, to nearest thousandth of a kg, for each species in the catch. Collected in pounds in 1993 and prior years and has since been converted to kg AFSC 0 42200.153 NUMBER_FISH Valid Values: whole numbers, 0, and null. This value is the extrapolated total number of individuals of this species caught in the haul. AFSC 0 620382 SUBSAMPLE_CODE Unused attribute AFSC unknown VOUCHER Reference number given to specimens that are collected and preserved for taxonomic identification purposes. These are assigned sequentially beginning with 1 and re-initiated for each haul AFSC 1 1314 AUDITJOIN This is a unique identifier for each record in the base table, to be used in corresponding audit tables to identify the original record in the base table AFSC 1 1268498 CRUISE A lookup table for every cruise that is in the RACEBASE database. It summarizes locations, dates, the country performing the survey and cruise name for each cruise AFSC CRUISEJOIN This is a unique numeric identifier assigned to each (VESSEL,CRUISE) combination AFSC 43 1448298 REGION Valid Values: AI=Aleutian Islands, BS=Bering Sea, GOA=Gulf of Alaska, WC=West Coast,HBS=Hydroacoustic Bering Sea, HG=Hydroacoustic Gulf of Alaska, HWC=Hydroacoustic West Coast, TAG=Denotes that no biological data exist for this cruise other than those related to tags released or recovered. AFSC unknown VESSEL Domain: RACE ADP Codebook: Vessel Codes AFSC 1 793 CRUISE This is a six-digit number 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.) AFSC 195301 200909 START_DATE Date. This is the date of the first haul of the cruise; this field is populated using a query - select min (start_time)from racebase.haul AFSC 19530310 20090802 END_DATE Date. This is the date of the last haul of the cruise; this field is populated value using a query - select max (start_time) from a racebase.haul AFSC 19530407 20090813 MIN_LATITUDE Latitude in decimal degrees. These are the Southern bounding coordinates of cruise AFSC 32.36567 68.39033 MAX_LATITUDE Latitude in decimal degrees. These are the Northern bounding coordinates of cruise AFSC 32.744 72.07583 MIN_LONGITUDE Longitude in decimal degrees. These are the Eastern bounding coordinates of cruise AFSC -179.977 -117.41667 MAX_LONGITUDE Longitude in decimal degrees. These are the Western bounding coordinates of cruise AFSC -179.79633 179.98667 AGENCY_NAME Text. Name of country or countries that conducted the cruise AFSC unknown SURVEY_NAME Text. Description of the survey AFSC unknown AUDITJOIN This is a unique identifier for each record in the base table, to be used in corresponding audit tables to identify the original record in the base table AFSC 1 1089 EVENT Header information for the PROFILE table: date, location, stratum, station, bottom depth, type of bathythermic device, and upcast/downcast flag value representing which limb of the profile is represented in the data stream AFSC CRUISEJOIN This is a unique numeric identifier assigned to each (VESSEL,CRUISE) combination AFSC 0 1403460 HAULJOIN This is a unique numeric identifier assigned to each (VESSEL,CRUISE,HAUL) combination AFSC 523 1403572 VESSEL Domain: RACE ADP Codebook: Vessel Codes AFSC 1 157 CRUISE This is a six-digit number identifying the Cruise number. Its format is: 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.) AFSC 197602 200909 REGION Valid Values: AI=Aleutian Islands, BS=Bering Sea, GOA=Gulf of Alaska, WC=West Coast,HBS=Hydroacoustic Bering Sea, HG=Hydroacoustic Gulf of Alaska, HWC=Hydroacoustic West Coast AFSC unknown EVENT Valid Values: whole numbers. This value serves to uniquely identify each deployment of the device within a cruise. It is a unique sequential number and generally, in order of chronological occurrence AFSC 1 973 HAUL This number uniquely identifies a haul within a cruise. It is a sequential number, in chronological order of occurrence. AFSC 0 1200 DROP_TIME Date and time of deployment of the device AFSC 19760809 20090807 LATITUDE Latitude (decimal degrees) where the device was deployed. AFSC 32.53867 86.6 LONGITUDE Longitude (decimal degrees) where the device was deployed. AFSC -180.16667 180.6 BOTTOM_DEPTH meters (m) AFSC 0 6000 STRATUM RACE statistical area for analyzing data. Strata were designed using bathymetry and other measures of habitat; References RACEBASE.STRATUM AFSC unknown STATION Alpha-numeric designation for the Station established in the design of a Survey AFSC unknown DEVICE Valid Values: CTD=conductivity temperature depth, MBT=microbathythermograph, SBE=Seabird Electronics BT, XBT=expendable bathythermograph AFSC unknown DEVICE_ID Valid Values: Whole numbers and null. This value serves to uniquely identify each piece of bathythermic equipment used in the survey. A null value indicates that the DEVICE_ID is unknown AFSC unknown UP_DOWN Valid Values: U=upcast, D=Downcast, null=unknown AFSC unknown AUDITJOIN This is a unique identifier for each record in the base table, to be used in corresponding audit tables to identify the original record in the base table AFSC 1 17470 HAUL Summary values describing each haul (i.e. location, how long the tow lasted, how deep, how far, net width, net height, bottom type, depth and temperature) AFSC CRUISEJOIN This is a unique numeric identifier assigned to each (VESSEL,CRUISE) combination AFSC 43 1448298 HAULJOIN This is a unique numeric identifier assigned to each (VESSEL,CRUISE,HAUL) combination AFSC 523 1448357 REGION Valid Values: AI=Aleutian Islands, BS=Bering Sea, GOA=Gulf of Alaska, WC=West Coast,HBS=Hydroacoustic Bering Sea, HG=Hydroacoustic Gulf of Alaska, HWC=Hydroacoustic West Coast, TAG=Fish Tagging AFSC unknown VESSEL Domain: RACE ADP Codebook: Vessel Codes AFSC 1 793 CRUISE This is a six-digit number identifying the Cruise number. It is 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.) AFSC 195301 200909 HAUL This number uniquely identifies a haul within a cruise. It is a sequential number, in chronological order of occurrence. AFSC 1 942 HAUL_TYPE Domain: RACE ADP Codebook: Haul Type AFSC 0 21 PERFORMANCE Domain: RACE ADP Codebook: Performance Codes AFSC -9 9 START_TIME Date. This is the date and time at the beginning of the haul AFSC 19530310 20090813 DURATION Decimal hour. This is the elapsed time between start and end of a haul AFSC 0 79 DISTANCE_FISHED kilometers (km) in thousandths of a km AFSC 0 36.188 NET_WIDTH Measured or estimated distance (m) between wingtips of the trawl. AFSC 1.981 42.15 NET_MEASURED This is a Y/N field, to indicate whether the NET_WIDTH was measured or estimated: Yes (Y) means that NET_WIDTH was measured and (N) indicates that NET_WIDTH was calculated AFSC unknown NET_HEIGHT Measured or estimated distance (m) between footrope and headrope of the trawl. AFSC 0 43 STRATUM RACE database statistical area for analyzing data. Strata were designed using bathymetry and other measures of habitat and are unique to each survey series. AFSC 0 915 START_LATITUDE The latitude (decimal degrees) at the start of the haul AFSC 32.36567 72.07583 END_LATITUDE The latitude (decimal degrees) at the end of the haul AFSC 32 72.057 START_LONGITUDE The longitude (decimal degrees) at the start of the haul. AFSC -180 179.99833 END_LONGITUDE The longitude (decimal degrees) at the end of the haul AFSC -179.99747 179.9981 STATIONID Alpha-numeric designation for the Station established in the design of a Survey. AFSC unknown GEAR_DEPTH Meters (m). Weighted average depth (m) of trawl measured at the headrope (Groundfish) or footrope (MACE). Prior to (year?), before NET-HEIGHT was regularly measured, this value was used synonymously with BOTTOM_DEPTH. AFSC 0 1875 BOTTOM_DEPTH Meters (m). Weighted average depth (m) and is calculated by adding GEAR_DEPTH to NET_HEIGHT. Prior to (year), before NET_HEIGHT was regularly measured, this value was obtained using either echosounder or bathythermograph. AFSC 5 7236 BOTTOM_TYPE Domain: RACE ADP Codebook: Bottom Type Code AFSC unknown SURFACE_TEMPERATURE Surface temperature, in tenths of a degree, Celsius. Null values indicate temperature not recorded. AFSC -1.7 19.3 GEAR_TEMPERATURE Weighted average temperature (in tenths of a degree Celsius) measured at the maximum depth of the headrope of the trawl. Null values indicate temperature not recoreded. AFSC -2.2 17.8 WIRE_LENGTH meters (m); Length of trawl wire (warp) deployed. AFSC 9 2350 GEAR Type of trawl or gear deployed. Domain: RACE ADP Codebook:Gear Code AFSC unknown ACCESSORIES Accessories modifying GEAR. Domain: RACE ADP Codebook: Gear Accessories AFSC unknown SUBSAMPLE Denotes whether and how catch was subsampled. Domain: RACE ADP Codebook: Catch Subsample code AFSC unknown AUDITJOIN This is a unique identifier for each record in the base table, to be used in corresponding audit tables to identify the original record in the base table AFSC 1 74128 LENGTH Summarizes length frequency by species and sex for each haul AFSC CRUISEJOIN This is a unique numeric identifier assigned to each (VESSEL,CRUISE) combination AFSC 44 1448298 HAULJOIN This is a unique numeric identifier assigned to each (VESSEL,CRUISE,HAUL) combination AFSC 523 1448357 CATCHJOIN Sequence generated unique identifier for (VESSEL,CRUISE,HAUL, SPECIES_CODE) combination AFSC 62799 1449486 REGION Valid Values: AI=Aleutian Islands, BS=Bering Sea, GOA=Gulf of Alaska, WC=West Coast,HBS=Hydroacoustic Bering Sea, HG=Hydroacoustic Gulf of Alaska, HWC=Hydroacoustic West Coast AFSC unknown VESSEL Domain: RACE ADP Codebook: Vessel Codes AFSC 1 793 CRUISE This is a six-digit number 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.) AFSC 196101 200909 HAUL This number uniquely identifies a haul within a cruise. It is a sequential number, in chronological order of occurrence. AFSC 1 804 SPECIES_CODE Domain: RACE Species Codebook AFSC 2 79404 LENGTH Millimeter (mm) AFSC 8 3430 FREQUENCY Must be at least 001 AFSC 0 34066 SEX Valid Values: 1=male, 2=female, 3=undetermined AFSC 1 3 SAMPLE_TYPE Domain: RACE ADP Codebook:Length-Frequency Form: Sample Type; For Cruises: (WC 2198304, WC 23198401, WC 63198501S)"SUBSAMPLE TYPE" CODE USED TO INDICATE WHAT KIND OF TRAP was used sampletype 4 is defined as randomly selected from rectangular pots and sampletype 5 is defined as randomly selected from conical pots. For additional information see RACEBASE.NOTES AFSC 0 5 LENGTH_TYPE Domain: RACE ADP Codebook:Length-Frequency Form: Length Type AFSC 0 15 AUDITJOIN This is a unique identifier for each record in the base table, to be used in corresponding audit tables to identify the original record in the base table AFSC 1 5284050 PROFILE Water column data. It references RACEBASE.EVENT for each individual events AFSC VESSEL Domain: RACE ADP Codebook: Vessel Codes AFSC 1 157 CRUISE This is a six-digit number 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. AFSC 197602 200909 EVENT a unique sequential number, in order of chronological occurrence, identifying the deployment of the device AFSC 1 973 DEPTH meters (m) AFSC -2 40865 TEMPERATURE Celsius AFSC -17.05 85.83 SALINITY Practical Salinity Units (psu) AFSC -930 72.09 AUDITJOIN This is a unique identifier for each record in the base table, to be used in corresponding audit tables to identify the original record in the base table AFSC 1 1764799 SPECIES Lookup for animals encountered in Groundfish surveys. It includes species names, common names, their associated species_codes, and if they are found in the Bering Sea, Gulf of Alaska, and/or West Coast AFSC SPECIES_CODE Domain: RACE Species Codebook AFSC 1 99999 SPECIES_NAME The scientific name of the organism associated with the COMMON_NAME. AFSC unknown COMMON_NAME The common name of the marine organism associated with the SCIENTIFIC_NAME AFSC unknown REVISION 3-digit code identifying the year that the species was added to the species code. a=added YY=year the species was added AFSC unknown BS This is a Y/null field, to indicate whether the species is present (Y) or absent(null) from catches in this region AFSC unknown GOA This is a Y/null field, to indicate whether the species is present (Y) or absent(null) from catches in this region AFSC unknown WC This is a Y/null field, to indicate whether the species is present (Y) or absent(null) from catches in this region AFSC unknown AUDITJOIN This is a unique identifier for each record in the base table, to be used in corresponding audit tables to identify the original record in the base table AFSC 1 3441 STATIONS Lookup of station_id and their coordinates AFSC STATIONID Alpha-numeric designation for the Station established in the design of a Survey. In the Eastern Bering Sea, these stations have remained constant from the beginning of this time series. In other regions, sampling locations vary and are identified by station grid cell in which the haul took place. AFSC unknown LATITUDE Latitude in decimal degrees AFSC 54.66667 63.66667 LONGITUDE Longitude in decimal degrees AFSC -179.05 -157.93333 STRATUM RACE statistical area for analyzing data. Strata were designed using bathymetry and other measures of habitat; References RACEBASE.STRATUM AFSC 10 90 EBS 2010 Strata adjustments: The addition of the northern Bering Sea stations in 2010, necessitated the stratum boundaries to be reconfigured for three of the northern strata (70,81, and 82) and add a new stratum for Norton Sound and north of St. Lawrence Island, "Stratum 71" 1) Added to RACEBASE.STRATUM - a new set of stratum areas (YEAR=2010, AREA='BS'; see attached new_rb_stratum.txt for a list of the additions) 2) Added to RACEBASE.STATIONS - station information for the 144 new northern stations - stationid, lat, long, and stratum 3) Updated RACEBASE.HAUL to include stratum codes for all northern stations