Operation Acoustics Fact
Northwest Fisheries Science Center
Entity
(ENT)
| ID: 36426
| Published / External
Created: 2017-01-25
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 18470
ID: 36426
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Operation Acoustics Fact |
---|---|
Short Name | Operation Acoustics Fact |
* Status | Planned |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Operation details from the Integrated acoustic and trawl survey of Pacific hake off the Pacific Coast |
* 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 | Spreadsheet |
---|---|
Active Version? | Y |
Alias | |
Schema Name | PARR |
» Description |
Operation details from the Integrated acoustic and trawl survey of Pacific hake off the Pacific Coast |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | sampling_start_time_dim$second | Number | number of seconds in the minute |
100 | No | No | operation_dim$record_type | Text | operation record or reason record is unavailable |
100 | No | No | area_whid | Number | Warehouse identifier for the INPFC Sub-area where the vessel was at touch down |
100 | No | No | sampling_end_time_dim$military_hour | Number | military representation of the hour |
100 | No | No | vessel | Text | name of the vessel used for the operation |
100 | No | No | sampling_end_time_dim$minute | Number | number of minutes in the hour |
100 | No | No | area_dim$area_name | Text | name of area |
100 | No | No | operation_dim$observer_program | Text | description of the observer program |
100 | No | No | gear_temperature | Number | Taken from the SBE or the FS70 if the SBE is not available |
100 | No | No | area_dim$north_boundary_latitude_whid | Number | north boundary latitude warehouse identifier |
100 | No | No | program | Text | type of fram program |
100 | No | No | performance | Text | performance of the operation |
100 | No | No | operation_dim$fpc_person_whid | Number | person reference for the FPC |
100 | No | No | tow_end_timestamp | Time | operation end date timestamp |
100 | No | No | operation_dim$trip_id | Number | trip identifier number |
100 | No | No | operation_dim$vessel_id | Number | field database vessel id number |
100 | No | No | sampling_end_time_dim$period | Text | period of time |
100 | No | No | equilibrium_latitude_dim$latitude_second_units | Number | numeric representation of latitude that makes up the second unit only |
100 | No | No | equilibrium_latitude_dim$latitude_degree_units | Number | numeric representation of latitude that makes up the degree unit only |
100 | No | No | operation_dim_whid | Number | Warehouse identifier for operation |
100 | No | No | operation_dim$coast_guard_number | Text | Coast Guard documentation number of vessel |
100 | No | No | operation_dim$scientist_4_person_whid | Number | person reference for the fourth scientist |
100 | No | No | average_bottom_depth_whid | Number | Warehouse identifier for average bottom depth |
100 | No | No | sampling_end_time_dim$hour | Number | standard representation of the hour |
100 | No | No | sampling_start_time_whid | Number | Warehouse identifier for the sampling start time |
100 | No | No | sampling_end_time_whid | Number | Warehouse identifier for the sampling end time |
100 | No | No | equilibrium_latitude_dim$record_type | Text | latitude record type or reason record is unavailable |
100 | No | No | average_footrope_depth | Number | Calculated from adding the average headrope depth (from the Net Configuration form or the SBE data) and the average net height (from the Net Configuration form) |
100 | No | No | operation_dim$departure_date_whid | Number | date reference that vessel departed for the defined leg or trip |
100 | No | No | accessory | Text | Concatenated list of accessories used seperated by semicolons |
100 | No | No | operation_dim$captain_person_whid | Number | person reference for the vessel captain |
100 | No | No | operation_dim$ifq_account_number | Text | unique number assigned to user accounts in the Vessel Accounting Database |
100 | No | No | equilibrium_longitude_dim$longitude_degree_units | Number | numeric representation of longitude that makes up the degree unit only |
100 | No | No | operation_dim$state_registration_number | Text | state registration number for the vessel |
100 | No | No | operation_dim$scientist_2_person_whid | Number | person reference for the second scientist |
100 | No | No | distance_fished | Number | Distance (in nm) of the tow from touch down to haul back |
100 | No | No | equilibrium_longitude_whid | Number | Warehouse identifier for equilibrium longitude |
100 | No | No | operation_dim$operation_start_time_whid | Number | start time reference for the operation |
100 | No | No | leg | Number | leg number of the survey |
100 | No | No | average_bottom_depth_dim$depth_meters | Number | depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries) |
100 | No | No | equilibrium_longitude_dim$record_type | Text | longitude record type or reason record is unavailable |
100 | No | No | equilibrium_longitude_dim$longitude_compass_direction | Text | longitude compass direction |
100 | No | No | area_dim$ifq_area_id | Number | IFQ fishing area ID |
100 | No | No | sampling_start_time_dim$military_hour | Number | military representation of the hour |
100 | No | No | operation_dim$field_operation_seg_id | Number | operation segment id reference to the field operational segment table |
100 | No | No | operation_dim$return_date_whid | Number | date reference that vessel returned for the defined leg or trip |
100 | No | No | operation_dim$departure_port_whid | Number | port reference for the departure port |
100 | No | No | haul_weight_kg | Number | Total weight of catch measured in kilograms |
100 | No | No | sampling_start_time_dim$minute | Number | number of minutes in the hour |
100 | No | No | equilibrium_latitude_dim$latitude_compass_direction | Text | latitude compass direction |
100 | No | No | transect_whid | Number | Warehouse identifier for transect |
100 | No | No | operation_dim$operation_end_date_whid | Number | end date reference for the operation |
100 | No | No | operation_dim$return_port_whid | Number | port reference for return port |
100 | No | No | gear | Text | Type of gear used |
100 | No | No | trawl_id | Number | identifier for a sampling operation |
100 | No | No | equilibrium_latitude_dim$latitude_minute_units | Number | numeric representation of latitude that makes up the minute unit only |
100 | No | No | operation_dim$scientist_1_person_whid | Number | person reference for the first scientist |
100 | No | No | equilibrium_longitude_dim$longitude_second_units | Number | numeric representation of longitude that makes up the second unit only |
100 | No | No | sampling_start_hhmmss | Text | concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
100 | No | No | sampling_start_time_dim$record_type | Text | time record or reason record is unavailable |
100 | No | No | equilibrium_latitude_dim$latitude_in_degree_minute_second | Text | string representation of latitude in degrees, minutes, and seconds for example 4525'01" |
100 | No | No | sampling_end_time_dim$second | Number | number of seconds in the minute |
100 | No | No | equilibrium_longitude_dim$longitude_in_degrees | Number | numeric representation of longitude in decimal degrees |
100 | No | No | operation_dim$scientist_3_person_whid | Number | person reference for the third scientist |
100 | No | No | haul_weight_lb | Number | Total weight of catch measured in pounds |
100 | No | No | equilibrium_latitude_dim$named_parallel | Text | name of parallel, boundary, or commonly used geograpical location |
100 | No | No | sampling_start_time_dim$hour | Number | standard representation of the hour |
100 | No | No | area_dim$record_type | Text | area record or reason record is unavailable |
100 | No | No | average_bottom_depth_dim$boundary_indicator | Text | depth boundry indicator identifying ifp boundary marks |
100 | No | No | area_dim$south_boundary_latitude_whid | Number | south boundary latitude warehouse identifier |
100 | No | No | net_touchdown_time | Time | military time representation of the time |
100 | No | No | sampling_end_hhmmss | Text | concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
100 | No | No | average_bottom_depth_dim$depth_fathoms | Number | depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries |
100 | No | No | equilibrium_latitude_whid | Number | Warehouse identifier for equilibrium latitude |
100 | No | No | operation_dim$operation_end_time_whid | Number | end time reference for the operation |
100 | No | No | tow | Number | operation number of the survey |
100 | No | No | average_wireout | Number | Weighted average wireout from touch down to haul back taken from the Net Configuration form |
100 | No | No | sampling_start_time_dim$period | Text | period of time |
100 | No | No | sampling_end_time_dim$record_type | Text | time record or reason record is unavailable |
100 | No | No | project | Text | project name |
100 | No | No | pass | Number | pass number of the survey |
100 | No | No | net_height | Number | Weighted average height from touch down to haul back taken from the Net Configuration form |
100 | No | No | operation_dim$limited_entry_permit_number | Text | federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California |
100 | No | No | operation_dim$operation_start_date_whid | Number | start date reference for the operation |
100 | No | No | equilibrium_latitude_dim$latitude_in_degrees | Number | numeric representation of latitude in degrees |
100 | No | No | duration | Number | Time duration of the tow from touch down to haul back |
100 | No | No | net_liftoff_time | Time | military time representation of the time |
100 | No | No | average_bottom_depth_dim$record_type | Text | depth record or reason record is unavailable |
100 | No | No | tow_start_timestamp | Time | operation start date timestamp |
100 | No | No | equilibrium_longitude_dim$longitude_in_degree_minute_second | Text | string representation of longitude in degrees, minutes, and seconds for example 4525'01" |
100 | No | No | year | Number | operation year |
100 | No | No | equilibrium_longitude_dim$longitude_minute_units | Number | numeric representation of longitude that makes up the minute unit only |
100 | No | No | operation_dim$operation_type | Text | type of operation |
Attribute Details
Attribute Name | sampling_start_time_dim$second |
---|---|
Seq. Order | 1 |
Data Storage Type | Number |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
number of seconds in the minute |
General Data Type | Number |
Unit of Measure | sec |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-60 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$record_type |
---|---|
Seq. Order | 2 |
Data Storage Type | Text |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
operation record or reason record is unavailable |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Operation, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | area_whid |
---|---|
Seq. Order | 3 |
Data Storage Type | Number |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for the INPFC Sub-area where the vessel was at touch down |
General Data Type | Number |
Unit of Measure | whid |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_end_time_dim$military_hour |
---|---|
Seq. Order | 4 |
Data Storage Type | Number |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
military representation of the hour |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-24 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel |
---|---|
Seq. Order | 5 |
Data Storage Type | Text |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
name of the vessel used for the operation |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Aggressor, Amy Lynn, BJ Thomas, Blue Horizon, Captain Jack, Coast Pride, Excalibur, Last Straw, Limit Stalker, Mirage, Miss Leona, Morning Star, Ms. Julie, Noahs Ark, Pacific Sun IV, Raven, Sea Eagle, Toronado |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_end_time_dim$minute |
---|---|
Seq. Order | 6 |
Data Storage Type | Number |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
number of minutes in the hour |
General Data Type | Number |
Unit of Measure | min |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-60 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | area_dim$area_name |
---|---|
Seq. Order | 7 |
Data Storage Type | Text |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
name of area |
General Data Type | Text |
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 | operation_dim$observer_program |
---|---|
Seq. Order | 8 |
Data Storage Type | Text |
Max Length | 150 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
description of the observer program |
General Data Type | Text |
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_temperature |
---|---|
Seq. Order | 9 |
Data Storage Type | Number |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 9 |
Scale | |
Status | Active |
Description |
Taken from the SBE or the FS70 if the SBE is not available |
General Data Type | Number |
Unit of Measure | temperature |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | area_dim$north_boundary_latitude_whid |
---|---|
Seq. Order | 10 |
Data Storage Type | Number |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
north boundary latitude warehouse identifier |
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 | program |
---|---|
Seq. Order | 11 |
Data Storage Type | Text |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
type of fram program |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Bottom Trawl, Hook and Line |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | performance |
---|---|
Seq. Order | 12 |
Data Storage Type | Text |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
performance of the operation |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Insufficient Information, Indeterminate, Satisfactory, Trawlable, Untrawlable, Unsatisfactory, [null] |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$fpc_person_whid |
---|---|
Seq. Order | 13 |
Data Storage Type | Number |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
person reference for the FPC |
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 | tow_end_timestamp |
---|---|
Seq. Order | 14 |
Data Storage Type | Time |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
operation end date timestamp |
General Data Type | Time |
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 | operation_dim$trip_id |
---|---|
Seq. Order | 15 |
Data Storage Type | Number |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
trip identifier 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 | operation_dim$vessel_id |
---|---|
Seq. Order | 16 |
Data Storage Type | Number |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
field database vessel id 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 | sampling_end_time_dim$period |
---|---|
Seq. Order | 17 |
Data Storage Type | Text |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
period of time |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | AM, PM |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | equilibrium_latitude_dim$latitude_second_units |
---|---|
Seq. Order | 18 |
Data Storage Type | Number |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of latitude that makes up the second unit only |
General Data Type | Number |
Unit of Measure | sec |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-60 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | equilibrium_latitude_dim$latitude_degree_units |
---|---|
Seq. Order | 19 |
Data Storage Type | Number |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of latitude that makes up the degree unit only |
General Data Type | Number |
Unit of Measure | deg |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -90 to 90 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim_whid |
---|---|
Seq. Order | 20 |
Data Storage Type | Number |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for operation |
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 | operation_dim$coast_guard_number |
---|---|
Seq. Order | 21 |
Data Storage Type | Text |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Coast Guard documentation number of vessel |
General Data Type | Text |
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 | operation_dim$scientist_4_person_whid |
---|---|
Seq. Order | 22 |
Data Storage Type | Number |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
person reference for the fourth scientist |
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 | average_bottom_depth_whid |
---|---|
Seq. Order | 23 |
Data Storage Type | Number |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for average bottom depth |
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 | sampling_end_time_dim$hour |
---|---|
Seq. Order | 24 |
Data Storage Type | Number |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
standard representation of the hour |
General Data Type | Number |
Unit of Measure | hr |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-12 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_start_time_whid |
---|---|
Seq. Order | 25 |
Data Storage Type | Number |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for the sampling start 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 | sampling_end_time_whid |
---|---|
Seq. Order | 26 |
Data Storage Type | Number |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for the sampling end 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 | equilibrium_latitude_dim$record_type |
---|---|
Seq. Order | 27 |
Data Storage Type | Text |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
latitude record type or reason record is unavailable |
General Data Type | Text |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | average_footrope_depth |
---|---|
Seq. Order | 28 |
Data Storage Type | Number |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 6 |
Scale | |
Status | Active |
Description |
Calculated from adding the average headrope depth (from the Net Configuration form or the SBE data) and the average net height (from the Net Configuration form) |
General Data Type | Number |
Unit of Measure | depth |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$departure_date_whid |
---|---|
Seq. Order | 29 |
Data Storage Type | Number |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
date reference that vessel departed for the defined leg or 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 | accessory |
---|---|
Seq. Order | 30 |
Data Storage Type | Text |
Max Length | 80 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Concatenated list of accessories used seperated by semicolons |
General Data Type | Text |
Unit of Measure | accessory |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$captain_person_whid |
---|---|
Seq. Order | 31 |
Data Storage Type | Number |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
person reference for the vessel captain |
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 | operation_dim$ifq_account_number |
---|---|
Seq. Order | 32 |
Data Storage Type | Text |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
unique number assigned to user accounts in the Vessel Accounting Database |
General Data Type | Text |
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 | equilibrium_longitude_dim$longitude_degree_units |
---|---|
Seq. Order | 33 |
Data Storage Type | Number |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of longitude that makes up the degree unit only |
General Data Type | Number |
Unit of Measure | deg |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -180 to 180 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$state_registration_number |
---|---|
Seq. Order | 34 |
Data Storage Type | Text |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
state registration number for the vessel |
General Data Type | Text |
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 | operation_dim$scientist_2_person_whid |
---|---|
Seq. Order | 35 |
Data Storage Type | Number |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
person reference for the second scientist |
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 | distance_fished |
---|---|
Seq. Order | 36 |
Data Storage Type | Number |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
Status | Active |
Description |
Distance (in nm) of the tow from touch down to haul back |
General Data Type | Number |
Unit of Measure | fished |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | equilibrium_longitude_whid |
---|---|
Seq. Order | 37 |
Data Storage Type | Number |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for equilibrium longitude |
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 | operation_dim$operation_start_time_whid |
---|---|
Seq. Order | 38 |
Data Storage Type | Number |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
start time reference for the operation |
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 | leg |
---|---|
Seq. Order | 39 |
Data Storage Type | Number |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
leg number of the survey |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1,2,3,4,5,6,7,8 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | average_bottom_depth_dim$depth_meters |
---|---|
Seq. Order | 40 |
Data Storage Type | Number |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
Status | Active |
Description |
depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries) |
General Data Type | Number |
Unit of Measure | m |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-1500 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | equilibrium_longitude_dim$record_type |
---|---|
Seq. Order | 41 |
Data Storage Type | Text |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
longitude record type or reason record is unavailable |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Longitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | equilibrium_longitude_dim$longitude_compass_direction |
---|---|
Seq. Order | 42 |
Data Storage Type | Text |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
longitude compass direction |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | E, W |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | area_dim$ifq_area_id |
---|---|
Seq. Order | 43 |
Data Storage Type | Number |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
IFQ fishing area ID |
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 | sampling_start_time_dim$military_hour |
---|---|
Seq. Order | 44 |
Data Storage Type | Number |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
military representation of the hour |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-24 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$field_operation_seg_id |
---|---|
Seq. Order | 45 |
Data Storage Type | Number |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
operation segment id reference to the field operational segment table |
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 | operation_dim$return_date_whid |
---|---|
Seq. Order | 46 |
Data Storage Type | Number |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
date reference that vessel returned for the defined leg or 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 | operation_dim$departure_port_whid |
---|---|
Seq. Order | 47 |
Data Storage Type | Number |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
port reference for the departure port |
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 | haul_weight_kg |
---|---|
Seq. Order | 48 |
Data Storage Type | Number |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
Status | Active |
Description |
Total weight of catch measured in kilograms |
General Data Type | Number |
Unit of Measure | kg |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_start_time_dim$minute |
---|---|
Seq. Order | 49 |
Data Storage Type | Number |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
number of minutes in the hour |
General Data Type | Number |
Unit of Measure | min |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-60 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | equilibrium_latitude_dim$latitude_compass_direction |
---|---|
Seq. Order | 50 |
Data Storage Type | Text |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
latitude compass direction |
General Data Type | Text |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | N, S |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | transect_whid |
---|---|
Seq. Order | 51 |
Data Storage Type | Number |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for transect |
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 | operation_dim$operation_end_date_whid |
---|---|
Seq. Order | 52 |
Data Storage Type | Number |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
end date reference for the operation |
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 | operation_dim$return_port_whid |
---|---|
Seq. Order | 53 |
Data Storage Type | Number |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
port reference for return port |
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 |
---|---|
Seq. Order | 54 |
Data Storage Type | Text |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Type of gear used |
General Data Type | Text |
Unit of Measure | gear |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | trawl_id |
---|---|
Seq. Order | 55 |
Data Storage Type | Number |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
identifier for a sampling operation |
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 | equilibrium_latitude_dim$latitude_minute_units |
---|---|
Seq. Order | 56 |
Data Storage Type | Number |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of latitude that makes up the minute unit only |
General Data Type | Number |
Unit of Measure | min |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-60 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$scientist_1_person_whid |
---|---|
Seq. Order | 57 |
Data Storage Type | Number |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
person reference for the first scientist |
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 | equilibrium_longitude_dim$longitude_second_units |
---|---|
Seq. Order | 58 |
Data Storage Type | Number |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of longitude that makes up the second unit only |
General Data Type | Number |
Unit of Measure | sec |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-59 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_start_hhmmss |
---|---|
Seq. Order | 59 |
Data Storage Type | Text |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
General Data Type | Text |
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 | sampling_start_time_dim$record_type |
---|---|
Seq. Order | 60 |
Data Storage Type | Text |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
time record or reason record is unavailable |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | equilibrium_latitude_dim$latitude_in_degree_minute_second |
---|---|
Seq. Order | 61 |
Data Storage Type | Text |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
string representation of latitude in degrees, minutes, and seconds for example 4525'01" |
General Data Type | Text |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_end_time_dim$second |
---|---|
Seq. Order | 62 |
Data Storage Type | Number |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
number of seconds in the minute |
General Data Type | Number |
Unit of Measure | sec |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-60 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | equilibrium_longitude_dim$longitude_in_degrees |
---|---|
Seq. Order | 63 |
Data Storage Type | Number |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
numeric representation of longitude in decimal degrees |
General Data Type | Number |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -180 to 180 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$scientist_3_person_whid |
---|---|
Seq. Order | 64 |
Data Storage Type | Number |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
person reference for the third scientist |
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 | haul_weight_lb |
---|---|
Seq. Order | 65 |
Data Storage Type | Number |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
Status | Active |
Description |
Total weight of catch measured in pounds |
General Data Type | Number |
Unit of Measure | lb |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | equilibrium_latitude_dim$named_parallel |
---|---|
Seq. Order | 66 |
Data Storage Type | Text |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
name of parallel, boundary, or commonly used geograpical location |
General Data Type | Text |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_start_time_dim$hour |
---|---|
Seq. Order | 67 |
Data Storage Type | Number |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
standard representation of the hour |
General Data Type | Number |
Unit of Measure | hr |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-12 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | area_dim$record_type |
---|---|
Seq. Order | 68 |
Data Storage Type | Text |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
area record or reason record is unavailable |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Area, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Defined |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | average_bottom_depth_dim$boundary_indicator |
---|---|
Seq. Order | 69 |
Data Storage Type | Text |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
depth boundry indicator identifying ifp boundary marks |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | IFP Boundary Depth, Standard Contour Depth, NA |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | area_dim$south_boundary_latitude_whid |
---|---|
Seq. Order | 70 |
Data Storage Type | Number |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
south boundary latitude warehouse identifier |
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 | net_touchdown_time |
---|---|
Seq. Order | 71 |
Data Storage Type | Time |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
military time representation of the time |
General Data Type | Time |
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 | sampling_end_hhmmss |
---|---|
Seq. Order | 72 |
Data Storage Type | Text |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
General Data Type | Text |
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 | average_bottom_depth_dim$depth_fathoms |
---|---|
Seq. Order | 73 |
Data Storage Type | Number |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
Status | Active |
Description |
depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries |
General Data Type | Number |
Unit of Measure | fth |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | equilibrium_latitude_whid |
---|---|
Seq. Order | 74 |
Data Storage Type | Number |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for equilibrium latitude |
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 | operation_dim$operation_end_time_whid |
---|---|
Seq. Order | 75 |
Data Storage Type | Number |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
end time reference for the operation |
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 | tow |
---|---|
Seq. Order | 76 |
Data Storage Type | Number |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
operation number of the survey |
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 | average_wireout |
---|---|
Seq. Order | 77 |
Data Storage Type | Number |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 7 |
Scale | |
Status | Active |
Description |
Weighted average wireout from touch down to haul back taken from the Net Configuration form |
General Data Type | Number |
Unit of Measure | wireout |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_start_time_dim$period |
---|---|
Seq. Order | 78 |
Data Storage Type | Text |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
period of time |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | AM, PM |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_end_time_dim$record_type |
---|---|
Seq. Order | 79 |
Data Storage Type | Text |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
time record or reason record is unavailable |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | project |
---|---|
Seq. Order | 80 |
Data Storage Type | Text |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
project name |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Groundfish Shelf Survey, Groundfish Slope and Shelf Combination Survery, Groundfish Slope Survey, Groundfish Triennial Shelf Survery, Hypoxia Study, Santa Barbara Basin Study, Shelf Rockfish [2004-2015], Video Study |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | pass |
---|---|
Seq. Order | 81 |
Data Storage Type | Number |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
pass number of the survey |
General Data Type | Number |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1,2,3,4 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | net_height |
---|---|
Seq. Order | 82 |
Data Storage Type | Number |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 7 |
Scale | |
Status | Active |
Description |
Weighted average height from touch down to haul back taken from the Net Configuration form |
General Data Type | Number |
Unit of Measure | height |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$limited_entry_permit_number |
---|---|
Seq. Order | 83 |
Data Storage Type | Text |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California |
General Data Type | Text |
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 | operation_dim$operation_start_date_whid |
---|---|
Seq. Order | 84 |
Data Storage Type | Number |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
start date reference for the operation |
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 | equilibrium_latitude_dim$latitude_in_degrees |
---|---|
Seq. Order | 85 |
Data Storage Type | Number |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
numeric representation of latitude in degrees |
General Data Type | Number |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -90 to 90 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | duration |
---|---|
Seq. Order | 86 |
Data Storage Type | Number |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
Status | Active |
Description |
Time duration of the tow from touch down to haul back |
General Data Type | Number |
Unit of Measure | duration |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | net_liftoff_time |
---|---|
Seq. Order | 87 |
Data Storage Type | Time |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
military time representation of the time |
General Data Type | Time |
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 | average_bottom_depth_dim$record_type |
---|---|
Seq. Order | 88 |
Data Storage Type | Text |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
depth record or reason record is unavailable |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Depth, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | tow_start_timestamp |
---|---|
Seq. Order | 89 |
Data Storage Type | Time |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
operation start date timestamp |
General Data Type | Time |
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 | equilibrium_longitude_dim$longitude_in_degree_minute_second |
---|---|
Seq. Order | 90 |
Data Storage Type | Text |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
string representation of longitude in degrees, minutes, and seconds for example 4525'01" |
General Data Type | Text |
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 | year |
---|---|
Seq. Order | 91 |
Data Storage Type | Number |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
operation year |
General Data Type | Number |
Unit of Measure | year |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 2007+ |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | equilibrium_longitude_dim$longitude_minute_units |
---|---|
Seq. Order | 92 |
Data Storage Type | Number |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of longitude that makes up the minute unit only |
General Data Type | Number |
Unit of Measure | min |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-59 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$operation_type |
---|---|
Seq. Order | 93 |
Data Storage Type | Text |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
type of operation |
General Data Type | Text |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | CTD Cast, Drop, Experiment, Search, Trawl, VPR Tow, [null] |
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 | 36426 |
---|---|
Metadata Record Created By | Jeffrey W Cowen |
Metadata Record Created | 2017-01-25 10:28+0000 |
Metadata Record Last Modified By | SysAdmin InPortAdmin |
» Metadata Record Last Modified | 2022-08-09 17:11+0000 |
Metadata Record Published | 2017-03-03 |
Owner Org | NWFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2017-03-03 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2018-03-03 |
Tags |
---|