MM_SET_GILLNET
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:75194 | Updated: May 21, 2025 | Published / External
Item Identification
| Title: | MM_SET_GILLNET |
|---|
Entity Information
| Description: |
Captures bulk of hard copy Set Gillnet Gear Characteristics Form. Child of mm_gear. |
|---|
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
AKRGEAR_ID | NUMBER(6,0) | Unqiue database identifier for general gear type in use | |
|
100
|
ALARM_USED_CODE | VARCHAR2(1 BYTE) | Are alarms used on this net? | |
|
100
|
ANCHOR_DESCRIPTION | VARCHAR2(60 BYTE) | Description of the type of anchor | |
|
100
|
ANCHOR_TYPE_CODE | VARCHAR2(2 BYTE) | AMMOP code for the type of anchor | |
|
100
|
ANCHOR_TYPE_ID | NUMBER(6,0) | Unique database identifier for the type of anchor | |
|
100
|
ANCHOR_USED_CODE | VARCHAR2(1 BYTE) | Is an anchor/ Are anchors being used on this net? | |
|
100
|
AVERAGE_STRANDS_FLAG | VARCHAR2(1 BYTE) | Flags that instance when the numbe of strands recorded is an average. | |
|
100
|
COMMENTS | VARCHAR2(2000 BYTE) | Comments field | |
|
100
|
DROPLINE_HEIGHT | NUMBER(2,0) | Dropline height (inches) | |
|
100
|
DROPLINE_USED_CODE | VARCHAR2(1 BYTE) | Is dropline used on net? | |
|
100
|
FLOAT_COLOR_CODE | VARCHAR2(2 BYTE) | Uses AMMOP code for color | |
|
100
|
FLOAT_COLOR_ID | NUMBER(6,0) | Unique database identifier for the float color | |
|
100
|
FLOAT_COLOR_NAME | VARCHAR2(20 BYTE) | Uses AMMOP color names | |
|
100
|
FLOAT_COMBO_FLAG | VARCHAR2(1 BYTE) | Are a combination of float types used on this net? | |
|
100
|
FLOAT_LENGTH | NUMBER(5,2) | Length of floats (inches) | |
|
100
|
FLOAT_LINE_MATERIAL_CODE | VARCHAR2(1 BYTE) | AMMOP code for float line type | |
|
100
|
FLOAT_LINE_USED_FLAG | VARCHAR2(1 BYTE) | Is float line used on this net? | |
|
100
|
FLOAT_SHAPE_CODE | VARCHAR2(1 BYTE) | AMMOP code for the shape of floats | |
|
100
|
FLOAT_SPACING | NUMBER(4,0) | Distance between floats (inches) | |
|
100
|
HANGING_RATIO | NUMBER(4,2) | Ratio of corkline/weedline to stretched length of gillnetting. | |
|
100
|
HOOK_SHAPE_CODE | VARCHAR2(2 BYTE) | AMMOP code for the hook shape | |
|
100
|
HOOK_SHAPE_DESCRIPTION | VARCHAR2(60 BYTE) | Description of the hook shape | |
|
100
|
HOOK_SHAPE_ID | NUMBER(6,0) | Unqiue database identifier for the hook shape | |
|
100
|
LEADLINE_USED_CODE | VARCHAR2(1 BYTE) | Is leadline used on this net? | |
|
100
|
LEADLINE_WEIGHT | NUMBER(4,0) | Weight of a leadline in pounds/100 fathoms | |
|
100
|
LIGHT_USED_CODE | VARCHAR2(1 BYTE) | Are lights used on this net? | |
|
100
|
MANUFACTURER_NAME | VARCHAR2(100 BYTE) | The reported name of the gillnet webbing manufacturer. | |
|
100
|
MATERIAL_CODE | VARCHAR2(2 BYTE) | AMMOP code for net material (the fiber characteristics of the gillnet.) | |
|
100
|
MATERIAL_COLOR_CODE | VARCHAR2(2 BYTE) | Uses AMMOP code for color | |
|
100
|
MATERIAL_COLOR_ID | NUMBER(6,0) | Unique database identifier for color | |
|
100
|
MATERIAL_COLOR_NAME | VARCHAR2(20 BYTE) | Uses AMMOP color names | |
|
100
|
MATERIAL_DESCRIPTION | VARCHAR2(60 BYTE) | Descriptive text of net material (gillnet fiber characteristics.) | |
|
100
|
MATERIAL_ID | NUMBER(6,0) | Unique database indentifier for net material | |
|
100
|
MAX_MESHES_DEEP | NUMBER(4,0) | The maximum number of meshes deep found counted on the gillnet. | |
|
100
|
MAX_MESH_SIZE | NUMBER(3,1) | The maximum number of meshes deep found counted on the gillnet. | |
|
100
|
MESHES_DEEP | NUMBER(4,0) | The number meshes deep as average | |
|
100
|
MIN_MESHES_DEEP | NUMBER(4,0) | The minimum number of meshes deep found counted on the gillnet. | |
|
100
|
MIN_MESH_SIZE | NUMBER(3,1) | The minimum number of meshes deep found counted on the gillnet. | |
|
100
|
MMGEAR_ID | NUMBER(6,0) | Unique database identifier for set gillnet record | |
|
100
|
NET_LENGTH | NUMBER(4,0) | Length in fathoms of a gillnet | |
|
100
|
NUMBER_OF_ALARMS | NUMBER(2,0) | Number of alarms used on this net | |
|
100
|
NUMBER_OF_ANCHORS | NUMBER(2,0) | Number of anchors used on this net | |
|
100
|
NUMBER_OF_FLOATS | NUMBER(4,0) | Number of floats used on this net | |
|
100
|
NUMBER_OF_LIGHTS | NUMBER(2,0) | Number of lights used on this net | |
|
100
|
NUMBER_OF_NET_BUOYS | NUMBER(2,0) | Number of buoys used on this net | |
|
100
|
NUMBER_OF_PINGERS | NUMBER(2,0) | Number of pingers used on this net | |
|
100
|
NUMBER_OF_STRANDS | VARCHAR2(5 BYTE) | Number of strands of a set gillnet | |
|
100
|
PCT_PINGERS_WORKING | NUMBER(3,0) | Percent of pingers operating | |
|
100
|
PINGER_BRAND_ID | NUMBER(6,0) | Unique database identifier for pinger brand | |
|
100
|
PINGER_BRAND_NAME | VARCHAR2(60 BYTE) | Pinger brand name | |
|
100
|
PINGER_FREQUENCY | NUMBER(5,0) | Frequency of pingers in use (kHz) | |
|
100
|
PINGER_USED_CODE | VARCHAR2(1 BYTE) | Are pingers in use on this net? | |
|
100
|
SEQUENCE_NUMBER | NUMBER(3,0) | For 2002-2008, always "1" | |
|
100
|
TWINE_SIZE | VARCHAR2(3 BYTE) | Industry standard number for twine size | |
|
100
|
WEEDLINE_MATERIAL_CODE | VARCHAR2(1 BYTE) | AMMOP code for weedline type | |
|
100
|
WEEDLINE_USED_CODE | VARCHAR2(1 BYTE) | Is weedline used on net? |
Attribute Details
AKRGEAR_ID
CC ID: 1374684
| Data Storage Type: | NUMBER(6,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unqiue database identifier for general gear type in use |
ALARM_USED_CODE
CC ID: 1374685
| Data Storage Type: | VARCHAR2(1 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Are alarms used on this net? |
ANCHOR_DESCRIPTION
CC ID: 1374686
| Data Storage Type: | VARCHAR2(60 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Description of the type of anchor |
ANCHOR_TYPE_CODE
CC ID: 1374687
| Data Storage Type: | VARCHAR2(2 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
AMMOP code for the type of anchor |
ANCHOR_TYPE_ID
CC ID: 1374688
| Data Storage Type: | NUMBER(6,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unique database identifier for the type of anchor |
ANCHOR_USED_CODE
CC ID: 1374689
| Data Storage Type: | VARCHAR2(1 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Is an anchor/ Are anchors being used on this net? |
AVERAGE_STRANDS_FLAG
CC ID: 1374690
| Data Storage Type: | VARCHAR2(1 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Flags that instance when the numbe of strands recorded is an average. |
COMMENTS
CC ID: 1374691
| Data Storage Type: | VARCHAR2(2000 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Comments field |
DROPLINE_HEIGHT
CC ID: 1374692
| Data Storage Type: | NUMBER(2,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Dropline height (inches) |
DROPLINE_USED_CODE
CC ID: 1374693
| Data Storage Type: | VARCHAR2(1 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Is dropline used on net? |
FLOAT_COLOR_CODE
CC ID: 1374694
| Data Storage Type: | VARCHAR2(2 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Uses AMMOP code for color |
FLOAT_COLOR_ID
CC ID: 1374695
| Data Storage Type: | NUMBER(6,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unique database identifier for the float color |
FLOAT_COLOR_NAME
CC ID: 1374696
| Data Storage Type: | VARCHAR2(20 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Uses AMMOP color names |
FLOAT_COMBO_FLAG
CC ID: 1374697
| Data Storage Type: | VARCHAR2(1 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Are a combination of float types used on this net? |
FLOAT_LENGTH
CC ID: 1374698
| Data Storage Type: | NUMBER(5,2) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Length of floats (inches) |
FLOAT_LINE_MATERIAL_CODE
CC ID: 1374699
| Data Storage Type: | VARCHAR2(1 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
AMMOP code for float line type |
FLOAT_LINE_USED_FLAG
CC ID: 1374700
| Data Storage Type: | VARCHAR2(1 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Is float line used on this net? |
FLOAT_SHAPE_CODE
CC ID: 1374701
| Data Storage Type: | VARCHAR2(1 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
AMMOP code for the shape of floats |
FLOAT_SPACING
CC ID: 1374702
| Data Storage Type: | NUMBER(4,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Distance between floats (inches) |
HANGING_RATIO
CC ID: 1374703
| Data Storage Type: | NUMBER(4,2) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Ratio of corkline/weedline to stretched length of gillnetting. |
HOOK_SHAPE_CODE
CC ID: 1374704
| Data Storage Type: | VARCHAR2(2 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
AMMOP code for the hook shape |
HOOK_SHAPE_DESCRIPTION
CC ID: 1374705
| Data Storage Type: | VARCHAR2(60 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Description of the hook shape |
HOOK_SHAPE_ID
CC ID: 1374706
| Data Storage Type: | NUMBER(6,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unqiue database identifier for the hook shape |
LEADLINE_USED_CODE
CC ID: 1374707
| Data Storage Type: | VARCHAR2(1 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Is leadline used on this net? |
LEADLINE_WEIGHT
CC ID: 1374708
| Data Storage Type: | NUMBER(4,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Weight of a leadline in pounds/100 fathoms |
LIGHT_USED_CODE
CC ID: 1374709
| Data Storage Type: | VARCHAR2(1 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Are lights used on this net? |
MANUFACTURER_NAME
CC ID: 1374710
| Data Storage Type: | VARCHAR2(100 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The reported name of the gillnet webbing manufacturer. |
MATERIAL_CODE
CC ID: 1374711
| Data Storage Type: | VARCHAR2(2 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
AMMOP code for net material (the fiber characteristics of the gillnet.) |
MATERIAL_COLOR_CODE
CC ID: 1374712
| Data Storage Type: | VARCHAR2(2 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Uses AMMOP code for color |
MATERIAL_COLOR_ID
CC ID: 1374713
| Data Storage Type: | NUMBER(6,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unique database identifier for color |
MATERIAL_COLOR_NAME
CC ID: 1374714
| Data Storage Type: | VARCHAR2(20 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Uses AMMOP color names |
MATERIAL_DESCRIPTION
CC ID: 1374715
| Data Storage Type: | VARCHAR2(60 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Descriptive text of net material (gillnet fiber characteristics.) |
MATERIAL_ID
CC ID: 1374716
| Data Storage Type: | NUMBER(6,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unique database indentifier for net material |
MAX_MESHES_DEEP
CC ID: 1374717
| Data Storage Type: | NUMBER(4,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The maximum number of meshes deep found counted on the gillnet. |
MAX_MESH_SIZE
CC ID: 1374718
| Data Storage Type: | NUMBER(3,1) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The maximum number of meshes deep found counted on the gillnet. |
MESHES_DEEP
CC ID: 1374719
| Data Storage Type: | NUMBER(4,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The number meshes deep as average |
MIN_MESHES_DEEP
CC ID: 1374720
| Data Storage Type: | NUMBER(4,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The minimum number of meshes deep found counted on the gillnet. |
MIN_MESH_SIZE
CC ID: 1374721
| Data Storage Type: | NUMBER(3,1) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The minimum number of meshes deep found counted on the gillnet. |
MMGEAR_ID
CC ID: 1374722
| Data Storage Type: | NUMBER(6,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unique database identifier for set gillnet record |
NET_LENGTH
CC ID: 1374723
| Data Storage Type: | NUMBER(4,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Length in fathoms of a gillnet |
NUMBER_OF_ALARMS
CC ID: 1374724
| Data Storage Type: | NUMBER(2,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of alarms used on this net |
NUMBER_OF_ANCHORS
CC ID: 1374725
| Data Storage Type: | NUMBER(2,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of anchors used on this net |
NUMBER_OF_FLOATS
CC ID: 1374726
| Data Storage Type: | NUMBER(4,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of floats used on this net |
NUMBER_OF_LIGHTS
CC ID: 1374727
| Data Storage Type: | NUMBER(2,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of lights used on this net |
NUMBER_OF_NET_BUOYS
CC ID: 1374728
| Data Storage Type: | NUMBER(2,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of buoys used on this net |
NUMBER_OF_PINGERS
CC ID: 1374729
| Data Storage Type: | NUMBER(2,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of pingers used on this net |
NUMBER_OF_STRANDS
CC ID: 1374730
| Data Storage Type: | VARCHAR2(5 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of strands of a set gillnet |
PCT_PINGERS_WORKING
CC ID: 1374731
| Data Storage Type: | NUMBER(3,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Percent of pingers operating |
PINGER_BRAND_ID
CC ID: 1374732
| Data Storage Type: | NUMBER(6,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unique database identifier for pinger brand |
PINGER_BRAND_NAME
CC ID: 1374733
| Data Storage Type: | VARCHAR2(60 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Pinger brand name |
PINGER_FREQUENCY
CC ID: 1374734
| Data Storage Type: | NUMBER(5,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Frequency of pingers in use (kHz) |
PINGER_USED_CODE
CC ID: 1374735
| Data Storage Type: | VARCHAR2(1 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Are pingers in use on this net? |
SEQUENCE_NUMBER
CC ID: 1374736
| Data Storage Type: | NUMBER(3,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
For 2002-2008, always "1" |
TWINE_SIZE
CC ID: 1374737
| Data Storage Type: | VARCHAR2(3 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Industry standard number for twine size |
WEEDLINE_MATERIAL_CODE
CC ID: 1374738
| Data Storage Type: | VARCHAR2(1 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
AMMOP code for weedline type |
WEEDLINE_USED_CODE
CC ID: 1374739
| Data Storage Type: | VARCHAR2(1 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Is weedline used on net? |
Catalog Details
| Catalog Item ID: | 75194 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:75194 |
| Metadata Record Created By: | Rachel Wuest |
| Metadata Record Created: | 2025-03-06 23:03+0000 |
| Metadata Record Last Modified By: | Daniel Woodrich |
| Metadata Record Last Modified: | 2025-05-21 19:12+0000 |
| Metadata Record Published: | 2025-05-21 |
| Owner Org: | AFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Review Frequency: | 1 Year |