27398
Industry Based Survey (IBS) Cod
Industry Based Survey (IBS) Cod
Data Set
Published / External
23136
Northeast Cooperative Research Program (NCRP)
Project
Completed
The "Gulf of Maine Atlantic Cod Industry-Based Survey" was a collaboration of the Massachusetts Division of Marine Fisheries and the fishing industry, with support from NOAA Fisheries. The goal of the survey was to define the broad scale distribution of Atlantic cod aggregations in the Gulf of Maine in space and time, by age and size composition.
Specific objectives were to use the resultant data to: 1) compliment the NEFSC bottom trawl surveys and 2) evaluate the Gulf of Maine rolling closure areas that existed at the time. Intensive sampling in Gulf of Maine waters was accomplished using four commercial trawlers equipped with a trawl specifically designed for this program. Sampling protocols were adapted from the NEFSC standardized bottom trawl surveys.
Theme
cod
Theme
cooperative research
Theme
survey
Stratum
benthic
Stratum
demersal
Stratum
pelagic
NEFSC Woods Hole Lab
Woods Hole
MA
USA
Data Set
Oracle Database
As Needed
Table (digital)
Otter trawl, ship based DGPS, ship based sounder
Vessels: FV Jocka, FV Lisa Ann II, FV Lady Jane, FV Titan
Otter Trawl
31492
Table: CLOUD
CLOUD
Published / External
Completed
Support table describing cloud cover.
Loaded by batch 8360, 03-16-2016 14:48
Data Table
Yes
SVDBS
Support table describing cloud cover.
1
CLOUD
NUMBER
22
No
No
2
0
Active
Code to represent percentage of cloud cover. See SVDBS.CLOUD
NUMBER
2
PCTCLEAR
NUMBER
22
No
No
3
0
Active
Cloud cover as a percentage. See SVDBS.CLOUD
NUMBER
3
DOE
DATE
7
No
No
Active
Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS).
DATE
4
DOC
DATE
7
No
No
Active
Date when the current record was updated or changed. Date format (MM/DD/YY HH:MI:SS)
DATE
5
UOE
VARCHAR2
8
No
No
Active
The Oracle username of the individual who entered the new record.
VARCHAR2
6
UOC
VARCHAR2
8
No
No
Active
The Oracle username of the individual who changed the current record.
VARCHAR2
31493
Table: GEAR_CONDITION
GEAR_CONDITION
Published / External
Completed
Support table for field GEARCOND in the table SVSTA_BASE. Identifies condition of the gear and is one component of the SHG value.
Loaded by batch 8360, 03-16-2016 14:48
Data Table
Yes
SVDBS
Support table for field GEARCOND in the table SVSTA_BASE. Identifies condition of the gear and is one component of the SHG value.
1
GEARCOND
VARCHAR2
1
Yes
Yes
Active
Refer to SVDBS.GEAR_CONDITION table for gear condition codes and descriptions.
VARCHAR2
2
GEAR_CONDITION
VARCHAR2
300
No
No
Active
Description of gear condition.
VARCHAR2
3
DOE
DATE
7
No
No
Active
Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS).
DATE
4
DOC
DATE
7
No
No
Active
Date when the current record was updated or changed. Date format (MM/DD/YY HH:MI:SS)
DATE
5
UOE
VARCHAR2
8
No
No
Active
The Oracle username of the individual who entered the new record.
VARCHAR2
6
UOC
VARCHAR2
8
No
No
Active
The Oracle username of the individual who changed the current record.
VARCHAR2
31494
Table: HAUL_VALUE
HAUL_VALUE
Published / External
Completed
Support table for field HAUL in the table SVSTA_BASE. A component of the SHG in determining whether a tow is considered valid.
Loaded by batch 8360, 03-16-2016 14:48
Data Table
Yes
SVDBS
Support table for field HAUL in the table SVSTA_BASE. A component of the SHG in determining whether a tow is considered valid.
1
HAUL
VARCHAR2
1
Yes
Yes
Active
Code for relative success of haul. See SVDBS.HAUL_VALUE table
VARCHAR2
2
HAUL_TYPE
VARCHAR2
80
No
No
Active
Description of Haul Value for Bottom Trawl Surveys. See SVDBS_HAUL_VALUE.
VARCHAR2
3
DOE
DATE
7
No
No
Active
Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS).
DATE
4
DOC
DATE
7
No
No
Active
Date when the current record was updated or changed. Date format (MM/DD/YY HH:MI:SS)
DATE
5
UOE
VARCHAR2
8
No
No
Active
The Oracle username of the individual who entered the new record.
VARCHAR2
6
UOC
VARCHAR2
8
No
No
Active
The Oracle username of the individual who changed the current record.
VARCHAR2
31497
Table: MATURITY_CODES
MATURITY_CODES
Published / External
Completed
MASSACHUSETTS Historical support table containing acceptable maturity codes and their description. FSCS_MATURITY_CODES replaces this table.
Loaded by batch 8360, 03-16-2016 14:48
Data Table
Yes
SVDBS
MASSACHUSETTS Historical support table containing acceptable maturity codes and their description. FSCS_MATURITY_CODES replaces this table.
1
MATURITY
CHAR
1
No
No
Active
Stage of maturation of the fish being sampled. See SVDBS.FSCS_MATURITY_CODES
CHAR
2
MATURITY_DESCRIPTION
VARCHAR2
65
No
No
Active
Description of maturity codes.
VARCHAR2
31498
Table: SEX_CODES
SEX_CODES
Published / External
Completed
Historical support table containing acceptable codes and descriptions for the field sex.
Loaded by batch 8360, 03-16-2016 14:48
Data Table
Yes
SVDBS
Historical support table containing acceptable codes and descriptions for the field sex.
1
SEX
NUMBER
22
No
No
1
0
Active
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.
NUMBER
2
SEX_DESCRIPTION
VARCHAR2
255
No
No
Active
Description of the sex code field. Only 0, 1, 2 are valid entries for fscs tables. 0=Unsexed, unknown, or sex not observed; Since the summer 1995 Gulf of Maine Trawl Survey forgot to look for American Lobster; 1=Male; 2=Female; Female Stage I for Northern Shrimp; Since the summer 1995 Gulf of Maine Trawl Survey Female (no eggs, no notch) for American Lobster; 3=Female Stage II for Northern Shrimp; Since the summer 1995 Gulf of Maine Trawl Survey Female, with eggs, no notch for American Lobster; 4=Transitional for Northern Shrimp; Since the summer 1995 Gulf of Maine Trawl Survey Female, with notch, no eggs for American Lobster; 5=Ovigerous for Northern Shrimp; Since the summer 1995 Gulf of Maine Trawl Survey Female, with notch and eggs for American Lobster;6=Non-spawning Female for Northern Shrimp; 7=Female for Northern Shrimp not staged (stage I or II not determined)
VARCHAR2
31499
Table: STATION_VALUE
STATION_VALUE
Published / External
Completed
Support table identifying the type of station being performed. Component of SHG value
Loaded by batch 8360, 03-16-2016 14:48
Data Table
Yes
SVDBS
Support table identifying the type of station being performed. Component of SHG value
1
STATYPE
VARCHAR2
1
Yes
Yes
Active
Code designating type of tow being performed (e.g. random vs. nonrandom tows). See svdbs.station_value table for all statype codes and their descriptions.
VARCHAR2
2
STATION_TYPE
VARCHAR2
65
No
No
Active
Description of station type code for Bottom Trawl Surveys: See SVDBS.STATION_VALUE.STATYPE code for Scallop & Clam Surveys: 1 = Survey haul (random-stratified); 2 = Non-random haul; 3 = Special random add-on station haul;4 = Comparison haul;5 = No dredge haul (e.g., CTD); 6 = Site-specific; 7 = Systematic grid; 8 = Depletion site (as of 1999);9 = Systematiac parallel transects;0 = Systematic zig zag transects
VARCHAR2
3
DOE
DATE
7
No
No
Active
Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS).
DATE
4
DOC
DATE
7
No
No
Active
Date when the current record was updated or changed. Date format (MM/DD/YY HH:MI:SS)
DATE
5
UOE
VARCHAR2
8
No
No
Active
The Oracle username of the individual who entered the new record.
VARCHAR2
6
UOC
VARCHAR2
8
No
No
Active
The Oracle username of the individual who changed the current record.
VARCHAR2
31500
Table: SVCRUISE_PURPOSE
SVCRUISE_PURPOSE
Published / External
Completed
Support table for the PURPOSE_CODE field of the MASTER_CRUISE_TABLE and MASTER_CRUISE_DETAILS tables. Identifying the purpose of a survey
Loaded by batch 8360, 03-16-2016 14:48
Data Table
Yes
SVDBS
Support table for the PURPOSE_CODE field of the MASTER_CRUISE_TABLE and MASTER_CRUISE_DETAILS tables. Identifying the purpose of a survey
1
PURPOSE_CODE
VARCHAR2
2
Yes
Yes
Active
Code referencing purpose of cruise conducted. See SVDBS.SVCRUISE_PURPOSE table
VARCHAR2
2
PURPOSE
VARCHAR2
100
Yes
No
Active
Description of purpose_code to identify type of cruise conducted (e.g. Bottom Trawl, Scallop, Clam, etc.).
VARCHAR2
3
DOE
DATE
7
No
No
Active
Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS).
DATE
4
DOC
DATE
7
No
No
Active
Date when the current record was updated or changed. Date format (MM/DD/YY HH:MI:SS)
DATE
5
UOE
VARCHAR2
8
No
No
Active
The Oracle username of the individual who entered the new record.
VARCHAR2
6
UOC
VARCHAR2
8
No
No
Active
The Oracle username of the individual who changed the current record.
VARCHAR2
31501
Table: SVCRUISE_STATUS
SVCRUISE_STATUS
Published / External
Completed
Support table for the STATUS_CODE field of the MASTER_CRUISE_TABLE and MASTER_CRUISE_DETAILS table. Identifies the availability of master data.
Loaded by batch 8360, 03-16-2016 14:48
Data Table
Yes
SVDBS
Support table for the STATUS_CODE field of the MASTER_CRUISE_TABLE and MASTER_CRUISE_DETAILS table. Identifies the availability of master data.
1
STATUS_CODE
VARCHAR2
2
Yes
Yes
Active
Code referencing whether or not a cruise is available in the SVDBS system. See SVDBS.SVCRUISE_STATUS
VARCHAR2
2
STATUS
VARCHAR2
40
No
No
Active
A data status code indictating whether a cruise is availabe in SVDBS system. See SVDBS.SVCRUISE_STATUS
VARCHAR2
31502
Table: SVGEAR
SVGEAR
Published / External
Completed
Support table containing gear codes and descriptions for the field SVGEAR of the table SVSTA_BASE.
Loaded by batch 8360, 03-16-2016 14:48
Data Table
Yes
SVDBS
Support table containing gear codes and descriptions for the field SVGEAR of the table SVSTA_BASE.
1
SVGEAR
VARCHAR2
2
Yes
Yes
Active
Code referencing predominant gear type used on a cruise. See SVDBS.SVGEAR table.
VARCHAR2
2
GEAR_DEFINITION
VARCHAR2
300
No
No
Active
Type and description of gear.
VARCHAR2
3
DOE
DATE
7
No
No
Active
Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS).
DATE
4
DOC
DATE
7
No
No
Active
Date when the current record was updated or changed. Date format (MM/DD/YY HH:MI:SS)
DATE
5
UOE
VARCHAR2
8
No
No
Active
The Oracle username of the individual who entered the new record.
VARCHAR2
6
UOC
VARCHAR2
8
No
No
Active
The Oracle username of the individual who changed the current record.
VARCHAR2
31509
Table: WEATHER
WEATHER
Published / External
Completed
Support table containing codes and descriptions used in the WEATHER field of the SVSTA_BASE table.
Loaded by batch 8360, 03-16-2016 14:48
Data Table
Yes
SVDBS
Support table containing codes and descriptions used in the WEATHER field of the SVSTA_BASE table.
1
WEATHER
VARCHAR2
2
Yes
Yes
Active
Code reflecting weather condition. See SVDBS.WEATHER table
VARCHAR2
2
WEATHER_DEF
VARCHAR2
65
No
No
Active
Description of weather code. See SVDBS.WEATHER table
VARCHAR2
3
DOE
DATE
7
No
No
Active
Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS).
DATE
4
DOC
DATE
7
No
No
Active
Date when the current record was updated or changed. Date format (MM/DD/YY HH:MI:SS)
DATE
5
UOE
VARCHAR2
8
No
No
Active
The Oracle username of the individual who entered the new record.
VARCHAR2
6
UOC
VARCHAR2
8
No
No
Active
The Oracle username of the individual who changed the current record.
VARCHAR2
31510
Table: XBT
XBT
Published / External
Completed
Historical support table containing codes and descriptions for the field XBT of the table SVSTA_BASE.
Loaded by batch 8360, 03-16-2016 14:48
Data Table
Yes
SVDBS
Historical support table containing codes and descriptions for the field XBT of the table SVSTA_BASE.
1
XBT
VARCHAR2
1
Yes
Yes
Active
Code associated with expendable bathythermograph (temperature/depth profile instrument). See SVDBS.XBT
VARCHAR2
2
XBT_DEF
VARCHAR2
65
No
No
Active
Definition of XBT codes. See SVDBS.XBT
VARCHAR2
3
DOE
DATE
7
No
No
Active
Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS).
DATE
4
DOC
DATE
7
No
No
Active
Date when the current record was updated or changed. Date format (MM/DD/YY HH:MI:SS)
DATE
5
UOE
VARCHAR2
8
No
No
Active
The Oracle username of the individual who entered the new record.
VARCHAR2
6
UOC
VARCHAR2
8
No
No
Active
The Oracle username of the individual who changed the current record.
VARCHAR2
33791
Table: SVMSTRATA
SVMSTRATA
Published / External
Completed
Historical support table containing all acceptable stratum codes.
Loaded by batch 9095, 07-29-2016 10:32
Data Table
Yes
SVDBS
Historical support table containing all acceptable stratum codes.
1
STRGRP_DESC
VARCHAR2
30
No
No
Active
Description of stratum group.
VARCHAR2
2
STRATUM
VARCHAR2
5
Yes
Yes
Active
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.
VARCHAR2
3
STRATUM_NAME
VARCHAR2
30
No
No
Active
Name of stratum area.
VARCHAR2
4
STRATUM_AREA
NUMBER
22
No
No
6
0
Active
Stratum area measured in square nautical miles.
NUMBER
5
MIDLAT
NUMBER
22
No
No
6
2
Active
Middle latitude in stratum for auditing purposes.
NUMBER
6
MIDLON
NUMBER
22
No
No
6
2
Active
Middle longitude in stratum for auditing purposes.
NUMBER
7
MINLAT
NUMBER
22
No
No
6
2
Active
Minimum latitude in stratum for auditing purposes.
NUMBER
8
MAXLAT
NUMBER
22
No
No
6
2
Active
Maximum latitude in stratum for auditing purposes.
NUMBER
9
MINLON
NUMBER
22
No
No
6
2
Active
Minimum longitude in stratum for auditing purposes.
NUMBER
10
MAXLON
NUMBER
22
No
No
6
2
Active
Maximum longitude in stratum for auditing purposes.
NUMBER
11
BLOCKS
NUMBER
22
No
No
4
0
Active
Statistical area blocks.
NUMBER
12
NOTOWS
NUMBER
22
No
No
2
0
Active
Number of tows for a given stratum.
NUMBER
13
DOE
DATE
7
No
No
Active
Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS).
DATE
14
DOC
DATE
7
No
No
Active
Date when the current record was updated or changed. Date format (MM/DD/YY HH:MI:SS)
DATE
15
UOE
VARCHAR2
8
No
No
Active
The Oracle username of the individual who entered the new record.
VARCHAR2
16
UOC
VARCHAR2
8
No
No
Active
The Oracle username of the individual who changed the current record.
VARCHAR2
33792
Table: SV_VESSEL
SV_VESSEL
Published / External
Completed
Support table identifying all vessel codes and descriptions.
Loaded by batch 9095, 07-29-2016 10:32
Data Table
Yes
SVDBS
Support table identifying all vessel codes and descriptions.
1
VESSEL_NAME
VARCHAR2
20
No
No
Active
Name of vessel.
VARCHAR2
2
VESSEL_ABBREV
VARCHAR2
4
Yes
Yes
Active
Vessel abbreviation. See SVDBS.SV_VESSEL
VARCHAR2
3
COUNTRY_OF_ORIGIN
VARCHAR2
20
No
No
Active
Country of origin of vessel.
VARCHAR2
4
HOME_PORT
VARCHAR2
20
No
No
Active
City where vessel maintains its home port.
VARCHAR2
5
AGENCY_NAME
VARCHAR2
20
No
No
Active
Name of state or federal agency that utilizes the vessel.
VARCHAR2
6
LENGTH_OVERALL_FT
NUMBER
22
No
No
38
0
Active
Overall length of vessel measured to nearest foot.
NUMBER
7
CONSTRUCTION
VARCHAR2
20
No
No
Active
Construction material of vessel.
VARCHAR2
8
YEAR_BUILT
VARCHAR2
4
No
No
Active
Year vessel was built.
VARCHAR2
33793
Table: UNION_FSCS_SVBIO
UNION_FSCS_SVBIO
Published / External
Completed
Materialized view joining pre-FSCS and FSCS data sets into one structure. Contains individual fish and invertebrate data.
Loaded by batch 9095, 07-29-2016 10:32
Data Table
Yes
SVDBS
Materialized view joining pre-FSCS and FSCS data sets into one structure. Contains individual fish and invertebrate data.
1
CRUISE6
VARCHAR2
6
No
No
Active
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)
VARCHAR2
2
CRUISE
VARCHAR2
6
No
No
Active
Unique numerical code for a cruise.
VARCHAR2
3
STRATUM
VARCHAR2
5
No
No
Active
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.
VARCHAR2
4
TOW
VARCHAR2
3
No
No
Active
Sequential number representing order in which station was selected within a stratum.
VARCHAR2
5
STATION
VARCHAR2
4
No
No
Active
Unique sequential order in which stations have been completed. Hangups and short tows each receive a non-repeated consecutive number.
VARCHAR2
6
STATUS_CODE
VARCHAR2
2
No
No
Active
Code referencing whether or not a cruise is available in the SVDBS system. See SVDBS.SVCRUISE_STATUS.
VARCHAR2
7
ID
VARCHAR2
18
No
No
Active
Concatenation of Cruise, Stratum, Tow and Station values.
VARCHAR2
8
SVSPP
VARCHAR2
3
No
No
Active
A standard code which represents a species caught in a trawl or dredge. Refer to the SVDBS.SVSPECIES_LIST
VARCHAR2
9
CATCHSEX
VARCHAR2
1
No
No
Active
Code used to identify species that are sexed at the catch level. See SVDBS.SEX_CODES
VARCHAR2
10
INDID
NUMBER
22
No
No
6
0
Active
A unique identifier for each fish sampled.
NUMBER
11
LENGTH
NUMBER
22
No
No
5
2
Active
Measured length of species in centimeters (cm). Measure method differs by species.
NUMBER
12
INDWT
NUMBER
22
No
No
7
3
Active
Individual weight (KG) of species being sampled.
NUMBER
13
SEX
VARCHAR2
1
No
No
Active
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.
VARCHAR2
14
MATURITY
VARCHAR2
2
No
No
Active
Stage of maturation of the fish being sampled. See SVDBS.FSCS_MATURITY_CODES
VARCHAR2
15
AGE
NUMBER
22
No
No
2
0
Active
Age of specimen in years.
NUMBER
16
AGE_DATA_FLAG
VARCHAR2
1
No
No
Active
Code to indicate whether or not an age sample was taken. Valuess: Y = Yes, sample taken; NULL = no age sample taken.
VARCHAR2
17
STOM_VOLUME
NUMBER
22
No
No
5
1
Active
Volume of the stomach contents of the fish sampled, measured to the nearest tenth of a cubic centimeter (cc).
NUMBER
18
STOM_WGT
NUMBER
22
No
No
8
3
Active
Stomach weight of an individual fish in grams.
NUMBER
19
CUTTER
VARCHAR2
30
No
No
Active
Name of the individual who was measuring and cutting fish at a FSCS workstation.
VARCHAR2
20
RECORDER
VARCHAR2
30
No
No
Active
The name of the individual who recorded data.
VARCHAR2
21
IND_FISH_COMMENTS
VARCHAR2
500
No
No
Active
Comment field for an indiviual fish or invertebrate sampled.
VARCHAR2
33794
Table: UNION_FSCS_SVCAT
UNION_FSCS_SVCAT
Published / External
Completed
Materialized view joining pre-FSCS and FSCS data sets into one structure. Contains total number and weight of all species caught at a station.
Loaded by batch 9095, 07-29-2016 10:32
Data Table
Yes
SVDBS
Materialized view joining pre-FSCS and FSCS data sets into one structure. Contains total number and weight of all species caught at a station.
1
CRUISE6
VARCHAR2
6
No
No
Active
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)
VARCHAR2
2
CRUISE
VARCHAR2
6
No
No
Active
Unique numerical code for a cruise.
VARCHAR2
3
STRATUM
VARCHAR2
5
No
No
Active
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.
VARCHAR2
4
TOW
VARCHAR2
3
No
No
Active
Sequential number representing order in which station was selected within a stratum.
VARCHAR2
5
STATION
VARCHAR2
4
No
No
Active
Unique sequential order in which stations have been completed. Hangups and short tows each receive a non-repeated consecutive number.
VARCHAR2
6
STATUS_CODE
VARCHAR2
2
No
No
Active
Code referencing whether or not a cruise is available in the SVDBS system. See SVDBS.SVCRUISE_STATUS.
VARCHAR2
7
ID
VARCHAR2
18
No
No
Active
Concatenation of Cruise, Stratum, Tow and Station values.
VARCHAR2
8
SVSPP
VARCHAR2
3
No
No
Active
A standard code which represents a species caught in a trawl or dredge. Refer to the SVDBS.SVSPECIES_LIST
VARCHAR2
9
CATCHSEX
VARCHAR2
1
No
No
Active
Code used to identify species that are sexed at the catch level. See SVDBS.SEX_CODES
VARCHAR2
10
EXPCATCHNUM
NUMBER
22
No
No
8
0
Active
Expanded number of individuals of a species caught at a given station.
NUMBER
11
EXPCATCHWT
NUMBER
22
No
No
9
3
Active
Expanded catch weight of a species caught at a given station.
NUMBER
12
LOGGED_SPECIES_NAME
VARCHAR2
45
No
No
Active
Name of the species, either common, scientific or both.
VARCHAR2
13
CATCH_COMMENT
VARCHAR2
500
No
No
Active
Comments concerning a species at the catch level.
VARCHAR2
33795
Table: UNION_FSCS_SVLEN
UNION_FSCS_SVLEN
Published / External
Completed
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.
Loaded by batch 9095, 07-29-2016 10:32
Data Table
Yes
SVDBS
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.
1
CRUISE6
VARCHAR2
6
No
No
Active
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)
VARCHAR2
2
CRUISE
VARCHAR2
6
No
No
Active
Unique numerical code for a cruise.
VARCHAR2
3
STRATUM
VARCHAR2
5
No
No
Active
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.
VARCHAR2
4
TOW
VARCHAR2
3
No
No
Active
Sequential number representing order in which station was selected within a stratum.
VARCHAR2
5
STATION
VARCHAR2
4
No
No
Active
Unique sequential order in which stations have been completed. Hangups and short tows each receive a non-repeated consecutive number.
VARCHAR2
6
STATUS_CODE
VARCHAR2
2
No
No
Active
Code referencing whether or not a cruise is available in the SVDBS system. See SVDBS.SVCRUISE_STATUS.
VARCHAR2
7
ID
VARCHAR2
18
No
No
Active
Concatenation of Cruise, Stratum, Tow and Station values.
VARCHAR2
8
SVSPP
VARCHAR2
3
No
No
Active
A standard code which represents a species caught in a trawl or dredge. Refer to the SVDBS.SVSPECIES_LIST
VARCHAR2
9
CATCHSEX
VARCHAR2
1
No
No
Active
Code used to identify species that are sexed at the catch level. See SVDBS.SEX_CODES
VARCHAR2
10
LENGTH
NUMBER
22
No
No
5
2
Active
Measured length of species in centimeters (cm). Measure method differs by species.
NUMBER
11
EXPNUMLEN
NUMBER
22
No
No
8
0
Active
Expanded number of specimens at a given length.
NUMBER
12
LOGGED_SPECIES_NAME
VARCHAR2
45
No
No
Active
Name of the species, either common, scientific or both.
VARCHAR2
13
LENGTH_COMMENT
VARCHAR2
100
No
No
Active
Comment related to length of individual fish.
VARCHAR2
33796
Table: UNION_FSCS_SVSTA
UNION_FSCS_SVSTA
Published / External
Completed
Materialized view joining pre-FSCS and FSCS data sets into one structure. Contains station data for each station.
Loaded by batch 9095, 07-29-2016 10:32
Data Table
Yes
SVDBS
Materialized view joining pre-FSCS and FSCS data sets into one structure. Contains station data for each station.
1
CRUISE6
VARCHAR2
6
No
No
Active
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)
VARCHAR2
2
CRUISE
VARCHAR2
6
No
No
Active
Unique numerical code for a cruise.
VARCHAR2
3
STRATUM
VARCHAR2
5
No
No
Active
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.
VARCHAR2
4
TOW
VARCHAR2
3
No
No
Active
Sequential number representing order in which station was selected within a stratum.
VARCHAR2
5
STATION
VARCHAR2
4
No
No
Active
Unique sequential order in which stations have been completed. Hangups and short tows each receive a non-repeated consecutive number.
VARCHAR2
6
STATUS_CODE
VARCHAR2
2
No
No
Active
Code referencing whether or not a cruise is available in the SVDBS system. See SVDBS.SVCRUISE_STATUS.
VARCHAR2
7
ID
VARCHAR2
72
No
No
Active
Concatenation of Cruise, Stratum, Tow and Station values.
VARCHAR2
8
STATYPE
VARCHAR2
4
No
No
Active
Code designating type of tow being performed (e.g. random vs. nonrandom tows). See SVDBS.STATION_VALUE table for all statype codes and their descriptions.
VARCHAR2
9
HAUL
VARCHAR2
4
No
No
Active
Code for relative success of haul. See SVDBS.HAUL_VALUE table
VARCHAR2
10
GEARCOND
VARCHAR2
4
No
No
Active
Refer to SVDBS.GEAR_CONDITION table for gear condition codes and descriptions.
VARCHAR2
11
SHG
VARCHAR2
12
No
No
Active
Concatenation of Station, Haul and Gear values. See SVDBS.STATION_VALUE, SVDBS.HAUL_VALUE, SVDBS.GEAR_CONDITION
VARCHAR2
12
TYPE_CODE
NUMBER
22
No
No
2
0
Active
Code concerning station details. This defines the type of sampling conducted at each station. Standard NEFSC BTS tows are coded with a T value = 1. The T value=1 is subdivided into 6 components: 1- Random Tow, within 1nm Radius; 1- Random Tow, outside 1nm, within 3nm Radius; 1- Repeat Tow; 1- Random Altername; 1- Random Offshore Continental Shelf; 1- Altername Offshore Protocol. Tow types other than NEFSC BTS standard random tows are defined by the following code values: 2- Non-Random Tow - Tow is not conducted according a random and stratified statistical design. Tow must follow NEFSC BTS protocols.; 3- Survey Standardization - Tow conducted to evaluate NEFSC BTS standardization (i.e. gear testing); 4- Comparison Tow - Tow conducted in comparison of other gears, surveys, vessels or operating procedures ; 5- Aborted Tow - Gear set but timed tow duration never started (aborted tow); 6- Site Specific - Non-random tow conducted in a specific, targeted region; 7- Experimental Survey Design - Survey design type other than random and stratified (i.e. transect, depletion study, grid, fixed etc.); 8 Other - Tows that do not fall into the previous categories. Detailed description of the tow type shall be recorded.
NUMBER
13
TYPE_COMMENT
VARCHAR2
1000
No
No
Active
Comment concerning the Type_Code of the given operation.
VARCHAR2
14
OPERATION_CODE
NUMBER
22
No
No
2
0
Active
Code to define tow in terms of the operational characteristics (i.e. tow duration, vessel speed, scope ratio, depth, trawl perf., winch perf., stratum boundaries. O-Value= 4 is considered non-valid. Tow should be repeated, when possible, at the discretion of Chief Scientist. 1- Good Performance - All operational parameters are within optimal tol.range.2- Representative - Tow dur. 18.00min 19.49min or 20.50min-21.00min; 75-99% on-bottom tow dist. within the correct stratum; Door Spread mean outside optimal but within tol. limit. Wing Spread mean outside optimal but within tolerance limit. (Door and Wing spread are depth dependant calcs.); Headrope Height mean outside optimal but within the tolerance limit(Optimal Height is 3.2-4.1m.3- Representative - Tow dur. 16.00min -17.99min; Acqu. Code Value = 4 (details given with A code); Door Spread Std Deviation High (greater than 4.5m);Wing Spread Std Deviation High (> than 2.0m; Headrope Ht Spread Std Deviation High (Greater than 1.0m; Scope Ratio outside tolerance limit. (+/- 25%)4- Non Representative - Tow dur. < than 16.00min or > than 21.00min; Tow distance < than 0.8nm or > than 1.05nm; Door Spread mean outside tol. limit. (Depth dependant); Wing Spread mean outside tol. limit.(Depth dependant); Headrope Height mean outside tol. limit. (Less than 2.7m or greater than 4.7m); SOG mean outside tol. limit. (Less than 2.6 or greater than 3.4kts); Depth mean outside tol. limit. (EK6018kHz, must be within +/- 10% of set depth, or +/-5m at depths less than 50m); Mean Starboard and Mean Port Block Tension not equalized within ±0.5t; Diff. between mean Starboard and Port Winch calculated wire out lengths greater than 10m; Diff. between mean STBD and Port Block wire out lengths greater than 10m; Less than 75% of on-bottom tow distance within correct stratum; Trawl Depth > than 20% difference of vessel tow depth; Chief Scientist or Watch Chief Failed tow- tow considered unsatisfactory based on vessel or gear performance.
NUMBER
15
OPERATION_COMMENT
VARCHAR2
1000
No
No
Active
Comment concerning Operation Code of given operation (tow duration, vessel speed, scope ration, depth, trawl performance,winch performance, and stratum boundaries.
VARCHAR2
16
GEAR_CODE
NUMBER
22
No
No
2
0
Active
Gear condition code.Gear defined as trawl net,cod-end,liner,sweep,doors & rigging. Valid Gear values =1,2,4(no code 3).1-Good Tow- No damage to webbing, frame ropes, sweep doors or rigging. Trawl properly rigged and considered to be in standard configuration. 2- Representative- Minor Small Holes/Tears in webbing (incl. cod-end and liner).Tears easily repaired coded 2. Larger holes/tears in Jibs,Wings,Bunts,Square or 1st & 2nd Top Bellies.Hole not thought to sig. alter fish capture.Obstr. in/on gear, not thought to signif. alter fish capture Minor Hang;No signif. gear damage;Hang,after 16.00min tow dur.;Tow dur. adjust to time hang occurred;Insignif. sweep damage (i.e. slight damage to rockhoppers not thought to increase fish escapement);Loss or damage to < than 12 floats; Very large catch;Deck tow of dogfish or other species;Other gear damage/malfunction not thought to significantly alter fish capture.4-Non_Representative -Signif. holes/tears/large holes in bottom bellies, or any portion of webbing aft of 2nd belly;Major Gear Damage(i.e. rim-rack, whole sections torn out,loss of trawl door(s) etc.);Open Cod-end;Improperly Attached Liner OR Open Liner OR Signif. Catch Outside Liner;Twisted Wing(s);Signif. Loss of bottom contacts (4min duration or longer).Improper Rigging;Collapsed Doors;Crossed Doors;Major Sweep Damage. (Parted sweep and/or major damage(i.e. loss of more than one rockhopper, or damage to sweep components thought to significantly increase fish escapement. Damaged Frame Rope(s)(headrope,up&down line,bolshline);Open Gore;Twisted or Crossed Bridle(s); Parted Legs;Loss/damage to 12 or > floats;Signif. damage to wing-end extension (i.e. loss, broken or altered length).Signif. Hang. Occurring at <16.00min tow dur.(OR unknown tow dur.;Large obstr. IN/ON gear thought to alter catch effic. or trawl geom.(i.e. pot stuck in front opening of cod-end. Catch not landed on deck;Damage to main towing cable(s);Other gear dam./malf. signif. altering catch efficiency.
NUMBER
17
GEAR_COMMENT
VARCHAR2
1000
No
No
Active
Comment concerning gear condition, damage or malfunction of a given operation.
VARCHAR2
18
ACQUISITION_CODE
NUMBER
22
No
No
2
0
Active
Code concerning data acquisition (i.e. SCS data, trawl mens., SCS event button press).1- No Data Acq Errors. All data acq 75% or greater valid.2- Representative: Door Spread 50.00% - 74.99% data acq.;Wing Spread 50.00% - 74.99% data acq.;Height 50.00% - 74.99% data acq.;Trawl Depth 50.00% - 74.99% data acq.;Winch Tension 50.00% - 74.99% data acq.;Winch Wire Out 50.00% - 74.99% data acq.;Block Tension 50.00% - 74.99% data acq.;Block Wire Out 50.00% - 74.99% data acq.;Speed Over Ground 50.00% - 74.99% data acq.;Vessel Depth 50.00% - 74.99% data acq.;GPS 50.00% - 74.99% data acq.;3-Representative: Door Spread 25.00% - 49.99% data acq.;Wing Spread 25.00% - 49.99% data acq.;Height 25.00% - 49.99% data acq.;Trawl Depth 25.00% - 49.99% data acq.;Winch Tension 25.00% - 49.99% data acq.;Winch Wire Out 25.00% - 49.99% data acq.;Block Tension 25.00% - 49.99% data acq.;Block Wire Out 25.00% - 49.99% data acq.;Speed Over Ground 25.00% - 49.99% data acq.;Vessel Depth 25.00% - 49.99% data acq.;GPS 25.00% - 49.99% data acquisition.4- Non_Representative: Door Spread Less Than 25.00% data acq.;Wing Spread Less Than 25.00% data acq.;Height Less Than 25.00% data acq.;Trawl Depth Less Than 25.00% data acq.;Winch Tension Less Than 25.00% data acq.;Winch Wire Out Less Than 25.00% data acq.;Block Tension Less Than 25.00% data acq.;Block Wire Out Less Than 25.00% data acq.;Speed Over Ground Less Than 25.00% data acq.;Vessel Depth Less Than 25.00% data acq.;GPS Less Than 25.00% data acq.;Error Recording Event Data. Trawl event data missing.;Critical Button Press Error, Unknown Event Time(s).
NUMBER
19
ACQUISITION_COMMENT
VARCHAR2
1000
No
No
Active
Comment concerning data acquisition (i.e. SCS data, trawl mensuration, SCS event button press).
VARCHAR2
20
TOGA
NUMBER
22
No
No
8
0
Active
A concatentation of the T, O, G and A codes assigned to an operation. Each standard survey tow is evaluated based on four categories, Type, Operational, Gear and Acquisition (T.O.G.A.). Type (T), Operational (O) and Gear (G) categories are used to validate each tow; the Acquisition (A) category is additional information not used for validation. T.O.G.A. is a detailed analysis of survey trawl and vessel performance during each tow, utilizing available data from trawl mensuration systems and vessel sensors not previously analyzed by the historical Station, Haul, and Gear (S.H.G.) coding system.
NUMBER
21
AREA
VARCHAR2
3
No
No
Active
Standard area code used for commercial data (New England Statistical Area Code) for the position of the beginning of the tow.
VARCHAR2
22
SVVESSEL
VARCHAR2
2
No
No
Active
Standard two character code for a survey vessel. Refer to SVDBS.SV_VESSEL
VARCHAR2
23
CRUNUM
VARCHAR2
8
No
No
Active
National Ocean Services (NOS) consecutive cruise number on a particular vessel.
VARCHAR2
24
SVGEAR
VARCHAR2
8
No
No
Active
Code referencing predominant gear type used on a cruise. See SVDBS.SVGEAR table.
VARCHAR2
25
BEGIN_EST_TOWDATE
DATE
7
No
No
Active
Date and time represented by Eastern Standard Time (EST) for the start of a tow or deployment.
DATE
26
END_EST_TOWDATE
DATE
7
No
No
Active
Date and time represented by Eastern Standard Time (EST) at the end of a tow or deployment.
DATE
27
BEGIN_GMT_TOWDATE
DATE
7
No
No
Active
Date and time represented by Greenwich Mean Time (GMT) for the start of a tow or deployment.
DATE
28
END_GMT_TOWDATE
DATE
7
No
No
Active
Date and time represented by Greenwich Mean Time (GMT) at the end of a tow or deployment.
DATE
29
EST_YEAR
VARCHAR2
4
No
No
Active
Year, represented by Eastern Standard Time (EST).
VARCHAR2
30
EST_MONTH
VARCHAR2
2
No
No
Active
Month, represented by Eastern Standard Time (EST).
VARCHAR2
31
EST_DAY
VARCHAR2
2
No
No
Active
Day of the month represented by Eastern Standard Time (EST).
VARCHAR2
32
EST_JULIAN_DAY
VARCHAR2
7
No
No
Active
Julian day of towdate represented as Eastern Standard Time (EST).
VARCHAR2
33
EST_TIME
VARCHAR2
8
No
No
Active
Time, represented by Eastern Standard Time (EST).
VARCHAR2
34
GMT_YEAR
VARCHAR2
4
No
No
Active
Year, represented as Greenwich Mean Time (GMT).
VARCHAR2
35
GMT_MONTH
VARCHAR2
2
No
No
Active
Month, represented as Greenwich Mean Time (GMT).
VARCHAR2
36
GMT_DAY
VARCHAR2
2
No
No
Active
Day of the month, represented as Greenwich Mean Time (GMT).
VARCHAR2
37
GMT_JULIAN_DAY
VARCHAR2
7
No
No
Active
Julian day of towdate represented as Greenwich Mean Time (GMT).
VARCHAR2
38
GMT_TIME
VARCHAR2
8
No
No
Active
Time, represented as Greenwich Mean Time (GMT).
VARCHAR2
39
TOWDUR
NUMBER
22
No
No
5
2
Active
Duration of tow in minutes.
NUMBER
40
SETDEPTH
NUMBER
22
No
No
4
0
Active
Depth at the time the primary gear is set to fish, to the nearest meter.
NUMBER
41
ENDDEPTH
NUMBER
22
No
No
4
0
Active
Water depth (m) at end of tow.
NUMBER
42
MINDEPTH
NUMBER
22
No
No
4
0
Active
Minimum depth (m) at which gear fished.
NUMBER
43
MAXDEPTH
NUMBER
22
No
No
4
0
Active
Maximum depth at which gear fished.
NUMBER
44
AVGDEPTH
NUMBER
22
No
No
4
0
Active
A four digit number recording the average depth, to the nearest meter, during a survey gear deployment.
NUMBER
45
BEGEKVLOG
NUMBER
22
No
No
8
3
Active
An eight digit number measuring to the nearest thousandth of a nautical mile (e.g., 14564.345). Used to mark the beginning of a survey trawl for acoustic data purposes.
NUMBER
46
ENDEKVLOG
NUMBER
22
No
No
8
3
Active
An eight digit number measuring to the nearest thousandth of a nautical mile (e.g., 14564.345). Used to mark the end of a survey trawl for acoustic data purposes.
NUMBER
47
BEGLAT
NUMBER
22
No
No
9
4
Active
Beginning latitude of tow (decimal degrees).
NUMBER
48
BEGLON
NUMBER
22
No
No
9
4
Active
Beginning longitude of tow (decimal degrees).
NUMBER
49
ENDLAT
NUMBER
22
No
No
9
4
Active
Latitude at end of tow.
NUMBER
50
ENDLON
NUMBER
22
No
No
9
4
Active
Logitude at end of tow.
NUMBER
51
DECDEG_BEGLAT
NUMBER
22
No
No
10
6
Active
Beginning latitude of tow in decimal degrees.
NUMBER
52
DECDEG_BEGLON
NUMBER
22
No
No
10
6
Active
Beginning longitude of tow in decimal degrees.
NUMBER
53
DECDEG_ENDLAT
NUMBER
22
No
No
10
6
Active
Ending latitide of tow in decimal degrees.
NUMBER
54
DECDEG_ENDLON
NUMBER
22
No
No
10
6
Active
Ending longitude of tow in decimal degrees.
NUMBER
55
LORS1
VARCHAR2
9
No
No
Active
Starting Loran C time delay.
VARCHAR2
56
LORE1
VARCHAR2
9
No
No
Active
Ending Loran C time delay.
VARCHAR2
57
LORS2
VARCHAR2
9
No
No
Active
Starting Loran C time delay.
VARCHAR2
58
LORE2
VARCHAR2
9
No
No
Active
Ending Loran C time delay.
VARCHAR2
59
CABLE
NUMBER
22
No
No
5
0
Active
Wire out (meters) at the water surface.
NUMBER
60
PITCH
NUMBER
22
No
No
3
0
Active
Pitch of variable pitch propeller.
NUMBER
61
HEADING
NUMBER
22
No
No
4
1
Active
Vessel compass heading.
NUMBER
62
COURSE
NUMBER
22
No
No
4
1
Active
Actual course the vessel made good in degrees.
NUMBER
63
RPM
NUMBER
22
No
No
3
0
Active
Average shaft revolutions per minute while under tow.
NUMBER
64
DOPDISTB
NUMBER
22
No
No
5
3
Active
Speed over bottom recorded by GPS.
NUMBER
65
DOPDISTW
NUMBER
22
No
No
5
3
Active
Speed through water recorded by AMATEK when the water depth is >200m.
NUMBER
66
DESSPEED
NUMBER
22
No
No
2
1
Active
Designated towing speed for a particular gear (knots).
NUMBER
67
GEARID
VARCHAR2
2
No
No
Active
Net identification number located on wing of net.
VARCHAR2
68
DOORID
VARCHAR2
2
No
No
Active
Identification number of doors.
VARCHAR2
69
OTHGEAR
VARCHAR2
4
No
No
Active
Code for gear deployed other than primary gear (i.e. net, dredge) such as bongo, Neuston, etc. See SVDBS.OTHGEAR
VARCHAR2
70
AIRTEMP
NUMBER
22
No
No
5
2
Active
Air temperature (degrees Celsius) rounded to nearest whole degree.
NUMBER
71
CLOUD
VARCHAR2
3
No
No
Active
Code to represent percentage of cloud cover. See SVDBS.CLOUD
VARCHAR2
72
BAROPRESS
NUMBER
22
No
No
5
1
Active
Barometric pressure (millibars).
NUMBER
73
WINDDIR
NUMBER
22
No
No
4
1
Active
Direction of wind during deployment of gear (degrees).
NUMBER
74
WINDSP
NUMBER
22
No
No
4
1
Active
Speed of wind in knots.
NUMBER
75
WEATHER
VARCHAR2
3
No
No
Active
Code reflecting weather condition. See SVDBS.WEATHER table
VARCHAR2
76
WAVEHGT
NUMBER
22
No
No
4
2
Active
Height of waves (m).
NUMBER
77
SWELLDIR
NUMBER
22
No
No
3
0
Active
Swell direction (degrees).
NUMBER
78
SWELLHGT
NUMBER
22
No
No
4
2
Active
Swell height (m).
NUMBER
79
BKTTEMP
NUMBER
22
No
No
6
3
Active
Surface water temperature (degrees Celsius).
NUMBER
80
TRASHAMT
NUMBER
22
No
No
4
0
Active
Volume of trash in liters.
NUMBER
81
TRASHSHL
NUMBER
22
No
No
3
0
Active
Trash by % of shells collected during shellfish surveys.
NUMBER
82
TRASHBIO
NUMBER
22
No
No
3
0
Active
Trash by % of living animals such as fish, starfish and snails colected during shellfish surveys.
NUMBER
83
TRASHSUB
NUMBER
22
No
No
3
0
Active
Trash by % of rocks, pebbles, sand collected during shellfish surveys.
NUMBER
84
XBT
VARCHAR2
1
No
No
Active
Code associated with expendable bathythermograph (temperature/depth profile instrument). See SVDBS.XBT
VARCHAR2
85
SURFTEMP
NUMBER
22
No
No
6
3
Active
Surface temperature of water (degrees Celcius).
NUMBER
86
SURFSALIN
NUMBER
22
No
No
6
3
Active
Salinity at water surface in practical salinity units (PSU).
NUMBER
87
BOTTEMP
NUMBER
22
No
No
6
3
Active
Bottom temperature (degrees Celsius).
NUMBER
88
BOTSALIN
NUMBER
22
No
No
6
3
Active
Bottom salinity in Practical Salinity Units (PSU).
NUMBER
89
FULD
NUMBER
22
No
No
3
0
Active
Fullness of the dredge, measured to the nearest bushel (used on scallop and clam surveys only).
NUMBER
90
NO_DETAIL_SVSPP
NUMBER
22
No
No
4
0
Active
Number of biological data sheets associated with a given station.
NUMBER
91
BOTSPEED
NUMBER
22
No
No
3
1
Active
Speed over bottom (knots) recorded by GPS.
NUMBER
92
WATCH_CHIEF
VARCHAR2
30
No
No
Active
Person responsible for smooth conduct of each watch and the collection of data.
VARCHAR2
93
CHIEF_SCIENTIST
VARCHAR2
30
No
No
Active
Person responsible for scientific operations (how and where sampling occurs) and the scientific party.
VARCHAR2
94
WATCH_CHIEF_COMMENTS
VARCHAR2
500
No
No
Active
Watch Chief comment regarding current tow.
VARCHAR2
95
STATION_COMMENTS
VARCHAR2
500
No
No
Active
Comment from the bridge officers.
VARCHAR2
96
HABITAT_COMMENTS
VARCHAR2
500
No
No
Active
Comments on non-coded species found in catch.
VARCHAR2
Data Steward
2003
Person
Kostovick, Paul
paul.kostovick@noaa.gov
166 Water Street
Woods Hole
MA
02543
USA
(508)495-2343
(508)495-2230
8am-4:30pm
Distributor
2007
Organization
Northeast Fisheries Science Center
NEFSC
166 Water Street
Woods Hole
MA
02543-1026
USA
(508)495-2000
https://www.fisheries.noaa.gov/about/northeast-fisheries-science-center
NEFSC Home Page
Online Resource
8:00 a.m. to 4:30 p.m. Monday - Friday
Metadata Contact
2018-09
Person
Kostovick, Paul
paul.kostovick@noaa.gov
166 Water Street
Woods Hole
MA
02543
USA
(508)495-2343
(508)495-2230
8am-4:30pm
Originator
2003
2007
Organization
Northeast Fisheries Science Center
NEFSC
166 Water Street
Woods Hole
MA
02543-1026
USA
(508)495-2000
https://www.fisheries.noaa.gov/about/northeast-fisheries-science-center
NEFSC Home Page
Online Resource
8:00 a.m. to 4:30 p.m. Monday - Friday
Point of Contact
2017
Person
Kostovick, Paul
paul.kostovick@noaa.gov
166 Water Street
Woods Hole
MA
02543
USA
(508)495-2343
(508)495-2230
8am-4:30pm
-70.865883
-66.955583
44.691317
41.108983
Range
2003
2007
Unclassified
Available to qualified researchers.
Please contact Point of Contact via email.
NEFSC Data Access Procedure:
1. Formal request in writing usually to the data owner/contact or Center Director;
2. Requester is contacted by data owner to review and verify the request content and details for data delivery options.
3. If data is confidential then owner will determine if the data may be released to the requester;
4. If data can be released, the data is downloaded and packaged for delivery electronically; or the requester may be directed to where the data is available online.
User must read and fully comprehend the metadata prior to use. Applications or inferences derived from the data should be carefully considered for accuracy.
NEFSC Data Access Constraint:
If data is stored on an internal NEFSC network, the requester may not have direct access to query the data unless they are also authorized for network access.
Acknowledgement of NOAA/NMFS/NEFSC, as the source from which these data were obtained in any publications and/or other representations of these, data is suggested.
https://console.cloud.google.com/storage/browser/nmfs_odp_nefsc/PARR/FMRD/NCRP/27398
4 Files:
- 27398_UNION_FSCS_SVBIO.csv
- 27398_UNION_FSCS_SVCAT.csv
- 27398_UNION_FSCS_SVLEN.csv
- 27398_UNION_FSCS_SVSTA.csv
Data extracted on 5/8/2019
https://storage.googleapis.com/nmfs_odp_nefsc/PARR/PEMAD/ESB/SVDBS/SVDBS_SupportTables.zip
Compressed Zipped Folder contains Support Table Entities for this data set
SVDBS_SupportTables.zip contains Entities
- SVDBS_CLOUD.csv
- SVDBS_GEAR_CONDITION.csv
- SVDBS_HAUL_VALUE.csv
- SVDBS_MATURITY_CODES.csv
- SVDBS_SEX_CODES.csv
- SVDBS_STATION_VALUE.csv
- SVDBS_SVCRUISE_PURPOSE.csv
- SVDBS_SVCRUISE_STATUS.csv
- SVDBS_SVGEAR.csv
- SVDBS_SVMSTRATA.csv
- SVDBS_SV_VESSEL.csv
- SVDBS_WEATHER.csv
- SVDBS_XBT.csv
Data extracted on 8/8/2017
Oracle database on Centralized Data Management System
Data validation during data collection using FSCS 1.6, Data auditing post-survey by established auditing routines, Data validation during database load
Yes
Unknown
Yes
No
none
To Be Determined
Unknown
Archival of source data preserving unaltered collected data, Scheduled backups, Remote storage backups, Password protection
Vessel sensor data were collected electronically using SCS. Catch and biological data were collected electronically using FSCS 1.6. At the completion of the cruise, a database copy was inserted into the shoreside database.
31492
Entity
Table: CLOUD
31493
Entity
Table: GEAR_CONDITION
31494
Entity
Table: HAUL_VALUE
31497
Entity
Table: MATURITY_CODES
31498
Entity
Table: SEX_CODES
31499
Entity
Table: STATION_VALUE
31500
Entity
Table: SVCRUISE_PURPOSE
31501
Entity
Table: SVCRUISE_STATUS
31502
Entity
Table: SVGEAR
33791
Entity
Table: SVMSTRATA
33792
Entity
Table: SV_VESSEL
33793
Entity
Table: UNION_FSCS_SVBIO
33794
Entity
Table: UNION_FSCS_SVCAT
33795
Entity
Table: UNION_FSCS_SVLEN
33796
Entity
Table: UNION_FSCS_SVSTA
31509
Entity
Table: WEATHER
31510
Entity
Table: XBT
gov.noaa.nmfs.inport:27398
Patricia Jones
2015-09-23T13:20:22
Michaael Armbruster
2023-04-10T19:41:31
2016-07-29
Northeast Fisheries Science Center
NEFSC
166 Water Street
Woods Hole
MA
02543-1026
USA
(508)495-2000
http://www.nefsc.noaa.gov
8:00 a.m. to 4:30 p.m. Monday - Friday
1001
Public
No
2016-07-29
1 Year
2017-07-29