Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: GSS_GULF_SHRIMP_96_99
Short Name: GSS_GULF_SHRIMP_96_99
Status: Completed
Abstract:

Table hoolding data from 1996 to 1999

Notes:

Loaded by batch 1744, 10-17-2007 10:30

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None pounds
None shrimp date
None value

Temporal Keywords

Thesaurus Keyword
UNCONTROLLED
None 1996-1999

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None Alabama
None Florida
None Gulf Coast
None Louisiana
None Mississippi
None Texas

Stratum Keywords

Thesaurus Keyword
UNCONTROLLED
None dealer
None gear
None grade
None species
None year.month

Physical Location

Organization: Galveston Laboratory
City: Galveston
State/Province: TX

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: GSS
Description:

Table holding the Gulf shrimp data from 1996 to 1999

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
PORT NUMBER Port of landing.
100
VESSEL_NUMBER NUMBER 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
100
STATE_VESSEL_ID VARCHAR2 Official State Boat Registration Number for boats that are registered as a state boat
100
DEPARTURE_MONTH NUMBER Trip Departure Month
100
DEPARTURE_DAY NUMBER Trip Departure Day
100
DEPARTURE_YEAR NUMBER Trip Departure Year. (4 character)
100
DEPARTURE_DATE_CONV DATE Departure Date as a Date value when it is possible to contsruct the date value.
100
UNLOAD_MONTH NUMBER Trip Unload Month
100
UNLOAD_DAY NUMBER Trip Unload Day
100
UNLOAD_YEAR NUMBER Trip Unload Year. (4 character)
100
UNLOAD_DATE_CONV DATE UNLOAD_DATE converted to DATE type. See DEPARTURE_DATE_CONV for retrieval suggestions.
100
RIVER_CODE NUMBER Corresponds to first digit of the Water Body Code
100
GRID_CODE NUMBER Corresponds to the second and third positions of the Water Body Code
100
SHORE_CODE NUMBER Corresponds to the fourth position of the Water Body Code
100
DEPTH NUMBER Code that represents depths in 5 fathom increments. Valid codes for this column can be found in the table GSS_DEPTH.
100
DAYS_FISHED NUMBER Number of days fished measured in 24 hours of fishing.
100
NUMBER_OF_TRIPS NUMBER Number of trips associated with the shrimp catch.
100
TYPE_OF_GRADING NUMBER Type of grading, whether done by box or machine.
100
SPECIES_CODE NUMBER Species of shrimp caught. Valid codes for this column can be found in the table SPECIES_CODE_GSS.
100
SIZE_CLASS_RANGE_BEGIN NUMBER Beginning of the size range.
100
SIZE_CLASS_RANGE_END NUMBER Ending of the size range.
100
POUNDS NUMBER Pounds of shrimp landed.
100
VALUE NUMBER Dollar value of shrimp landed.
100
AVERAGE_PRICE_PER_POUND NUMBER Average price per pound of shrimp.
100
CONDITION_OF_LANDING NUMBER Indicates whether the shrimp were landed with their heads on, off or a combination of the two.
100
RECORD_TYPE VARCHAR2 Indicates whether the information was provided by a dealer (T) or whether it was an interview (S)
100
SCHEDULE_NUMBER NUMBER Number appearing on the GSS form.
100
DEALER_CODE VARCHAR2 Dealer code.
100
DEPARTURE_PORT NUMBER Port of departure. Valid codes for this column can be found in the table GSS_PORTS_SE.
100
TRAWL_SIZE NUMBER Size of trawl head rope in feet.
100
NUMBER_OF_TRAWLS NUMBER Number of trawls pulled by vessel.
100
RETURN_DATE VARCHAR2 Date on which the vessel returned in character type, format MMDDYY.
100
RETURN_DATE_CONV DATE Date on which the vessel returned in DATE format.
100
NIGHT_EFFORT_HOURS NUMBER Hours of fishing effort at night (1830-0630)
100
NIGHT_EFFORT_BROWN NUMBER Night effort for brown shrimp.
100
NIGHT_EFFORT_PINK NUMBER Night effort for pink shrimp.
100
NIGHT_EFFORT_WHITE NUMBER Night effort for white shrimp.
100
NIGHT_EFFORT_OTHER NUMBER Night effort for all other species.
100
DAY_EFFORT_HOURS NUMBER Hours of fishing effort during the day (0630 - 1830.)
100
DAY_EFFORT_BROWN NUMBER Day effort for brown shrimp.
100
DAY_EFFORT_PINK NUMBER Day effort for pink shrimp.
100
DAY_EFFORT_WHITE NUMBER Day effort for white shrimp.
100
DAY_EFFORT_OTHER NUMBER Night effort for all other species.
100
NIGHT_DAY_EFFORT_HOURS NUMBER Fishing effort during night and day.
100
NIGHT_DAY_EFFORT_BROWN NUMBER Fishing effort during night and day for brown shrimp.
100
NIGHT_DAY_EFFORT_PINK NUMBER Fishing effort during night and day for pink shrimp.
100
NIGHT_DAY_EFFORT_WHITE NUMBER Fishing effort during night and day for white shrimp.
100
NIGHT_DAY_EFFORT_OTHER NUMBER Fishing effort during night and day for other species.
100
GEAR_CODE NUMBER Type of gear used during fishing trip. A list of valid gear codes can be found in GEAR_CODE_GSS (GSS_GEARS.)
100
ADD_DELETE_CODE VARCHAR2 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.
100
CREW NUMBER Number of crew members reported for the trip.
100
TEDS NUMBER Used to indicate whether TEDs where observed. This column is currently not used.
100
BLANK VARCHAR2 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.
100
SOURCE_FILE VARCHAR2 The data file containing this record that was loaded
100
TRIP_TICKET_NUMBER VARCHAR2 The state trip ticket number associated with this record. This was added in 2004
100
OLD_DEALER_CODE VARCHAR2 Keeps The old Dealer Code that was on the record prior to the changing of Dealer Codes which was done in 2001
100
FORM_VERSION VARCHAR2 needed for trip identification (added 9/15/06)

Attribute Details

PORT

CC ID: 17986
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Port of landing.

General Data Type: NUMBER

VESSEL_NUMBER

CC ID: 17985
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 7
Scale: 0
Status: Active
Description:

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

General Data Type: NUMBER

STATE_VESSEL_ID

CC ID: 17984
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Official State Boat Registration Number for boats that are registered as a state boat

General Data Type: VARCHAR2

DEPARTURE_MONTH

CC ID: 17983
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Trip Departure Month

General Data Type: NUMBER

DEPARTURE_DAY

CC ID: 17982
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Trip Departure Day

General Data Type: NUMBER

DEPARTURE_YEAR

CC ID: 17981
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Trip Departure Year. (4 character)

General Data Type: NUMBER

DEPARTURE_DATE_CONV

CC ID: 17980
Seq. Order: 7
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Departure Date as a Date value when it is possible to contsruct the date value.

General Data Type: DATE

UNLOAD_MONTH

CC ID: 17979
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Trip Unload Month

General Data Type: NUMBER

UNLOAD_DAY

CC ID: 17978
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Trip Unload Day

General Data Type: NUMBER

UNLOAD_YEAR

CC ID: 17977
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Trip Unload Year. (4 character)

General Data Type: NUMBER

UNLOAD_DATE_CONV

CC ID: 17976
Seq. Order: 11
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

UNLOAD_DATE converted to DATE type. See DEPARTURE_DATE_CONV for retrieval suggestions.

General Data Type: DATE

RIVER_CODE

CC ID: 17975
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Corresponds to first digit of the Water Body Code

General Data Type: NUMBER

GRID_CODE

CC ID: 17974
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Corresponds to the second and third positions of the Water Body Code

General Data Type: NUMBER

SHORE_CODE

CC ID: 17973
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Corresponds to the fourth position of the Water Body Code

General Data Type: NUMBER

DEPTH

CC ID: 17972
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Code that represents depths in 5 fathom increments. Valid codes for this column can be found in the table GSS_DEPTH.

General Data Type: NUMBER

DAYS_FISHED

CC ID: 17971
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 1
Status: Active
Description:

Number of days fished measured in 24 hours of fishing.

General Data Type: NUMBER

NUMBER_OF_TRIPS

CC ID: 17970
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Number of trips associated with the shrimp catch.

General Data Type: NUMBER

TYPE_OF_GRADING

CC ID: 17969
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Type of grading, whether done by box or machine.

General Data Type: NUMBER

SPECIES_CODE

CC ID: 17968
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Species of shrimp caught. Valid codes for this column can be found in the table SPECIES_CODE_GSS.

General Data Type: NUMBER

SIZE_CLASS_RANGE_BEGIN

CC ID: 17967
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Beginning of the size range.

General Data Type: NUMBER

SIZE_CLASS_RANGE_END

CC ID: 17966
Seq. Order: 21
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Ending of the size range.

General Data Type: NUMBER

POUNDS

CC ID: 17965
Seq. Order: 22
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 0
Status: Active
Description:

Pounds of shrimp landed.

General Data Type: NUMBER

VALUE

CC ID: 17964
Seq. Order: 23
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 0
Status: Active
Description:

Dollar value of shrimp landed.

General Data Type: NUMBER

AVERAGE_PRICE_PER_POUND

CC ID: 17963
Seq. Order: 24
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Average price per pound of shrimp.

General Data Type: NUMBER

CONDITION_OF_LANDING

CC ID: 17962
Seq. Order: 25
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Indicates whether the shrimp were landed with their heads on, off or a combination of the two.

General Data Type: NUMBER

RECORD_TYPE

CC ID: 17961
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicates whether the information was provided by a dealer (T) or whether it was an interview (S)

General Data Type: VARCHAR2

SCHEDULE_NUMBER

CC ID: 17960
Seq. Order: 27
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Number appearing on the GSS form.

General Data Type: NUMBER

DEALER_CODE

CC ID: 17959
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 9
Required: No
Primary Key: No
Status: Active
Description:

Dealer code.

General Data Type: VARCHAR2

DEPARTURE_PORT

CC ID: 17958
Seq. Order: 29
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Port of departure. Valid codes for this column can be found in the table GSS_PORTS_SE.

General Data Type: NUMBER

TRAWL_SIZE

CC ID: 17957
Seq. Order: 30
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Size of trawl head rope in feet.

General Data Type: NUMBER

NUMBER_OF_TRAWLS

CC ID: 17956
Seq. Order: 31
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Number of trawls pulled by vessel.

General Data Type: NUMBER

RETURN_DATE

CC ID: 17955
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Date on which the vessel returned in character type, format MMDDYY.

General Data Type: VARCHAR2

RETURN_DATE_CONV

CC ID: 17954
Seq. Order: 33
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date on which the vessel returned in DATE format.

General Data Type: DATE

NIGHT_EFFORT_HOURS

CC ID: 17953
Seq. Order: 34
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Hours of fishing effort at night (1830-0630)

General Data Type: NUMBER

NIGHT_EFFORT_BROWN

CC ID: 17952
Seq. Order: 35
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Night effort for brown shrimp.

General Data Type: NUMBER

NIGHT_EFFORT_PINK

CC ID: 17951
Seq. Order: 36
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Night effort for pink shrimp.

General Data Type: NUMBER

NIGHT_EFFORT_WHITE

CC ID: 17950
Seq. Order: 37
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Night effort for white shrimp.

General Data Type: NUMBER

NIGHT_EFFORT_OTHER

CC ID: 17949
Seq. Order: 38
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Night effort for all other species.

General Data Type: NUMBER

DAY_EFFORT_HOURS

CC ID: 17948
Seq. Order: 39
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Hours of fishing effort during the day (0630 - 1830.)

General Data Type: NUMBER

DAY_EFFORT_BROWN

CC ID: 17947
Seq. Order: 40
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Day effort for brown shrimp.

General Data Type: NUMBER

DAY_EFFORT_PINK

CC ID: 17946
Seq. Order: 41
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Day effort for pink shrimp.

General Data Type: NUMBER

DAY_EFFORT_WHITE

CC ID: 17945
Seq. Order: 42
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Day effort for white shrimp.

General Data Type: NUMBER

DAY_EFFORT_OTHER

CC ID: 17944
Seq. Order: 43
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Night effort for all other species.

General Data Type: NUMBER

NIGHT_DAY_EFFORT_HOURS

CC ID: 17943
Seq. Order: 44
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Fishing effort during night and day.

General Data Type: NUMBER

NIGHT_DAY_EFFORT_BROWN

CC ID: 17942
Seq. Order: 45
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Fishing effort during night and day for brown shrimp.

General Data Type: NUMBER

NIGHT_DAY_EFFORT_PINK

CC ID: 17941
Seq. Order: 46
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Fishing effort during night and day for pink shrimp.

General Data Type: NUMBER

NIGHT_DAY_EFFORT_WHITE

CC ID: 17940
Seq. Order: 47
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Fishing effort during night and day for white shrimp.

General Data Type: NUMBER

NIGHT_DAY_EFFORT_OTHER

CC ID: 17939
Seq. Order: 48
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Fishing effort during night and day for other species.

General Data Type: NUMBER

GEAR_CODE

CC ID: 17938
Seq. Order: 49
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Type of gear used during fishing trip. A list of valid gear codes can be found in GEAR_CODE_GSS (GSS_GEARS.)

General Data Type: NUMBER

ADD_DELETE_CODE

CC ID: 17937
Seq. Order: 50
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

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.

General Data Type: VARCHAR2

CREW

CC ID: 17936
Seq. Order: 51
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Number of crew members reported for the trip.

General Data Type: NUMBER

TEDS

CC ID: 17935
Seq. Order: 52
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Used to indicate whether TEDs where observed. This column is currently not used.

General Data Type: NUMBER

BLANK

CC ID: 17934
Seq. Order: 53
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

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.

General Data Type: VARCHAR2

SOURCE_FILE

CC ID: 17933
Seq. Order: 54
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

The data file containing this record that was loaded

General Data Type: VARCHAR2

TRIP_TICKET_NUMBER

CC ID: 17932
Seq. Order: 55
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

The state trip ticket number associated with this record. This was added in 2004

General Data Type: VARCHAR2

OLD_DEALER_CODE

CC ID: 17931
Seq. Order: 56
Data Storage Type: VARCHAR2
Max Length: 9
Required: No
Primary Key: No
Status: Active
Description:

Keeps The old Dealer Code that was on the record prior to the changing of Dealer Codes which was done in 2001

General Data Type: VARCHAR2

FORM_VERSION

CC ID: 17930
Seq. Order: 57
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

needed for trip identification (added 9/15/06)

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 5518
GUID: gov.noaa.nmfs.inport:5518
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-10-17 10:30+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2024-06-14 14:05+0000
Metadata Record Published: 2024-06-14
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-07
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-07