33578 OBTTG Entity Published / External 24111 Observer and At Sea Monitor Database (OBDBS) Data Set Completed Observer Twin Trawl Gear Characteristics Loaded by batch 9053, 07-27-2016 19:10 Data View Yes OBDBS Observer Twin 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 DEPLOYED VARCHAR2 1 No No Active Position where gear deployed: port, starboard, both or aft VARCHAR2 9 NETSCON VARCHAR2 1 No No Active If nets connected where two nets deployed on scallop or twin trawl; 1 = yes, 0 = no Collected for ASM where applicable. VARCHAR2 10 NETNAMEP VARCHAR2 2 No No Active Coded identifier for name of port or aft deployed net; see OBNETNAME table(collected for prg before 2007; otg beginning 03/2007) Collected for ASM where applicable. VARCHAR2 11 NETNAMES VARCHAR2 2 No No Active Coded identifier for name of starboard deployed net; see OBNETNAME table(collected for prg before 2007; otg beginning 03/2007) Collected for ASM where applicable. VARCHAR2 12 NETTYPEP VARCHAR2 2 No No Active Coded identifier for type of port or aft deployed trawl net See OBNETTYPE table.(collected for prg before 2007; otg beginning 03/2007) Collected for ASM where applicable. VARCHAR2 13 NETTYPES VARCHAR2 2 No No Active Coded identifier for type of starboard deployed trawl net See OBNETTYPE table.(collected for prg before 2007; otg beginning 03/2007) Collected for ASM where applicable. VARCHAR2 14 NETBUILDERP VARCHAR2 2 No No Active Coded identifier for builder net for port or aft gear See OBNETBUILDER table.(collected stg beginning 01/2008) VARCHAR2 15 NETBUILDERS VARCHAR2 2 No No Active Coded identifier for builder net for starboard gear See OBNETBUILDER table.(stg beginning 01/2008) VARCHAR2 16 DOORUSDP VARCHAR2 1 No No Active Door used on port net 0=no, 1=yes, 9 = unknown. VARCHAR2 17 DOORUSDS VARCHAR2 1 No No Active Door used on starboard net: 0=no, 1=yes, 9 = unknown. VARCHAR2 18 DOORWGTP NUMBER 22 No No 4 0 Active Weight of one door used on port net in whole kilograms. null if unknown or not used NUMBER 19 DOORWGTS NUMBER 22 No No 4 0 Active Weight of one door used on starboard net in whole kilograms. Null if unknown or not used NUMBER 20 NEGEAR VARCHAR2 3 No No Active Northeast gear code. See OBGEAR table. Collected for ASM where applicable. VARCHAR2 21 NETMATP VARCHAR2 2 No No Active Material used in body of port side scallop net not including codend. See OBNETMAT table. VARCHAR2 22 NETMATS VARCHAR2 2 No No Active Material used in body of starboard side scallp net not including codend. See OBNETMAT table. VARCHAR2 23 CODMATP VARCHAR2 2 No No Active Type of construction material used in codend port side. See OBNETMAT table. VARCHAR2 24 CODMATS VARCHAR2 2 No No Active Type of construction material used in codend starboard side. See OBNETMAT table. VARCHAR2 25 BRDTPLENP NUMBER 22 No No 3 0 Active Length of top bridle, in whole fathoms, port or aft deployed NUMBER 26 BRDTPLENS NUMBER 22 No No 3 0 Active Length of top bridle, in whole fathoms, starboard deployed NUMBER 27 HDROPLENP NUMBER 22 No No 3 0 Active Length of head rope on port net, in feet NUMBER 28 HDROPLENS NUMBER 22 No No 3 0 Active Length of head rope on starboard net, in feet NUMBER 29 FTROPLENP NUMBER 22 No No 3 0 Active Length of rope along bottom of port net in whole feet. NUMBER 30 FTROPLENS NUMBER 22 No No 3 0 Active Length of rope along bottom of starboard net in whole feet. NUMBER 31 GRCABLENP NUMBER 22 No No 4 0 Active Length of wire connecting the bridles and back strap on port net in whole feet. NUMBER 32 GRCABLENS NUMBER 22 No No 4 0 Active Length of wire connecting the bridles and back strap on starboard net in whole feet. NUMBER 33 CIRCLEMCP NUMBER 22 No No 4 0 Active Number of meshes in fishing circle on port net. NUMBER 34 CIRCLEMCS NUMBER 22 No No 4 0 Active Number of meshes in fishing circle on starboard net. NUMBER 35 CIRCLEMSP NUMBER 22 No No 5 1 Active Inside mesh measurement from port net fishing circle; nearest 1/10 inch. NUMBER 36 CIRCLEMSS NUMBER 22 No No 5 1 Active Inside mesh measurement from starboard net fishing circle; nearest 1/10. NUMBER 37 GRCABTYPP VARCHAR2 2 No No Active Gear type on port 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 38 GRCABTYPS VARCHAR2 2 No No Active Gear type on starboard 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 39 BRDLGTYPP VARCHAR2 2 No No Active Gear type making up port bridles/legs 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 40 BRDLGTYPS VARCHAR2 2 No No Active Gear type on starboard bridles/legs, and footrope. 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 41 FTROPTYPP VARCHAR2 2 No No Active Gear type on port footrope/sweep. 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 42 FTROPTYPS VARCHAR2 2 No No Active Gear type on starboard footrope/sweepp. 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 43 NSWEEPSP NUMBER 22 No No 4 0 Active Total number of the largest piecce of gear present on the port net sweep /footrope (rollers, rock hoppers). Null if sweep is chain or cable/wire or or aft NUMBER 44 SWEEPDIAP NUMBER 22 No No 2 0 Active The diameter in whole inches of the largest piece of gear present on the sweep / footrope on the port or aft net; null if sweep is chain or cable/wire or wrapped NUMBER 45 NSWEEPSS NUMBER 22 No No 4 0 Active Total number of the largest piecce of gear present on the starboard net sweep / footrope(rollers, rock hoppers). Null if sweep is chain or cable/wire NUMBER 46 SWEEPDIAS NUMBER 22 No No 2 0 Active The diameter in whole inches of the largest piece of gear present on the sweep /footrope on the starboard net; null if sweep is chain or cable/wire or wrapped NUMBER 47 NFLOATSP NUMBER 22 No No 3 0 Active Number of floats on port gear NUMBER 48 NFLOATSS NUMBER 22 No No 3 0 Active Number of floats on starboard gear NUMBER 49 FLOATDIAP NUMBER 22 No No 2 0 Active Diameter in whole inches of majority of floats attached to port net headrope. NUMBER 50 FLOATDIAS NUMBER 22 No No 2 0 Active Diameter in whole inches of majority of floats attached to starboard net headrope. NUMBER 51 CODHUNGP VARCHAR2 1 No No Active Hanging configuration of codend..0= unknown, 1 = diamond, 2 = square, 3 square,/wrapped, 8 = combination Collected for ASM where applicable. VARCHAR2 52 CODHUNGS VARCHAR2 1 No No Active Hanging configuration of codend..0= unknown, 1 = diamond, 2 = square, 3 square,/wrapped, 8 = combination Collected for ASM where applicable. VARCHAR2 53 CODTWINETYPP VARCHAR2 1 No No Active Single or double twine used in port codend: 1=single, 2=double, 0=unknown Collected for ASM where applicable. VARCHAR2 54 CODTWINETYPS VARCHAR2 1 No No Active Single or double twine used in starboard codend: 1=single, 2=double, 0=unknown Collected for ASM where applicable. VARCHAR2 55 CODMSIZEP NUMBER 22 No No 3 0 Active Ten randomly selected inside mesh measurements from port net codend; whole millimeters Collected for ASM where applicable. NUMBER 56 CODMSIZES NUMBER 22 No No 3 0 Active Ten randomly selected inside mesh measurements from starboard net codend; whole millimeters Collected for ASM where applicable. NUMBER 57 CODLINERUSDP VARCHAR2 1 No No Active Liner used on port net codend: 0=no, 1=yes, 9=unknown Collected for ASM where applicable. VARCHAR2 58 CODLINERUSDS VARCHAR2 1 No No Active Liner used on starboard net codene: 0=no, 1=yes, 9= unknown Collected for ASM where applicable. VARCHAR2 59 CODSTRENUSDP VARCHAR2 1 No No Active Strengthener meterial used in codend of port net; 0=no, 1=yes, 9=unknown VARCHAR2 60 LINERMSIZEP NUMBER 22 No No 3 0 Active Truncated average of ten randomly selected inside liner whole millimeter measurements for port net location. In obdbs Version 10, this column replaces CODLINERAVMS, datatype changed to NUMBER. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable. NUMBER 61 LINERMSIZES NUMBER 22 No No 3 0 Active Truncated average of ten randomly selected inside liner whole millimeter measurements for starboard net location. In obdbs Version 10, this column replaces CODLINERAVMS, datatype changed to NUMBER. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable. NUMBER 62 KITPNUSDP VARCHAR2 1 No No Active Indicator of whether kite panel used on port or aft depoyed gear added 1-08 VARCHAR2 63 KITPNUSDS VARCHAR2 1 No No Active Indicator of whether kite panel used on starboard depoyed gear added 1-08 VARCHAR2 64 NKITPNP NUMBER 22 No No 2 0 Active Total number of panels used in kite in port or aft deployed net.| added 1-08 NUMBER 65 NKITPNS NUMBER 22 No No 2 0 Active Total number of panels used in kite in starboard net.| added 1-08 NUMBER 66 KITPNLENP NUMBER 22 No No 3 0 Active Average length of panels used in kite in port or aft deployed net, in whole inches. NUMBER 67 KITPNLENS NUMBER 22 No No 3 0 Active Average length of panels used in kite in starboard deployed net, in whole inches. NUMBER 68 KITPNWIDP NUMBER 22 No No 2 0 Active Average width of panels used in kite in port or aft deployed net, in whole inches.| added 1-08 NUMBER 69 KITPNWIDS NUMBER 22 No No 2 0 Active Average width of panels used in kite in starboard deployed net, in whole inches.| added 1-08 NUMBER 70 CODSTRENUSDS VARCHAR2 1 No No Active Strengthener material used in codend of starboard net; 0=no, 1=yes, 9=unknown VARCHAR2 71 CODCHAFFUSDP VARCHAR2 1 No No Active Chaffing gear used on port codend. 0=no, 1=yes, 9=unknown. VARCHAR2 72 CODCHAFFUSDS VARCHAR2 1 No No Active Chaffing gear used on starboard codend. 0=no, 1=yes, 9=unknown. VARCHAR2 73 GMELECTSUSDP VARCHAR2 1 No No Active Whether transducers used on port net: 0=no, 1=yes, 9=unknown VARCHAR2 74 GMELECTSUSDS VARCHAR2 1 No No Active Whether transducers used on starboard net: 0=no, 1=yes, 9=unknown VARCHAR2 75 NTRANSP NUMBER 22 No No 2 0 Active Number of transducers used on port gear. unknown: null; null if not used NUMBER 76 NTRANSS NUMBER 22 No No 2 0 Active Number of transducers on starboard gear. Unknown: null; null if not used NUMBER 77 TRANSTYPP VARCHAR2 1 No No Active Type of transducers used. 0=unknown, 1=wired, 2=wireless,3 = Both VARCHAR2 78 TRANSTYPS VARCHAR2 1 No No Active Type of transducers used: 0=unknown, 1=wired, 2=wireless, 3 = Both VARCHAR2 79 TRANSBRDP VARCHAR2 1 No No Active Code for brand of port side transducers: 0=unknown, 1=Furuno, 2=Simrad 9=other , 3 = Furuno/Simrad combination 9 = other VARCHAR2 80 TRANSBRDS VARCHAR2 1 No No Active Code for brand of starboard side transducers: 0= unkno1n, 1=Furuno, 2=Simrad , 3 = Furuno/Simrad combination , 9=other VARCHAR2 81 TRANSLOCSTRP VARCHAR2 20 No No Active Location of transducers used on port gear, comma separated string of values. Renamed from TRANSLOC with OBDBS Version 10. See OBTRANSLOC table. VARCHAR2 82 TRANSLOCSTRS VARCHAR2 20 No No Active Location of transducers used on starboard gear, comma separated string of values. Renamed from TRANSLOC with OBDBS Version 10. See OBTRANSLOC table. VARCHAR2 83 EXCLUSDP VARCHAR2 1 No No Active Excluder or separators ddevice used on port net: 0=no, 1=yes, 9=unknown. Collected for ASM where applicable. VARCHAR2 84 EXCLUSDS VARCHAR2 1 No No Active Excluder or separators devide used on starboard net: 0=no, 1=yes, 9= unknown. Collected for ASM where applicable. VARCHAR2 85 EXCLTYPP 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. VARCHAR2 86 EXCLTYPS 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. VARCHAR2 87 ESCAPOUTUSDP 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 Collected for ASM where applicable. VARCHAR2 88 ESCAPOUTUSDS 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 Collected for ASM where applicable. VARCHAR2 89 ESCAPOUTLENP NUMBER 22 No No 2 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 90 ESCAPOUTLENS NUMBER 22 No No 2 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 91 ESCAPOUTWIDP NUMBER 22 No No 2 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 92 ESCAPOUTWIDS NUMBER 22 No No 2 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 93 ESCAPOUTSHPP 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 94 ESCAPOUTSHPS 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 95 ESCAPOUTLOCP 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 96 ESCAPOUTLOCS 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 97 ESCAPOUTTYPP VARCHAR2 1 No No Active Type of escape outlet: 0 = Unknown, 1 = Panel, 2 = Opening, 3 = Single Flap, 4 = Double Flap, 9 = Other VARCHAR2 98 ESCAPOUTTYPS VARCHAR2 1 No No Active Type of escape outlet: 0 = Unknown, 1 = Panel, 2 = Opening, 3 = Single Flap, 4 = Double Flap, 9 = Other VARCHAR2 99 ESCAPOUTMSP NUMBER 22 No No 3 0 Active Mesh size of the escape outlet in whole inches. NUMBER 100 ESCAPOUTMSS NUMBER 22 No No 3 0 Active Mesh size of the escape outlet in whole inches. NUMBER 101 TEDEXTMSP NUMBER 22 No No 3 0 Active Turtle exclusion device extension mesh size port or aft gear in tenths of inches (begun 1/2008) NUMBER 102 TEDEXTMSS NUMBER 22 No No 3 0 Active Turtle exclusion device extension mesh size starboard gear in tenths of inches (begun 3/2007) NUMBER 103 ESCAPOUTLENMCP NUMBER 22 No No 3 0 Active Number of meshes in length of the escape outlet (front -> codend) NUMBER 104 ESCAPOUTLENMCS NUMBER 22 No No 3 0 Active Number of meshes in length of the escape outlet (front -> codend) NUMBER 105 ESCAPOUTWIDMCP NUMBER 22 No No 3 0 Active Number of meshes in width of the escape outlet (side -> side) NUMBER 106 ESCAPOUTWIDMCS NUMBER 22 No No 3 0 Active Number of meshes in width of the escape outlet (side -> side) NUMBER 107 TTGCOMMENTSS VARCHAR2 250 No No Active Additional comments regarding the starboard side gear on a twin trawl gear record. Collected for ASM where applicable. VARCHAR2 108 TTGCOMMENTSP VARCHAR2 250 No No Active Additional comments regarding the port side gear on a twin trawl gear record. Collected for ASM where applicable. VARCHAR2 109 LINERMATP VARCHAR2 2 No No Active Type of construction material used in liner for port net location. See OBNETMAT table. Collected beginning with obdbs Version 10 (01/01/2011). VARCHAR2 110 LINERMATS VARCHAR2 2 No No Active Type of construction material used in liner for starboard net location. See OBNETMAT table. Collected beginning with obdbs Version 10 (01/01/2011). VARCHAR2 111 LINERHUNGP VARCHAR2 1 No No Active Hanging configuration of liner for port net location. See OBTWTHUNG table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable. VARCHAR2 112 LINERHUNGS VARCHAR2 1 No No Active Hanging configuration of liner for starboard net location. See OBTWTHUNG table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable. VARCHAR2 113 LINERTWTYPP VARCHAR2 1 No No Active Single or double twine used in liner for port net location. See OBLINTYP table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable. VARCHAR2 114 LINERTWTYPS VARCHAR2 1 No No Active Single or double twine used in liner for starboard net location. See OBLINTYP table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable. VARCHAR2 115 TEDEXTMSTYPP VARCHAR2 1 No No Active Indicator if the number recorded in T.E.D. EXTENSION MESH SIZE for port net location is an actual or estimated value A = actual, E = estimated. Collected beginning with obdbs Version 10 (01/01/2011). VARCHAR2 116 TEDEXTMSTYPS VARCHAR2 1 No No Active Indicator if the number recorded in T.E.D. EXTENSION MESH SIZE for starboard net locationis an actual or estimated value A = actual, E = estimated. Collected beginning with obdbs Version 10 (01/01/2011). VARCHAR2 117 DOE DATE 7 No No Active Date of Entry of the associated record. DATE 118 UOE VARCHAR2 8 No No Active Oracle user ID of the person who entered the data. VARCHAR2 119 DOC DATE 7 No No Active Date associated record was updated. DATE 120 UOC VARCHAR2 8 No No Active Oracle ID of user who made the (most recent ) change on the record. VARCHAR2 gov.noaa.nmfs.inport:33578 Patricia Jones 2016-07-27T19:10:31 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