33318 OBSTH Entity Published / External 24111 Observer and At Sea Monitor Database (OBDBS) Data Set Completed Observer Scallop Trawl Hauls from standard observer trips Loaded by batch 8949, 07-06-2016 08:23 Data View Yes OBDBS Observer Scallop Trawl Hauls from standard observer trips 1 LINK3 VARCHAR2 19 No No Active Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. Collected for ASM where applicable. VARCHAR2 2 LINK4 VARCHAR2 17 No No Active Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable. VARCHAR2 3 LINK1 VARCHAR2 15 No No 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 4 PROGRAM VARCHAR2 3 No No Active First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable. VARCHAR2 5 YEAR VARCHAR2 4 No No Active Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable. VARCHAR2 6 MONTH VARCHAR2 2 No No Active Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable. VARCHAR2 7 TRIPID VARCHAR2 6 No No 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 8 HAULNUM VARCHAR2 4 No No Active Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable. VARCHAR2 9 GEARNUM VARCHAR2 2 No No Active Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable. VARCHAR2 10 NETOBS VARCHAR2 1 No No Active 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. VARCHAR2 11 TOWSPEED NUMBER 22 No No 3 1 Active Average towing speed over bottom, to nearest 10th of knot. NUMBER 12 WIREOUT NUMBER 22 No No 4 0 Active Amount of wire paid out for haul, in whole fathoms. NUMBER 13 CLAPOBS VARCHAR2 1 No No Active Indicator of whether sea scallop clappers were found in gear for haul. 0 = no, 1 = yes, 9 = unknown. VARCHAR2 14 NBUSHKEP NUMBER 22 No No 5 2 Active Amount of scallops, in the shell, kept from haul, to nearest hundredth of a bushel. Not entered prior to 5/1994; set to unknown. NUMBER 15 NBUSHDIS NUMBER 22 No No 5 2 Active Amount of scallops, in the shell, discarded from haul, to nearest hundredth of a bushel. Not collected prior to 5/1994; set to unknown. NUMBER 16 AVLBBUSHKEP NUMBER 22 No No 4 1 Active 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. NUMBER 17 AVLBBUSHDIS NUMBER 22 No No 4 1 Active Average pounds per bushel of scallops, in shell, discarded from haul. Not collected prior to 5/1994; set to unknown. NUMBER 18 DRKEPFLAG VARCHAR2 1 No No Active Indicator of whether the avlbbushkept is for dressed/shucked (1) or round (2) scallops 0 = unknown VARCHAR2 19 DRDISFLAG VARCHAR2 1 No No Active Indicator of whether the avlbbushdis is for dressed/shucked (1) or round (2) scallops 0 = unknown VARCHAR2 20 NTURNS NUMBER 22 No No 2 0 Active Number of turns > 90 degrees in haul; begun 3/2007 NUMBER 21 NETOVERT NUMBER 22 No No 4 0 Active Average distance from the top to bottom of mouth of net while fishing; whole feet; begun 3/2007 NUMBER 22 NETOHORIZ NUMBER 22 No No 4 0 Active Average width of netmouth wing tip -> wing tip while fishing; whole feet; begun 3/2007 NUMBER 23 DOORSPREAD NUMBER 22 No No 4 0 Active Average distance between the doors while fishing; whole feet; begun 3/2007 NUMBER 24 STHCOMMENTS VARCHAR2 250 No No Active Comments on Scallop trawl haul VARCHAR2 gov.noaa.nmfs.inport:33318 Patricia Jones 2016-07-06T08:23:45 SysAdmin InPortAdmin 2022-08-09T17:11:12 2016-07-28 Northeast Fisheries Science Center NEFSC 166 Water Street Woods Hole MA 02543-1026 USA (508)495-2000 https://www.nefsc.noaa.gov 8:00 a.m. to 4:30 p.m. Monday - Friday 1001 Public No 2016-07-28 1 Year 2017-07-28