Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Ecosystems & Aquaculture Division (EAD) > Habitat Ecology Branch (HEB) > Coastal Estuarine Linkages >

TrwlInvDETAILTOW

Entity (ENT) | Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:36210 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Linkages Trawl-Invertebrate-Detail table Tow Data

Description

Linkages Trawl-Invertebrate-Detail table Tow Data

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
TDur DOUBLE PRECISION	Trawl_duration of tow (min)
NODCcode VARCHAR	species taxonomic code from the National Oceanographic Data Center
StgSex VARCHAR	stage or gender of species
Catch INTEGER	Total number of species in the sample of a given taxon.
SpTowCat1m DOUBLE PRECISION	Density/Total catch by species adjusted & expressed as no./1m2 of sea-surface area per tow
Meas INTEGER	the total number of invertebrates measured at that station
Sizemm INTEGER	size of invertebrate (mm)
Num INTEGER	number of species at that size
SizTowDen1m DOUBLE PRECISION	tow density for that size group
SizStDen1m DOUBLE PRECISION	station density for that size group
Vol_L DOUBLE PRECISION	volume filtered
TowVol1m DOUBLE PRECISION	volume filtered per 1m at tow
stvol1m DOUBLE PRECISION	volume filtered per 1m at station

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

TDur
DOUBLE PRECISION

Trawl_duration of tow (min)

NODCcode
VARCHAR

species taxonomic code from the National Oceanographic Data Center

StgSex
VARCHAR

stage or gender of species

Catch
INTEGER

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

SpTowCat1m
DOUBLE PRECISION

Density/Total catch by species adjusted & expressed as no./1m2 of sea-surface area per tow

Meas
INTEGER

the total number of invertebrates measured at that station

Sizemm
INTEGER

size of invertebrate (mm)

Num
INTEGER

number of species at that size

SizTowDen1m
DOUBLE PRECISION

tow density for that size group

SizStDen1m
DOUBLE PRECISION

station density for that size group

Vol_L
DOUBLE PRECISION

volume filtered

TowVol1m
DOUBLE PRECISION

volume filtered per 1m at tow

stvol1m
DOUBLE PRECISION

volume filtered per 1m at station

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (NEFSC) for inquiries on this record.

Title:	TrwlInvDETAILTOW
Short Name:	TrwlInvDETAILTOW
Status:	Completed
Abstract:	Linkages Trawl-Invertebrate-Detail table Tow Data

Entity Type:	Data File
Active Version?:	Yes
Description:	Linkages Trawl-Invertebrate-Detail table Tow Data

Note: Metadata requirements do not apply to attributes for non-tabular entities.

Attribute Summary

	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	TDur	DOUBLE PRECISION	Trawl_duration of tow (min)
N/A	NODCcode	VARCHAR	species taxonomic code from the National Oceanographic Data Center
N/A	StgSex	VARCHAR	stage or gender of species
N/A	Catch	INTEGER	Total number of species in the sample of a given taxon.
N/A	SpTowCat1m	DOUBLE PRECISION	Density/Total catch by species adjusted & expressed as no./1m2 of sea-surface area per tow
N/A	Meas	INTEGER	the total number of invertebrates measured at that station
N/A	Sizemm	INTEGER	size of invertebrate (mm)
N/A	Num	INTEGER	number of species at that size
N/A	SizTowDen1m	DOUBLE PRECISION	tow density for that size group
N/A	SizStDen1m	DOUBLE PRECISION	station density for that size group
N/A	Vol_L	DOUBLE PRECISION	volume filtered
N/A	TowVol1m	DOUBLE PRECISION	volume filtered per 1m at tow
N/A	stvol1m	DOUBLE PRECISION	volume filtered per 1m at station

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

TDur

DOUBLE PRECISION

Trawl_duration of tow (min)

N/A

NODCcode

VARCHAR

species taxonomic code from the National Oceanographic Data Center

N/A

StgSex

VARCHAR

stage or gender of species

N/A

Catch

INTEGER

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

N/A

SpTowCat1m

DOUBLE PRECISION

Density/Total catch by species adjusted & expressed as no./1m2 of sea-surface area per tow

N/A

Meas

INTEGER

the total number of invertebrates measured at that station

N/A

Sizemm

INTEGER

size of invertebrate (mm)

N/A

Num

INTEGER

number of species at that size

N/A

SizTowDen1m

DOUBLE PRECISION

tow density for that size group

N/A

SizStDen1m

DOUBLE PRECISION

station density for that size group

N/A

Vol_L

DOUBLE PRECISION

volume filtered

N/A

TowVol1m

DOUBLE PRECISION

volume filtered per 1m at tow

N/A

stvol1m

DOUBLE PRECISION

volume filtered per 1m at station

Attribute Details

Key

CC ID: 372305

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: 372306

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: 372307

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: 372308

Seq. Order:	4
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

Tow

CC ID: 372309

Seq. Order:	5
Data Storage Type:	INTEGER
Max Length:	2
Required:	Yes
Primary Key:	No
Precision:	1
Scale:	0
Status:	Active
Description:	consecutive tow number for a given cruise
General Data Type:	INTEGER

Hauls

CC ID: 372310

Seq. Order:	6
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

TDur

CC ID: 372311

Seq. Order:	7
Data Storage Type:	DOUBLE PRECISION
Max Length:	8
Required:	Yes
Primary Key:	No
Precision:	15
Scale:	14
Status:	Active
Description:	Trawl_duration of tow (min)
General Data Type:	DOUBLE PRECISION

NODCcode

CC ID: 372312

Seq. Order:	8
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

StgSex

CC ID: 372313

Seq. Order:	9
Data Storage Type:	VARCHAR
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	stage or gender of species
General Data Type:	VARCHAR

Catch

CC ID: 372314

Seq. Order:	10
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

SpTowCat1m

CC ID: 372315

Seq. Order:	11
Data Storage Type:	DOUBLE PRECISION
Max Length:	8
Required:	No
Primary Key:	No
Precision:	16
Scale:	14
Status:	Active
Description:	Density/Total catch by species adjusted & expressed as no./1m2 of sea-surface area per tow
General Data Type:	DOUBLE PRECISION

Meas

CC ID: 372316

Seq. Order:	12
Data Storage Type:	INTEGER
Max Length:	2
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	the total number of invertebrates measured at that station
General Data Type:	INTEGER

Sizemm

CC ID: 372317

Seq. Order:	13
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

Num

CC ID: 372318

Seq. Order:	14
Data Storage Type:	INTEGER
Max Length:	2
Required:	No
Primary Key:	No
Precision:	1
Scale:	0
Status:	Active
Description:	number of species at that size
General Data Type:	INTEGER

SizTowDen1m

CC ID: 372319

Seq. Order:	15
Data Storage Type:	DOUBLE PRECISION
Max Length:	8
Required:	No
Primary Key:	No
Precision:	16
Scale:	15
Status:	Active
Description:	tow density for that size group
General Data Type:	DOUBLE PRECISION

SizStDen1m

CC ID: 372320

Seq. Order:	16
Data Storage Type:	DOUBLE PRECISION
Max Length:	8
Required:	No
Primary Key:	No
Precision:	16
Scale:	15
Status:	Active
Description:	station density for that size group
General Data Type:	DOUBLE PRECISION

Vol_L

CC ID: 372321

Seq. Order:	17
Data Storage Type:	DOUBLE PRECISION
Max Length:	8
Required:	No
Primary Key:	No
Precision:	4
Scale:	3
Status:	Active
Description:	volume filtered
General Data Type:	DOUBLE PRECISION

TowVol1m

CC ID: 372322

Seq. Order:	18
Data Storage Type:	DOUBLE PRECISION
Max Length:	8
Required:	No
Primary Key:	No
Precision:	17
Scale:	16
Status:	Active
Description:	volume filtered per 1m at tow
General Data Type:	DOUBLE PRECISION

stvol1m

CC ID: 372323

Seq. Order:	19
Data Storage Type:	DOUBLE PRECISION
Max Length:	8
Required:	No
Primary Key:	No
Precision:	17
Scale:	16
Status:	Active
Description:	volume filtered per 1m at station
General Data Type:	DOUBLE PRECISION

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

TrwlInvDETAILTOW

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

Key

TKey

Consta

TGear

Tow

Hauls

TDur

NODCcode

StgSex

Catch

SpTowCat1m

Meas

Sizemm

Num

SizTowDen1m

SizStDen1m

Vol_L

TowVol1m

stvol1m

Catalog Details