33568 OBOTG Entity Published / External 24111 Observer and At Sea Monitor Database (OBDBS) Data Set Completed Observer Otter Trawl Gear Characteristics Loaded by batch 9053, 07-27-2016 19:10 Data View Yes OBDBS Observer Otter Trawl Gear Characteristics 1 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 2 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 3 PROGRAM VARCHAR2 3 No No Active First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable. VARCHAR2 4 YEAR VARCHAR2 4 No No Active Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable. VARCHAR2 5 MONTH VARCHAR2 2 No No Active Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable. VARCHAR2 6 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 7 GEARNUM VARCHAR2 2 No No Active Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable. VARCHAR2 8 NEGEAR VARCHAR2 3 No No Active Northeast gear code. See OBGEAR table. Collected for ASM where applicable. VARCHAR2 9 DOORUSD VARCHAR2 1 No No Active Indicator of whether door was used on gear. 0=no, 1=yes, 9 = unknown. VARCHAR2 10 DOORWGT NUMBER 22 No No 4 0 Active Weight of one door on on net in whole kilograms. Null if not used or unknown. NUMBER 11 NETNAME VARCHAR2 2 No No Active Coded identifier for name of trawl net; see OBNETNAME table(collected for prg before 2007; otg beginning 03/2007). Collected for ASM where applicable. VARCHAR2 12 NETTYPE VARCHAR2 2 No No Active Coded identifier for type of trawl net See OBNETTYPE table.(collected for prg before 2007; otg beginning 03/2007). Collected for ASM where applicable. VARCHAR2 13 NETBUILDER VARCHAR2 2 No No Active Coded identifier for builder net See OBNETBUILDER table.(collected for prg before 2007; otg beginning 03/2007) VARCHAR2 14 NETMAT VARCHAR2 2 No No Active Type of construction material used in body of net, not including codend. See OBNETMAT table. Removed with obdbs Version 10. VARCHAR2 15 CODMAT VARCHAR2 2 No No Active Type of construction material used in codend only. See OBNETMAT table. VARCHAR2 16 HDROPLEN NUMBER 22 No No 3 0 Active Length of the head rope, in feet. NUMBER 17 FTROPLEN NUMBER 22 No No 3 0 Active Length of rope along bottom of net, in whole feet. NUMBER 18 GRCABLEN NUMBER 22 No No 4 0 Active Length of wire connecting the bridles and back strap, in fathoms (previous to 5/2007 was in feet) NUMBER 19 CIRCLEMC NUMBER 22 No No 4 0 Active Number of meshes in fishing circle.Not collected prior to 5/1994; set to unknown NUMBER 20 CIRCLEMS NUMBER 22 No No 5 1 Active Inside mesh measurement from fishing circle; cm in PR gear; nearest 1/10 inch in OT.Not entered prior to 5/1994; set to unknown. NUMBER 21 GRCABTYP VARCHAR2 2 No No Active Gear type on ground cable 0=unknown, 1=chain, 2=cable/wire,3= wrapped cable, 4=rock hopper, 5=roller, 6=rubber cookie, 7=bobbin, 8=none, 9=other VARCHAR2 22 BRDLGTYP VARCHAR2 2 No No Active Gear type making up the bridles/legs 0=unknown, 1=chain, 2=cable/wire VARCHAR2 23 BRDTPLEN NUMBER 22 No No 3 0 Active Length of top bridle, in whole fathoms. NUMBER 24 FTROPTYP VARCHAR2 2 No No Active Foot rope / sweep type; see OBGRNDGEAR table. VARCHAR2 25 NSWEEPS NUMBER 22 No No 4 0 Active Total number of the largest piecce of gear present on the sweep/footrope (rollers, rock hoppers). Null if sweep is chain or cable/wire or NUMBER 26 SWEEPDIA NUMBER 22 No No 2 0 Active The diameter in whole inches of the largest piece of gear present on the sweep/footrope; null if sweep is chain or cable/wire or wrapped / NUMBER 27 NFLOATS NUMBER 22 No No 3 0 Active Number of floats on gear. NUMBER 28 FLOATDIA NUMBER 22 No No 2 0 Active Diameter in whole inches of majority of floats attached to the headrope.Not collected prior to 2001; set to unknown. NUMBER 29 CODHUNG VARCHAR2 1 No No Active Hanging configuration of codend..0= unknown, 1 = diamond, 2 = square, 3 square,/wrapped, 8 = combination. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable. VARCHAR2 30 CODTWINETYP VARCHAR2 1 No No Active single or double twine used in codend. 1 = single, 2 = double, 3 = single on top , double on bottom 9= other, 0=unknown; not collected before 5/1994; set to unknown. Collected for ASM where applicable. VARCHAR2 31 CODMSIZE NUMBER 22 No No 3 0 Active Truncated average of ten randomly selected inside mesh whole millimeter measurements. Collected for ASM where applicable. NUMBER 32 CODLINERUSD VARCHAR2 1 No No Active Indicator of whether liner is used in net's codend. Presence of liner data began in 1989 with the start of the data collection time series. 0 = no, 1 = yes, and 9 = unknown. Collected for ASM where applicable. VARCHAR2 33 LINERMSIZE NUMBER 22 No No 3 0 Active Truncated average of ten randomly selected inside liner whole millimeter measurements. In obdbs Version 10, this column replaces CODLINERAVMS, datatype changed to NUMBER. Prior to 2007, LINERMSIZE is not an average estimate, but rather one codend liner mesh size (CODLINERMS1 formerly CODMSLINER), as the additional 3 measurements were not collected until 2007.Collected for ASM where applicable. NUMBER 34 CODSTRENUSD VARCHAR2 1 No No Active Indicator of whether strengthener material is used in codend of net. Not collected before 5/1994; set to unknown. VARCHAR2 35 CODCHAFFUSD VARCHAR2 1 No No Active Chaffing gear used on codend. 0 = no, 1= yes, 9 = unknown. Not collected prior to 5/1994; set to unknown. VARCHAR2 36 GMELECTSUSD VARCHAR2 1 No No Active Whether transducers were used on trawl gear. 0=no, 1 = yes, 9 = unknown. Not collected before 5/1994; set to unknown. VARCHAR2 37 NTRANS NUMBER 22 No No 2 0 Active Number of transducers used on gear. Not collected before 5/1994; set to unknown. NUMBER 38 TRANSTYP VARCHAR2 1 No No Active Type of transducers used. 0 = unknown, 1 = wired, 2 = wireless , 3 = Both(if transducers not used = 0). Not collected before 5/1994; set to unknown. VARCHAR2 39 TRANSBRD VARCHAR2 1 No No Active Code for brand of transducers used:. 0 = unknown, 1 = Furuno, 2 = Simrad 9 = other (if transducers not used = 0). Not collected before 5/1994; set to unknown. VARCHAR2 40 TRANSLOCSTR VARCHAR2 20 No No Active Location of transducers used on gear, comma separated string of values. Renamed from TRANSLOC with OBDBS Version 10. See OBTRANSLOC table. VARCHAR2 41 EXCLUSD VARCHAR2 1 No No Active Indicator of whether excluder or separator device is used on gear.0=no, 1=yes, 9=unknown. Not collected before 5/1994; set to unknown. Collected for ASM where applicable. VARCHAR2 42 EXCLTYP VARCHAR2 2 No No Active Type of excluder or separator device used on gear. 0=unknown, 1 = nordmore grate, 2 = T.E.D., 3 = separtor panel, 4 = guiding device, 8 = combo, 9 = other. Not collected before 5/1994; set to unknown. VARCHAR2 43 TEDEXTMS NUMBER 22 No No 2 1 Active Turtle exclusion device extension mesh size in tenths of inches (begun 3/2007) NUMBER 44 ESCAPOUTUSD VARCHAR2 1 No No Active Indicator of whether fish outlet was used on gear. 0 = no, 1 = yes, 9 = unknown. Not entered prior to 5/1994;set to unknown. FSOUTUSD before 3/2007 VARCHAR2 45 ESCAPOUTLEN NUMBER 22 No No 4 0 Active Length of fish outlet from front to back of net, in whole inches. Not collected before 5/1994; set to unknown. Previous 3/2007: fsoutlen NUMBER 46 ESCAPOUTWID NUMBER 22 No No 4 0 Active Width of fish outlet, from side to side of net, in whole inches. Not collected prior to 5/1994; set to unknown. Pre 2/2007: fsoutwid NUMBER 47 ESCAPOUTSHP VARCHAR2 2 No No Active Shape of escape outlet used on gear. 00 = unknown, 01 = rectangle, 06 = square , 07 = diamond, 08 = diamond, 99 = other. Not entered prior to 5/1994; set to unknown.fsoutshp prior 3/2007 VARCHAR2 48 ESCAPOUTLOC VARCHAR2 1 No No Active Location of escape outlet on gear. 0 = unknown, 1 = top, 2 = bottom, 3 = side, 8 = combo, 9 = other. Not entered before 5/1994; set to unknown.FSOUTLOC PRIOR 3/2007 VARCHAR2 49 ESCAPOUTMS NUMBER 22 No No 4 0 Active Mesh size of the escape outlet in whole inches. NUMBER 50 ESCAPOUTLENMC NUMBER 22 No No 3 0 Active Number of meshes in length of the escape outlet (front -> codend) NUMBER 51 ESCAPOUTWIDMC NUMBER 22 No No 3 0 Active Number of meshes in width of the escape outlet (side -> side) NUMBER 52 ESCAPOUTTYP VARCHAR2 1 No No Active Type of escape outlet: 0 = Unknown, 1 = Panel, 2 = Opening, 3 = Single Flap, 4 = Double Flap, 9 = Other VARCHAR2 53 KITPNUSD VARCHAR2 1 No No Active Indicator of whether kite panel used.| added to OTG 1-08 VARCHAR2 54 NKITPN NUMBER 22 No No 2 0 Active Total number of panels used in kite in net.| added 1-08 NUMBER 55 KITPNWID NUMBER 22 No No 2 0 Active Average width of panels used in kite in net, in whole inches.| added to OTG 1-08 NUMBER 56 KITPNLEN NUMBER 22 No No 3 0 Active Average length of panels used in kite in net, in whole inches. | added to OTG 1-08 NUMBER 57 OTGCOMMENTS VARCHAR2 250 No No Active Comments on trawl gear record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable. VARCHAR2 58 LINERMAT VARCHAR2 2 No No Active Type of construction material used in liner. See OBNETMAT table. Collected beginning with obdbs Version 10 (01/01/2011). VARCHAR2 59 LINERHUNG VARCHAR2 1 No No Active Hanging configuration of liner. See OBTWTHUNG table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable. VARCHAR2 60 LINERTWTYP VARCHAR2 1 No No Active Single or double twine used in liner. See OBLINTYP table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable. VARCHAR2 61 TEDEXTMSTYP VARCHAR2 1 No No Active Indicator if the number recorded in T.E.D. EXTENSION MESH SIZE is an actual or estimated value A = actual, E = estimated Collected beginning with obdbs Version 10 (01/01/2011). VARCHAR2 gov.noaa.nmfs.inport:33568 Patricia Jones 2016-07-27T19:10:30 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