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

Summary

Abstract

Linkages Trawl-Inert-Items table Tow Data

Description

Linkages 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

Note: Metadata requirements do not apply to attributes for non-tabular entities.

Attribute Summary

Rubric Score Primary Key? 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

CC ID: 372283
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

CC ID: 372284
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

CC ID: 372285
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

CC ID: 372286
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

CC ID: 372287
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

CC ID: 372288
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

CC ID: 372289
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

CC ID: 372290
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

CC ID: 372291
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

CC ID: 372292
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

CC ID: 372293
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

CC ID: 372294
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

CC ID: 372295
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

CC ID: 372296
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