RP052AA1_V
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:67550 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Surface fishing data collected during NOAA research cruises.
DescriptionSurface fishing data collected during NOAA research cruises.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
DATASET_CODE
VARCHAR2 |
Source ID Code assigned by the data entry staff. |
VERSION_CODE
VARCHAR2 |
Code for the format version assigned by the data entry staff. |
VESSEL_CODE
VARCHAR2 |
Code for the vessel. |
CRUISE_NUMBER
VARCHAR2 |
Four digit incremental number of the cruise, e.g., 0022. |
YEAR
VARCHAR2 |
Local year. |
MONTH
VARCHAR2 |
Local month. |
DAY
VARCHAR2 |
Local day. |
LOCAL_TIME
VARCHAR2 |
Local time school sighted. |
OCTANT
VARCHAR2 |
Octant of the globe. OCTANT used to determine latitude direction (N/S), longitude direction (E/W) and the first digit of LONGITUDE_DEGREES (0/1). |
LATITUDE_DEGREES
VARCHAR2 |
Latitude degrees. Units for values are degrees. |
LATITUDE_MINUTES
VARCHAR2 |
Latitude minutes. Units for values are minutes. |
LATITUDE_DIRECTION
VARCHAR2 |
Latitude direction. OCTANT was used to determine LATITUDE_DIRECTION (N/S). |
LATITUDE_DD
NUMBER |
Computed latitude, in decimal degrees, of the sampling site. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. |
LONGITUDE_DEGREES
VARCHAR2 |
Longitude degrees. During data entry, the first digit (0 or 1) was omitted. OCTANT was used to determine the first digit (0 or 1). Units for values are degrees. |
LONGITUDE_MINUTES
VARCHAR2 |
Longitude minutes. Units for values are minutes. |
LONGITUDE_DIRECTION
VARCHAR2 |
Longitude direction. OCTANT was used to determine LONGITUDE_DIRECTION (E/W). |
LONGITUDE_DD
NUMBER |
Computed longitude, in decimal degrees, of the sampling site. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. |
STATION_NUMBER
VARCHAR2 |
Station number. |
LOCAL_TIME_SCHOOL_ABANDONED
VARCHAR2 |
Local time school was abandoned. |
SPECIES_CODE_IN_SCHOOL
VARCHAR2 |
2-digit species code in school. |
FIRST_SPECIES_CODE_IN_CATCH
VARCHAR2 |
2-digit species code of first species in catch. This may or may not be the same as SPECIES_CODE_IN_SCHOOL. The school may have been fished witout results, or it may have been a mixed school with a mixed catch. |
FIRST_SPECIES_NUMBER_CAUGHT
VARCHAR2 |
Number of first species caught. |
FIRST_SPECIES_AVERAGE_LENGTH
VARCHAR2 |
Average length, in centimeters, of first species. Units for values are centimeters. |
SECOND_SPECIES_CODE_IN_CATCH
VARCHAR2 |
2-digit species code of second species in catch. |
SECOND_SPECIES_NUMBER_CAUGHT
VARCHAR2 |
Number of second species caught. |
SECOND_SPECIES_AVERAGE_LENGTH
VARCHAR2 |
Average length, in centimeters, of second species. Units for values are centimeters. |
TOTAL_NUMBER_PASSES
VARCHAR2 |
Total number of passes. |
NUMBER_MEN_HOOKING
VARCHAR2 |
Number of men hooking; the collection form field label is NUMBER_HOOKS_FISHING. |
SCHOOL_LOCATED_BY_CODE
VARCHAR2 |
Code for how the school was located. |
TYPE_OF_SCHOOL_CODE
VARCHAR2 |
Code for the type of school. |
NUMBER_BIRDS_IN_FLOCK_CODE
VARCHAR2 |
Code for the number of birds in the flock. |
FISH_TAGGED_YN
VARCHAR2 |
Code for whether any fish was tagged. |
STOMACH_CONTENTS_YN
VARCHAR2 |
Code for whether the stomach contents were enumerated or preserved. |
GONADS_YN
VARCHAR2 |
Code for whether the gonads were examined or preserved. |
ADDITIONAL_INFO_YN
VARCHAR2 |
Code for whether there is additional information on other logs. |
NUMBER_BUCKETS_BAIT_USED
VARCHAR2 |
Number of buckets of bait used. |
BAIT_SPECIES_CODE
VARCHAR2 |
2-digit code for the bait species. |
SURFACE_WATER_TEMPERATURE
VARCHAR2 |
Surface water temperature, in tenths of a centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are centigrade. Measures are reported with a precision of 3. |
SURFACE_SALINITY
VARCHAR2 |
Surface salinity, in parts per thousand. During data entry, the "3" and the decimal point were omitted; they have been inserted into the data. Units for values are parts per thousand. Measures are reported with a precision of 2. |
NUMBER_SPECIES_MEASURED
VARCHAR2 |
This is an additional field that was written on the data collection form. It had no descriptive field name, other than Column 79. And the record format sheet did not have a field name or data description. It may be the number of different species that were measured for the date and time. |
TIME_ZONE_CODE
VARCHAR2 |
Code for the time zone. |
SEQUENCE_NUMBER
VARCHAR2 |
A consecutive number assigned to each record for a block of data. |
DATE_LOADED
DATE |
Date when the record was loaded into Oracle or updated. |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (PIFSC) for inquiries on this record.
Item Identification
Title: | RP052AA1_V |
---|---|
Short Name: | RP052AA1_V |
Status: | Completed |
Abstract: |
Surface fishing data collected during NOAA research cruises. |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Description: |
Surface fishing data collected during NOAA research cruises. |
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 number of the cruise, e.g., 0022. | |
100
|
YEAR | VARCHAR2 | Local year. | |
100
|
MONTH | VARCHAR2 | Local month. | |
100
|
DAY | VARCHAR2 | Local day. | |
100
|
LOCAL_TIME | VARCHAR2 | Local time school sighted. | |
100
|
OCTANT | VARCHAR2 | Octant of the globe. OCTANT used to determine latitude direction (N/S), longitude direction (E/W) and the first digit of LONGITUDE_DEGREES (0/1). | |
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. OCTANT was used to determine LATITUDE_DIRECTION (N/S). | |
100
|
LATITUDE_DD | NUMBER | Computed latitude, in decimal degrees, of the sampling site. Postive 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. OCTANT was used to determine the first digit (0 or 1). Units for values are degrees. | |
100
|
LONGITUDE_MINUTES | VARCHAR2 | Longitude minutes. Units for values are minutes. | |
100
|
LONGITUDE_DIRECTION | VARCHAR2 | Longitude direction. OCTANT was used to determine LONGITUDE_DIRECTION (E/W). | |
100
|
LONGITUDE_DD | NUMBER | Computed longitude, in decimal degrees, of the sampling site. Postive 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. | |
100
|
LOCAL_TIME_SCHOOL_ABANDONED | VARCHAR2 | Local time school was abandoned. | |
100
|
SPECIES_CODE_IN_SCHOOL | VARCHAR2 | 2-digit species code in school. | |
100
|
FIRST_SPECIES_CODE_IN_CATCH | VARCHAR2 | 2-digit species code of first species in catch. This may or may not be the same as SPECIES_CODE_IN_SCHOOL. The school may have been fished witout results, or it may have been a mixed school with a mixed catch. | |
100
|
FIRST_SPECIES_NUMBER_CAUGHT | VARCHAR2 | Number of first species caught. | |
100
|
FIRST_SPECIES_AVERAGE_LENGTH | VARCHAR2 | Average length, in centimeters, of first species. Units for values are centimeters. | |
100
|
SECOND_SPECIES_CODE_IN_CATCH | VARCHAR2 | 2-digit species code of second species in catch. | |
100
|
SECOND_SPECIES_NUMBER_CAUGHT | VARCHAR2 | Number of second species caught. | |
100
|
SECOND_SPECIES_AVERAGE_LENGTH | VARCHAR2 | Average length, in centimeters, of second species. Units for values are centimeters. | |
100
|
TOTAL_NUMBER_PASSES | VARCHAR2 | Total number of passes. | |
100
|
NUMBER_MEN_HOOKING | VARCHAR2 | Number of men hooking; the collection form field label is NUMBER_HOOKS_FISHING. | |
100
|
SCHOOL_LOCATED_BY_CODE | VARCHAR2 | Code for how the school was located. | |
100
|
TYPE_OF_SCHOOL_CODE | VARCHAR2 | Code for the type of school. | |
100
|
NUMBER_BIRDS_IN_FLOCK_CODE | VARCHAR2 | Code for the number of birds in the flock. | |
100
|
FISH_TAGGED_YN | VARCHAR2 | Code for whether any fish was tagged. | |
100
|
STOMACH_CONTENTS_YN | VARCHAR2 | Code for whether the stomach contents were enumerated or preserved. | |
100
|
GONADS_YN | VARCHAR2 | Code for whether the gonads were examined or preserved. | |
100
|
ADDITIONAL_INFO_YN | VARCHAR2 | Code for whether there is additional information on other logs. | |
100
|
NUMBER_BUCKETS_BAIT_USED | VARCHAR2 | Number of buckets of bait used. | |
100
|
BAIT_SPECIES_CODE | VARCHAR2 | 2-digit code for the bait species. | |
100
|
SURFACE_WATER_TEMPERATURE | VARCHAR2 | Surface water temperature, in tenths of a centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are centigrade. Measures are reported with a precision of 3. | |
100
|
SURFACE_SALINITY | VARCHAR2 | Surface salinity, in parts per thousand. During data entry, the "3" and the decimal point were omitted; they have been inserted into the data. Units for values are parts per thousand. Measures are reported with a precision of 2. | |
100
|
NUMBER_SPECIES_MEASURED | VARCHAR2 | This is an additional field that was written on the data collection form. It had no descriptive field name, other than Column 79. And the record format sheet did not have a field name or data description. It may be the number of different species that were measured for the date and time. | |
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; 007 = CHARLES H GILBERT |
CRUISE_NUMBER
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Four digit incremental number of the cruise, e.g., 0022. |
General Data Type: | VARCHAR2 |
YEAR
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Local year. |
General Data Type: | VARCHAR2 |
MONTH
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Local month. |
General Data Type: | VARCHAR2 |
DAY
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Local day. |
General Data Type: | VARCHAR2 |
LOCAL_TIME
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Local time school sighted. |
General Data Type: | VARCHAR2 |
OCTANT
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Octant of the globe. OCTANT used to determine latitude direction (N/S), longitude direction (E/W) and the first digit of LONGITUDE_DEGREES (0/1). |
General Data Type: | VARCHAR2 |
Allowed Values: | 0 = NORTH LATITUDE, 00 DEG WEST TO 89 DEG 59 MIN WEST LONGITUDE; 1 = NORTH LATITUDE, 90 DEG WEST TO 179 DEG 59 MIN WEST LONGITUDE; 2 = NORTH LATITUDE, 180 DEG TO 90 DEG 01 MIN EAST LONGITUDE; 3 = NORTH LATITUDE, 90 DEG EAST TO 00 DEG 01 MIN EAST LONGITUDE; 5 = SOUTH LATITUDE, 00 DEG WEST TO 89 DEG 59 MIN WEST LONGITUDE; 6 = SOUTH LATITUDE, 90 DEG WEST TO 179 DEG 59 MIN WEST LONGITUDE; 7 = SOUTH LATITUDE, 180 DEG TO 90 DEG 01 MIN EAST LONGITUDE; 8 = SOUTH LATITUDE, 90 DEG EAST TO 00 DEG 01 MIN EAST 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. OCTANT was used to determine LATITUDE_DIRECTION (N/S). |
General Data Type: | VARCHAR2 |
Allowed Values: | N = NORTH; S = SOUTH |
LATITUDE_DD
Seq. Order: | 13 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 42 |
Required: | No |
Primary Key: | No |
Scale: | 38 |
Status: | Active |
Description: |
Computed latitude, in decimal degrees, of the sampling site. Postive 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. OCTANT was used to determine the first digit (0 or 1). 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. OCTANT was used to determine LONGITUDE_DIRECTION (E/W). |
General Data Type: | VARCHAR2 |
Allowed Values: | E = EAST; W = WEST |
LONGITUDE_DD
Seq. Order: | 17 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 41 |
Required: | No |
Primary Key: | No |
Scale: | 36 |
Status: | Active |
Description: |
Computed longitude, in decimal degrees, of the sampling site. Postive 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. |
General Data Type: | VARCHAR2 |
LOCAL_TIME_SCHOOL_ABANDONED
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Local time school was abandoned. |
General Data Type: | VARCHAR2 |
SPECIES_CODE_IN_SCHOOL
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
2-digit species code in school. |
General Data Type: | VARCHAR2 |
Default Value: | 00 = NO FISH; 32 = KATSUWONUS PELAMIS, SKIPJACK, AKU; 33 = EUTHYNNUS SPP., LITTLE TUNNY, KAWAKAWA; 34 = THUNNUS OBESUS, BIGEYE TUNA, AHI; 35 = THUNNUS ALBACARES, YELLOWFIN TUNA, AHI; 41 = AUXIS SPP., FRIGATE MACKEREL; 53 = CORYPHAENIDAE, DOLPHINFISH; MAHIMAHI; 73 = MODIDAE, HEADFISHES OR SUNFISHES, MOLAMOLA; 90 = COMBINATION IN SCHOOLS SKIPJACK-YELLOWFIN; 91 = COMBINATION IN SCHOOLS SKIPJACK-LITTLE TUNNY; 93 = COMBINATION IN SCHOOLS SKIPJACK-BIGEYE; 94 = COMBINATION IN SCHOOLS SKIPJACK-MAHIMAHI; 95 = COMBINATION IN SCHOOLS YELLOWFIN-MAHIMAHI; 96 = COMBINATION IN SCHOOLS OTHER FISH IN COMBINATION; 98 = OTHER THINGS; 99 = UNIDENTIFIED |
FIRST_SPECIES_CODE_IN_CATCH
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
2-digit species code of first species in catch. This may or may not be the same as SPECIES_CODE_IN_SCHOOL. The school may have been fished witout results, or it may have been a mixed school with a mixed catch. |
General Data Type: | VARCHAR2 |
Allowed Values: | 32 = KATSUWONUS PELAMIS, SKIPJACK, AKU; 33 = EUTHYNNUS SPP., LITTLE TUNNY, KAWAKAWA; 34 = THUNNUS OBESUS, BIGEYE TUNA, AHI; 35 = THUNNUS ALBACARES, YELLOWFIN TUNA, AHI; 41 = AUXIS SPP., FRIGATE MACKEREL; 53 = CORYPHAENIDAE, DOLPHINFISH; MAHIMAHI; 90 = COMBINATION IN SCHOOLS SKIPJACK-YELLOWFIN; 95 = COMBINATION IN SCHOOLS YELLOWFIN-MAHIMAHI; 96 = COMBINATION IN SCHOOLS OTHER FISH IN COMBINATION |
FIRST_SPECIES_NUMBER_CAUGHT
Seq. Order: | 22 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of first species caught. |
General Data Type: | VARCHAR2 |
FIRST_SPECIES_AVERAGE_LENGTH
Seq. Order: | 23 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Average length, in centimeters, of first species. Units for values are centimeters. |
General Data Type: | VARCHAR2 |
Unit of Measure: | centimeters |
SECOND_SPECIES_CODE_IN_CATCH
Seq. Order: | 24 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
2-digit species code of second species in catch. |
General Data Type: | VARCHAR2 |
Allowed Values: | 00 = NO FISH; 32 = KATSUWONUS PELAMIS, SKIPJACK, AKU; 33 = EUTHYNNUS SPP., LITTLE TUNNY, KAWAKAWA; 34 = THUNNUS OBESUS, BIGEYE TUNA, AHI; 35 = THUNNUS ALBACARES, YELLOWFIN TUNA, AHI; 41 = AUXIS SPP., FRIGATE MACKEREL |
SECOND_SPECIES_NUMBER_CAUGHT
Seq. Order: | 25 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of second species caught. |
General Data Type: | VARCHAR2 |
SECOND_SPECIES_AVERAGE_LENGTH
Seq. Order: | 26 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Average length, in centimeters, of second species. Units for values are centimeters. |
General Data Type: | VARCHAR2 |
Unit of Measure: | centimeters |
TOTAL_NUMBER_PASSES
Seq. Order: | 27 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Total number of passes. |
General Data Type: | VARCHAR2 |
NUMBER_MEN_HOOKING
Seq. Order: | 28 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of men hooking; the collection form field label is NUMBER_HOOKS_FISHING. |
General Data Type: | VARCHAR2 |
SCHOOL_LOCATED_BY_CODE
Seq. Order: | 29 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for how the school was located. |
General Data Type: | VARCHAR2 |
Allowed Values: | 0 = BIRD FLOCK; 1 = JUMPERS; 2 = SURFACE PATCH; 3 = DEBRIS; 4 = BLIND CHUMMING; 9 = OTHER |
TYPE_OF_SCHOOL_CODE
Seq. Order: | 30 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the type of school. |
General Data Type: | VARCHAR2 |
Allowed Values: | 0 = SUB-SURFACE; 1 = JUMPING; 2 = BREEZING; 3 = FINNING |
NUMBER_BIRDS_IN_FLOCK_CODE
Seq. Order: | 31 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the number of birds in the flock. |
General Data Type: | VARCHAR2 |
Allowed Values: | BLANK, NULL = PRESENT BUT NUMBER NOT RECORDED; 1 = 1; 2 = 2 - 5; 3 = 6 - 10; 4 = 11 - 25; 5 = 26 - 50; 6 = 51 - 100; 7 = 101 - 500; 8 = 501 - 1000; 9 = 1001 - 2000; 0 = OVER 2000 |
FISH_TAGGED_YN
Seq. Order: | 32 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for whether any fish was tagged. |
General Data Type: | VARCHAR2 |
Allowed Values: | 0 = YES; 1 = NO |
STOMACH_CONTENTS_YN
Seq. Order: | 33 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for whether the stomach contents were enumerated or preserved. |
General Data Type: | VARCHAR2 |
Allowed Values: | 0 = YES; 1 = NO |
GONADS_YN
Seq. Order: | 34 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for whether the gonads were examined or preserved. |
General Data Type: | VARCHAR2 |
Allowed Values: | 0 = YES; 1 = NO |
ADDITIONAL_INFO_YN
Seq. Order: | 35 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for whether there is additional information on other logs. |
General Data Type: | VARCHAR2 |
Allowed Values: | 0 = YES; 1 = NO |
NUMBER_BUCKETS_BAIT_USED
Seq. Order: | 36 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of buckets of bait used. |
General Data Type: | VARCHAR2 |
BAIT_SPECIES_CODE
Seq. Order: | 37 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
2-digit code for the bait species. |
General Data Type: | VARCHAR2 |
Allowed Values: | 01 = ELOPIDAE, TENPOUNDERS, AWAAWA; 03 = HARENGULA VITTATA, MARQUESAN SARDINE; 07 = STOLEPHORUS PURPUREUS, ANCHOVY, NEHU; 22 = POECILIIDAE, TOP MINNOWS, MOSQUITO FISH, SWORDTAILS, MOLLIES; 28 = ATHERINIDAE, SILVERSIDES, IAO; 30 = MUGILIDAE, MULLETS, AMAAMA, UOUOA; 32 = KATSUWONUS PELAMIS, SKIPJACK, AKU; 3A = THREADFIN SHAD (FRESHWATER); 55 = CARANGIDAE, JACKS, SCAD, AMBERJACKS; 56 = KUHLIIDAE, MOUNTAIN BASSES, AHOLEHOLE; 59 = MULLIDAE, GOATFISHES, SURMULLETS, WEKE, MOANA, KUMU, OAMA, UPENEUS ARGE; 60 = CICHLIDAE, TILAPIAS; 97 = BAITFISH COMBINATION; 98 = OTHER THINGS |
SURFACE_WATER_TEMPERATURE
Seq. Order: | 38 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Scale: | 1 |
Status: | Active |
Description: |
Surface water temperature, in tenths of a centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are centigrade. Measures are reported with a precision of 3. |
General Data Type: | VARCHAR2 |
Unit of Measure: | centigrade |
SURFACE_SALINITY
Seq. Order: | 39 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Scale: | 4 |
Status: | Active |
Description: |
Surface salinity, in parts per thousand. During data entry, the "3" and the decimal point were omitted; they have been inserted into the data. Units for values are parts per thousand. Measures are reported with a precision of 2. |
General Data Type: | VARCHAR2 |
Unit of Measure: | parts per thousand |
NUMBER_SPECIES_MEASURED
Seq. Order: | 40 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
This is an additional field that was written on the data collection form. It had no descriptive field name, other than Column 79. And the record format sheet did not have a field name or data description. It may be the number of different species that were measured for the date and time. |
General Data Type: | VARCHAR2 |
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: | A = MINUS 1; B = MINUS 2; C = MINUS 3; D = MINUS 4; E = MINUS 5; F = MINUS 6; G = MINUS 7; H = MINUS 8; I = MINUS 9; K = MINUS 10; L = MINUS 11; M = MINUS 12; N = PLUS 1; O = PLUS 2; P = PLUS 3; Q = PLUS 4; R = PLUS 5; S = PLUS 6; T = PLUS 7; U = PLUS 8; V = PLUS 9; W = PLUS 10; X = PLUS 11; Y = PLUS 12; Z = 0 |
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: | 67550 |
---|---|
GUID: | gov.noaa.nmfs.inport:67550 |
Metadata Record Created By: | Brent M Miyamoto |
Metadata Record Created: | 2022-07-15 19:14+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2022-07-16 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2022-07-16 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2023-07-16 |