LL_STATION
Northeast Fisheries Science Center
Entity
(ENT)
| ID: 35952
| Published / External
Created: 2016-12-13
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 27731
ID: 35952
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | LL_STATION |
---|---|
Short Name | LL_STATION |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Table contains the operational and location data for each station |
* Purpose | |
Notes | |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | Data Table |
---|---|
Active Version? | Y |
Alias | |
Schema Name | |
» Description |
Table contains the operational and location data for each station |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | CRUISE | NUMBER | Unique numerical code for each cruise. Specific to a vessel and season. Five digits, where first 2 digits indicate vessel, next 2 year, last digit season. For example 24142 = Tenacious II 2014 fall survey or 25151 = Mary Elizabeth 2015 spring survey. If last digit = 3 it is an experimental survey trip |
100 | No | No | STATION | NUMBER | Unique sequential order in which stations have been completed, unique to each cruise code. Failed gear deployments each receive a non-repeated consecutive number. |
100 | No | No | STATION_ID | VARCHAR2 | A predefined identifier generated during the random station assignment indicating the area where a piece of fishing gear is to be deployed. (Strata coding modified from the SVDBS definition, see SVDBS.UNION_FSCS_SVSTA.STRATUM) Code consists of 3 parts: Stratum number (2bytes) and bottom stratum type (1 bytes). Stratum number refers to strata from the SVDBS offshore stratum group with the numbers defined by depth zone. The third byte refers to the longline survey bottom strata type; 1 = smooth bottom; 0 = rough bottom. The fifth byte (following a dash as the fourth byte) is the number assigned based on the random sequential order drawn within each stratum and bottom type. For example: 270-5 would be the fifth random rough-bottom station drawn in strata 27; 361-1 would be the first random smooth-bottom station drawn in strata 36. |
100 | No | No | TRIP_ID | NUMBER | Unique trip identifier generated in FLDRS software. Generated to identify each fishing trip from port. Fishing operation data collected using the FLDRS software and initially loaded into FVTR tables, before being migrated to this schema. See FVTR.CRPP_VERS_TRIP |
100 | No | No | EFFORT_NUM | NUMBER | Unique identifier for each fishing effort (gear deployment) within a trip, see FVTR.CRPP_VERS_TRIP |
100 | No | No | STRATUM | NUMBER | A predefined area where the longline gear was deployed. Stratum is a two digit number referring to the stratum number from the SVDBS stratum definition, see SVDBS.UNION_FSCS_SVSTA.STRATUM. All longline strata are taken from the SVDBS offshore stratum group. May be null or differ from ASSIGNED_STRATUM, if more than 50% of the gear was deployed over the boundary into an adjoining stratum. |
100 | No | No | ASSIGNED_STRATUM | NUMBER | The predefined area where the longline gear was assigned to be deployed. Stratum is a two digit number referring to the stratum number from the SVDBS stratum definition, see SVDBS.UNION_FSCS_SVSTA.STRATUM. All longline strata are taken from the SVDBS offshore stratum group. ASSIGNED STRATUM will match the first two bytes of the STATION_ID code |
100 | No | No | BOTTOM_TYPE | VARCHAR2 | A bottom type substratification specific to the longline survey. Rough bottom strata were defined as areas above the 70th percentile for Terrain Rugged Index values (Hare at al. 2012) within each stratum. Regions below the 70th percentile cut point were assigned to the smooth-bottom sub-stratum. |
100 | No | No | AREA | NUMBER | Standard area code used for commercial data (New England Statistical Area Code) for the position of the beginning of the tow. |
100 | No | No | BEGIN_SET_TIME | DATE | Datetime (UTC) when the gear is first placed in the water at the start of the fishing effort |
100 | No | No | END_SET_TIME | DATE | Datetime (UTC) when setting of the gear has stopped and the gear begins to fish |
100 | No | No | BEGIN_HAUL_TIME | DATE | Datetime (UTC) when fishing stops and hauling the gear starts |
100 | No | No | END_HAUL_TIME | DATE | Datetime (UTC) when the gear has been completely hauled and is back aboard the vessel |
100 | No | No | SOAK_DURATION_DH | NUMBER | Soak or haul duration of the fishing effort (h.hh), from END_SET_TIME until BEGIN_HAUL_TIME |
100 | No | No | DECDEG_BEGLAT_SET | NUMBER | Latitude where the gear is first placed in the water at the start of the fishing effort (ddmm.mmmm) |
100 | No | No | DECDEG_BEGLON_SET | NUMBER | Longitude where the gear is first placed in the water at the start of the fishing effort (dddmm.mmmm) |
100 | No | No | DECDEG_ENDLAT_SET | NUMBER | Latitude where the setting of the gear has stopped and the gear begins to fish (ddmm.mmmm) |
100 | No | No | DECDEG_ENDLON_SET | NUMBER | Longitude where the setting of the gear has stopped and the gear begins to fish (dddmm.mmmm) |
100 | No | No | DECDEG_BEGLAT_HAUL | NUMBER | Latitude where fishing stops and hauling the gear starts (ddmm.mmmm) |
100 | No | No | DECDEG_BEGLON_HAUL | NUMBER | Longitude where fishing stops and hauling the gear starts (dddmm.mmmm) |
100 | No | No | DECDEG_ENDLAT_HAUL | NUMBER | Latitude where the gear has been completely hauled and is back aboard the vessel (ddmm.mmmm) |
100 | No | No | DECDEG_ENDLON_HAUL | NUMBER | Longitude where the gear has been completely hauled and is back aboard the vessel (dddmm.mmmm) |
100 | No | No | STATION_TYPE | NUMBER | Survey station type. See LL_STA_EVAL_CODES for values. Value = 1 is the recommended threshold for valid standard survey sets |
100 | No | No | STATION_ASSIGNMENT | NUMBER | Source for the station assignment. See LL_STA_EVAL_CODES for values. Any value is considered acceptable for valid standard survey sets |
100 | No | No | GEAR_EVALUATION | NUMBER | Evaluation of the condition of the longline gear made at the end of gear hauling. Most commonly tangled sections of mainline, buoy line, and hooks. Tangles could have occurred during gear setting, hauling, or while on bottom. Captured fish could have contributed to the tangle. Tangles observed at haul back do not inherently indicate a reduced fishing capacity. See LL_STA_EVAL_CODES for values. A value < 4 is the recommended threshold for valid standard survey sets |
100 | No | No | GEAR_DAMAGE | NUMBER | Mainline parted during hauling, once or multiple times. In most cases this will not impact fishing capacity, unless there is a loss of some gear, but may increase haul time. See LL_STA_EVAL_CODES for values. A value < 5 is the recommended threshold for valid standard survey sets |
100 | No | No | GEAR_INTERACTION | NUMBER | Any interactions of the survey gear with other fishing gear or other human objects. See LL_STA_EVAL_CODES for values. A value < 4 is the recommended threshold for valid standard survey sets |
100 | No | No | INTERACTION_TYPE | NUMBER | Category for the gear or object with which the survey interacted. See LL_STA_EVAL_CODES for values. |
100 | No | No | ENVIRONMENTAL_CONDITONS | NUMBER | Any conditions or situations related to environmental conditions or biota that might have impacted the survey gear and its capacity to fish consistently. See LL_STA_EVAL_CODES for values. A value < 4 is the recommended threshold for valid standard survey sets |
100 | No | No | DATA_ACQUISITION | NUMBER | Equipment, computer, or other data collection problems that might have contributed to the amount or quality of the data collected. See LL_STA_EVAL_CODES for values. A value < 4 is the recommended threshold for valid standard survey sets |
100 | No | No | SET_NOTES | VARCHAR2 | Comments field for notes related to the deployment of the gear |
100 | No | No | HAUL_NOTES | VARCHAR2 | Comments field for notes related to the hauling of the gear |
100 | No | No | CATCH_NOTES | VARCHAR2 | Comments field for notes related to the catch |
100 | No | No | BOTTOM_VIDEO | NUMBER | Binary indicator of whether a drop camera video was taken at the station: 1 = usable video footage obtained, 0 = no usable video footage obtained |
100 | No | No | WINDDIR | VARCHAR2 | Direction of wind during deployment of gear (degrees). |
100 | No | No | WINDSP | NUMBER | Speed of wind in knots. |
100 | No | No | WAVEHGT | NUMBER | Height of waves (m). |
100 | No | No | SWELLHGT | NUMBER | Swell height (m). |
100 | No | No | VESSEL_NAME | VARCHAR2 | Name of vessel. |
100 | No | No | CURRENT_INSTR_ID1 | VARCHAR2 | Identification code for the current instrument attached to the first end of the longline gear deployed |
100 | No | No | CURRENT_INSTR_ID2 | VARCHAR2 | Identification code for the current instrument attached to the first end of the longline gear deployed |
Attribute Details
Attribute Name | CRUISE |
---|---|
Seq. Order | 1 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Unique numerical code for each cruise. Specific to a vessel and season. Five digits, where first 2 digits indicate vessel, next 2 year, last digit season. For example 24142 = Tenacious II 2014 fall survey or 25151 = Mary Elizabeth 2015 spring survey. If last digit = 3 it is an experimental survey trip |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | STATION |
---|---|
Seq. Order | 2 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 5 |
Scale | 0 |
Status | Active |
Description |
Unique sequential order in which stations have been completed, unique to each cruise code. Failed gear deployments each receive a non-repeated consecutive number. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | STATION_ID |
---|---|
Seq. Order | 3 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A predefined identifier generated during the random station assignment indicating the area where a piece of fishing gear is to be deployed. (Strata coding modified from the SVDBS definition, see SVDBS.UNION_FSCS_SVSTA.STRATUM) Code consists of 3 parts: Stratum number (2bytes) and bottom stratum type (1 bytes). Stratum number refers to strata from the SVDBS offshore stratum group with the numbers defined by depth zone. The third byte refers to the longline survey bottom strata type; 1 = smooth bottom; 0 = rough bottom. The fifth byte (following a dash as the fourth byte) is the number assigned based on the random sequential order drawn within each stratum and bottom type. For example: 270-5 would be the fifth random rough-bottom station drawn in strata 27; 361-1 would be the first random smooth-bottom station drawn in strata 36. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TRIP_ID |
---|---|
Seq. Order | 4 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 20 |
Scale | 0 |
Status | Active |
Description |
Unique trip identifier generated in FLDRS software. Generated to identify each fishing trip from port. Fishing operation data collected using the FLDRS software and initially loaded into FVTR tables, before being migrated to this schema. See FVTR.CRPP_VERS_TRIP |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | EFFORT_NUM |
---|---|
Seq. Order | 5 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 5 |
Scale | 0 |
Status | Active |
Description |
Unique identifier for each fishing effort (gear deployment) within a trip, see FVTR.CRPP_VERS_TRIP |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | STRATUM |
---|---|
Seq. Order | 6 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 5 |
Scale | 0 |
Status | Active |
Description |
A predefined area where the longline gear was deployed. Stratum is a two digit number referring to the stratum number from the SVDBS stratum definition, see SVDBS.UNION_FSCS_SVSTA.STRATUM. All longline strata are taken from the SVDBS offshore stratum group. May be null or differ from ASSIGNED_STRATUM, if more than 50% of the gear was deployed over the boundary into an adjoining stratum. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ASSIGNED_STRATUM |
---|---|
Seq. Order | 7 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 5 |
Scale | 0 |
Status | Active |
Description |
The predefined area where the longline gear was assigned to be deployed. Stratum is a two digit number referring to the stratum number from the SVDBS stratum definition, see SVDBS.UNION_FSCS_SVSTA.STRATUM. All longline strata are taken from the SVDBS offshore stratum group. ASSIGNED STRATUM will match the first two bytes of the STATION_ID code |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BOTTOM_TYPE |
---|---|
Seq. Order | 8 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A bottom type substratification specific to the longline survey. Rough bottom strata were defined as areas above the 70th percentile for Terrain Rugged Index values (Hare at al. 2012) within each stratum. Regions below the 70th percentile cut point were assigned to the smooth-bottom sub-stratum. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | AREA |
---|---|
Seq. Order | 9 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 5 |
Scale | 0 |
Status | Active |
Description |
Standard area code used for commercial data (New England Statistical Area Code) for the position of the beginning of the tow. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BEGIN_SET_TIME |
---|---|
Seq. Order | 10 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Datetime (UTC) when the gear is first placed in the water at the start of the fishing effort |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | END_SET_TIME |
---|---|
Seq. Order | 11 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Datetime (UTC) when setting of the gear has stopped and the gear begins to fish |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BEGIN_HAUL_TIME |
---|---|
Seq. Order | 12 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Datetime (UTC) when fishing stops and hauling the gear starts |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | END_HAUL_TIME |
---|---|
Seq. Order | 13 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Datetime (UTC) when the gear has been completely hauled and is back aboard the vessel |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SOAK_DURATION_DH |
---|---|
Seq. Order | 14 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 7 |
Scale | 4 |
Status | Active |
Description |
Soak or haul duration of the fishing effort (h.hh), from END_SET_TIME until BEGIN_HAUL_TIME |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DECDEG_BEGLAT_SET |
---|---|
Seq. Order | 15 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | 5 |
Status | Active |
Description |
Latitude where the gear is first placed in the water at the start of the fishing effort (ddmm.mmmm) |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DECDEG_BEGLON_SET |
---|---|
Seq. Order | 16 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | 5 |
Status | Active |
Description |
Longitude where the gear is first placed in the water at the start of the fishing effort (dddmm.mmmm) |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DECDEG_ENDLAT_SET |
---|---|
Seq. Order | 17 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | 5 |
Status | Active |
Description |
Latitude where the setting of the gear has stopped and the gear begins to fish (ddmm.mmmm) |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DECDEG_ENDLON_SET |
---|---|
Seq. Order | 18 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | 5 |
Status | Active |
Description |
Longitude where the setting of the gear has stopped and the gear begins to fish (dddmm.mmmm) |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DECDEG_BEGLAT_HAUL |
---|---|
Seq. Order | 19 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | 5 |
Status | Active |
Description |
Latitude where fishing stops and hauling the gear starts (ddmm.mmmm) |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DECDEG_BEGLON_HAUL |
---|---|
Seq. Order | 20 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | 5 |
Status | Active |
Description |
Longitude where fishing stops and hauling the gear starts (dddmm.mmmm) |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DECDEG_ENDLAT_HAUL |
---|---|
Seq. Order | 21 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | 5 |
Status | Active |
Description |
Latitude where the gear has been completely hauled and is back aboard the vessel (ddmm.mmmm) |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DECDEG_ENDLON_HAUL |
---|---|
Seq. Order | 22 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | 5 |
Status | Active |
Description |
Longitude where the gear has been completely hauled and is back aboard the vessel (dddmm.mmmm) |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | STATION_TYPE |
---|---|
Seq. Order | 23 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 1 |
Scale | |
Status | Active |
Description |
Survey station type. See LL_STA_EVAL_CODES for values. Value = 1 is the recommended threshold for valid standard survey sets |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | STATION_ASSIGNMENT |
---|---|
Seq. Order | 24 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 1 |
Scale | |
Status | Active |
Description |
Source for the station assignment. See LL_STA_EVAL_CODES for values. Any value is considered acceptable for valid standard survey sets |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GEAR_EVALUATION |
---|---|
Seq. Order | 25 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 1 |
Scale | |
Status | Active |
Description |
Evaluation of the condition of the longline gear made at the end of gear hauling. Most commonly tangled sections of mainline, buoy line, and hooks. Tangles could have occurred during gear setting, hauling, or while on bottom. Captured fish could have contributed to the tangle. Tangles observed at haul back do not inherently indicate a reduced fishing capacity. See LL_STA_EVAL_CODES for values. A value < 4 is the recommended threshold for valid standard survey sets |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GEAR_DAMAGE |
---|---|
Seq. Order | 26 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 1 |
Scale | |
Status | Active |
Description |
Mainline parted during hauling, once or multiple times. In most cases this will not impact fishing capacity, unless there is a loss of some gear, but may increase haul time. See LL_STA_EVAL_CODES for values. A value < 5 is the recommended threshold for valid standard survey sets |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GEAR_INTERACTION |
---|---|
Seq. Order | 27 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 1 |
Scale | |
Status | Active |
Description |
Any interactions of the survey gear with other fishing gear or other human objects. See LL_STA_EVAL_CODES for values. A value < 4 is the recommended threshold for valid standard survey sets |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | INTERACTION_TYPE |
---|---|
Seq. Order | 28 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 1 |
Scale | |
Status | Active |
Description |
Category for the gear or object with which the survey interacted. See LL_STA_EVAL_CODES for values. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ENVIRONMENTAL_CONDITONS |
---|---|
Seq. Order | 29 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 1 |
Scale | |
Status | Active |
Description |
Any conditions or situations related to environmental conditions or biota that might have impacted the survey gear and its capacity to fish consistently. See LL_STA_EVAL_CODES for values. A value < 4 is the recommended threshold for valid standard survey sets |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DATA_ACQUISITION |
---|---|
Seq. Order | 30 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 1 |
Scale | |
Status | Active |
Description |
Equipment, computer, or other data collection problems that might have contributed to the amount or quality of the data collected. See LL_STA_EVAL_CODES for values. A value < 4 is the recommended threshold for valid standard survey sets |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SET_NOTES |
---|---|
Seq. Order | 31 |
Data Storage Type | VARCHAR2 |
Max Length | 300 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Comments field for notes related to the deployment of the gear |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | HAUL_NOTES |
---|---|
Seq. Order | 32 |
Data Storage Type | VARCHAR2 |
Max Length | 300 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Comments field for notes related to the hauling of the gear |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CATCH_NOTES |
---|---|
Seq. Order | 33 |
Data Storage Type | VARCHAR2 |
Max Length | 300 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Comments field for notes related to the catch |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BOTTOM_VIDEO |
---|---|
Seq. Order | 34 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 1 |
Scale | |
Status | Active |
Description |
Binary indicator of whether a drop camera video was taken at the station: 1 = usable video footage obtained, 0 = no usable video footage obtained |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | WINDDIR |
---|---|
Seq. Order | 35 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Direction of wind during deployment of gear (degrees). |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | WINDSP |
---|---|
Seq. Order | 36 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | 0 |
Status | Active |
Description |
Speed of wind in knots. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | WAVEHGT |
---|---|
Seq. Order | 37 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | 0 |
Status | Active |
Description |
Height of waves (m). |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SWELLHGT |
---|---|
Seq. Order | 38 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | 0 |
Status | Active |
Description |
Swell height (m). |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | VESSEL_NAME |
---|---|
Seq. Order | 39 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of vessel. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CURRENT_INSTR_ID1 |
---|---|
Seq. Order | 40 |
Data Storage Type | VARCHAR2 |
Max Length | 14 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Identification code for the current instrument attached to the first end of the longline gear deployed |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CURRENT_INSTR_ID2 |
---|---|
Seq. Order | 41 |
Data Storage Type | VARCHAR2 |
Max Length | 14 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Identification code for the current instrument attached to the first end of the longline gear deployed |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 35952 |
---|---|
Metadata Record Created By | Patricia L Jones |
Metadata Record Created | 2016-12-13 16:38+0000 |
Metadata Record Last Modified By | SysAdmin InPortAdmin |
» Metadata Record Last Modified | 2022-08-09 17:11+0000 |
Metadata Record Published | 2016-12-13 |
Owner Org | NEFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2016-12-13 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2017-12-13 |
Tags |
---|