Table: POP_GEAR_LOG
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:5342 | Updated: June 14, 2024 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
One record for each gear log in the trip
DescriptionOne record for each gear log in the trip
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
GEAR_LOG_KEY
NUMBER |
Generated primary key |
STRING_NUMBER
NUMBER |
Consecutive number assigned to each string. Changes that result in a change of target species will necessitate a new string number. |
NUMBER_HOOKS
NUMBER |
Average number of hooks set calculated over all hauls with the same gear configuration. |
ANCHOR_USED
VARCHAR2 |
Was an anchor used? |
ANCHOR_WEIGHT
NUMBER |
Units are pounds. |
MAINLINE_COLOR
VARCHAR2 |
Coded color of the main line |
MAINLINE_DIAMETER
NUMBER |
In millimeters |
MAINLINE_STRENGTH
NUMBER |
In pounds |
MAINLINE_MATERIAL
VARCHAR2 |
Coded material that the mainline is constructed with. |
MAINLINE_STRANDS
NUMBER |
Number of strands in the mainline |
WERE_OTHER_FLOATS_USED
VARCHAR2 |
Were Other Floats Used |
NUMBER_OTHER_FLOATS
NUMBER |
Number of Other Floats used ? |
NUMBER_HOOKS_BETWEEN_FLOATS
NUMBER |
Maximum number of hooks between floats |
NUMBER_RADIO_BEACONS
NUMBER |
Number of radio beacons |
NUMBER_RADAR_REFLECTORS
NUMBER |
Number of radar reflectors |
NUMBER_SECTIONS
NUMBER |
Number of sections |
DISTANCE_BETWEEN_SECTIONS
NUMBER |
Distance between sections in nautical miles. |
WERE_LIGHT_STICKS_USED
VARCHAR2 |
Were light sticks used |
LIGHT_STICK_COLOR
VARCHAR2 |
Light stick color. Only populated if light sticks were used. |
GANGION_DISTANCE
NUMBER |
Distance between gangions in feet. |
GANGION_DIAMETER
NUMBER |
Gangion diameter to the nearest tenth of a millimeter. |
GANGION_MATERIAL
VARCHAR2 |
Code of material used for gangions |
GANGION_COLOR
VARCHAR2 |
Gangion Color Code |
LEADER_LENGTH
NUMBER |
Length of the leader to the nearest inch. |
LEADER_STRENGTH
NUMBER |
Test or Dry Breaking Weight Strength of the leader in pound. |
LEADER_MATERIAL
VARCHAR2 |
Code of Material Used For Leaders. |
COMMENTS
VARCHAR2 |
Comments |
GENERATED_RECORD
VARCHAR2 |
'Y' if a Gear Log record was generated |
CREATED_BY_USER_ID
VARCHAR2 |
Created by whom |
CREATED_DATE
DATE |
Created when |
MODIFIED_BY_USER_ID
VARCHAR2 |
Modified by whom |
MODIFIED_DATE
DATE |
Modified when |
WERE_POLYBALL_FLOATS_USED
VARCHAR2 |
Were polybal floats used? |
WERE_BULLET_FLOATS_USED
VARCHAR2 |
Were Bulet Floats Used |
NUMBER_POLYBALL_FLOATS
NUMBER |
Number of polybal floats. |
NUMBER_BULLET_FLOATS
NUMBER |
Number of bulet floats |
GANGION_TEST
NUMBER |
Test or Dry Breaking Weight Strength of the gangion in pounds |
TRIP_NUMBER
VARCHAR2 |
Link to POP_TRIP_LOG |
STATUS_ID
VARCHAR2 |
Status Identifier |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (SEFSC) for inquiries on this record.
Item Identification
Title: | Table: POP_GEAR_LOG |
---|---|
Short Name: | POP_GEAR_LOG |
Status: | Completed |
Abstract: |
One record for each gear log in the trip |
Notes: |
Loaded by batch 1683, 10-12-2007 05:01 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | POPOL |
Description: |
One record for each gear log in the trip |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
GEAR_LOG_KEY | NUMBER | Generated primary key | |
100
|
STRING_NUMBER | NUMBER | Consecutive number assigned to each string. Changes that result in a change of target species will necessitate a new string number. | |
100
|
NUMBER_HOOKS | NUMBER | Average number of hooks set calculated over all hauls with the same gear configuration. | |
100
|
ANCHOR_USED | VARCHAR2 | Was an anchor used? | |
100
|
ANCHOR_WEIGHT | NUMBER | Units are pounds. | |
100
|
MAINLINE_COLOR | VARCHAR2 | Coded color of the main line | |
100
|
MAINLINE_DIAMETER | NUMBER | In millimeters | |
100
|
MAINLINE_STRENGTH | NUMBER | In pounds | |
100
|
MAINLINE_MATERIAL | VARCHAR2 | Coded material that the mainline is constructed with. | |
100
|
MAINLINE_STRANDS | NUMBER | Number of strands in the mainline | |
100
|
WERE_OTHER_FLOATS_USED | VARCHAR2 | Were Other Floats Used | |
100
|
NUMBER_OTHER_FLOATS | NUMBER | Number of Other Floats used ? | |
100
|
NUMBER_HOOKS_BETWEEN_FLOATS | NUMBER | Maximum number of hooks between floats | |
100
|
NUMBER_RADIO_BEACONS | NUMBER | Number of radio beacons | |
100
|
NUMBER_RADAR_REFLECTORS | NUMBER | Number of radar reflectors | |
100
|
NUMBER_SECTIONS | NUMBER | Number of sections | |
100
|
DISTANCE_BETWEEN_SECTIONS | NUMBER | Distance between sections in nautical miles. | |
100
|
WERE_LIGHT_STICKS_USED | VARCHAR2 | Were light sticks used | |
100
|
LIGHT_STICK_COLOR | VARCHAR2 | Light stick color. Only populated if light sticks were used. | |
100
|
GANGION_DISTANCE | NUMBER | Distance between gangions in feet. | |
100
|
GANGION_DIAMETER | NUMBER | Gangion diameter to the nearest tenth of a millimeter. | |
100
|
GANGION_MATERIAL | VARCHAR2 | Code of material used for gangions | |
100
|
GANGION_COLOR | VARCHAR2 | Gangion Color Code | |
100
|
LEADER_LENGTH | NUMBER | Length of the leader to the nearest inch. | |
100
|
LEADER_STRENGTH | NUMBER | Test or Dry Breaking Weight Strength of the leader in pound. | |
100
|
LEADER_MATERIAL | VARCHAR2 | Code of Material Used For Leaders. | |
100
|
COMMENTS | VARCHAR2 | Comments | |
100
|
GENERATED_RECORD | VARCHAR2 | 'Y' if a Gear Log record was generated | |
100
|
CREATED_BY_USER_ID | VARCHAR2 | Created by whom | |
100
|
CREATED_DATE | DATE | Created when | |
100
|
MODIFIED_BY_USER_ID | VARCHAR2 | Modified by whom | |
100
|
MODIFIED_DATE | DATE | Modified when | |
100
|
WERE_POLYBALL_FLOATS_USED | VARCHAR2 | Were polybal floats used? | |
100
|
WERE_BULLET_FLOATS_USED | VARCHAR2 | Were Bulet Floats Used | |
100
|
NUMBER_POLYBALL_FLOATS | NUMBER | Number of polybal floats. | |
100
|
NUMBER_BULLET_FLOATS | NUMBER | Number of bulet floats | |
100
|
GANGION_TEST | NUMBER | Test or Dry Breaking Weight Strength of the gangion in pounds | |
100
|
TRIP_NUMBER | VARCHAR2 | Link to POP_TRIP_LOG | |
100
|
STATUS_ID | VARCHAR2 | Status Identifier |
Attribute Details
GEAR_LOG_KEY
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Generated primary key |
General Data Type: | NUMBER |
STRING_NUMBER
Seq. Order: | 2 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
Consecutive number assigned to each string. Changes that result in a change of target species will necessitate a new string number. |
General Data Type: | NUMBER |
NUMBER_HOOKS
Seq. Order: | 3 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Average number of hooks set calculated over all hauls with the same gear configuration. |
General Data Type: | NUMBER |
ANCHOR_USED
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Was an anchor used? |
General Data Type: | VARCHAR2 |
ANCHOR_WEIGHT
Seq. Order: | 5 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Units are pounds. |
General Data Type: | NUMBER |
MAINLINE_COLOR
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Coded color of the main line |
General Data Type: | VARCHAR2 |
MAINLINE_DIAMETER
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 1 |
Status: | Active |
Description: |
In millimeters |
General Data Type: | NUMBER |
MAINLINE_STRENGTH
Seq. Order: | 8 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
In pounds |
General Data Type: | NUMBER |
MAINLINE_MATERIAL
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Coded material that the mainline is constructed with. |
General Data Type: | VARCHAR2 |
MAINLINE_STRANDS
Seq. Order: | 10 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Number of strands in the mainline |
General Data Type: | NUMBER |
WERE_OTHER_FLOATS_USED
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Were Other Floats Used |
General Data Type: | VARCHAR2 |
NUMBER_OTHER_FLOATS
Seq. Order: | 12 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Number of Other Floats used ? |
General Data Type: | NUMBER |
NUMBER_HOOKS_BETWEEN_FLOATS
Seq. Order: | 13 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Maximum number of hooks between floats |
General Data Type: | NUMBER |
NUMBER_RADIO_BEACONS
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Number of radio beacons |
General Data Type: | NUMBER |
NUMBER_RADAR_REFLECTORS
Seq. Order: | 15 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Number of radar reflectors |
General Data Type: | NUMBER |
NUMBER_SECTIONS
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Number of sections |
General Data Type: | NUMBER |
DISTANCE_BETWEEN_SECTIONS
Seq. Order: | 17 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 1 |
Status: | Active |
Description: |
Distance between sections in nautical miles. |
General Data Type: | NUMBER |
WERE_LIGHT_STICKS_USED
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Were light sticks used |
General Data Type: | VARCHAR2 |
LIGHT_STICK_COLOR
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Light stick color. Only populated if light sticks were used. |
General Data Type: | VARCHAR2 |
GANGION_DISTANCE
Seq. Order: | 20 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Distance between gangions in feet. |
General Data Type: | NUMBER |
GANGION_DIAMETER
Seq. Order: | 21 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 1 |
Status: | Active |
Description: |
Gangion diameter to the nearest tenth of a millimeter. |
General Data Type: | NUMBER |
GANGION_MATERIAL
Seq. Order: | 22 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code of material used for gangions |
General Data Type: | VARCHAR2 |
GANGION_COLOR
Seq. Order: | 23 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Gangion Color Code |
General Data Type: | VARCHAR2 |
LEADER_LENGTH
Seq. Order: | 24 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Length of the leader to the nearest inch. |
General Data Type: | NUMBER |
LEADER_STRENGTH
Seq. Order: | 25 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Test or Dry Breaking Weight Strength of the leader in pound. |
General Data Type: | NUMBER |
LEADER_MATERIAL
Seq. Order: | 26 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code of Material Used For Leaders. |
General Data Type: | VARCHAR2 |
COMMENTS
Seq. Order: | 27 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2000 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Comments |
General Data Type: | VARCHAR2 |
GENERATED_RECORD
Seq. Order: | 28 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
'Y' if a Gear Log record was generated |
General Data Type: | VARCHAR2 |
CREATED_BY_USER_ID
Seq. Order: | 29 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Created by whom |
General Data Type: | VARCHAR2 |
CREATED_DATE
Seq. Order: | 30 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Created when |
General Data Type: | DATE |
MODIFIED_BY_USER_ID
Seq. Order: | 31 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Modified by whom |
General Data Type: | VARCHAR2 |
MODIFIED_DATE
Seq. Order: | 32 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Modified when |
General Data Type: | DATE |
WERE_POLYBALL_FLOATS_USED
Seq. Order: | 33 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Were polybal floats used? |
General Data Type: | VARCHAR2 |
WERE_BULLET_FLOATS_USED
Seq. Order: | 34 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Were Bulet Floats Used |
General Data Type: | VARCHAR2 |
NUMBER_POLYBALL_FLOATS
Seq. Order: | 35 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Number of polybal floats. |
General Data Type: | NUMBER |
NUMBER_BULLET_FLOATS
Seq. Order: | 36 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Number of bulet floats |
General Data Type: | NUMBER |
GANGION_TEST
Seq. Order: | 37 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Test or Dry Breaking Weight Strength of the gangion in pounds |
General Data Type: | NUMBER |
TRIP_NUMBER
Seq. Order: | 38 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Link to POP_TRIP_LOG |
General Data Type: | VARCHAR2 |
STATUS_ID
Seq. Order: | 39 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Status Identifier |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 5342 |
---|---|
GUID: | gov.noaa.nmfs.inport:5342 |
Metadata Record Created By: | Lee M Weinberger |
Metadata Record Created: | 2007-10-12 05:01+0000 |
Metadata Record Last Modified By: | Lee M Weinberger |
Metadata Record Last Modified: | 2024-06-14 13:53+0000 |
Metadata Record Published: | 2024-06-14 |
Owner Org: | SEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2021-05-06 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2022-05-06 |