Search Help Show/Hide Menu
Metadata Rubric
83%
5 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Resource Ecology and Fisheries Management Divis... > Trophic Interactions > AFSC/REFM: North Pacific Groundfish Diet Data 1... >

HAUL

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:22162  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

REEM North Pacific Groundfish Diet Data Haul Table

Description

REEM North Pacific Groundfish Diet Data Haul Table

Entity Information

Data Attribute / Type Description
VESSEL
NUMBER 		A 4-digit numeric field that does not accept null values, acceptable values are any vessel code.
CRUISE
NUMBER 		A 6-digit numeric field that does not accept null values, acceptable values are any cruise code.
HAUL
NUMBER 		A 3-digit numeric field that does not allow null values representing the haul number from which the associated stomach data were collected.
YEAR
NUMBER 		A 4-digit numeric field that does not accept null values, acceptable values are any four,digit year.
MONTH
NUMBER 		A 2-digit numeric field that does not allow null values representing the month from which the haul was collected.
DAY
NUMBER 		A 2-digit numeric field that does not allow null values representing the day of the month from which the haul was collected.
RLAT
NUMBER 		An 8.2 numeric field that does not allow null values representing the latitude (decimal degrees) from which the haul was collected. This represents the haul back location
RLONG
NUMBER 		A 9.2 numeric field that does not allow null values representing the longitude (decimal degrees) from which the haul was collected. This represents the haul back location. Eastern longitudes are represented by negative values, western by postitive
GEAR_DEPTH
NUMBER 		A 4-digit numeric field that allows null values representing the average gear depth (m).
BOTTOM_DEPTH
NUMBER 		A 4-digit numeric field that allows null values representing the average bottom depth (m).
START_HOUR
NUMBER 		A 4-digit numeric field that allows null values representing the 24 hour(hhmm) start time of a given haul.
DURATION
NUMBER 		A 5.3-digit numeric field that allows null values representing the length of time (hours) the trawl was in the water.
DISTANCE
NUMBER 		A 6.2-digit numeric field that allowed null values representing the distance (nm) fished.
HAUL_TYPE
NUMBER 		A 3-digit numeric field that does not allow null values representing the type of haul conducted. Acceptable values are 0, 3, 4, 5, 6, 7 for bottom trawls (see RACE ADP guide for description of codes), 1, 2, 8, 10 for off-bottom trawls (see RACE ADP guide for description of codes), 32 for longline and 37 for pots, 9 for observer samples collected at plants or from vessels delivering to plants
STRATUM
NUMBER 		A 5-digit numeric field that allows null values representing the RACE stratum number within which the haul was conducted.
SURFACE_TEMP
NUMBER 		A 4.2-digit numeric field that allows null values representing the surface water temperature (deg C).
GEAR_TEMP
NUMBER 		A 4.2-digit numeric field that allows null values representing the gear water temperature (deg C).
BOTTOM_TYPE
NUMBER 		A 3-digit numeric field that allows null values representing the bottom type, codes can be found in a current RACE ADP manual.
WIRE_OUT
NUMBER 		A 4-digit numeric field that allows null values representing the amount of wire (m) out during the trawl.
GEAR
NUMBER 		A 4-digit numeric field that allows null values representing the gear used, codes can be found in a current RACE ADP manual.
ACCESSORIES
NUMBER 		A 4-digit numeric field that allows null values representing the gear accessories used, codes can be found in a current RACE ADP manual.
SUBSAMPLE
NUMBER 		A 2-digit numeric field that allows null values representing the subsample type used if any, codes can be found in a current RACE ADP manual.
PERFORMANCE
NUMBER 		A 2-digit numeric field that allows null values representing the gear performance, codes can be found in a current RACE ADP manual.
INPFC_AREA
NUMBER 		A 3-digit numeric field that allows null values representing the INPFC area from which the sample was collected.
STATIONID
VARCHAR2 		A 9-digit alphanumeric field that allows null values representing the RACE station ID number for the eastern Bering Sea shelf only.
HAULJOIN
NUMBER 		A 12 digit numeric field that does not allow null values. Each haul has a unique hauljoin, this is the primary key for the haul table and is used to relate haul information to the other tables.
START_DATE
DATE 		A date string that allows null values representing the start date (mm/dd/yyyy) of the haul.
REGION
VARCHAR2 		A 6-place VarChar2 field that does not allow null values for region. Current values are BS (Bering Sea), GOA (Gulf Of Alaska), AI (Aleutian Islands), BF (Beaufort Sea).
CRUISE_TYPE
VARCHAR2 		A 20-place VarChar2 that does not allow null values for cruise type representing the type of cruise from which the samples were collected. Current values are ADFG, Observer, Other, REFM, Race_Groundfish, Race_Hydro, Race_Other.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

Item Identification

Title: HAUL
Short Name: HAUL
Status: In Work
Abstract:

REEM North Pacific Groundfish Diet Data Haul Table
Notes:

Loaded by FGDC Metadata Uploader, batch 5084, 09-02-2014 16:45

Entity Information

Description:

REEM North Pacific Groundfish Diet Data Haul Table

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 VESSEL NUMBER A 4-digit numeric field that does not accept null values, acceptable values are any vessel code.
100
 CRUISE NUMBER A 6-digit numeric field that does not accept null values, acceptable values are any cruise code.
100
 HAUL NUMBER A 3-digit numeric field that does not allow null values representing the haul number from which the associated stomach data were collected.
100
 YEAR NUMBER A 4-digit numeric field that does not accept null values, acceptable values are any four,digit year.
100
 MONTH NUMBER A 2-digit numeric field that does not allow null values representing the month from which the haul was collected.
100
 DAY NUMBER A 2-digit numeric field that does not allow null values representing the day of the month from which the haul was collected.
100
 RLAT NUMBER An 8.2 numeric field that does not allow null values representing the latitude (decimal degrees) from which the haul was collected. This represents the haul back location
100
 RLONG NUMBER A 9.2 numeric field that does not allow null values representing the longitude (decimal degrees) from which the haul was collected. This represents the haul back location. Eastern longitudes are represented by negative values, western by postitive
100
 GEAR_DEPTH NUMBER A 4-digit numeric field that allows null values representing the average gear depth (m).
100
 BOTTOM_DEPTH NUMBER A 4-digit numeric field that allows null values representing the average bottom depth (m).
100
 START_HOUR NUMBER A 4-digit numeric field that allows null values representing the 24 hour(hhmm) start time of a given haul.
100
 DURATION NUMBER A 5.3-digit numeric field that allows null values representing the length of time (hours) the trawl was in the water.
100
 DISTANCE NUMBER A 6.2-digit numeric field that allowed null values representing the distance (nm) fished.
100
 HAUL_TYPE NUMBER A 3-digit numeric field that does not allow null values representing the type of haul conducted. Acceptable values are 0, 3, 4, 5, 6, 7 for bottom trawls (see RACE ADP guide for description of codes), 1, 2, 8, 10 for off-bottom trawls (see RACE ADP guide for description of codes), 32 for longline and 37 for pots, 9 for observer samples collected at plants or from vessels delivering to plants
100
 STRATUM NUMBER A 5-digit numeric field that allows null values representing the RACE stratum number within which the haul was conducted.
100
 SURFACE_TEMP NUMBER A 4.2-digit numeric field that allows null values representing the surface water temperature (deg C).
100
 GEAR_TEMP NUMBER A 4.2-digit numeric field that allows null values representing the gear water temperature (deg C).
100
 BOTTOM_TYPE NUMBER A 3-digit numeric field that allows null values representing the bottom type, codes can be found in a current RACE ADP manual.
100
 WIRE_OUT NUMBER A 4-digit numeric field that allows null values representing the amount of wire (m) out during the trawl.
100
 GEAR NUMBER A 4-digit numeric field that allows null values representing the gear used, codes can be found in a current RACE ADP manual.
100
 ACCESSORIES NUMBER A 4-digit numeric field that allows null values representing the gear accessories used, codes can be found in a current RACE ADP manual.
100
 SUBSAMPLE NUMBER A 2-digit numeric field that allows null values representing the subsample type used if any, codes can be found in a current RACE ADP manual.
100
 PERFORMANCE NUMBER A 2-digit numeric field that allows null values representing the gear performance, codes can be found in a current RACE ADP manual.
100
 INPFC_AREA NUMBER A 3-digit numeric field that allows null values representing the INPFC area from which the sample was collected.
100
 STATIONID VARCHAR2 A 9-digit alphanumeric field that allows null values representing the RACE station ID number for the eastern Bering Sea shelf only.
100
 HAULJOIN NUMBER A 12 digit numeric field that does not allow null values. Each haul has a unique hauljoin, this is the primary key for the haul table and is used to relate haul information to the other tables.
100
 START_DATE DATE A date string that allows null values representing the start date (mm/dd/yyyy) of the haul.
100
 REGION VARCHAR2 A 6-place VarChar2 field that does not allow null values for region. Current values are BS (Bering Sea), GOA (Gulf Of Alaska), AI (Aleutian Islands), BF (Beaufort Sea).
100
 CRUISE_TYPE VARCHAR2 A 20-place VarChar2 that does not allow null values for cruise type representing the type of cruise from which the samples were collected. Current values are ADFG, Observer, Other, REFM, Race_Groundfish, Race_Hydro, Race_Other.

Attribute Details

VESSEL

CC ID: 208084
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A 4-digit numeric field that does not accept null values, acceptable values are any vessel code.
Allowed Values: 1 - 7777

CRUISE

CC ID: 208085
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A 6-digit numeric field that does not accept null values, acceptable values are any cruise code.
Allowed Values: 11982 - 992009

HAUL

CC ID: 208086
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A 3-digit numeric field that does not allow null values representing the haul number from which the associated stomach data were collected.
Allowed Values: 1 - 4081

YEAR

CC ID: 208087
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A 4-digit numeric field that does not accept null values, acceptable values are any four,digit year.
Allowed Values: 1981 - 2015

MONTH

CC ID: 208088
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A 2-digit numeric field that does not allow null values representing the month from which the haul was collected.
Allowed Values: 1 - 12

DAY

CC ID: 208089
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A 2-digit numeric field that does not allow null values representing the day of the month from which the haul was collected.
Allowed Values: 1 - 31

RLAT

CC ID: 208090
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

An 8.2 numeric field that does not allow null values representing the latitude (decimal degrees) from which the haul was collected. This represents the haul back location
Allowed Values: 51.03 - 73.04

RLONG

CC ID: 208091
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A 9.2 numeric field that does not allow null values representing the longitude (decimal degrees) from which the haul was collected. This represents the haul back location. Eastern longitudes are represented by negative values, western by postitive
Allowed Values: -180 - 179.99

GEAR_DEPTH

CC ID: 208092
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A 4-digit numeric field that allows null values representing the average gear depth (m).
Allowed Values: -9 - 1521

BOTTOM_DEPTH

CC ID: 208093
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A 4-digit numeric field that allows null values representing the average bottom depth (m).
Allowed Values: -9 - 3811

START_HOUR

CC ID: 208094
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A 4-digit numeric field that allows null values representing the 24 hour(hhmm) start time of a given haul.
Allowed Values: -9 - 938

DURATION

CC ID: 208095
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A 5.3-digit numeric field that allows null values representing the length of time (hours) the trawl was in the water.
Allowed Values: -9 - 241

DISTANCE

CC ID: 208096
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A 6.2-digit numeric field that allowed null values representing the distance (nm) fished.
Allowed Values: -99 - 30.54

HAUL_TYPE

CC ID: 208097
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A 3-digit numeric field that does not allow null values representing the type of haul conducted. Acceptable values are 0, 3, 4, 5, 6, 7 for bottom trawls (see RACE ADP guide for description of codes), 1, 2, 8, 10 for off-bottom trawls (see RACE ADP guide for description of codes), 32 for longline and 37 for pots, 9 for observer samples collected at plants or from vessels delivering to plants
Allowed Values: 0 - 37

STRATUM

CC ID: 208098
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A 5-digit numeric field that allows null values representing the RACE stratum number within which the haul was conducted.
Allowed Values: 0 - 6400

SURFACE_TEMP

CC ID: 208099
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A 4.2-digit numeric field that allows null values representing the surface water temperature (deg C).
Allowed Values: -9 - 40

GEAR_TEMP

CC ID: 208100
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A 4.2-digit numeric field that allows null values representing the gear water temperature (deg C).
Allowed Values: -9 - 13.2

BOTTOM_TYPE

CC ID: 208101
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A 3-digit numeric field that allows null values representing the bottom type, codes can be found in a current RACE ADP manual.
Allowed Values: -99 - 99

WIRE_OUT

CC ID: 208102
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A 4-digit numeric field that allows null values representing the amount of wire (m) out during the trawl.
Allowed Values: -99 - 2189

GEAR

CC ID: 208103
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A 4-digit numeric field that allows null values representing the gear used, codes can be found in a current RACE ADP manual.
Allowed Values: -99 - 915

ACCESSORIES

CC ID: 208104
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A 4-digit numeric field that allows null values representing the gear accessories used, codes can be found in a current RACE ADP manual.
Allowed Values: -99 - 798

SUBSAMPLE

CC ID: 208105
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A 2-digit numeric field that allows null values representing the subsample type used if any, codes can be found in a current RACE ADP manual.
Allowed Values: -9 - 12

PERFORMANCE

CC ID: 208106
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A 2-digit numeric field that allows null values representing the gear performance, codes can be found in a current RACE ADP manual.
Allowed Values: -9 - 7

INPFC_AREA

CC ID: 208107
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A 3-digit numeric field that allows null values representing the INPFC area from which the sample was collected.
Allowed Values: 0 - 659

STATIONID

CC ID: 208108
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

A 9-digit alphanumeric field that allows null values representing the RACE station ID number for the eastern Bering Sea shelf only.

HAULJOIN

CC ID: 208109
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

A 12 digit numeric field that does not allow null values. Each haul has a unique hauljoin, this is the primary key for the haul table and is used to relate haul information to the other tables.
Allowed Values: 347810 - 11135974

START_DATE

CC ID: 208110
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

A date string that allows null values representing the start date (mm/dd/yyyy) of the haul.
Allowed Values: 198104140000 - 201508110000

REGION

CC ID: 208111
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

A 6-place VarChar2 field that does not allow null values for region. Current values are BS (Bering Sea), GOA (Gulf Of Alaska), AI (Aleutian Islands), BF (Beaufort Sea).

CRUISE_TYPE

CC ID: 208112
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

A 20-place VarChar2 that does not allow null values for cruise type representing the type of cruise from which the samples were collected. Current values are ADFG, Observer, Other, REFM, Race_Groundfish, Race_Hydro, Race_Other.

Catalog Details

Catalog Item ID: 22162
GUID: gov.noaa.nmfs.inport:22162
Metadata Record Created By: Angie Greig
Metadata Record Created: 2014-09-02 16:45+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-04-19
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-04-19
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-04-19