5515
Table: GSS_GULF_SHRIMP_56_83
GSS_GULF_SHRIMP_56_83
Entity
Published / External
22119
Gulf Shrimp System
Data Set
Completed
Table holding data from 1956 to 1983
Loaded by batch 1744, 10-17-2007 10:30
Theme
pounds
Theme
shrimp date
Theme
value
Temporal
1956-1983
Spatial
Alabama
Spatial
Florida
Spatial
Gulf Coast
Spatial
Louisiana
Spatial
Mississippi
Spatial
Texas
Stratum
dealer
Stratum
gear
Stratum
grade
Stratum
species
Stratum
year.month
Data Table
Yes
GSS
Table holding data from 1956 to 1983
1
PORT
NUMBER
22
No
No
2
0
Active
Port of landing.
NUMBER
2
VESSEL_NUMBER
NUMBER
22
No
No
6
0
Active
Official Coast Guard Vessel Number. This column may also contain a number other than a vessel id, in which case the record represents consolidated trips. For consolidated trips, the first four characters of the VESSEL_NUMBER are 9s, the fifth character
NUMBER
3
STATE_VESSEL_ID
VARCHAR2
10
No
No
Active
Official State Boat Registration Number for boats that are registered as a state boat
VARCHAR2
4
DEPARTURE_MONTH
NUMBER
22
No
No
2
0
Active
Trip Departure Month
NUMBER
5
DEPARTURE_DAY
NUMBER
22
No
No
2
0
Active
Trip Departure Day
NUMBER
6
DEPARTURE_YEAR
NUMBER
22
No
No
4
0
Active
Trip Departure Year. (4 character)
NUMBER
7
UNLOAD_MONTH
NUMBER
22
No
No
2
0
Active
Trip Unload Month
NUMBER
8
UNLOAD_DAY
NUMBER
22
No
No
2
0
Active
Trip Unload Day
NUMBER
9
UNLOAD_YEAR
NUMBER
22
No
No
4
0
Active
Trip Unload Year. (4 character)
NUMBER
10
UNLOAD_DATE_CONV
DATE
7
No
No
Active
UNLOAD_DATE converted to DATE type. See DEPARTURE_DATE_CONV for retrieval suggestions.
DATE
11
RIVER_CODE
NUMBER
22
No
No
1
0
Active
Corresponds to first digit of the Water Body Code
NUMBER
12
GRID_CODE
NUMBER
22
No
No
2
0
Active
Corresponds to the second and third positions of the Water Body Code
NUMBER
13
SHORE_CODE
NUMBER
22
No
No
1
0
Active
Corresponds to the fourth position of the Water Body Code
NUMBER
14
DEPTH
NUMBER
22
No
No
2
0
Active
Code that represents depths in 5 fathom increments. Valid codes for this column can be found in the table GSS_DEPTH.
NUMBER
15
DAYS_FISHED
NUMBER
22
No
No
5
1
Active
Number of days fished measured in 24 hours of fishing.
NUMBER
16
NUMBER_OF_TRIPS
NUMBER
22
No
No
6
1
Active
Number of trips associated with the shrimp catch.
NUMBER
17
TYPE_OF_GRADING
NUMBER
22
No
No
1
0
Active
Type of grading, whether done by box or machine.
NUMBER
18
SPECIES_CODE
NUMBER
22
No
No
1
0
Active
Species of shrimp caught. Valid codes for this column can be found in the table SPECIES_CODE_GSS.
NUMBER
19
SIZE_CODE
NUMBER
22
No
No
1
0
Active
Size Code
NUMBER
20
POUNDS
NUMBER
22
No
No
8
0
Active
Pounds of shrimp landed.
NUMBER
21
VALUE
NUMBER
22
No
No
8
0
Active
Dollar value of shrimp landed.
NUMBER
22
CONDITION_OF_LANDING
NUMBER
22
No
No
1
0
Active
Indicates whether the shrimp were landed with their heads on, off or a combination of the two.
NUMBER
23
AVERAGE_PRICE_PER_POUND
NUMBER
22
No
No
4
3
Active
Average price per pound of shrimp.
NUMBER
24
RECORD_TYPE
VARCHAR2
1
No
No
Active
Indicates whether the information was provided by a dealer (T) or whether it was an interview (S)
VARCHAR2
25
SCHEDULE_NUMBER
NUMBER
22
No
No
4
0
Active
Number appearing on the GSS form.
NUMBER
26
DEALER_CODE
VARCHAR2
9
No
No
Active
Dealer code.
VARCHAR2
27
IN_OFF_SHORE_CODE
NUMBER
22
No
No
1
0
Active
A code to indicate the distance from sure of where the shrimp catch was landed.
NUMBER
28
SOURCE_FILE
VARCHAR2
20
No
No
Active
The data file containing this record that was loaded
VARCHAR2
29
TRIP_TICKET_NUMBER
VARCHAR2
10
No
No
Active
The state trip ticket number associated with this record. This was added in 2004
VARCHAR2
30
GEAR_CODE
NUMBER
22
No
No
1
0
Active
Type of gear used during fishing trip. A list of valid gear codes can be found in GEAR_CODE_GSS (GSS_GEARS.)
NUMBER
31
OLD_DEALER_CODE
VARCHAR2
9
No
No
Active
Keeps The old Dealer Code that was on the record prior to the changing of Dealer Codes which was done in 2001
VARCHAR2
32
FORM_VERSION
VARCHAR2
8
No
No
Active
needed for trip identification (added 9/15/06)
VARCHAR2
gov.noaa.nmfs.inport:5515
Lee Weinberger
2007-10-17T10:30:14
SysAdmin InPortAdmin
2022-08-09T17:11:01
2021-05-07
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
www.sefsc.noaa.gov
8:00 a.m. - 4:30 p.m. EST
1001
Public
No
2021-05-07
1 Year
2022-05-07