33279 ASMOTH Entity Published / External 24111 Observer and At Sea Monitor Database (OBDBS) Data Set Completed At Sea Monitor Otter Trawl Hauls Loaded by batch 8948, 07-06-2016 08:22 Data View Yes OBDBS At Sea Monitor Otter Trawl Hauls 1 LINK3 VARCHAR2 19 Yes 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 Yes No Active Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable. VARCHAR2 10 TOWSPEED NUMBER 22 No No 3 1 Active Average towing speed over bottom, to nearest 10th of knot. NUMBER 11 WIREOUT NUMBER 22 No No 4 0 Active Amount of wire paid out for haul, in whole fathoms. NUMBER 12 NTURNS NUMBER 22 No No 2 0 Active Number of turns > 90 degrees in haul; begun 3/2007 NUMBER 13 NETOVERT NUMBER 22 No No 3 0 Active Average distance from the top to bottom of mouth of net while fishing; whole feet; begun 3/2007 NUMBER 14 NETOHORIZ NUMBER 22 No No 3 0 Active Average width of netmouth wing tip -> wing tip while fishing; whole feet; begun 3/2007 NUMBER 15 DOORSPREAD NUMBER 22 No No 3 0 Active Average distance between the doors while fishing; whole feet; begun 3/2007 NUMBER 16 PUMPBEGINDATE DATE 7 No No Active Day,month,year in local time that fish pumping is attached to codend and initially turned on DATE 17 PUMPENDDATE DATE 7 No No Active Day,month,year in local time that fish pump is turned off and fish are no longer coming out of the dewatering box. DATE 18 OTHCOMMENTS VARCHAR2 250 No No Active Comments on trawl haul record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable. VARCHAR2 19 ASMTEST_STATUS VARCHAR2 6 No No Active Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested VARCHAR2 gov.noaa.nmfs.inport:33279 Patricia Jones 2016-07-06T08:22:55 SysAdmin InPortAdmin 2022-08-09T17:11:11 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