Search Help Show/Hide Menu
Summary
Item Identification
Keywords
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Table holding data from 1956 to 1983

Description

Table holding data from 1956 to 1983

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
PORT
NUMBER
Port of landing.
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
STATE_VESSEL_ID
VARCHAR2
Official State Boat Registration Number for boats that are registered as a state boat
DEPARTURE_MONTH
NUMBER
Trip Departure Month
DEPARTURE_DAY
NUMBER
Trip Departure Day
DEPARTURE_YEAR
NUMBER
Trip Departure Year. (4 character)
UNLOAD_MONTH
NUMBER
Trip Unload Month
UNLOAD_DAY
NUMBER
Trip Unload Day
UNLOAD_YEAR
NUMBER
Trip Unload Year. (4 character)
UNLOAD_DATE_CONV
DATE
UNLOAD_DATE converted to DATE type. See DEPARTURE_DATE_CONV for retrieval suggestions.
RIVER_CODE
NUMBER
Corresponds to first digit of the Water Body Code
GRID_CODE
NUMBER
Corresponds to the second and third positions of the Water Body Code
SHORE_CODE
NUMBER
Corresponds to the fourth position of the Water Body Code
DEPTH
NUMBER
Code that represents depths in 5 fathom increments. Valid codes for this column can be found in the table GSS_DEPTH.
DAYS_FISHED
NUMBER
Number of days fished measured in 24 hours of fishing.
NUMBER_OF_TRIPS
NUMBER
Number of trips associated with the shrimp catch.
TYPE_OF_GRADING
NUMBER
Type of grading, whether done by box or machine.
SPECIES_CODE
NUMBER
Species of shrimp caught. Valid codes for this column can be found in the table SPECIES_CODE_GSS.
SIZE_CODE
NUMBER
Size Code
POUNDS
NUMBER
Pounds of shrimp landed.
VALUE
NUMBER
Dollar value of shrimp landed.
CONDITION_OF_LANDING
NUMBER
Indicates whether the shrimp were landed with their heads on, off or a combination of the two.
AVERAGE_PRICE_PER_POUND
NUMBER
Average price per pound of shrimp.
RECORD_TYPE
VARCHAR2
Indicates whether the information was provided by a dealer (T) or whether it was an interview (S)
SCHEDULE_NUMBER
NUMBER
Number appearing on the GSS form.
DEALER_CODE
VARCHAR2
Dealer code.
IN_OFF_SHORE_CODE
NUMBER
A code to indicate the distance from sure of where the shrimp catch was landed.
SOURCE_FILE
VARCHAR2
The data file containing this record that was loaded
TRIP_TICKET_NUMBER
VARCHAR2
The state trip ticket number associated with this record. This was added in 2004
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.)
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
FORM_VERSION
VARCHAR2
needed for trip identification (added 9/15/06)

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

Item Identification

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

Table holding data from 1956 to 1983

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 1956-1983

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 1956 to 1983

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
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_CODE NUMBER Size Code
100
POUNDS NUMBER Pounds of shrimp landed.
100
VALUE NUMBER Dollar value of shrimp landed.
100
CONDITION_OF_LANDING NUMBER Indicates whether the shrimp were landed with their heads on, off or a combination of the two.
100
AVERAGE_PRICE_PER_POUND NUMBER Average price per pound of shrimp.
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
IN_OFF_SHORE_CODE NUMBER A code to indicate the distance from sure of where the shrimp catch was landed.
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
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
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: 17815
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: 17814
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
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: 17813
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: 17812
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: 17811
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: 17810
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

UNLOAD_MONTH

CC ID: 17809
Seq. Order: 7
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: 17808
Seq. Order: 8
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: 17807
Seq. Order: 9
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: 17806
Seq. Order: 10
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: 17805
Seq. Order: 11
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: 17804
Seq. Order: 12
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: 17803
Seq. Order: 13
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: 17802
Seq. Order: 14
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: 17801
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 1
Status: Active
Description:

Number of days fished measured in 24 hours of fishing.

General Data Type: NUMBER

NUMBER_OF_TRIPS

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

Number of trips associated with the shrimp catch.

General Data Type: NUMBER

TYPE_OF_GRADING

CC ID: 17799
Seq. Order: 17
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: 17798
Seq. Order: 18
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_CODE

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

Size Code

General Data Type: NUMBER

POUNDS

CC ID: 17796
Seq. Order: 20
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: 17795
Seq. Order: 21
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

CONDITION_OF_LANDING

CC ID: 17794
Seq. Order: 22
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

AVERAGE_PRICE_PER_POUND

CC ID: 17793
Seq. Order: 23
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 3
Status: Active
Description:

Average price per pound of shrimp.

General Data Type: NUMBER

RECORD_TYPE

CC ID: 17792
Seq. Order: 24
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: 17791
Seq. Order: 25
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: 17790
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 9
Required: No
Primary Key: No
Status: Active
Description:

Dealer code.

General Data Type: VARCHAR2

IN_OFF_SHORE_CODE

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

A code to indicate the distance from sure of where the shrimp catch was landed.

General Data Type: NUMBER

SOURCE_FILE

CC ID: 17788
Seq. Order: 28
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: 17787
Seq. Order: 29
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

GEAR_CODE

CC ID: 17786
Seq. Order: 30
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

OLD_DEALER_CODE

CC ID: 17785
Seq. Order: 31
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: 17784
Seq. Order: 32
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: 5515
GUID: gov.noaa.nmfs.inport:5515
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