Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Fisheries Sampling Branch (FSB) > Observer and At Sea Monitor Database (OBDBS) >

View: OBSIG

Entity (ENT) | Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:33572 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Observer Sighting Logs

Description

Observer Sighting Logs

Entity Type
Data View

Data Attribute / Type	Description
PROGRAM VARCHAR2	First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
YEAR VARCHAR2	Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.
MONTH VARCHAR2	Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.
TRIPID VARCHAR2	May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable.
LINK1 VARCHAR2	15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable.
YEAREVNT VARCHAR2	Year event took place, 4 digits.
MONTHEVNT VARCHAR2	Month event took place.
DAYEVNT VARCHAR2	Day event took place.
TIMEEVNT VARCHAR2	Local time using 24 hr. clock(0000-2359) that event occurred.
DATEEVNT DATE	Date of the sighting or effort event reported. NOTE: if time is unknown it defaults to midnight in this field
EVNTTYPE VARCHAR2	Indicator of type of event that occurred. See OBEVNTTYP table.
HAULNUM VARCHAR2	Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable.
EVNTPOS VARCHAR2	Location and position of observer on vessel at time of event. See OBEVNTPOS table.
LATEVT VARCHAR2	Latitude location, (DDMMSS) where event occurred.
LONEVT VARCHAR2	Longitude location, DDMMSS, where event occurred.
GIS_LATEVT NUMBER	GIS format (decimal degrees) for the latitude for the event
GIS_LONEVT NUMBER	GIS format (decimal degrees) for the longitude for the event
AREA VARCHAR2	Statistical area code obtained from positions at beginning of haul for fixed gear and end of the haul for mobile gear or at sighting position. See LOC2AREAS table on sole. Collected for ASM where applicable.
WEATHER VARCHAR2	HAUL: Code for weather at beginning of haul. EVENT: Code for weather at time event occurred. See support table OBWEATHER for codes. Collected for ASM where applicable.
WAVEHGT NUMBER	HAUL: Wave height at beginning of haul, in whole feet. EVENT: Wave height at beginning of event, in whole feet. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable.
NESPP4 VARCHAR2	Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable.
NANIMALS NUMBER	Number of animals sighted.
SIGHTCUE VARCHAR2	Indicator of how sighting was first detected. Not collected prior to 5/1994; set to unknown.
ANMLCOND VARCHAR2	Condition of animal when released or sighted. See OBANMLCOND table. Collected for ASM where applicable.
ANMLBHVR VARCHAR2	Code for behavior of animal when released or sighted. (SIG: references OBANMLBHVR).
SIGCOMMENTS VARCHAR2	Information of field characteristics actually seen by observer and used to id animal.
EVNTNUM NUMBER	Sighting Event Number used in OBDBS Version 10

Data Attribute / Type

Description

PROGRAM
VARCHAR2

First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.

YEAR
VARCHAR2

Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.

MONTH
VARCHAR2

Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.

TRIPID
VARCHAR2

May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable.

LINK1
VARCHAR2

15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable.

YEAREVNT
VARCHAR2

Year event took place, 4 digits.

MONTHEVNT
VARCHAR2

Month event took place.

DAYEVNT
VARCHAR2

Day event took place.

TIMEEVNT
VARCHAR2

Local time using 24 hr. clock(0000-2359) that event occurred.

DATEEVNT
DATE

Date of the sighting or effort event reported. NOTE: if time is unknown it defaults to midnight in this field

EVNTTYPE
VARCHAR2

Indicator of type of event that occurred. See OBEVNTTYP table.

HAULNUM
VARCHAR2

Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable.

EVNTPOS
VARCHAR2

Location and position of observer on vessel at time of event. See OBEVNTPOS table.

LATEVT
VARCHAR2

Latitude location, (DDMMSS) where event occurred.

LONEVT
VARCHAR2

Longitude location, DDMMSS, where event occurred.

GIS_LATEVT
NUMBER

GIS format (decimal degrees) for the latitude for the event

GIS_LONEVT
NUMBER

GIS format (decimal degrees) for the longitude for the event

AREA
VARCHAR2

Statistical area code obtained from positions at beginning of haul for fixed gear and end of the haul for mobile gear or at sighting position. See LOC2AREAS table on sole. Collected for ASM where applicable.

WEATHER
VARCHAR2

HAUL: Code for weather at beginning of haul. EVENT: Code for weather at time event occurred. See support table OBWEATHER for codes. Collected for ASM where applicable.

WAVEHGT
NUMBER

HAUL: Wave height at beginning of haul, in whole feet. EVENT: Wave height at beginning of event, in whole feet. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable.

NESPP4
VARCHAR2

Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable.

NANIMALS
NUMBER

Number of animals sighted.

SIGHTCUE
VARCHAR2

Indicator of how sighting was first detected. Not collected prior to 5/1994; set to unknown.

ANMLCOND
VARCHAR2

Condition of animal when released or sighted. See OBANMLCOND table. Collected for ASM where applicable.

ANMLBHVR
VARCHAR2

Code for behavior of animal when released or sighted. (SIG: references OBANMLBHVR).

SIGCOMMENTS
VARCHAR2

Information of field characteristics actually seen by observer and used to id animal.

EVNTNUM
NUMBER

Sighting Event Number used in OBDBS Version 10

No Child Items for this record.

No contact information is available for this record.

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

Title:	View: OBSIG
Short Name:	OBSIG
Status:	Completed
Abstract:	Observer Sighting Logs
Notes:	Loaded by batch 9053, 07-27-2016 19:10

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	OBDBS
Description:	Observer Sighting Logs

Attribute Summary

	Name	Type	Description
100	PROGRAM	VARCHAR2	First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
100	YEAR	VARCHAR2	Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.
100	MONTH	VARCHAR2	Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.
100	TRIPID	VARCHAR2	May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable.
100	LINK1	VARCHAR2	15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable.
100	YEAREVNT	VARCHAR2	Year event took place, 4 digits.
100	MONTHEVNT	VARCHAR2	Month event took place.
100	DAYEVNT	VARCHAR2	Day event took place.
100	TIMEEVNT	VARCHAR2	Local time using 24 hr. clock(0000-2359) that event occurred.
100	DATEEVNT	DATE	Date of the sighting or effort event reported. NOTE: if time is unknown it defaults to midnight in this field
100	EVNTTYPE	VARCHAR2	Indicator of type of event that occurred. See OBEVNTTYP table.
100	HAULNUM	VARCHAR2	Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable.
100	EVNTPOS	VARCHAR2	Location and position of observer on vessel at time of event. See OBEVNTPOS table.
100	LATEVT	VARCHAR2	Latitude location, (DDMMSS) where event occurred.
100	LONEVT	VARCHAR2	Longitude location, DDMMSS, where event occurred.
100	GIS_LATEVT	NUMBER	GIS format (decimal degrees) for the latitude for the event
100	GIS_LONEVT	NUMBER	GIS format (decimal degrees) for the longitude for the event
100	AREA	VARCHAR2	Statistical area code obtained from positions at beginning of haul for fixed gear and end of the haul for mobile gear or at sighting position. See LOC2AREAS table on sole. Collected for ASM where applicable.
100	WEATHER	VARCHAR2	HAUL: Code for weather at beginning of haul. EVENT: Code for weather at time event occurred. See support table OBWEATHER for codes. Collected for ASM where applicable.
100	WAVEHGT	NUMBER	HAUL: Wave height at beginning of haul, in whole feet. EVENT: Wave height at beginning of event, in whole feet. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable.
100	NESPP4	VARCHAR2	Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable.
100	NANIMALS	NUMBER	Number of animals sighted.
100	SIGHTCUE	VARCHAR2	Indicator of how sighting was first detected. Not collected prior to 5/1994; set to unknown.
100	ANMLCOND	VARCHAR2	Condition of animal when released or sighted. See OBANMLCOND table. Collected for ASM where applicable.
100	ANMLBHVR	VARCHAR2	Code for behavior of animal when released or sighted. (SIG: references OBANMLBHVR).
100	SIGCOMMENTS	VARCHAR2	Information of field characteristics actually seen by observer and used to id animal.
100	EVNTNUM	NUMBER	Sighting Event Number used in OBDBS Version 10

Name

Type

Description

100

PROGRAM

VARCHAR2

First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.

100

YEAR

VARCHAR2

Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.

100

MONTH

VARCHAR2

Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.

100

TRIPID

VARCHAR2

100

LINK1

VARCHAR2

15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable.

100

YEAREVNT

VARCHAR2

Year event took place, 4 digits.

100

MONTHEVNT

VARCHAR2

Month event took place.

100

DAYEVNT

VARCHAR2

Day event took place.

100

TIMEEVNT

VARCHAR2

Local time using 24 hr. clock(0000-2359) that event occurred.

100

DATEEVNT

DATE

Date of the sighting or effort event reported. NOTE: if time is unknown it defaults to midnight in this field

100

EVNTTYPE

VARCHAR2

Indicator of type of event that occurred. See OBEVNTTYP table.

100

HAULNUM

VARCHAR2

Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable.

100

EVNTPOS

VARCHAR2

Location and position of observer on vessel at time of event. See OBEVNTPOS table.

100

LATEVT

VARCHAR2

Latitude location, (DDMMSS) where event occurred.

100

LONEVT

VARCHAR2

Longitude location, DDMMSS, where event occurred.

100

GIS_LATEVT

NUMBER

GIS format (decimal degrees) for the latitude for the event

100

GIS_LONEVT

NUMBER

GIS format (decimal degrees) for the longitude for the event

100

AREA

VARCHAR2

100

WEATHER

VARCHAR2

HAUL: Code for weather at beginning of haul. EVENT: Code for weather at time event occurred. See support table OBWEATHER for codes. Collected for ASM where applicable.

100

WAVEHGT

NUMBER

HAUL: Wave height at beginning of haul, in whole feet. EVENT: Wave height at beginning of event, in whole feet. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable.

100

NESPP4

VARCHAR2

Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable.

100

NANIMALS

NUMBER

Number of animals sighted.

100

SIGHTCUE

VARCHAR2

Indicator of how sighting was first detected. Not collected prior to 5/1994; set to unknown.

100

ANMLCOND

VARCHAR2

Condition of animal when released or sighted. See OBANMLCOND table. Collected for ASM where applicable.

100

ANMLBHVR

VARCHAR2

Code for behavior of animal when released or sighted. (SIG: references OBANMLBHVR).

100

SIGCOMMENTS

VARCHAR2

Information of field characteristics actually seen by observer and used to id animal.

100

EVNTNUM

NUMBER

Sighting Event Number used in OBDBS Version 10

Attribute Details

PROGRAM

CC ID: 334862

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
General Data Type:	VARCHAR2

YEAR

CC ID: 334873

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.
General Data Type:	VARCHAR2

MONTH

CC ID: 334882

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.
General Data Type:	VARCHAR2

TRIPID

CC ID: 334883

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable.
General Data Type:	VARCHAR2

LINK1

CC ID: 334884

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	15
Required:	No
Primary Key:	No
Status:	Active
Description:	15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable.
General Data Type:	VARCHAR2

YEAREVNT

CC ID: 334885

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Year event took place, 4 digits.
General Data Type:	VARCHAR2

MONTHEVNT

CC ID: 334886

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Month event took place.
General Data Type:	VARCHAR2

DAYEVNT

CC ID: 334887

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Day event took place.
General Data Type:	VARCHAR2

TIMEEVNT

CC ID: 334888

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Local time using 24 hr. clock(0000-2359) that event occurred.
General Data Type:	VARCHAR2

DATEEVNT

CC ID: 334863

Seq. Order:	10
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date of the sighting or effort event reported. NOTE: if time is unknown it defaults to midnight in this field
General Data Type:	DATE

EVNTTYPE

CC ID: 334864

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of type of event that occurred. See OBEVNTTYP table.
General Data Type:	VARCHAR2

HAULNUM

CC ID: 334865

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable.
General Data Type:	VARCHAR2

EVNTPOS

CC ID: 334866

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Location and position of observer on vessel at time of event. See OBEVNTPOS table.
General Data Type:	VARCHAR2

LATEVT

CC ID: 334867

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Latitude location, (DDMMSS) where event occurred.
General Data Type:	VARCHAR2

LONEVT

CC ID: 334868

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Longitude location, DDMMSS, where event occurred.
General Data Type:	VARCHAR2

GIS_LATEVT

CC ID: 334869

Seq. Order:	16
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	GIS format (decimal degrees) for the latitude for the event
General Data Type:	NUMBER

GIS_LONEVT

CC ID: 334870

Seq. Order:	17
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	GIS format (decimal degrees) for the longitude for the event
General Data Type:	NUMBER

AREA

CC ID: 334871

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Statistical area code obtained from positions at beginning of haul for fixed gear and end of the haul for mobile gear or at sighting position. See LOC2AREAS table on sole. Collected for ASM where applicable.
General Data Type:	VARCHAR2

WEATHER

CC ID: 334872

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	HAUL: Code for weather at beginning of haul. EVENT: Code for weather at time event occurred. See support table OBWEATHER for codes. Collected for ASM where applicable.
General Data Type:	VARCHAR2

WAVEHGT

CC ID: 334874

Seq. Order:	20
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	HAUL: Wave height at beginning of haul, in whole feet. EVENT: Wave height at beginning of event, in whole feet. Not collected prior to 5/1994; set to unknown. Collected for ASM where applicable.
General Data Type:	NUMBER

NESPP4

CC ID: 334875

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable.
General Data Type:	VARCHAR2

NANIMALS

CC ID: 334876

Seq. Order:	22
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Number of animals sighted.
General Data Type:	NUMBER

SIGHTCUE

CC ID: 334877

Seq. Order:	23
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of how sighting was first detected. Not collected prior to 5/1994; set to unknown.
General Data Type:	VARCHAR2

ANMLCOND

CC ID: 334878

Seq. Order:	24
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Condition of animal when released or sighted. See OBANMLCOND table. Collected for ASM where applicable.
General Data Type:	VARCHAR2

ANMLBHVR

CC ID: 334879

Seq. Order:	25
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for behavior of animal when released or sighted. (SIG: references OBANMLBHVR).
General Data Type:	VARCHAR2

SIGCOMMENTS

CC ID: 334880

Seq. Order:	26
Data Storage Type:	VARCHAR2
Max Length:	500
Required:	No
Primary Key:	No
Status:	Active
Description:	Information of field characteristics actually seen by observer and used to id animal.
General Data Type:	VARCHAR2

EVNTNUM

CC ID: 334881

Seq. Order:	27
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Sighting Event Number used in OBDBS Version 10
General Data Type:	NUMBER

Catalog Item ID:	33572
GUID:	gov.noaa.nmfs.inport:33572
Metadata Record Created By:	Patricia L Jones
Metadata Record Created:	2016-07-27 19:10+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2016-07-28
Owner Org:	NEFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2016-07-28
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2017-07-28

View: OBSIG

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

PROGRAM

YEAR

MONTH

TRIPID

LINK1

YEAREVNT

MONTHEVNT

DAYEVNT

TIMEEVNT

DATEEVNT

EVNTTYPE

HAULNUM

EVNTPOS

LATEVT

LONEVT

GIS_LATEVT

GIS_LONEVT

AREA

WEATHER

WAVEHGT

NESPP4

NANIMALS

SIGHTCUE

ANMLCOND

ANMLBHVR

SIGCOMMENTS

EVNTNUM

Catalog Details