Search Help Show/Hide Menu
Metadata Rubric
83%
5 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > AMMOP > AMMOP Oracle database 1999 - 2013 >

MM_SIGHTING_WATCH

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:75199  |  Updated: May 21, 2025  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Description

Table holding information about sightings and sighting events that occurred while the observer was on watch.

Entity Information

Data Attribute / Type Description
BEAUFORT_CODE
VARCHAR2(1 BYTE) 		Sea state on the Beaufort Scale.
BEHAVIOR_CODE
VARCHAR2(2 BYTE) 		Code representing the behavior of the animals sighted.
BEHAVIOR_ID
NUMBER(6,0) 		Unique identifier of the behavior of the animals sighted.
COMMENTS
VARCHAR2(2000 BYTE) 		User-entered descriptive notes.
DISTANCE_TO_GEAR
NUMBER(4,0) 		Distance from observer to net in whole meters.
DISTANCE_TO_VESSEL
NUMBER(4,0) 		Distance from observer to animal sighted in whole meters.
LATITUDE
NUMBER(7,1) 		Sighting event latitude in tenths of minutes.
LONGITUDE
NUMBER(7,1) 		Sighting event longitude in tenths of minutes.
NUMBER_OF_INDIVIDUALS
NUMBER(4,0) 		Number of individual animals sighted.
OBSERVATION_PLATFORM_CODE
VARCHAR2(1 BYTE) 		Platform from which observer made the sighting.
OBSERVER_CODE
VARCHAR2(3 BYTE) 		Code associated with the observer within the Marine Mammal Observer Program.
OBSERVER_ID
NUMBER(6,0) 		Unique identifier of the observer within the Marine Mammal Observer Program.
SEQUENCE_NUMBER
NUMBER(3,0) 		Sequence number within the parent sighting record.
SIGHTING_ID
NUMBER(6,0) 		Unique identifier of the parent sighting record.
SIGHTING_OBJECT_CODE
VARCHAR2(5 BYTE) 		Agency species code or code representing the object that was sighted.
SIGHTING_OBJECT_ID
NUMBER(6,0) 		Unique identifier of the agency species or sighting object.
WATCH_NUMBER
NUMBER(2,0) 		The distinct watch for which a sighting event was recorded.
TYPE_CODE
VARCHAR2(2 BYTE) 		Code for the type of sighting event recorded.
TYPE_ID
NUMBER(6,0) 		Unique identifier of the type of sighting event recorded.
WAVE_HEIGHT
NUMBER(3,1) 		Estimated wave height in meters.
WEATHER_CODE
VARCHAR2(1 BYTE) 		Weather at time of sighting event.
WATCH_TIME
NUMBER(5,0) 		The time on a 24-hour clock that a sighting event was recorded.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: MM_SIGHTING_WATCH

Entity Information

Description:

Table holding information about sightings and sighting events that occurred while the observer was on watch.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 BEAUFORT_CODE VARCHAR2(1 BYTE) Sea state on the Beaufort Scale.
100
 BEHAVIOR_CODE VARCHAR2(2 BYTE) Code representing the behavior of the animals sighted.
100
 BEHAVIOR_ID NUMBER(6,0) Unique identifier of the behavior of the animals sighted.
100
 COMMENTS VARCHAR2(2000 BYTE) User-entered descriptive notes.
100
 DISTANCE_TO_GEAR NUMBER(4,0) Distance from observer to net in whole meters.
100
 DISTANCE_TO_VESSEL NUMBER(4,0) Distance from observer to animal sighted in whole meters.
100
 LATITUDE NUMBER(7,1) Sighting event latitude in tenths of minutes.
100
 LONGITUDE NUMBER(7,1) Sighting event longitude in tenths of minutes.
100
 NUMBER_OF_INDIVIDUALS NUMBER(4,0) Number of individual animals sighted.
100
 OBSERVATION_PLATFORM_CODE VARCHAR2(1 BYTE) Platform from which observer made the sighting.
100
 OBSERVER_CODE VARCHAR2(3 BYTE) Code associated with the observer within the Marine Mammal Observer Program.
100
 OBSERVER_ID NUMBER(6,0) Unique identifier of the observer within the Marine Mammal Observer Program.
100
 SEQUENCE_NUMBER NUMBER(3,0) Sequence number within the parent sighting record.
100
 SIGHTING_ID NUMBER(6,0) Unique identifier of the parent sighting record.
100
 SIGHTING_OBJECT_CODE VARCHAR2(5 BYTE) Agency species code or code representing the object that was sighted.
100
 SIGHTING_OBJECT_ID NUMBER(6,0) Unique identifier of the agency species or sighting object.
100
 WATCH_NUMBER NUMBER(2,0) The distinct watch for which a sighting event was recorded.
100
 TYPE_CODE VARCHAR2(2 BYTE) Code for the type of sighting event recorded.
100
 TYPE_ID NUMBER(6,0) Unique identifier of the type of sighting event recorded.
100
 WAVE_HEIGHT NUMBER(3,1) Estimated wave height in meters.
100
 WEATHER_CODE VARCHAR2(1 BYTE) Weather at time of sighting event.
100
 WATCH_TIME NUMBER(5,0) The time on a 24-hour clock that a sighting event was recorded.

Attribute Details

BEAUFORT_CODE

CC ID: 1374803
Data Storage Type: VARCHAR2(1 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Sea state on the Beaufort Scale.

BEHAVIOR_CODE

CC ID: 1374804
Data Storage Type: VARCHAR2(2 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Code representing the behavior of the animals sighted.

BEHAVIOR_ID

CC ID: 1374805
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

Unique identifier of the behavior of the animals sighted.

COMMENTS

CC ID: 1374806
Data Storage Type: VARCHAR2(2000 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

User-entered descriptive notes.

DISTANCE_TO_GEAR

CC ID: 1374807
Data Storage Type: NUMBER(4,0)
Required: No
Primary Key: No
Status: Active
Description:

Distance from observer to net in whole meters.

DISTANCE_TO_VESSEL

CC ID: 1374808
Data Storage Type: NUMBER(4,0)
Required: No
Primary Key: No
Status: Active
Description:

Distance from observer to animal sighted in whole meters.

LATITUDE

CC ID: 1374809
Data Storage Type: NUMBER(7,1)
Required: No
Primary Key: No
Status: Active
Description:

Sighting event latitude in tenths of minutes.

LONGITUDE

CC ID: 1374810
Data Storage Type: NUMBER(7,1)
Required: No
Primary Key: No
Status: Active
Description:

Sighting event longitude in tenths of minutes.

NUMBER_OF_INDIVIDUALS

CC ID: 1374811
Data Storage Type: NUMBER(4,0)
Required: No
Primary Key: No
Status: Active
Description:

Number of individual animals sighted.

OBSERVATION_PLATFORM_CODE

CC ID: 1374812
Data Storage Type: VARCHAR2(1 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Platform from which observer made the sighting.

OBSERVER_CODE

CC ID: 1374813
Data Storage Type: VARCHAR2(3 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Code associated with the observer within the Marine Mammal Observer Program.

OBSERVER_ID

CC ID: 1374814
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

Unique identifier of the observer within the Marine Mammal Observer Program.

SEQUENCE_NUMBER

CC ID: 1374815
Data Storage Type: NUMBER(3,0)
Required: No
Primary Key: No
Status: Active
Description:

Sequence number within the parent sighting record.

SIGHTING_ID

CC ID: 1374816
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

Unique identifier of the parent sighting record.

SIGHTING_OBJECT_CODE

CC ID: 1374817
Data Storage Type: VARCHAR2(5 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Agency species code or code representing the object that was sighted.

SIGHTING_OBJECT_ID

CC ID: 1374818
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

Unique identifier of the agency species or sighting object.

WATCH_NUMBER

CC ID: 1374819
Data Storage Type: NUMBER(2,0)
Required: No
Primary Key: No
Status: Active
Description:

The distinct watch for which a sighting event was recorded.

TYPE_CODE

CC ID: 1374820
Data Storage Type: VARCHAR2(2 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Code for the type of sighting event recorded.

TYPE_ID

CC ID: 1374821
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

Unique identifier of the type of sighting event recorded.

WAVE_HEIGHT

CC ID: 1374822
Data Storage Type: NUMBER(3,1)
Required: No
Primary Key: No
Status: Active
Description:

Estimated wave height in meters.

WEATHER_CODE

CC ID: 1374823
Data Storage Type: VARCHAR2(1 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Weather at time of sighting event.

WATCH_TIME

CC ID: 1374845
Data Storage Type: NUMBER(5,0)
Required: No
Primary Key: No
Status: Active
Description:

The time on a 24-hour clock that a sighting event was recorded.

Catalog Details

Catalog Item ID: 75199
GUID: gov.noaa.nmfs.inport:75199
Metadata Record Created By: Rachel Wuest
Metadata Record Created: 2025-03-06 23:25+0000
Metadata Record Last Modified By: Daniel Woodrich
Metadata Record Last Modified: 2025-05-21 19:12+0000
Metadata Record Published: 2025-05-21
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year