View: OBSDG

33312

View: OBSDG

OBSDG

Entity

Published / External

24111

Observer and At Sea Monitor Database (OBDBS)

Data Set

Completed Observer Scallop Dredge and Crab Dredge Gear Characteristics from standard observer trips Loaded by batch 8949, 07-06-2016 08:23

Data View

Yes

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

LINK4

VARCHAR2

Active Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable.

VARCHAR2

LINK1

VARCHAR2

Active 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.

VARCHAR2

PROGRAM

VARCHAR2

Active First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.

VARCHAR2

YEAR

VARCHAR2

Active Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.

VARCHAR2

MONTH

VARCHAR2

Active Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.

VARCHAR2

TRIPID

VARCHAR2

Active 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.

VARCHAR2

GEARNUM

VARCHAR2

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

VARCHAR2

NEGEAR

VARCHAR2

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

VARCHAR2

DREDGESDEPLOYED

VARCHAR2

Active 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;

VARCHAR2

FRAMEHGTP

NUMBER

2 0 Active Overall height of port dredge frame in inches.

NUMBER

FRAMEHGTS

NUMBER

2 0 Active Overall height of starboard dredge frame in inches.

NUMBER

FRAMEWIDP

NUMBER

3 0 Active Width of the port dredge frame, in whole feet.

NUMBER

FRAMEWIDS

NUMBER

3 0 Active Width of the starboard dredge frame, in whole feet.

NUMBER

PPLATUSDP

VARCHAR2

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

VARCHAR2

PPLATUSDS

VARCHAR2

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

VARCHAR2

RCHNUSDP

VARCHAR2

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

VARCHAR2

RCHNUSDS

VARCHAR2

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

VARCHAR2

NRCHAINP

NUMBER

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

NUMBER

NRCHAINS

NUMBER

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

NUMBER

TCHNUSDP

VARCHAR2

Active 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.

VARCHAR2

TCHNUSDS

VARCHAR2

Active 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.

VARCHAR2

NTCHAINP

NUMBER

2 0 Active Number of tickler chains on the port dredge.

NUMBER

NTCHAINS

NUMBER

2 0 Active Number of tickler chains on the starboard dredge.

NUMBER

CHNCONFIGP

VARCHAR2

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

VARCHAR2

CHNCONFIGS

VARCHAR2

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

VARCHAR2

MSTWTOPP

NUMBER

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

NUMBER

MSTWTOPS

NUMBER

3 0 Active 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.

NUMBER

CBCHAFFUSDP

VARCHAR2

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

VARCHAR2

CBCHAFFUSDS

VARCHAR2

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

VARCHAR2

NLINKBTWP

NUMBER

2 0 Active Number of links between 2 rings on the port dredge.

NUMBER

NLINKBTWS

NUMBER

2 0 Active Number of links between 2 rings on the starboard dredge.

NUMBER

LINKSIZEP

NUMBER

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

NUMBER

LINKSIZES

NUMBER

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

NUMBER

RSITOBP

NUMBER

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

NUMBER

RSITOBS

NUMBER

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

NUMBER

RSIBOBP

NUMBER

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

NUMBER

RSIBOBS

NUMBER

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

NUMBER

RSOBOBP

NUMBER

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

NUMBER

RSOBOBS

NUMBER

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

NUMBER

MCTWTOPWIDP

NUMBER

3 0 Active 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

NUMBER

MCTWTOPWIDS

NUMBER

3 0 Active 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

NUMBER

MCTWTOPLENP

NUMBER

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

NUMBER

MCTWTOPLENS

NUMBER

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

NUMBER

TWTOPHUNGP

VARCHAR2

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

VARCHAR2

TWTOPHUNGS

VARCHAR2

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

VARCHAR2

NRINGTWTOPP

NUMBER

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

NUMBER

NRINGTWTOPS

NUMBER

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

NUMBER

NROWAPRONP

NUMBER

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

NUMBER

NROWAPRONS

NUMBER

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

NUMBER

SDGCOMMENTSS

VARCHAR2

250

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

VARCHAR2

SDGCOMMENTSP

VARCHAR2

250

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

VARCHAR2

FRAMETYPP

VARCHAR2

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

VARCHAR2

FRAMETYPS

VARCHAR2

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

VARCHAR2

gov.noaa.nmfs.inport:33312

Patricia Jones

2016-07-06T08:23:43

SysAdmin InPortAdmin

2022-08-09T17:11:12

2016-07-28

Northeast Fisheries Science Center

NEFSC

166 Water Street

Woods Hole

02543-1026

USA

(508)495-2000

https://www.nefsc.noaa.gov

8:00 a.m. to 4:30 p.m. Monday - Friday

1001

Public

2016-07-28

1 Year

2017-07-28