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

Summary

Abstract

Linkages Trawl-Invertebrate table Station Data

Description

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