28415
CURRENT_LENGTH
CURRENT LENGTH
Entity
Published / External
28125
AFSC/FMA/Current Observer Data Interface
Data Set
In Work
The current length data object is a denormalized view of haul, species composition and length fisheries statistics. It is derived from the observer production data and in inclusive from 2008 through the current date. The primary users are industry for inseason montoring of production.
Populated in batch by the execution of the procedure load_current_length which is run every two hours.
Temporal
2008 AND FORWARD
Spatial
BS, AI, BSAI, GOA
Stratum
OBSERVER, CURRENT DATA, FISHERY STATISTICS
Fisheries Monitoring and Analysis
Seattle
WA
USA
Alaska Fisheries Science Center
Data Table
Yes
CURRENT_LENGTH
OBSINT
The current length data object is a denormalized view of haul, species composition and length fisheries statistics. It is derived from the observer production data and in inclusive from 2008 through the current date. The primary users are industry for inseason montoring of production.
10
T_TABLE
VARCHAR2
18
No
No
Active
Identifier of Source Table. Length statistics may be sourced directly from hauls or offloads, or by the more usual path of observer sampling ans species composition.
Character
Upper
15
CRUISE
Number
8
No
No
8
0
Active
Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
Integer
20
PERMIT
VARCHAR2
6
No
No
Active
Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau.
Chracter
Upper
25
HAUL_JOIN
NUMBER
32
No
No
Active
Surrogate FK to haul if length record is so derived Composed of concatenation of cruise, permit and haul_seq. For domestic table records this is a sequence generated unique identifier for a haul.
INTEGER
30
PORT_JOIN
NUMBER
23
No
No
23
0
Active
Surrogate FK to offload if length record is so derived. Composed of concatenation of cruise, permit and offload_seq. For domestic table records this is a sequence generated unique identifier for a port.
INTEGER
35
LENGTH_SEQ
NUMBER
8
No
No
8
0
Active
Sequence generated unique identifier of an atl_length.
INTEGER
40
VESSEL
VARCHAR2
7
No
No
Active
Alpha Numeric code from ATL_Lov_Vessel table, which identifies the vessel. This is a legacy value from the pre 2008 data model and is for the convenience of the users only. Permit is the unique identifier of a vessel and the appropriate join value.
45
HAUL_OFFLOAD_DATE
DATE
12
No
No
Active
Date of offload or haul retrieval depending on whether this length frequency record was derived from an offload or a haul.
Date
50
HAUL_OFFLOAD
Number
3
No
No
3
0
Active
Number which is entered by the observer identifying a unique haul or offload depending on which was the ultimate data source.
Integer
55
GEAR_TYPE
Number
3
No
No
3
0
Active
Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record
Integer
60
NMFS_AREA
number
3
No
No
3
0
Active
Inherited from parent haul when appropriate NULL for offloads and domestic table data.
Integer
65
LATDD_START
NUMBER
7
No
No
7
5
Active
Latitude decimal degrees is computed from the deployment latitude.
Number
70
LONDD_START
Number
8
No
No
8
2
Active
Longitude decimal degrees is computed from the deploymentl longitude.
Number
75
LATDD_END
Number
7
No
No
7
5
Active
Latitude decimal degrees is computed from the deployment latitude of a haul.
Number
80
LONDD_END
NUMBER
8
No
No
8
5
Active
Longitude decimal degrees is computed from the retrieval longitude.
Number
85
SPECIES
NUMBER
4
No
No
4
0
Active
Species either inherited from species composition or recorded in length if different, or if the length record is a child of haul or offload.
Integer
90
SEX
VARCHAR2
1
No
No
Active
Sex of length frequency animals
Character
Upper
M, F, U
95
LENGTH
NUMBER
33
No
No
Active
Measured length of organism in cm.
Real Number
100
FREQUENCY
Number
23
No
No
Active
Number of animals measured of a given length.
Integer
105
EGGS
VARCHAR2
1
No
No
Active
Indicator of presence or absence of eggs.
CHARACTER
Upper
Y,N,U
110
YEAR
NUMBER
4
No
No
4
0
Active
Year extracted from haul retrieval date or offload deleivery end date
INTEGER
115
VIABILITY
VARCHAR2
1
No
No
Active
Halibut viability code.
CHARACTER
120
INJURY
VARCHAR2
40
No
No
Active
Halibut injury code.
125
SAMPLE_SYSTEM
NUMBER
2
No
No
2
0
Active
Code for sampling system employed by the observer.
INTEGER
130
GEAR_PERFORMANCE
NUMBER
2
No
No
2
0
Active
Unique performance code for a gear type. FK to atl_lov_gear_performance
INTEGER
Data Steward
2008
Person
Narita, Renold E
ren.narita@noaa.gov
Email
Data Steward
2008
Person
Blair, Julie A
julie.blair@noaa.gov
7600 Sandpoint Way NE
Seattle
WA
98115
USA
206 526 4053
(206)526-4066
0700-1630
Email
Distributor
2008
Person
Blair, Julie A
julie.blair@noaa.gov
7600 Sandpoint Way NE
Seattle
WA
98115
USA
206 526 4053
(206)526-4066
0700-1630
Email
Metadata Contact
2008
Person
Narita, Renold E
ren.narita@noaa.gov
Email
Point of Contact
2008
Person
Blair, Julie A
julie.blair@noaa.gov
7600 Sandpoint Way NE
Seattle
WA
98115
USA
206 526 4053
(206)526-4066
0700-1630
Email
Confidential
Confidential under Magnuson Stevens.
Made available to OLE, NMFS Staff, and vessel managers with valid confidentiality agreements
Made available to OLE, NMFS Staff, and vessel managers with valid confidentiality agreements
Made available to OLE, NMFS Staff, and vessel managers with valid confidentiality agreements, requests must be made through Ren Narita.
Confidential data may not be published in raw form
Confidential data may only be used for fisheries management and approved research.
None
None
gov.noaa.nmfs.inport:28415
Julie Blair
2015-10-30T11:12:23
SysAdmin InPortAdmin
2022-08-09T17:11:00
2016-05-04
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
2016-05-04
1 Year
2017-05-04