22120
Gulf Shrimp Code Tables
Gulf Shrimp Code Tablea
Data Set
Published / External
1915
Gulf shrimp system
Project
In Work
List of Codes Tables Used In the Gulf Shrimp Systems.
Only for Internal use
Spatial
Global Change Master Directory (GCMD) Location Keywords
OCEAN > ATLANTIC OCEAN > NORTH ATLANTIC OCEAN > GULF OF MEXICO
Theme
PARR Exclusion
Non-Environmental Data
Theme
Shrimp
Theme
fishdep
Theme
fishery-dependent
Theme
gear
Spatial
Alabama
Spatial
Florida
Spatial
Gulf States
Spatial
Louisiana
Spatial
Mississippi
Spatial
Texas
Stratum
area
Stratum
county
Stratum
grade
Stratum
market category
Stratum
species
Stratum
state
Stratum
water body
Southeast Fisheries Science Center
Miami
FL
USA
5507
Table: GSSXALS_GEAR_CODE
GSSXALS_GEAR_CODE
Published / External
Completed
Contains GSS shrimp species codes with the covertion to NMFS species code and the convertion factor used to convert to heads on.
Loaded by batch 1744, 10-17-2007 10:30
Data Table
Yes
GSS
Contains GSS shrimp species codes with the covertion to NMFS species code and the convertion factor used to convert to heads on.
1
GSS_GEAR_CODE
VARCHAR2
1
No
No
Active
The gear code in the GSS System.
VARCHAR2
2
ALS_GEAR_CODE
VARCHAR2
3
No
No
Active
The gear code in the ALS system.
VARCHAR2
3
DESCRIPTION
VARCHAR2
30
No
No
Active
A description of the gear.
VARCHAR2
5509
Table: GSS_CONDITION_LANDED
GSS_CONDITION_LANDED
Published / External
Completed
Table Of Valid Condition Codes
Loaded by batch 1744, 10-17-2007 10:30
Data Table
Yes
GSS
Table Of Valid Condition Codes
1
CONDITION_CODE
NUMBER
22
No
No
1
0
Active
A code that indicates the condition in which shrimp were landed (heads on, off, both)
NUMBER
2
DESCRIPTION
VARCHAR2
15
No
No
Active
Description of the code.
VARCHAR2
5511
Table: GSS_DEPTH
GSS_DEPTH
Published / External
Completed
Table Of Valid Depth Codes
Loaded by batch 1744, 10-17-2007 10:30
Data Table
Yes
GSS
Table Of Valid Depth Codes
1
DEPTH_CODE
NUMBER
22
No
No
2
0
Active
Code that represents a 5 fathom depth range
NUMBER
2
MIN_DEPTH
NUMBER
22
No
No
3
0
Active
Minimum depth in the range represented by the code.
NUMBER
3
MAX_DEPTH
NUMBER
22
No
No
3
0
Active
Maximum depth in the range represented by the code.
NUMBER
5512
Table: GSS_GRADING_TYPE
GSS_GRADING_TYPE
Published / External
Completed
Contains codes that represent the way in which the shrimp were graded or sorted.
Loaded by batch 1744, 10-17-2007 10:30
Data Table
Yes
GSS
Contains codes that represent the way in which the shrimp were graded or sorted.
1
GRADING_CODE
NUMBER
22
No
No
1
0
Active
Code that represents different methods of grading shrimp.
NUMBER
2
DESCRIPTION
VARCHAR2
20
No
No
Active
Description that illustrates what the code represents.
VARCHAR2
5519
View: GSS_PORTS_SE
GSS_PORTS_SE
Published / External
Completed
View of Valid Port Codes For The Gulf Shrimp System. It is also used to translate GSS Port Codes to NMFS State and County Codes
Loaded by batch 1744, 10-17-2007 10:30
Data View
Yes
GSS
View of Valid Port Codes For The Gulf Shrimp System. It is also used to translate GSS Port Codes to NMFS State and County Codes
1
PORT_NAME
VARCHAR2
25
No
No
Active
Name Of The Port
VARCHAR2
2
NMFS_CODE
VARCHAR2
3
No
No
Active
3 character NMFS County Code
VARCHAR2
3
PORT_CODE
VARCHAR2
2
No
No
Active
Port Code in GSS System
VARCHAR2
4
STATE_CODE
VARCHAR2
2
No
No
Active
Two character NMFS State Code
VARCHAR2
5522
Table: GSS_SIZE
GSS_SIZE
Published / External
Completed
Contains codes to identify the size class ranges of shrimp.
Loaded by batch 1744, 10-17-2007 10:30
Data Table
Yes
GSS
Contains codes to identify the size class ranges of shrimp.
1
SIZE_CODE
NUMBER
22
No
No
1
0
Active
Code used to represent a range of numbers of shrimp per pound for a given size class.
NUMBER
2
MIN_COUNT
VARCHAR2
45
No
No
Active
Minimum number of shrimp for this size category.
VARCHAR2
3
MAX_COUNT
VARCHAR2
3
No
No
Active
Maximum number of shrimp for this size category.
VARCHAR2
5527
View: GSS_WATER_BODY_CODE
GSS_WATER_BODY_CODE
Published / External
Completed
View of Valid Water Body Codes For The Gulf Shrimp System. It is also used to translate GSS Port Codes to NMFS State and County Codes
Loaded by batch 1744, 10-17-2007 10:30
Data View
Yes
GSS
View of Valid Water Body Codes For The Gulf Shrimp System. It is also used to translate GSS Port Codes to NMFS State and County Codes
1
RIVER_CODE
NUMBER
22
No
No
1
0
Active
River Code
NUMBER
2
GRID_CODE
NUMBER
22
No
No
2
0
Active
Grid Code
NUMBER
3
SHORE_CODE
NUMBER
22
No
No
1
0
Active
Shore Code in GSS System
NUMBER
4
DESCRIPTION
VARCHAR2
250
No
No
Active
Description Of The Code
VARCHAR2
5
DATE_ADDED
DATE
7
No
No
Active
Date record was added to this table
DATE
6
CURRENT_YEAR
VARCHAR2
1
No
No
Active
Indicates whether this code set is used to validate at this time
VARCHAR2
5528
Table: GSS_WATER_BODY_GRID
GSS_WATER_BODY_GRID
Published / External
Completed
Contains water body codes, grid numbers and descriptions of areas where finfish or invertebrates are caught.
Loaded by batch 1744, 10-17-2007 10:30
Data Table
Yes
GSS
Contains water body codes, grid numbers and descriptions of areas where finfish or invertebrates are caught.
1
CURRENT_YEAR
VARCHAR2
1
No
No
Active
Current year (?)
VARCHAR2
2
GRID_NUMBER
VARCHAR2
6
No
No
Active
Grid number assigned based on coordinates.
VARCHAR2
3
DESCRIPTION
VARCHAR2
250
No
No
Active
Thorough description of the area the code represents.
VARCHAR2
4
DATE_ADDED
DATE
7
No
No
Active
Date in which the code was added to the table.
DATE
5529
Table: PORT_CODE_SE
PORT_CODE_SE
Published / External
Completed
Table of Valid Port Codes For The Gulf Shrimp System. It is also used to translate GSS Port Codes to NMFS State and County Codes
Loaded by batch 1744, 10-17-2007 10:30
Data Table
Yes
GSS
Table of Valid Port Codes For The Gulf Shrimp System. It is also used to translate GSS Port Codes to NMFS State and County Codes
1
PORT_NAME
VARCHAR2
25
No
No
Active
Name Of The Port
VARCHAR2
2
NMFS_CODE
VARCHAR2
3
No
No
Active
3 character NMFS County Code
VARCHAR2
3
PORT_CODE
VARCHAR2
2
No
No
Active
Port Code in GSS System
VARCHAR2
4
STATE_CODE
VARCHAR2
2
No
No
Active
Two character NMFS State Code
VARCHAR2
5530
Table: SPECIES_CODE_GSS
SPECIES_CODE_GSS
Published / External
Completed
List of valid gss species codes and their equivalent NMFS Codes and the conversion factor to get the reported wigth to whole poundst
Loaded by batch 1744, 10-17-2007 10:30
Data Table
Yes
GSS
List of valid gss species codes and their equivalent NMFS Codes and the conversion factor to get the reported wigth to whole poundst
1
GSS_CODE
VARCHAR2
1
No
No
Active
Gulf Shrimp System specific code.
VARCHAR2
2
SCIENTIFIC_NAME
VARCHAR2
22
No
No
Active
Scientific name.
VARCHAR2
3
COMMON_NAME
VARCHAR2
21
No
No
Active
Common name.
VARCHAR2
4
CONVERSION_FACTOR
NUMBER
22
No
No
3
2
Active
Conversion factor from heads off to heads on.
NUMBER
5
NMFS_CODE
VARCHAR2
4
No
No
Active
Official NMFS code.
VARCHAR2
5531
Table: WATER_BODY_GRID_CODE
WATER_BODY_GRID_CODE
Published / External
Completed
View of Valid Water Body Codes For The Gulf Shrimp System. It is also used to translate GSS Port Codes to NMFS State and County Codes
Loaded by batch 1744, 10-17-2007 10:30
Data Table
Yes
SEFSC
View of Valid Water Body Codes For The Gulf Shrimp System. It is also used to translate GSS Port Codes to NMFS State and County Codes
1
RIVER_CODE
NUMBER
22
No
No
1
0
Active
River Code
NUMBER
2
GRID_CODE
NUMBER
22
No
No
2
0
Active
Grid Code
NUMBER
3
SHORE_CODE
NUMBER
22
No
No
1
0
Active
Shore Code in GSS System
NUMBER
4
DESCRIPTION
VARCHAR2
250
No
No
Active
Description Of The Code
VARCHAR2
5
DATE_ADDED
DATE
7
No
No
Active
Date record was added to this table
DATE
6
CURRENT_YEAR
VARCHAR2
1
No
No
Active
Indicates whether this code set is used to validate at this time
VARCHAR2
Data Steward
2010
2021
Person
Primrose, James A
james.primrose@noaa.gov
4700 Avenue U
Galveston
TX
77551-5997
409-766-3526
409-766-3508
Data Steward
1990-01-01
2019
Person
Nance, James M
Retired No known Contact
Retired
Distributor
1958
Organization
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
https://www.fisheries.noaa.gov/about/southeast-fisheries-science-center
About SEFSC
Online Resource
8:00 a.m. - 4:30 p.m. EST
Contact by email preferred.
Metadata Contact
2010
2021
Person
Primrose, James A
james.primrose@noaa.gov
4700 Avenue U
Galveston
TX
77551-5997
409-766-3526
409-766-3508
Contact by email preferred.
Point of Contact
2015
Person
Baumer, Tim J
tim.baumer@noaa.gov
4700 Avenue U
Galveston
TX
77551
409-766-3784
Contact by email preferred.
Process Contact
2010-01-01
2021
Person
Primrose, James A
james.primrose@noaa.gov
4700 Avenue U
Galveston
TX
77551-5997
409-766-3526
409-766-3508
Oracle Database
5507
Entity
Table: GSSXALS_GEAR_CODE
5509
Entity
Table: GSS_CONDITION_LANDED
5511
Entity
Table: GSS_DEPTH
5512
Entity
Table: GSS_GRADING_TYPE
5522
Entity
Table: GSS_SIZE
5528
Entity
Table: GSS_WATER_BODY_GRID
5529
Entity
Table: PORT_CODE_SE
5530
Entity
Table: SPECIES_CODE_GSS
5531
Entity
Table: WATER_BODY_GRID_CODE
5519
Entity
View: GSS_PORTS_SE
5527
Entity
View: GSS_WATER_BODY_CODE
22119
Data Set
Gulf Shrimp System
Larger Work Citation
gov.noaa.nmfs.inport:22120
Lee Weinberger
2014-08-28T23:35:49
SysAdmin InPortAdmin
2023-06-12T13:33:56
2021-05-07
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