9747
Table: ATL_SALMON
ATL_SALMON
Entity
Published / External
7284
AFSC/FMA/North Pacific Groundfish and Halibut Observer Program, Post 2008 Fishery Statistics.
Data Set
Completed
This entity records the number of prohibited pacific salmon recorded as bycatch ,by species, for an offload or a haul.
Loaded by batch 2390, 06-30-2009 16:11
Theme
AFSC
Theme
ATL
Theme
ATLAS
Theme
BYCATCH
Theme
FMA
Theme
GROUNDFISH
Theme
NORPAC
Theme
OBSERVER
Theme
PROHIBITED SPECIES
Theme
SAMPLING
Spatial
AI
Spatial
ALEUTIAN ISLANDS
Spatial
BERING SEA
Spatial
BS
Spatial
BSAI
Spatial
GOA
Spatial
GULF OF ALASKA
Data Table
Yes
NORPAC
This entity records the number of prohibited pacific salmon recorded as bycatch ,by species, for an offload or a haul. Retrofitted from table SALMON_TABLE.
1
CRUISE
NUMBER
22
Yes
Yes
8
0
Active
Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
NUMBER
Refers to more than one entity
2
SALMON_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated unique identifier of a salmon record
NUMBER
3
OFFLOAD_SEQ
NUMBER
22
No
No
9
0
Active
Sequence generated unique identifier for an offload record. This is the optional FK identifier from an offload.
NUMBER
NORPAC.ATL_OFFLOAD
4
HAUL_SEQ
NUMBER
22
No
No
9
0
Active
Sequence generated unique identifier for a haul record. This is the optional FK identifier from a haul.
NUMBER
NORPAC.ATL_HAUL
5
RELIABILITY_CODE
NUMBER
22
No
No
38
Active
Unique Numeric Value recording who (industry and or observer) recorded the salmon census. FK from lov_salmon_reliability. FK from atl_lov_salmon_reliability.
NUMBER
NORPAC.ATL_LOV_SALMON_RELIABIL
6
SCALE
VARCHAR2
1
No
No
Active
Whether the temperature was recorded in degrees farenheit(F), celsius(C) or nebulous(N).
VARCHAR2
F, C, N
7
SURFACE_TEMP
NUMBER
22
No
No
6
1
Active
Surface temperature of the water. Applicable only to hauls.
NUMBER
8
FISHING_TEMP
NUMBER
22
No
No
6
1
Active
Temperature recorded at fishing depth. Applicable only to hauls.
NUMBER
9
NUMBER_CHINOOK
NUMBER
22
No
No
38
Active
Number of Chinook recorded for this Haul or Offload. (Census of Salmon beginning 2011).
NUMBER
10
NUMBER_OTHER
NUMBER
22
No
No
38
Active
Number of Other salmon species recorded for this Haul or Offload. (Census of Salmon beginning 2011).
NUMBER
11
NUMBER_UNIDENTIFIED
NUMBER
22
No
No
38
Active
Number of Salmon which could not be identified by species.
NUMBER
12
PERMIT
VARCHAR2
6
Yes
Yes
Active
Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
VARCHAR2
Upper
Refers to more than one entity
13
NUMBER_CHUM
NUMBER
22
No
No
5
0
Active
Number of Chum salmon tallied for this Haul or Offload. (Census of Salmon beginning 2011).
NUMBER
14
NUMBER_COHO
NUMBER
22
No
No
5
0
Active
Number of Coho salmon tallied for this Haul or Offload. (Census of Salmon beginning 2011).
NUMBER
15
NUMBER_SOCKEYE
NUMBER
22
No
No
5
0
Active
Number of Sockeye salmon tallied for this Haul or Offload. (Census of Salmon beginning 2011).
NUMBER
16
NUMBER_PINK
NUMBER
22
No
No
5
0
Active
Number of Pink salmon tallied for this Haul or Offload. (Census of Salmon beginning 2011).
NUMBER
gov.noaa.nmfs.inport:9747
Doug Turnbull
2009-06-30T16:11:45
SysAdmin InPortAdmin
2022-08-09T17:11:03
2018-09-26
Alaska Fisheries Science Center
AFSC
7600 Sand Point Way N.E., Building 4
Seattle
WA
98115
USA
http://www.afsc.noaa.gov
0700-1700 Pacific Time
1001
Public
No
2018-09-26
1 Year
2019-09-26