Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Population and Ecosystems Monitoring and Analys... > Population Biology Branch > Enhanced Biological Sampling Data >

EBSFD_FSCS_UNION

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

Item Identification

Title:	EBSFD_FSCS_UNION
Short Name:	EBSFD_FSCS_UNION
Status:	Completed
Abstract:	Catch data joined in from SVDBS for individual fish sampled from NEFSC and MADMF trawl surveys, as well as some fish from Cooperative Research projects that have data stored on SVDBS. Catch data joined in from SVDBS.UNION_FSCS_SVSTA, and biological data from SVDBS.UNION_FSCS_SVBIO. Data are joined (using SURVEYID, STATIONNUMBER, FISHNUMBER from FLDRPILOT.FISH_ORGANISM and FLDRPILOT.SPECIES.SPECIES_ITIS) to SVDBS columns CRUISE6, STATION, INDID, ITISSPP (respectively).

Entity Information

Entity Type:	Data Table
Active Version?:	Yes
Description:	Catch data joined in from SVDBS for individual fish sampled from NEFSC and MADMF trawl surveys, as well as some fish from Cooperative Research projects that have data stored on SVDBS. Catch data joined in from SVDBS.UNION_FSCS_SVSTA, and biological data from SVDBS.UNION_FSCS_SVBIO. Data are joined (using SURVEYID, STATIONNUMBER, FISHNUMBER from FLDRPILOT.FISH_ORGANISM and FLDRPILOT.SPECIES.SPECIES_ITIS) to SVDBS columns CRUISE6, STATION, INDID, ITISSPP (respectively).

Data Attributes

Attribute Summary

	Name	Type	Description
100	FISH_ID_CODE	VARCHAR2	Unique code for each sampled fish. Assigned and dependent on FISH_ORGANISM.FISH_ID_CODE
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	STATION	VARCHAR2	Unique sequential order in which stations have been completed. Hangups and short tows each receive a non-repeated consecutive number.
100	ID	VARCHAR2	Concatenation of Cruise, Stratum, Tow and Station values.
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	AREA	VARCHAR2	Standard area code used for commercial data (New England Statistical Area Code) for the position of the beginning of the tow.
100	BEGIN_EST_TOWDATE	DATE	Date and time represented by Eastern Standard Time (EST) for the start of a tow or deployment.
100	END_EST_TOWDATE	DATE	Date and time represented by Eastern Standard Time (EST) at the end of a tow or deployment.
100	EST_YEAR	VARCHAR2	Year, represented by Eastern Standard Time (EST).
100	EST_MONTH	VARCHAR2	Month, represented by Eastern Standard Time (EST).
100	EST_DAY	VARCHAR2	Day of the month represented by Eastern Standard Time (EST).
100	EST_TIME	VARCHAR2	Time, represented by Eastern Standard Time (EST).
100	TOWDUR	NUMBER	Duration of tow in minutes.
100	AVGDEPTH	NUMBER	A four digit number recording the average depth, to the nearest meter, during a survey gear deployment.
100	BEGLAT	NUMBER	Beginning latitude of tow (decimal degrees).
100	BEGLON	NUMBER	Beginning longitude of tow (decimal degrees).
100	ENDLAT	NUMBER	Latitude at end of tow.
100	ENDLON	NUMBER	Longitude at end of tow.
100	BOTTEMP	NUMBER	Bottom temperature (degrees Celsius).
100	STATION_COMMENTS	VARCHAR2	Comment from the bridge officers.
100	INDID	NUMBER	A unique identifier for each fish sampled.
100	AGE	NUMBER	Age of specimen in years.
100	IND_FISH_COMMENTS	VARCHAR2	Comment field for an individual fish or invertebrate sampled.
100	SEX	VARCHAR2	Code indicating sex of fish or invertebrate species. See SVDBS.FSCS_SEX_CODES if using fscs data and SVDBS.SEX_CODES if using non FSCS data. Codes 0, 1, 2 and 4 are the only valid codes in fscs tables.
100	LENGTH	NUMBER	Measured length of species in centimeters (cm). Measure method differs by species.
100	MATURITY	VARCHAR2	Stage of maturation of the fish being sampled. See SVDBS.FSCS_MATURITY_CODES

Name

Type

Description

100

FISH_ID_CODE

VARCHAR2

Unique code for each sampled fish. Assigned and dependent on FISH_ORGANISM.FISH_ID_CODE

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

STATION

VARCHAR2

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

100

VARCHAR2

Concatenation of Cruise, Stratum, Tow and Station values.

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

AREA

VARCHAR2

Standard area code used for commercial data (New England Statistical Area Code) for the position of the beginning of the tow.

100

BEGIN_EST_TOWDATE

DATE

Date and time represented by Eastern Standard Time (EST) for the start of a tow or deployment.

100

END_EST_TOWDATE

DATE

Date and time represented by Eastern Standard Time (EST) at the end of a tow or deployment.

100

EST_YEAR

VARCHAR2

Year, represented by Eastern Standard Time (EST).

100

EST_MONTH

VARCHAR2

Month, represented by Eastern Standard Time (EST).

100

EST_DAY

VARCHAR2

Day of the month represented by Eastern Standard Time (EST).

100

EST_TIME

VARCHAR2

Time, represented by Eastern Standard Time (EST).

100

TOWDUR

NUMBER

Duration of tow in minutes.

100

AVGDEPTH

NUMBER

A four digit number recording the average depth, to the nearest meter, during a survey gear deployment.

100

BEGLAT

NUMBER

Beginning latitude of tow (decimal degrees).

100

BEGLON

NUMBER

Beginning longitude of tow (decimal degrees).

100

ENDLAT

NUMBER

Latitude at end of tow.

100

ENDLON

NUMBER

Longitude at end of tow.

100

BOTTEMP

NUMBER

Bottom temperature (degrees Celsius).

100

STATION_COMMENTS

VARCHAR2

Comment from the bridge officers.

100

INDID

NUMBER

A unique identifier for each fish sampled.

100

AGE

NUMBER

Age of specimen in years.

100

IND_FISH_COMMENTS

VARCHAR2

Comment field for an individual fish or invertebrate sampled.

100

SEX

VARCHAR2

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

100

LENGTH

NUMBER

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

100

MATURITY

VARCHAR2

Stage of maturation of the fish being sampled. See SVDBS.FSCS_MATURITY_CODES

Attribute Details

FISH_ID_CODE

CC ID: 362133

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique code for each sampled fish. Assigned and dependent on FISH_ORGANISM.FISH_ID_CODE
General Data Type:	VARCHAR2

CRUISE6

CC ID: 362134

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

STATION

CC ID: 362135

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

ID

CC ID: 362136

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

STRATUM

CC ID: 362137

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

AREA

CC ID: 362138

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Standard area code used for commercial data (New England Statistical Area Code) for the position of the beginning of the tow.
General Data Type:	VARCHAR2

BEGIN_EST_TOWDATE

CC ID: 362139

Seq. Order:	7
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date and time represented by Eastern Standard Time (EST) for the start of a tow or deployment.
General Data Type:	DATE

END_EST_TOWDATE

CC ID: 362140

Seq. Order:	8
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date and time represented by Eastern Standard Time (EST) at the end of a tow or deployment.
General Data Type:	DATE

EST_YEAR

CC ID: 362141

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	40
Required:	No
Primary Key:	No
Status:	Active
Description:	Year, represented by Eastern Standard Time (EST).
General Data Type:	VARCHAR2

EST_MONTH

CC ID: 362142

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	40
Required:	No
Primary Key:	No
Status:	Active
Description:	Month, represented by Eastern Standard Time (EST).
General Data Type:	VARCHAR2

EST_DAY

CC ID: 362143

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	40
Required:	No
Primary Key:	No
Status:	Active
Description:	Day of the month represented by Eastern Standard Time (EST).
General Data Type:	VARCHAR2

EST_TIME

CC ID: 362144

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	32
Required:	No
Primary Key:	No
Status:	Active
Description:	Time, represented by Eastern Standard Time (EST).
General Data Type:	VARCHAR2

TOWDUR

CC ID: 362145

Seq. Order:	13
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Duration of tow in minutes.
General Data Type:	NUMBER

AVGDEPTH

CC ID: 362146

Seq. Order:	14
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	A four digit number recording the average depth, to the nearest meter, during a survey gear deployment.
General Data Type:	NUMBER

BEGLAT

CC ID: 362147

Seq. Order:	15
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Beginning latitude of tow (decimal degrees).
General Data Type:	NUMBER

BEGLON

CC ID: 362148

Seq. Order:	16
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Beginning longitude of tow (decimal degrees).
General Data Type:	NUMBER

ENDLAT

CC ID: 362149

Seq. Order:	17
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Latitude at end of tow.
General Data Type:	NUMBER

ENDLON

CC ID: 362150

Seq. Order:	18
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Longitude at end of tow.
General Data Type:	NUMBER

BOTTEMP

CC ID: 362151

Seq. Order:	19
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Bottom temperature (degrees Celsius).
General Data Type:	NUMBER

STATION_COMMENTS

CC ID: 362152

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	500
Required:	No
Primary Key:	No
Status:	Active
Description:	Comment from the bridge officers.
General Data Type:	VARCHAR2

INDID

CC ID: 362153

Seq. Order:	21
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	A unique identifier for each fish sampled.
General Data Type:	NUMBER

AGE

CC ID: 362154

Seq. Order:	22
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Age of specimen in years.
General Data Type:	NUMBER

IND_FISH_COMMENTS

CC ID: 362155

Seq. Order:	23
Data Storage Type:	VARCHAR2
Max Length:	500
Required:	No
Primary Key:	No
Status:	Active
Description:	Comment field for an individual fish or invertebrate sampled.
General Data Type:	VARCHAR2

SEX

CC ID: 362156

Seq. Order:	24
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code indicating sex of fish or invertebrate species. See SVDBS.FSCS_SEX_CODES if using fscs data and SVDBS.SEX_CODES if using non FSCS data. Codes 0, 1, 2 and 4 are the only valid codes in fscs tables.
General Data Type:	VARCHAR2

LENGTH

CC ID: 362157

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

MATURITY

CC ID: 362158

Seq. Order:	26
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Stage of maturation of the fish being sampled. See SVDBS.FSCS_MATURITY_CODES
General Data Type:	VARCHAR2

Catalog Details

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