Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: TrwlInvertSta
Short Name: TrwlInvertSta
Status: Completed
Abstract:

Linkages Trawl-Invertebrate table Station Data

Entity Information

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

Linkages Trawl-Invertebrate 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
NODCcode VARCHAR species taxonomic code from the National Oceanographic Data Center
N/A
SpStaCat INTEGER species catch at station
N/A
SpStaCat1m DOUBLE PRECISION species catch at station per 1m
N/A
SpStaVol DOUBLE PRECISION species volume at station
N/A
SpStaVol1m DOUBLE PRECISION species volume at station per 1m

Attribute Details

Key

CC ID: 372324
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: 372325
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: 372326
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: 372327
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

NODCcode

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

species taxonomic code from the National Oceanographic Data Center

General Data Type: VARCHAR

SpStaCat

CC ID: 372329
Seq. Order: 6
Data Storage Type: INTEGER
Max Length: 2
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

species catch at station

General Data Type: INTEGER

SpStaCat1m

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

species catch at station per 1m

General Data Type: DOUBLE PRECISION

SpStaVol

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

species volume at station

General Data Type: DOUBLE PRECISION

SpStaVol1m

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

species volume at station per 1m

General Data Type: DOUBLE PRECISION

Catalog Details

Catalog Item ID: 36211
GUID: gov.noaa.nmfs.inport:36211
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2017-01-04 11:42+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