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