Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Ecosystems & Aquaculture Division (EAD) > Habitat Ecology Branch (HEB) > Coastal Estuarine Linkages >

TrwlInvDETAILSTA

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:36209  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Linkages Trawl-Invertebrate-Detail table Station Data

Description

Linkages Trawl-Invertebrate-Detail 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
SpStaDen1m
DOUBLE PRECISION 		species density per 1m at station
Sizemm
INTEGER 		size of invertebrate (mm)
SizDenSt1m
DOUBLE PRECISION 		species density by size 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: TrwlInvDETAILSTA
Short Name: TrwlInvDETAILSTA
Status: Completed
Abstract:

Linkages Trawl-Invertebrate-Detail table Station Data

Entity Information

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

Linkages Trawl-Invertebrate-Detail 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
 SpStaDen1m DOUBLE PRECISION species density per 1m at station
N/A
 Sizemm INTEGER size of invertebrate (mm)
N/A
 SizDenSt1m DOUBLE PRECISION species density by size per 1m at station

Attribute Details

Key

CC ID: 372297
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: 372298
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: 372299
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: 372300
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: 372301
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

SpStaDen1m

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

species density per 1m at station
General Data Type: DOUBLE PRECISION

Sizemm

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

size of invertebrate (mm)
General Data Type: INTEGER

SizDenSt1m

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

species density by size per 1m at station
General Data Type: DOUBLE PRECISION

Catalog Details

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