Search Help Show/Hide Menu
Metadata Rubric
83%
5 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > AMMOP > AMMOP Oracle database 1999 - 2013 >

MM_SET_GILLNET

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:75194  |  Updated: May 21, 2025  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Description

Captures bulk of hard copy Set Gillnet Gear Characteristics Form. Child of mm_gear.

Entity Information

Data Attribute / Type Description
AKRGEAR_ID
NUMBER(6,0) 		Unqiue database identifier for general gear type in use
ALARM_USED_CODE
VARCHAR2(1 BYTE) 		Are alarms used on this net?
ANCHOR_DESCRIPTION
VARCHAR2(60 BYTE) 		Description of the type of anchor
ANCHOR_TYPE_CODE
VARCHAR2(2 BYTE) 		AMMOP code for the type of anchor
ANCHOR_TYPE_ID
NUMBER(6,0) 		Unique database identifier for the type of anchor
ANCHOR_USED_CODE
VARCHAR2(1 BYTE) 		Is an anchor/ Are anchors being used on this net?
AVERAGE_STRANDS_FLAG
VARCHAR2(1 BYTE) 		Flags that instance when the numbe of strands recorded is an average.
COMMENTS
VARCHAR2(2000 BYTE) 		Comments field
DROPLINE_HEIGHT
NUMBER(2,0) 		Dropline height (inches)
DROPLINE_USED_CODE
VARCHAR2(1 BYTE) 		Is dropline used on net?
FLOAT_COLOR_CODE
VARCHAR2(2 BYTE) 		Uses AMMOP code for color
FLOAT_COLOR_ID
NUMBER(6,0) 		Unique database identifier for the float color
FLOAT_COLOR_NAME
VARCHAR2(20 BYTE) 		Uses AMMOP color names
FLOAT_COMBO_FLAG
VARCHAR2(1 BYTE) 		Are a combination of float types used on this net?
FLOAT_LENGTH
NUMBER(5,2) 		Length of floats (inches)
FLOAT_LINE_MATERIAL_CODE
VARCHAR2(1 BYTE) 		AMMOP code for float line type
FLOAT_LINE_USED_FLAG
VARCHAR2(1 BYTE) 		Is float line used on this net?
FLOAT_SHAPE_CODE
VARCHAR2(1 BYTE) 		AMMOP code for the shape of floats
FLOAT_SPACING
NUMBER(4,0) 		Distance between floats (inches)
HANGING_RATIO
NUMBER(4,2) 		Ratio of corkline/weedline to stretched length of gillnetting.
HOOK_SHAPE_CODE
VARCHAR2(2 BYTE) 		AMMOP code for the hook shape
HOOK_SHAPE_DESCRIPTION
VARCHAR2(60 BYTE) 		Description of the hook shape
HOOK_SHAPE_ID
NUMBER(6,0) 		Unqiue database identifier for the hook shape
LEADLINE_USED_CODE
VARCHAR2(1 BYTE) 		Is leadline used on this net?
LEADLINE_WEIGHT
NUMBER(4,0) 		Weight of a leadline in pounds/100 fathoms
LIGHT_USED_CODE
VARCHAR2(1 BYTE) 		Are lights used on this net?
MANUFACTURER_NAME
VARCHAR2(100 BYTE) 		The reported name of the gillnet webbing manufacturer.
MATERIAL_CODE
VARCHAR2(2 BYTE) 		AMMOP code for net material (the fiber characteristics of the gillnet.)
MATERIAL_COLOR_CODE
VARCHAR2(2 BYTE) 		Uses AMMOP code for color
MATERIAL_COLOR_ID
NUMBER(6,0) 		Unique database identifier for color
MATERIAL_COLOR_NAME
VARCHAR2(20 BYTE) 		Uses AMMOP color names
MATERIAL_DESCRIPTION
VARCHAR2(60 BYTE) 		Descriptive text of net material (gillnet fiber characteristics.)
MATERIAL_ID
NUMBER(6,0) 		Unique database indentifier for net material
MAX_MESHES_DEEP
NUMBER(4,0) 		The maximum number of meshes deep found counted on the gillnet.
MAX_MESH_SIZE
NUMBER(3,1) 		The maximum number of meshes deep found counted on the gillnet.
MESHES_DEEP
NUMBER(4,0) 		The number meshes deep as average
MIN_MESHES_DEEP
NUMBER(4,0) 		The minimum number of meshes deep found counted on the gillnet.
MIN_MESH_SIZE
NUMBER(3,1) 		The minimum number of meshes deep found counted on the gillnet.
MMGEAR_ID
NUMBER(6,0) 		Unique database identifier for set gillnet record
NET_LENGTH
NUMBER(4,0) 		Length in fathoms of a gillnet
NUMBER_OF_ALARMS
NUMBER(2,0) 		Number of alarms used on this net
NUMBER_OF_ANCHORS
NUMBER(2,0) 		Number of anchors used on this net
NUMBER_OF_FLOATS
NUMBER(4,0) 		Number of floats used on this net
NUMBER_OF_LIGHTS
NUMBER(2,0) 		Number of lights used on this net
NUMBER_OF_NET_BUOYS
NUMBER(2,0) 		Number of buoys used on this net
NUMBER_OF_PINGERS
NUMBER(2,0) 		Number of pingers used on this net
NUMBER_OF_STRANDS
VARCHAR2(5 BYTE) 		Number of strands of a set gillnet
PCT_PINGERS_WORKING
NUMBER(3,0) 		Percent of pingers operating
PINGER_BRAND_ID
NUMBER(6,0) 		Unique database identifier for pinger brand
PINGER_BRAND_NAME
VARCHAR2(60 BYTE) 		Pinger brand name
PINGER_FREQUENCY
NUMBER(5,0) 		Frequency of pingers in use (kHz)
PINGER_USED_CODE
VARCHAR2(1 BYTE) 		Are pingers in use on this net?
SEQUENCE_NUMBER
NUMBER(3,0) 		For 2002-2008, always "1"
TWINE_SIZE
VARCHAR2(3 BYTE) 		Industry standard number for twine size
WEEDLINE_MATERIAL_CODE
VARCHAR2(1 BYTE) 		AMMOP code for weedline type
WEEDLINE_USED_CODE
VARCHAR2(1 BYTE) 		Is weedline used on net?

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

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

Rubric Score Primary Key? 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