Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Fisheries Sampling Branch (FSB) > Observer and At Sea Monitor Database (OBDBS) >

View: OBSTH

Entity (ENT) | Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:33318 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Observer Scallop Trawl Hauls from standard observer trips

Description

Observer Scallop Trawl Hauls from standard observer trips

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.
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.
HAULNUM VARCHAR2	Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable.
GEARNUM VARCHAR2	Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
NETOBS VARCHAR2	Net(s) where kept and discard data were collected" 0=unknown, 1= port, 2= starboard, 3=both, 4=aft, 0= unknown Collected for ASM where applicable.
TOWSPEED NUMBER	Average towing speed over bottom, to nearest 10th of knot.
WIREOUT NUMBER	Amount of wire paid out for haul, in whole fathoms.
CLAPOBS VARCHAR2	Indicator of whether sea scallop clappers were found in gear for haul. 0 = no, 1 = yes, 9 = unknown.
NBUSHKEP NUMBER	Amount of scallops, in the shell, kept from haul, to nearest hundredth of a bushel. Not entered prior to 5/1994; set to unknown.
NBUSHDIS NUMBER	Amount of scallops, in the shell, discarded from haul, to nearest hundredth of a bushel. Not collected prior to 5/1994; set to unknown.
AVLBBUSHKEP NUMBER	Average pounds per bushel of scallops kept from haul. For standard protocol these are estimated , in shell. For closed area scallop (CAS) trips they are recorded as dressed (shucked) weights. Not recorded before 5/1994; set to unknown.
AVLBBUSHDIS NUMBER	Average pounds per bushel of scallops, in shell, discarded from haul. Not collected prior to 5/1994; set to unknown.
DRKEPFLAG VARCHAR2	Indicator of whether the avlbbushkept is for dressed/shucked (1) or round (2) scallops 0 = unknown
DRDISFLAG VARCHAR2	Indicator of whether the avlbbushdis is for dressed/shucked (1) or round (2) scallops 0 = unknown
NTURNS NUMBER	Number of turns > 90 degrees in haul; begun 3/2007
NETOVERT NUMBER	Average distance from the top to bottom of mouth of net while fishing; whole feet; begun 3/2007
NETOHORIZ NUMBER	Average width of netmouth wing tip -> wing tip while fishing; whole feet; begun 3/2007
DOORSPREAD NUMBER	Average distance between the doors while fishing; whole feet; begun 3/2007
STHCOMMENTS VARCHAR2	Comments on Scallop trawl haul

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.

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.

HAULNUM
VARCHAR2

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

GEARNUM
VARCHAR2

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

NETOBS
VARCHAR2

Net(s) where kept and discard data were collected" 0=unknown, 1= port, 2= starboard, 3=both, 4=aft, 0= unknown Collected for ASM where applicable.

TOWSPEED
NUMBER

Average towing speed over bottom, to nearest 10th of knot.

WIREOUT
NUMBER

Amount of wire paid out for haul, in whole fathoms.

CLAPOBS
VARCHAR2

Indicator of whether sea scallop clappers were found in gear for haul. 0 = no, 1 = yes, 9 = unknown.

NBUSHKEP
NUMBER

Amount of scallops, in the shell, kept from haul, to nearest hundredth of a bushel. Not entered prior to 5/1994; set to unknown.

NBUSHDIS
NUMBER

Amount of scallops, in the shell, discarded from haul, to nearest hundredth of a bushel. Not collected prior to 5/1994; set to unknown.

AVLBBUSHKEP
NUMBER

Average pounds per bushel of scallops kept from haul. For standard protocol these are estimated , in shell. For closed area scallop (CAS) trips they are recorded as dressed (shucked) weights. Not recorded before 5/1994; set to unknown.

AVLBBUSHDIS
NUMBER

Average pounds per bushel of scallops, in shell, discarded from haul. Not collected prior to 5/1994; set to unknown.

DRKEPFLAG
VARCHAR2

Indicator of whether the avlbbushkept is for dressed/shucked (1) or round (2) scallops 0 = unknown

DRDISFLAG
VARCHAR2

Indicator of whether the avlbbushdis is for dressed/shucked (1) or round (2) scallops 0 = unknown

NTURNS
NUMBER

Number of turns > 90 degrees in haul; begun 3/2007

NETOVERT
NUMBER

Average distance from the top to bottom of mouth of net while fishing; whole feet; begun 3/2007

NETOHORIZ
NUMBER

Average width of netmouth wing tip -> wing tip while fishing; whole feet; begun 3/2007

DOORSPREAD
NUMBER

Average distance between the doors while fishing; whole feet; begun 3/2007

STHCOMMENTS
VARCHAR2

Comments on Scallop trawl haul

No Child Items for this record.

No contact information is available for this record.

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

Title:	View: OBSTH
Short Name:	OBSTH
Status:	Completed
Abstract:	Observer Scallop Trawl Hauls from standard observer trips
Notes:	Loaded by batch 8949, 07-06-2016 08:23

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	OBDBS
Description:	Observer Scallop Trawl Hauls from standard observer trips

Attribute Summary

	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	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	HAULNUM	VARCHAR2	Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable.
100	GEARNUM	VARCHAR2	Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
100	NETOBS	VARCHAR2	Net(s) where kept and discard data were collected" 0=unknown, 1= port, 2= starboard, 3=both, 4=aft, 0= unknown Collected for ASM where applicable.
100	TOWSPEED	NUMBER	Average towing speed over bottom, to nearest 10th of knot.
100	WIREOUT	NUMBER	Amount of wire paid out for haul, in whole fathoms.
100	CLAPOBS	VARCHAR2	Indicator of whether sea scallop clappers were found in gear for haul. 0 = no, 1 = yes, 9 = unknown.
100	NBUSHKEP	NUMBER	Amount of scallops, in the shell, kept from haul, to nearest hundredth of a bushel. Not entered prior to 5/1994; set to unknown.
100	NBUSHDIS	NUMBER	Amount of scallops, in the shell, discarded from haul, to nearest hundredth of a bushel. Not collected prior to 5/1994; set to unknown.
100	AVLBBUSHKEP	NUMBER	Average pounds per bushel of scallops kept from haul. For standard protocol these are estimated , in shell. For closed area scallop (CAS) trips they are recorded as dressed (shucked) weights. Not recorded before 5/1994; set to unknown.
100	AVLBBUSHDIS	NUMBER	Average pounds per bushel of scallops, in shell, discarded from haul. Not collected prior to 5/1994; set to unknown.
100	DRKEPFLAG	VARCHAR2	Indicator of whether the avlbbushkept is for dressed/shucked (1) or round (2) scallops 0 = unknown
100	DRDISFLAG	VARCHAR2	Indicator of whether the avlbbushdis is for dressed/shucked (1) or round (2) scallops 0 = unknown
100	NTURNS	NUMBER	Number of turns > 90 degrees in haul; begun 3/2007
100	NETOVERT	NUMBER	Average distance from the top to bottom of mouth of net while fishing; whole feet; begun 3/2007
100	NETOHORIZ	NUMBER	Average width of netmouth wing tip -> wing tip while fishing; whole feet; begun 3/2007
100	DOORSPREAD	NUMBER	Average distance between the doors while fishing; whole feet; begun 3/2007
100	STHCOMMENTS	VARCHAR2	Comments on Scallop trawl haul

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

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

100

HAULNUM

VARCHAR2

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

100

GEARNUM

VARCHAR2

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

100

NETOBS

VARCHAR2

Net(s) where kept and discard data were collected" 0=unknown, 1= port, 2= starboard, 3=both, 4=aft, 0= unknown Collected for ASM where applicable.

100

TOWSPEED

NUMBER

Average towing speed over bottom, to nearest 10th of knot.

100

WIREOUT

NUMBER

Amount of wire paid out for haul, in whole fathoms.

100

CLAPOBS

VARCHAR2

Indicator of whether sea scallop clappers were found in gear for haul. 0 = no, 1 = yes, 9 = unknown.

100

NBUSHKEP

NUMBER

Amount of scallops, in the shell, kept from haul, to nearest hundredth of a bushel. Not entered prior to 5/1994; set to unknown.

100

NBUSHDIS

NUMBER

Amount of scallops, in the shell, discarded from haul, to nearest hundredth of a bushel. Not collected prior to 5/1994; set to unknown.

100

AVLBBUSHKEP

NUMBER

100

AVLBBUSHDIS

NUMBER

Average pounds per bushel of scallops, in shell, discarded from haul. Not collected prior to 5/1994; set to unknown.

100

DRKEPFLAG

VARCHAR2

Indicator of whether the avlbbushkept is for dressed/shucked (1) or round (2) scallops 0 = unknown

100

DRDISFLAG

VARCHAR2

Indicator of whether the avlbbushdis is for dressed/shucked (1) or round (2) scallops 0 = unknown

100

NTURNS

NUMBER

Number of turns > 90 degrees in haul; begun 3/2007

100

NETOVERT

NUMBER

Average distance from the top to bottom of mouth of net while fishing; whole feet; begun 3/2007

100

NETOHORIZ

NUMBER

Average width of netmouth wing tip -> wing tip while fishing; whole feet; begun 3/2007

100

DOORSPREAD

NUMBER

Average distance between the doors while fishing; whole feet; begun 3/2007

100

STHCOMMENTS

VARCHAR2

Comments on Scallop trawl haul

Attribute Details

LINK3

CC ID: 330620

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

LINK4

CC ID: 330631

Seq. Order:	2
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: 330637

Seq. Order:	3
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: 330638

Seq. Order:	4
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: 330639

Seq. Order:	5
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: 330640

Seq. Order:	6
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: 330641

Seq. Order:	7
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: 330642

Seq. Order:	8
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

GEARNUM

CC ID: 330643

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

NETOBS

CC ID: 330621

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Net(s) where kept and discard data were collected" 0=unknown, 1= port, 2= starboard, 3=both, 4=aft, 0= unknown Collected for ASM where applicable.
General Data Type:	VARCHAR2

TOWSPEED

CC ID: 330622

Seq. Order:	11
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	1
Status:	Active
Description:	Average towing speed over bottom, to nearest 10th of knot.
General Data Type:	NUMBER

WIREOUT

CC ID: 330623

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Amount of wire paid out for haul, in whole fathoms.
General Data Type:	NUMBER

CLAPOBS

CC ID: 330624

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of whether sea scallop clappers were found in gear for haul. 0 = no, 1 = yes, 9 = unknown.
General Data Type:	VARCHAR2

NBUSHKEP

CC ID: 330625

Seq. Order:	14
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	2
Status:	Active
Description:	Amount of scallops, in the shell, kept from haul, to nearest hundredth of a bushel. Not entered prior to 5/1994; set to unknown.
General Data Type:	NUMBER

NBUSHDIS

CC ID: 330626

Seq. Order:	15
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	2
Status:	Active
Description:	Amount of scallops, in the shell, discarded from haul, to nearest hundredth of a bushel. Not collected prior to 5/1994; set to unknown.
General Data Type:	NUMBER

AVLBBUSHKEP

CC ID: 330627

Seq. Order:	16
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	1
Status:	Active
Description:	Average pounds per bushel of scallops kept from haul. For standard protocol these are estimated , in shell. For closed area scallop (CAS) trips they are recorded as dressed (shucked) weights. Not recorded before 5/1994; set to unknown.
General Data Type:	NUMBER

AVLBBUSHDIS

CC ID: 330628

Seq. Order:	17
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	1
Status:	Active
Description:	Average pounds per bushel of scallops, in shell, discarded from haul. Not collected prior to 5/1994; set to unknown.
General Data Type:	NUMBER

DRKEPFLAG

CC ID: 330629

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of whether the avlbbushkept is for dressed/shucked (1) or round (2) scallops 0 = unknown
General Data Type:	VARCHAR2

DRDISFLAG

CC ID: 330630

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of whether the avlbbushdis is for dressed/shucked (1) or round (2) scallops 0 = unknown
General Data Type:	VARCHAR2

NTURNS

CC ID: 330632

Seq. Order:	20
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Number of turns > 90 degrees in haul; begun 3/2007
General Data Type:	NUMBER

NETOVERT

CC ID: 330633

Seq. Order:	21
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Average distance from the top to bottom of mouth of net while fishing; whole feet; begun 3/2007
General Data Type:	NUMBER

NETOHORIZ

CC ID: 330634

Seq. Order:	22
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Average width of netmouth wing tip -> wing tip while fishing; whole feet; begun 3/2007
General Data Type:	NUMBER

DOORSPREAD

CC ID: 330635

Seq. Order:	23
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Average distance between the doors while fishing; whole feet; begun 3/2007
General Data Type:	NUMBER

STHCOMMENTS

CC ID: 330636

Seq. Order:	24
Data Storage Type:	VARCHAR2
Max Length:	250
Required:	No
Primary Key:	No
Status:	Active
Description:	Comments on Scallop trawl haul
General Data Type:	VARCHAR2

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

View: OBSTH

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

LINK3

LINK4

LINK1

PROGRAM

YEAR

MONTH

TRIPID

HAULNUM

GEARNUM

NETOBS

TOWSPEED

WIREOUT

CLAPOBS

NBUSHKEP

NBUSHDIS

AVLBBUSHKEP

AVLBBUSHDIS

DRKEPFLAG

DRDISFLAG

NTURNS

NETOVERT

NETOHORIZ

DOORSPREAD

STHCOMMENTS

Catalog Details