Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Population and Ecosystems Monitoring and Analys... > Ecosystems Surveys Branch > Dredge Surveys > Atlantic Surfclam and Ocean Quahog Survey >

Table: UNION_FSCS_SVLEN

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Materialized view joining pre-FSCS and FSCS data sets into one structure. Contains total number of fish caught at each length for all species at a station.

Description

Materialized view joining pre-FSCS and FSCS data sets into one structure. Contains total number of fish caught at each length for all species at a station.

Entity Type
Data Table

Data Attribute / Type	Description
CRUISE6 VARCHAR2	Code uniquely identifying cruise. The first four digits indicate the year and the last two digit uniquely identify the cruise within the year. The 5th byte signifies cruises other than groundfish: Shrimp survey = 7 (i.e. 201470), State of Massachusetts survey = 9 (i.e. 201491), Food habits = 5 (i.e.199554)
CRUISE VARCHAR2	Unique numerical code for a cruise.
STRATUM VARCHAR2	A predefined area where a net dredge, or other piece of gear was deployed. Code consists of 2 parts: Stratum group code number (2 bytes) and stratum number (3 bytes). Stratum group refers to if area fished is inshore or offshore North or South of Cape Hatteras or the type of cruise (shellfish, State of MA, offshore deepwater). The stratum number (third and fourth digits of code) refers to area defined by depth zone. See SVDBS.SVMSTRATA. The fifth digit of the code increases the length of the stratum number for revised strata after the Hague Line was established. Stratum group code: 01 = Trawl, offshore north of Hatteras; 02 = BIOM; 03 = Trawl, inshore north of Hatteras; 04 = Shrimp; 05 = Scotian shelf; 06 = Shellfish; 07 = Trawl, inshore south of Hatteras; 08 = Trawl, Offshore south of Hatteras; 09 = MA DMF; 99 = Offshore deepwater (outside the stratified area). A change in Bottom Trawl Stratum for the Gulf of Maine-Bay of Fundy has been in effect since Spring 1987, and may be summarized as follows: Previous strata: 01350; Present strata: 01351, 01352.
TOW VARCHAR2	Sequential number representing order in which station was selected within a stratum.
STATION VARCHAR2	Unique sequential order in which stations have been completed. Hangups and short tows each receive a non-repeated consecutive number.
STATUS_CODE VARCHAR2	Code referencing whether or not a cruise is available in the SVDBS system. See SVDBS.SVCRUISE_STATUS.
ID VARCHAR2	Concatenation of Cruise6, Stratum, Tow and Station values.
SVSPP VARCHAR2	A standard code which represents a species caught in a trawl or dredge. Refer to the SVDBS.SVSPECIES_LIST
CATCHSEX VARCHAR2	Code used to identify species that are sexed at the catch level. See SVDBS.SEX_CODES
LENGTH NUMBER	Measured length of species in centimeters (cm). Measure method differs by species.
EXPNUMLEN NUMBER	Expanded number of specimens at a given length.
LOGGED_SPECIES_NAME VARCHAR2	Name of the species, either common, scientific or both.
LENGTH_COMMENT VARCHAR2	Comment related to length of individual fish.

Data Attribute / Type

Description

CRUISE6
VARCHAR2

Code uniquely identifying cruise. The first four digits indicate the year and the last two digit uniquely identify the cruise within the year. The 5th byte signifies cruises other than groundfish: Shrimp survey = 7 (i.e. 201470), State of Massachusetts survey = 9 (i.e. 201491), Food habits = 5 (i.e.199554)

CRUISE
VARCHAR2

Unique numerical code for a cruise.

STRATUM
VARCHAR2

A predefined area where a net dredge, or other piece of gear was deployed. Code consists of 2 parts: Stratum group code number (2 bytes) and stratum number (3 bytes). Stratum group refers to if area fished is inshore or offshore North or South of Cape Hatteras or the type of cruise (shellfish, State of MA, offshore deepwater). The stratum number (third and fourth digits of code) refers to area defined by depth zone. See SVDBS.SVMSTRATA. The fifth digit of the code increases the length of the stratum number for revised strata after the Hague Line was established. Stratum group code: 01 = Trawl, offshore north of Hatteras; 02 = BIOM; 03 = Trawl, inshore north of Hatteras; 04 = Shrimp; 05 = Scotian shelf; 06 = Shellfish; 07 = Trawl, inshore south of Hatteras; 08 = Trawl, Offshore south of Hatteras; 09 = MA DMF; 99 = Offshore deepwater (outside the stratified area). A change in Bottom Trawl Stratum for the Gulf of Maine-Bay of Fundy has been in effect since Spring 1987, and may be summarized as follows: Previous strata: 01350; Present strata: 01351, 01352.

TOW
VARCHAR2

Sequential number representing order in which station was selected within a stratum.

STATION
VARCHAR2

Unique sequential order in which stations have been completed. Hangups and short tows each receive a non-repeated consecutive number.

STATUS_CODE
VARCHAR2

Code referencing whether or not a cruise is available in the SVDBS system. See SVDBS.SVCRUISE_STATUS.

ID
VARCHAR2

Concatenation of Cruise6, Stratum, Tow and Station values.

SVSPP
VARCHAR2

A standard code which represents a species caught in a trawl or dredge. Refer to the SVDBS.SVSPECIES_LIST

CATCHSEX
VARCHAR2

Code used to identify species that are sexed at the catch level. See SVDBS.SEX_CODES

LENGTH
NUMBER

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

EXPNUMLEN
NUMBER

Expanded number of specimens at a given length.

LOGGED_SPECIES_NAME
VARCHAR2

Name of the species, either common, scientific or both.

LENGTH_COMMENT
VARCHAR2

Comment related to length of individual fish.

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:	Table: UNION_FSCS_SVLEN
Short Name:	UNION_FSCS_SVLEN
Status:	Completed
Abstract:	Materialized view joining pre-FSCS and FSCS data sets into one structure. Contains total number of fish caught at each length for all species at a station.
Notes:	Loaded by batch 9078, 07-28-2016 12:36

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	SVDBS
Description:	Materialized view joining pre-FSCS and FSCS data sets into one structure. Contains total number of fish caught at each length for all species at a station.

Attribute Summary

	Name	Type	Description
100	CRUISE6	VARCHAR2	Code uniquely identifying cruise. The first four digits indicate the year and the last two digit uniquely identify the cruise within the year. The 5th byte signifies cruises other than groundfish: Shrimp survey = 7 (i.e. 201470), State of Massachusetts survey = 9 (i.e. 201491), Food habits = 5 (i.e.199554)
100	CRUISE	VARCHAR2	Unique numerical code for a cruise.
100	STRATUM	VARCHAR2	A predefined area where a net dredge, or other piece of gear was deployed. Code consists of 2 parts: Stratum group code number (2 bytes) and stratum number (3 bytes). Stratum group refers to if area fished is inshore or offshore North or South of Cape Hatteras or the type of cruise (shellfish, State of MA, offshore deepwater). The stratum number (third and fourth digits of code) refers to area defined by depth zone. See SVDBS.SVMSTRATA. The fifth digit of the code increases the length of the stratum number for revised strata after the Hague Line was established. Stratum group code: 01 = Trawl, offshore north of Hatteras; 02 = BIOM; 03 = Trawl, inshore north of Hatteras; 04 = Shrimp; 05 = Scotian shelf; 06 = Shellfish; 07 = Trawl, inshore south of Hatteras; 08 = Trawl, Offshore south of Hatteras; 09 = MA DMF; 99 = Offshore deepwater (outside the stratified area). A change in Bottom Trawl Stratum for the Gulf of Maine-Bay of Fundy has been in effect since Spring 1987, and may be summarized as follows: Previous strata: 01350; Present strata: 01351, 01352.
100	TOW	VARCHAR2	Sequential number representing order in which station was selected within a stratum.
100	STATION	VARCHAR2	Unique sequential order in which stations have been completed. Hangups and short tows each receive a non-repeated consecutive number.
100	STATUS_CODE	VARCHAR2	Code referencing whether or not a cruise is available in the SVDBS system. See SVDBS.SVCRUISE_STATUS.
100	ID	VARCHAR2	Concatenation of Cruise6, Stratum, Tow and Station values.
100	SVSPP	VARCHAR2	A standard code which represents a species caught in a trawl or dredge. Refer to the SVDBS.SVSPECIES_LIST
100	CATCHSEX	VARCHAR2	Code used to identify species that are sexed at the catch level. See SVDBS.SEX_CODES
100	LENGTH	NUMBER	Measured length of species in centimeters (cm). Measure method differs by species.
100	EXPNUMLEN	NUMBER	Expanded number of specimens at a given length.
100	LOGGED_SPECIES_NAME	VARCHAR2	Name of the species, either common, scientific or both.
100	LENGTH_COMMENT	VARCHAR2	Comment related to length of individual fish.

Name

Type

Description

100

CRUISE6

VARCHAR2

100

CRUISE

VARCHAR2

Unique numerical code for a cruise.

100

STRATUM

VARCHAR2

100

TOW

VARCHAR2

Sequential number representing order in which station was selected within a stratum.

100

STATION

VARCHAR2

Unique sequential order in which stations have been completed. Hangups and short tows each receive a non-repeated consecutive number.

100

STATUS_CODE

VARCHAR2

Code referencing whether or not a cruise is available in the SVDBS system. See SVDBS.SVCRUISE_STATUS.

100

VARCHAR2

Concatenation of Cruise6, Stratum, Tow and Station values.

100

SVSPP

VARCHAR2

A standard code which represents a species caught in a trawl or dredge. Refer to the SVDBS.SVSPECIES_LIST

100

CATCHSEX

VARCHAR2

Code used to identify species that are sexed at the catch level. See SVDBS.SEX_CODES

100

LENGTH

NUMBER

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

100

EXPNUMLEN

NUMBER

Expanded number of specimens at a given length.

100

LOGGED_SPECIES_NAME

VARCHAR2

Name of the species, either common, scientific or both.

100

LENGTH_COMMENT

VARCHAR2

Comment related to length of individual fish.

Attribute Details

CRUISE6

CC ID: 336929

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Code uniquely identifying cruise. The first four digits indicate the year and the last two digit uniquely identify the cruise within the year. The 5th byte signifies cruises other than groundfish: Shrimp survey = 7 (i.e. 201470), State of Massachusetts survey = 9 (i.e. 201491), Food habits = 5 (i.e.199554)
General Data Type:	VARCHAR2

CRUISE

CC ID: 336934

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique numerical code for a cruise.
General Data Type:	VARCHAR2

STRATUM

CC ID: 336935

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	A predefined area where a net dredge, or other piece of gear was deployed. Code consists of 2 parts: Stratum group code number (2 bytes) and stratum number (3 bytes). Stratum group refers to if area fished is inshore or offshore North or South of Cape Hatteras or the type of cruise (shellfish, State of MA, offshore deepwater). The stratum number (third and fourth digits of code) refers to area defined by depth zone. See SVDBS.SVMSTRATA. The fifth digit of the code increases the length of the stratum number for revised strata after the Hague Line was established. Stratum group code: 01 = Trawl, offshore north of Hatteras; 02 = BIOM; 03 = Trawl, inshore north of Hatteras; 04 = Shrimp; 05 = Scotian shelf; 06 = Shellfish; 07 = Trawl, inshore south of Hatteras; 08 = Trawl, Offshore south of Hatteras; 09 = MA DMF; 99 = Offshore deepwater (outside the stratified area). A change in Bottom Trawl Stratum for the Gulf of Maine-Bay of Fundy has been in effect since Spring 1987, and may be summarized as follows: Previous strata: 01350; Present strata: 01351, 01352.
General Data Type:	VARCHAR2

TOW

CC ID: 336936

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Sequential number representing order in which station was selected within a stratum.
General Data Type:	VARCHAR2

STATION

CC ID: 336937

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique sequential order in which stations have been completed. Hangups and short tows each receive a non-repeated consecutive number.
General Data Type:	VARCHAR2

STATUS_CODE

CC ID: 336938

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Code referencing whether or not a cruise is available in the SVDBS system. See SVDBS.SVCRUISE_STATUS.
General Data Type:	VARCHAR2

ID

CC ID: 336939

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	18
Required:	No
Primary Key:	No
Status:	Active
Description:	Concatenation of Cruise6, Stratum, Tow and Station values.
General Data Type:	VARCHAR2

SVSPP

CC ID: 336940

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	A standard code which represents a species caught in a trawl or dredge. Refer to the SVDBS.SVSPECIES_LIST
General Data Type:	VARCHAR2

CATCHSEX

CC ID: 336941

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code used to identify species that are sexed at the catch level. See SVDBS.SEX_CODES
General Data Type:	VARCHAR2

LENGTH

CC ID: 336930

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

EXPNUMLEN

CC ID: 336931

Seq. Order:	11
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	8
Scale:	0
Status:	Active
Description:	Expanded number of specimens at a given length.
General Data Type:	NUMBER

LOGGED_SPECIES_NAME

CC ID: 336932

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	45
Required:	No
Primary Key:	No
Status:	Active
Description:	Name of the species, either common, scientific or both.
General Data Type:	VARCHAR2

LENGTH_COMMENT

CC ID: 336933

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	100
Required:	No
Primary Key:	No
Status:	Active
Description:	Comment related to length of individual fish.
General Data Type:	VARCHAR2

Catalog Item ID:	33645
GUID:	gov.noaa.nmfs.inport:33645
Metadata Record Created By:	Patricia L Jones
Metadata Record Created:	2016-07-28 12:36+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2019-05-31
Owner Org:	NEFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2019-05-31
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2020-05-31

Table: UNION_FSCS_SVLEN

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

CRUISE6

CRUISE

STRATUM

TOW

STATION

STATUS_CODE

ID

SVSPP

CATCHSEX

LENGTH

EXPNUMLEN

LOGGED_SPECIES_NAME

LENGTH_COMMENT

Catalog Details