5342
Table: POP_GEAR_LOG
POP_GEAR_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
One record for each gear log in the trip
Loaded by batch 1683, 10-12-2007 05:01
Data Table
Yes
POPOL
One record for each gear log in the trip
1
GEAR_LOG_KEY
NUMBER
22
Yes
Yes
10
0
Active
Generated primary key
NUMBER
2
STRING_NUMBER
NUMBER
22
Yes
No
1
0
Active
Consecutive number assigned to each string. Changes that result in a change of target species will necessitate a new string number.
NUMBER
3
NUMBER_HOOKS
NUMBER
22
No
No
4
0
Active
Average number of hooks set calculated over all hauls with the same gear configuration.
NUMBER
4
ANCHOR_USED
VARCHAR2
1
Yes
No
Active
Was an anchor used?
VARCHAR2
5
ANCHOR_WEIGHT
NUMBER
22
No
No
3
0
Active
Units are pounds.
NUMBER
6
MAINLINE_COLOR
VARCHAR2
2
No
No
Active
Coded color of the main line
VARCHAR2
7
MAINLINE_DIAMETER
NUMBER
22
No
No
2
1
Active
In millimeters
NUMBER
8
MAINLINE_STRENGTH
NUMBER
22
No
No
4
0
Active
In pounds
NUMBER
9
MAINLINE_MATERIAL
VARCHAR2
1
No
No
Active
Coded material that the mainline is constructed with.
VARCHAR2
10
MAINLINE_STRANDS
NUMBER
22
No
No
4
0
Active
Number of strands in the mainline
NUMBER
11
WERE_OTHER_FLOATS_USED
VARCHAR2
1
No
No
Active
Were Other Floats Used
VARCHAR2
12
NUMBER_OTHER_FLOATS
NUMBER
22
No
No
4
0
Active
Number of Other Floats used ?
NUMBER
13
NUMBER_HOOKS_BETWEEN_FLOATS
NUMBER
22
No
No
4
0
Active
Maximum number of hooks between floats
NUMBER
14
NUMBER_RADIO_BEACONS
NUMBER
22
No
No
4
0
Active
Number of radio beacons
NUMBER
15
NUMBER_RADAR_REFLECTORS
NUMBER
22
No
No
4
0
Active
Number of radar reflectors
NUMBER
16
NUMBER_SECTIONS
NUMBER
22
No
No
3
0
Active
Number of sections
NUMBER
17
DISTANCE_BETWEEN_SECTIONS
NUMBER
22
No
No
3
1
Active
Distance between sections in nautical miles.
NUMBER
18
WERE_LIGHT_STICKS_USED
VARCHAR2
1
No
No
Active
Were light sticks used
VARCHAR2
19
LIGHT_STICK_COLOR
VARCHAR2
2
No
No
Active
Light stick color. Only populated if light sticks were used.
VARCHAR2
20
GANGION_DISTANCE
NUMBER
22
No
No
4
0
Active
Distance between gangions in feet.
NUMBER
21
GANGION_DIAMETER
NUMBER
22
No
No
4
1
Active
Gangion diameter to the nearest tenth of a millimeter.
NUMBER
22
GANGION_MATERIAL
VARCHAR2
1
No
No
Active
Code of material used for gangions
VARCHAR2
23
GANGION_COLOR
VARCHAR2
2
No
No
Active
Gangion Color Code
VARCHAR2
24
LEADER_LENGTH
NUMBER
22
No
No
4
0
Active
Length of the leader to the nearest inch.
NUMBER
25
LEADER_STRENGTH
NUMBER
22
No
No
4
0
Active
Test or Dry Breaking Weight Strength of the leader in pound.
NUMBER
26
LEADER_MATERIAL
VARCHAR2
1
No
No
Active
Code of Material Used For Leaders.
VARCHAR2
27
COMMENTS
VARCHAR2
2000
No
No
Active
Comments
VARCHAR2
28
GENERATED_RECORD
VARCHAR2
1
No
No
Active
'Y' if a Gear Log record was generated
VARCHAR2
29
CREATED_BY_USER_ID
VARCHAR2
20
Yes
No
Active
Created by whom
VARCHAR2
30
CREATED_DATE
DATE
7
Yes
No
Active
Created when
DATE
31
MODIFIED_BY_USER_ID
VARCHAR2
20
No
No
Active
Modified by whom
VARCHAR2
32
MODIFIED_DATE
DATE
7
No
No
Active
Modified when
DATE
33
WERE_POLYBALL_FLOATS_USED
VARCHAR2
1
No
No
Active
Were polybal floats used?
VARCHAR2
34
WERE_BULLET_FLOATS_USED
VARCHAR2
1
No
No
Active
Were Bulet Floats Used
VARCHAR2
35
NUMBER_POLYBALL_FLOATS
NUMBER
22
No
No
4
0
Active
Number of polybal floats.
NUMBER
36
NUMBER_BULLET_FLOATS
NUMBER
22
No
No
4
0
Active
Number of bulet floats
NUMBER
37
GANGION_TEST
NUMBER
22
No
No
4
0
Active
Test or Dry Breaking Weight Strength of the gangion in pounds
NUMBER
38
TRIP_NUMBER
VARCHAR2
6
Yes
No
Active
Link to POP_TRIP_LOG
VARCHAR2
39
STATUS_ID
VARCHAR2
1
No
No
Active
Status Identifier
VARCHAR2
gov.noaa.nmfs.inport:5342
Lee Weinberger
2007-10-12T05:01:41
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