View: OBPRH
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33307 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Observer Pair Trawl Hauls
DescriptionObserver Pair 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. |
HRDEPMIN
NUMBER |
Shallowest depth from surface the headrope fished, in whole fathoms. |
HRDEPMAX
NUMBER |
Deepest depth from surface the headrope fished, in whole fathoms. |
DISTMIN
NUMBER |
Shortest distance between two boats while fishing, in whole feet. |
DISTMAX
NUMBER |
Longest distance between two boats while fishing, in whole feet. |
PUMPBEGINYEAR
VARCHAR2 |
Year in local time that fish pumping is attached to codend and initially turned on |
PUMPBEGINMONTH
VARCHAR2 |
Month in local time that fish pumping is attached to codend and initially turned on |
PUMPBEGINDAY
VARCHAR2 |
Day in local time that fish pumping is attached to codend and initially turned on |
PUMPBEGINTIME
VARCHAR2 |
Time in local time that fish pumping is attached to codend and initially turned on |
PUMPENDYEAR
VARCHAR2 |
Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box. |
PUMPENDMONTH
VARCHAR2 |
Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box. |
PUMPENDDAY
VARCHAR2 |
Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box. |
PUMPENDTIME
VARCHAR2 |
Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box. |
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 |
PRHCOMMENTS
VARCHAR2 |
Additional information re: PaiR trawl Haul. |
DOE
DATE |
Date of Entry of the associated record. |
UOE
VARCHAR2 |
Oracle user ID of the person who entered the data. |
DOC
DATE |
Date associated record was updated. |
UOC
VARCHAR2 |
Oracle ID of user who made the (most recent ) change on the record. |
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: OBPRH |
---|---|
Short Name: | OBPRH |
Status: | Completed |
Abstract: |
Observer Pair Trawl Hauls |
Notes: |
Loaded by batch 8949, 07-06-2016 08:23 |
Entity Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Schema Name: | OBDBS |
Description: |
Observer Pair 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
|
HRDEPMIN | NUMBER | Shallowest depth from surface the headrope fished, in whole fathoms. | |
100
|
HRDEPMAX | NUMBER | Deepest depth from surface the headrope fished, in whole fathoms. | |
100
|
DISTMIN | NUMBER | Shortest distance between two boats while fishing, in whole feet. | |
100
|
DISTMAX | NUMBER | Longest distance between two boats while fishing, in whole feet. | |
100
|
PUMPBEGINYEAR | VARCHAR2 | Year in local time that fish pumping is attached to codend and initially turned on | |
100
|
PUMPBEGINMONTH | VARCHAR2 | Month in local time that fish pumping is attached to codend and initially turned on | |
100
|
PUMPBEGINDAY | VARCHAR2 | Day in local time that fish pumping is attached to codend and initially turned on | |
100
|
PUMPBEGINTIME | VARCHAR2 | Time in local time that fish pumping is attached to codend and initially turned on | |
100
|
PUMPENDYEAR | VARCHAR2 | Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box. | |
100
|
PUMPENDMONTH | VARCHAR2 | Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box. | |
100
|
PUMPENDDAY | VARCHAR2 | Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box. | |
100
|
PUMPENDTIME | VARCHAR2 | Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box. | |
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
|
PRHCOMMENTS | VARCHAR2 | Additional information re: PaiR trawl Haul. | |
100
|
DOE | DATE | Date of Entry of the associated record. | |
100
|
UOE | VARCHAR2 | Oracle user ID of the person who entered the data. | |
100
|
DOC | DATE | Date associated record was updated. | |
100
|
UOC | VARCHAR2 | Oracle ID of user who made the (most recent ) change on the record. |
Attribute Details
LINK3
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 19 |
Required: | No |
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: | 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 |
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: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Amount of wire paid out for haul, in whole fathoms. |
General Data Type: | NUMBER |
HRDEPMIN
Seq. Order: | 12 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Shallowest depth from surface the headrope fished, in whole fathoms. |
General Data Type: | NUMBER |
HRDEPMAX
Seq. Order: | 13 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Deepest depth from surface the headrope fished, in whole fathoms. |
General Data Type: | NUMBER |
DISTMIN
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Shortest distance between two boats while fishing, in whole feet. |
General Data Type: | NUMBER |
DISTMAX
Seq. Order: | 15 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Longest distance between two boats while fishing, in whole feet. |
General Data Type: | NUMBER |
PUMPBEGINYEAR
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Year in local time that fish pumping is attached to codend and initially turned on |
General Data Type: | VARCHAR2 |
PUMPBEGINMONTH
Seq. Order: | 17 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Month in local time that fish pumping is attached to codend and initially turned on |
General Data Type: | VARCHAR2 |
PUMPBEGINDAY
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Day in local time that fish pumping is attached to codend and initially turned on |
General Data Type: | VARCHAR2 |
PUMPBEGINTIME
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Time in local time that fish pumping is attached to codend and initially turned on |
General Data Type: | VARCHAR2 |
PUMPENDYEAR
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box. |
General Data Type: | VARCHAR2 |
PUMPENDMONTH
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box. |
General Data Type: | VARCHAR2 |
PUMPENDDAY
Seq. Order: | 22 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box. |
General Data Type: | VARCHAR2 |
PUMPENDTIME
Seq. Order: | 23 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Time in local time that fish when fish pump is turned off and fish are no longer coming out of the dewatering box. |
General Data Type: | VARCHAR2 |
NTURNS
Seq. Order: | 24 |
---|---|
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: | 25 |
---|---|
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: | 26 |
---|---|
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: | 27 |
---|---|
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 |
PRHCOMMENTS
Seq. Order: | 28 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 250 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Additional information re: PaiR trawl Haul. |
General Data Type: | VARCHAR2 |
DOE
Seq. Order: | 29 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date of Entry of the associated record. |
General Data Type: | DATE |
UOE
Seq. Order: | 30 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Oracle user ID of the person who entered the data. |
General Data Type: | VARCHAR2 |
DOC
Seq. Order: | 31 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date associated record was updated. |
General Data Type: | DATE |
UOC
Seq. Order: | 32 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Oracle ID of user who made the (most recent ) change on the record. |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 33307 |
---|---|
GUID: | gov.noaa.nmfs.inport:33307 |
Metadata Record Created By: | Patricia L Jones |
Metadata Record Created: | 2016-07-06 08:23+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 |