Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Northeast Cooperative Research Program (NCRP) > Gulf of Maine Cooperative Bottom Longline Surve... >

LL_LENGTH

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Table contains the length data for each station

Description

Table contains the length data for each station

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.
SVSPP NUMBER	A standard code which represents a species caught. Refer to the SVDBS.SVSPECIES_LIST
COMMON_NAME VARCHAR2	A standard common name 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.
LENGTH NUMBER	Measured length of an individual in centimeters (cm). Measure method differs by species
ENTRY_ORDER NUMBER	Order in which fish were measured or entered into the field computer.
NOTES VARCHAR2	Comments related to the measurement of the individual organism's length.
VESSEL NUMBER	Two digit code for the vessel on which the organism was collected and measured. Matches with code in LL_STATION.CRUISE. Values are 24 = Tenacious II or 25 = Mary Elizabeth
EST_LENGTH VARCHAR2	Binary indicator of whether the length of an organism was measured (N) or estimated by otolith back-calculation (Y)
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.

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.

SVSPP
NUMBER

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

COMMON_NAME
VARCHAR2

A standard common name 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.

LENGTH
NUMBER

Measured length of an individual in centimeters (cm). Measure method differs by species

ENTRY_ORDER
NUMBER

Order in which fish were measured or entered into the field computer.

NOTES
VARCHAR2

Comments related to the measurement of the individual organism's length.

VESSEL
NUMBER

Two digit code for the vessel on which the organism was collected and measured. Matches with code in LL_STATION.CRUISE. Values are 24 = Tenacious II or 25 = Mary Elizabeth

EST_LENGTH
VARCHAR2

Binary indicator of whether the length of an organism was measured (N) or estimated by otolith back-calculation (Y)

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.

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:	LL_LENGTH
Short Name:	LL_LENGTH
Status:	Completed
Abstract:	Table contains the length data for each station

Entity Type:	Data Table
Active Version?:	Yes
Description:	Table contains the length data for each station

Attribute Summary

	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	SVSPP	NUMBER	A standard code which represents a species caught. Refer to the SVDBS.SVSPECIES_LIST
100	COMMON_NAME	VARCHAR2	A standard common name 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	LENGTH	NUMBER	Measured length of an individual in centimeters (cm). Measure method differs by species
100	ENTRY_ORDER	NUMBER	Order in which fish were measured or entered into the field computer.
100	NOTES	VARCHAR2	Comments related to the measurement of the individual organism's length.
100	VESSEL	NUMBER	Two digit code for the vessel on which the organism was collected and measured. Matches with code in LL_STATION.CRUISE. Values are 24 = Tenacious II or 25 = Mary Elizabeth
100	EST_LENGTH	VARCHAR2	Binary indicator of whether the length of an organism was measured (N) or estimated by otolith back-calculation (Y)
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.

Name

Type

Description

100

CRUISE

NUMBER

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

SVSPP

NUMBER

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

100

COMMON_NAME

VARCHAR2

A standard common name 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

LENGTH

NUMBER

Measured length of an individual in centimeters (cm). Measure method differs by species

100

ENTRY_ORDER

NUMBER

Order in which fish were measured or entered into the field computer.

100

NOTES

VARCHAR2

Comments related to the measurement of the individual organism's length.

100

VESSEL

NUMBER

Two digit code for the vessel on which the organism was collected and measured. Matches with code in LL_STATION.CRUISE. Values are 24 = Tenacious II or 25 = Mary Elizabeth

100

EST_LENGTH

VARCHAR2

Binary indicator of whether the length of an organism was measured (N) or estimated by otolith back-calculation (Y)

100

AUDIT_FLAG

VARCHAR2

Attribute Details

CRUISE

CC ID: 363157

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

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

SVSPP

CC ID: 363159

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

COMMON_NAME

CC ID: 363160

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

SEX

CC ID: 363161

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

LENGTH

CC ID: 363162

Seq. Order:	6
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Measured length of an individual in centimeters (cm). Measure method differs by species
General Data Type:	NUMBER

ENTRY_ORDER

CC ID: 363163

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Order in which fish were measured or entered into the field computer.
General Data Type:	NUMBER

NOTES

CC ID: 363164

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	255
Required:	No
Primary Key:	No
Status:	Active
Description:	Comments related to the measurement of the individual organism's length.
General Data Type:	VARCHAR2

VESSEL

CC ID: 363165

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Two digit code for the vessel on which the organism was collected and measured. Matches with code in LL_STATION.CRUISE. Values are 24 = Tenacious II or 25 = Mary Elizabeth
General Data Type:	NUMBER

EST_LENGTH

CC ID: 363166

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Binary indicator of whether the length of an organism was measured (N) or estimated by otolith back-calculation (Y)
General Data Type:	VARCHAR2

AUDIT_FLAG

CC ID: 712578

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 Item ID:	35950
GUID:	gov.noaa.nmfs.inport:35950
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-13
Owner Org:	NEFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2016-12-13
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2017-12-13

LL_LENGTH

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

CRUISE

STATION

SVSPP

COMMON_NAME

SEX

LENGTH

ENTRY_ORDER

NOTES

VESSEL

EST_LENGTH

AUDIT_FLAG

Catalog Details