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

Summary

Abstract

Table contains the catch data for each station

Description

Table contains the catch data for each station

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
CRUISE
NUMBER
Unique numerical code for each cruise. Specific to a vessel and season. Five digits, where first 2 digits indicate vessel, next 2 year, last digit season. For example 24142 = Tenacious II 2014 fall survey or 25151 = Mary Elizabeth 2015 spring survey. If last digit = 3 it is an experimental survey trip
STATION
NUMBER
Unique sequential order in which stations have been completed, unique to each cruise code. Failed gear deployments each receive a non-repeated consecutive number.
COMMON_NAME
VARCHAR2
A standard common name which represents a species caught. Refer to the SVDBS.SVSPECIES_LIST
SVSPP
NUMBER
A standard code which represents a species caught. Refer to the SVDBS.SVSPECIES_LIST
SEX
NUMBER
Code indicating sex of fish or invertebrate species. See SVDBS.FSCS_SEX_CODES. Codes 0, 1, 2 and 4 are the only valid codes in fscs tables.
LENWT
NUMBER
Weight (kg) of individuals for which length was measured for that species.
LENNUM
NUMBER
Number of individuals for that species that lengths were measured.
CATCHWT
NUMBER
Mass of all catch (kg) for a species. This includes both the weight of catch for which lengths were taken and subsampled portions of the catch. Catch weight is also expanded for damaged catch. Damaged catch expansion varies by species and damage level. These protocols are still under development for some species. If length data was obtained for the damaged individuals weight is estimated from the organism lengths. If organism(s) was not intact and an otolith was obtained length and weight are estimated by otolith size back-calculation. Length back-calculation is done using a species-specific GAM model with data available in COOPLL.OTOLITH_LENGTH_PREDICTION_DATA using a measurement of the damaged individual's otolith length and width, one or both as available. If no otolith was obtained the weight are estimated using the mean weight within that strata for the species. If there are limited data available within strata for that species than a mean for the whole survey region is applied.
CATCHNUM
NUMBER
Expanded number of individuals of a species caught at a given station. Includes count of damaged individuals and expansion of the count for subsampled catch. Expansion of the subsampled catch is done using the length-frequency distribution from that station, or if data is insufficient than the distribution for the entire strata.
COMMENTS
VARCHAR2
Catch comments for the current species.
AUDIT_FLAG
VARCHAR2
Binary flag that indicates a data issue was identified during the audit (if = Y), with details provided in the comments field. It may indicate a data field that is not recommended for use in analysis.

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

Table contains the catch data for each station

Entity Information

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

Table contains the catch data for each station

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
CRUISE NUMBER Unique numerical code for each cruise. Specific to a vessel and season. Five digits, where first 2 digits indicate vessel, next 2 year, last digit season. For example 24142 = Tenacious II 2014 fall survey or 25151 = Mary Elizabeth 2015 spring survey. If last digit = 3 it is an experimental survey trip
100
STATION NUMBER Unique sequential order in which stations have been completed, unique to each cruise code. Failed gear deployments each receive a non-repeated consecutive number.
100
COMMON_NAME VARCHAR2 A standard common name which represents a species caught. Refer to the SVDBS.SVSPECIES_LIST
100
SVSPP NUMBER A standard code which represents a species caught. Refer to the SVDBS.SVSPECIES_LIST
100
SEX NUMBER Code indicating sex of fish or invertebrate species. See SVDBS.FSCS_SEX_CODES. Codes 0, 1, 2 and 4 are the only valid codes in fscs tables.
100
LENWT NUMBER Weight (kg) of individuals for which length was measured for that species.
100
LENNUM NUMBER Number of individuals for that species that lengths were measured.
100
CATCHWT NUMBER Mass of all catch (kg) for a species. This includes both the weight of catch for which lengths were taken and subsampled portions of the catch. Catch weight is also expanded for damaged catch. Damaged catch expansion varies by species and damage level. These protocols are still under development for some species. If length data was obtained for the damaged individuals weight is estimated from the organism lengths. If organism(s) was not intact and an otolith was obtained length and weight are estimated by otolith size back-calculation. Length back-calculation is done using a species-specific GAM model with data available in COOPLL.OTOLITH_LENGTH_PREDICTION_DATA using a measurement of the damaged individual's otolith length and width, one or both as available. If no otolith was obtained the weight are estimated using the mean weight within that strata for the species. If there are limited data available within strata for that species than a mean for the whole survey region is applied.
100
CATCHNUM NUMBER Expanded number of individuals of a species caught at a given station. Includes count of damaged individuals and expansion of the count for subsampled catch. Expansion of the subsampled catch is done using the length-frequency distribution from that station, or if data is insufficient than the distribution for the entire strata.
100
COMMENTS VARCHAR2 Catch comments for the current species.
100
AUDIT_FLAG VARCHAR2 Binary flag that indicates a data issue was identified during the audit (if = Y), with details provided in the comments field. It may indicate a data field that is not recommended for use in analysis.

Attribute Details

CRUISE

CC ID: 363147
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Unique numerical code for each cruise. Specific to a vessel and season. Five digits, where first 2 digits indicate vessel, next 2 year, last digit season. For example 24142 = Tenacious II 2014 fall survey or 25151 = Mary Elizabeth 2015 spring survey. If last digit = 3 it is an experimental survey trip

General Data Type: NUMBER

STATION

CC ID: 363148
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Unique sequential order in which stations have been completed, unique to each cruise code. Failed gear deployments each receive a non-repeated consecutive number.

General Data Type: NUMBER

COMMON_NAME

CC ID: 363149
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

A standard common name which represents a species caught. Refer to the SVDBS.SVSPECIES_LIST

General Data Type: VARCHAR2

SVSPP

CC ID: 363150
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

A standard code which represents a species caught. Refer to the SVDBS.SVSPECIES_LIST

General Data Type: NUMBER

SEX

CC ID: 363151
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Code indicating sex of fish or invertebrate species. See SVDBS.FSCS_SEX_CODES. Codes 0, 1, 2 and 4 are the only valid codes in fscs tables.

General Data Type: NUMBER

LENWT

CC ID: 363152
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Scale: 3
Status: Active
Description:

Weight (kg) of individuals for which length was measured for that species.

General Data Type: NUMBER

LENNUM

CC ID: 363153
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Number of individuals for that species that lengths were measured.

General Data Type: NUMBER

CATCHWT

CC ID: 363154
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Scale: 3
Status: Active
Description:

Mass of all catch (kg) for a species. This includes both the weight of catch for which lengths were taken and subsampled portions of the catch. Catch weight is also expanded for damaged catch. Damaged catch expansion varies by species and damage level. These protocols are still under development for some species. If length data was obtained for the damaged individuals weight is estimated from the organism lengths. If organism(s) was not intact and an otolith was obtained length and weight are estimated by otolith size back-calculation. Length back-calculation is done using a species-specific GAM model with data available in COOPLL.OTOLITH_LENGTH_PREDICTION_DATA using a measurement of the damaged individual's otolith length and width, one or both as available. If no otolith was obtained the weight are estimated using the mean weight within that strata for the species. If there are limited data available within strata for that species than a mean for the whole survey region is applied.

General Data Type: NUMBER

CATCHNUM

CC ID: 363155
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Expanded number of individuals of a species caught at a given station. Includes count of damaged individuals and expansion of the count for subsampled catch. Expansion of the subsampled catch is done using the length-frequency distribution from that station, or if data is insufficient than the distribution for the entire strata.

General Data Type: NUMBER

COMMENTS

CC ID: 363156
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Catch comments for the current species.

General Data Type: VARCHAR2

AUDIT_FLAG

CC ID: 712577
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Binary flag that indicates a data issue was identified during the audit (if = Y), with details provided in the comments field. It may indicate a data field that is not recommended for use in analysis.

Catalog Details

Catalog Item ID: 35949
GUID: gov.noaa.nmfs.inport:35949
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-12-13 16:37+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-12-15
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-12-15
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-12-15