Table: HAUL
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:69748 | Updated: October 26, 2023 | Published / External
Item Identification
Title: | Table: HAUL |
---|---|
Short Name: | HAUL |
Status: | Completed |
Abstract: |
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. |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | RACEBASE |
Description: |
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 Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
CRUISEJOIN | NUMBER | This is a unique numeric identifier assigned to each (VESSEL,CRUISE) combination | |
100
|
![]() |
HAULJOIN | NUMBER | This is a unique numeric identifier assigned to each (VESSEL, CRUISE, HAUL) combination |
100
|
REGION | VARCHAR2 | 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. | |
100
|
VESSEL | NUMBER | Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual | |
100
|
CRUISE | NUMBER | 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. | |
100
|
HAUL | NUMBER | This number uniquely identifies a haul within a cruise. It is a sequential number, in chronological order of occurrence. | |
100
|
HAUL_TYPE | NUMBER | Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual | |
100
|
PERFORMANCE | NUMBER | Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual | |
100
|
START_TIME | DATE | 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. | |
100
|
DURATION | NUMBER | 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 | |
100
|
DISTANCE_FISHED | NUMBER | kilometers (km) in thousandths of a km | |
100
|
NET_WIDTH | NUMBER | Measured or estimated distance (m) between wingtips of the trawl. | |
100
|
NET_MEASURED | VARCHAR2 | 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 | |
100
|
NET_HEIGHT | NUMBER | Measured or estimated distance (m) between footrope and headrope of the trawl. | |
100
|
STRATUM | NUMBER | RACE database statistical area for analyzing data. Strata were designed using bathymetry and other measures of habitat and are unique to each survey series. | |
100
|
START_LATITUDE | NUMBER | The latitude (decimal degrees) at the start of the haul | |
100
|
END_LATITUDE | NUMBER | The latitude (decimal degrees) at the end of the haul | |
100
|
START_LONGITUDE | NUMBER | The longitude (decimal degrees) at the start of the haul. | |
100
|
END_LONGITUDE | NUMBER | The longitude (decimal degrees) at the end of the haul | |
100
|
STATIONID | VARCHAR2 | Alpha-numeric designation for the Station established in the design of a Survey. | |
100
|
GEAR_DEPTH | NUMBER | 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. | |
100
|
BOTTOM_DEPTH | NUMBER | 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. | |
100
|
BOTTOM_TYPE | VARCHAR2 | Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual | |
100
|
SURFACE_TEMPERATURE | NUMBER | Surface temperature, in tenths of a degree, Celsius. Null values indicate temperature not recorded. | |
100
|
GEAR_TEMPERATURE | NUMBER | 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. | |
100
|
WIRE_LENGTH | NUMBER | meters (m); Length of trawl wire (warp) deployed. | |
100
|
GEAR | VARCHAR2 | Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual | |
100
|
ACCESSORIES | VARCHAR2 | Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual | |
100
|
SUBSAMPLE | VARCHAR2 | Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual | |
100
|
AUDITJOIN | NUMBER | 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 | |
100
|
ABUNDANCE_HAUL | VARCHAR2 | 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. |
Attribute Details
CRUISEJOIN
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 12 |
Scale: | 0 |
Status: | Active |
Description: |
This is a unique numeric identifier assigned to each (VESSEL,CRUISE) combination |
General Data Type: | NUMBER |
HAULJOIN
Seq. Order: | 2 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 12 |
Scale: | 0 |
Status: | Active |
Description: |
This is a unique numeric identifier assigned to each (VESSEL, CRUISE, HAUL) combination |
General Data Type: | NUMBER |
REGION
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
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. |
General Data Type: | VARCHAR2 |
VESSEL
Seq. Order: | 4 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual |
General Data Type: | NUMBER |
CRUISE
Seq. Order: | 5 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
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. |
General Data Type: | NUMBER |
HAUL
Seq. Order: | 6 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
This number uniquely identifies a haul within a cruise. It is a sequential number, in chronological order of occurrence. |
General Data Type: | NUMBER |
HAUL_TYPE
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual |
General Data Type: | NUMBER |
PERFORMANCE
Seq. Order: | 8 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 3 |
Scale: | 2 |
Status: | Active |
Description: |
Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual |
General Data Type: | NUMBER |
START_TIME
Seq. Order: | 9 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
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. |
General Data Type: | DATE |
DURATION
Seq. Order: | 10 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 4 |
Status: | Active |
Description: |
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 |
General Data Type: | NUMBER |
DISTANCE_FISHED
Seq. Order: | 11 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 3 |
Status: | Active |
Description: |
kilometers (km) in thousandths of a km |
General Data Type: | NUMBER |
NET_WIDTH
Seq. Order: | 12 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 3 |
Status: | Active |
Description: |
Measured or estimated distance (m) between wingtips of the trawl. |
General Data Type: | NUMBER |
NET_MEASURED
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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 |
General Data Type: | VARCHAR2 |
NET_HEIGHT
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 3 |
Status: | Active |
Description: |
Measured or estimated distance (m) between footrope and headrope of the trawl. |
General Data Type: | NUMBER |
STRATUM
Seq. Order: | 15 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
RACE database statistical area for analyzing data. Strata were designed using bathymetry and other measures of habitat and are unique to each survey series. |
General Data Type: | NUMBER |
START_LATITUDE
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 7 |
Scale: | 5 |
Status: | Active |
Description: |
The latitude (decimal degrees) at the start of the haul |
General Data Type: | NUMBER |
END_LATITUDE
Seq. Order: | 17 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 7 |
Scale: | 5 |
Status: | Active |
Description: |
The latitude (decimal degrees) at the end of the haul |
General Data Type: | NUMBER |
START_LONGITUDE
Seq. Order: | 18 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 8 |
Scale: | 5 |
Status: | Active |
Description: |
The longitude (decimal degrees) at the start of the haul. |
General Data Type: | NUMBER |
END_LONGITUDE
Seq. Order: | 19 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 5 |
Status: | Active |
Description: |
The longitude (decimal degrees) at the end of the haul |
General Data Type: | NUMBER |
STATIONID
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Alpha-numeric designation for the Station established in the design of a Survey. |
General Data Type: | VARCHAR2 |
GEAR_DEPTH
Seq. Order: | 21 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
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. |
General Data Type: | NUMBER |
BOTTOM_DEPTH
Seq. Order: | 22 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
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. |
General Data Type: | NUMBER |
BOTTOM_TYPE
Seq. Order: | 23 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual |
General Data Type: | VARCHAR2 |
SURFACE_TEMPERATURE
Seq. Order: | 24 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 1 |
Status: | Active |
Description: |
Surface temperature, in tenths of a degree, Celsius. Null values indicate temperature not recorded. |
General Data Type: | NUMBER |
GEAR_TEMPERATURE
Seq. Order: | 25 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 1 |
Status: | Active |
Description: |
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. |
General Data Type: | NUMBER |
WIRE_LENGTH
Seq. Order: | 26 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
meters (m); Length of trawl wire (warp) deployed. |
General Data Type: | NUMBER |
GEAR
Seq. Order: | 27 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual |
General Data Type: | VARCHAR2 |
ACCESSORIES
Seq. Order: | 28 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual |
General Data Type: | VARCHAR2 |
SUBSAMPLE
Seq. Order: | 29 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual |
General Data Type: | VARCHAR2 |
AUDITJOIN
Seq. Order: | 30 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 12 |
Scale: | 0 |
Status: | Active |
Description: |
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 |
General Data Type: | NUMBER |
ABUNDANCE_HAUL
Seq. Order: | 31 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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. |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 69748 |
---|---|
GUID: | gov.noaa.nmfs.inport:69748 |
Metadata Record Created By: | Nancy Roberson |
Metadata Record Created: | 2023-05-01 17:43+0000 |
Metadata Record Last Modified By: | Nancy Roberson |
Metadata Record Last Modified: | 2023-10-26 19:05+0000 |
Metadata Record Published: | 2023-10-26 |
Owner Org: | AFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2023-10-26 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2024-10-26 |