RP052AA1_V
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:67550 | Updated: August 9, 2022 | Published / External
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 |