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 >

LnkPlSta2

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

Summary

Abstract

Linkages Plankton-Station table

Description

Linkages Plankton-Station table

Entity Information

Entity Type
Data File

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

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

Rubric Score Primary Key? Name Type Description
N/A
 Primary Key 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)]

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