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

Summary

Abstract

Observer Purse Seine Gear Characteristics

Description

Observer Purse Seine Gear Characteristics

Entity Information

Entity Type
Data View

Data Attribute / Type Description
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.
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.
GEARNUM
VARCHAR2
Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
NEGEAR
VARCHAR2
Northeast gear code. See OBGEAR table. Collected for ASM where applicable.
NETLEN
NUMBER
Average horizontal distance of net, measured along float line, in whole feet. Collected for ASM where applicable.
BUNTLEN
NUMBER
Total length of bunt measured along floatline, in whole feet.
NETDPTH
NUMBER
Overall depth of net section, in whole fathoms.
BUNTDPTH
NUMBER
Overall depth of sack/bunt section of the sein, in whole fathoms..
MSNET
NUMBER
Mesh size of net in inches to 100th of inch; obtained from captain
MSBUNT
NUMBER
Mesh size used in bunt of gear, to nearest hundredth of inch.
TSNET
VARCHAR2
Twine size of sack/ bunt webbing in whole millimeters; obtained from captain
TSBUNT
VARCHAR2
Twine size of the bunt in whole millimeters; obtained from the captain
NETMAT
VARCHAR2
Type of construction material used in body of net, not including codend. See OBNETMAT table. Removed with obdbs Version 10.
BUNTMAT
VARCHAR2
Material of bunt webbing on gear.
FLLINLEN
NUMBER
Length of floatline, in whole fathoms.
FLLINDIA
NUMBER
Diameter of floatline, in hundredths of inches.
LDLINLEN
NUMBER
Length of leadline, in whole fathoms.
LDLINDIA
NUMBER
Diameter of leadline, in hundredths of inches.
PSLINLEN
NUMBER
Length of purse line, in whole fathoms.
PSLINDIA
NUMBER
Diameter of purse line, in whole fathoms.
LDLINWGT
NUMBER
Total weight of leadline used, in whole pounds.
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)
ADDWGTLBS
NUMBER
Total weight of additional weights used on leadline or mainline, in whole pounds. Not collected prior to 2001 (all set to null )
HAULDEV
VARCHAR2
Code for device used for hauling gear aboard vessel.
RINGTYP
VARCHAR2
Code for type of rings used to secure purse line to net.
RINGMAT
VARCHAR2
Type of material used to construct the rings.
PSGCOMMENTS
VARCHAR2
Additional information re: Purse Seine Gear.
DOE
DATE
Date of Entry of the associated record.
UOE
VARCHAR2
Oracle user ID of the person who entered the data.
DOC
DATE
Date associated record was updated.
UOC
VARCHAR2
Oracle ID of user who made the (most recent ) change on the record.

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: OBPSG
Short Name: OBPSG
Status: Completed
Abstract:

Observer Purse Seine Gear Characteristics

Notes:

Loaded by batch 8949, 07-06-2016 08:23

Entity Information

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

Observer Purse Seine Gear Characteristics

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
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
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
GEARNUM VARCHAR2 Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
100
NEGEAR VARCHAR2 Northeast gear code. See OBGEAR table. Collected for ASM where applicable.
100
NETLEN NUMBER Average horizontal distance of net, measured along float line, in whole feet. Collected for ASM where applicable.
100
BUNTLEN NUMBER Total length of bunt measured along floatline, in whole feet.
100
NETDPTH NUMBER Overall depth of net section, in whole fathoms.
100
BUNTDPTH NUMBER Overall depth of sack/bunt section of the sein, in whole fathoms..
100
MSNET NUMBER Mesh size of net in inches to 100th of inch; obtained from captain
100
MSBUNT NUMBER Mesh size used in bunt of gear, to nearest hundredth of inch.
100
TSNET VARCHAR2 Twine size of sack/ bunt webbing in whole millimeters; obtained from captain
100
TSBUNT VARCHAR2 Twine size of the bunt in whole millimeters; obtained from the captain
100
NETMAT VARCHAR2 Type of construction material used in body of net, not including codend. See OBNETMAT table. Removed with obdbs Version 10.
100
BUNTMAT VARCHAR2 Material of bunt webbing on gear.
100
FLLINLEN NUMBER Length of floatline, in whole fathoms.
100
FLLINDIA NUMBER Diameter of floatline, in hundredths of inches.
100
LDLINLEN NUMBER Length of leadline, in whole fathoms.
100
LDLINDIA NUMBER Diameter of leadline, in hundredths of inches.
100
PSLINLEN NUMBER Length of purse line, in whole fathoms.
100
PSLINDIA NUMBER Diameter of purse line, in whole fathoms.
100
LDLINWGT NUMBER Total weight of leadline used, in whole pounds.
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
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
HAULDEV VARCHAR2 Code for device used for hauling gear aboard vessel.
100
RINGTYP VARCHAR2 Code for type of rings used to secure purse line to net.
100
RINGMAT VARCHAR2 Type of material used to construct the rings.
100
PSGCOMMENTS VARCHAR2 Additional information re: Purse Seine Gear.
100
DOE DATE Date of Entry of the associated record.
100
UOE VARCHAR2 Oracle user ID of the person who entered the data.
100
DOC DATE Date associated record was updated.
100
UOC VARCHAR2 Oracle ID of user who made the (most recent ) change on the record.

Attribute Details

LINK4

CC ID: 330216
Seq. Order: 1
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: 330227
Seq. Order: 2
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

PROGRAM

CC ID: 330238
Seq. Order: 3
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: 330245
Seq. Order: 4
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: 330246
Seq. Order: 5
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: 330247
Seq. Order: 6
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

GEARNUM

CC ID: 330248
Seq. Order: 7
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

NEGEAR

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

Northeast gear code. See OBGEAR table. Collected for ASM where applicable.

General Data Type: VARCHAR2

NETLEN

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

Average horizontal distance of net, measured along float line, in whole feet. Collected for ASM where applicable.

General Data Type: NUMBER

BUNTLEN

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

Total length of bunt measured along floatline, in whole feet.

General Data Type: NUMBER

NETDPTH

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

Overall depth of net section, in whole fathoms.

General Data Type: NUMBER

BUNTDPTH

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

Overall depth of sack/bunt section of the sein, in whole fathoms..

General Data Type: NUMBER

MSNET

CC ID: 330220
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 2
Status: Active
Description:

Mesh size of net in inches to 100th of inch; obtained from captain

General Data Type: NUMBER

MSBUNT

CC ID: 330221
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 2
Status: Active
Description:

Mesh size used in bunt of gear, to nearest hundredth of inch.

General Data Type: NUMBER

TSNET

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

Twine size of sack/ bunt webbing in whole millimeters; obtained from captain

General Data Type: VARCHAR2

TSBUNT

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

Twine size of the bunt in whole millimeters; obtained from the captain

General Data Type: VARCHAR2

NETMAT

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

Type of construction material used in body of net, not including codend. See OBNETMAT table. Removed with obdbs Version 10.

General Data Type: VARCHAR2

BUNTMAT

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

Material of bunt webbing on gear.

General Data Type: VARCHAR2

FLLINLEN

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

Length of floatline, in whole fathoms.

General Data Type: NUMBER

FLLINDIA

CC ID: 330228
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 2
Status: Active
Description:

Diameter of floatline, in hundredths of inches.

General Data Type: NUMBER

LDLINLEN

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

Length of leadline, in whole fathoms.

General Data Type: NUMBER

LDLINDIA

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

Diameter of leadline, in hundredths of inches.

General Data Type: NUMBER

PSLINLEN

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

Length of purse line, in whole fathoms.

General Data Type: NUMBER

PSLINDIA

CC ID: 330232
Seq. Order: 24
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 2
Status: Active
Description:

Diameter of purse line, in whole fathoms.

General Data Type: NUMBER

LDLINWGT

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

Total weight of leadline used, in whole pounds.

General Data Type: NUMBER

ADDWGTUSD

CC ID: 330234
Seq. Order: 26
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

ADDWGTLBS

CC ID: 330235
Seq. Order: 27
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

HAULDEV

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

Code for device used for hauling gear aboard vessel.

General Data Type: VARCHAR2

RINGTYP

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

Code for type of rings used to secure purse line to net.

General Data Type: VARCHAR2

RINGMAT

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

Type of material used to construct the rings.

General Data Type: VARCHAR2

PSGCOMMENTS

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

Additional information re: Purse Seine Gear.

General Data Type: VARCHAR2

DOE

CC ID: 330241
Seq. Order: 32
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date of Entry of the associated record.

General Data Type: DATE

UOE

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

Oracle user ID of the person who entered the data.

General Data Type: VARCHAR2

DOC

CC ID: 330243
Seq. Order: 34
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date associated record was updated.

General Data Type: DATE

UOC

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

Oracle ID of user who made the (most recent ) change on the record.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 33308
GUID: gov.noaa.nmfs.inport:33308
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-07-06 08:23+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