Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Historical Datasets Metadata Portfolio > Historical Research Vessel Metadata Portfolio > Station Number & Activity Log Data collected du... >

RV002AA5_V

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:52866  |  Updated: February 6, 2023  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

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.

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.

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 		Last two digits of the year of the cruise and two digits incremental number of the cruise for the year, e.g., 7802.
YEAR
VARCHAR2 		Year of the station operation.
MONTH
VARCHAR2 		Month of the station operation.
DAY
VARCHAR2 		Day of the station operation started.
STATION_NUMBER
VARCHAR2 		Station number of the operation.
LATITUDE_DEGREES
VARCHAR2 		Latitude degrees of the station operation. Units for values are degrees.
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.
LATITUDE_DIRECTION
VARCHAR2 		Latitude direction of the station operation.
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.
LONGITUDE_DEGREES
VARCHAR2 		Longitude degrees of the station operation. Units for values are degrees.
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.
LONGITUDE_DIRECTION
VARCHAR2 		Longitude direction of the station operation.
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.
XBT_CODE
VARCHAR2 		Code whether an XBT was deployed.
SURFACE_SAMPLE_CODE
VARCHAR2 		Code whether a SURFACE SAMPLE was collected.
ACTIVITY_01_CODE
VARCHAR2 		Activity_code for the first operation at the station.
ACTIVITY_02_CODE
VARCHAR2 		Activity_code for the second operation at the station.
ACTIVITY_03_CODE
VARCHAR2 		Activity_code for the third operation at the station.
ACTIVITY_04_CODE
VARCHAR2 		Activity_code for the fourth operation at the station.
ACTIVITY_05_CODE
VARCHAR2 		Activity_code for the fifth operation at the station.
ACTIVITY_06_CODE
VARCHAR2 		Activity_code for the sixth operation at the station.
ACTIVITY_07_CODE
VARCHAR2 		Activity_code for the seventh operation at the station.
ACTIVITY_08_CODE
VARCHAR2 		Activity_code for the eighth operation at the station.
ACTIVITY_09_CODE
VARCHAR2 		Activity_code for the ninth operation at the station.
ACTIVITY_10_CODE
VARCHAR2 		Activity_code for the tenth operation at the station.
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.
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: 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

Rubric Score Primary Key? 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

CC ID: 1217582
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

CC ID: 1217583
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

CC ID: 1217584
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

CC ID: 1217585
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

CC ID: 1217586
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

CC ID: 1217587
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

CC ID: 1217588
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

CC ID: 1217589
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

CC ID: 1217590
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

CC ID: 1217591
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

CC ID: 1217592
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

CC ID: 1217593
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

CC ID: 1217594
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

CC ID: 1217595
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

CC ID: 1217596
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

CC ID: 1217597
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

CC ID: 1217598
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

CC ID: 1217599
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

CC ID: 1217600
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

CC ID: 1217601
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

CC ID: 1217602
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

CC ID: 1217603
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

CC ID: 1217604
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

CC ID: 1217605
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

CC ID: 1217606
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

CC ID: 1217607
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

CC ID: 1217608
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

CC ID: 1217609
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

CC ID: 1217610
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

CC ID: 1217611
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

CC ID: 1217612
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