33591
Table: SVMSTRATA
SVMSTRATA
Entity
Published / External
9025
Atlantic Herring Acoustic Surveys
Data Set
Completed
Historical support table containing all acceptable stratum codes.
Loaded by batch 9069, 07-28-2016 10:55
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
gov.noaa.nmfs.inport:33591
Patricia Jones
2016-07-28T10:55:24
SysAdmin InPortAdmin
2022-08-09T17:11:16
2019-05-31
Northeast Fisheries Science Center
NEFSC
166 Water Street
Woods Hole
MA
02543-1026
USA
(508)495-2000
https://www.nefsc.noaa.gov
8:00 a.m. to 4:30 p.m. Monday - Friday
1001
Public
No
2019-05-31
1 Year
2020-05-31