Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: RP015AA1_V
Short Name: RP015AA1_V
Status: Completed
Abstract:

Gill Netting Data collected during NOAA research vessel cruises between 1956 and 1959.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

Gill Netting Data collected during NOAA research vessel cruises between 1956 and 1959.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
DATASET_CODE VARCHAR2 Source ID Code assigned by the data entry staff.
100
VERSION_CODE VARCHAR2 Code for the format version assigned by the data entry staff.
100
VESSEL_CODE VARCHAR2 Code for the vessel.
100
CRUISE_NUMBER VARCHAR2 Four digit incremental cruise number of the vessel, e.g., 0032.
100
YEAR VARCHAR2 Year.
100
MONTH VARCHAR2 Month.
100
DAY VARCHAR2 Day.
100
TIME_SET_START VARCHAR2 Time set started.
100
OCTANT VARCHAR2 Octant of the globe.
100
LATITUDE_DEGREES VARCHAR2 Latitude degrees. Units for values are degrees.
100
LATITUDE_MINUTES VARCHAR2 Latitude minutes. Units for values are minutes.
100
LATITUDE_DIRECTION VARCHAR2 Latitude direction, determined using OCTANT.
100
LATITUDE_DD NUMBER Computer latitude, in decimal degrees. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.
100
LONGITUDE_DEGREES VARCHAR2 Longitude degrees. During data entry the first digit (0 or 1) was omitted; it has been inserted, using OCTANT. Units for values are degrees.
100
LONGITUDE_MINUTES VARCHAR2 Longitude minutes. Units for values are minutes.
100
LONGITUDE_DIRECTION VARCHAR2 Longitude direction, determined using OCTANT.
100
LONGITUDE_DD NUMBER Computer longitude, in decimal degrees. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
100
STATION_NUMBER VARCHAR2 Station number of gill netting operation.
100
VESSEL_COURSE_SET_DRIFT VARCHAR2 Direction of set (0-360), to the nearest 10 degrees OR Drift.
100
VESSEL_COURSE_HAUL VARCHAR2 Direction of haul (0-360), to the nearest 10 degrees.
100
TOTAL_SET_TIME VARCHAR2 Total time to set, in minutes.
100
TOTAL_SOAK_TIME VARCHAR2 Total soak time, in minutes.
100
TOTAL_HAUL_TIME VARCHAR2 Total time to haul, in minutes.
100
NUMBER_SHACKLES VARCHAR2 Number of shackles of Gill / Trammel Net.
100
FISHING_DEPTH_CODE VARCHAR2 Fishing depth code.
100
SHACKLE_NUMBER VARCHAR2 Shackle number.
100
TRAMMEL_NET_CODE VARCHAR2 Trammel net code.
100
STRETCHED_MESH_SIZE VARCHAR2 Stretched mesh size, in inches.
100
STRETCHED_MESH_SIZE_QUARTER_INCH VARCHAR2 Stretched mesh size fractional component, quarter inch, e.g., 1/2 = 2.
100
SHACKLE_SIZE_LENGTH_CODE VARCHAR2 Shackle size length code, in increments of 50 fathoms, e.g., 50 fathoms = 1, 100 fathoms = 2.
100
SHACKLE_SIZE_DEPTH_CODE VARCHAR2 Shackle size, depth code, in number of meshes deep. (See publication Special Scientific Report -- Fisheries No. 90 and Commercial Fisheries Review, vol. 21, no. 8, Graham and Mann).
100
SHACKLE_TIME_HAUL VARCHAR2 Haul time of shackle.
100
SPECIES_CODE VARCHAR2 2-digit species code.
100
POSITION_IN_NET_CODE VARCHAR2 Code for the position in the net the species was caught.
100
CAUGHT_CODE VARCHAR2 Code for Tangled in net or Gilled.
100
FORK_LENGTH VARCHAR2 Fork length, in tenths of a centimeter. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are centimeters. Measures are reported with a precision of 4.
100
WEIGHT VARCHAR2 Weight, in tenths of a pound. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are pounds. Measures are reported with a precision of 4.
100
SEX_MATURITY_CODE VARCHAR2 Code for the sex and maturity of the species.
100
STOMACH_CONTENTS_CODE VARCHAR2 Code for stomach contents collected.
100
COLLECTIONS_CODE VARCHAR2 Code for the type(s) of collection.
100
TIME_ZONE_CODE VARCHAR2 Code for the time_zone.
100
SEQUENCE_NUMBER VARCHAR2 A consecutive number assigned to each record for a block of data.
100
DATE_LOADED DATE Date when the record was loaded into Oracle or updated.

Attribute Details

DATASET_CODE

CC ID: 1076557
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Source ID Code assigned by the data entry staff.

General Data Type: VARCHAR2

VERSION_CODE

CC ID: 1076558
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Code for the format version assigned by the data entry staff.

General Data Type: VARCHAR2

VESSEL_CODE

CC ID: 1076559
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Code for the vessel.

General Data Type: VARCHAR2
Allowed Values: 004 = HUGH M SMITH; 005 = JOHN R MANNING

CRUISE_NUMBER

CC ID: 1076560
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Four digit incremental cruise number of the vessel, e.g., 0032.

General Data Type: VARCHAR2

YEAR

CC ID: 1076561
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Year.

General Data Type: VARCHAR2

MONTH

CC ID: 1076562
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Month.

General Data Type: VARCHAR2

DAY

CC ID: 1076563
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Day.

General Data Type: VARCHAR2

TIME_SET_START

CC ID: 1076564
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Time set started.

General Data Type: VARCHAR2

OCTANT

CC ID: 1076565
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Octant of the globe.

General Data Type: VARCHAR2
Allowed Values: 1 = NORTH LATITUDE, 90° WEST - 179° 59’ WEST LONGITUDE

LATITUDE_DEGREES

CC ID: 1076566
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Latitude degrees. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

LATITUDE_MINUTES

CC ID: 1076567
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Latitude minutes. Units for values are minutes.

General Data Type: VARCHAR2
Unit of Measure: minutes

LATITUDE_DIRECTION

CC ID: 1076568
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Latitude direction, determined using OCTANT.

General Data Type: VARCHAR2
Allowed Values: N =NORTH

LATITUDE_DD

CC ID: 1076569
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 41
Required: No
Primary Key: No
Scale: 37
Status: Active
Description:

Computer latitude, in decimal degrees. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40.

General Data Type: NUMBER
Unit of Measure: degrees

LONGITUDE_DEGREES

CC ID: 1076570
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Longitude degrees. During data entry the first digit (0 or 1) was omitted; it has been inserted, using OCTANT. Units for values are degrees.

General Data Type: VARCHAR2
Unit of Measure: degrees

LONGITUDE_MINUTES

CC ID: 1076571
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Longitude minutes. Units for values are minutes.

General Data Type: VARCHAR2
Unit of Measure: minutes

LONGITUDE_DIRECTION

CC ID: 1076572
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Longitude direction, determined using OCTANT.

General Data Type: VARCHAR2
Allowed Values: W = WEST

LONGITUDE_DD

CC ID: 1076573
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 41
Required: No
Primary Key: No
Scale: 36
Status: Active
Description:

Computer longitude, in decimal degrees. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.

General Data Type: NUMBER
Unit of Measure: degrees

STATION_NUMBER

CC ID: 1076574
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Station number of gill netting operation.

General Data Type: VARCHAR2

VESSEL_COURSE_SET_DRIFT

CC ID: 1076575
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Direction of set (0-360), to the nearest 10 degrees OR Drift.

General Data Type: VARCHAR2

VESSEL_COURSE_HAUL

CC ID: 1076576
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Direction of haul (0-360), to the nearest 10 degrees.

General Data Type: VARCHAR2

TOTAL_SET_TIME

CC ID: 1076577
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Total time to set, in minutes.

General Data Type: VARCHAR2

TOTAL_SOAK_TIME

CC ID: 1076578
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Total soak time, in minutes.

General Data Type: VARCHAR2

TOTAL_HAUL_TIME

CC ID: 1076579
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Total time to haul, in minutes.

General Data Type: VARCHAR2

NUMBER_SHACKLES

CC ID: 1076580
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Number of shackles of Gill / Trammel Net.

General Data Type: VARCHAR2

FISHING_DEPTH_CODE

CC ID: 1076581
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Fishing depth code.

General Data Type: VARCHAR2
Allowed Values: 1 = SURFACE; 2 = SUBSURFACE

SHACKLE_NUMBER

CC ID: 1076582
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Shackle number.

General Data Type: VARCHAR2

TRAMMEL_NET_CODE

CC ID: 1076583
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Trammel net code.

General Data Type: VARCHAR2
Allowed Values: T = TRAMMEL NET

STRETCHED_MESH_SIZE

CC ID: 1076584
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Stretched mesh size, in inches.

General Data Type: VARCHAR2

STRETCHED_MESH_SIZE_QUARTER_INCH

CC ID: 1076585
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Stretched mesh size fractional component, quarter inch, e.g., 1/2 = 2.

General Data Type: VARCHAR2

SHACKLE_SIZE_LENGTH_CODE

CC ID: 1076586
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Shackle size length code, in increments of 50 fathoms, e.g., 50 fathoms = 1, 100 fathoms = 2.

General Data Type: VARCHAR2
Allowed Values: 1 = 50 FATHOMS; 2 = 100 FATHOMS

SHACKLE_SIZE_DEPTH_CODE

CC ID: 1076587
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Shackle size, depth code, in number of meshes deep. (See publication Special Scientific Report -- Fisheries No. 90 and Commercial Fisheries Review, vol. 21, no. 8, Graham and Mann).

General Data Type: VARCHAR2

SHACKLE_TIME_HAUL

CC ID: 1076588
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Haul time of shackle.

General Data Type: VARCHAR2

SPECIES_CODE

CC ID: 1076589
Seq. Order: 33
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

2-digit species code.

General Data Type: VARCHAR2
Allowed Values: 12 = SALMON; 32 = SKIPJACK; 35 = YELLOWFIN TUNA; 36 = ALBACORE; 37 = BLACK TUNA; 44 = WAHOO; 53 = DOLPHINFISH; 54 = BRAMIDAE; 55 = CARANGIDAE; 73 = MOLIDAE; 74 = MACKEREL OR SALMON SHARK; 75 = BONITO OR MAKO SHARK; 77 = BASKING SHARKS; 81 = GREAT BLUE SHARK; 99 = UNKNOWN; && = MISCELLANEOUS SPECIES, SQUID, TURTLE, OTHERS

POSITION_IN_NET_CODE

CC ID: 1076590
Seq. Order: 34
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for the position in the net the species was caught.

General Data Type: VARCHAR2
Allowed Values: 0 = POSITION NOT KNOWN; 1 = FACING BOW, UPPER; 2= FACING BOW, MIDDLE; 3 = FACING BOW, LOWER; 4 = FACING STERN, UPPER; 5 = FACING STERN MIDDLE; 6 = FACING STERN LOWER; 7 = DIRECTION FACING NOT KNOWN , UPPER; 8 = DIRECTION FACING NOT KNOWN, MIDDLE; 9 = DIRECTION FACING NOT KNOWN, LOWER

CAUGHT_CODE

CC ID: 1076591
Seq. Order: 35
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for Tangled in net or Gilled.

General Data Type: VARCHAR2
Allowed Values: 1 = TANGLED IN NET; 2 = GILLED

FORK_LENGTH

CC ID: 1076592
Seq. Order: 36
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Fork length, in tenths of a centimeter. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are centimeters. Measures are reported with a precision of 4.

General Data Type: VARCHAR2
Unit of Measure: centimeters

WEIGHT

CC ID: 1076593
Seq. Order: 37
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Weight, in tenths of a pound. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are pounds. Measures are reported with a precision of 4.

General Data Type: VARCHAR2
Unit of Measure: pounds

SEX_MATURITY_CODE

CC ID: 1076594
Seq. Order: 38
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for the sex and maturity of the species.

General Data Type: VARCHAR2
Allowed Values: BLANK = NOT EXAMINED; BLANK = IMMATURE, SEX NOT DETERMINED; 0 = MALE, MATURITY UNDETERMINED; 1 = MALE, IMMATURE; 2 = MALE, MATURING; 3 = MALE, RIPE; 4 = MALE, SPENT; 5 = FEMALE, IMMATURE; 6 = FEMALE, MATURING; 7 = FEMALE, RIPE; 8 = FEMALE, SPENT; 9 = FEMALE, MATURITY UNDETERMINED

STOMACH_CONTENTS_CODE

CC ID: 1076595
Seq. Order: 39
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for stomach contents collected.

General Data Type: VARCHAR2
Allowed Values: 1 = STOMACH CONTENTS SAMPLED AND ENUMERATED; 2 = STOMACH CONTENTS PRESERVED

COLLECTIONS_CODE

CC ID: 1076596
Seq. Order: 40
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for the type(s) of collection.

General Data Type: VARCHAR2
Allowed Values: 1 = GONAD CONDITION LISTED OR GONAD TAKEN; 2 = HARD PARTS TAKEN; 3 = BLOOD TAKEN; 4 = GONADS AND HARD PARTS TAKEN; 5 = GONADS AND BLOOD TAKEN; 6 = HARD PARTS AND BLOOD TAKEN; 7 = GONADS, HARD PARTS AND BLOOD TAKEN; 8 = WHOLE FISH AND/OR FISH FLESH TAKEN; 9 = EYE OR PINEAL REGION TAKEN

TIME_ZONE_CODE

CC ID: 1076597
Seq. Order: 41
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for the time_zone.

General Data Type: VARCHAR2
Allowed Values: U = +8; V = +9; W = +10; X = +11; Y = +12

SEQUENCE_NUMBER

CC ID: 1076598
Seq. Order: 42
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

A consecutive number assigned to each record for a block of data.

General Data Type: VARCHAR2

DATE_LOADED

CC ID: 1076599
Seq. Order: 43
Data Storage Type: DATE
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Date when the record was loaded into Oracle or updated.

General Data Type: DATE

Catalog Details

Catalog Item ID: 65095
GUID: gov.noaa.nmfs.inport:65095
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2021-07-29 22:28+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-07-30
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-07-30
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-07-30