5514
Table: GSS_GULF_SHRIMP_06_09
GSS_GULF_SHRIMP_06_09
Entity
Published / External
22119
Gulf Shrimp System
Data Set
Completed
Table holding data from 2006 to 2009
Loaded by batch 1744, 10-17-2007 10:30
Theme
pounds
Theme
shrimp date
Theme
value
Temporal
2006-2009
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 2006 to 2009
1
PORT
NUMBER
22
No
No
2
0
Active
Port of landing.
NUMBER
2
VESSEL_NUMBER
NUMBER
22
No
No
7
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
DEPARTURE_DATE_CONV
DATE
7
No
No
Active
Departure Date as a Date value when it is possible to contsruct the date value.
DATE
8
UNLOAD_MONTH
NUMBER
22
No
No
2
0
Active
Trip Unload Month
NUMBER
9
UNLOAD_DAY
NUMBER
22
No
No
2
0
Active
Trip Unload Day
NUMBER
10
UNLOAD_YEAR
NUMBER
22
No
No
4
0
Active
Trip Unload Year. (4 character)
NUMBER
11
UNLOAD_DATE_CONV
DATE
7
No
No
Active
UNLOAD_DATE converted to DATE type. See DEPARTURE_DATE_CONV for retrieval suggestions.
DATE
12
RIVER_CODE
NUMBER
22
No
No
1
0
Active
Corresponds to first digit of the Water Body Code
NUMBER
13
GRID_CODE
NUMBER
22
No
No
2
0
Active
Corresponds to the second and third positions of the Water Body Code
NUMBER
14
SHORE_CODE
NUMBER
22
No
No
1
0
Active
Corresponds to the fourth position of the Water Body Code
NUMBER
15
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
16
DAYS_FISHED
NUMBER
22
No
No
6
1
Active
Number of days fished measured in 24 hours of fishing.
NUMBER
17
NUMBER_OF_TRIPS
NUMBER
22
No
No
3
0
Active
Number of trips associated with the shrimp catch.
NUMBER
18
TYPE_OF_GRADING
NUMBER
22
No
No
1
0
Active
Type of grading, whether done by box or machine.
NUMBER
19
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
20
SIZE_CLASS_RANGE_BEGIN
NUMBER
22
No
No
3
0
Active
Beginning of the size range.
NUMBER
21
SIZE_CLASS_RANGE_END
NUMBER
22
No
No
3
0
Active
Ending of the size range.
NUMBER
22
POUNDS
NUMBER
22
No
No
8
0
Active
Pounds of shrimp landed.
NUMBER
23
VALUE
NUMBER
22
No
No
8
0
Active
Dollar value of shrimp landed.
NUMBER
24
AVERAGE_PRICE_PER_POUND
NUMBER
22
No
No
6
2
Active
Average price per pound of shrimp.
NUMBER
25
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
26
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
27
SCHEDULE_NUMBER
NUMBER
22
No
No
4
0
Active
Number appearing on the GSS form.
NUMBER
28
DEALER_CODE
VARCHAR2
9
No
No
Active
Dealer code.
VARCHAR2
29
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
30
DEPARTURE_PORT
NUMBER
22
No
No
2
0
Active
Port of departure. Valid codes for this column can be found in the table GSS_PORTS_SE.
NUMBER
31
TRAWL_SIZE
NUMBER
22
No
No
2
0
Active
Size of trawl head rope in feet.
NUMBER
32
NUMBER_OF_TRAWLS
NUMBER
22
No
No
1
0
Active
Number of trawls pulled by vessel.
NUMBER
33
RETURN_DATE
VARCHAR2
8
No
No
Active
Date on which the vessel returned in character type, format MMDDYY.
VARCHAR2
34
RETURN_DATE_CONV
DATE
7
No
No
Active
Date on which the vessel returned in DATE format.
DATE
35
NIGHT_EFFORT_HOURS
NUMBER
22
No
No
3
0
Active
Hours of fishing effort at night (1830-0630)
NUMBER
36
NIGHT_EFFORT_BROWN
NUMBER
22
No
No
1
0
Active
Night effort for brown shrimp.
NUMBER
37
NIGHT_EFFORT_PINK
NUMBER
22
No
No
1
0
Active
Night effort for pink shrimp.
NUMBER
38
NIGHT_EFFORT_WHITE
NUMBER
22
No
No
1
0
Active
Night effort for white shrimp.
NUMBER
39
NIGHT_EFFORT_OTHER
NUMBER
22
No
No
1
0
Active
Night effort for all other species.
NUMBER
40
DAY_EFFORT_HOURS
NUMBER
22
No
No
3
0
Active
Hours of fishing effort during the day (0630 - 1830.)
NUMBER
41
DAY_EFFORT_BROWN
NUMBER
22
No
No
1
0
Active
Day effort for brown shrimp.
NUMBER
42
DAY_EFFORT_PINK
NUMBER
22
No
No
1
0
Active
Day effort for pink shrimp.
NUMBER
43
DAY_EFFORT_WHITE
NUMBER
22
No
No
1
0
Active
Day effort for white shrimp.
NUMBER
44
DAY_EFFORT_OTHER
NUMBER
22
No
No
1
0
Active
Night effort for all other species.
NUMBER
45
NIGHT_DAY_EFFORT_HOURS
NUMBER
22
No
No
3
0
Active
Fishing effort during night and day.
NUMBER
46
NIGHT_DAY_EFFORT_BROWN
NUMBER
22
No
No
1
0
Active
Fishing effort during night and day for brown shrimp.
NUMBER
47
NIGHT_DAY_EFFORT_PINK
NUMBER
22
No
No
1
0
Active
Fishing effort during night and day for pink shrimp.
NUMBER
48
NIGHT_DAY_EFFORT_WHITE
NUMBER
22
No
No
1
0
Active
Fishing effort during night and day for white shrimp.
NUMBER
49
NIGHT_DAY_EFFORT_OTHER
NUMBER
22
No
No
1
0
Active
Fishing effort during night and day for other species.
NUMBER
50
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
51
ADD_DELETE_CODE
VARCHAR2
1
No
No
Active
Code used to indicate whether rows should be added or deleted. This column is no longer used and is being kept for historical reasons. It will be removed in the future.
VARCHAR2
52
CREW
NUMBER
22
No
No
1
0
Active
Number of crew members reported for the trip.
NUMBER
53
TEDS
NUMBER
22
No
No
1
0
Active
Used to indicate whether TEDs where observed. This column is currently not used.
NUMBER
54
BLANK
VARCHAR2
2
No
No
Active
A column that represents a blank space in the historical records. These "blank" columns will be kept until the historical data have been reviewed because there have been cases were unidentified information were found.
VARCHAR2
55
SOURCE_FILE
VARCHAR2
20
No
No
Active
The data file containing this record that was loaded
VARCHAR2
56
TRIP_TICKET_NUMBER
VARCHAR2
10
No
No
Active
The state trip ticket number associated with this record. This was added in 2004
VARCHAR2
57
FORM_VERSION
VARCHAR2
8
No
No
Active
needed for trip identification (added 9/15/06)
VARCHAR2
gov.noaa.nmfs.inport:5514
Lee Weinberger
2007-10-17T10:30:13
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