View: OBSIG
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33572 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | View: OBSIG |
---|---|
Short Name: | OBSIG |
Status: | Completed |
Abstract: |
Observer Sighting Logs |
Notes: |
Loaded by batch 9053, 07-27-2016 19:10 |
Entity Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Schema Name: | OBDBS |
Description: |
Observer Sighting Logs |
Data Attributes
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 |
Attribute Details
PROGRAM
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 Details
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 |