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

Summary

Abstract

Linkages Trawl-Invertebrate table Tow Data

Description

Linkages Trawl-Invertebrate 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
NODCcode
VARCHAR
species taxonomic code from the National Oceanographic Data Center
Catch
INTEGER
Total number of species in the sample of a given taxon.
TowCat1m
DOUBLE PRECISION
catch per 1m at tow
Vol_L
DOUBLE PRECISION
volume filtered
TowVol1m
DOUBLE PRECISION
volume filtered per 1m at tow
detail
INTEGER
reference to another attribute table

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

Linkages Trawl-Invertebrate table Tow Data

Entity Information

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

Linkages Trawl-Invertebrate 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
NODCcode VARCHAR species taxonomic code from the National Oceanographic Data Center
N/A
Catch INTEGER Total number of species in the sample of a given taxon.
N/A
TowCat1m DOUBLE PRECISION catch per 1m at tow
N/A
Vol_L DOUBLE PRECISION volume filtered
N/A
TowVol1m DOUBLE PRECISION volume filtered per 1m at tow
N/A
detail INTEGER reference to another attribute table

Attribute Details

Key

CC ID: 372333
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: 372334
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: 372335
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: 372336
Seq. Order: 4
Data Storage Type: VARCHAR
Max Length: 14
Required: Yes
Primary Key: No
Status: Active
Description:

Trawl_gear (2meterBeamTrawl or Otter Trawl 16')

General Data Type: VARCHAR

Tow

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

consecutive tow number for a given cruise

General Data Type: INTEGER

Hauls

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

haul number for the specific gear type

General Data Type: INTEGER

NODCcode

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

Catch

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

Total number of species in the sample of a given taxon.

General Data Type: INTEGER

TowCat1m

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

catch per 1m at tow

General Data Type: DOUBLE PRECISION

Vol_L

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

volume filtered

General Data Type: DOUBLE PRECISION

TowVol1m

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

volume filtered per 1m at tow

General Data Type: DOUBLE PRECISION

detail

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

reference to another attribute table

General Data Type: INTEGER

Catalog Details

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