Table: GSS_GULF_SHRIMP_06_09
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:5514 | Updated: June 14, 2024 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Table holding data from 2006 to 2009
DescriptionTable holding data from 2006 to 2009
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) |
DEPARTURE_DATE_CONV
DATE |
Departure Date as a Date value when it is possible to contsruct the date value. |
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_CLASS_RANGE_BEGIN
NUMBER |
Beginning of the size range. |
SIZE_CLASS_RANGE_END
NUMBER |
Ending of the size range. |
POUNDS
NUMBER |
Pounds of shrimp landed. |
VALUE
NUMBER |
Dollar value of shrimp landed. |
AVERAGE_PRICE_PER_POUND
NUMBER |
Average price per pound of shrimp. |
CONDITION_OF_LANDING
NUMBER |
Indicates whether the shrimp were landed with their heads on, off or a combination of the two. |
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. |
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 |
DEPARTURE_PORT
NUMBER |
Port of departure. Valid codes for this column can be found in the table GSS_PORTS_SE. |
TRAWL_SIZE
NUMBER |
Size of trawl head rope in feet. |
NUMBER_OF_TRAWLS
NUMBER |
Number of trawls pulled by vessel. |
RETURN_DATE
VARCHAR2 |
Date on which the vessel returned in character type, format MMDDYY. |
RETURN_DATE_CONV
DATE |
Date on which the vessel returned in DATE format. |
NIGHT_EFFORT_HOURS
NUMBER |
Hours of fishing effort at night (1830-0630) |
NIGHT_EFFORT_BROWN
NUMBER |
Night effort for brown shrimp. |
NIGHT_EFFORT_PINK
NUMBER |
Night effort for pink shrimp. |
NIGHT_EFFORT_WHITE
NUMBER |
Night effort for white shrimp. |
NIGHT_EFFORT_OTHER
NUMBER |
Night effort for all other species. |
DAY_EFFORT_HOURS
NUMBER |
Hours of fishing effort during the day (0630 - 1830.) |
DAY_EFFORT_BROWN
NUMBER |
Day effort for brown shrimp. |
DAY_EFFORT_PINK
NUMBER |
Day effort for pink shrimp. |
DAY_EFFORT_WHITE
NUMBER |
Day effort for white shrimp. |
DAY_EFFORT_OTHER
NUMBER |
Night effort for all other species. |
NIGHT_DAY_EFFORT_HOURS
NUMBER |
Fishing effort during night and day. |
NIGHT_DAY_EFFORT_BROWN
NUMBER |
Fishing effort during night and day for brown shrimp. |
NIGHT_DAY_EFFORT_PINK
NUMBER |
Fishing effort during night and day for pink shrimp. |
NIGHT_DAY_EFFORT_WHITE
NUMBER |
Fishing effort during night and day for white shrimp. |
NIGHT_DAY_EFFORT_OTHER
NUMBER |
Fishing effort during night and day for other species. |
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.) |
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. |
CREW
NUMBER |
Number of crew members reported for the trip. |
TEDS
NUMBER |
Used to indicate whether TEDs where observed. This column is currently not used. |
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. |
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 |
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_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
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
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: | 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
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 |
DEPARTURE_DATE_CONV
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: | 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 |