Slide Menu
InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.2.3. Downtime Schedule Tuesday, November 29, 2022 12:00pm - 1:30pm Eastern / 10:00am - 11:30pm Pacific / 7:00am - 8:30pm Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: https://www.fisheries.noaa.gov/inportserve/waf What's...
View All
Search Help Show/Hide Menu

Item Identification

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

Table holding data from 2006 to 2009

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 2006-2009

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

Entity Information

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

Table holding data from 2006 to 2009

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
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
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
FORM_VERSION VARCHAR2 needed for trip identification (added 9/15/06)

Attribute Details

PORT

CC ID: 17783
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: 17782
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: 17781
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: 17780
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: 17779
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: 17778
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: 17777
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: 17776
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: 17775
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: 17774
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: 17773
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: 17772
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: 17771
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: 17770
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: 17769
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: 17768
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: 17767
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: 17766
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: 17765
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: 17764
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: 17763
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: 17762
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: 17761
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: 17760
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: 17759
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: 17758
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: 17757
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: 17756
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 9
Required: No
Primary Key: No
Status: Active
Description:

Dealer code.

General Data Type: VARCHAR2

OLD_DEALER_CODE

CC ID: 17755
Seq. Order: 29
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

DEPARTURE_PORT

CC ID: 17754
Seq. Order: 30
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: 17753
Seq. Order: 31
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: 17752
Seq. Order: 32
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: 17751
Seq. Order: 33
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: 17750
Seq. Order: 34
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: 17749
Seq. Order: 35
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: 17748
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 brown shrimp.

General Data Type: NUMBER

NIGHT_EFFORT_PINK

CC ID: 17747
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 pink shrimp.

General Data Type: NUMBER

NIGHT_EFFORT_WHITE

CC ID: 17746
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 white shrimp.

General Data Type: NUMBER

NIGHT_EFFORT_OTHER

CC ID: 17745
Seq. Order: 39
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: 17744
Seq. Order: 40
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: 17743
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 brown shrimp.

General Data Type: NUMBER

DAY_EFFORT_PINK

CC ID: 17742
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 pink shrimp.

General Data Type: NUMBER

DAY_EFFORT_WHITE

CC ID: 17741
Seq. Order: 43
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: 17740
Seq. Order: 44
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: 17739
Seq. Order: 45
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: 17738
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 brown shrimp.

General Data Type: NUMBER

NIGHT_DAY_EFFORT_PINK

CC ID: 17737
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 pink shrimp.

General Data Type: NUMBER

NIGHT_DAY_EFFORT_WHITE

CC ID: 17736
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 white shrimp.

General Data Type: NUMBER

NIGHT_DAY_EFFORT_OTHER

CC ID: 17735
Seq. Order: 49
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: 17734
Seq. Order: 50
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: 17733
Seq. Order: 51
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: 17732
Seq. Order: 52
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: 17731
Seq. Order: 53
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: 17730
Seq. Order: 54
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: 17729
Seq. Order: 55
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: 17728
Seq. Order: 56
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

FORM_VERSION

CC ID: 17727
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: 5514
GUID: gov.noaa.nmfs.inport:5514
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-10-17 10:30+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-05-07
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