Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Fisheries Research and Monitoring Divisio... > Stock Assessment Program > Bottomfish Fishery-Independent Survey in Hawaii... > Bottomfish Fishery-Independent Survey in Hawaii... >

CAM_SAMPLE_20190321

Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:56042 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Data source: 20190321

Description

Entity Type
Data Table

Data Attribute / Type	Description
BFISH VARCHAR2	Id for survey Mission: BFISH_Year_Season (e.g. BFISH_2017_F).
MISSION_ID VARCHAR2	Id for NOAA ship mission (e.g. SE1707).
DROP_CD VARCHAR2	Unique ID for the collected sample.
DROP_DATE VARCHAR2	Local Date of MOUSSS drop based on UTC.
DROP_TIME VARCHAR2	Local time of MOUSSS drop based on UTC.
VESSEL VARCHAR2	Name of vessel from which sample was collected.
GEAR_ID VARCHAR2	Id for individual gear unit.
FRAME_RATE NUMBER	Number of frames per second collected by the camera.
GRID_ID_TARGET VARCHAR2	Id for intended primary sampling unit in which the sample was to be collected.
PSU VARCHAR2	Id for primary sampling unit in which the sample was collected.
OBS_LAT NUMBER	Latitude in decimal degrees at which sample was collected. Units for values are degrees. Measures are reported with a precision of 10.
OBS_LON NUMBER	Longitude in decimal degrees at which sample was collected. Units for values are degrees. Measures are reported with a precision of 10.
OFFICIAL_DEPTH_M NUMBER	Official depth reading for drop (if TDR 1&2 both record then mean of TRD 1 & 2. If only one TDR records then depth from that TDR, if neither TDR record then depth from fathometer). Units for values are meters.The depths for SE1701 were updated in December 2019; measures are reported with a precision of 6.
SEQUENCE_NR VARCHAR2	Consecutive number added to each record. Starts with 00000001 for each BFISH (Survey Mission).
CREATE_DTM DATE	Date and time this record was added to the database (populated by trigger); field added in August 2019.
CREATED_BY VARCHAR2	Application Express or Oracle username of the person creating this record (populated by trigger); field added in August 2019.
LAST_MOD_DTM DATE	Date and time this record was last modified (populated by trigger); field added in August 2019.
LAST_MOD_BY VARCHAR2	Application Express or Oracle username of the person who last modified this record (populated by trigger); field added in August 2019.
OFFICIAL_TEMP_C Number	Official temperature reading for drop is the mode of 30 temperature recordings (with recordings every 30 seconds for 15 minutes of bottom time), then calculate the mean of the two temperature modes from TDRs 1 & 2 (if TDRs 1&2 both record then mean of TRD 1 & 2; if only one TDR records then mode of temperature from that TDR; if neither TDR records then no temperature is given). Units of values are degrees Celsius. Measures are reported with a precision of 4.This data field was added in December 2019.

Data Attribute / Type

Description

BFISH
VARCHAR2

Id for survey Mission: BFISH_Year_Season (e.g. BFISH_2017_F).

MISSION_ID
VARCHAR2

Id for NOAA ship mission (e.g. SE1707).

DROP_CD
VARCHAR2

Unique ID for the collected sample.

DROP_DATE
VARCHAR2

Local Date of MOUSSS drop based on UTC.

DROP_TIME
VARCHAR2

Local time of MOUSSS drop based on UTC.

VESSEL
VARCHAR2

Name of vessel from which sample was collected.

GEAR_ID
VARCHAR2

Id for individual gear unit.

FRAME_RATE
NUMBER

Number of frames per second collected by the camera.

GRID_ID_TARGET
VARCHAR2

Id for intended primary sampling unit in which the sample was to be collected.

PSU
VARCHAR2

Id for primary sampling unit in which the sample was collected.

OBS_LAT
NUMBER

Latitude in decimal degrees at which sample was collected. Units for values are degrees. Measures are reported with a precision of 10.

OBS_LON
NUMBER

Longitude in decimal degrees at which sample was collected. Units for values are degrees. Measures are reported with a precision of 10.

OFFICIAL_DEPTH_M
NUMBER

Official depth reading for drop (if TDR 1&2 both record then mean of TRD 1 & 2. If only one TDR records then depth from that TDR, if neither TDR record then depth from fathometer). Units for values are meters.The depths for SE1701 were updated in December 2019; measures are reported with a precision of 6.

SEQUENCE_NR
VARCHAR2

Consecutive number added to each record. Starts with 00000001 for each BFISH (Survey Mission).

CREATE_DTM
DATE

Date and time this record was added to the database (populated by trigger); field added in August 2019.

CREATED_BY
VARCHAR2

Application Express or Oracle username of the person creating this record (populated by trigger); field added in August 2019.

LAST_MOD_DTM
DATE

Date and time this record was last modified (populated by trigger); field added in August 2019.

LAST_MOD_BY
VARCHAR2

Application Express or Oracle username of the person who last modified this record (populated by trigger); field added in August 2019.

OFFICIAL_TEMP_C
Number

Official temperature reading for drop is the mode of 30 temperature recordings (with recordings every 30 seconds for 15 minutes of bottom time), then calculate the mean of the two temperature modes from TDRs 1 & 2 (if TDRs 1&2 both record then mean of TRD 1 & 2; if only one TDR records then mode of temperature from that TDR; if neither TDR records then no temperature is given). Units of values are degrees Celsius. Measures are reported with a precision of 4.This data field was added in December 2019.

No Child Items for this record.

No contact information is available for this record.

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

Title:	CAM_SAMPLE_20190321
Short Name:	CAM_SAMPLE_20190321
Status:	On Going
Abstract:	Data source: 20190321

Entity Type:	Data Table
Description:	.

Attribute Summary

	Name	Type	Description
100	BFISH	VARCHAR2	Id for survey Mission: BFISH_Year_Season (e.g. BFISH_2017_F).
100	MISSION_ID	VARCHAR2	Id for NOAA ship mission (e.g. SE1707).
100	DROP_CD	VARCHAR2	Unique ID for the collected sample.
100	DROP_DATE	VARCHAR2	Local Date of MOUSSS drop based on UTC.
100	DROP_TIME	VARCHAR2	Local time of MOUSSS drop based on UTC.
100	VESSEL	VARCHAR2	Name of vessel from which sample was collected.
100	GEAR_ID	VARCHAR2	Id for individual gear unit.
100	FRAME_RATE	NUMBER	Number of frames per second collected by the camera.
100	GRID_ID_TARGET	VARCHAR2	Id for intended primary sampling unit in which the sample was to be collected.
100	PSU	VARCHAR2	Id for primary sampling unit in which the sample was collected.
100	OBS_LAT	NUMBER	Latitude in decimal degrees at which sample was collected. Units for values are degrees. Measures are reported with a precision of 10.
100	OBS_LON	NUMBER	Longitude in decimal degrees at which sample was collected. Units for values are degrees. Measures are reported with a precision of 10.
100	OFFICIAL_DEPTH_M	NUMBER	Official depth reading for drop (if TDR 1&2 both record then mean of TRD 1 & 2. If only one TDR records then depth from that TDR, if neither TDR record then depth from fathometer). Units for values are meters.The depths for SE1701 were updated in December 2019; measures are reported with a precision of 6.
100	SEQUENCE_NR	VARCHAR2	Consecutive number added to each record. Starts with 00000001 for each BFISH (Survey Mission).
100	CREATE_DTM	DATE	Date and time this record was added to the database (populated by trigger); field added in August 2019.
100	CREATED_BY	VARCHAR2	Application Express or Oracle username of the person creating this record (populated by trigger); field added in August 2019.
100	LAST_MOD_DTM	DATE	Date and time this record was last modified (populated by trigger); field added in August 2019.
100	LAST_MOD_BY	VARCHAR2	Application Express or Oracle username of the person who last modified this record (populated by trigger); field added in August 2019.
100	OFFICIAL_TEMP_C	Number	Official temperature reading for drop is the mode of 30 temperature recordings (with recordings every 30 seconds for 15 minutes of bottom time), then calculate the mean of the two temperature modes from TDRs 1 & 2 (if TDRs 1&2 both record then mean of TRD 1 & 2; if only one TDR records then mode of temperature from that TDR; if neither TDR records then no temperature is given). Units of values are degrees Celsius. Measures are reported with a precision of 4.This data field was added in December 2019.

Name

Type

Description

100

BFISH

VARCHAR2

Id for survey Mission: BFISH_Year_Season (e.g. BFISH_2017_F).

100

MISSION_ID

VARCHAR2

Id for NOAA ship mission (e.g. SE1707).

100

DROP_CD

VARCHAR2

Unique ID for the collected sample.

100

DROP_DATE

VARCHAR2

Local Date of MOUSSS drop based on UTC.

100

DROP_TIME

VARCHAR2

Local time of MOUSSS drop based on UTC.

100

VESSEL

VARCHAR2

Name of vessel from which sample was collected.

100

GEAR_ID

VARCHAR2

Id for individual gear unit.

100

FRAME_RATE

NUMBER

Number of frames per second collected by the camera.

100

GRID_ID_TARGET

VARCHAR2

Id for intended primary sampling unit in which the sample was to be collected.

100

PSU

VARCHAR2

Id for primary sampling unit in which the sample was collected.

100

OBS_LAT

NUMBER

Latitude in decimal degrees at which sample was collected. Units for values are degrees. Measures are reported with a precision of 10.

100

OBS_LON

NUMBER

Longitude in decimal degrees at which sample was collected. Units for values are degrees. Measures are reported with a precision of 10.

100

OFFICIAL_DEPTH_M

NUMBER

100

SEQUENCE_NR

VARCHAR2

Consecutive number added to each record. Starts with 00000001 for each BFISH (Survey Mission).

100

CREATE_DTM

DATE

Date and time this record was added to the database (populated by trigger); field added in August 2019.

100

CREATED_BY

VARCHAR2

Application Express or Oracle username of the person creating this record (populated by trigger); field added in August 2019.

100

LAST_MOD_DTM

DATE

Date and time this record was last modified (populated by trigger); field added in August 2019.

100

LAST_MOD_BY

VARCHAR2

Application Express or Oracle username of the person who last modified this record (populated by trigger); field added in August 2019.

100

OFFICIAL_TEMP_C

Number

Attribute Details

BFISH

CC ID: 833659

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	12
Required:	Yes
Primary Key:	Yes
Status:	Active
Description:	Id for survey Mission: BFISH_Year_Season (e.g. BFISH_2017_F).
General Data Type:	CHARACTER

MISSION_ID

CC ID: 833660

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Id for NOAA ship mission (e.g. SE1707).
General Data Type:	CHARACTER

DROP_CD

CC ID: 833661

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	15
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique ID for the collected sample.
General Data Type:	CHARACTER

DROP_DATE

CC ID: 833662

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	Local Date of MOUSSS drop based on UTC.
General Data Type:	CHARACTER

DROP_TIME

CC ID: 833663

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Local time of MOUSSS drop based on UTC.
General Data Type:	CHARACTER

VESSEL

CC ID: 833664

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	25
Required:	No
Primary Key:	No
Status:	Active
Description:	Name of vessel from which sample was collected.
General Data Type:	CHARACTER

GEAR_ID

CC ID: 833665

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Id for individual gear unit.
General Data Type:	CHARACTER

FRAME_RATE

CC ID: 833666

Seq. Order:	8
Data Storage Type:	NUMBER
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Number of frames per second collected by the camera.
General Data Type:	NUMBER

GRID_ID_TARGET

CC ID: 833667

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	Id for intended primary sampling unit in which the sample was to be collected.
General Data Type:	CHARACTER

PSU

CC ID: 833668

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	Id for primary sampling unit in which the sample was collected.
General Data Type:	CHARACTER

OBS_LAT

CC ID: 833669

Seq. Order:	11
Data Storage Type:	NUMBER
Max Length:	11
Required:	No
Primary Key:	No
Scale:	8
Status:	Active
Description:	Latitude in decimal degrees at which sample was collected. Units for values are degrees. Measures are reported with a precision of 10.
General Data Type:	NUMBER
Unit of Measure:	degrees

OBS_LON

CC ID: 833670

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	12
Required:	No
Primary Key:	No
Scale:	7
Status:	Active
Description:	Longitude in decimal degrees at which sample was collected. Units for values are degrees. Measures are reported with a precision of 10.
General Data Type:	NUMBER
Unit of Measure:	degrees

OFFICIAL_DEPTH_M

CC ID: 833671

Seq. Order:	13
Data Storage Type:	NUMBER
Max Length:	7
Required:	No
Primary Key:	No
Precision:	6
Scale:	3
Status:	Active
Description:	Official depth reading for drop (if TDR 1&2 both record then mean of TRD 1 & 2. If only one TDR records then depth from that TDR, if neither TDR record then depth from fathometer). Units for values are meters.The depths for SE1701 were updated in December 2019; measures are reported with a precision of 6.
General Data Type:	NUMBER
Unit of Measure:	meters

SEQUENCE_NR

CC ID: 868060

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	8
Min Length:	8
Required:	Yes
Primary Key:	Yes
Status:	Active
Description:	Consecutive number added to each record. Starts with 00000001 for each BFISH (Survey Mission).
General Data Type:	CHARACTER

CREATE_DTM

CC ID: 868061

Seq. Order:	15
Data Storage Type:	DATE
Required:	No
Primary Key:	No
Status:	Active
Description:	Date and time this record was added to the database (populated by trigger); field added in August 2019.
General Data Type:	DATE

CREATED_BY

CC ID: 868062

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	Application Express or Oracle username of the person creating this record (populated by trigger); field added in August 2019.
General Data Type:	CHARACTER

LAST_MOD_DTM

CC ID: 868063

Seq. Order:	17
Data Storage Type:	DATE
Required:	No
Primary Key:	No
Status:	Active
Description:	Date and time this record was last modified (populated by trigger); field added in August 2019.
General Data Type:	DATE

LAST_MOD_BY

CC ID: 868064

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	Application Express or Oracle username of the person who last modified this record (populated by trigger); field added in August 2019.
General Data Type:	CHARACTER

OFFICIAL_TEMP_C

CC ID: 890751

Seq. Order:	19
Data Storage Type:	Number
Max Length:	5
Required:	No
Primary Key:	No
Precision:	4
Scale:	2
Status:	Active
Description:	Official temperature reading for drop is the mode of 30 temperature recordings (with recordings every 30 seconds for 15 minutes of bottom time), then calculate the mean of the two temperature modes from TDRs 1 & 2 (if TDRs 1&2 both record then mean of TRD 1 & 2; if only one TDR records then mode of temperature from that TDR; if neither TDR records then no temperature is given). Units of values are degrees Celsius. Measures are reported with a precision of 4.This data field was added in December 2019.
Unit of Measure:	degrees Celsius

Catalog Item ID:	56042
GUID:	gov.noaa.nmfs.inport:56042
Metadata Record Created By:	Brent M Miyamoto
Metadata Record Created:	2019-04-12 22:37+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2019-08-20
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2019-08-20
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2020-08-20

CAM_SAMPLE_20190321

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

BFISH

MISSION_ID

DROP_CD

DROP_DATE

DROP_TIME

VESSEL

GEAR_ID

FRAME_RATE

GRID_ID_TARGET

PSU

OBS_LAT

OBS_LON

OFFICIAL_DEPTH_M

SEQUENCE_NR

CREATE_DTM

CREATED_BY

LAST_MOD_DTM

LAST_MOD_BY

OFFICIAL_TEMP_C

Catalog Details