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

Summary

Abstract

Observer Beach Seine Gear

Description

Observer Beach Seine Gear

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.
NNETS
NUMBER
Total number of individual nets used. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable.
BUNTUSD
VARCHAR2
Indicator of whether bunt is used in gear.
BUNTLEN
NUMBER
Total length of bunt measured along floatline, in whole feet.
BUNTHGT
NUMBER
Height of bunt, to nearest 10th of a foot.
MSBUNT
NUMBER
Mesh size used in bunt of gear, to nearest hundredth of inch.
MSTYPBUNT
VARCHAR2
Indicator of whether bunt mesh size is actual or estimated.
BUNMCVERT
NUMBER
Number of vertical meshes of bunt, count of individual meshes along one endline.
BUNHNGRATIO
NUMBER
Average fractional ratio of floatline for bunt to length bunt would be if bunt were taken off floatline & stretched out.
TSBUNT
VARCHAR2
Twine size of the bunt in whole millimeters; obtained from the captain
TSTYPBUNT
VARCHAR2
If twine size measure actual: 1(A), estiamted: 2(E), unknown 0(U)
BUNTNSTRAN
NUMBER
Number of strands of twine in the bunt webbing.
BUNTCOLOR
VARCHAR2
Color of bunt webbing on gear.
BUNTMAT
VARCHAR2
Material of bunt webbing on gear.
FLOATUSD
VARCHAR2
Indicator of whether floats were used on gear. 0=no, 1=yes 9= unknown.
FLDISTBT
NUMBER
Distance between floats ; null if not used or unknown
WSNTUSD
VARCHAR2
If washnet used = 1, if not used = 0, if unknown = 9
WSNTLEN
NUMBER
Length of Wash Net in whole feet if used; null if not used or unknown
GEARLEN
NUMBER
Computed: total of bunt, wash net and wings; null if any are unknown
ANCHUSD
VARCHAR2
Indicator of whether an anchor was used. 0 = no 1 = yes 9 = unknown.
ANCHTYP
VARCHAR2
Anchor type danforth: 1, Dead weight 2, combo 8, other 9, unknown 0. 3/2007|added to Beach Seine 7-08
NANCHOR
NUMBER
Total number of Anchors on Gear; null if not used or unknown
ANCHWGT
NUMBER
Total weight of anchor(s) used to hold gear in place, in whole pounds.
ANCHWGTYP
VARCHAR2
Indicator of whether anchor weight was an actual or estimated weight. 0 = unknown, 1 = actual 2 = estimated. Not collected prior to 1994; all set to unknown
FLLINMAT
VARCHAR2
Material of floatline used. 0=unknown; 1=floating(w/foam core); 2= twisted polypropylene; 9=other. Not collected before 1994; set to unknown
LDLINWGT
NUMBER
Total weight of leadline used, in whole pounds.
ACTMMDUSD
VARCHAR2
An indicator for whether an active marine mammal deterrent device was used on gear. Collection began in 1994, all records prior to 1994 were set to unknown. 0 = no, 1 = yes, and 9 = unknown.
NACTMMD
NUMBER
Number of active marine mammal deterrent devices (I.e.pingers),on gear when it was set. Not collected prior to2001. Set to unknown
ACTMMDBRD
VARCHAR2
Brand name of active marine mammal deterrent devices. Not collected prior to 2001, all records prior to 2001 were set to unknown. 00 = unknown, 01 = Dukane, 02 = Airmar, 03 = Fumunda, 98 = combination, and 99 = other (Note: code '00' represents an unknown marine mammal deterrent device and null values when no device is used). To distinguish between unknown deterrent devices and null values please refer to the ACTMMDUSD field.
ACTMMDFRQ
VARCHAR2
Frequency of active marine mammal deterrent devices on gear, in kilohertz. Not collected prior to 2001. (set to 000 = unknown)
PASMMDUSD
VARCHAR2
Indicator of whether passive marine mammal deterrent devices were used. 0=no; 1=yes.
NPASMMD
NUMBER
Number of passive marine mammal deterrent devices on gear when it was set. Not collected prior to2001. Set to unknown.
BSGCOMMENTS
VARCHAR2
Additional information re:gear.

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

Observer Beach Seine Gear

Notes:

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

Entity Information

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

Observer Beach Seine Gear

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
NNETS NUMBER Total number of individual nets used. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable.
100
BUNTUSD VARCHAR2 Indicator of whether bunt is used in gear.
100
BUNTLEN NUMBER Total length of bunt measured along floatline, in whole feet.
100
BUNTHGT NUMBER Height of bunt, to nearest 10th of a foot.
100
MSBUNT NUMBER Mesh size used in bunt of gear, to nearest hundredth of inch.
100
MSTYPBUNT VARCHAR2 Indicator of whether bunt mesh size is actual or estimated.
100
BUNMCVERT NUMBER Number of vertical meshes of bunt, count of individual meshes along one endline.
100
BUNHNGRATIO NUMBER Average fractional ratio of floatline for bunt to length bunt would be if bunt were taken off floatline & stretched out.
100
TSBUNT VARCHAR2 Twine size of the bunt in whole millimeters; obtained from the captain
100
TSTYPBUNT VARCHAR2 If twine size measure actual: 1(A), estiamted: 2(E), unknown 0(U)
100
BUNTNSTRAN NUMBER Number of strands of twine in the bunt webbing.
100
BUNTCOLOR VARCHAR2 Color of bunt webbing on gear.
100
BUNTMAT VARCHAR2 Material of bunt webbing on gear.
100
FLOATUSD VARCHAR2 Indicator of whether floats were used on gear. 0=no, 1=yes 9= unknown.
100
FLDISTBT NUMBER Distance between floats ; null if not used or unknown
100
WSNTUSD VARCHAR2 If washnet used = 1, if not used = 0, if unknown = 9
100
WSNTLEN NUMBER Length of Wash Net in whole feet if used; null if not used or unknown
100
GEARLEN NUMBER Computed: total of bunt, wash net and wings; null if any are unknown
100
ANCHUSD VARCHAR2 Indicator of whether an anchor was used. 0 = no 1 = yes 9 = unknown.
100
ANCHTYP VARCHAR2 Anchor type danforth: 1, Dead weight 2, combo 8, other 9, unknown 0. 3/2007|added to Beach Seine 7-08
100
NANCHOR NUMBER Total number of Anchors on Gear; null if not used or unknown
100
ANCHWGT NUMBER Total weight of anchor(s) used to hold gear in place, in whole pounds.
100
ANCHWGTYP VARCHAR2 Indicator of whether anchor weight was an actual or estimated weight. 0 = unknown, 1 = actual 2 = estimated. Not collected prior to 1994; all set to unknown
100
FLLINMAT VARCHAR2 Material of floatline used. 0=unknown; 1=floating(w/foam core); 2= twisted polypropylene; 9=other. Not collected before 1994; set to unknown
100
LDLINWGT NUMBER Total weight of leadline used, in whole pounds.
100
ACTMMDUSD VARCHAR2 An indicator for whether an active marine mammal deterrent device was used on gear. Collection began in 1994, all records prior to 1994 were set to unknown. 0 = no, 1 = yes, and 9 = unknown.
100
NACTMMD NUMBER Number of active marine mammal deterrent devices (I.e.pingers),on gear when it was set. Not collected prior to2001. Set to unknown
100
ACTMMDBRD VARCHAR2 Brand name of active marine mammal deterrent devices. Not collected prior to 2001, all records prior to 2001 were set to unknown. 00 = unknown, 01 = Dukane, 02 = Airmar, 03 = Fumunda, 98 = combination, and 99 = other (Note: code '00' represents an unknown marine mammal deterrent device and null values when no device is used). To distinguish between unknown deterrent devices and null values please refer to the ACTMMDUSD field.
100
ACTMMDFRQ VARCHAR2 Frequency of active marine mammal deterrent devices on gear, in kilohertz. Not collected prior to 2001. (set to 000 = unknown)
100
PASMMDUSD VARCHAR2 Indicator of whether passive marine mammal deterrent devices were used. 0=no; 1=yes.
100
NPASMMD NUMBER Number of passive marine mammal deterrent devices on gear when it was set. Not collected prior to2001. Set to unknown.
100
BSGCOMMENTS VARCHAR2 Additional information re:gear.

Attribute Details

LINK4

CC ID: 334227
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: 334238
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: 334249
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: 334260
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: 334262
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: 334263
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: 334264
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: 334265
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

NNETS

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

Total number of individual nets used. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable.

General Data Type: NUMBER

BUNTUSD

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

Indicator of whether bunt is used in gear.

General Data Type: VARCHAR2

BUNTLEN

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

BUNTHGT

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

Height of bunt, to nearest 10th of a foot.

General Data Type: NUMBER

MSBUNT

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

MSTYPBUNT

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

Indicator of whether bunt mesh size is actual or estimated.

General Data Type: VARCHAR2

BUNMCVERT

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

Number of vertical meshes of bunt, count of individual meshes along one endline.

General Data Type: NUMBER

BUNHNGRATIO

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

Average fractional ratio of floatline for bunt to length bunt would be if bunt were taken off floatline & stretched out.

General Data Type: NUMBER

TSBUNT

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

TSTYPBUNT

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

If twine size measure actual: 1(A), estiamted: 2(E), unknown 0(U)

General Data Type: VARCHAR2

BUNTNSTRAN

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

Number of strands of twine in the bunt webbing.

General Data Type: NUMBER

BUNTCOLOR

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

Color of bunt webbing on gear.

General Data Type: VARCHAR2

BUNTMAT

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

Material of bunt webbing on gear.

General Data Type: VARCHAR2

FLOATUSD

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

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

General Data Type: VARCHAR2

FLDISTBT

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

Distance between floats ; null if not used or unknown

General Data Type: NUMBER

WSNTUSD

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

If washnet used = 1, if not used = 0, if unknown = 9

General Data Type: VARCHAR2

WSNTLEN

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

Length of Wash Net in whole feet if used; null if not used or unknown

General Data Type: NUMBER

GEARLEN

CC ID: 334245
Seq. Order: 26
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Computed: total of bunt, wash net and wings; null if any are unknown

General Data Type: NUMBER

ANCHUSD

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

Indicator of whether an anchor was used. 0 = no 1 = yes 9 = unknown.

General Data Type: VARCHAR2

ANCHTYP

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

Anchor type danforth: 1, Dead weight 2, combo 8, other 9, unknown 0. 3/2007|added to Beach Seine 7-08

General Data Type: VARCHAR2

NANCHOR

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

Total number of Anchors on Gear; null if not used or unknown

General Data Type: NUMBER

ANCHWGT

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

Total weight of anchor(s) used to hold gear in place, in whole pounds.

General Data Type: NUMBER

ANCHWGTYP

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

Indicator of whether anchor weight was an actual or estimated weight. 0 = unknown, 1 = actual 2 = estimated. Not collected prior to 1994; all set to unknown

General Data Type: VARCHAR2

FLLINMAT

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

Material of floatline used. 0=unknown; 1=floating(w/foam core); 2= twisted polypropylene; 9=other. Not collected before 1994; set to unknown

General Data Type: VARCHAR2

LDLINWGT

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

Total weight of leadline used, in whole pounds.

General Data Type: NUMBER

ACTMMDUSD

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

An indicator for whether an active marine mammal deterrent device was used on gear. Collection began in 1994, all records prior to 1994 were set to unknown. 0 = no, 1 = yes, and 9 = unknown.

General Data Type: VARCHAR2

NACTMMD

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

Number of active marine mammal deterrent devices (I.e.pingers),on gear when it was set. Not collected prior to2001. Set to unknown

General Data Type: NUMBER

ACTMMDBRD

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

Brand name of active marine mammal deterrent devices. Not collected prior to 2001, all records prior to 2001 were set to unknown. 00 = unknown, 01 = Dukane, 02 = Airmar, 03 = Fumunda, 98 = combination, and 99 = other (Note: code '00' represents an unknown marine mammal deterrent device and null values when no device is used). To distinguish between unknown deterrent devices and null values please refer to the ACTMMDUSD field.

General Data Type: VARCHAR2

ACTMMDFRQ

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

Frequency of active marine mammal deterrent devices on gear, in kilohertz. Not collected prior to 2001. (set to 000 = unknown)

General Data Type: VARCHAR2

PASMMDUSD

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

Indicator of whether passive marine mammal deterrent devices were used. 0=no; 1=yes.

General Data Type: VARCHAR2

NPASMMD

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

Number of passive marine mammal deterrent devices on gear when it was set. Not collected prior to2001. Set to unknown.

General Data Type: NUMBER

BSGCOMMENTS

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

Additional information re:gear.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 33558
GUID: gov.noaa.nmfs.inport:33558
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