View: ASMOTG
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33556 | Updated: August 9, 2022 | Published / External
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
|
|
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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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 |