Item Identification

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

Table than is populated during data import if there is data catch data that cannot be imported into the haul table.

Notes:

Loaded by FGDC Metadata Uploader, batch 7092, 09-18-2015 13:08

Entity Information

Description:

Table than is populated during data import if there is data catch data that cannot be imported into the haul table.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Haul_Position_ID Unknown autogenerated
100
Cruise_Station_ID Unknown autogenerated
100
Vessel Unknown vessel code
100
cruise Unknown cruise number, year + 01. e.g., 200101
100
haul Unknown haul number (start over every year)
100
INPFC_area Unknown Bering Sea, Aleutian Islands, Western Gulf of Alaska, Central Gulf of Alaska, Esatern Gulf of Alaska
100
station Unknown standard station number. >500 = experimental stations
100
haul_date Unknown Date haul was set and hauled
100
start_latitude Unknown start latitude of haul (decimal degrees)
100
start_hemi_ns Unknown start hemisphere of the haul (north/south)
100
start_longitude Unknown start longitude of the haul (decimal degrees)
100
start_hemi_ew Unknown start hemisphere of the haul (east/west)
100
end_latitude Unknown end latitude of haul (decimal degrees)
100
end_hemi_ns Unknown end hemisphere of the haul (north/south)
100
end_longitude Unknown end longitude of the haul (decimal degrees)
100
end_hemi_ew Unknown end hemisphere of the haul (east/west)
100
set_start_time Unknown time when haul back starts
100
set_end_time Unknown time when gear set starts
100
haul_start_time Unknown time when haul back starts
100
haul_end_time Unknown time when haul back ends
100
soak_time Unknown time gear was soaking in minutes (set end time - haul start time)
100
distance_fished Unknown length of set in km (approximate)
100
starting_depth Unknown depth of first skate at haul back
100
ending_depth Unknown depth of last skate at haul back
100
surface_temperature Unknown temperatre at the surface at start of haul back
100
gear_temperature Unknown temperature at depth taken from a temperature-depth recorder
100
tdr_depth Unknown depth at which the gear_temperature is taken with a temperature-depth recorder
100
gear_type Unknown type of gear used, determined by specifics of hooks, bait, or any other differences
100
bait_type Unknown type of bait used, consistent in United states survey
100
year Unknown none
100
create_date Unknown used to flag a haul (usually at the station level actually, so both hauls will be flagged) for a marine mammal sighting. Used for sperm whales. See rpn_filter for killer whale depredation. When killer whales are present, they are depredating, so they are not documented in mammal_sightings.
100
mammal_sighting Unknown used to flag a haul (usually at the station level actually, so both hauls will be flagged) for a marine mammal sighting. Used for sperm whales. See rpn_filter for killer whale depredation. When killer whales are present, they are depredating, so they are not documented in mammal_sightings.
100
Depredation_flag Unknown Flag used to document if there was evidence of sperm whale depredation on the haul. Evidence is presence of head and lips or damamged fishing gear (broken hooks)
100
error_description Unknown none

Attribute Details

Haul_Position_ID

CC ID: 222553
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

autogenerated

Allowed Values: No domain defined.

Cruise_Station_ID

CC ID: 222554
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

autogenerated

Allowed Values: No domain defined.

Vessel

CC ID: 222555
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

vessel code

Allowed Values: No domain defined.

cruise

CC ID: 222556
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

cruise number, year + 01. e.g., 200101

Allowed Values: No domain defined.

haul

CC ID: 222557
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

haul number (start over every year)

Allowed Values: No domain defined.

INPFC_area

CC ID: 222558
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Bering Sea, Aleutian Islands, Western Gulf of Alaska, Central Gulf of Alaska, Esatern Gulf of Alaska

Allowed Values: No domain defined.

station

CC ID: 222559
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

standard station number. >500 = experimental stations

Allowed Values: No domain defined.

haul_date

CC ID: 222560
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Date haul was set and hauled

Allowed Values: No domain defined.

start_latitude

CC ID: 222561
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

start latitude of haul (decimal degrees)

Allowed Values: No domain defined.

start_hemi_ns

CC ID: 222562
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

start hemisphere of the haul (north/south)

Allowed Values: No domain defined.

start_longitude

CC ID: 222563
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

start longitude of the haul (decimal degrees)

Allowed Values: No domain defined.

start_hemi_ew

CC ID: 222564
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

start hemisphere of the haul (east/west)

Allowed Values: No domain defined.

end_latitude

CC ID: 222565
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

end latitude of haul (decimal degrees)

Allowed Values: No domain defined.

end_hemi_ns

CC ID: 222566
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

end hemisphere of the haul (north/south)

Allowed Values: No domain defined.

end_longitude

CC ID: 222567
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

end longitude of the haul (decimal degrees)

Allowed Values: No domain defined.

end_hemi_ew

CC ID: 222568
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

end hemisphere of the haul (east/west)

Allowed Values: No domain defined.

set_start_time

CC ID: 222569
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

time when haul back starts

Allowed Values: No domain defined.

set_end_time

CC ID: 222570
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

time when gear set starts

Allowed Values: No domain defined.

haul_start_time

CC ID: 222571
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

time when haul back starts

Allowed Values: No domain defined.

haul_end_time

CC ID: 222572
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

time when haul back ends

Allowed Values: No domain defined.

soak_time

CC ID: 222573
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

time gear was soaking in minutes (set end time - haul start time)

Allowed Values: No domain defined.

distance_fished

CC ID: 222574
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

length of set in km (approximate)

Allowed Values: No domain defined.

starting_depth

CC ID: 222575
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

depth of first skate at haul back

Allowed Values: No domain defined.

ending_depth

CC ID: 222576
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

depth of last skate at haul back

Allowed Values: No domain defined.

surface_temperature

CC ID: 222577
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

temperatre at the surface at start of haul back

Allowed Values: No domain defined.

gear_temperature

CC ID: 222578
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

temperature at depth taken from a temperature-depth recorder

Allowed Values: No domain defined.

tdr_depth

CC ID: 222579
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

depth at which the gear_temperature is taken with a temperature-depth recorder

Allowed Values: No domain defined.

gear_type

CC ID: 222580
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

type of gear used, determined by specifics of hooks, bait, or any other differences

Allowed Values: No domain defined.

bait_type

CC ID: 222581
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

type of bait used, consistent in United states survey

Allowed Values: No domain defined.

year

CC ID: 222582
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

none

Allowed Values: No domain defined.

create_date

CC ID: 222583
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

used to flag a haul (usually at the station level actually, so both hauls will be flagged) for a marine mammal sighting. Used for sperm whales. See rpn_filter for killer whale depredation. When killer whales are present, they are depredating, so they are not documented in mammal_sightings.

Allowed Values: No domain defined.

mammal_sighting

CC ID: 222584
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

used to flag a haul (usually at the station level actually, so both hauls will be flagged) for a marine mammal sighting. Used for sperm whales. See rpn_filter for killer whale depredation. When killer whales are present, they are depredating, so they are not documented in mammal_sightings.

Allowed Values: No domain defined.

Depredation_flag

CC ID: 222585
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Flag used to document if there was evidence of sperm whale depredation on the haul. Evidence is presence of head and lips or damamged fishing gear (broken hooks)

Allowed Values: No domain defined.

error_description

CC ID: 222586
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

none

Allowed Values: No domain defined.

Catalog Details

Catalog Item ID: 27275
Metadata Record Created By: Emily A Fergusson
Metadata Record Created: 2015-09-18 13:08+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2016-05-18
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2017-05-19