Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Observer LongLine Hauls

Description

Observer LongLine Hauls

Entity Information

Entity Type
Data View

Data Attribute / Type Description
LINK3
VARCHAR2
Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. Collected for ASM where applicable.
PROGRAM
VARCHAR2
First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
YEAR
VARCHAR2
Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.
MONTH
VARCHAR2
Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.
TRIPID
VARCHAR2
May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable.
HAULNUM
VARCHAR2
Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable.
LINK4
VARCHAR2
Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable.
LINK1
VARCHAR2
15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable.
GEARNUM
VARCHAR2
Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
WTMPSBEG
NUMBER
Surface water temperature at beginning of set, Fahrenheit to nearest tenth of degree.
WTMPSEND
NUMBER
Surface water temperature at end of set, Fahrenheit to nearest tenth of degree.
WTMPHBEG
NUMBER
Surface water temperature at beginning of haul, Fahrenheit to nearest tenth of degree.
RATLRUSD
VARCHAR2
Indicator of whether rattlers used on gear. 0 = no , 1 = yes 9 = unknown
NRATLRS
NUMBER
Number of rattlers used on gear.
SURLTUSD
VARCHAR2
Indicator of whether surface lights used on gear. 0 = no 1 = yes 9 = unknown
NSURLT
NUMBER
Number of surface lights used on gear.
ADDWGTUSD
VARCHAR2
Indicator of additional line weights attached to leadline (GGG) or mainline (LLH). 0 = no, 1 = yes, 9 = unknown. Not collected prior to 2001 (all set to 9 = unknown)
NADDWGTS
NUMBER
Number of additional line weights.
ADDWGTLBS
NUMBER
Total weight of additional weights used on leadline or mainline, in whole pounds. Not collected prior to 2001 (all set to null )
NHKSET
NUMBER
Total number of hooks used for set.
NHKHAUL
NUMBER
Total number of hooks hauled from this set (3/2007)
NHKLOST
NUMBER
Total number of hooks lost from set.
NHKTEND
NUMBER
Number of hooks pulled during "hotlining". Not collected prior to 2001; set to unknown.
NHKREBA
NUMBER
Number of hooks pulled, rebaited and reset. Not collected prior to 2001; set to unknown.
BAIT1LBS
NUMBER
Amount of primary bait used for haul, in whole pounds.
BAIT1KND
VARCHAR2
Code for primary bait kind. see OBBAIT table.
BAIT1TYP
VARCHAR2
Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other.
BAIT1CND
VARCHAR2
Code for condition of primary bait used. 0 = unknown. 1 = previously frozen, 2 = fresh, 3 = salted, 6 = frozen, 7 = semifrozen, 8 = combination, 9 = other.
BAIT2LBS
NUMBER
Amount of secondary bait used for haul, in whole pounds.
BAIT2KND
VARCHAR2
Code for bait kind. See OBBAIT table.
BAIT2TYP
VARCHAR2
Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other
BAIT2CND
VARCHAR2
Code for condition of bait used. 0 = unknown, 1 = previously frozen, 2 = fresh, 3 = salted, 6 = frozen, 7 = semifrozen, 8 = combination, 9 = other.
BAIT3LBS
NUMBER
Amount of third bait used for haul, in whole lbs.
BAIT3KND
VARCHAR2
Code for bait kind. see OBBAIT table
BAIT3TYP
VARCHAR2
Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other
BAIT3CND
VARCHAR2
Code for condition of bait used. 0 = unknown 1 = previously frozen 2 = fresh 3 = salted 6 = frozen 7 = semifrozen 8 = combination 9 = other
MLLEN
NUMBER
Length of mainline, to the nearest 10th of nautical mile. Collected for ASM where applicable.
SETSPEED
NUMBER
Speed of vessel setting net during set, nearest 10th of knot.
HKDEPMIN
NUMBER
Shallowest depth, from surface, in which hooks fished, in whole fathoms.
HKDEPMAX
NUMBER
Deepest depth, from surface, in which hooks fished, in whole fathoms.
SETMETHOD
VARCHAR2
Method of manner in which gear was set for haul. See OBSETMETHOD table.
LLHCOMMENTS
VARCHAR2
Comments on line haul record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: View: OBLLH
Short Name: OBLLH
Status: Completed
Abstract:

Observer LongLine Hauls

Notes:

Loaded by batch 9053, 07-27-2016 19:10

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: OBDBS
Description:

Observer LongLine Hauls

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
LINK3 VARCHAR2 Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. Collected for ASM where applicable.
100
PROGRAM VARCHAR2 First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
100
YEAR VARCHAR2 Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.
100
MONTH VARCHAR2 Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.
100
TRIPID VARCHAR2 May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable.
100
HAULNUM VARCHAR2 Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable.
100
LINK4 VARCHAR2 Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable.
100
LINK1 VARCHAR2 15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable.
100
GEARNUM VARCHAR2 Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
100
WTMPSBEG NUMBER Surface water temperature at beginning of set, Fahrenheit to nearest tenth of degree.
100
WTMPSEND NUMBER Surface water temperature at end of set, Fahrenheit to nearest tenth of degree.
100
WTMPHBEG NUMBER Surface water temperature at beginning of haul, Fahrenheit to nearest tenth of degree.
100
RATLRUSD VARCHAR2 Indicator of whether rattlers used on gear. 0 = no , 1 = yes 9 = unknown
100
NRATLRS NUMBER Number of rattlers used on gear.
100
SURLTUSD VARCHAR2 Indicator of whether surface lights used on gear. 0 = no 1 = yes 9 = unknown
100
NSURLT NUMBER Number of surface lights used on gear.
100
ADDWGTUSD VARCHAR2 Indicator of additional line weights attached to leadline (GGG) or mainline (LLH). 0 = no, 1 = yes, 9 = unknown. Not collected prior to 2001 (all set to 9 = unknown)
100
NADDWGTS NUMBER Number of additional line weights.
100
ADDWGTLBS NUMBER Total weight of additional weights used on leadline or mainline, in whole pounds. Not collected prior to 2001 (all set to null )
100
NHKSET NUMBER Total number of hooks used for set.
100
NHKHAUL NUMBER Total number of hooks hauled from this set (3/2007)
100
NHKLOST NUMBER Total number of hooks lost from set.
100
NHKTEND NUMBER Number of hooks pulled during "hotlining". Not collected prior to 2001; set to unknown.
100
NHKREBA NUMBER Number of hooks pulled, rebaited and reset. Not collected prior to 2001; set to unknown.
100
BAIT1LBS NUMBER Amount of primary bait used for haul, in whole pounds.
100
BAIT1KND VARCHAR2 Code for primary bait kind. see OBBAIT table.
100
BAIT1TYP VARCHAR2 Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other.
100
BAIT1CND VARCHAR2 Code for condition of primary bait used. 0 = unknown. 1 = previously frozen, 2 = fresh, 3 = salted, 6 = frozen, 7 = semifrozen, 8 = combination, 9 = other.
100
BAIT2LBS NUMBER Amount of secondary bait used for haul, in whole pounds.
100
BAIT2KND VARCHAR2 Code for bait kind. See OBBAIT table.
100
BAIT2TYP VARCHAR2 Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other
100
BAIT2CND VARCHAR2 Code for condition of bait used. 0 = unknown, 1 = previously frozen, 2 = fresh, 3 = salted, 6 = frozen, 7 = semifrozen, 8 = combination, 9 = other.
100
BAIT3LBS NUMBER Amount of third bait used for haul, in whole lbs.
100
BAIT3KND VARCHAR2 Code for bait kind. see OBBAIT table
100
BAIT3TYP VARCHAR2 Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other
100
BAIT3CND VARCHAR2 Code for condition of bait used. 0 = unknown 1 = previously frozen 2 = fresh 3 = salted 6 = frozen 7 = semifrozen 8 = combination 9 = other
100
MLLEN NUMBER Length of mainline, to the nearest 10th of nautical mile. Collected for ASM where applicable.
100
SETSPEED NUMBER Speed of vessel setting net during set, nearest 10th of knot.
100
HKDEPMIN NUMBER Shallowest depth, from surface, in which hooks fished, in whole fathoms.
100
HKDEPMAX NUMBER Deepest depth, from surface, in which hooks fished, in whole fathoms.
100
SETMETHOD VARCHAR2 Method of manner in which gear was set for haul. See OBSETMETHOD table.
100
LLHCOMMENTS VARCHAR2 Comments on line haul record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable.

Attribute Details

LINK3

CC ID: 334588
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 19
Required: No
Primary Key: No
Status: Active
Description:

Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. Collected for ASM where applicable.

General Data Type: VARCHAR2

PROGRAM

CC ID: 334599
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.

General Data Type: VARCHAR2

YEAR

CC ID: 334610
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.

General Data Type: VARCHAR2

MONTH

CC ID: 334621
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.

General Data Type: VARCHAR2

TRIPID

CC ID: 334625
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable.

General Data Type: VARCHAR2

HAULNUM

CC ID: 334626
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable.

General Data Type: VARCHAR2

LINK4

CC ID: 334627
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 17
Required: No
Primary Key: No
Status: Active
Description:

Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable.

General Data Type: VARCHAR2

LINK1

CC ID: 334628
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable.

General Data Type: VARCHAR2

GEARNUM

CC ID: 334629
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.

General Data Type: VARCHAR2

WTMPSBEG

CC ID: 334589
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 1
Status: Active
Description:

Surface water temperature at beginning of set, Fahrenheit to nearest tenth of degree.

General Data Type: NUMBER

WTMPSEND

CC ID: 334590
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 1
Status: Active
Description:

Surface water temperature at end of set, Fahrenheit to nearest tenth of degree.

General Data Type: NUMBER

WTMPHBEG

CC ID: 334591
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 1
Status: Active
Description:

Surface water temperature at beginning of haul, Fahrenheit to nearest tenth of degree.

General Data Type: NUMBER

RATLRUSD

CC ID: 334592
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicator of whether rattlers used on gear. 0 = no , 1 = yes 9 = unknown

General Data Type: VARCHAR2

NRATLRS

CC ID: 334593
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Number of rattlers used on gear.

General Data Type: NUMBER

SURLTUSD

CC ID: 334594
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicator of whether surface lights used on gear. 0 = no 1 = yes 9 = unknown

General Data Type: VARCHAR2

NSURLT

CC ID: 334595
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Number of surface lights used on gear.

General Data Type: NUMBER

ADDWGTUSD

CC ID: 334596
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicator of additional line weights attached to leadline (GGG) or mainline (LLH). 0 = no, 1 = yes, 9 = unknown. Not collected prior to 2001 (all set to 9 = unknown)

General Data Type: VARCHAR2

NADDWGTS

CC ID: 334597
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Number of additional line weights.

General Data Type: NUMBER

ADDWGTLBS

CC ID: 334598
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Total weight of additional weights used on leadline or mainline, in whole pounds. Not collected prior to 2001 (all set to null )

General Data Type: NUMBER

NHKSET

CC ID: 334600
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Total number of hooks used for set.

General Data Type: NUMBER

NHKHAUL

CC ID: 334601
Seq. Order: 21
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Total number of hooks hauled from this set (3/2007)

General Data Type: NUMBER

NHKLOST

CC ID: 334602
Seq. Order: 22
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Total number of hooks lost from set.

General Data Type: NUMBER

NHKTEND

CC ID: 334603
Seq. Order: 23
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Number of hooks pulled during "hotlining". Not collected prior to 2001; set to unknown.

General Data Type: NUMBER

NHKREBA

CC ID: 334604
Seq. Order: 24
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Number of hooks pulled, rebaited and reset. Not collected prior to 2001; set to unknown.

General Data Type: NUMBER

BAIT1LBS

CC ID: 334605
Seq. Order: 25
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Amount of primary bait used for haul, in whole pounds.

General Data Type: NUMBER

BAIT1KND

CC ID: 334606
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Code for primary bait kind. see OBBAIT table.

General Data Type: VARCHAR2

BAIT1TYP

CC ID: 334607
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other.

General Data Type: VARCHAR2

BAIT1CND

CC ID: 334608
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for condition of primary bait used. 0 = unknown. 1 = previously frozen, 2 = fresh, 3 = salted, 6 = frozen, 7 = semifrozen, 8 = combination, 9 = other.

General Data Type: VARCHAR2

BAIT2LBS

CC ID: 334609
Seq. Order: 29
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Amount of secondary bait used for haul, in whole pounds.

General Data Type: NUMBER

BAIT2KND

CC ID: 334611
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Code for bait kind. See OBBAIT table.

General Data Type: VARCHAR2

BAIT2TYP

CC ID: 334612
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other

General Data Type: VARCHAR2

BAIT2CND

CC ID: 334613
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for condition of bait used. 0 = unknown, 1 = previously frozen, 2 = fresh, 3 = salted, 6 = frozen, 7 = semifrozen, 8 = combination, 9 = other.

General Data Type: VARCHAR2

BAIT3LBS

CC ID: 334614
Seq. Order: 33
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Amount of third bait used for haul, in whole lbs.

General Data Type: NUMBER

BAIT3KND

CC ID: 334615
Seq. Order: 34
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Code for bait kind. see OBBAIT table

General Data Type: VARCHAR2

BAIT3TYP

CC ID: 334616
Seq. Order: 35
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other

General Data Type: VARCHAR2

BAIT3CND

CC ID: 334617
Seq. Order: 36
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for condition of bait used. 0 = unknown 1 = previously frozen 2 = fresh 3 = salted 6 = frozen 7 = semifrozen 8 = combination 9 = other

General Data Type: VARCHAR2

MLLEN

CC ID: 334618
Seq. Order: 37
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 1
Status: Active
Description:

Length of mainline, to the nearest 10th of nautical mile. Collected for ASM where applicable.

General Data Type: NUMBER

SETSPEED

CC ID: 334619
Seq. Order: 38
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 1
Status: Active
Description:

Speed of vessel setting net during set, nearest 10th of knot.

General Data Type: NUMBER

HKDEPMIN

CC ID: 334620
Seq. Order: 39
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Shallowest depth, from surface, in which hooks fished, in whole fathoms.

General Data Type: NUMBER

HKDEPMAX

CC ID: 334622
Seq. Order: 40
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Deepest depth, from surface, in which hooks fished, in whole fathoms.

General Data Type: NUMBER

SETMETHOD

CC ID: 334623
Seq. Order: 41
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Method of manner in which gear was set for haul. See OBSETMETHOD table.

General Data Type: VARCHAR2

LLHCOMMENTS

CC ID: 334624
Seq. Order: 42
Data Storage Type: VARCHAR2
Max Length: 250
Required: No
Primary Key: No
Status: Active
Description:

Comments on line haul record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 33566
GUID: gov.noaa.nmfs.inport:33566
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-07-27 19:10+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-07-28
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-07-28
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-07-28