RP015AA1_V
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:65095 | Updated: August 9, 2022 | Published / External
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
![]() |
![]() |
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
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
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
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
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
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Year. |
General Data Type: | VARCHAR2 |
MONTH
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Month. |
General Data Type: | VARCHAR2 |
DAY
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |