Metadata Rubric

100%

6 / 6

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

LnkPlSta2

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

Item Identification

Title:	LnkPlSta2
Short Name:	LnkPlSta2
Status:	Completed
Abstract:	Linkages Plankton-Station table

Entity Information

Entity Type:	Data File
Active Version?:	Yes
Description:	Linkages Plankton-Station table

Data Attributes

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	cr	VARCHAR	2 char each for ship, year and consecutive cruise number (for the year)
N/A	consta	INTEGER	consecutive station number for a given cruise
N/A	stdsta	INTEGER	standard,or fixed, station number
N/A	pdate	DATE	Plankton_date format mm/dd/yyyy
N/A	ptime	TIME	Plankton_timeformat HH:MI:SS AM/PM
N/A	pdatetime	TIMESTAMP	Plankton_Datetime format mm/dd/yyyy HH24:MI
N/A	pjdat	DOUBLE PRECISION	Plankton_Julian date
N/A	mon	INTEGER	Month (1 to 12)
N/A	year	INTEGER	Year (4-digit)
N/A	sur	INTEGER	consecutive survey number
N/A	pgear	VARCHAR	Plankton_gear code
N/A	net	VARCHAR	net identifier
N/A	haul	INTEGER	haul number for the specific gear type
N/A	plat	DOUBLE PRECISION	Plankton_Latitude (ddmm.xx)
N/A	plng	DOUBLE PRECISION	Plankton_Longitude (ddmm.xx)
N/A	pdlat	DOUBLE PRECISION	Plankton_Latitude, decimal-degrees
N/A	pdlng	DOUBLE PRECISION	Plankton_Longitude, decimal-degrees
N/A	pdpt	DOUBLE PRECISION	Plankton_towdepth
N/A	fmNum	INTEGER	flowmeter number
N/A	calib(m/ct)	DOUBLE PRECISION	calibrationfactor (m/count)
N/A	fmStart	INTEGER	flowmeter start value
N/A	fmEnd	INTEGER	flowmeter end value
N/A	fmcounts	INTEGER	actual flowmeter count
N/A	calcdist	DOUBLE PRECISION	distance traveled (fmcounts*calibrationfactor)
N/A	mouthArea	DOUBLE PRECISION	plankton net area (pi*r2)=0.285815938m2
N/A	Volm3	DOUBLE PRECISION	Volume of water filtered (moutharea*distanced traveled)
N/A	mwo	DOUBLE PRECISION	maximum amount of wire out
N/A	AngleFrSfc	DOUBLE PRECISION	wire angle from surface
N/A	calcmtd	DOUBLE PRECISION	calculated max tow depth (mwo * sin(AngleFrSfc)
N/A	HF10m2	DOUBLE PRECISION	Haul factor (no./10m2), =mtd/[(counts)(moutharea)(calib)*10)]

Name

Type

Description

N/A

key

VARCHAR

concatenation of Cruise code and Standard Station number

N/A

VARCHAR

2 char each for ship, year and consecutive cruise number (for the year)

N/A

consta

INTEGER

consecutive station number for a given cruise

N/A

stdsta

INTEGER

standard,or fixed, station number

N/A

pdate

DATE

Plankton_date format mm/dd/yyyy

N/A

ptime

TIME

Plankton_timeformat HH:MI:SS AM/PM

N/A

pdatetime

TIMESTAMP

Plankton_Datetime format mm/dd/yyyy HH24:MI

N/A

pjdat

DOUBLE PRECISION

Plankton_Julian date

N/A

mon

INTEGER

Month (1 to 12)

N/A

year

INTEGER

Year (4-digit)

N/A

sur

INTEGER

consecutive survey number

N/A

pgear

VARCHAR

Plankton_gear code

N/A

net

VARCHAR

net identifier

N/A

haul

INTEGER

haul number for the specific gear type

N/A

plat

DOUBLE PRECISION

Plankton_Latitude (ddmm.xx)

N/A

plng

DOUBLE PRECISION

Plankton_Longitude (ddmm.xx)

N/A

pdlat

DOUBLE PRECISION

Plankton_Latitude, decimal-degrees

N/A

pdlng

DOUBLE PRECISION

Plankton_Longitude, decimal-degrees

N/A

pdpt

DOUBLE PRECISION

Plankton_towdepth

N/A

fmNum

INTEGER

flowmeter number

N/A

calib(m/ct)

DOUBLE PRECISION

calibrationfactor (m/count)

N/A

fmStart

INTEGER

flowmeter start value

N/A

fmEnd

INTEGER

flowmeter end value

N/A

fmcounts

INTEGER

actual flowmeter count

N/A

calcdist

DOUBLE PRECISION

distance traveled (fmcounts*calibrationfactor)

N/A

mouthArea

DOUBLE PRECISION

plankton net area (pi*r2)=0.285815938m2

N/A

Volm3

DOUBLE PRECISION

Volume of water filtered (moutharea*distanced traveled)

N/A

mwo

DOUBLE PRECISION

maximum amount of wire out

N/A

AngleFrSfc

DOUBLE PRECISION

wire angle from surface

N/A

calcmtd

DOUBLE PRECISION

calculated max tow depth (mwo * sin(AngleFrSfc)

N/A

HF10m2

DOUBLE PRECISION

Haul factor (no./10m2), =mtd/[(counts)*(moutharea)*(calib)*10)]

Attribute Details

key

CC ID: 372189

Seq. Order:	1
Data Storage Type:	VARCHAR
Max Length:	8
Required:	Yes
Primary Key:	Yes
Status:	Active
Description:	concatenation of Cruise code and Standard Station number
General Data Type:	VARCHAR

cr

CC ID: 372190

Seq. Order:	2
Data Storage Type:	VARCHAR
Max Length:	6
Required:	Yes
Primary Key:	No
Status:	Active
Description:	2 char each for ship, year and consecutive cruise number (for the year)
General Data Type:	VARCHAR

consta

CC ID: 372191

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

stdsta

CC ID: 372192

Seq. Order:	4
Data Storage Type:	INTEGER
Max Length:	2
Required:	Yes
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	standard,or fixed, station number
General Data Type:	INTEGER

pdate

CC ID: 372193

Seq. Order:	5
Data Storage Type:	DATE
Max Length:	8
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Plankton_date format mm/dd/yyyy
General Data Type:	DATE

ptime

CC ID: 372194

Seq. Order:	6
Data Storage Type:	TIME
Max Length:	8
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Plankton_timeformat HH:MI:SS AM/PM
General Data Type:	TIME

pdatetime

CC ID: 372195

Seq. Order:	7
Data Storage Type:	TIMESTAMP
Max Length:	8
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Plankton_Datetime format mm/dd/yyyy HH24:MI
General Data Type:	TIMESTAMP

pjdat

CC ID: 372196

Seq. Order:	8
Data Storage Type:	DOUBLE PRECISION
Max Length:	8
Required:	Yes
Primary Key:	No
Precision:	10
Scale:	7
Status:	Active
Description:	Plankton_Julian date
General Data Type:	DOUBLE PRECISION

mon

CC ID: 372197

Seq. Order:	9
Data Storage Type:	INTEGER
Max Length:	2
Required:	Yes
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Month (1 to 12)
General Data Type:	INTEGER

year

CC ID: 372198

Seq. Order:	10
Data Storage Type:	INTEGER
Max Length:	2
Required:	Yes
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Year (4-digit)
General Data Type:	INTEGER

sur

CC ID: 372199

Seq. Order:	11
Data Storage Type:	INTEGER
Max Length:	2
Required:	Yes
Primary Key:	No
Precision:	1
Scale:	0
Status:	Active
Description:	consecutive survey number
General Data Type:	INTEGER

pgear

CC ID: 372200

Seq. Order:	12
Data Storage Type:	VARCHAR
Max Length:	4
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Plankton_gear code
General Data Type:	VARCHAR

net

CC ID: 372201

Seq. Order:	13
Data Storage Type:	VARCHAR
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	net identifier
General Data Type:	VARCHAR

haul

CC ID: 372202

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

plat

CC ID: 372203

Seq. Order:	15
Data Storage Type:	DOUBLE PRECISION
Max Length:	8
Required:	Yes
Primary Key:	No
Precision:	6
Scale:	2
Status:	Active
Description:	Plankton_Latitude (ddmm.xx)
General Data Type:	DOUBLE PRECISION

plng

CC ID: 372204

Seq. Order:	16
Data Storage Type:	DOUBLE PRECISION
Max Length:	8
Required:	Yes
Primary Key:	No
Precision:	6
Scale:	2
Status:	Active
Description:	Plankton_Longitude (ddmm.xx)
General Data Type:	DOUBLE PRECISION

pdlat

CC ID: 372205

Seq. Order:	17
Data Storage Type:	DOUBLE PRECISION
Max Length:	8
Required:	Yes
Primary Key:	No
Precision:	15
Scale:	13
Status:	Active
Description:	Plankton_Latitude, decimal-degrees
General Data Type:	DOUBLE PRECISION

pdlng

CC ID: 372206

Seq. Order:	18
Data Storage Type:	DOUBLE PRECISION
Max Length:	8
Required:	Yes
Primary Key:	No
Precision:	15
Scale:	13
Status:	Active
Description:	Plankton_Longitude, decimal-degrees
General Data Type:	DOUBLE PRECISION

pdpt

CC ID: 372207

Seq. Order:	19
Data Storage Type:	DOUBLE PRECISION
Max Length:	8
Required:	Yes
Primary Key:	No
Precision:	3
Scale:	1
Status:	Active
Description:	Plankton_towdepth
General Data Type:	DOUBLE PRECISION

fmNum

CC ID: 372208

Seq. Order:	20
Data Storage Type:	INTEGER
Max Length:	2
Required:	Yes
Primary Key:	No
Precision:	5
Scale:	0
Status:	Active
Description:	flowmeter number
General Data Type:	INTEGER

calib(m/ct)

CC ID: 372209

Seq. Order:	21
Data Storage Type:	DOUBLE PRECISION
Max Length:	8
Required:	Yes
Primary Key:	No
Precision:	7
Scale:	6
Status:	Active
Description:	calibrationfactor (m/count)
General Data Type:	DOUBLE PRECISION

fmStart

CC ID: 372210

Seq. Order:	22
Data Storage Type:	INTEGER
Max Length:	2
Required:	Yes
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	flowmeter start value
General Data Type:	INTEGER

fmEnd

CC ID: 372211

Seq. Order:	23
Data Storage Type:	INTEGER
Max Length:	2
Required:	Yes
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	flowmeter end value
General Data Type:	INTEGER

fmcounts

CC ID: 372212

Seq. Order:	24
Data Storage Type:	INTEGER
Max Length:	2
Required:	Yes
Primary Key:	No
Precision:	5
Scale:	0
Status:	Active
Description:	actual flowmeter count
General Data Type:	INTEGER

calcdist

CC ID: 372213

Seq. Order:	25
Data Storage Type:	DOUBLE PRECISION
Max Length:	8
Required:	Yes
Primary Key:	No
Precision:	7
Scale:	6
Status:	Active
Description:	distance traveled (fmcounts*calibrationfactor)
General Data Type:	DOUBLE PRECISION

mouthArea

CC ID: 372214

Seq. Order:	26
Data Storage Type:	DOUBLE PRECISION
Max Length:	8
Required:	Yes
Primary Key:	No
Precision:	10
Scale:	9
Status:	Active
Description:	plankton net area (pi*r2)=0.285815938m2
General Data Type:	DOUBLE PRECISION

Volm3

CC ID: 372215

Seq. Order:	27
Data Storage Type:	DOUBLE PRECISION
Max Length:	8
Required:	Yes
Primary Key:	No
Precision:	16
Scale:	13
Status:	Active
Description:	Volume of water filtered (moutharea*distanced traveled)
General Data Type:	DOUBLE PRECISION

mwo

CC ID: 372216

Seq. Order:	28
Data Storage Type:	DOUBLE PRECISION
Max Length:	8
Required:	Yes
Primary Key:	No
Precision:	3
Scale:	1
Status:	Active
Description:	maximum amount of wire out
General Data Type:	DOUBLE PRECISION

AngleFrSfc

CC ID: 372217

Seq. Order:	29
Data Storage Type:	DOUBLE PRECISION
Max Length:	8
Required:	Yes
Primary Key:	No
Precision:	4
Scale:	2
Status:	Active
Description:	wire angle from surface
General Data Type:	DOUBLE PRECISION

calcmtd

CC ID: 372218

Seq. Order:	30
Data Storage Type:	DOUBLE PRECISION
Max Length:	8
Required:	Yes
Primary Key:	No
Precision:	16
Scale:	14
Status:	Active
Description:	calculated max tow depth (mwo * sin(AngleFrSfc)
General Data Type:	DOUBLE PRECISION

HF10m2

CC ID: 372219

Seq. Order:	31
Data Storage Type:	DOUBLE PRECISION
Max Length:	8
Required:	Yes
Primary Key:	No
Precision:	16
Scale:	14
Status:	Active
Description:	Haul factor (no./10m2), =mtd/[(counts)(moutharea)(calib)*10)]
General Data Type:	DOUBLE PRECISION

Catalog Details

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