Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Fisheries Sampling Branch (FSB) > Observer and At Sea Monitor Database (OBDBS) >

View: OBPRG

Entity (ENT) | Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:33569 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Observer Pair Trawl Gear Characteristics

Description

Observer Pair Trawl Gear Characteristics

Entity Type
Data View

Data Attribute / Type	Description
LINK4 VARCHAR2	Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable.
LINK1 VARCHAR2	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.
PROGRAM VARCHAR2	First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
YEAR VARCHAR2	Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.
MONTH VARCHAR2	Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.
TRIPID VARCHAR2	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.
GEARNUM VARCHAR2	Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
NEGEAR VARCHAR2	Northeast gear code. See OBGEAR table. Collected for ASM where applicable.
DOORUSD VARCHAR2	Indicator of whether door was used on gear. 0=no, 1=yes, 9 = unknown.
DOORWGT NUMBER	Weight of one door on on net in whole kilograms. Null if not used or unknown.
NETNAME VARCHAR2	Coded identifier for name of trawl net; see OBNETNAME table(collected for prg before 2007; otg beginning 03/2007). Collected for ASM where applicable.
NETTYPE VARCHAR2	Coded identifier for type of trawl net See OBNETTYPE table.(collected for prg before 2007; otg beginning 03/2007). Collected for ASM where applicable.
NETBUILDER VARCHAR2	Coded identifier for builder net See OBNETBUILDER table.(collected for prg before 2007; otg beginning 03/2007)
NETCODE VARCHAR2	Code that identifies net. See OBNET table.
YRNETMAD VARCHAR2	Four digit year net was made.
GRFSHTYP VARCHAR2	Code for how gear is fished.
NETCONS VARCHAR2	Type of net construction in forward section of net.
NETDESGN VARCHAR2	Code for constuction design of net.
MSMIN NUMBER	Minimum mesh size of net, to nearest hundredth of an inch. Collected for ASM where applicable.
MSMAX NUMBER	Maximum mesh size of net, to nearest hundredth of an inch. Collected for ASM where applicable.
WGTSUSD VARCHAR2	Were weights used? 0=no; 1=yes; 9=unknown.
WGTSLBS NUMBER	Total poundage of all weights used on gear, in whole lbs.
WGTTYPE VARCHAR2	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.
NETMAT VARCHAR2	Type of construction material used in body of net, not including codend. See OBNETMAT table. Removed with obdbs Version 10.
CODMAT VARCHAR2	Type of construction material used in codend only. See OBNETMAT table.
FLOATUSD VARCHAR2	Indicator of whether floats were used on gear. 0=no, 1=yes 9= unknown.
BLOUTUSD VARCHAR2	Indicator of whether blowout section is used.
KITPNUSD VARCHAR2	Indicator of whether kite panel used.\| added to OTG 1-08
NKITPN NUMBER	Total number of panels used in kite in net.\| added 1-08
KITPNLEN NUMBER	Average length of panels used in kite in net, in whole inches. \| added to OTG 1-08
KITPNWID NUMBER	Average width of panels used in kite in net, in whole inches.\| added to OTG 1-08
HDROPLEN NUMBER	Length of the head rope, in feet.
FTROPLEN NUMBER	Length of rope along bottom of net, in whole feet.
BRDTPLEN NUMBER	Length of top bridle, in whole fathoms.
WBRDLEN NUMBER	Length of wing bridle, in whole fathoms.
BBRDLEN NUMBER	Length of bottom bridle, in whole fathoms.
NBRDWARP NUMBER	Number of bridles attached to each warp.
NBRDSIDE NUMBER	Number of wings or bridles found on ONE side(left or right) of net.
NWARPBOT NUMBER	Number of warps fished by each boat.
CIRCLEMC NUMBER	Number of meshes in fishing circle.Not collected prior to 5/1994; set to unknown
CIRCLEMS NUMBER	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.
NFLOATS NUMBER	Number of floats on gear.
FLOATDIA NUMBER	Diameter in whole inches of majority of floats attached to the headrope.Not collected prior to 2001; set to unknown.
CODHUNG VARCHAR2	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.
CODTWINETYP VARCHAR2	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.
CODMSIZE NUMBER	Truncated average of ten randomly selected inside mesh whole millimeter measurements. Collected for ASM where applicable.
CODLINERUSD VARCHAR2	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.
LINERMSIZE NUMBER	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.
CODSTRENUSD VARCHAR2	Indicator of whether strengthener material is used in codend of net. Not collected before 5/1994; set to unknown.
CODCHAFFUSD VARCHAR2	Chaffing gear used on codend. 0 = no, 1= yes, 9 = unknown. Not collected prior to 5/1994; set to unknown.
GMELECTSUSD VARCHAR2	Whether transducers were used on trawl gear. 0=no, 1 = yes, 9 = unknown. Not collected before 5/1994; set to unknown.
NTRANS NUMBER	Number of transducers used on gear. Not collected before 5/1994; set to unknown.
TRANSTYP VARCHAR2	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.
TRANSBRD VARCHAR2	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.
TRANSLOCSTR VARCHAR2	Location of transducers used on gear, comma separated string of values. Renamed from TRANSLOC with OBDBS Version 10. See OBTRANSLOC table.
LINERMAT VARCHAR2	Type of construction material used in liner. See OBNETMAT table. Collected beginning with obdbs Version 10 (01/01/2011).
LINERHUNG VARCHAR2	Hanging configuration of liner. See OBTWTHUNG table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
LINERTWTYP VARCHAR2	Single or double twine used in liner. See OBLINTYP table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
EXCLUSD VARCHAR2	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.
EXCLTYP VARCHAR2	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.
TEDEXTMS NUMBER	Turtle exclusion device extension mesh size in tenths of inches (begun 3/2007)
ESCAPOUTUSD VARCHAR2	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
ESCAPOUTLEN NUMBER	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
ESCAPOUTWID NUMBER	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
ESCAPOUTSHP VARCHAR2	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
ESCAPOUTLOC VARCHAR2	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
ESCAPOUTMS NUMBER	Mesh size of the escape outlet in whole inches.
ESCAPOUTLENMC NUMBER	Number of meshes in length of the escape outlet (front -> codend)
ESCAPOUTWIDMC NUMBER	Number of meshes in width of the escape outlet (side -> side)
ESCAPOUTTYP VARCHAR2	Type of escape outlet: 0 = Unknown, 1 = Panel, 2 = Opening, 3 = Single Flap, 4 = Double Flap, 9 = Other
PRGCOMMENTS VARCHAR2	Additional information re: PaiR trawl Gear.

Data Attribute / Type

Description

LINK4
VARCHAR2

Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable.

LINK1
VARCHAR2

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.

PROGRAM
VARCHAR2

First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.

YEAR
VARCHAR2

Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.

MONTH
VARCHAR2

Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.

TRIPID
VARCHAR2

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.

GEARNUM
VARCHAR2

Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.

NEGEAR
VARCHAR2

Northeast gear code. See OBGEAR table. Collected for ASM where applicable.

DOORUSD
VARCHAR2

Indicator of whether door was used on gear. 0=no, 1=yes, 9 = unknown.

DOORWGT
NUMBER

Weight of one door on on net in whole kilograms. Null if not used or unknown.

NETNAME
VARCHAR2

Coded identifier for name of trawl net; see OBNETNAME table(collected for prg before 2007; otg beginning 03/2007). Collected for ASM where applicable.

NETTYPE
VARCHAR2

Coded identifier for type of trawl net See OBNETTYPE table.(collected for prg before 2007; otg beginning 03/2007). Collected for ASM where applicable.

NETBUILDER
VARCHAR2

Coded identifier for builder net See OBNETBUILDER table.(collected for prg before 2007; otg beginning 03/2007)

NETCODE
VARCHAR2

Code that identifies net. See OBNET table.

YRNETMAD
VARCHAR2

Four digit year net was made.

GRFSHTYP
VARCHAR2

Code for how gear is fished.

NETCONS
VARCHAR2

Type of net construction in forward section of net.

NETDESGN
VARCHAR2

Code for constuction design of net.

MSMIN
NUMBER

Minimum mesh size of net, to nearest hundredth of an inch. Collected for ASM where applicable.

MSMAX
NUMBER

Maximum mesh size of net, to nearest hundredth of an inch. Collected for ASM where applicable.

WGTSUSD
VARCHAR2

Were weights used? 0=no; 1=yes; 9=unknown.

WGTSLBS
NUMBER

Total poundage of all weights used on gear, in whole lbs.

WGTTYPE
VARCHAR2

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.

NETMAT
VARCHAR2

Type of construction material used in body of net, not including codend. See OBNETMAT table. Removed with obdbs Version 10.

CODMAT
VARCHAR2

Type of construction material used in codend only. See OBNETMAT table.

FLOATUSD
VARCHAR2

Indicator of whether floats were used on gear. 0=no, 1=yes 9= unknown.

BLOUTUSD
VARCHAR2

Indicator of whether blowout section is used.

KITPNUSD
VARCHAR2

Indicator of whether kite panel used.| added to OTG 1-08

NKITPN
NUMBER

Total number of panels used in kite in net.| added 1-08

KITPNLEN
NUMBER

Average length of panels used in kite in net, in whole inches. | added to OTG 1-08

KITPNWID
NUMBER

Average width of panels used in kite in net, in whole inches.| added to OTG 1-08

HDROPLEN
NUMBER

Length of the head rope, in feet.

FTROPLEN
NUMBER

Length of rope along bottom of net, in whole feet.

BRDTPLEN
NUMBER

Length of top bridle, in whole fathoms.

WBRDLEN
NUMBER

Length of wing bridle, in whole fathoms.

BBRDLEN
NUMBER

Length of bottom bridle, in whole fathoms.

NBRDWARP
NUMBER

Number of bridles attached to each warp.

NBRDSIDE
NUMBER

Number of wings or bridles found on ONE side(left or right) of net.

NWARPBOT
NUMBER

Number of warps fished by each boat.

CIRCLEMC
NUMBER

Number of meshes in fishing circle.Not collected prior to 5/1994; set to unknown

CIRCLEMS
NUMBER

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.

NFLOATS
NUMBER

Number of floats on gear.

FLOATDIA
NUMBER

Diameter in whole inches of majority of floats attached to the headrope.Not collected prior to 2001; set to unknown.

CODHUNG
VARCHAR2

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.

CODTWINETYP
VARCHAR2

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.

CODMSIZE
NUMBER

Truncated average of ten randomly selected inside mesh whole millimeter measurements. Collected for ASM where applicable.

CODLINERUSD
VARCHAR2

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.

LINERMSIZE
NUMBER

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.

CODSTRENUSD
VARCHAR2

Indicator of whether strengthener material is used in codend of net. Not collected before 5/1994; set to unknown.

CODCHAFFUSD
VARCHAR2

Chaffing gear used on codend. 0 = no, 1= yes, 9 = unknown. Not collected prior to 5/1994; set to unknown.

GMELECTSUSD
VARCHAR2

Whether transducers were used on trawl gear. 0=no, 1 = yes, 9 = unknown. Not collected before 5/1994; set to unknown.

NTRANS
NUMBER

Number of transducers used on gear. Not collected before 5/1994; set to unknown.

TRANSTYP
VARCHAR2

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.

TRANSBRD
VARCHAR2

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.

TRANSLOCSTR
VARCHAR2

Location of transducers used on gear, comma separated string of values. Renamed from TRANSLOC with OBDBS Version 10. See OBTRANSLOC table.

LINERMAT
VARCHAR2

Type of construction material used in liner. See OBNETMAT table. Collected beginning with obdbs Version 10 (01/01/2011).

LINERHUNG
VARCHAR2

Hanging configuration of liner. See OBTWTHUNG table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.

LINERTWTYP
VARCHAR2

Single or double twine used in liner. See OBLINTYP table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.

EXCLUSD
VARCHAR2

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.

EXCLTYP
VARCHAR2

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.

TEDEXTMS
NUMBER

Turtle exclusion device extension mesh size in tenths of inches (begun 3/2007)

ESCAPOUTUSD
VARCHAR2

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

ESCAPOUTLEN
NUMBER

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

ESCAPOUTWID
NUMBER

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

ESCAPOUTSHP
VARCHAR2

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

ESCAPOUTLOC
VARCHAR2

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

ESCAPOUTMS
NUMBER

Mesh size of the escape outlet in whole inches.

ESCAPOUTLENMC
NUMBER

Number of meshes in length of the escape outlet (front -> codend)

ESCAPOUTWIDMC
NUMBER

Number of meshes in width of the escape outlet (side -> side)

ESCAPOUTTYP
VARCHAR2

Type of escape outlet: 0 = Unknown, 1 = Panel, 2 = Opening, 3 = Single Flap, 4 = Double Flap, 9 = Other

PRGCOMMENTS
VARCHAR2

Additional information re: PaiR trawl Gear.

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (NEFSC) for inquiries on this record.

Title:	View: OBPRG
Short Name:	OBPRG
Status:	Completed
Abstract:	Observer Pair Trawl Gear Characteristics
Notes:	Loaded by batch 9053, 07-27-2016 19:10

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	OBDBS
Description:	Observer Pair Trawl Gear Characteristics

Attribute Summary

	Name	Type	Description
100	LINK4	VARCHAR2	Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable.
100	LINK1	VARCHAR2	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.
100	PROGRAM	VARCHAR2	First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
100	YEAR	VARCHAR2	Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.
100	MONTH	VARCHAR2	Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.
100	TRIPID	VARCHAR2	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.
100	GEARNUM	VARCHAR2	Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
100	NEGEAR	VARCHAR2	Northeast gear code. See OBGEAR table. Collected for ASM where applicable.
100	DOORUSD	VARCHAR2	Indicator of whether door was used on gear. 0=no, 1=yes, 9 = unknown.
100	DOORWGT	NUMBER	Weight of one door on on net in whole kilograms. Null if not used or unknown.
100	NETNAME	VARCHAR2	Coded identifier for name of trawl net; see OBNETNAME table(collected for prg before 2007; otg beginning 03/2007). Collected for ASM where applicable.
100	NETTYPE	VARCHAR2	Coded identifier for type of trawl net See OBNETTYPE table.(collected for prg before 2007; otg beginning 03/2007). Collected for ASM where applicable.
100	NETBUILDER	VARCHAR2	Coded identifier for builder net See OBNETBUILDER table.(collected for prg before 2007; otg beginning 03/2007)
100	NETCODE	VARCHAR2	Code that identifies net. See OBNET table.
100	YRNETMAD	VARCHAR2	Four digit year net was made.
100	GRFSHTYP	VARCHAR2	Code for how gear is fished.
100	NETCONS	VARCHAR2	Type of net construction in forward section of net.
100	NETDESGN	VARCHAR2	Code for constuction design of net.
100	MSMIN	NUMBER	Minimum mesh size of net, to nearest hundredth of an inch. Collected for ASM where applicable.
100	MSMAX	NUMBER	Maximum mesh size of net, to nearest hundredth of an inch. Collected for ASM where applicable.
100	WGTSUSD	VARCHAR2	Were weights used? 0=no; 1=yes; 9=unknown.
100	WGTSLBS	NUMBER	Total poundage of all weights used on gear, in whole lbs.
100	WGTTYPE	VARCHAR2	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.
100	NETMAT	VARCHAR2	Type of construction material used in body of net, not including codend. See OBNETMAT table. Removed with obdbs Version 10.
100	CODMAT	VARCHAR2	Type of construction material used in codend only. See OBNETMAT table.
100	FLOATUSD	VARCHAR2	Indicator of whether floats were used on gear. 0=no, 1=yes 9= unknown.
100	BLOUTUSD	VARCHAR2	Indicator of whether blowout section is used.
100	KITPNUSD	VARCHAR2	Indicator of whether kite panel used.\| added to OTG 1-08
100	NKITPN	NUMBER	Total number of panels used in kite in net.\| added 1-08
100	KITPNLEN	NUMBER	Average length of panels used in kite in net, in whole inches. \| added to OTG 1-08
100	KITPNWID	NUMBER	Average width of panels used in kite in net, in whole inches.\| added to OTG 1-08
100	HDROPLEN	NUMBER	Length of the head rope, in feet.
100	FTROPLEN	NUMBER	Length of rope along bottom of net, in whole feet.
100	BRDTPLEN	NUMBER	Length of top bridle, in whole fathoms.
100	WBRDLEN	NUMBER	Length of wing bridle, in whole fathoms.
100	BBRDLEN	NUMBER	Length of bottom bridle, in whole fathoms.
100	NBRDWARP	NUMBER	Number of bridles attached to each warp.
100	NBRDSIDE	NUMBER	Number of wings or bridles found on ONE side(left or right) of net.
100	NWARPBOT	NUMBER	Number of warps fished by each boat.
100	CIRCLEMC	NUMBER	Number of meshes in fishing circle.Not collected prior to 5/1994; set to unknown
100	CIRCLEMS	NUMBER	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.
100	NFLOATS	NUMBER	Number of floats on gear.
100	FLOATDIA	NUMBER	Diameter in whole inches of majority of floats attached to the headrope.Not collected prior to 2001; set to unknown.
100	CODHUNG	VARCHAR2	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.
100	CODTWINETYP	VARCHAR2	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.
100	CODMSIZE	NUMBER	Truncated average of ten randomly selected inside mesh whole millimeter measurements. Collected for ASM where applicable.
100	CODLINERUSD	VARCHAR2	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.
100	LINERMSIZE	NUMBER	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.
100	CODSTRENUSD	VARCHAR2	Indicator of whether strengthener material is used in codend of net. Not collected before 5/1994; set to unknown.
100	CODCHAFFUSD	VARCHAR2	Chaffing gear used on codend. 0 = no, 1= yes, 9 = unknown. Not collected prior to 5/1994; set to unknown.
100	GMELECTSUSD	VARCHAR2	Whether transducers were used on trawl gear. 0=no, 1 = yes, 9 = unknown. Not collected before 5/1994; set to unknown.
100	NTRANS	NUMBER	Number of transducers used on gear. Not collected before 5/1994; set to unknown.
100	TRANSTYP	VARCHAR2	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.
100	TRANSBRD	VARCHAR2	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.
100	TRANSLOCSTR	VARCHAR2	Location of transducers used on gear, comma separated string of values. Renamed from TRANSLOC with OBDBS Version 10. See OBTRANSLOC table.
100	LINERMAT	VARCHAR2	Type of construction material used in liner. See OBNETMAT table. Collected beginning with obdbs Version 10 (01/01/2011).
100	LINERHUNG	VARCHAR2	Hanging configuration of liner. See OBTWTHUNG table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
100	LINERTWTYP	VARCHAR2	Single or double twine used in liner. See OBLINTYP table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
100	EXCLUSD	VARCHAR2	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.
100	EXCLTYP	VARCHAR2	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.
100	TEDEXTMS	NUMBER	Turtle exclusion device extension mesh size in tenths of inches (begun 3/2007)
100	ESCAPOUTUSD	VARCHAR2	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
100	ESCAPOUTLEN	NUMBER	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
100	ESCAPOUTWID	NUMBER	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
100	ESCAPOUTSHP	VARCHAR2	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
100	ESCAPOUTLOC	VARCHAR2	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
100	ESCAPOUTMS	NUMBER	Mesh size of the escape outlet in whole inches.
100	ESCAPOUTLENMC	NUMBER	Number of meshes in length of the escape outlet (front -> codend)
100	ESCAPOUTWIDMC	NUMBER	Number of meshes in width of the escape outlet (side -> side)
100	ESCAPOUTTYP	VARCHAR2	Type of escape outlet: 0 = Unknown, 1 = Panel, 2 = Opening, 3 = Single Flap, 4 = Double Flap, 9 = Other
100	PRGCOMMENTS	VARCHAR2	Additional information re: PaiR trawl Gear.

Name

Type

Description

100

LINK4

VARCHAR2

Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable.

100

LINK1

VARCHAR2

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.

100

PROGRAM

VARCHAR2

First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.

100

YEAR

VARCHAR2

Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.

100

MONTH

VARCHAR2

Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.

100

TRIPID

VARCHAR2

100

GEARNUM

VARCHAR2

Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.

100

NEGEAR

VARCHAR2

Northeast gear code. See OBGEAR table. Collected for ASM where applicable.

100

DOORUSD

VARCHAR2

Indicator of whether door was used on gear. 0=no, 1=yes, 9 = unknown.

100

DOORWGT

NUMBER

Weight of one door on on net in whole kilograms. Null if not used or unknown.

100

NETNAME

VARCHAR2

Coded identifier for name of trawl net; see OBNETNAME table(collected for prg before 2007; otg beginning 03/2007). Collected for ASM where applicable.

100

NETTYPE

VARCHAR2

Coded identifier for type of trawl net See OBNETTYPE table.(collected for prg before 2007; otg beginning 03/2007). Collected for ASM where applicable.

100

NETBUILDER

VARCHAR2

Coded identifier for builder net See OBNETBUILDER table.(collected for prg before 2007; otg beginning 03/2007)

100

NETCODE

VARCHAR2

Code that identifies net. See OBNET table.

100

YRNETMAD

VARCHAR2

Four digit year net was made.

100

GRFSHTYP

VARCHAR2

Code for how gear is fished.

100

NETCONS

VARCHAR2

Type of net construction in forward section of net.

100

NETDESGN

VARCHAR2

Code for constuction design of net.

100

MSMIN

NUMBER

Minimum mesh size of net, to nearest hundredth of an inch. Collected for ASM where applicable.

100

MSMAX

NUMBER

Maximum mesh size of net, to nearest hundredth of an inch. Collected for ASM where applicable.

100

WGTSUSD

VARCHAR2

Were weights used? 0=no; 1=yes; 9=unknown.

100

WGTSLBS

NUMBER

Total poundage of all weights used on gear, in whole lbs.

100

WGTTYPE

VARCHAR2

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.

100

NETMAT

VARCHAR2

Type of construction material used in body of net, not including codend. See OBNETMAT table. Removed with obdbs Version 10.

100

CODMAT

VARCHAR2

Type of construction material used in codend only. See OBNETMAT table.

100

FLOATUSD

VARCHAR2

Indicator of whether floats were used on gear. 0=no, 1=yes 9= unknown.

100

BLOUTUSD

VARCHAR2

Indicator of whether blowout section is used.

100

KITPNUSD

VARCHAR2

Indicator of whether kite panel used.| added to OTG 1-08

100

NKITPN

NUMBER

Total number of panels used in kite in net.| added 1-08

100

KITPNLEN

NUMBER

Average length of panels used in kite in net, in whole inches. | added to OTG 1-08

100

KITPNWID

NUMBER

Average width of panels used in kite in net, in whole inches.| added to OTG 1-08

100

HDROPLEN

NUMBER

Length of the head rope, in feet.

100

FTROPLEN

NUMBER

Length of rope along bottom of net, in whole feet.

100

BRDTPLEN

NUMBER

Length of top bridle, in whole fathoms.

100

WBRDLEN

NUMBER

Length of wing bridle, in whole fathoms.

100

BBRDLEN

NUMBER

Length of bottom bridle, in whole fathoms.

100

NBRDWARP

NUMBER

Number of bridles attached to each warp.

100

NBRDSIDE

NUMBER

Number of wings or bridles found on ONE side(left or right) of net.

100

NWARPBOT

NUMBER

Number of warps fished by each boat.

100

CIRCLEMC

NUMBER

Number of meshes in fishing circle.Not collected prior to 5/1994; set to unknown

100

CIRCLEMS

NUMBER

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.

100

NFLOATS

NUMBER

Number of floats on gear.

100

FLOATDIA

NUMBER

Diameter in whole inches of majority of floats attached to the headrope.Not collected prior to 2001; set to unknown.

100

CODHUNG

VARCHAR2

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.

100

CODTWINETYP

VARCHAR2

100

CODMSIZE

NUMBER

Truncated average of ten randomly selected inside mesh whole millimeter measurements. Collected for ASM where applicable.

100

CODLINERUSD

VARCHAR2

100

LINERMSIZE

NUMBER

100

CODSTRENUSD

VARCHAR2

Indicator of whether strengthener material is used in codend of net. Not collected before 5/1994; set to unknown.

100

CODCHAFFUSD

VARCHAR2

Chaffing gear used on codend. 0 = no, 1= yes, 9 = unknown. Not collected prior to 5/1994; set to unknown.

100

GMELECTSUSD

VARCHAR2

Whether transducers were used on trawl gear. 0=no, 1 = yes, 9 = unknown. Not collected before 5/1994; set to unknown.

100

NTRANS

NUMBER

Number of transducers used on gear. Not collected before 5/1994; set to unknown.

100

TRANSTYP

VARCHAR2

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.

100

TRANSBRD

VARCHAR2

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.

100

TRANSLOCSTR

VARCHAR2

Location of transducers used on gear, comma separated string of values. Renamed from TRANSLOC with OBDBS Version 10. See OBTRANSLOC table.

100

LINERMAT

VARCHAR2

Type of construction material used in liner. See OBNETMAT table. Collected beginning with obdbs Version 10 (01/01/2011).

100

LINERHUNG

VARCHAR2

Hanging configuration of liner. See OBTWTHUNG table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.

100

LINERTWTYP

VARCHAR2

Single or double twine used in liner. See OBLINTYP table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.

100

EXCLUSD

VARCHAR2

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.

100

EXCLTYP

VARCHAR2

100

TEDEXTMS

NUMBER

Turtle exclusion device extension mesh size in tenths of inches (begun 3/2007)

100

ESCAPOUTUSD

VARCHAR2

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

100

ESCAPOUTLEN

NUMBER

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

100

ESCAPOUTWID

NUMBER

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

100

ESCAPOUTSHP

VARCHAR2

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

100

ESCAPOUTLOC

VARCHAR2

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

100

ESCAPOUTMS

NUMBER

Mesh size of the escape outlet in whole inches.

100

ESCAPOUTLENMC

NUMBER

Number of meshes in length of the escape outlet (front -> codend)

100

ESCAPOUTWIDMC

NUMBER

Number of meshes in width of the escape outlet (side -> side)

100

ESCAPOUTTYP

VARCHAR2

Type of escape outlet: 0 = Unknown, 1 = Panel, 2 = Opening, 3 = Single Flap, 4 = Double Flap, 9 = Other

100

PRGCOMMENTS

VARCHAR2

Additional information re: PaiR trawl Gear.

Attribute Details

LINK4

CC ID: 334709

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	17
Required:	No
Primary Key:	No
Status:	Active
Description:	Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable.
General Data Type:	VARCHAR2

LINK1

CC ID: 334720

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	15
Required:	No
Primary Key:	No
Status:	Active
Description:	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.
General Data Type:	VARCHAR2

PROGRAM

CC ID: 334731

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
General Data Type:	VARCHAR2

YEAR

CC ID: 334742

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.
General Data Type:	VARCHAR2

MONTH

CC ID: 334753

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.
General Data Type:	VARCHAR2

TRIPID

CC ID: 334764

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	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.
General Data Type:	VARCHAR2

GEARNUM

CC ID: 334775

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
General Data Type:	VARCHAR2

NEGEAR

CC ID: 334778

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Northeast gear code. See OBGEAR table. Collected for ASM where applicable.
General Data Type:	VARCHAR2

DOORUSD

CC ID: 334779

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of whether door was used on gear. 0=no, 1=yes, 9 = unknown.
General Data Type:	VARCHAR2

DOORWGT

CC ID: 334710

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Weight of one door on on net in whole kilograms. Null if not used or unknown.
General Data Type:	NUMBER

NETNAME

CC ID: 334711

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Coded identifier for name of trawl net; see OBNETNAME table(collected for prg before 2007; otg beginning 03/2007). Collected for ASM where applicable.
General Data Type:	VARCHAR2

NETTYPE

CC ID: 334712

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Coded identifier for type of trawl net See OBNETTYPE table.(collected for prg before 2007; otg beginning 03/2007). Collected for ASM where applicable.
General Data Type:	VARCHAR2

NETBUILDER

CC ID: 334713

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Coded identifier for builder net See OBNETBUILDER table.(collected for prg before 2007; otg beginning 03/2007)
General Data Type:	VARCHAR2

NETCODE

CC ID: 334714

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Code that identifies net. See OBNET table.
General Data Type:	VARCHAR2

YRNETMAD

CC ID: 334715

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Four digit year net was made.
General Data Type:	VARCHAR2

GRFSHTYP

CC ID: 334716

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for how gear is fished.
General Data Type:	VARCHAR2

NETCONS

CC ID: 334717

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Type of net construction in forward section of net.
General Data Type:	VARCHAR2

NETDESGN

CC ID: 334718

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for constuction design of net.
General Data Type:	VARCHAR2

MSMIN

CC ID: 334719

Seq. Order:	19
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	1
Status:	Active
Description:	Minimum mesh size of net, to nearest hundredth of an inch. Collected for ASM where applicable.
General Data Type:	NUMBER

MSMAX

CC ID: 334721

Seq. Order:	20
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	1
Status:	Active
Description:	Maximum mesh size of net, to nearest hundredth of an inch. Collected for ASM where applicable.
General Data Type:	NUMBER

WGTSUSD

CC ID: 334722

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Were weights used? 0=no; 1=yes; 9=unknown.
General Data Type:	VARCHAR2

WGTSLBS

CC ID: 334723

Seq. Order:	22
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	0
Status:	Active
Description:	Total poundage of all weights used on gear, in whole lbs.
General Data Type:	NUMBER

WGTTYPE

CC ID: 334724

Seq. Order:	23
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	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.
General Data Type:	VARCHAR2

NETMAT

CC ID: 334725

Seq. Order:	24
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Type of construction material used in body of net, not including codend. See OBNETMAT table. Removed with obdbs Version 10.
General Data Type:	VARCHAR2

CODMAT

CC ID: 334726

Seq. Order:	25
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Type of construction material used in codend only. See OBNETMAT table.
General Data Type:	VARCHAR2

FLOATUSD

CC ID: 334727

Seq. Order:	26
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of whether floats were used on gear. 0=no, 1=yes 9= unknown.
General Data Type:	VARCHAR2

BLOUTUSD

CC ID: 334728

Seq. Order:	27
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of whether blowout section is used.
General Data Type:	VARCHAR2

KITPNUSD

CC ID: 334729

Seq. Order:	28
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of whether kite panel used.\| added to OTG 1-08
General Data Type:	VARCHAR2

NKITPN

CC ID: 334730

Seq. Order:	29
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Total number of panels used in kite in net.\| added 1-08
General Data Type:	NUMBER

KITPNLEN

CC ID: 334732

Seq. Order:	30
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Average length of panels used in kite in net, in whole inches. \| added to OTG 1-08
General Data Type:	NUMBER

KITPNWID

CC ID: 334733

Seq. Order:	31
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Average width of panels used in kite in net, in whole inches.\| added to OTG 1-08
General Data Type:	NUMBER

HDROPLEN

CC ID: 334734

Seq. Order:	32
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Length of the head rope, in feet.
General Data Type:	NUMBER

FTROPLEN

CC ID: 334735

Seq. Order:	33
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Length of rope along bottom of net, in whole feet.
General Data Type:	NUMBER

BRDTPLEN

CC ID: 334736

Seq. Order:	34
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Length of top bridle, in whole fathoms.
General Data Type:	NUMBER

WBRDLEN

CC ID: 334737

Seq. Order:	35
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Length of wing bridle, in whole fathoms.
General Data Type:	NUMBER

BBRDLEN

CC ID: 334738

Seq. Order:	36
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Length of bottom bridle, in whole fathoms.
General Data Type:	NUMBER

NBRDWARP

CC ID: 334739

Seq. Order:	37
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Number of bridles attached to each warp.
General Data Type:	NUMBER

NBRDSIDE

CC ID: 334740

Seq. Order:	38
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	1
Scale:	0
Status:	Active
Description:	Number of wings or bridles found on ONE side(left or right) of net.
General Data Type:	NUMBER

NWARPBOT

CC ID: 334741

Seq. Order:	39
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	1
Scale:	0
Status:	Active
Description:	Number of warps fished by each boat.
General Data Type:	NUMBER

CIRCLEMC

CC ID: 334743

Seq. Order:	40
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Number of meshes in fishing circle.Not collected prior to 5/1994; set to unknown
General Data Type:	NUMBER

CIRCLEMS

CC ID: 334744

Seq. Order:	41
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	1
Status:	Active
Description:	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.
General Data Type:	NUMBER

NFLOATS

CC ID: 334745

Seq. Order:	42
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Number of floats on gear.
General Data Type:	NUMBER

FLOATDIA

CC ID: 334746

Seq. Order:	43
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Diameter in whole inches of majority of floats attached to the headrope.Not collected prior to 2001; set to unknown.
General Data Type:	NUMBER

CODHUNG

CC ID: 334747

Seq. Order:	44
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	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.
General Data Type:	VARCHAR2

CODTWINETYP

CC ID: 334748

Seq. Order:	45
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	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.
General Data Type:	VARCHAR2

CODMSIZE

CC ID: 334749

Seq. Order:	46
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Truncated average of ten randomly selected inside mesh whole millimeter measurements. Collected for ASM where applicable.
General Data Type:	NUMBER

CODLINERUSD

CC ID: 334750

Seq. Order:	47
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	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.
General Data Type:	VARCHAR2

LINERMSIZE

CC ID: 334751

Seq. Order:	48
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	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.
General Data Type:	NUMBER

CODSTRENUSD

CC ID: 334752

Seq. Order:	49
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of whether strengthener material is used in codend of net. Not collected before 5/1994; set to unknown.
General Data Type:	VARCHAR2

CODCHAFFUSD

CC ID: 334754

Seq. Order:	50
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Chaffing gear used on codend. 0 = no, 1= yes, 9 = unknown. Not collected prior to 5/1994; set to unknown.
General Data Type:	VARCHAR2

GMELECTSUSD

CC ID: 334755

Seq. Order:	51
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Whether transducers were used on trawl gear. 0=no, 1 = yes, 9 = unknown. Not collected before 5/1994; set to unknown.
General Data Type:	VARCHAR2

NTRANS

CC ID: 334756

Seq. Order:	52
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Number of transducers used on gear. Not collected before 5/1994; set to unknown.
General Data Type:	NUMBER

TRANSTYP

CC ID: 334757

Seq. Order:	53
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	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.
General Data Type:	VARCHAR2

TRANSBRD

CC ID: 334758

Seq. Order:	54
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	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.
General Data Type:	VARCHAR2

TRANSLOCSTR

CC ID: 334759

Seq. Order:	55
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Location of transducers used on gear, comma separated string of values. Renamed from TRANSLOC with OBDBS Version 10. See OBTRANSLOC table.
General Data Type:	VARCHAR2

LINERMAT

CC ID: 334760

Seq. Order:	56
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Type of construction material used in liner. See OBNETMAT table. Collected beginning with obdbs Version 10 (01/01/2011).
General Data Type:	VARCHAR2

LINERHUNG

CC ID: 334761

Seq. Order:	57
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Hanging configuration of liner. See OBTWTHUNG table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
General Data Type:	VARCHAR2

LINERTWTYP

CC ID: 334762

Seq. Order:	58
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Single or double twine used in liner. See OBLINTYP table. Collected beginning with obdbs Version 10 (01/01/2011). Collected for ASM where applicable.
General Data Type:	VARCHAR2

EXCLUSD

CC ID: 334763

Seq. Order:	59
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	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.
General Data Type:	VARCHAR2

EXCLTYP

CC ID: 334765

Seq. Order:	60
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	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.
General Data Type:	VARCHAR2

TEDEXTMS

CC ID: 334766

Seq. Order:	61
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	1
Status:	Active
Description:	Turtle exclusion device extension mesh size in tenths of inches (begun 3/2007)
General Data Type:	NUMBER

ESCAPOUTUSD

CC ID: 334767

Seq. Order:	62
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	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
General Data Type:	VARCHAR2

ESCAPOUTLEN

CC ID: 334768

Seq. Order:	63
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	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
General Data Type:	NUMBER

ESCAPOUTWID

CC ID: 334769

Seq. Order:	64
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	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
General Data Type:	NUMBER

ESCAPOUTSHP

CC ID: 334770

Seq. Order:	65
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	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
General Data Type:	VARCHAR2

ESCAPOUTLOC

CC ID: 334771

Seq. Order:	66
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	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
General Data Type:	VARCHAR2

ESCAPOUTMS

CC ID: 334772

Seq. Order:	67
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Mesh size of the escape outlet in whole inches.
General Data Type:	NUMBER

ESCAPOUTLENMC

CC ID: 334773

Seq. Order:	68
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Number of meshes in length of the escape outlet (front -> codend)
General Data Type:	NUMBER

ESCAPOUTWIDMC

CC ID: 334774

Seq. Order:	69
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Number of meshes in width of the escape outlet (side -> side)
General Data Type:	NUMBER

ESCAPOUTTYP

CC ID: 334776

Seq. Order:	70
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Type of escape outlet: 0 = Unknown, 1 = Panel, 2 = Opening, 3 = Single Flap, 4 = Double Flap, 9 = Other
General Data Type:	VARCHAR2

PRGCOMMENTS

CC ID: 334777

Seq. Order:	71
Data Storage Type:	VARCHAR2
Max Length:	250
Required:	No
Primary Key:	No
Status:	Active
Description:	Additional information re: PaiR trawl Gear.
General Data Type:	VARCHAR2

Catalog Item ID:	33569
GUID:	gov.noaa.nmfs.inport:33569
Metadata Record Created By:	Patricia L Jones
Metadata Record Created:	2016-07-27 19:10+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2016-07-28
Owner Org:	NEFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2016-07-28
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2017-07-28

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

LINK4

LINK1

PROGRAM

YEAR

MONTH

TRIPID

GEARNUM

NEGEAR

DOORUSD

DOORWGT

NETNAME

NETTYPE

NETBUILDER

NETCODE

YRNETMAD

GRFSHTYP

NETCONS

NETDESGN

MSMIN

MSMAX

WGTSUSD

WGTSLBS

WGTTYPE

NETMAT

CODMAT

FLOATUSD

BLOUTUSD

KITPNUSD

NKITPN

KITPNLEN

KITPNWID

HDROPLEN

FTROPLEN

BRDTPLEN

WBRDLEN

BBRDLEN

NBRDWARP

NBRDSIDE

NWARPBOT

CIRCLEMC

CIRCLEMS

NFLOATS

FLOATDIA

CODHUNG

CODTWINETYP

CODMSIZE

CODLINERUSD

LINERMSIZE

CODSTRENUSD

CODCHAFFUSD

GMELECTSUSD

NTRANS

TRANSTYP

TRANSBRD

TRANSLOCSTR

LINERMAT

LINERHUNG

LINERTWTYP

EXCLUSD

EXCLTYP

TEDEXTMS

ESCAPOUTUSD

ESCAPOUTLEN

ESCAPOUTWID

ESCAPOUTSHP

ESCAPOUTLOC

ESCAPOUTMS

ESCAPOUTLENMC

ESCAPOUTWIDMC

ESCAPOUTTYP

PRGCOMMENTS