RI016AA2_RSCH_V
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:53629 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | RI016AA2_RSCH_V |
---|---|
Short Name: | RI016AA2_RSCH_V |
Status: | Completed |
Abstract: |
Size frequency data collected during research cruises. |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Description: |
Size frequency data collected during 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 for the vessel, e.g., 0054, or the last two digits of the year of the cruise and two-digit incremental number of the cruise for the year, e.g., 7504. | |
100
|
STATION_NUMBER | VARCHAR2 | Station number of the fishing operation. | |
100
|
YEAR | VARCHAR2 | Year of catch. | |
100
|
MONTH | VARCHAR2 | Month of catch. | |
100
|
DAY | VARCHAR2 | Day of catch. | |
100
|
LATITUDE_DEGREES | VARCHAR2 | Latitude degrees, in degrees. Units for values are degrees. | |
100
|
LATITUDE_MINUTES | VARCHAR2 | Latitude minutes, in minutes. Units for values are minutes. | |
100
|
LATITUDE_DIRECTION | VARCHAR2 | Latitude direction. | |
100
|
LATITUDE_DD | NUMBER | Computed 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, in degrees. Units for values are degrees. | |
100
|
LONGITUDE_MINUTES | VARCHAR2 | Longitude minutes, in minutes. Units for values are minutes. | |
100
|
LONGITUDE_DIRECTION | VARCHAR2 | Longitude direction. | |
100
|
LONGITUDE_DD | NUMBER | Computed 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
|
SPECIES_CODE | VARCHAR2 | Ten-digit CZM species code. | |
100
|
SPECIES_CODE_5 | VARCHAR2 | Five-digit CZM species code used in the earlier data was moved to a separate column and replaced by the ten-digit code in SPECIES_CODE. | |
100
|
RATIO_SAMPLED_CODE | VARCHAR2 | Code for the ratio of fish sampled. | |
100
|
REMAINDER | VARCHAR2 | The number of fish remaining after sampling the last 1/nth fish. For example, if your ratio was 1 out of 10 and you were measuring 99 fish, then your remainder is 9, i.e., after the 90th fish. | |
100
|
LINE_NUMBER | VARCHAR2 | Consecutive number on the collection form for each fish measured. | |
100
|
TOTAL_OR_FORK_LENGTH_MM | VARCHAR2 | Total or fork length, in tenths of a millimeter. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 5. | |
100
|
STANDARD_LENGTH_MM | VARCHAR2 | Standard length, in tenths of a millimeter. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 5. | |
100
|
WEIGHT_KG | VARCHAR2 | Weight of fish, in thousandths of a kilogram. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are kilograms. Measures are reported with a precision of 5. | |
100
|
TOTAL_OR_FORK_LENGTH_CM | VARCHAR2 | Total or 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 5. | |
100
|
WEIGHT_LB | VARCHAR2 | Weight of fish, in thousandths 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 6. | |
100
|
SEX_CODE | VARCHAR2 | Code for the sex of the fish. | |
100
|
SIZE_CODE | VARCHAR2 | Code for the size of the fish, Pentaceros richardsoni (8554590201). | |
100
|
JOB_NUMBER | VARCHAR2 | A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D84145. | |
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: | 001 = NOAA R/V TOWNSEND CROMWELL 007 = NOAA R/V 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 for the vessel, e.g., 0054, or the last two digits of the year of the cruise and two-digit incremental number of the cruise for the year, e.g., 7504. |
General Data Type: | VARCHAR2 |
STATION_NUMBER
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Station number of the fishing operation. |
General Data Type: | VARCHAR2 |
YEAR
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Year of catch. |
General Data Type: | VARCHAR2 |
MONTH
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Month of catch. |
General Data Type: | VARCHAR2 |
DAY
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Day of catch. |
General Data Type: | VARCHAR2 |
LATITUDE_DEGREES
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude degrees, in degrees. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
LATITUDE_MINUTES
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude minutes, in minutes. Units for values are minutes. |
General Data Type: | VARCHAR2 |
Unit of Measure: | minutes |
LATITUDE_DIRECTION
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude direction. |
General Data Type: | VARCHAR2 |
LATITUDE_DD
Seq. Order: | 12 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 42 |
Required: | No |
Primary Key: | No |
Scale: | 38 |
Status: | Active |
Description: |
Computed 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: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude degrees, in degrees. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
Allowed Values: | N = NORTH S = SOUTH |
LONGITUDE_MINUTES
Seq. Order: | 14 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude minutes, in minutes. Units for values are minutes. |
General Data Type: | VARCHAR2 |
Unit of Measure: | minutes |
LONGITUDE_DIRECTION
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude direction. |
General Data Type: | VARCHAR2 |
Allowed Values: | E = EAST W = WEST |
LONGITUDE_DD
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 41 |
Required: | No |
Primary Key: | No |
Scale: | 36 |
Status: | Active |
Description: |
Computed 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 |
SPECIES_CODE
Seq. Order: | 17 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Ten-digit CZM species code. |
General Data Type: | VARCHAR2 |
SPECIES_CODE_5
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Five-digit CZM species code used in the earlier data was moved to a separate column and replaced by the ten-digit code in SPECIES_CODE. |
General Data Type: | VARCHAR2 |
RATIO_SAMPLED_CODE
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the ratio of fish sampled. |
General Data Type: | VARCHAR2 |
REMAINDER
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The number of fish remaining after sampling the last 1/nth fish. For example, if your ratio was 1 out of 10 and you were measuring 99 fish, then your remainder is 9, i.e., after the 90th fish. |
General Data Type: | VARCHAR2 |
LINE_NUMBER
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Consecutive number on the collection form for each fish measured. |
General Data Type: | VARCHAR2 |
TOTAL_OR_FORK_LENGTH_MM
Seq. Order: | 22 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Scale: | 1 |
Status: | Active |
Description: |
Total or fork length, in tenths of a millimeter. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 5. |
General Data Type: | VARCHAR2 |
Unit of Measure: | millimeters |
STANDARD_LENGTH_MM
Seq. Order: | 23 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Scale: | 1 |
Status: | Active |
Description: |
Standard length, in tenths of a millimeter. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 5. |
General Data Type: | VARCHAR2 |
Unit of Measure: | millimeters |
WEIGHT_KG
Seq. Order: | 24 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Scale: | 3 |
Status: | Active |
Description: |
Weight of fish, in thousandths of a kilogram. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are kilograms. Measures are reported with a precision of 5. |
General Data Type: | VARCHAR2 |
Unit of Measure: | kilograms |
TOTAL_OR_FORK_LENGTH_CM
Seq. Order: | 25 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Scale: | 1 |
Status: | Active |
Description: |
Total or 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 5. |
General Data Type: | VARCHAR2 |
Unit of Measure: | centimeters |
WEIGHT_LB
Seq. Order: | 26 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Scale: | 3 |
Status: | Active |
Description: |
Weight of fish, in thousandths 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 6. |
General Data Type: | VARCHAR2 |
Unit of Measure: | pounds |
SEX_CODE
Seq. Order: | 27 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the sex of the fish. |
General Data Type: | VARCHAR2 |
Allowed Values: | F = FEMALE M = MALE |
SIZE_CODE
Seq. Order: | 28 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the size of the fish, Pentaceros richardsoni (8554590201). |
General Data Type: | VARCHAR2 |
Allowed Values: | 1 = LEAN 2 = INTERMEDIATE 3 = FAT |
JOB_NUMBER
Seq. Order: | 29 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D84145. |
General Data Type: | VARCHAR2 |
SEQUENCE_NUMBER
Seq. Order: | 30 |
---|---|
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: | 31 |
---|---|
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: | 53629 |
---|---|
GUID: | gov.noaa.nmfs.inport:53629 |
Metadata Record Created By: | Brent M Miyamoto |
Metadata Record Created: | 2018-09-10 15:25+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2020-12-18 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2020-12-18 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2021-12-18 |