Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

At Sea Monitor Otter Trawl Gear Characteristics

Description

At Sea Monitor 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).
ASMTEST_STATUS
VARCHAR2
Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested

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

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

At Sea Monitor 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).
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 Details

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