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

Summary

Abstract

Linkages Trawl-Inert-Items table Station Data

Description

Linkages Trawl-Inert-Items table Station Data

Entity Information

Entity Type
Data File

Data Attribute / Type Description
key
VARCHAR
concatenation of Cruise code and Standard Station number
consta
INTEGER
consecutive station number for a given cruise
tgear
VARCHAR
Trawl_gear (2meterBeamTrawl or Otter Trawl 16')
hauls
INTEGER
haul number for the specific gear type
itemcode
VARCHAR
2-digit numerical species/item code
StaVolSum
DOUBLE PRECISION
the sum of the volume at each station where species were collected
StaVol1m
DOUBLE PRECISION
the sum of the volume at each station where species were collected per 1m
StaCountSum
DOUBLE PRECISION
the sum of the count at each station where species were collected
StaCount1m
DOUBLE PRECISION
the sum of the count at each station where species were collected per 1m

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: TrwlInertSTA
Short Name: TrwlInertSTA
Status: Completed
Abstract:

Linkages Trawl-Inert-Items table Station Data

Entity Information

Entity Type: Data File
Active Version?: Yes
Description:

Linkages Trawl-Inert-Items table Station 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
consta INTEGER consecutive station number for a given cruise
N/A
tgear VARCHAR Trawl_gear (2meterBeamTrawl or Otter Trawl 16')
N/A
hauls INTEGER haul number for the specific gear type
N/A
itemcode VARCHAR 2-digit numerical species/item code
N/A
StaVolSum DOUBLE PRECISION the sum of the volume at each station where species were collected
N/A
StaVol1m DOUBLE PRECISION the sum of the volume at each station where species were collected per 1m
N/A
StaCountSum DOUBLE PRECISION the sum of the count at each station where species were collected
N/A
StaCount1m DOUBLE PRECISION the sum of the count at each station where species were collected per 1m

Attribute Details

key

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

consta

CC ID: 372275
Seq. Order: 2
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: 372276
Seq. Order: 3
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

hauls

CC ID: 372277
Seq. Order: 4
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

itemcode

CC ID: 372278
Seq. Order: 5
Data Storage Type: VARCHAR
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

2-digit numerical species/item code

General Data Type: VARCHAR

StaVolSum

CC ID: 372279
Seq. Order: 6
Data Storage Type: DOUBLE PRECISION
Max Length: 8
Required: No
Primary Key: No
Precision: 4
Scale: 2
Status: Active
Description:

the sum of the volume at each station where species were collected

General Data Type: DOUBLE PRECISION

StaVol1m

CC ID: 372280
Seq. Order: 7
Data Storage Type: DOUBLE PRECISION
Max Length: 8
Required: No
Primary Key: No
Precision: 18
Scale: 16
Status: Active
Description:

the sum of the volume at each station where species were collected per 1m

General Data Type: DOUBLE PRECISION

StaCountSum

CC ID: 372281
Seq. Order: 8
Data Storage Type: DOUBLE PRECISION
Max Length: 8
Required: No
Primary Key: No
Precision: 3
Scale: 1
Status: Active
Description:

the sum of the count at each station where species were collected

General Data Type: DOUBLE PRECISION

StaCount1m

CC ID: 372282
Seq. Order: 9
Data Storage Type: DOUBLE PRECISION
Max Length: 8
Required: No
Primary Key: No
Precision: 18
Scale: 16
Status: Active
Description:

the sum of the count at each station where species were collected per 1m

General Data Type: DOUBLE PRECISION

Catalog Details

Catalog Item ID: 36207
GUID: gov.noaa.nmfs.inport:36207
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