Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Linkages Larva-Length table

Description

Linkages Larva-Length 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)
stdsta
INTEGER
standard,or fixed, station number
gear
VARCHAR
gear code
net
VARCHAR
net id
haul
INTEGER
haul number for the specific gear type
CD
INTEGER
9-digit species code for fish
totcnt
INTEGER
Total count of fish larvae in the net
TotDen10m2
DOUBLE PRECISION
Density/Total catch adjusted & expressed as no./10m2 of sea-surface area
TotDen100m3
DOUBLE PRECISION
Density/Total catch adjusted & expressed as no./100m3 of cubic meters
mct
INTEGER
Total number of fish larvae measured
len
DOUBLE PRECISION
Length of each fish larvae measured
num
INTEGER
Number of fish larvae at that length
Lden10m2
DOUBLE PRECISION
Density/Total catch by length adjusted & expressed as no./10m2 of sea-surface area
Lden100m3
DOUBLE PRECISION
Density/Total catch by length adjusted & expressed as no./100m3 of cubic meters

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: LnkLarLenDens
Short Name: LnkLarLenDens
Status: Completed
Abstract:

Linkages Larva-Length table

Entity Information

Entity Type: Data File
Active Version?: Yes
Description:

Linkages Larva-Length 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
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
stdsta INTEGER standard,or fixed, station number
N/A
gear VARCHAR gear code
N/A
net VARCHAR net id
N/A
haul INTEGER haul number for the specific gear type
N/A
CD INTEGER 9-digit species code for fish
N/A
totcnt INTEGER Total count of fish larvae in the net
N/A
TotDen10m2 DOUBLE PRECISION Density/Total catch adjusted & expressed as no./10m2 of sea-surface area
N/A
TotDen100m3 DOUBLE PRECISION Density/Total catch adjusted & expressed as no./100m3 of cubic meters
N/A
mct INTEGER Total number of fish larvae measured
N/A
len DOUBLE PRECISION Length of each fish larvae measured
N/A
num INTEGER Number of fish larvae at that length
N/A
Lden10m2 DOUBLE PRECISION Density/Total catch by length adjusted & expressed as no./10m2 of sea-surface area
N/A
Lden100m3 DOUBLE PRECISION Density/Total catch by length adjusted & expressed as no./100m3 of cubic meters

Attribute Details

key

CC ID: 372174
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

cr

CC ID: 372175
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

stdsta

CC ID: 372176
Seq. Order: 3
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

gear

CC ID: 372177
Seq. Order: 4
Data Storage Type: VARCHAR
Max Length: 4
Required: Yes
Primary Key: No
Status: Active
Description:

gear code

General Data Type: VARCHAR

net

CC ID: 372178
Seq. Order: 5
Data Storage Type: VARCHAR
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

net id

General Data Type: VARCHAR

haul

CC ID: 372179
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

CD

CC ID: 372180
Seq. Order: 7
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

totcnt

CC ID: 372181
Seq. Order: 8
Data Storage Type: INTEGER
Max Length: 2
Required: Yes
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Total count of fish larvae in the net

General Data Type: INTEGER

TotDen10m2

CC ID: 372182
Seq. Order: 9
Data Storage Type: DOUBLE PRECISION
Max Length: 8
Required: Yes
Primary Key: No
Precision: 18
Scale: 14
Status: Active
Description:

Density/Total catch adjusted & expressed as no./10m2 of sea-surface area

General Data Type: DOUBLE PRECISION

TotDen100m3

CC ID: 372183
Seq. Order: 10
Data Storage Type: DOUBLE PRECISION
Max Length: 8
Required: Yes
Primary Key: No
Precision: 18
Scale: 14
Status: Active
Description:

Density/Total catch adjusted & expressed as no./100m3 of cubic meters

General Data Type: DOUBLE PRECISION

mct

CC ID: 372184
Seq. Order: 11
Data Storage Type: INTEGER
Max Length: 2
Required: Yes
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Total number of fish larvae measured

General Data Type: INTEGER

len

CC ID: 372185
Seq. Order: 12
Data Storage Type: DOUBLE PRECISION
Max Length: 8
Required: Yes
Primary Key: No
Precision: 3
Scale: 1
Status: Active
Description:

Length of each fish larvae measured

General Data Type: DOUBLE PRECISION

num

CC ID: 372186
Seq. Order: 13
Data Storage Type: INTEGER
Max Length: 2
Required: Yes
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Number of fish larvae at that length

General Data Type: INTEGER

Lden10m2

CC ID: 372187
Seq. Order: 14
Data Storage Type: DOUBLE PRECISION
Max Length: 8
Required: Yes
Primary Key: No
Precision: 16
Scale: 14
Status: Active
Description:

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

General Data Type: DOUBLE PRECISION

Lden100m3

CC ID: 372188
Seq. Order: 15
Data Storage Type: DOUBLE PRECISION
Max Length: 8
Required: Yes
Primary Key: No
Precision: 16
Scale: 14
Status: Active
Description:

Density/Total catch by length adjusted & expressed as no./100m3 of cubic meters

General Data Type: DOUBLE PRECISION

Catalog Details

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