View: OBBSG
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33558 | Updated: August 9, 2022 | Published / External
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |