Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > North Pacific (NORPAC) Groundfish and Halibut O... > AFSC/FMA/North Pacific Groundfish and Halibut O... >

Table: ATL_BIRD_EVENT

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:9638  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Keywords
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

This entity records bird interactions characterized by type, that may occur at either the haul, offload or at the trip level. Each interaction is recorded separately and may be for multiple animals.

Description

This entity records bird interactions characterized by type, that may occur at either the haul, offload or at the trip level. Each interaction is recorded separately and may be for multiple animals.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
BIRD_EVENT_SEQ
NUMBER 		Sequence generated unique identifier of a bird interaction event.
cruise1
NUMBER 		Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
CRUISE
NUMBER 		Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
PERMIT
VARCHAR2 		Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
EVENT_NUMBER
NUMBER 		User defined event reference number which is unique within a cruise.
TRIP_SEQ
NUMBER 		Sequence generated unique identifier of a trip
OFFLOAD_SEQ
NUMBER 		Sequence generated unique identifier for an offload record
HAUL_SEQ
NUMBER 		Sequence generated unique identifier for a haul record
DETERRENT_USED_CODE
VARCHAR2 		Unique code dientifying the reason for the use or absence of a bird deterrence strategy.
BEAUFORT_CODE
VARCHAR2 		International Beaufort Sea State Code
COUNT_TYPE_CODE
VARCHAR2 		Unique code describing how the number of animals field is determined. Except for a type of specific the grouping is an estimate and number is not required.
LOCATION_CODE
VARCHAR2 		Unique code identifying the location of the bird at the first observation
WEATHER_CODE
VARCHAR2 		Unique weather code
FISHERY_CODE
VARCHAR2 		Unique Abbreviated code for a fishery as defined by the observer.
NUMBER_OF_ANIMALS
NUMBER 		Number of animals involved with this interaction
LATITUDE_DEGREE
NUMBER 		Latitude at which the interaction with a bird occured.
LATITUDE_MINUTES
NUMBER 		Latitude at which the interaction with a bird occured.
LATITUDE_SECONDS
NUMBER 		Latitude at which the interaction with a bird occured.
LONGITUDE_DEGREE
NUMBER 		Longitude at which the interaction with a bird occured.
LONGITUDE_MINUTES
NUMBER 		Longitude at which the interaction with a bird occured.
LONGITUDE_SECONDS
NUMBER 		Longitude at which the interaction with a bird occured.
LONGITUDE_EW
VARCHAR2 		Identifies the logitude as E(ast) or W(est)
INTERACTION_DATE_TIME
DATE 		Date the interaction was observed. If an interaction record is related to an offload or a haul this date is inferred as the haul date or offload end date. If the interaction is related to a trip the interaction date is mandatory.
COMMENTS
VARCHAR2 		Observer entered comments regarding this interaction.

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: Table: ATL_BIRD_EVENT
Short Name: ATL_BIRD_EVENT
Status: Completed
Abstract:

This entity records bird interactions characterized by type, that may occur at either the haul, offload or at the trip level. Each interaction is recorded separately and may be for multiple animals.
Purpose:

The bird and bird/gear/vessel interaction and sampling data is collected for the US Fish and Wildlife Service by FMA observers. These modules both on the Atlas Client and NORPAC go live Jan 2010.
Notes:

Loaded by batch 2390, 06-30-2009 16:11

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None ATL
None ATLAS
None AVAIN
None BIRDS
None BYCATCH
None NORPAC
None OBSERVER

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None BERING SEA
None BSAI
None GOA
None GULF OF ALASKA

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NORPAC
Description:

This entity records bird interactions characterized by type, that may occur at either the haul, offload or at the trip level. Each interaction is recorded separately and may be for multiple animals.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key BIRD_EVENT_SEQ NUMBER Sequence generated unique identifier of a bird interaction event.
100
 cruise1 NUMBER Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
100
 Primary Key CRUISE NUMBER Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
100
 Primary Key PERMIT VARCHAR2 Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
100
 EVENT_NUMBER NUMBER User defined event reference number which is unique within a cruise.
100
 TRIP_SEQ NUMBER Sequence generated unique identifier of a trip
100
 OFFLOAD_SEQ NUMBER Sequence generated unique identifier for an offload record
100
 HAUL_SEQ NUMBER Sequence generated unique identifier for a haul record
100
 DETERRENT_USED_CODE VARCHAR2 Unique code dientifying the reason for the use or absence of a bird deterrence strategy.
100
 BEAUFORT_CODE VARCHAR2 International Beaufort Sea State Code
100
 COUNT_TYPE_CODE VARCHAR2 Unique code describing how the number of animals field is determined. Except for a type of specific the grouping is an estimate and number is not required.
100
 LOCATION_CODE VARCHAR2 Unique code identifying the location of the bird at the first observation
100
 WEATHER_CODE VARCHAR2 Unique weather code
100
 FISHERY_CODE VARCHAR2 Unique Abbreviated code for a fishery as defined by the observer.
100
 NUMBER_OF_ANIMALS NUMBER Number of animals involved with this interaction
100
 LATITUDE_DEGREE NUMBER Latitude at which the interaction with a bird occured.
100
 LATITUDE_MINUTES NUMBER Latitude at which the interaction with a bird occured.
100
 LATITUDE_SECONDS NUMBER Latitude at which the interaction with a bird occured.
100
 LONGITUDE_DEGREE NUMBER Longitude at which the interaction with a bird occured.
100
 LONGITUDE_MINUTES NUMBER Longitude at which the interaction with a bird occured.
100
 LONGITUDE_SECONDS NUMBER Longitude at which the interaction with a bird occured.
100
 LONGITUDE_EW VARCHAR2 Identifies the logitude as E(ast) or W(est)
100
 INTERACTION_DATE_TIME DATE Date the interaction was observed. If an interaction record is related to an offload or a haul this date is inferred as the haul date or offload end date. If the interaction is related to a trip the interaction date is mandatory.
100
 COMMENTS VARCHAR2 Observer entered comments regarding this interaction.

Attribute Details

BIRD_EVENT_SEQ

CC ID: 37912
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 9
Scale: 0
Status: Active
Description:

Sequence generated unique identifier of a bird interaction event.
General Data Type: NUMBER

cruise1

CC ID: 37915
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 0
Status: Active
Description:

Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
General Data Type: NUMBER
Foreign Key Relations:

Refers to more than one entity

CRUISE

CC ID: 37916
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 8
Scale: 0
Status: Active
Description:

Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
General Data Type: NUMBER
Foreign Key Relations:

Refers to more than one entity

PERMIT

CC ID: 37932
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 6
Required: Yes
Primary Key: Yes
Status: Active
Description:

Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
General Data Type: VARCHAR2
Foreign Key Relations:

Refers to more than one entity

EVENT_NUMBER

CC ID: 37918
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

User defined event reference number which is unique within a cruise.
General Data Type: NUMBER

TRIP_SEQ

CC ID: 37933
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Scale: 0
Status: Active
Description:

Sequence generated unique identifier of a trip
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.ATL_FMA_TRIP

OFFLOAD_SEQ

CC ID: 37931
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Scale: 0
Status: Active
Description:

Sequence generated unique identifier for an offload record
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.ATL_OFFLOAD

HAUL_SEQ

CC ID: 37920
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Scale: 0
Status: Active
Description:

Sequence generated unique identifier for a haul record
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.ATL_HAUL

DETERRENT_USED_CODE

CC ID: 37917
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 10
Required: Yes
Primary Key: No
Status: Active
Description:

Unique code dientifying the reason for the use or absence of a bird deterrence strategy.
General Data Type: VARCHAR2
Foreign Key Relations:

NORPAC.ATL_LOV_BIRD_DETERERENT

BEAUFORT_CODE

CC ID: 37911
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 10
Required: Yes
Primary Key: No
Status: Active
Description:

International Beaufort Sea State Code
General Data Type: VARCHAR2
Foreign Key Relations:

NORPAC.ATL_LOV_BEAUFORT_SCALE

COUNT_TYPE_CODE

CC ID: 37914
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 10
Required: Yes
Primary Key: No
Status: Active
Description:

Unique code describing how the number of animals field is determined. Except for a type of specific the grouping is an estimate and number is not required.
General Data Type: VARCHAR2
Foreign Key Relations:

NORPAC.ATL_LOV_BIRD_COUNT_TYPE

LOCATION_CODE

CC ID: 37925
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 10
Required: Yes
Primary Key: No
Status: Active
Description:

Unique code identifying the location of the bird at the first observation
General Data Type: VARCHAR2
Foreign Key Relations:

NORPAC.ATL_LOV_BIRD_EVENT_LOCA

WEATHER_CODE

CC ID: 37934
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 10
Required: Yes
Primary Key: No
Status: Active
Description:

Unique weather code
General Data Type: VARCHAR2
Foreign Key Relations:

NORPAC.ATL_LOV_WEATHER_CODE

FISHERY_CODE

CC ID: 37919
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 5
Required: Yes
Primary Key: No
Status: Active
Description:

Unique Abbreviated code for a fishery as defined by the observer.
General Data Type: VARCHAR2
Foreign Key Relations:

NORPAC.ATL_LOV_BIRD_FISHERY

NUMBER_OF_ANIMALS

CC ID: 37930
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Number of animals involved with this interaction
General Data Type: NUMBER

LATITUDE_DEGREE

CC ID: 37922
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Latitude at which the interaction with a bird occured.
General Data Type: NUMBER

LATITUDE_MINUTES

CC ID: 37923
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Latitude at which the interaction with a bird occured.
General Data Type: NUMBER

LATITUDE_SECONDS

CC ID: 37924
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Latitude at which the interaction with a bird occured.
General Data Type: NUMBER

LONGITUDE_DEGREE

CC ID: 37926
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Longitude at which the interaction with a bird occured.
General Data Type: NUMBER

LONGITUDE_MINUTES

CC ID: 37928
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Longitude at which the interaction with a bird occured.
General Data Type: NUMBER

LONGITUDE_SECONDS

CC ID: 37929
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Longitude at which the interaction with a bird occured.
General Data Type: NUMBER

LONGITUDE_EW

CC ID: 37927
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Identifies the logitude as E(ast) or W(est)
General Data Type: VARCHAR2

INTERACTION_DATE_TIME

CC ID: 37921
Seq. Order: 22
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date the interaction was observed. If an interaction record is related to an offload or a haul this date is inferred as the haul date or offload end date. If the interaction is related to a trip the interaction date is mandatory.
General Data Type: DATE

COMMENTS

CC ID: 37913
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 500
Required: No
Primary Key: No
Status: Active
Description:

Observer entered comments regarding this interaction.
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 9638
GUID: gov.noaa.nmfs.inport:9638
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2009-06-30 16:11+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-09-26
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-09-26
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-09-26