22119
Gulf Shrimp System
Gulf Shrimp Data Tables
Data Set
Published / External
1915
Gulf shrimp system
Project
In Work
Gulf of Mexico Shrimp Landings - This data set contains catch (landed catch) and effort for fishing trips made by the larger vessels that fish near and offshore for the various species of shrimp in the Gulf of Mexico. The data collection procedures for the catch/effort data for the large vessels consist of two parts. The landings statistics (i.e., quantity, value, etc.) are collected from the seafood dealers after the trips are unloaded whereas, the data on fishing effort (gear, fishing duration) and area are collected by interviews with the captain or crew while the trip is being unloaded.
There are two primary purposes for the implementation of this data collection program. The Gulf shrimp program was initiated to provide comprehensive landings data for all shrimp species caught and landed at ports in the Gulf of Mexico. Second, the program was implemented to provide stock assessment data on fishing effort, amount and location, and the associated catches for offshore trips to determine the catch per unit effort for these vessels.
Data Is confidential
Theme
PARR Exclusion
Non-Environmental Data
Theme
Effort
Theme
Landings
Theme
Penaeid Shrimp
Theme
Shrimp
Theme
Value
Theme
confidential data
Theme
fishdep
Theme
fishery-dependent
Temporal
1956-present
Spatial
Florida
Spatial
Gulf States
Spatial
Louisiana
Spatial
Missippi
Spatial
Texas
Stratum
area
Stratum
county
Stratum
grade
Stratum
market category
Stratum
species
Stratum
state
Stratum
water body
Southeast Fisheries Science Center
Miami
FL
USA
Location Of The Main Office Of The South East Fisheries Science Center
Data Set
Table (digital)
N/A
N/A
N/A
5513
Table: GSS_GULF_SHRIMP_00_05
GSS_GULF_SHRIMP_00_05
Published / External
Completed
Table Holding Data from 2000 to 2005
Loaded by batch 1744, 10-17-2007 10:30
Data Table
Yes
GSS
Table Holding Data from 2000 to 2005
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
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
30
TRAWL_SIZE
NUMBER
22
No
No
2
0
Active
Size of trawl head rope in feet.
NUMBER
31
NUMBER_OF_TRAWLS
NUMBER
22
No
No
1
0
Active
Number of trawls pulled by vessel.
NUMBER
32
RETURN_DATE
VARCHAR2
8
No
No
Active
Date on which the vessel returned in character type, format MMDDYY.
VARCHAR2
33
RETURN_DATE_CONV
DATE
7
No
No
Active
Date on which the vessel returned in DATE format.
DATE
34
NIGHT_EFFORT_HOURS
NUMBER
22
No
No
3
0
Active
Hours of fishing effort at night (1830-0630)
NUMBER
35
NIGHT_EFFORT_BROWN
NUMBER
22
No
No
1
0
Active
Night effort for brown shrimp.
NUMBER
36
NIGHT_EFFORT_PINK
NUMBER
22
No
No
1
0
Active
Night effort for pink shrimp.
NUMBER
37
NIGHT_EFFORT_WHITE
NUMBER
22
No
No
1
0
Active
Night effort for white shrimp.
NUMBER
38
NIGHT_EFFORT_OTHER
NUMBER
22
No
No
1
0
Active
Night effort for all other species.
NUMBER
39
DAY_EFFORT_HOURS
NUMBER
22
No
No
3
0
Active
Hours of fishing effort during the day (0630 - 1830.)
NUMBER
40
DAY_EFFORT_BROWN
NUMBER
22
No
No
1
0
Active
Day effort for brown shrimp.
NUMBER
41
DAY_EFFORT_PINK
NUMBER
22
No
No
1
0
Active
Day effort for pink shrimp.
NUMBER
42
DAY_EFFORT_WHITE
NUMBER
22
No
No
1
0
Active
Day effort for white shrimp.
NUMBER
43
DAY_EFFORT_OTHER
NUMBER
22
No
No
1
0
Active
Night effort for all other species.
NUMBER
44
NIGHT_DAY_EFFORT_HOURS
NUMBER
22
No
No
3
0
Active
Fishing effort during night and day.
NUMBER
45
NIGHT_DAY_EFFORT_BROWN
NUMBER
22
No
No
1
0
Active
Fishing effort during night and day for brown shrimp.
NUMBER
46
NIGHT_DAY_EFFORT_PINK
NUMBER
22
No
No
1
0
Active
Fishing effort during night and day for pink shrimp.
NUMBER
47
NIGHT_DAY_EFFORT_WHITE
NUMBER
22
No
No
1
0
Active
Fishing effort during night and day for white shrimp.
NUMBER
48
NIGHT_DAY_EFFORT_OTHER
NUMBER
22
No
No
1
0
Active
Fishing effort during night and day for other species.
NUMBER
49
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
50
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
51
CREW
NUMBER
22
No
No
1
0
Active
Number of crew members reported for the trip.
NUMBER
52
TEDS
NUMBER
22
No
No
1
0
Active
Used to indicate whether TEDs where observed. This column is currently not used.
NUMBER
53
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
54
SOURCE_FILE
VARCHAR2
20
No
No
Active
The data file containing this record that was loaded
VARCHAR2
55
TRIP_TICKET_NUMBER
VARCHAR2
10
No
No
Active
The state trip ticket number associated with this record. This was added in 2004
VARCHAR2
56
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
57
FORM_VERSION
VARCHAR2
8
No
No
Active
needed for trip identification (added 9/15/06)
VARCHAR2
5514
Table: GSS_GULF_SHRIMP_06_09
GSS_GULF_SHRIMP_06_09
Published / External
Completed
Table holding data from 2006 to 2009
Loaded by batch 1744, 10-17-2007 10:30
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
5515
Table: GSS_GULF_SHRIMP_56_83
GSS_GULF_SHRIMP_56_83
Published / External
Completed
Table holding data from 1956 to 1983
Loaded by batch 1744, 10-17-2007 10:30
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
5516
Table: GSS_GULF_SHRIMP_84_89
GSS_GULF_SHRIMP_84_89
Published / External
Completed
Contains Gulf Shrimp data from the year 1984 until the year 1989. The data had to be split up into two tables to speed up queries because of the large volume of data.
Loaded by batch 1744, 10-17-2007 10:30
Data Table
Yes
GSS
Contains Gulf Shrimp data from the year 1984 until the year 1989. The data had to be split up into two tables to speed up queries because of the large volume of data.
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
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
30
TRAWL_SIZE
NUMBER
22
No
No
2
0
Active
Size of trawl head rope in feet.
NUMBER
31
NUMBER_OF_TRAWLS
NUMBER
22
No
No
1
0
Active
Number of trawls pulled by vessel.
NUMBER
32
RETURN_DATE
VARCHAR2
8
No
No
Active
Date on which the vessel returned in character type, format MMDDYY.
VARCHAR2
33
RETURN_DATE_CONV
DATE
7
No
No
Active
Date on which the vessel returned in DATE format.
DATE
34
NIGHT_EFFORT_HOURS
NUMBER
22
No
No
3
0
Active
Hours of fishing effort at night (1830-0630)
NUMBER
35
NIGHT_EFFORT_BROWN
NUMBER
22
No
No
1
0
Active
Night effort for brown shrimp.
NUMBER
36
NIGHT_EFFORT_PINK
NUMBER
22
No
No
1
0
Active
Night effort for pink shrimp.
NUMBER
37
NIGHT_EFFORT_WHITE
NUMBER
22
No
No
1
0
Active
Night effort for white shrimp.
NUMBER
38
NIGHT_EFFORT_OTHER
NUMBER
22
No
No
1
0
Active
Night effort for all other species.
NUMBER
39
DAY_EFFORT_HOURS
NUMBER
22
No
No
3
0
Active
Hours of fishing effort during the day (0630 - 1830.)
NUMBER
40
DAY_EFFORT_BROWN
NUMBER
22
No
No
1
0
Active
Day effort for brown shrimp.
NUMBER
41
DAY_EFFORT_PINK
NUMBER
22
No
No
1
0
Active
Day effort for pink shrimp.
NUMBER
42
DAY_EFFORT_WHITE
NUMBER
22
No
No
1
0
Active
Day effort for white shrimp.
NUMBER
43
DAY_EFFORT_OTHER
NUMBER
22
No
No
1
0
Active
Night effort for all other species.
NUMBER
44
NIGHT_DAY_EFFORT_HOURS
NUMBER
22
No
No
3
0
Active
Fishing effort during night and day.
NUMBER
45
NIGHT_DAY_EFFORT_BROWN
NUMBER
22
No
No
1
0
Active
Fishing effort during night and day for brown shrimp.
NUMBER
46
NIGHT_DAY_EFFORT_PINK
NUMBER
22
No
No
1
0
Active
Fishing effort during night and day for pink shrimp.
NUMBER
47
NIGHT_DAY_EFFORT_WHITE
NUMBER
22
No
No
1
0
Active
Fishing effort during night and day for white shrimp.
NUMBER
48
NIGHT_DAY_EFFORT_OTHER
NUMBER
22
No
No
1
0
Active
Fishing effort during night and day for other species.
NUMBER
49
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
50
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
51
CREW
NUMBER
22
No
No
1
0
Active
Number of crew members reported for the trip.
NUMBER
52
TEDS
NUMBER
22
No
No
1
0
Active
Used to indicate whether TEDs where observed. This column is currently not used.
NUMBER
53
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
54
SOURCE_FILE
VARCHAR2
20
No
No
Active
The data file containing this record that was loaded
VARCHAR2
55
TRIP_TICKET_NUMBER
VARCHAR2
10
No
No
Active
The state trip ticket number associated with this record. This was added in 2004
VARCHAR2
56
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
57
FORM_VERSION
VARCHAR2
8
No
No
Active
needed for trip identification (added 9/15/06)
VARCHAR2
5517
Table: GSS_GULF_SHRIMP_90_95
GSS_GULF_SHRIMP_90_95
Published / External
Completed
Table holding data from 1990 to 1995
Loaded by batch 1744, 10-17-2007 10:30
Data Table
Yes
GSS
Table holding data from 1990 to 1995
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
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
30
TRAWL_SIZE
NUMBER
22
No
No
2
0
Active
Size of trawl head rope in feet.
NUMBER
31
NUMBER_OF_TRAWLS
NUMBER
22
No
No
1
0
Active
Number of trawls pulled by vessel.
NUMBER
32
RETURN_DATE
VARCHAR2
8
No
No
Active
Date on which the vessel returned in character type, format MMDDYY.
VARCHAR2
33
RETURN_DATE_CONV
DATE
7
No
No
Active
Date on which the vessel returned in DATE format.
DATE
34
NIGHT_EFFORT_HOURS
NUMBER
22
No
No
3
0
Active
Hours of fishing effort at night (1830-0630)
NUMBER
35
NIGHT_EFFORT_BROWN
NUMBER
22
No
No
1
0
Active
Night effort for brown shrimp.
NUMBER
36
NIGHT_EFFORT_PINK
NUMBER
22
No
No
1
0
Active
Night effort for pink shrimp.
NUMBER
37
NIGHT_EFFORT_WHITE
NUMBER
22
No
No
1
0
Active
Night effort for white shrimp.
NUMBER
38
NIGHT_EFFORT_OTHER
NUMBER
22
No
No
1
0
Active
Night effort for all other species.
NUMBER
39
DAY_EFFORT_HOURS
NUMBER
22
No
No
3
0
Active
Hours of fishing effort during the day (0630 - 1830.)
NUMBER
40
DAY_EFFORT_BROWN
NUMBER
22
No
No
1
0
Active
Day effort for brown shrimp.
NUMBER
41
DAY_EFFORT_PINK
NUMBER
22
No
No
1
0
Active
Day effort for pink shrimp.
NUMBER
42
DAY_EFFORT_WHITE
NUMBER
22
No
No
1
0
Active
Day effort for white shrimp.
NUMBER
43
DAY_EFFORT_OTHER
NUMBER
22
No
No
1
0
Active
Night effort for all other species.
NUMBER
44
NIGHT_DAY_EFFORT_HOURS
NUMBER
22
No
No
3
0
Active
Fishing effort during night and day.
NUMBER
45
NIGHT_DAY_EFFORT_BROWN
NUMBER
22
No
No
1
0
Active
Fishing effort during night and day for brown shrimp.
NUMBER
46
NIGHT_DAY_EFFORT_PINK
NUMBER
22
No
No
1
0
Active
Fishing effort during night and day for pink shrimp.
NUMBER
47
NIGHT_DAY_EFFORT_WHITE
NUMBER
22
No
No
1
0
Active
Fishing effort during night and day for white shrimp.
NUMBER
48
NIGHT_DAY_EFFORT_OTHER
NUMBER
22
No
No
1
0
Active
Fishing effort during night and day for other species.
NUMBER
49
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
50
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
51
CREW
NUMBER
22
No
No
1
0
Active
Number of crew members reported for the trip.
NUMBER
52
TEDS
NUMBER
22
No
No
1
0
Active
Used to indicate whether TEDs where observed. This column is currently not used.
NUMBER
53
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
54
SOURCE_FILE
VARCHAR2
20
No
No
Active
The data file containing this record that was loaded
VARCHAR2
55
TRIP_TICKET_NUMBER
VARCHAR2
10
No
No
Active
The state trip ticket number associated with this record. This was added in 2004
VARCHAR2
56
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
57
FORM_VERSION
VARCHAR2
8
No
No
Active
needed for trip identification (added 9/15/06)
VARCHAR2
5518
Table: GSS_GULF_SHRIMP_96_99
GSS_GULF_SHRIMP_96_99
Published / External
Completed
Table hoolding data from 1996 to 1999
Loaded by batch 1744, 10-17-2007 10:30
Data Table
Yes
GSS
Table holding the Gulf shrimp data from 1996 to 1999
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
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
30
TRAWL_SIZE
NUMBER
22
No
No
2
0
Active
Size of trawl head rope in feet.
NUMBER
31
NUMBER_OF_TRAWLS
NUMBER
22
No
No
1
0
Active
Number of trawls pulled by vessel.
NUMBER
32
RETURN_DATE
VARCHAR2
8
No
No
Active
Date on which the vessel returned in character type, format MMDDYY.
VARCHAR2
33
RETURN_DATE_CONV
DATE
7
No
No
Active
Date on which the vessel returned in DATE format.
DATE
34
NIGHT_EFFORT_HOURS
NUMBER
22
No
No
3
0
Active
Hours of fishing effort at night (1830-0630)
NUMBER
35
NIGHT_EFFORT_BROWN
NUMBER
22
No
No
1
0
Active
Night effort for brown shrimp.
NUMBER
36
NIGHT_EFFORT_PINK
NUMBER
22
No
No
1
0
Active
Night effort for pink shrimp.
NUMBER
37
NIGHT_EFFORT_WHITE
NUMBER
22
No
No
1
0
Active
Night effort for white shrimp.
NUMBER
38
NIGHT_EFFORT_OTHER
NUMBER
22
No
No
1
0
Active
Night effort for all other species.
NUMBER
39
DAY_EFFORT_HOURS
NUMBER
22
No
No
3
0
Active
Hours of fishing effort during the day (0630 - 1830.)
NUMBER
40
DAY_EFFORT_BROWN
NUMBER
22
No
No
1
0
Active
Day effort for brown shrimp.
NUMBER
41
DAY_EFFORT_PINK
NUMBER
22
No
No
1
0
Active
Day effort for pink shrimp.
NUMBER
42
DAY_EFFORT_WHITE
NUMBER
22
No
No
1
0
Active
Day effort for white shrimp.
NUMBER
43
DAY_EFFORT_OTHER
NUMBER
22
No
No
1
0
Active
Night effort for all other species.
NUMBER
44
NIGHT_DAY_EFFORT_HOURS
NUMBER
22
No
No
3
0
Active
Fishing effort during night and day.
NUMBER
45
NIGHT_DAY_EFFORT_BROWN
NUMBER
22
No
No
1
0
Active
Fishing effort during night and day for brown shrimp.
NUMBER
46
NIGHT_DAY_EFFORT_PINK
NUMBER
22
No
No
1
0
Active
Fishing effort during night and day for pink shrimp.
NUMBER
47
NIGHT_DAY_EFFORT_WHITE
NUMBER
22
No
No
1
0
Active
Fishing effort during night and day for white shrimp.
NUMBER
48
NIGHT_DAY_EFFORT_OTHER
NUMBER
22
No
No
1
0
Active
Fishing effort during night and day for other species.
NUMBER
49
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
50
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
51
CREW
NUMBER
22
No
No
1
0
Active
Number of crew members reported for the trip.
NUMBER
52
TEDS
NUMBER
22
No
No
1
0
Active
Used to indicate whether TEDs where observed. This column is currently not used.
NUMBER
53
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
54
SOURCE_FILE
VARCHAR2
20
No
No
Active
The data file containing this record that was loaded
VARCHAR2
55
TRIP_TICKET_NUMBER
VARCHAR2
10
No
No
Active
The state trip ticket number associated with this record. This was added in 2004
VARCHAR2
56
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
57
FORM_VERSION
VARCHAR2
8
No
No
Active
needed for trip identification (added 9/15/06)
VARCHAR2
Data Steward
2010
2021
Person
Primrose, James A
james.primrose@noaa.gov
4700 Avenue U
Galveston
TX
77551-5997
409-766-3526
409-766-3508
Contact by email preferred.
Data Steward
1990-01-01
2019
Person
Nance, James M
Retired No known Contact
Distributor
1958
Organization
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
https://www.fisheries.noaa.gov/about/southeast-fisheries-science-center
About SEFSC
Online Resource
8:00 a.m. - 4:30 p.m. EST
Contact by email preferred.
Metadata Contact
2010
2021
Person
Primrose, James A
james.primrose@noaa.gov
4700 Avenue U
Galveston
TX
77551-5997
409-766-3526
409-766-3508
Contact by email preferred.
Point of Contact
2015
Person
Baumer, Tim J
tim.baumer@noaa.gov
4700 Avenue U
Galveston
TX
77551
409-766-3784
Contact by email preferred.
Process Contact
2010-01-01
2021
Person
Primrose, James A
james.primrose@noaa.gov
4700 Avenue U
Galveston
TX
77551-5997
409-766-3526
409-766-3508
Ground Condition
-98
-79
30
22
Gulf Of Mexico
Continuing
1958
Sensitive
N/A
Access is restricted to personnel authorized in accordance with NOAA Administrative Order 216-100. A signed non-disclosure agreement must be on file for all authorized personnel.
These standards and procedures apply to all employees of the SEFSC that need access to confidential fisheries statistics. This includes full time or term employees, contractors, volunteers, and/or other employees associated with the SEFSC, but not directl
Access is restricted to personnel authorized in accordance with NOAA Administrative Order 216-100. A signed non-disclosure agreement must be on file for all authorized personnel.
There must be a clear and demonstrable need for the confidential data that are requested as part of a contract or grant. Confidential data can only be released for the specific contract or grant. Upon completion of the contract or grant, the recipient must either return the data or state that it has been destroyed. The contractor or grantee cannot use the data for any purpose other than the uses stated in the agreement.
Non-published Metadata access is restricted. Published Metadata is available to the public.
Only published metadata are to be used.
Data are validated, checked for errors and quality scored for completeness. Errors discovered are returned to port agents who attempt to correct them.
Yes
10
Yes
Yes
No
365
This data is currently wavered under the current NOAA guidelines for relational databases.
To Be Determined
365
The data resides on a secure database server only accessible through the NMFS network requiring separate multi-factor authentication for both network and database access.
1
Interview data are entered into SEFSC databases. Trip ticket data are collected by Gulf States and transmitted to SEFSC databases. Interview and trip ticket data are validated, error checked, merged and duplicates removed. Errors are returned to port agents who attempt to correct them when possible. This merged data becomes the final yearly landings data.
5513
Entity
Table: GSS_GULF_SHRIMP_00_05
5514
Entity
Table: GSS_GULF_SHRIMP_06_09
5515
Entity
Table: GSS_GULF_SHRIMP_56_83
5516
Entity
Table: GSS_GULF_SHRIMP_84_89
5517
Entity
Table: GSS_GULF_SHRIMP_90_95
5518
Entity
Table: GSS_GULF_SHRIMP_96_99
gov.noaa.nmfs.inport:22119
Lee Weinberger
2014-08-28T20:31:56
SysAdmin InPortAdmin
2023-06-12T13:33:56
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