Table: GSS_GULF_SHRIMP_56_83
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:5515 | Updated: June 14, 2024 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Table holding data from 1956 to 1983
DescriptionTable 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |