33569 OBPRG Entity Published / External 24111 Observer and At Sea Monitor Database (OBDBS) Data Set Completed Observer Pair Trawl Gear Characteristics Loaded by batch 9053, 07-27-2016 19:10 Data View Yes OBDBS Observer Pair 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 NETCODE VARCHAR2 2 No No Active Code that identifies net. See OBNET table. VARCHAR2 15 YRNETMAD VARCHAR2 4 No No Active Four digit year net was made. VARCHAR2 16 GRFSHTYP VARCHAR2 1 No No Active Code for how gear is fished. VARCHAR2 17 NETCONS VARCHAR2 1 No No Active Type of net construction in forward section of net. VARCHAR2 18 NETDESGN VARCHAR2 1 No No Active Code for constuction design of net. VARCHAR2 19 MSMIN NUMBER 22 No No 4 1 Active Minimum mesh size of net, to nearest hundredth of an inch. Collected for ASM where applicable. NUMBER 20 MSMAX NUMBER 22 No No 5 1 Active Maximum mesh size of net, to nearest hundredth of an inch. Collected for ASM where applicable. NUMBER 21 WGTSUSD VARCHAR2 1 No No Active Were weights used? 0=no; 1=yes; 9=unknown. VARCHAR2 22 WGTSLBS NUMBER 22 No No 5 0 Active Total poundage of all weights used on gear, in whole lbs. NUMBER 23 WGTTYPE VARCHAR2 1 No No Active One digit code denoting type of weight of species. 1=actual; 2=estimated; 0=unknown. SPP: prior to 5/1994 data recorded but not entered; set to unknown. Collected for ASM where applicable. VARCHAR2 24 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 25 CODMAT VARCHAR2 2 No No Active Type of construction material used in codend only. See OBNETMAT table. VARCHAR2 26 FLOATUSD VARCHAR2 1 No No Active Indicator of whether floats were used on gear. 0=no, 1=yes 9= unknown. VARCHAR2 27 BLOUTUSD VARCHAR2 1 No No Active Indicator of whether blowout section is used. VARCHAR2 28 KITPNUSD VARCHAR2 1 No No Active Indicator of whether kite panel used.| added to OTG 1-08 VARCHAR2 29 NKITPN NUMBER 22 No No 2 0 Active Total number of panels used in kite in net.| added 1-08 NUMBER 30 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 31 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 32 HDROPLEN NUMBER 22 No No 4 0 Active Length of the head rope, in feet. NUMBER 33 FTROPLEN NUMBER 22 No No 4 0 Active Length of rope along bottom of net, in whole feet. NUMBER 34 BRDTPLEN NUMBER 22 No No 3 0 Active Length of top bridle, in whole fathoms. NUMBER 35 WBRDLEN NUMBER 22 No No 3 0 Active Length of wing bridle, in whole fathoms. NUMBER 36 BBRDLEN NUMBER 22 No No 3 0 Active Length of bottom bridle, in whole fathoms. NUMBER 37 NBRDWARP NUMBER 22 No No 2 0 Active Number of bridles attached to each warp. NUMBER 38 NBRDSIDE NUMBER 22 No No 1 0 Active Number of wings or bridles found on ONE side(left or right) of net. NUMBER 39 NWARPBOT NUMBER 22 No No 1 0 Active Number of warps fished by each boat. NUMBER 40 CIRCLEMC NUMBER 22 No No 4 0 Active Number of meshes in fishing circle.Not collected prior to 5/1994; set to unknown NUMBER 41 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 42 NFLOATS NUMBER 22 No No 3 0 Active Number of floats on gear. NUMBER 43 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 44 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 45 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 46 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 47 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 48 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 49 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 50 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 51 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 52 NTRANS NUMBER 22 No No 2 0 Active Number of transducers used on gear. Not collected before 5/1994; set to unknown. NUMBER 53 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 54 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 55 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 56 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 57 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 58 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 59 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 60 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 61 TEDEXTMS NUMBER 22 No No 4 1 Active Turtle exclusion device extension mesh size in tenths of inches (begun 3/2007) NUMBER 62 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 63 ESCAPOUTLEN NUMBER 22 No No 3 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 64 ESCAPOUTWID NUMBER 22 No No 3 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 65 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 66 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 67 ESCAPOUTMS NUMBER 22 No No 3 0 Active Mesh size of the escape outlet in whole inches. NUMBER 68 ESCAPOUTLENMC NUMBER 22 No No 3 0 Active Number of meshes in length of the escape outlet (front -> codend) NUMBER 69 ESCAPOUTWIDMC NUMBER 22 No No 3 0 Active Number of meshes in width of the escape outlet (side -> side) NUMBER 70 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 71 PRGCOMMENTS VARCHAR2 250 No No Active Additional information re: PaiR trawl Gear. VARCHAR2 gov.noaa.nmfs.inport:33569 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