View: ASMOTH
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33279 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
At Sea Monitor Otter Trawl Hauls
DescriptionAt 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |