Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Fisheries Sampling Branch (FSB) > Observer and At Sea Monitor Database (OBDBS) >

View: OBOTG

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:33568  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Observer Otter Trawl Gear Characteristics

Description

Observer Otter Trawl Gear Characteristics

Entity Information

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

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: View: OBOTG
Short Name: OBOTG
Status: Completed
Abstract:

Observer Otter Trawl Gear Characteristics
Notes:

Loaded by batch 9053, 07-27-2016 19:10

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: OBDBS
Description:

Observer Otter Trawl Gear Characteristics

Data Attributes

Attribute Summary

Rubric Score Primary Key? 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).

Attribute Details

LINK4

CC ID: 334648
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: 334659
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: 334670
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: 334681
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: 334692
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: 334703
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: 334706
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: 334707
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: 334708
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: 334649
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: 334650
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: 334651
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: 334652
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: 334653
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: 334654
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: 334655
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: 334656
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: 334657
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: 334658
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: 334660
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: 334661
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: 334662
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: 334663
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: 334664
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: 334665
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: 334666
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: 334667
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: 334668
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: 334669
Seq. Order: 29
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: 334671
Seq. Order: 30
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: 334672
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: 334673
Seq. Order: 32
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: 334674
Seq. Order: 33
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: 334675
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: 334676
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: 334677
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: 334678
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: 334679
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: 334680
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: 334682
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: 334683
Seq. Order: 41
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: 334684
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: 334685
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: 334686
Seq. Order: 44
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: 334687
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: 334688
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: 334689
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: 334690
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: 334691
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: 334693
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: 334694
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: 334695
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: 334696
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: 334697
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: 334698
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: 334699
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: 334700
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: 334701
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: 334702
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: 334704
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: 334705
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

Catalog Details

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