Metadata Rubric

100%

6 / 6

Alaska Fisheries Science Center Metadata Librar... > Resource Assessment and Conservation Engineerin... > Groundfish Assessment Program > AFSC/RACE/GAP: RACEBASE Database >

Table: CRUISE

Entity (ENT) | Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:69747 | Updated: October 26, 2023 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

A lookup table for every cruise that is in the RACEBASE database. It summarizes locations, dates, the country performing the survey and cruise name for each cruise

Description

A lookup table for every cruise that is in the RACEBASE database. It summarizes locations, dates, the country performing the survey and cruise name for each cruise

Entity Type
Data Table

Data Attribute / Type	Description
CRUISEJOIN NUMBER	This is a unique numeric identifier assigned to each (VESSEL,CRUISE) combination
REGION VARCHAR2	Valid Values: AI=Aleutian Islands, BS=Bering Sea, GOA=Gulf of Alaska, WC=West Coast,HBS=Hydroacoustic Bering Sea, HG=Hydroacoustic Gulf of Alaska, HWC=Hydroacoustic West Coast, TAG=Denotes that no biological data exist for this cruise other than those related to tags released or recovered.
VESSEL NUMBER	Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual
CRUISE NUMBER	This is a six-digit number identifying the Cruise number of the form: YYYY99 (where YYYY = year of the cruise; 99 = 2-digit number and is sequential; 01 denotes the first cruise that vessel made in this year, 02 is the second, etc.)
START_DATE DATE	Date. This is the date of the first haul of the cruise; this field is populated using a query - select min (start_time)from racebase.haul
END_DATE DATE	Date. This is the date of the last haul of the cruise; this field is populated value using a query - select max (start_time) from a racebase.haul
MIN_LATITUDE NUMBER	Latitude in decimal degrees. These are the southern bounding coordinates of cruise.
MAX_LATITUDE NUMBER	Latitude in decimal degrees. These are the northern bounding coordinates of the cruise.
MIN_LONGITUDE NUMBER	Longitude in decimal degrees. These are the eastern bounding coordinates of cruise.
MAX_LONGITUDE NUMBER	Longitude in decimal degrees. These are the western bounding coordinates of cruise.
AGENCY_NAME VARCHAR2	Text. Name of country or countries that conducted the cruise
SURVEY_NAME VARCHAR2	Text. Description of the survey.
AUDITJOIN NUMBER	This is a unique identifier for each record in the base table, to be used in corresponding audit tables to identify the original record in the base table

Data Attribute / Type

Description

CRUISEJOIN
NUMBER

This is a unique numeric identifier assigned to each (VESSEL,CRUISE) combination

REGION
VARCHAR2

Valid Values: AI=Aleutian Islands, BS=Bering Sea, GOA=Gulf of Alaska, WC=West Coast,HBS=Hydroacoustic Bering Sea, HG=Hydroacoustic Gulf of Alaska, HWC=Hydroacoustic West Coast, TAG=Denotes that no biological data exist for this cruise other than those related to tags released or recovered.

VESSEL
NUMBER

Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual

CRUISE
NUMBER

This is a six-digit number identifying the Cruise number of the form: YYYY99 (where YYYY = year of the cruise; 99 = 2-digit number and is sequential; 01 denotes the first cruise that vessel made in this year, 02 is the second, etc.)

START_DATE
DATE

Date. This is the date of the first haul of the cruise; this field is populated using a query - select min (start_time)from racebase.haul

END_DATE
DATE

Date. This is the date of the last haul of the cruise; this field is populated value using a query - select max (start_time) from a racebase.haul

MIN_LATITUDE
NUMBER

Latitude in decimal degrees. These are the southern bounding coordinates of cruise.

MAX_LATITUDE
NUMBER

Latitude in decimal degrees. These are the northern bounding coordinates of the cruise.

MIN_LONGITUDE
NUMBER

Longitude in decimal degrees. These are the eastern bounding coordinates of cruise.

MAX_LONGITUDE
NUMBER

Longitude in decimal degrees. These are the western bounding coordinates of cruise.

AGENCY_NAME
VARCHAR2

Text. Name of country or countries that conducted the cruise

SURVEY_NAME
VARCHAR2

Text. Description of the survey.

AUDITJOIN
NUMBER

This is a unique identifier for each record in the base table, to be used in corresponding audit tables to identify the original record in the base table

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

Title:	Table: CRUISE
Short Name:	CRUISE
Status:	Completed
Abstract:	A lookup table for every cruise that is in the RACEBASE database. It summarizes locations, dates, the country performing the survey and cruise name for each cruise

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	RACEBASE
Description:	A lookup table for every cruise that is in the RACEBASE database. It summarizes locations, dates, the country performing the survey and cruise name for each cruise

Attribute Summary

	Name	Type	Description
100	CRUISEJOIN	NUMBER	This is a unique numeric identifier assigned to each (VESSEL,CRUISE) combination
100	REGION	VARCHAR2	Valid Values: AI=Aleutian Islands, BS=Bering Sea, GOA=Gulf of Alaska, WC=West Coast,HBS=Hydroacoustic Bering Sea, HG=Hydroacoustic Gulf of Alaska, HWC=Hydroacoustic West Coast, TAG=Denotes that no biological data exist for this cruise other than those related to tags released or recovered.
100	VESSEL	NUMBER	Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual
100	CRUISE	NUMBER	This is a six-digit number identifying the Cruise number of the form: YYYY99 (where YYYY = year of the cruise; 99 = 2-digit number and is sequential; 01 denotes the first cruise that vessel made in this year, 02 is the second, etc.)
100	START_DATE	DATE	Date. This is the date of the first haul of the cruise; this field is populated using a query - select min (start_time)from racebase.haul
100	END_DATE	DATE	Date. This is the date of the last haul of the cruise; this field is populated value using a query - select max (start_time) from a racebase.haul
100	MIN_LATITUDE	NUMBER	Latitude in decimal degrees. These are the southern bounding coordinates of cruise.
100	MAX_LATITUDE	NUMBER	Latitude in decimal degrees. These are the northern bounding coordinates of the cruise.
100	MIN_LONGITUDE	NUMBER	Longitude in decimal degrees. These are the eastern bounding coordinates of cruise.
100	MAX_LONGITUDE	NUMBER	Longitude in decimal degrees. These are the western bounding coordinates of cruise.
100	AGENCY_NAME	VARCHAR2	Text. Name of country or countries that conducted the cruise
100	SURVEY_NAME	VARCHAR2	Text. Description of the survey.
100	AUDITJOIN	NUMBER	This is a unique identifier for each record in the base table, to be used in corresponding audit tables to identify the original record in the base table

Name

Type

Description

100

CRUISEJOIN

NUMBER

This is a unique numeric identifier assigned to each (VESSEL,CRUISE) combination

100

REGION

VARCHAR2

100

VESSEL

NUMBER

Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual

100

CRUISE

NUMBER

100

START_DATE

DATE

Date. This is the date of the first haul of the cruise; this field is populated using a query - select min (start_time)from racebase.haul

100

END_DATE

DATE

Date. This is the date of the last haul of the cruise; this field is populated value using a query - select max (start_time) from a racebase.haul

100

MIN_LATITUDE

NUMBER

Latitude in decimal degrees. These are the southern bounding coordinates of cruise.

100

MAX_LATITUDE

NUMBER

Latitude in decimal degrees. These are the northern bounding coordinates of the cruise.

100

MIN_LONGITUDE

NUMBER

Longitude in decimal degrees. These are the eastern bounding coordinates of cruise.

100

MAX_LONGITUDE

NUMBER

Longitude in decimal degrees. These are the western bounding coordinates of cruise.

100

AGENCY_NAME

VARCHAR2

Text. Name of country or countries that conducted the cruise

100

SURVEY_NAME

VARCHAR2

Text. Description of the survey.

100

AUDITJOIN

NUMBER

This is a unique identifier for each record in the base table, to be used in corresponding audit tables to identify the original record in the base table

Attribute Details

CRUISEJOIN

CC ID: 1229963

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	12
Scale:	0
Status:	Active
Description:	This is a unique numeric identifier assigned to each (VESSEL,CRUISE) combination
General Data Type:	NUMBER

REGION

CC ID: 1229964

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Valid Values: AI=Aleutian Islands, BS=Bering Sea, GOA=Gulf of Alaska, WC=West Coast,HBS=Hydroacoustic Bering Sea, HG=Hydroacoustic Gulf of Alaska, HWC=Hydroacoustic West Coast, TAG=Denotes that no biological data exist for this cruise other than those related to tags released or recovered.
General Data Type:	VARCHAR2

VESSEL

CC ID: 1229965

Seq. Order:	3
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual
General Data Type:	NUMBER

CRUISE

CC ID: 1229966

Seq. Order:	4
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	This is a six-digit number identifying the Cruise number of the form: YYYY99 (where YYYY = year of the cruise; 99 = 2-digit number and is sequential; 01 denotes the first cruise that vessel made in this year, 02 is the second, etc.)
General Data Type:	NUMBER

START_DATE

CC ID: 1229967

Seq. Order:	5
Data Storage Type:	DATE
Max Length:	7
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Date. This is the date of the first haul of the cruise; this field is populated using a query - select min (start_time)from racebase.haul
General Data Type:	DATE

END_DATE

CC ID: 1229968

Seq. Order:	6
Data Storage Type:	DATE
Max Length:	7
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Date. This is the date of the last haul of the cruise; this field is populated value using a query - select max (start_time) from a racebase.haul
General Data Type:	DATE

MIN_LATITUDE

CC ID: 1229969

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	7
Scale:	5
Status:	Active
Description:	Latitude in decimal degrees. These are the southern bounding coordinates of cruise.
General Data Type:	NUMBER

MAX_LATITUDE

CC ID: 1229970

Seq. Order:	8
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	7
Scale:	5
Status:	Active
Description:	Latitude in decimal degrees. These are the northern bounding coordinates of the cruise.
General Data Type:	NUMBER

MIN_LONGITUDE

CC ID: 1229971

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	8
Scale:	5
Status:	Active
Description:	Longitude in decimal degrees. These are the eastern bounding coordinates of cruise.
General Data Type:	NUMBER

MAX_LONGITUDE

CC ID: 1229972

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	8
Scale:	5
Status:	Active
Description:	Longitude in decimal degrees. These are the western bounding coordinates of cruise.
General Data Type:	NUMBER

AGENCY_NAME

CC ID: 1229973

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	40
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Text. Name of country or countries that conducted the cruise
General Data Type:	VARCHAR2

SURVEY_NAME

CC ID: 1229974

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	80
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Text. Description of the survey.
General Data Type:	VARCHAR2

AUDITJOIN

CC ID: 1229975

Seq. Order:	13
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	12
Scale:	0
Status:	Active
Description:	This is a unique identifier for each record in the base table, to be used in corresponding audit tables to identify the original record in the base table
General Data Type:	NUMBER

Catalog Item ID:	69747
GUID:	gov.noaa.nmfs.inport:69747
Metadata Record Created By:	Nancy Roberson
Metadata Record Created:	2023-05-01 17:43+0000
Metadata Record Last Modified By:	Nancy Roberson
Metadata Record Last Modified:	2023-10-26 19:04+0000
Metadata Record Published:	2023-10-26
Owner Org:	AFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2023-10-26
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2024-10-26

Table: CRUISE

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

CRUISEJOIN

REGION

VESSEL

CRUISE

START_DATE

END_DATE

MIN_LATITUDE

MAX_LATITUDE

MIN_LONGITUDE

MAX_LONGITUDE

AGENCY_NAME

SURVEY_NAME

AUDITJOIN

Catalog Details