5515 GSS_GULF_SHRIMP_56_83 Entity Published / External 22119 Gulf Shrimp System Data Set Completed Table holding data from 1956 to 1983 Loaded by batch 1744, 10-17-2007 10:30 Theme pounds Theme shrimp date Theme value Temporal 1956-1983 Spatial Alabama Spatial Florida Spatial Gulf Coast Spatial Louisiana Spatial Mississippi Spatial Texas Stratum dealer Stratum gear Stratum grade Stratum species Stratum year.month Data Table Yes GSS Table holding data from 1956 to 1983 1 PORT NUMBER 22 No No 2 0 Active Port of landing. NUMBER 2 VESSEL_NUMBER NUMBER 22 No No 6 0 Active 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 NUMBER 3 STATE_VESSEL_ID VARCHAR2 10 No No Active Official State Boat Registration Number for boats that are registered as a state boat VARCHAR2 4 DEPARTURE_MONTH NUMBER 22 No No 2 0 Active Trip Departure Month NUMBER 5 DEPARTURE_DAY NUMBER 22 No No 2 0 Active Trip Departure Day NUMBER 6 DEPARTURE_YEAR NUMBER 22 No No 4 0 Active Trip Departure Year. (4 character) NUMBER 7 UNLOAD_MONTH NUMBER 22 No No 2 0 Active Trip Unload Month NUMBER 8 UNLOAD_DAY NUMBER 22 No No 2 0 Active Trip Unload Day NUMBER 9 UNLOAD_YEAR NUMBER 22 No No 4 0 Active Trip Unload Year. (4 character) NUMBER 10 UNLOAD_DATE_CONV DATE 7 No No Active UNLOAD_DATE converted to DATE type. See DEPARTURE_DATE_CONV for retrieval suggestions. DATE 11 RIVER_CODE NUMBER 22 No No 1 0 Active Corresponds to first digit of the Water Body Code NUMBER 12 GRID_CODE NUMBER 22 No No 2 0 Active Corresponds to the second and third positions of the Water Body Code NUMBER 13 SHORE_CODE NUMBER 22 No No 1 0 Active Corresponds to the fourth position of the Water Body Code NUMBER 14 DEPTH NUMBER 22 No No 2 0 Active Code that represents depths in 5 fathom increments. Valid codes for this column can be found in the table GSS_DEPTH. NUMBER 15 DAYS_FISHED NUMBER 22 No No 5 1 Active Number of days fished measured in 24 hours of fishing. NUMBER 16 NUMBER_OF_TRIPS NUMBER 22 No No 6 1 Active Number of trips associated with the shrimp catch. NUMBER 17 TYPE_OF_GRADING NUMBER 22 No No 1 0 Active Type of grading, whether done by box or machine. NUMBER 18 SPECIES_CODE NUMBER 22 No No 1 0 Active Species of shrimp caught. Valid codes for this column can be found in the table SPECIES_CODE_GSS. NUMBER 19 SIZE_CODE NUMBER 22 No No 1 0 Active Size Code NUMBER 20 POUNDS NUMBER 22 No No 8 0 Active Pounds of shrimp landed. NUMBER 21 VALUE NUMBER 22 No No 8 0 Active Dollar value of shrimp landed. NUMBER 22 CONDITION_OF_LANDING NUMBER 22 No No 1 0 Active Indicates whether the shrimp were landed with their heads on, off or a combination of the two. NUMBER 23 AVERAGE_PRICE_PER_POUND NUMBER 22 No No 4 3 Active Average price per pound of shrimp. NUMBER 24 RECORD_TYPE VARCHAR2 1 No No Active Indicates whether the information was provided by a dealer (T) or whether it was an interview (S) VARCHAR2 25 SCHEDULE_NUMBER NUMBER 22 No No 4 0 Active Number appearing on the GSS form. NUMBER 26 DEALER_CODE VARCHAR2 9 No No Active Dealer code. VARCHAR2 27 IN_OFF_SHORE_CODE NUMBER 22 No No 1 0 Active A code to indicate the distance from sure of where the shrimp catch was landed. NUMBER 28 SOURCE_FILE VARCHAR2 20 No No Active The data file containing this record that was loaded VARCHAR2 29 TRIP_TICKET_NUMBER VARCHAR2 10 No No Active The state trip ticket number associated with this record. This was added in 2004 VARCHAR2 30 GEAR_CODE NUMBER 22 No No 1 0 Active Type of gear used during fishing trip. A list of valid gear codes can be found in GEAR_CODE_GSS (GSS_GEARS.) NUMBER 31 OLD_DEALER_CODE VARCHAR2 9 No No Active Keeps The old Dealer Code that was on the record prior to the changing of Dealer Codes which was done in 2001 VARCHAR2 32 FORM_VERSION VARCHAR2 8 No No Active needed for trip identification (added 9/15/06) VARCHAR2 gov.noaa.nmfs.inport:5515 Lee Weinberger 2007-10-17T10:30:14 Lee Weinberger 2024-06-14T14:05:19 2024-06-14 Southeast Fisheries Science Center SEFSC 75 Virginia Beach Drive Miami FL 33149 USA (305)361-5761 www.sefsc.noaa.gov 8:00 a.m. - 4:30 p.m. EST 1001 Public No 2021-05-07 1 Year 2022-05-07