Metadata Rubric

100%

6 / 6

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

LnkTrwlFishTow

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Linkages Trawl-Fish table Tow Data

Description

Linkages Trawl-Fish 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)
taxcode INTEGER	9-digit species code for fish
TowCatch INTEGER	the total number of fish larvae in the catch at that station
meas INTEGER	the total number of fish larvae measured at that station
len INTEGER	the length of each fish larvae measured
num INTEGER	the number of fish larvae at that length
Ldentow1m DOUBLE PRECISION	Density/Total catch by length adjusted & expressed as no./1m2 of sea-surface area per tow
Ldensta1m DOUBLE PRECISION	Density/Total catch by length adjusted & expressed as no./1m2 of sea-surface area per station
SpTowCat1m DOUBLE PRECISION	Density/Total catch by species adjusted & expressed as no./1m2 of sea-surface area per tow

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)

taxcode
INTEGER

9-digit species code for fish

TowCatch
INTEGER

the total number of fish larvae in the catch at that station

meas
INTEGER

the total number of fish larvae measured at that station

len
INTEGER

the length of each fish larvae measured

num
INTEGER

the number of fish larvae at that length

Ldentow1m
DOUBLE PRECISION

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

Ldensta1m
DOUBLE PRECISION

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

SpTowCat1m
DOUBLE PRECISION

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

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:	LnkTrwlFishTow
Short Name:	LnkTrwlFishTow
Status:	Completed
Abstract:	Linkages Trawl-Fish table Tow Data

Entity Type:	Data File
Active Version?:	Yes
Description:	Linkages Trawl-Fish 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	taxcode	INTEGER	9-digit species code for fish
N/A	TowCatch	INTEGER	the total number of fish larvae in the catch at that station
N/A	meas	INTEGER	the total number of fish larvae measured at that station
N/A	len	INTEGER	the length of each fish larvae measured
N/A	num	INTEGER	the number of fish larvae at that length
N/A	Ldentow1m	DOUBLE PRECISION	Density/Total catch by length adjusted & expressed as no./1m2 of sea-surface area per tow
N/A	Ldensta1m	DOUBLE PRECISION	Density/Total catch by length adjusted & expressed as no./1m2 of sea-surface area per station
N/A	SpTowCat1m	DOUBLE PRECISION	Density/Total catch by species adjusted & expressed as no./1m2 of sea-surface area per tow

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

taxcode

INTEGER

9-digit species code for fish

N/A

TowCatch

INTEGER

the total number of fish larvae in the catch at that station

N/A

meas

INTEGER

the total number of fish larvae measured at that station

N/A

len

INTEGER

the length of each fish larvae measured

N/A

num

INTEGER

the number of fish larvae at that length

N/A

Ldentow1m

DOUBLE PRECISION

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

N/A

Ldensta1m

DOUBLE PRECISION

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

N/A

SpTowCat1m

DOUBLE PRECISION

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

Attribute Details

key

CC ID: 372237

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

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

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

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

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

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

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

taxcode

CC ID: 372244

Seq. Order:	8
Data Storage Type:	INTEGER
Max Length:	4
Required:	Yes
Primary Key:	No
Precision:	9
Scale:	0
Status:	Active
Description:	9-digit species code for fish
General Data Type:	INTEGER

TowCatch

CC ID: 372245

Seq. Order:	9
Data Storage Type:	INTEGER
Max Length:	2
Required:	Yes
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	the total number of fish larvae in the catch at that station
General Data Type:	INTEGER

meas

CC ID: 372246

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

len

CC ID: 372247

Seq. Order:	11
Data Storage Type:	INTEGER
Max Length:	2
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	the length of each fish larvae measured
General Data Type:	INTEGER

num

CC ID: 372248

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

Ldentow1m

CC ID: 372249

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

Ldensta1m

CC ID: 372250

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

SpTowCat1m

CC ID: 372251

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

Catalog Item ID:	36204
GUID:	gov.noaa.nmfs.inport:36204
Metadata Record Created By:	Patricia L Jones
Metadata Record Created:	2017-01-04 11:40+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

LnkTrwlFishTow

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

key

tkey

consta

tgear

tow

hauls

tdur

taxcode

TowCatch

meas

len

num

Ldentow1m

Ldensta1m

SpTowCat1m

Catalog Details