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

Summary

Abstract

At Sea Monitor Otter Trawl Hauls

Description

At Sea Monitor Otter Trawl Hauls

Entity Information

Entity Type
Data View

Data Attribute / Type Description
LINK3
VARCHAR2
Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. Collected for ASM where applicable.
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.
HAULNUM
VARCHAR2
Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable.
GEARNUM
VARCHAR2
Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
TOWSPEED
NUMBER
Average towing speed over bottom, to nearest 10th of knot.
WIREOUT
NUMBER
Amount of wire paid out for haul, in whole fathoms.
NTURNS
NUMBER
Number of turns > 90 degrees in haul; begun 3/2007
NETOVERT
NUMBER
Average distance from the top to bottom of mouth of net while fishing; whole feet; begun 3/2007
NETOHORIZ
NUMBER
Average width of netmouth wing tip -> wing tip while fishing; whole feet; begun 3/2007
DOORSPREAD
NUMBER
Average distance between the doors while fishing; whole feet; begun 3/2007
PUMPBEGINDATE
DATE
Day,month,year in local time that fish pumping is attached to codend and initially turned on
PUMPENDDATE
DATE
Day,month,year in local time that fish pump is turned off and fish are no longer coming out of the dewatering box.
OTHCOMMENTS
VARCHAR2
Comments on trawl haul record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable.
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: ASMOTH
Short Name: ASMOTH
Status: Completed
Abstract:

At Sea Monitor Otter Trawl Hauls

Notes:

Loaded by batch 8948, 07-06-2016 08:22

Entity Information

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

At Sea Monitor Otter Trawl Hauls

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
LINK3 VARCHAR2 Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. Collected for ASM where applicable.
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
HAULNUM VARCHAR2 Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable.
100
GEARNUM VARCHAR2 Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
100
TOWSPEED NUMBER Average towing speed over bottom, to nearest 10th of knot.
100
WIREOUT NUMBER Amount of wire paid out for haul, in whole fathoms.
100
NTURNS NUMBER Number of turns > 90 degrees in haul; begun 3/2007
100
NETOVERT NUMBER Average distance from the top to bottom of mouth of net while fishing; whole feet; begun 3/2007
100
NETOHORIZ NUMBER Average width of netmouth wing tip -> wing tip while fishing; whole feet; begun 3/2007
100
DOORSPREAD NUMBER Average distance between the doors while fishing; whole feet; begun 3/2007
100
PUMPBEGINDATE DATE Day,month,year in local time that fish pumping is attached to codend and initially turned on
100
PUMPENDDATE DATE Day,month,year in local time that fish pump is turned off and fish are no longer coming out of the dewatering box.
100
OTHCOMMENTS VARCHAR2 Comments on trawl haul record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable.
100
ASMTEST_STATUS VARCHAR2 Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested

Attribute Details

LINK3

CC ID: 329261
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 19
Required: Yes
Primary Key: No
Status: Active
Description:

Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. Collected for ASM where applicable.

General Data Type: VARCHAR2

LINK4

CC ID: 329272
Seq. Order: 2
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: 329273
Seq. Order: 3
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: 329274
Seq. Order: 4
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: 329275
Seq. Order: 5
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: 329276
Seq. Order: 6
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: 329277
Seq. Order: 7
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

HAULNUM

CC ID: 329278
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable.

General Data Type: VARCHAR2

GEARNUM

CC ID: 329279
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 2
Required: Yes
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

TOWSPEED

CC ID: 329262
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 1
Status: Active
Description:

Average towing speed over bottom, to nearest 10th of knot.

General Data Type: NUMBER

WIREOUT

CC ID: 329263
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Amount of wire paid out for haul, in whole fathoms.

General Data Type: NUMBER

NTURNS

CC ID: 329264
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Number of turns > 90 degrees in haul; begun 3/2007

General Data Type: NUMBER

NETOVERT

CC ID: 329265
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Average distance from the top to bottom of mouth of net while fishing; whole feet; begun 3/2007

General Data Type: NUMBER

NETOHORIZ

CC ID: 329266
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Average width of netmouth wing tip -> wing tip while fishing; whole feet; begun 3/2007

General Data Type: NUMBER

DOORSPREAD

CC ID: 329267
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Average distance between the doors while fishing; whole feet; begun 3/2007

General Data Type: NUMBER

PUMPBEGINDATE

CC ID: 329268
Seq. Order: 16
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Day,month,year in local time that fish pumping is attached to codend and initially turned on

General Data Type: DATE

PUMPENDDATE

CC ID: 329269
Seq. Order: 17
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Day,month,year in local time that fish pump is turned off and fish are no longer coming out of the dewatering box.

General Data Type: DATE

OTHCOMMENTS

CC ID: 329270
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 250
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

ASMTEST_STATUS

CC ID: 329271
Seq. Order: 19
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: 33279
GUID: gov.noaa.nmfs.inport:33279
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-07-06 08:22+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