TrwlInertTOW
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:36208 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Linkages Trawl-Inert-Items table Tow Data
DescriptionLinkages Trawl-Inert-Items table Tow Data
Entity Information
Entity Type
Data File
Data Attribute / Type | Description |
---|---|
key
VARCHAR |
concatenation of Cruise code and Standard Station number |
tkey
VARCHAR |
Trawl_concatenation of Cruise code, Standard Station number, tgear, and tow |
consta
INTEGER |
consecutive station number for a given cruise |
tgear
VARCHAR |
Trawl_gear (2meterBeamTrawl or Otter Trawl 16') |
tow
INTEGER |
consecutive tow number for a given cruise |
hauls
INTEGER |
haul number for the specific gear type |
tdur
DOUBLE PRECISION |
Trawl_duration of tow (min) |
itemCD
VARCHAR |
2-digit numerical species/item code |
vol_L
DOUBLE PRECISION |
volume filtered |
towvol1m
DOUBLE PRECISION |
volume filtered per 1m at tow |
stvol1m
DOUBLE PRECISION |
volume filtered per 1m at station |
count
DOUBLE PRECISION |
number of itemsCD |
towcount1m
DOUBLE PRECISION |
count per 1m at tow |
stcount1m
DOUBLE PRECISION |
count per 1m at station |
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: | TrwlInertTOW |
---|---|
Short Name: | TrwlInertTOW |
Status: | Completed |
Abstract: |
Linkages Trawl-Inert-Items table Tow Data |
Entity Information
Entity Type: | Data File |
---|---|
Active Version?: | Yes |
Description: |
Linkages Trawl-Inert-Items table Tow Data |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
N/A
|
key | VARCHAR | concatenation of Cruise code and Standard Station number | |
N/A
|
tkey | VARCHAR | Trawl_concatenation of Cruise code, Standard Station number, tgear, and tow | |
N/A
|
consta | INTEGER | consecutive station number for a given cruise | |
N/A
|
tgear | VARCHAR | Trawl_gear (2meterBeamTrawl or Otter Trawl 16') | |
N/A
|
tow | INTEGER | consecutive tow number for a given cruise | |
N/A
|
hauls | INTEGER | haul number for the specific gear type | |
N/A
|
tdur | DOUBLE PRECISION | Trawl_duration of tow (min) | |
N/A
|
itemCD | VARCHAR | 2-digit numerical species/item code | |
N/A
|
vol_L | DOUBLE PRECISION | volume filtered | |
N/A
|
towvol1m | DOUBLE PRECISION | volume filtered per 1m at tow | |
N/A
|
stvol1m | DOUBLE PRECISION | volume filtered per 1m at station | |
N/A
|
count | DOUBLE PRECISION | number of itemsCD | |
N/A
|
towcount1m | DOUBLE PRECISION | count per 1m at tow | |
N/A
|
stcount1m | DOUBLE PRECISION | count per 1m at station |
Attribute Details
key
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR |
Max Length: | 8 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
concatenation of Cruise code and Standard Station number |
General Data Type: | VARCHAR |
tkey
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR |
Max Length: | 14 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Trawl_concatenation of Cruise code, Standard Station number, tgear, and tow |
General Data Type: | VARCHAR |
consta
Seq. Order: | 3 |
---|---|
Data Storage Type: | INTEGER |
Max Length: | 2 |
Required: | Yes |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
consecutive station number for a given cruise |
General Data Type: | INTEGER |
tgear
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR |
Max Length: | 4 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Trawl_gear (2meterBeamTrawl or Otter Trawl 16') |
General Data Type: | VARCHAR |
tow
Seq. Order: | 5 |
---|---|
Data Storage Type: | INTEGER |
Max Length: | 2 |
Required: | Yes |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
consecutive tow number for a given cruise |
General Data Type: | INTEGER |
hauls
Seq. Order: | 6 |
---|---|
Data Storage Type: | INTEGER |
Max Length: | 2 |
Required: | Yes |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
haul number for the specific gear type |
General Data Type: | INTEGER |
tdur
Seq. Order: | 7 |
---|---|
Data Storage Type: | DOUBLE PRECISION |
Max Length: | 8 |
Required: | Yes |
Primary Key: | No |
Precision: | 16 |
Scale: | 14 |
Status: | Active |
Description: |
Trawl_duration of tow (min) |
General Data Type: | DOUBLE PRECISION |
itemCD
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR |
Max Length: | 2 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
2-digit numerical species/item code |
General Data Type: | VARCHAR |
vol_L
Seq. Order: | 9 |
---|---|
Data Storage Type: | DOUBLE PRECISION |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 3 |
Status: | Active |
Description: |
volume filtered |
General Data Type: | DOUBLE PRECISION |
towvol1m
Seq. Order: | 10 |
---|---|
Data Storage Type: | DOUBLE PRECISION |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Precision: | 16 |
Scale: | 15 |
Status: | Active |
Description: |
volume filtered per 1m at tow |
General Data Type: | DOUBLE PRECISION |
stvol1m
Seq. Order: | 11 |
---|---|
Data Storage Type: | DOUBLE PRECISION |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Precision: | 16 |
Scale: | 15 |
Status: | Active |
Description: |
volume filtered per 1m at station |
General Data Type: | DOUBLE PRECISION |
count
Seq. Order: | 12 |
---|---|
Data Storage Type: | DOUBLE PRECISION |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 1 |
Status: | Active |
Description: |
number of itemsCD |
General Data Type: | DOUBLE PRECISION |
towcount1m
Seq. Order: | 13 |
---|---|
Data Storage Type: | DOUBLE PRECISION |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Precision: | 16 |
Scale: | 15 |
Status: | Active |
Description: |
count per 1m at tow |
General Data Type: | DOUBLE PRECISION |
stcount1m
Seq. Order: | 14 |
---|---|
Data Storage Type: | DOUBLE PRECISION |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Precision: | 16 |
Scale: | 15 |
Status: | Active |
Description: |
count per 1m at station |
General Data Type: | DOUBLE PRECISION |
Catalog Details
Catalog Item ID: | 36208 |
---|---|
GUID: | gov.noaa.nmfs.inport:36208 |
Metadata Record Created By: | Patricia L Jones |
Metadata Record Created: | 2017-01-04 11:41+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2017-02-15 |
Owner Org: | NEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2017-02-15 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2018-02-15 |