CURRENT_LENGTH
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:28415 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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.
DescriptionThe 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.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
T_TABLE
VARCHAR2 |
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. |
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. |
HAUL_JOIN
NUMBER |
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. |
PORT_JOIN
NUMBER |
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. |
LENGTH_SEQ
NUMBER |
Sequence generated unique identifier of an atl_length. |
VESSEL
VARCHAR2 |
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. |
HAUL_OFFLOAD_DATE
DATE |
Date of offload or haul retrieval depending on whether this length frequency record was derived from an offload or a haul. |
HAUL_OFFLOAD
Number |
Number which is entered by the observer identifying a unique haul or offload depending on which was the ultimate data source. |
GEAR_TYPE
Number |
Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record |
NMFS_AREA
number |
Inherited from parent haul when appropriate NULL for offloads and domestic table data. |
LATDD_START
NUMBER |
Latitude decimal degrees is computed from the deployment latitude. |
LONDD_START
Number |
Longitude decimal degrees is computed from the deploymentl longitude. |
LATDD_END
Number |
Latitude decimal degrees is computed from the deployment latitude of a haul. |
LONDD_END
NUMBER |
Longitude decimal degrees is computed from the retrieval longitude. |
SPECIES
NUMBER |
Species either inherited from species composition or recorded in length if different, or if the length record is a child of haul or offload. |
SEX
VARCHAR2 |
Sex of length frequency animals |
LENGTH
NUMBER |
Measured length of organism in cm. |
FREQUENCY
Number |
Number of animals measured of a given length. |
EGGS
VARCHAR2 |
Indicator of presence or absence of eggs. |
YEAR
NUMBER |
Year extracted from haul retrieval date or offload deleivery end date |
VIABILITY
VARCHAR2 |
Halibut viability code. |
INJURY
VARCHAR2 |
Halibut injury code. |
SAMPLE_SYSTEM
NUMBER |
Code for sampling system employed by the observer. |
GEAR_PERFORMANCE
NUMBER |
Unique performance code for a gear type. FK to atl_lov_gear_performance |
Child Items
No Child Items for this record.
Contact Information
Point of Contact
Julie A Blair
julie.blair@noaa.gov
206 526 4053
Metadata Contact
Renold E Narita
ren.narita@noaa.gov
Item Identification
Title: | CURRENT_LENGTH |
---|---|
Short Name: | CURRENT LENGTH |
Status: | In Work |
Abstract: |
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. |
Supplemental Information: |
Populated in batch by the execution of the procedure load_current_length which is run every two hours. |
Keywords
Temporal Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | 2008 AND FORWARD |
Spatial Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | BS, AI, BSAI, GOA |
Stratum Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | OBSERVER, CURRENT DATA, FISHERY STATISTICS |
Physical Location
Organization: | Fisheries Monitoring and Analysis |
---|---|
City: | Seattle |
State/Province: | WA |
Country: | USA |
Location Description: |
Alaska Fisheries Science Center |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Alias: | CURRENT_LENGTH |
Schema Name: | OBSINT |
Description: |
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. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
T_TABLE | VARCHAR2 | 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. | |
100
|
CRUISE | Number | Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. | |
100
|
PERMIT | VARCHAR2 | Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau. | |
100
|
HAUL_JOIN | NUMBER | 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. | |
100
|
PORT_JOIN | NUMBER | 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. | |
100
|
LENGTH_SEQ | NUMBER | Sequence generated unique identifier of an atl_length. | |
100
|
VESSEL | VARCHAR2 | 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. | |
100
|
HAUL_OFFLOAD_DATE | DATE | Date of offload or haul retrieval depending on whether this length frequency record was derived from an offload or a haul. | |
100
|
HAUL_OFFLOAD | Number | Number which is entered by the observer identifying a unique haul or offload depending on which was the ultimate data source. | |
100
|
GEAR_TYPE | Number | Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record | |
100
|
NMFS_AREA | number | Inherited from parent haul when appropriate NULL for offloads and domestic table data. | |
100
|
LATDD_START | NUMBER | Latitude decimal degrees is computed from the deployment latitude. | |
100
|
LONDD_START | Number | Longitude decimal degrees is computed from the deploymentl longitude. | |
100
|
LATDD_END | Number | Latitude decimal degrees is computed from the deployment latitude of a haul. | |
100
|
LONDD_END | NUMBER | Longitude decimal degrees is computed from the retrieval longitude. | |
100
|
SPECIES | NUMBER | Species either inherited from species composition or recorded in length if different, or if the length record is a child of haul or offload. | |
100
|
SEX | VARCHAR2 | Sex of length frequency animals | |
100
|
LENGTH | NUMBER | Measured length of organism in cm. | |
100
|
FREQUENCY | Number | Number of animals measured of a given length. | |
100
|
EGGS | VARCHAR2 | Indicator of presence or absence of eggs. | |
100
|
YEAR | NUMBER | Year extracted from haul retrieval date or offload deleivery end date | |
100
|
VIABILITY | VARCHAR2 | Halibut viability code. | |
100
|
INJURY | VARCHAR2 | Halibut injury code. | |
100
|
SAMPLE_SYSTEM | NUMBER | Code for sampling system employed by the observer. | |
100
|
GEAR_PERFORMANCE | NUMBER | Unique performance code for a gear type. FK to atl_lov_gear_performance |
Attribute Details
T_TABLE
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 18 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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. |
General Data Type: | Character |
Case Restriction: | Upper |
CRUISE
Seq. Order: | 15 |
---|---|
Data Storage Type: | Number |
Max Length: | 8 |
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: | Integer |
PERMIT
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
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: | Chracter |
Case Restriction: | Upper |
HAUL_JOIN
Seq. Order: | 25 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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. |
General Data Type: | INTEGER |
PORT_JOIN
Seq. Order: | 30 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 23 |
Required: | No |
Primary Key: | No |
Precision: | 23 |
Scale: | 0 |
Status: | Active |
Description: |
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. |
General Data Type: | INTEGER |
LENGTH_SEQ
Seq. Order: | 35 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated unique identifier of an atl_length. |
General Data Type: | INTEGER |
VESSEL
Seq. Order: | 40 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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. |
HAUL_OFFLOAD_DATE
Seq. Order: | 45 |
---|---|
Data Storage Type: | DATE |
Max Length: | 12 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date of offload or haul retrieval depending on whether this length frequency record was derived from an offload or a haul. |
General Data Type: | Date |
HAUL_OFFLOAD
Seq. Order: | 50 |
---|---|
Data Storage Type: | Number |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Number which is entered by the observer identifying a unique haul or offload depending on which was the ultimate data source. |
General Data Type: | Integer |
GEAR_TYPE
Seq. Order: | 55 |
---|---|
Data Storage Type: | Number |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record |
General Data Type: | Integer |
NMFS_AREA
Seq. Order: | 60 |
---|---|
Data Storage Type: | number |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Inherited from parent haul when appropriate NULL for offloads and domestic table data. |
General Data Type: | Integer |
LATDD_START
Seq. Order: | 65 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Precision: | 7 |
Scale: | 5 |
Status: | Active |
Description: |
Latitude decimal degrees is computed from the deployment latitude. |
General Data Type: | Number |
LONDD_START
Seq. Order: | 70 |
---|---|
Data Storage Type: | Number |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 2 |
Status: | Active |
Description: |
Longitude decimal degrees is computed from the deploymentl longitude. |
General Data Type: | Number |
LATDD_END
Seq. Order: | 75 |
---|---|
Data Storage Type: | Number |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Precision: | 7 |
Scale: | 5 |
Status: | Active |
Description: |
Latitude decimal degrees is computed from the deployment latitude of a haul. |
General Data Type: | Number |
LONDD_END
Seq. Order: | 80 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 5 |
Status: | Active |
Description: |
Longitude decimal degrees is computed from the retrieval longitude. |
General Data Type: | Number |
SPECIES
Seq. Order: | 85 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Species either inherited from species composition or recorded in length if different, or if the length record is a child of haul or offload. |
General Data Type: | Integer |
SEX
Seq. Order: | 90 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Sex of length frequency animals |
General Data Type: | Character |
Case Restriction: | Upper |
Allowed Values: | M, F, U |
LENGTH
Seq. Order: | 95 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 33 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Measured length of organism in cm. |
General Data Type: | Real Number |
FREQUENCY
Seq. Order: | 100 |
---|---|
Data Storage Type: | Number |
Max Length: | 23 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of animals measured of a given length. |
General Data Type: | Integer |
EGGS
Seq. Order: | 105 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Indicator of presence or absence of eggs. |
General Data Type: | CHARACTER |
Case Restriction: | Upper |
Allowed Values: | Y,N,U |
YEAR
Seq. Order: | 110 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Year extracted from haul retrieval date or offload deleivery end date |
General Data Type: | INTEGER |
VIABILITY
Seq. Order: | 115 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Halibut viability code. |
General Data Type: | CHARACTER |
INJURY
Seq. Order: | 120 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 40 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Halibut injury code. |
SAMPLE_SYSTEM
Seq. Order: | 125 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Code for sampling system employed by the observer. |
General Data Type: | INTEGER |
GEAR_PERFORMANCE
Seq. Order: | 130 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Unique performance code for a gear type. FK to atl_lov_gear_performance |
General Data Type: | INTEGER |
Support Roles
Data Steward
Date Effective From: | 2008 |
---|---|
Date Effective To: | |
Contact (Person): | Narita, Renold E |
Email Address: | ren.narita@noaa.gov |
Contact Instructions: |
|
Data Steward
Date Effective From: | 2008 |
---|---|
Date Effective To: | |
Contact (Person): | Blair, Julie A |
Address: |
7600 Sandpoint Way NE Seattle, WA 98115 USA |
Email Address: | julie.blair@noaa.gov |
Phone: | 206 526 4053 |
Fax: | (206)526-4066 |
Business Hours: | 0700-1630 |
Contact Instructions: |
|
Distributor
Date Effective From: | 2008 |
---|---|
Date Effective To: | |
Contact (Person): | Blair, Julie A |
Address: |
7600 Sandpoint Way NE Seattle, WA 98115 USA |
Email Address: | julie.blair@noaa.gov |
Phone: | 206 526 4053 |
Fax: | (206)526-4066 |
Business Hours: | 0700-1630 |
Contact Instructions: |
|
Metadata Contact
Date Effective From: | 2008 |
---|---|
Date Effective To: | |
Contact (Person): | Narita, Renold E |
Email Address: | ren.narita@noaa.gov |
Contact Instructions: |
|
Point of Contact
Date Effective From: | 2008 |
---|---|
Date Effective To: | |
Contact (Person): | Blair, Julie A |
Address: |
7600 Sandpoint Way NE Seattle, WA 98115 USA |
Email Address: | julie.blair@noaa.gov |
Phone: | 206 526 4053 |
Fax: | (206)526-4066 |
Business Hours: | 0700-1630 |
Contact Instructions: |
|
Access Information
Security Class: | Confidential |
---|---|
Security Classification System: |
Confidential under Magnuson Stevens. |
Security Handling Description: |
Made available to OLE, NMFS Staff, and vessel managers with valid confidentiality agreements |
Data Access Policy: |
Made available to OLE, NMFS Staff, and vessel managers with valid confidentiality agreements |
Data Access Procedure: |
Made available to OLE, NMFS Staff, and vessel managers with valid confidentiality agreements, requests must be made through Ren Narita. |
Data Access Constraints: |
Confidential data may not be published in raw form |
Data Use Constraints: |
Confidential data may only be used for fisheries management and approved research. |
Metadata Access Constraints: |
None |
Metadata Use Constraints: |
None |
Catalog Details
Catalog Item ID: | 28415 |
---|---|
GUID: | gov.noaa.nmfs.inport:28415 |
Metadata Record Created By: | Julie A Blair |
Metadata Record Created: | 2015-10-30 11:12+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2016-05-04 |
Owner Org: | AFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2016-05-04 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2017-05-04 |