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: OBSDG

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Observer Scallop Dredge and Crab Dredge Gear Characteristics from standard observer trips

Description

Observer Scallop Dredge and Crab Dredge Gear Characteristics from standard observer trips

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.
DREDGESDEPLOYED VARCHAR2	Code denoting where dredges are deployed. P = port, S = starboard, B = both, A=aft, U= Unknown. Not collected prior to 5/1994; set to unknown. Aft collected beginning 2005;
FRAMEHGTP NUMBER	Overall height of port dredge frame in inches.
FRAMEHGTS NUMBER	Overall height of starboard dredge frame in inches.
FRAMEWIDP NUMBER	Width of the port dredge frame, in whole feet.
FRAMEWIDS NUMBER	Width of the starboard dredge frame, in whole feet.
PPLATUSDP VARCHAR2	Indicator of whether pressure plate used on port dredge. 0 = no, 1 = yes, 9 = unknown.
PPLATUSDS VARCHAR2	Indicator of whether pressure plate used on starboard dredge. 0 = no, 1 = yes, 9 = unknown.
RCHNUSDP VARCHAR2	Indicator of rock chains used on the port dredge. 0 = no, 1 = yes, 2=configured for turtle exclusion, 9 = unknown.
RCHNUSDS VARCHAR2	Indicator of rock chains used on the starboard dredge. 0 = no, 1 = yes, 2=configured for turtle exclusion, 9 = unknown.
NRCHAINP NUMBER	Number of rock chains on the port dredge. 0=unknown if rchnusdp = 1. 0=n/a if rchnusdp = 0.
NRCHAINS NUMBER	Number of rock chains on the starboard dredge. 0=unknown if rchnusds = 1. 0=n/a if rchnusds = 0.
TCHNUSDP VARCHAR2	Tickler chain used on port dredge. 0=no, 1=yes, 1= configured for turtle exclusion, 9=unknown. Not entered before 5/1994; set to unknown.
TCHNUSDS VARCHAR2	Tickler chain used on starboard dredge. 0=no, 1= yes, 2 = configured for turtle exclusion, 9=unknown. Not entered before 5/1994; set to unknown.
NTCHAINP NUMBER	Number of tickler chains on the port dredge.
NTCHAINS NUMBER	Number of tickler chains on the starboard dredge.
CHNCONFIGP VARCHAR2	Configuration f the port scallop dredge 1 = standard, 2 = turtle chain mat
CHNCONFIGS VARCHAR2	Configuration f the scallop dredge starboard drecge1 = standard, 2 = turtle chain mat
MSTWTOPP NUMBER	Mesh size twine top port dredge in millimeters. For Crab Dredge (negear 383) values represent codend mesh sizes for port dredge.
MSTWTOPS NUMBER	Mesh size in the twine top of the starboard dredge in mIllimeters. For Crab Dredge (negear 383) values represent codend mesh sizes for starboard dredge.
CBCHAFFUSDP VARCHAR2	Indicator of whether chaffing gear was used on the port chain bag. 0=no, 1=yes 9= unknown.
CBCHAFFUSDS VARCHAR2	Indicator of whether chaffing gear was used on the starboard dredge chain bag. 0=no, 1=yes 9= unknown.
NLINKBTWP NUMBER	Number of links between 2 rings on the port dredge.
NLINKBTWS NUMBER	Number of links between 2 rings on the starboard dredge.
LINKSIZEP NUMBER	Link stock size of steel used in links between the rings in the bottom of the chain bag on the port dredge.
LINKSIZES NUMBER	Link stock size of steel used in links between the rings in the bottom of the chain bag on the starboard dredge.
RSITOBP NUMBER	Inside measure of ring size top of bag port dredge in millimeters.
RSITOBS NUMBER	Inside measure of ring size top of bag starboard dredge in milimeters.
RSIBOBP NUMBER	Inside measure of ring size bottom of bag port dredge in millimeters.
RSIBOBS NUMBER	Inside measure of ring size bottom of bag starboard dredge in millimeters.
RSOBOBP NUMBER	Outside measure of ring size bottom of bag port dredge in millimeters.
RSOBOBS NUMBER	Outside measure of ring size bottom of bag starboard dredge in millimeters.
MCTWTOPWIDP NUMBER	Number of meshes for the width of the twine top (runs from one side of the dredge frame to the other) on the port or aft gear
MCTWTOPWIDS NUMBER	Number of meshes for the width of the twine top (runs from one side of the dredge frame to the other) on the starboard gear
MCTWTOPLENP NUMBER	Number of meshes for the length of the twine top (runs from frame to chain bag) on the port or aft gear
MCTWTOPLENS NUMBER	Number of meshes for the length of the twine top (runs from frame to chain bag) on the starboard gear
TWTOPHUNGP VARCHAR2	Hanging configuration of twine top port or aft gear..0= unknown, 1 = diamond, 2 = square, 3 square,/wrapped, 8 = combination
TWTOPHUNGS VARCHAR2	Hanging configuration of twine top starboard gear..0= unknown, 1 = diamond, 2 = square, 3 square,/wrapped, 8 = combination
NRINGTWTOPP NUMBER	Number of rings that the twine top is hung from on port or aft deployed gear.
NRINGTWTOPS NUMBER	Number of rings that the twine top is hung from on starboard deployed gear.
NROWAPRONP NUMBER	Number of rings that the twine top is hung from on port or aft deployed gear.
NROWAPRONS NUMBER	Number of rings that the twine top is hung from on starboard deployed gear.
SDGCOMMENTSS VARCHAR2	Additional information regarding scallop starboard dredge haul.Prior to 2001 only true or false.
SDGCOMMENTSP VARCHAR2	Additional information regarding scallop port dredge haul. Prior to 2001 only true or false.
FRAMETYPP VARCHAR2	Type of dredge frame used on port dredge. See OBFRAMETYP table. Collected beginning with obdbs Version 10 (01/01/2011).
FRAMETYPS VARCHAR2	Type of dredge frame used on starboard dredge. See OBFRAMETYP table. Collected beginning with obdbs Version 10 (01/01/2011).

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.

DREDGESDEPLOYED
VARCHAR2

Code denoting where dredges are deployed. P = port, S = starboard, B = both, A=aft, U= Unknown. Not collected prior to 5/1994; set to unknown. Aft collected beginning 2005;

FRAMEHGTP
NUMBER

Overall height of port dredge frame in inches.

FRAMEHGTS
NUMBER

Overall height of starboard dredge frame in inches.

FRAMEWIDP
NUMBER

Width of the port dredge frame, in whole feet.

FRAMEWIDS
NUMBER

Width of the starboard dredge frame, in whole feet.

PPLATUSDP
VARCHAR2

Indicator of whether pressure plate used on port dredge. 0 = no, 1 = yes, 9 = unknown.

PPLATUSDS
VARCHAR2

Indicator of whether pressure plate used on starboard dredge. 0 = no, 1 = yes, 9 = unknown.

RCHNUSDP
VARCHAR2

Indicator of rock chains used on the port dredge. 0 = no, 1 = yes, 2=configured for turtle exclusion, 9 = unknown.

RCHNUSDS
VARCHAR2

Indicator of rock chains used on the starboard dredge. 0 = no, 1 = yes, 2=configured for turtle exclusion, 9 = unknown.

NRCHAINP
NUMBER

Number of rock chains on the port dredge. 0=unknown if rchnusdp = 1. 0=n/a if rchnusdp = 0.

NRCHAINS
NUMBER

Number of rock chains on the starboard dredge. 0=unknown if rchnusds = 1. 0=n/a if rchnusds = 0.

TCHNUSDP
VARCHAR2

Tickler chain used on port dredge. 0=no, 1=yes, 1= configured for turtle exclusion, 9=unknown. Not entered before 5/1994; set to unknown.

TCHNUSDS
VARCHAR2

Tickler chain used on starboard dredge. 0=no, 1= yes, 2 = configured for turtle exclusion, 9=unknown. Not entered before 5/1994; set to unknown.

NTCHAINP
NUMBER

Number of tickler chains on the port dredge.

NTCHAINS
NUMBER

Number of tickler chains on the starboard dredge.

CHNCONFIGP
VARCHAR2

Configuration f the port scallop dredge 1 = standard, 2 = turtle chain mat

CHNCONFIGS
VARCHAR2

Configuration f the scallop dredge starboard drecge1 = standard, 2 = turtle chain mat

MSTWTOPP
NUMBER

Mesh size twine top port dredge in millimeters. For Crab Dredge (negear 383) values represent codend mesh sizes for port dredge.

MSTWTOPS
NUMBER

Mesh size in the twine top of the starboard dredge in mIllimeters. For Crab Dredge (negear 383) values represent codend mesh sizes for starboard dredge.

CBCHAFFUSDP
VARCHAR2

Indicator of whether chaffing gear was used on the port chain bag. 0=no, 1=yes 9= unknown.

CBCHAFFUSDS
VARCHAR2

Indicator of whether chaffing gear was used on the starboard dredge chain bag. 0=no, 1=yes 9= unknown.

NLINKBTWP
NUMBER

Number of links between 2 rings on the port dredge.

NLINKBTWS
NUMBER

Number of links between 2 rings on the starboard dredge.

LINKSIZEP
NUMBER

Link stock size of steel used in links between the rings in the bottom of the chain bag on the port dredge.

LINKSIZES
NUMBER

Link stock size of steel used in links between the rings in the bottom of the chain bag on the starboard dredge.

RSITOBP
NUMBER

Inside measure of ring size top of bag port dredge in millimeters.

RSITOBS
NUMBER

Inside measure of ring size top of bag starboard dredge in milimeters.

RSIBOBP
NUMBER

Inside measure of ring size bottom of bag port dredge in millimeters.

RSIBOBS
NUMBER

Inside measure of ring size bottom of bag starboard dredge in millimeters.

RSOBOBP
NUMBER

Outside measure of ring size bottom of bag port dredge in millimeters.

RSOBOBS
NUMBER

Outside measure of ring size bottom of bag starboard dredge in millimeters.

MCTWTOPWIDP
NUMBER

Number of meshes for the width of the twine top (runs from one side of the dredge frame to the other) on the port or aft gear

MCTWTOPWIDS
NUMBER

Number of meshes for the width of the twine top (runs from one side of the dredge frame to the other) on the starboard gear

MCTWTOPLENP
NUMBER

Number of meshes for the length of the twine top (runs from frame to chain bag) on the port or aft gear

MCTWTOPLENS
NUMBER

Number of meshes for the length of the twine top (runs from frame to chain bag) on the starboard gear

TWTOPHUNGP
VARCHAR2

Hanging configuration of twine top port or aft gear..0= unknown, 1 = diamond, 2 = square, 3 square,/wrapped, 8 = combination

TWTOPHUNGS
VARCHAR2

Hanging configuration of twine top starboard gear..0= unknown, 1 = diamond, 2 = square, 3 square,/wrapped, 8 = combination

NRINGTWTOPP
NUMBER

Number of rings that the twine top is hung from on port or aft deployed gear.

NRINGTWTOPS
NUMBER

Number of rings that the twine top is hung from on starboard deployed gear.

NROWAPRONP
NUMBER

Number of rings that the twine top is hung from on port or aft deployed gear.

NROWAPRONS
NUMBER

Number of rings that the twine top is hung from on starboard deployed gear.

SDGCOMMENTSS
VARCHAR2

Additional information regarding scallop starboard dredge haul.Prior to 2001 only true or false.

SDGCOMMENTSP
VARCHAR2

Additional information regarding scallop port dredge haul. Prior to 2001 only true or false.

FRAMETYPP
VARCHAR2

Type of dredge frame used on port dredge. See OBFRAMETYP table. Collected beginning with obdbs Version 10 (01/01/2011).

FRAMETYPS
VARCHAR2

Type of dredge frame used on starboard dredge. See OBFRAMETYP table. Collected beginning with obdbs Version 10 (01/01/2011).

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: OBSDG
Short Name:	OBSDG
Status:	Completed
Abstract:	Observer Scallop Dredge and Crab Dredge Gear Characteristics 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 Dredge and Crab Dredge Gear Characteristics from standard observer trips

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	DREDGESDEPLOYED	VARCHAR2	Code denoting where dredges are deployed. P = port, S = starboard, B = both, A=aft, U= Unknown. Not collected prior to 5/1994; set to unknown. Aft collected beginning 2005;
100	FRAMEHGTP	NUMBER	Overall height of port dredge frame in inches.
100	FRAMEHGTS	NUMBER	Overall height of starboard dredge frame in inches.
100	FRAMEWIDP	NUMBER	Width of the port dredge frame, in whole feet.
100	FRAMEWIDS	NUMBER	Width of the starboard dredge frame, in whole feet.
100	PPLATUSDP	VARCHAR2	Indicator of whether pressure plate used on port dredge. 0 = no, 1 = yes, 9 = unknown.
100	PPLATUSDS	VARCHAR2	Indicator of whether pressure plate used on starboard dredge. 0 = no, 1 = yes, 9 = unknown.
100	RCHNUSDP	VARCHAR2	Indicator of rock chains used on the port dredge. 0 = no, 1 = yes, 2=configured for turtle exclusion, 9 = unknown.
100	RCHNUSDS	VARCHAR2	Indicator of rock chains used on the starboard dredge. 0 = no, 1 = yes, 2=configured for turtle exclusion, 9 = unknown.
100	NRCHAINP	NUMBER	Number of rock chains on the port dredge. 0=unknown if rchnusdp = 1. 0=n/a if rchnusdp = 0.
100	NRCHAINS	NUMBER	Number of rock chains on the starboard dredge. 0=unknown if rchnusds = 1. 0=n/a if rchnusds = 0.
100	TCHNUSDP	VARCHAR2	Tickler chain used on port dredge. 0=no, 1=yes, 1= configured for turtle exclusion, 9=unknown. Not entered before 5/1994; set to unknown.
100	TCHNUSDS	VARCHAR2	Tickler chain used on starboard dredge. 0=no, 1= yes, 2 = configured for turtle exclusion, 9=unknown. Not entered before 5/1994; set to unknown.
100	NTCHAINP	NUMBER	Number of tickler chains on the port dredge.
100	NTCHAINS	NUMBER	Number of tickler chains on the starboard dredge.
100	CHNCONFIGP	VARCHAR2	Configuration f the port scallop dredge 1 = standard, 2 = turtle chain mat
100	CHNCONFIGS	VARCHAR2	Configuration f the scallop dredge starboard drecge1 = standard, 2 = turtle chain mat
100	MSTWTOPP	NUMBER	Mesh size twine top port dredge in millimeters. For Crab Dredge (negear 383) values represent codend mesh sizes for port dredge.
100	MSTWTOPS	NUMBER	Mesh size in the twine top of the starboard dredge in mIllimeters. For Crab Dredge (negear 383) values represent codend mesh sizes for starboard dredge.
100	CBCHAFFUSDP	VARCHAR2	Indicator of whether chaffing gear was used on the port chain bag. 0=no, 1=yes 9= unknown.
100	CBCHAFFUSDS	VARCHAR2	Indicator of whether chaffing gear was used on the starboard dredge chain bag. 0=no, 1=yes 9= unknown.
100	NLINKBTWP	NUMBER	Number of links between 2 rings on the port dredge.
100	NLINKBTWS	NUMBER	Number of links between 2 rings on the starboard dredge.
100	LINKSIZEP	NUMBER	Link stock size of steel used in links between the rings in the bottom of the chain bag on the port dredge.
100	LINKSIZES	NUMBER	Link stock size of steel used in links between the rings in the bottom of the chain bag on the starboard dredge.
100	RSITOBP	NUMBER	Inside measure of ring size top of bag port dredge in millimeters.
100	RSITOBS	NUMBER	Inside measure of ring size top of bag starboard dredge in milimeters.
100	RSIBOBP	NUMBER	Inside measure of ring size bottom of bag port dredge in millimeters.
100	RSIBOBS	NUMBER	Inside measure of ring size bottom of bag starboard dredge in millimeters.
100	RSOBOBP	NUMBER	Outside measure of ring size bottom of bag port dredge in millimeters.
100	RSOBOBS	NUMBER	Outside measure of ring size bottom of bag starboard dredge in millimeters.
100	MCTWTOPWIDP	NUMBER	Number of meshes for the width of the twine top (runs from one side of the dredge frame to the other) on the port or aft gear
100	MCTWTOPWIDS	NUMBER	Number of meshes for the width of the twine top (runs from one side of the dredge frame to the other) on the starboard gear
100	MCTWTOPLENP	NUMBER	Number of meshes for the length of the twine top (runs from frame to chain bag) on the port or aft gear
100	MCTWTOPLENS	NUMBER	Number of meshes for the length of the twine top (runs from frame to chain bag) on the starboard gear
100	TWTOPHUNGP	VARCHAR2	Hanging configuration of twine top port or aft gear..0= unknown, 1 = diamond, 2 = square, 3 square,/wrapped, 8 = combination
100	TWTOPHUNGS	VARCHAR2	Hanging configuration of twine top starboard gear..0= unknown, 1 = diamond, 2 = square, 3 square,/wrapped, 8 = combination
100	NRINGTWTOPP	NUMBER	Number of rings that the twine top is hung from on port or aft deployed gear.
100	NRINGTWTOPS	NUMBER	Number of rings that the twine top is hung from on starboard deployed gear.
100	NROWAPRONP	NUMBER	Number of rings that the twine top is hung from on port or aft deployed gear.
100	NROWAPRONS	NUMBER	Number of rings that the twine top is hung from on starboard deployed gear.
100	SDGCOMMENTSS	VARCHAR2	Additional information regarding scallop starboard dredge haul.Prior to 2001 only true or false.
100	SDGCOMMENTSP	VARCHAR2	Additional information regarding scallop port dredge haul. Prior to 2001 only true or false.
100	FRAMETYPP	VARCHAR2	Type of dredge frame used on port dredge. See OBFRAMETYP table. Collected beginning with obdbs Version 10 (01/01/2011).
100	FRAMETYPS	VARCHAR2	Type of dredge frame used on starboard dredge. See OBFRAMETYP table. Collected beginning with obdbs Version 10 (01/01/2011).

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

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

DREDGESDEPLOYED

VARCHAR2

Code denoting where dredges are deployed. P = port, S = starboard, B = both, A=aft, U= Unknown. Not collected prior to 5/1994; set to unknown. Aft collected beginning 2005;

100

FRAMEHGTP

NUMBER

Overall height of port dredge frame in inches.

100

FRAMEHGTS

NUMBER

Overall height of starboard dredge frame in inches.

100

FRAMEWIDP

NUMBER

Width of the port dredge frame, in whole feet.

100

FRAMEWIDS

NUMBER

Width of the starboard dredge frame, in whole feet.

100

PPLATUSDP

VARCHAR2

Indicator of whether pressure plate used on port dredge. 0 = no, 1 = yes, 9 = unknown.

100

PPLATUSDS

VARCHAR2

Indicator of whether pressure plate used on starboard dredge. 0 = no, 1 = yes, 9 = unknown.

100

RCHNUSDP

VARCHAR2

Indicator of rock chains used on the port dredge. 0 = no, 1 = yes, 2=configured for turtle exclusion, 9 = unknown.

100

RCHNUSDS

VARCHAR2

Indicator of rock chains used on the starboard dredge. 0 = no, 1 = yes, 2=configured for turtle exclusion, 9 = unknown.

100

NRCHAINP

NUMBER

Number of rock chains on the port dredge. 0=unknown if rchnusdp = 1. 0=n/a if rchnusdp = 0.

100

NRCHAINS

NUMBER

Number of rock chains on the starboard dredge. 0=unknown if rchnusds = 1. 0=n/a if rchnusds = 0.

100

TCHNUSDP

VARCHAR2

Tickler chain used on port dredge. 0=no, 1=yes, 1= configured for turtle exclusion, 9=unknown. Not entered before 5/1994; set to unknown.

100

TCHNUSDS

VARCHAR2

Tickler chain used on starboard dredge. 0=no, 1= yes, 2 = configured for turtle exclusion, 9=unknown. Not entered before 5/1994; set to unknown.

100

NTCHAINP

NUMBER

Number of tickler chains on the port dredge.

100

NTCHAINS

NUMBER

Number of tickler chains on the starboard dredge.

100

CHNCONFIGP

VARCHAR2

Configuration f the port scallop dredge 1 = standard, 2 = turtle chain mat

100

CHNCONFIGS

VARCHAR2

Configuration f the scallop dredge starboard drecge1 = standard, 2 = turtle chain mat

100

MSTWTOPP

NUMBER

Mesh size twine top port dredge in millimeters. For Crab Dredge (negear 383) values represent codend mesh sizes for port dredge.

100

MSTWTOPS

NUMBER

Mesh size in the twine top of the starboard dredge in mIllimeters. For Crab Dredge (negear 383) values represent codend mesh sizes for starboard dredge.

100

CBCHAFFUSDP

VARCHAR2

Indicator of whether chaffing gear was used on the port chain bag. 0=no, 1=yes 9= unknown.

100

CBCHAFFUSDS

VARCHAR2

Indicator of whether chaffing gear was used on the starboard dredge chain bag. 0=no, 1=yes 9= unknown.

100

NLINKBTWP

NUMBER

Number of links between 2 rings on the port dredge.

100

NLINKBTWS

NUMBER

Number of links between 2 rings on the starboard dredge.

100

LINKSIZEP

NUMBER

Link stock size of steel used in links between the rings in the bottom of the chain bag on the port dredge.

100

LINKSIZES

NUMBER

Link stock size of steel used in links between the rings in the bottom of the chain bag on the starboard dredge.

100

RSITOBP

NUMBER

Inside measure of ring size top of bag port dredge in millimeters.

100

RSITOBS

NUMBER

Inside measure of ring size top of bag starboard dredge in milimeters.

100

RSIBOBP

NUMBER

Inside measure of ring size bottom of bag port dredge in millimeters.

100

RSIBOBS

NUMBER

Inside measure of ring size bottom of bag starboard dredge in millimeters.

100

RSOBOBP

NUMBER

Outside measure of ring size bottom of bag port dredge in millimeters.

100

RSOBOBS

NUMBER

Outside measure of ring size bottom of bag starboard dredge in millimeters.

100

MCTWTOPWIDP

NUMBER

Number of meshes for the width of the twine top (runs from one side of the dredge frame to the other) on the port or aft gear

100

MCTWTOPWIDS

NUMBER

Number of meshes for the width of the twine top (runs from one side of the dredge frame to the other) on the starboard gear

100

MCTWTOPLENP

NUMBER

Number of meshes for the length of the twine top (runs from frame to chain bag) on the port or aft gear

100

MCTWTOPLENS

NUMBER

Number of meshes for the length of the twine top (runs from frame to chain bag) on the starboard gear

100

TWTOPHUNGP

VARCHAR2

Hanging configuration of twine top port or aft gear..0= unknown, 1 = diamond, 2 = square, 3 square,/wrapped, 8 = combination

100

TWTOPHUNGS

VARCHAR2

Hanging configuration of twine top starboard gear..0= unknown, 1 = diamond, 2 = square, 3 square,/wrapped, 8 = combination

100

NRINGTWTOPP

NUMBER

Number of rings that the twine top is hung from on port or aft deployed gear.

100

NRINGTWTOPS

NUMBER

Number of rings that the twine top is hung from on starboard deployed gear.

100

NROWAPRONP

NUMBER

Number of rings that the twine top is hung from on port or aft deployed gear.

100

NROWAPRONS

NUMBER

Number of rings that the twine top is hung from on starboard deployed gear.

100

SDGCOMMENTSS

VARCHAR2

Additional information regarding scallop starboard dredge haul.Prior to 2001 only true or false.

100

SDGCOMMENTSP

VARCHAR2

Additional information regarding scallop port dredge haul. Prior to 2001 only true or false.

100

FRAMETYPP

VARCHAR2

Type of dredge frame used on port dredge. See OBFRAMETYP table. Collected beginning with obdbs Version 10 (01/01/2011).

100

FRAMETYPS

VARCHAR2

Type of dredge frame used on starboard dredge. See OBFRAMETYP table. Collected beginning with obdbs Version 10 (01/01/2011).

Attribute Details

LINK4

CC ID: 330367

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: 330378

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: 330389

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: 330400

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: 330411

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: 330416

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: 330417

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	1
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: 330418

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

DREDGESDEPLOYED

CC ID: 330419

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code denoting where dredges are deployed. P = port, S = starboard, B = both, A=aft, U= Unknown. Not collected prior to 5/1994; set to unknown. Aft collected beginning 2005;
General Data Type:	VARCHAR2

FRAMEHGTP

CC ID: 330368

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Overall height of port dredge frame in inches.
General Data Type:	NUMBER

FRAMEHGTS

CC ID: 330369

Seq. Order:	11
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Overall height of starboard dredge frame in inches.
General Data Type:	NUMBER

FRAMEWIDP

CC ID: 330370

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Width of the port dredge frame, in whole feet.
General Data Type:	NUMBER

FRAMEWIDS

CC ID: 330371

Seq. Order:	13
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Width of the starboard dredge frame, in whole feet.
General Data Type:	NUMBER

PPLATUSDP

CC ID: 330372

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of whether pressure plate used on port dredge. 0 = no, 1 = yes, 9 = unknown.
General Data Type:	VARCHAR2

PPLATUSDS

CC ID: 330373

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of whether pressure plate used on starboard dredge. 0 = no, 1 = yes, 9 = unknown.
General Data Type:	VARCHAR2

RCHNUSDP

CC ID: 330374

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of rock chains used on the port dredge. 0 = no, 1 = yes, 2=configured for turtle exclusion, 9 = unknown.
General Data Type:	VARCHAR2

RCHNUSDS

CC ID: 330375

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of rock chains used on the starboard dredge. 0 = no, 1 = yes, 2=configured for turtle exclusion, 9 = unknown.
General Data Type:	VARCHAR2

NRCHAINP

CC ID: 330376

Seq. Order:	18
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Number of rock chains on the port dredge. 0=unknown if rchnusdp = 1. 0=n/a if rchnusdp = 0.
General Data Type:	NUMBER

NRCHAINS

CC ID: 330377

Seq. Order:	19
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Number of rock chains on the starboard dredge. 0=unknown if rchnusds = 1. 0=n/a if rchnusds = 0.
General Data Type:	NUMBER

TCHNUSDP

CC ID: 330379

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Tickler chain used on port dredge. 0=no, 1=yes, 1= configured for turtle exclusion, 9=unknown. Not entered before 5/1994; set to unknown.
General Data Type:	VARCHAR2

TCHNUSDS

CC ID: 330380

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Tickler chain used on starboard dredge. 0=no, 1= yes, 2 = configured for turtle exclusion, 9=unknown. Not entered before 5/1994; set to unknown.
General Data Type:	VARCHAR2

NTCHAINP

CC ID: 330381

Seq. Order:	22
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Number of tickler chains on the port dredge.
General Data Type:	NUMBER

NTCHAINS

CC ID: 330382

Seq. Order:	23
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Number of tickler chains on the starboard dredge.
General Data Type:	NUMBER

CHNCONFIGP

CC ID: 330383

Seq. Order:	24
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Configuration f the port scallop dredge 1 = standard, 2 = turtle chain mat
General Data Type:	VARCHAR2

CHNCONFIGS

CC ID: 330384

Seq. Order:	25
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Configuration f the scallop dredge starboard drecge1 = standard, 2 = turtle chain mat
General Data Type:	VARCHAR2

MSTWTOPP

CC ID: 330385

Seq. Order:	26
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Mesh size twine top port dredge in millimeters. For Crab Dredge (negear 383) values represent codend mesh sizes for port dredge.
General Data Type:	NUMBER

MSTWTOPS

CC ID: 330386

Seq. Order:	27
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Mesh size in the twine top of the starboard dredge in mIllimeters. For Crab Dredge (negear 383) values represent codend mesh sizes for starboard dredge.
General Data Type:	NUMBER

CBCHAFFUSDP

CC ID: 330387

Seq. Order:	28
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of whether chaffing gear was used on the port chain bag. 0=no, 1=yes 9= unknown.
General Data Type:	VARCHAR2

CBCHAFFUSDS

CC ID: 330388

Seq. Order:	29
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of whether chaffing gear was used on the starboard dredge chain bag. 0=no, 1=yes 9= unknown.
General Data Type:	VARCHAR2

NLINKBTWP

CC ID: 330390

Seq. Order:	30
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Number of links between 2 rings on the port dredge.
General Data Type:	NUMBER

NLINKBTWS

CC ID: 330391

Seq. Order:	31
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Number of links between 2 rings on the starboard dredge.
General Data Type:	NUMBER

LINKSIZEP

CC ID: 330392

Seq. Order:	32
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	2
Status:	Active
Description:	Link stock size of steel used in links between the rings in the bottom of the chain bag on the port dredge.
General Data Type:	NUMBER

LINKSIZES

CC ID: 330393

Seq. Order:	33
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	2
Status:	Active
Description:	Link stock size of steel used in links between the rings in the bottom of the chain bag on the starboard dredge.
General Data Type:	NUMBER

RSITOBP

CC ID: 330394

Seq. Order:	34
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Inside measure of ring size top of bag port dredge in millimeters.
General Data Type:	NUMBER

RSITOBS

CC ID: 330395

Seq. Order:	35
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Inside measure of ring size top of bag starboard dredge in milimeters.
General Data Type:	NUMBER

RSIBOBP

CC ID: 330396

Seq. Order:	36
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Inside measure of ring size bottom of bag port dredge in millimeters.
General Data Type:	NUMBER

RSIBOBS

CC ID: 330397

Seq. Order:	37
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Inside measure of ring size bottom of bag starboard dredge in millimeters.
General Data Type:	NUMBER

RSOBOBP

CC ID: 330398

Seq. Order:	38
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Outside measure of ring size bottom of bag port dredge in millimeters.
General Data Type:	NUMBER

RSOBOBS

CC ID: 330399

Seq. Order:	39
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Outside measure of ring size bottom of bag starboard dredge in millimeters.
General Data Type:	NUMBER

MCTWTOPWIDP

CC ID: 330401

Seq. Order:	40
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Number of meshes for the width of the twine top (runs from one side of the dredge frame to the other) on the port or aft gear
General Data Type:	NUMBER

MCTWTOPWIDS

CC ID: 330402

Seq. Order:	41
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Number of meshes for the width of the twine top (runs from one side of the dredge frame to the other) on the starboard gear
General Data Type:	NUMBER

MCTWTOPLENP

CC ID: 330403

Seq. Order:	42
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Number of meshes for the length of the twine top (runs from frame to chain bag) on the port or aft gear
General Data Type:	NUMBER

MCTWTOPLENS

CC ID: 330404

Seq. Order:	43
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Number of meshes for the length of the twine top (runs from frame to chain bag) on the starboard gear
General Data Type:	NUMBER

TWTOPHUNGP

CC ID: 330405

Seq. Order:	44
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Hanging configuration of twine top port or aft gear..0= unknown, 1 = diamond, 2 = square, 3 square,/wrapped, 8 = combination
General Data Type:	VARCHAR2

TWTOPHUNGS

CC ID: 330406

Seq. Order:	45
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Hanging configuration of twine top starboard gear..0= unknown, 1 = diamond, 2 = square, 3 square,/wrapped, 8 = combination
General Data Type:	VARCHAR2

NRINGTWTOPP

CC ID: 330407

Seq. Order:	46
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Number of rings that the twine top is hung from on port or aft deployed gear.
General Data Type:	NUMBER

NRINGTWTOPS

CC ID: 330408

Seq. Order:	47
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Number of rings that the twine top is hung from on starboard deployed gear.
General Data Type:	NUMBER

NROWAPRONP

CC ID: 330409

Seq. Order:	48
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Number of rings that the twine top is hung from on port or aft deployed gear.
General Data Type:	NUMBER

NROWAPRONS

CC ID: 330410

Seq. Order:	49
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Number of rings that the twine top is hung from on starboard deployed gear.
General Data Type:	NUMBER

SDGCOMMENTSS

CC ID: 330412

Seq. Order:	50
Data Storage Type:	VARCHAR2
Max Length:	250
Required:	No
Primary Key:	No
Status:	Active
Description:	Additional information regarding scallop starboard dredge haul.Prior to 2001 only true or false.
General Data Type:	VARCHAR2

SDGCOMMENTSP

CC ID: 330413

Seq. Order:	51
Data Storage Type:	VARCHAR2
Max Length:	250
Required:	No
Primary Key:	No
Status:	Active
Description:	Additional information regarding scallop port dredge haul. Prior to 2001 only true or false.
General Data Type:	VARCHAR2

FRAMETYPP

CC ID: 330414

Seq. Order:	52
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Type of dredge frame used on port dredge. See OBFRAMETYP table. Collected beginning with obdbs Version 10 (01/01/2011).
General Data Type:	VARCHAR2

FRAMETYPS

CC ID: 330415

Seq. Order:	53
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Type of dredge frame used on starboard dredge. See OBFRAMETYP table. Collected beginning with obdbs Version 10 (01/01/2011).
General Data Type:	VARCHAR2

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

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

LINK4

LINK1

PROGRAM

YEAR

MONTH

TRIPID

GEARNUM

NEGEAR

DREDGESDEPLOYED

FRAMEHGTP

FRAMEHGTS

FRAMEWIDP

FRAMEWIDS

PPLATUSDP

PPLATUSDS

RCHNUSDP

RCHNUSDS

NRCHAINP

NRCHAINS

TCHNUSDP

TCHNUSDS

NTCHAINP

NTCHAINS

CHNCONFIGP

CHNCONFIGS

MSTWTOPP

MSTWTOPS

CBCHAFFUSDP

CBCHAFFUSDS

NLINKBTWP

NLINKBTWS

LINKSIZEP

LINKSIZES

RSITOBP

RSITOBS

RSIBOBP

RSIBOBS

RSOBOBP

RSOBOBS

MCTWTOPWIDP

MCTWTOPWIDS

MCTWTOPLENP

MCTWTOPLENS

TWTOPHUNGP

TWTOPHUNGS

NRINGTWTOPP

NRINGTWTOPS

NROWAPRONP

NROWAPRONS

SDGCOMMENTSS

SDGCOMMENTSP

FRAMETYPP

FRAMETYPS

Catalog Details