5347
Table: POP_HAUL_LOG
POP_HAUL_LOG
Entity
Published / External
30713
PELAGIC OBSERVER PROGRAM (POP). Catch/Effort data collected by observers on board U.S. commercial Pelagic Longline vessels
Data Set
Completed
Haul Log Information
Loaded by batch 1683, 10-12-2007 05:01
Southeast Fisheries Science Center
Miami
FL
USA
Data Table
Yes
POPOL
Haul Log Information
1
GEAR_LOG_KEY
NUMBER
22
Yes
No
10
0
Active
Gear Log Key
NUMBER
2
HAUL_LOG_KEY
NUMBER
22
Yes
Yes
10
0
Active
Primary Key
NUMBER
3
HAUL_NUMBER
NUMBER
22
Yes
No
2
0
Active
Haul Number
NUMBER
4
GEAR_CODE
VARCHAR2
3
Yes
No
Active
NMFS Gear Code
VARCHAR2
5
WAS_HAUL_OBSERVED
VARCHAR2
1
Yes
No
Active
Was haul observed?
VARCHAR2
6
WAS_CATCH
VARCHAR2
1
Yes
No
Active
Were fish caught in the haul?
VARCHAR2
7
WAS_INCIDENTAL_TAKE
VARCHAR2
1
Yes
No
Active
Was incidental take?
VARCHAR2
8
WEATHER_DESCRIPTION
VARCHAR2
2
No
No
Active
Code For Weather Condition at time of the beginning of the haul.
VARCHAR2
9
WIND_SPEED
NUMBER
22
No
No
2
0
Active
In knots at the beginning of the haul.
NUMBER
10
WIND_DIRECTION
VARCHAR2
3
No
No
Active
In compass degrees at the beginning of the haul.
VARCHAR2
11
WAVE_HEIGHT
NUMBER
22
No
No
2
0
Active
Max. Wave Height at the beginning of the haul in feet
NUMBER
12
REVERSE_HAUL
VARCHAR2
1
No
No
Active
The last hook set is the first hook hauled.
VARCHAR2
13
GEAR_CONDITION
VARCHAR2
2
No
No
Active
Gear Condition at the completion of the haul
VARCHAR2
14
MAINLINE_LENGTH
NUMBER
22
No
No
4
1
Active
In nautical miles
NUMBER
15
SET_SPEED
NUMBER
22
No
No
3
1
Active
In Knots
NUMBER
16
BOTTOM_DEPTH_MINIMUM
NUMBER
22
No
No
4
0
Active
In fathoms.
NUMBER
17
BOTTOM_DEPTH_MAXIMUM
NUMBER
22
No
No
4
0
Active
In fathoms.
NUMBER
18
HOOK_DEPTH_MINIMUM
NUMBER
22
No
No
4
0
Active
In fathoms
NUMBER
19
HOOK_DEPTH_MAXIMUM
NUMBER
22
No
No
4
0
Active
In fathoms
NUMBER
20
TOTAL_ADDITIONAL_WEIGHT
NUMBER
22
No
No
5
0
Active
In Pounds
NUMBER
21
TARGET_SPECIES
VARCHAR2
3
Yes
No
Active
Uses Pop Species Code.
VARCHAR2
22
SOAK_DURATION
NUMBER
22
No
No
4
1
Active
In Hours
NUMBER
23
WERE_FLOATS_USED
VARCHAR2
1
No
No
Active
Were Floats Used
VARCHAR2
24
NUMBER_OF_FLOATS
NUMBER
22
No
No
4
0
Active
Number of floats used during the haul.
NUMBER
25
WERE_LIGHT_STICKS_USED
VARCHAR2
1
No
No
Active
Were Light Sticks Used
VARCHAR2
26
NUMBER_LIGHT_STICKS
NUMBER
22
No
No
4
0
Active
Populated only if were_light_sticks_used is set to yes.
NUMBER
27
WERE_RATTLERS_USED
VARCHAR2
1
No
No
Active
Were Rattlers Used
VARCHAR2
28
NUMBER_RATTLERS
NUMBER
22
No
No
4
0
Active
Populated only if were_rattlers_used is set to yes.
NUMBER
29
WERE_SURF_LITES_USED
VARCHAR2
1
No
No
Active
Were Surf Lites Used
VARCHAR2
30
NUMBER_SURF_LITES
NUMBER
22
No
No
2
0
Active
Populated only if were_surf_lites_used is set to yes.
NUMBER
31
WERE_RADIO_BEACONS_USED
VARCHAR2
1
No
No
Active
Were Radio Beacons Used
VARCHAR2
32
NUMBER_RADIO_BEACONS
NUMBER
22
No
No
2
0
Active
Populated only if were_radio_beacons_used is set to yes.
NUMBER
33
WERE_RADAR_REFLECTORS_USED
VARCHAR2
1
No
No
Active
Were radar relectors used
VARCHAR2
34
NUMBER_RADAR_REFLECTORS
NUMBER
22
No
No
4
0
Active
Populated only if number_radar_reflectors_used is set to yes.
NUMBER
35
ADDITIONAL_LINE_WEIGHTS_USED
VARCHAR2
1
No
No
Active
Were Additional Line Weights used
VARCHAR2
36
NUMBER_ADDITIONAL_LINE_WEIGHTS
NUMBER
22
No
No
3
0
Active
Populated only if addtional_line_weights_used is set to yes.
NUMBER
37
NUMBER_HOOKS_SET
NUMBER
22
No
No
4
0
Active
Number of Hooks set
NUMBER
38
NUMBER_HOOKS_LOST
NUMBER
22
No
No
4
0
Active
Number of Hooks lost. This should relate to the Gear Condition [POP_GEAR_LOG.GEAR_CONDITION] but it also includes bite offs and cut offs.
NUMBER
39
NUMBER_HOOKS_TENDED
NUMBER
22
No
No
4
0
Active
Number of Hooks Pulled during hotlining, which is when the vessel runs the line and pulls hooks where floats are submerged.
NUMBER
40
NUMBER_HOOKS_REBAITED
NUMBER
22
No
No
4
0
Active
Number of hooks pulled, rebaited and put back into the water. This is added to set number to get the total hooks for effort analysis.
NUMBER
41
BEGIN_SET_DATE
DATE
7
No
No
Active
Hours and minutes are included in the time.
DATE
42
END_SET_DATE
DATE
7
No
No
Active
Hours and minutes are included in the time.
DATE
43
BEGIN_HAUL_DATE
DATE
7
No
No
Active
Hours and minutes are included in the time.
DATE
44
END_HAUL_DATE
DATE
7
No
No
Active
Time includes year, date, hours and minutes.
DATE
45
BEGIN_SET_LATITUDE
NUMBER
22
No
No
2
0
Active
Begin Set Latitude Degrees
NUMBER
46
BEGIN_SET_LATITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
Begin Set Latitude Minutes
NUMBER
47
BEGIN_SET_LATITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
Begin Set Latitude Hemisphere.
VARCHAR2
48
END_SET_LATITUDE
NUMBER
22
No
No
2
0
Active
End Set Latitude Degrees
NUMBER
49
END_SET_LATITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
End Set Latitude Minutes
NUMBER
50
END_SET_LATITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
End Set Latitude Hemisphere
VARCHAR2
51
BEGIN_HAUL_LATITUDE
NUMBER
22
No
No
2
0
Active
Begin Haul Latitude Degrees
NUMBER
52
BEGIN_HAUL_LATITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
Begin Haul Latitude Minutes
NUMBER
53
BEGIN_HAUL_LATITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
Begin Haul Latitude Hemisphere
VARCHAR2
54
END_HAUL_LATITUDE
NUMBER
22
No
No
2
0
Active
End Haul Latitude Degrees
NUMBER
55
END_HAUL_LATITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
End Haul Latitude Minutes
NUMBER
56
END_HAUL_LATITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
End Haul Latitude Hemisphere
VARCHAR2
57
BEGIN_SET_LONGITUDE
NUMBER
22
No
No
3
0
Active
Begin Set Longitude Degrees
NUMBER
58
BEGIN_SET_LONGITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
Begin Set Longitude Minutes
NUMBER
59
BEGIN_SET_LONGITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
Begin Set Longitude Hemisphere
VARCHAR2
60
END_SET_LONGITUDE
NUMBER
22
No
No
3
0
Active
End Set Longitude Degrees
NUMBER
61
END_SET_LONGITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
End Set Longitude Minutes
NUMBER
62
END_SET_LONGITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
End Set Longitude Hemisphere
VARCHAR2
63
BEGIN_HAUL_LONGITUDE
NUMBER
22
No
No
3
0
Active
Begin Haul Longitude Degrees
NUMBER
64
BEGIN_HAUL_LONGITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
Begin Haul Longitude Minutes
NUMBER
65
BEGIN_HAUL_LONGITUDE_HEMISPHER
VARCHAR2
1
Yes
No
Active
Begin Haul Longitude Hemisphere
VARCHAR2
66
END_HAUL_LONGITUDE
NUMBER
22
No
No
3
0
Active
End Haul Longitude Degrees
NUMBER
67
END_HAUL_LONGITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
End Haul Longitude Minutes
NUMBER
68
END_HAUL_LONGITUDE_HEMISPHERE
VARCHAR2
1
Yes
No
Active
End Haul Longitude Hemisphere
VARCHAR2
69
BEGIN_SET_TEMPERATURE
NUMBER
22
No
No
3
1
Active
In Fahrenheit
NUMBER
70
END_SET_TEMPERATURE
NUMBER
22
No
No
3
1
Active
In Fahrenheit
NUMBER
71
BEGIN_HAUL_TEMPERATURE
NUMBER
22
No
No
3
1
Active
In Fahrenheit
NUMBER
72
END_HAUL_TEMPERATURE
NUMBER
22
No
No
3
1
Active
In Fahrenheit
NUMBER
73
SET_DURATION
NUMBER
22
No
No
4
1
Active
Set Duration In Hours
NUMBER
74
HAUL_LOST_TIME
NUMBER
22
No
No
4
1
Active
Time Lost During Haul. (In Hours)
NUMBER
75
HAUL_DURATION
NUMBER
22
No
No
4
1
Active
In Hours
NUMBER
76
FISHING_AREA
VARCHAR2
3
No
No
Active
Fishing Area
VARCHAR2
77
EXPERIMENTAL_TREATMENT
VARCHAR2
3
No
No
Active
Refers to certain experimental PLOP data.The value assigned here is defined by experimental parameters that can be gotten from Cheryl Brown.
VARCHAR2
78
COMMENTS
VARCHAR2
2000
No
No
Active
Observer comments about the haul
VARCHAR2
79
IS_EXPERIMENT
VARCHAR2
1
No
No
Active
Is an experimental haul?
VARCHAR2
80
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
81
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
82
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Modified by whom
VARCHAR2
83
MODIFIED_DATE
DATE
7
No
No
Active
Modified when
DATE
gov.noaa.nmfs.inport:5347
Lee Weinberger
2007-10-12T05:01:43
SysAdmin InPortAdmin
2022-08-09T17:11:01
2021-05-06
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
www.sefsc.noaa.gov
8:00 a.m. - 4:30 p.m. EST
1001
Public
No
2021-05-06
1 Year
2022-05-06