69748 HAUL Entity Published / External 22008 AFSC/RACE/GAP: RACEBASE Database Data Set 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 gov.noaa.nmfs.inport:69748 Nancy Roberson 2023-05-01T17:43:47 Nancy Roberson 2023-10-26T19:05:28 2023-10-26 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 2023-10-26 1 Year 2024-10-26