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: ASMOTG

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

At Sea Monitor Otter Trawl Gear Characteristics

Description

At Sea Monitor Otter 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)
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.
HDROPLEN NUMBER	Length of the head rope, in feet.
FTROPLEN NUMBER	Length of rope along bottom of net, in whole feet.
GRCABLEN NUMBER	Length of wire connecting the bridles and back strap, in fathoms (previous to 5/2007 was in feet)
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.
GRCABTYP VARCHAR2	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
BRDLGTYP VARCHAR2	Gear type making up the bridles/legs 0=unknown, 1=chain, 2=cable/wire
BRDTPLEN NUMBER	Length of top bridle, in whole fathoms.
FTROPTYP VARCHAR2	Foot rope / sweep type; see OBGRNDGEAR table.
NSWEEPS NUMBER	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
SWEEPDIA NUMBER	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 /
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.
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
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
KITPNWID NUMBER	Average width of panels used in kite in net, in whole inches.\| added to OTG 1-08
KITPNLEN NUMBER	Average length of panels used in kite in net, in whole inches. \| added to OTG 1-08
OTGCOMMENTS VARCHAR2	Comments on trawl gear record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable.
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.
TEDEXTMSTYP VARCHAR2	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).
ASMTEST_STATUS VARCHAR2	Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested

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)

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.

HDROPLEN
NUMBER

Length of the head rope, in feet.

FTROPLEN
NUMBER

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

GRCABLEN
NUMBER

Length of wire connecting the bridles and back strap, in fathoms (previous to 5/2007 was in feet)

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.

GRCABTYP
VARCHAR2

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

BRDLGTYP
VARCHAR2

Gear type making up the bridles/legs 0=unknown, 1=chain, 2=cable/wire

BRDTPLEN
NUMBER

Length of top bridle, in whole fathoms.

FTROPTYP
VARCHAR2

Foot rope / sweep type; see OBGRNDGEAR table.

NSWEEPS
NUMBER

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

SWEEPDIA
NUMBER

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 /

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.

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

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

KITPNWID
NUMBER

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

KITPNLEN
NUMBER

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

OTGCOMMENTS
VARCHAR2

Comments on trawl gear record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable.

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.

TEDEXTMSTYP
VARCHAR2

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).

ASMTEST_STATUS
VARCHAR2

Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested

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: ASMOTG
Short Name:	ASMOTG
Status:	Completed
Abstract:	At Sea Monitor Otter Trawl Gear Characteristics
Notes:	Loaded by batch 9053, 07-27-2016 19:10

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	OBDBS
Description:	At Sea Monitor Otter 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	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	HDROPLEN	NUMBER	Length of the head rope, in feet.
100	FTROPLEN	NUMBER	Length of rope along bottom of net, in whole feet.
100	GRCABLEN	NUMBER	Length of wire connecting the bridles and back strap, in fathoms (previous to 5/2007 was in feet)
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	GRCABTYP	VARCHAR2	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
100	BRDLGTYP	VARCHAR2	Gear type making up the bridles/legs 0=unknown, 1=chain, 2=cable/wire
100	BRDTPLEN	NUMBER	Length of top bridle, in whole fathoms.
100	FTROPTYP	VARCHAR2	Foot rope / sweep type; see OBGRNDGEAR table.
100	NSWEEPS	NUMBER	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
100	SWEEPDIA	NUMBER	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 /
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	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	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	KITPNWID	NUMBER	Average width of panels used in kite in net, in whole inches.\| added to OTG 1-08
100	KITPNLEN	NUMBER	Average length of panels used in kite in net, in whole inches. \| added to OTG 1-08
100	OTGCOMMENTS	VARCHAR2	Comments on trawl gear record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable.
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	TEDEXTMSTYP	VARCHAR2	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).
100	ASMTEST_STATUS	VARCHAR2	Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested

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

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

HDROPLEN

NUMBER

Length of the head rope, in feet.

100

FTROPLEN

NUMBER

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

100

GRCABLEN

NUMBER

Length of wire connecting the bridles and back strap, in fathoms (previous to 5/2007 was in feet)

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

GRCABTYP

VARCHAR2

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

100

BRDLGTYP

VARCHAR2

Gear type making up the bridles/legs 0=unknown, 1=chain, 2=cable/wire

100

BRDTPLEN

NUMBER

Length of top bridle, in whole fathoms.

100

FTROPTYP

VARCHAR2

Foot rope / sweep type; see OBGRNDGEAR table.

100

NSWEEPS

NUMBER

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

100

SWEEPDIA

NUMBER

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 /

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

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

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

KITPNWID

NUMBER

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

100

KITPNLEN

NUMBER

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

100

OTGCOMMENTS

VARCHAR2

Comments on trawl gear record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable.

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

TEDEXTMSTYP

VARCHAR2

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).

100

ASMTEST_STATUS

VARCHAR2

Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested

Attribute Details

LINK4

CC ID: 334104

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	17
Required:	Yes
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: 334115

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: 334126

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: 334137

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: 334148

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: 334159

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: 334163

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: 334164

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

DOORUSD

CC ID: 334165

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: 334105

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: 334106

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	Yes
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: 334107

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	Yes
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: 334108

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

NETMAT

CC ID: 334109

Seq. Order:	14
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: 334110

Seq. Order:	15
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

HDROPLEN

CC ID: 334111

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

FTROPLEN

CC ID: 334112

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

GRCABLEN

CC ID: 334113

Seq. Order:	18
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Length of wire connecting the bridles and back strap, in fathoms (previous to 5/2007 was in feet)
General Data Type:	NUMBER

CIRCLEMC

CC ID: 334114

Seq. Order:	19
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: 334116

Seq. Order:	20
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

GRCABTYP

CC ID: 334117

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

BRDLGTYP

CC ID: 334118

Seq. Order:	22
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Gear type making up the bridles/legs 0=unknown, 1=chain, 2=cable/wire
General Data Type:	VARCHAR2

BRDTPLEN

CC ID: 334119

Seq. Order:	23
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

FTROPTYP

CC ID: 334120

Seq. Order:	24
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Foot rope / sweep type; see OBGRNDGEAR table.
General Data Type:	VARCHAR2

NSWEEPS

CC ID: 334121

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

SWEEPDIA

CC ID: 334122

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

NFLOATS

CC ID: 334123

Seq. Order:	27
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: 334124

Seq. Order:	28
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: 334125

Seq. Order:	29
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
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: 334127

Seq. Order:	30
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
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: 334128

Seq. Order:	31
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: 334129

Seq. Order:	32
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
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: 334130

Seq. Order:	33
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
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: 334131

Seq. Order:	34
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: 334132

Seq. Order:	35
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: 334133

Seq. Order:	36
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: 334134

Seq. Order:	37
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: 334135

Seq. Order:	38
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: 334136

Seq. Order:	39
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: 334138

Seq. Order:	40
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

EXCLUSD

CC ID: 334139

Seq. Order:	41
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
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: 334140

Seq. Order:	42
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: 334141

Seq. Order:	43
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
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: 334142

Seq. Order:	44
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
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: 334143

Seq. Order:	45
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
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: 334144

Seq. Order:	46
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
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: 334145

Seq. Order:	47
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: 334146

Seq. Order:	48
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: 334147

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

ESCAPOUTLENMC

CC ID: 334149

Seq. Order:	50
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: 334150

Seq. Order:	51
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: 334151

Seq. Order:	52
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

KITPNUSD

CC ID: 334152

Seq. Order:	53
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: 334153

Seq. Order:	54
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

KITPNWID

CC ID: 334154

Seq. Order:	55
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

KITPNLEN

CC ID: 334155

Seq. Order:	56
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

OTGCOMMENTS

CC ID: 334156

Seq. Order:	57
Data Storage Type:	VARCHAR2
Max Length:	250
Required:	No
Primary Key:	No
Status:	Active
Description:	Comments on trawl gear record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable.
General Data Type:	VARCHAR2

LINERMAT

CC ID: 334157

Seq. Order:	58
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: 334158

Seq. Order:	59
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: 334160

Seq. Order:	60
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

TEDEXTMSTYP

CC ID: 334161

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

ASMTEST_STATUS

CC ID: 334162

Seq. Order:	62
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested
General Data Type:	VARCHAR2

Catalog Item ID:	33556
GUID:	gov.noaa.nmfs.inport:33556
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

NETMAT

CODMAT

HDROPLEN

FTROPLEN

GRCABLEN

CIRCLEMC

CIRCLEMS

GRCABTYP

BRDLGTYP

BRDTPLEN

FTROPTYP

NSWEEPS

SWEEPDIA

NFLOATS

FLOATDIA

CODHUNG

CODTWINETYP

CODMSIZE

CODLINERUSD

LINERMSIZE

CODSTRENUSD

CODCHAFFUSD

GMELECTSUSD

NTRANS

TRANSTYP

TRANSBRD

TRANSLOCSTR

EXCLUSD

EXCLTYP

TEDEXTMS

ESCAPOUTUSD

ESCAPOUTLEN

ESCAPOUTWID

ESCAPOUTSHP

ESCAPOUTLOC

ESCAPOUTMS

ESCAPOUTLENMC

ESCAPOUTWIDMC

ESCAPOUTTYP

KITPNUSD

NKITPN

KITPNWID

KITPNLEN

OTGCOMMENTS

LINERMAT

LINERHUNG

LINERTWTYP

TEDEXTMSTYP

ASMTEST_STATUS

Catalog Details