Slide Menu
Jump to Section...
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 

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