RV002AA5_V
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:52866 | Updated: February 6, 2023 | Published / External
Item Identification
Title: | RV002AA5_V |
---|---|
Short Name: | RV002AA5_V |
Status: | Completed |
Abstract: |
Station number and operation conducted at stations during the 1978-2002 cruises of the NOAA R/V Townsend Cromwell, the 2003 and 2007 cruises of the NOAA R/V Oscar E Sette and the 1981-1983 cruises of the Hokusei Maru, Japanese research and training vessel. |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Description: |
Station number and operation conducted at stations during the 1978-2002 cruises of the NOAA R/V Townsend Cromwell, the 2003 and 2007 cruises of the NOAA R/V Oscar E Sette and the 1981-1983 cruises of the Hokusei Maru, Japanese research and training vessel. |
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 | Last two digits of the year of the cruise and two digits incremental number of the cruise for the year, e.g., 7802. | |
100
|
YEAR | VARCHAR2 | Year of the station operation. | |
100
|
MONTH | VARCHAR2 | Month of the station operation. | |
100
|
DAY | VARCHAR2 | Day of the station operation started. | |
100
|
STATION_NUMBER | VARCHAR2 | Station number of the operation. | |
100
|
LATITUDE_DEGREES | VARCHAR2 | Latitude degrees of the station operation. Units for values are degrees. | |
100
|
LATITUDE_MINUTES | VARCHAR2 | Latitude minutes of the station operation, in tenths of a minute. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are minutes. | |
100
|
LATITUDE_DIRECTION | VARCHAR2 | Latitude direction of the station operation. | |
100
|
LATITUDE_DD | NUMBER | Computed latitude, in decimal degrees, of the station operation. 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 of the station operation. Units for values are degrees. | |
100
|
LONGITUDE_MINUTES | VARCHAR2 | Longitude minutes of the station operation, in tenths of a minute. During data entry, the decimal point was not omitted; it has been inserted into the data. Units for values are minutes. | |
100
|
LONGITUDE_DIRECTION | VARCHAR2 | Longitude direction of the station operation. | |
100
|
LONGITUDE_DD | NUMBER | Computed longitude, in decimal degrees, of the station operation. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. | |
100
|
XBT_CODE | VARCHAR2 | Code whether an XBT was deployed. | |
100
|
SURFACE_SAMPLE_CODE | VARCHAR2 | Code whether a SURFACE SAMPLE was collected. | |
100
|
ACTIVITY_01_CODE | VARCHAR2 | Activity_code for the first operation at the station. | |
100
|
ACTIVITY_02_CODE | VARCHAR2 | Activity_code for the second operation at the station. | |
100
|
ACTIVITY_03_CODE | VARCHAR2 | Activity_code for the third operation at the station. | |
100
|
ACTIVITY_04_CODE | VARCHAR2 | Activity_code for the fourth operation at the station. | |
100
|
ACTIVITY_05_CODE | VARCHAR2 | Activity_code for the fifth operation at the station. | |
100
|
ACTIVITY_06_CODE | VARCHAR2 | Activity_code for the sixth operation at the station. | |
100
|
ACTIVITY_07_CODE | VARCHAR2 | Activity_code for the seventh operation at the station. | |
100
|
ACTIVITY_08_CODE | VARCHAR2 | Activity_code for the eighth operation at the station. | |
100
|
ACTIVITY_09_CODE | VARCHAR2 | Activity_code for the ninth operation at the station. | |
100
|
ACTIVITY_10_CODE | VARCHAR2 | Activity_code for the tenth operation at the station. | |
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., D83021. | |
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; OES = NOAA R/ V OSCAR E SETTE; 995 = HOKUSEI MARU (JAPANESE RESEARCH AND TRAINING VESSEL) |
CRUISE_NUMBER
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Last two digits of the year of the cruise and two digits incremental number of the cruise for the year, e.g., 7802. |
General Data Type: | VARCHAR2 |
YEAR
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Year of the station operation. |
General Data Type: | VARCHAR2 |
MONTH
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Month of the station operation. |
General Data Type: | VARCHAR2 |
DAY
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Day of the station operation started. |
General Data Type: | VARCHAR2 |
STATION_NUMBER
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Station number of the operation. |
General Data Type: | VARCHAR2 |
Allowed Values: | 001 - 521; VESSEL_CODE=001, CRUISE_NUMBER=7902 ALSO HAS 2-CHARACTER CODES: AI = "INSHORE SOUTH PT., BIG ISLAND HAWAII"; AL = "OFFSHORE, LEEWARD BIG ISLAND HAWAII (SOUTH PT.)"; AW = "OFFSHORE HILO, BIG ISLAND HAWAII"; BI = "INSHORE KAWAIHAE, BIG ISLAND HAWAII"; BL = "OFFSHORE KEAHOLE PT., BIG ISLAND HAWAII"; BW = "OFFHORE UPOLU PT., BIG ISLAND HAWAII"; CI = "INSHORE MOLOKAI"; CL = "OFFSHORE, LEEWARD LANAI"; DI = "INSHORE, WAIANAE, OAHU"; DL = "OFFSHORE, WAIANAE, OAHU"; DW = "OFFSHORE KAHUKU PT., OAHU"; EI = "INSHORE, NIHOA"; EL = "OFFSHORE, LEEWARD NIHOA"; EW = "OFFSHORE, WINDWARD NIHOA"; FI = "INSHORE, FRENCH FRIGATE SHOALS"; FL = "OFFSHORE, LEEWARD FRENCH FRIGATE SHOALS"; FW = "OFFSHORE, WINDWARD FRENCH FRIGATE SHOALS"; GI = "INSHORE, LAYSAN"; GL = "OFFSHORE, LEEWARD LAYSAN"; GW = OFFSHORE, WINDWARD LAYSAN"; HI = "INSHORE, MIDWAY"; HL = "OFFSHORE, LEEWARD MIDWAY"; HW = "OFFSHORE, WINDWARD MIDWAY"; |
LATITUDE_DEGREES
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude degrees of the station operation. 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 of the station operation, in tenths of a minute. During data entry, the decimal point was omitted; it has been inserted into the data. 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 of the station operation. |
General Data Type: | VARCHAR2 |
Allowed Values: | N = NORTH; S = SOUTH |
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, of the station operation. 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: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude degrees of the station operation. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
LONGITUDE_MINUTES
Seq. Order: | 14 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude minutes of the station operation, in tenths of a minute. During data entry, the decimal point was not omitted; it has been inserted into the data. 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 of the station operation. |
General Data Type: | VARCHAR2 |
Allowed Values: | E = EAST; W = WEST |
LONGITUDE_DD
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 42 |
Required: | No |
Primary Key: | No |
Scale: | 36 |
Status: | Active |
Description: |
Computed longitude, in decimal degrees, of the station operation. 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 |
XBT_CODE
Seq. Order: | 17 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code whether an XBT was deployed. |
General Data Type: | VARCHAR2 |
Allowed Values: | 1 = XBT DEPLOYED |
SURFACE_SAMPLE_CODE
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code whether a SURFACE SAMPLE was collected. |
General Data Type: | VARCHAR2 |
Allowed Values: | 1 = SURFACE SAMPLE COLLECTED |
ACTIVITY_01_CODE
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Activity_code for the first operation at the station. |
General Data Type: | VARCHAR2 |
ACTIVITY_02_CODE
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Activity_code for the second operation at the station. |
General Data Type: | VARCHAR2 |
ACTIVITY_03_CODE
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Activity_code for the third operation at the station. |
General Data Type: | VARCHAR2 |
ACTIVITY_04_CODE
Seq. Order: | 22 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Activity_code for the fourth operation at the station. |
General Data Type: | VARCHAR2 |
ACTIVITY_05_CODE
Seq. Order: | 23 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Activity_code for the fifth operation at the station. |
General Data Type: | VARCHAR2 |
ACTIVITY_06_CODE
Seq. Order: | 24 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Activity_code for the sixth operation at the station. |
General Data Type: | VARCHAR2 |
ACTIVITY_07_CODE
Seq. Order: | 25 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Activity_code for the seventh operation at the station. |
General Data Type: | VARCHAR2 |
ACTIVITY_08_CODE
Seq. Order: | 26 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Activity_code for the eighth operation at the station. |
General Data Type: | VARCHAR2 |
ACTIVITY_09_CODE
Seq. Order: | 27 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Activity_code for the ninth operation at the station. |
General Data Type: | VARCHAR2 |
ACTIVITY_10_CODE
Seq. Order: | 28 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Activity_code for the tenth operation at the station. |
General Data Type: | VARCHAR2 |
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., D83021. |
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: | 52866 |
---|---|
GUID: | gov.noaa.nmfs.inport:52866 |
Metadata Record Created By: | Brent M Miyamoto |
Metadata Record Created: | 2018-06-11 14:21+0000 |
Metadata Record Last Modified By: | Brent M Miyamoto |
Metadata Record Last Modified: | 2023-02-06 21:04+0000 |
Metadata Record Published: | 2023-02-06 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2023-02-06 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2024-02-06 |