Operation Acoustics Fact
Entity (ENT) | Northwest Fisheries Science Center (NWFSC)GUID: gov.noaa.nmfs.inport:36426 | Updated: August 9, 2022 | Published / External
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
sampling_start_time_dim$second | Number | number of seconds in the minute | |
|
100
|
operation_dim$record_type | Text | operation record or reason record is unavailable | |
|
100
|
area_whid | Number | Warehouse identifier for the INPFC Sub-area where the vessel was at touch down | |
|
100
|
sampling_end_time_dim$military_hour | Number | military representation of the hour | |
|
100
|
vessel | Text | name of the vessel used for the operation | |
|
100
|
sampling_end_time_dim$minute | Number | number of minutes in the hour | |
|
100
|
area_dim$area_name | Text | name of area | |
|
100
|
operation_dim$observer_program | Text | description of the observer program | |
|
100
|
gear_temperature | Number | Taken from the SBE or the FS70 if the SBE is not available | |
|
100
|
area_dim$north_boundary_latitude_whid | Number | north boundary latitude warehouse identifier | |
|
100
|
program | Text | type of fram program | |
|
100
|
performance | Text | performance of the operation | |
|
100
|
operation_dim$fpc_person_whid | Number | person reference for the FPC | |
|
100
|
tow_end_timestamp | Time | operation end date timestamp | |
|
100
|
operation_dim$trip_id | Number | trip identifier number | |
|
100
|
operation_dim$vessel_id | Number | field database vessel id number | |
|
100
|
sampling_end_time_dim$period | Text | period of time | |
|
100
|
equilibrium_latitude_dim$latitude_second_units | Number | numeric representation of latitude that makes up the second unit only | |
|
100
|
equilibrium_latitude_dim$latitude_degree_units | Number | numeric representation of latitude that makes up the degree unit only | |
|
100
|
operation_dim_whid | Number | Warehouse identifier for operation | |
|
100
|
operation_dim$coast_guard_number | Text | Coast Guard documentation number of vessel | |
|
100
|
operation_dim$scientist_4_person_whid | Number | person reference for the fourth scientist | |
|
100
|
average_bottom_depth_whid | Number | Warehouse identifier for average bottom depth | |
|
100
|
sampling_end_time_dim$hour | Number | standard representation of the hour | |
|
100
|
sampling_start_time_whid | Number | Warehouse identifier for the sampling start time | |
|
100
|
sampling_end_time_whid | Number | Warehouse identifier for the sampling end time | |
|
100
|
equilibrium_latitude_dim$record_type | Text | latitude record type or reason record is unavailable | |
|
100
|
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
|
operation_dim$departure_date_whid | Number | date reference that vessel departed for the defined leg or trip | |
|
100
|
accessory | Text | Concatenated list of accessories used seperated by semicolons | |
|
100
|
operation_dim$captain_person_whid | Number | person reference for the vessel captain | |
|
100
|
operation_dim$ifq_account_number | Text | unique number assigned to user accounts in the Vessel Accounting Database | |
|
100
|
equilibrium_longitude_dim$longitude_degree_units | Number | numeric representation of longitude that makes up the degree unit only | |
|
100
|
operation_dim$state_registration_number | Text | state registration number for the vessel | |
|
100
|
operation_dim$scientist_2_person_whid | Number | person reference for the second scientist | |
|
100
|
distance_fished | Number | Distance (in nm) of the tow from touch down to haul back | |
|
100
|
equilibrium_longitude_whid | Number | Warehouse identifier for equilibrium longitude | |
|
100
|
operation_dim$operation_start_time_whid | Number | start time reference for the operation | |
|
100
|
leg | Number | leg number of the survey | |
|
100
|
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
|
equilibrium_longitude_dim$record_type | Text | longitude record type or reason record is unavailable | |
|
100
|
equilibrium_longitude_dim$longitude_compass_direction | Text | longitude compass direction | |
|
100
|
area_dim$ifq_area_id | Number | IFQ fishing area ID | |
|
100
|
sampling_start_time_dim$military_hour | Number | military representation of the hour | |
|
100
|
operation_dim$field_operation_seg_id | Number | operation segment id reference to the field operational segment table | |
|
100
|
operation_dim$return_date_whid | Number | date reference that vessel returned for the defined leg or trip | |
|
100
|
operation_dim$departure_port_whid | Number | port reference for the departure port | |
|
100
|
haul_weight_kg | Number | Total weight of catch measured in kilograms | |
|
100
|
sampling_start_time_dim$minute | Number | number of minutes in the hour | |
|
100
|
equilibrium_latitude_dim$latitude_compass_direction | Text | latitude compass direction | |
|
100
|
transect_whid | Number | Warehouse identifier for transect | |
|
100
|
operation_dim$operation_end_date_whid | Number | end date reference for the operation | |
|
100
|
operation_dim$return_port_whid | Number | port reference for return port | |
|
100
|
gear | Text | Type of gear used | |
|
100
|
trawl_id | Number | identifier for a sampling operation | |
|
100
|
equilibrium_latitude_dim$latitude_minute_units | Number | numeric representation of latitude that makes up the minute unit only | |
|
100
|
operation_dim$scientist_1_person_whid | Number | person reference for the first scientist | |
|
100
|
equilibrium_longitude_dim$longitude_second_units | Number | numeric representation of longitude that makes up the second unit only | |
|
100
|
sampling_start_hhmmss | Text | concatenation of military hour, minute, second, example 230415 equates to 23:04:15 | |
|
100
|
sampling_start_time_dim$record_type | Text | time record or reason record is unavailable | |
|
100
|
equilibrium_latitude_dim$latitude_in_degree_minute_second | Text | string representation of latitude in degrees, minutes, and seconds for example 4525'01" | |
|
100
|
sampling_end_time_dim$second | Number | number of seconds in the minute | |
|
100
|
equilibrium_longitude_dim$longitude_in_degrees | Number | numeric representation of longitude in decimal degrees | |
|
100
|
operation_dim$scientist_3_person_whid | Number | person reference for the third scientist | |
|
100
|
haul_weight_lb | Number | Total weight of catch measured in pounds | |
|
100
|
equilibrium_latitude_dim$named_parallel | Text | name of parallel, boundary, or commonly used geograpical location | |
|
100
|
sampling_start_time_dim$hour | Number | standard representation of the hour | |
|
100
|
area_dim$record_type | Text | area record or reason record is unavailable | |
|
100
|
average_bottom_depth_dim$boundary_indicator | Text | depth boundry indicator identifying ifp boundary marks | |
|
100
|
area_dim$south_boundary_latitude_whid | Number | south boundary latitude warehouse identifier | |
|
100
|
net_touchdown_time | Time | military time representation of the time | |
|
100
|
sampling_end_hhmmss | Text | concatenation of military hour, minute, second, example 230415 equates to 23:04:15 | |
|
100
|
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
|
equilibrium_latitude_whid | Number | Warehouse identifier for equilibrium latitude | |
|
100
|
operation_dim$operation_end_time_whid | Number | end time reference for the operation | |
|
100
|
tow | Number | operation number of the survey | |
|
100
|
average_wireout | Number | Weighted average wireout from touch down to haul back taken from the Net Configuration form | |
|
100
|
sampling_start_time_dim$period | Text | period of time | |
|
100
|
sampling_end_time_dim$record_type | Text | time record or reason record is unavailable | |
|
100
|
project | Text | project name | |
|
100
|
pass | Number | pass number of the survey | |
|
100
|
net_height | Number | Weighted average height from touch down to haul back taken from the Net Configuration form | |
|
100
|
operation_dim$limited_entry_permit_number | Text | federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California | |
|
100
|
operation_dim$operation_start_date_whid | Number | start date reference for the operation | |
|
100
|
equilibrium_latitude_dim$latitude_in_degrees | Number | numeric representation of latitude in degrees | |
|
100
|
duration | Number | Time duration of the tow from touch down to haul back | |
|
100
|
net_liftoff_time | Time | military time representation of the time | |
|
100
|
average_bottom_depth_dim$record_type | Text | depth record or reason record is unavailable | |
|
100
|
tow_start_timestamp | Time | operation start date timestamp | |
|
100
|
equilibrium_longitude_dim$longitude_in_degree_minute_second | Text | string representation of longitude in degrees, minutes, and seconds for example 4525'01" | |
|
100
|
year | Number | operation year | |
|
100
|
equilibrium_longitude_dim$longitude_minute_units | Number | numeric representation of longitude that makes up the minute unit only | |
|
100
|
operation_dim$operation_type | Text | type of operation |
Attribute Details
sampling_start_time_dim$second
CC ID: 385412
| Seq. Order: | 1 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
number of seconds in the minute |
| General Data Type: | Number |
| Unit of Measure: | sec |
| Allowed Values: | 0-60 |
operation_dim$record_type
CC ID: 385413
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | Text |
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
operation record or reason record is unavailable |
| General Data Type: | Text |
| Allowed Values: | Operation, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
area_whid
CC ID: 385414
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| 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 |
sampling_end_time_dim$military_hour
CC ID: 385415
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
military representation of the hour |
| General Data Type: | Number |
| Allowed Values: | 0-24 |
vessel
CC ID: 385416
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | Text |
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
name of the vessel used for the operation |
| General Data Type: | Text |
| 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 |
sampling_end_time_dim$minute
CC ID: 385417
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
number of minutes in the hour |
| General Data Type: | Number |
| Unit of Measure: | min |
| Allowed Values: | 0-60 |
area_dim$area_name
CC ID: 385418
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | Text |
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
name of area |
| General Data Type: | Text |
operation_dim$observer_program
CC ID: 385419
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | Text |
| Max Length: | 150 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
description of the observer program |
| General Data Type: | Text |
gear_temperature
CC ID: 385420
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Precision: | 9 |
| Status: | Active |
| Description: |
Taken from the SBE or the FS70 if the SBE is not available |
| General Data Type: | Number |
| Unit of Measure: | temperature |
area_dim$north_boundary_latitude_whid
CC ID: 385421
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
north boundary latitude warehouse identifier |
| General Data Type: | Number |
program
CC ID: 385422
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | Text |
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
type of fram program |
| General Data Type: | Text |
| Allowed Values: | Bottom Trawl, Hook and Line |
performance
CC ID: 385423
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | Text |
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
performance of the operation |
| General Data Type: | Text |
| Allowed Values: | Insufficient Information, Indeterminate, Satisfactory, Trawlable, Untrawlable, Unsatisfactory, [null] |
operation_dim$fpc_person_whid
CC ID: 385424
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
person reference for the FPC |
| General Data Type: | Number |
tow_end_timestamp
CC ID: 385425
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | Time |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
operation end date timestamp |
| General Data Type: | Time |
operation_dim$trip_id
CC ID: 385426
| Seq. Order: | 15 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
trip identifier number |
| General Data Type: | Number |
operation_dim$vessel_id
CC ID: 385427
| Seq. Order: | 16 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
field database vessel id number |
| General Data Type: | Number |
sampling_end_time_dim$period
CC ID: 385428
| Seq. Order: | 17 |
|---|---|
| Data Storage Type: | Text |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
period of time |
| General Data Type: | Text |
| Allowed Values: | AM, PM |
equilibrium_latitude_dim$latitude_second_units
CC ID: 385429
| Seq. Order: | 18 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of latitude that makes up the second unit only |
| General Data Type: | Number |
| Unit of Measure: | sec |
| Allowed Values: | 0-60 |
equilibrium_latitude_dim$latitude_degree_units
CC ID: 385430
| Seq. Order: | 19 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of latitude that makes up the degree unit only |
| General Data Type: | Number |
| Unit of Measure: | deg |
| Allowed Values: | -90 to 90 |
operation_dim_whid
CC ID: 385431
| Seq. Order: | 20 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for operation |
| General Data Type: | Number |
operation_dim$coast_guard_number
CC ID: 385432
| Seq. Order: | 21 |
|---|---|
| Data Storage Type: | Text |
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Coast Guard documentation number of vessel |
| General Data Type: | Text |
operation_dim$scientist_4_person_whid
CC ID: 385433
| Seq. Order: | 22 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
person reference for the fourth scientist |
| General Data Type: | Number |
average_bottom_depth_whid
CC ID: 385434
| Seq. Order: | 23 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for average bottom depth |
| General Data Type: | Number |
sampling_end_time_dim$hour
CC ID: 385435
| Seq. Order: | 24 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
standard representation of the hour |
| General Data Type: | Number |
| Unit of Measure: | hr |
| Allowed Values: | 0-12 |
sampling_start_time_whid
CC ID: 385436
| Seq. Order: | 25 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for the sampling start time |
| General Data Type: | Number |
sampling_end_time_whid
CC ID: 385437
| Seq. Order: | 26 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for the sampling end time |
| General Data Type: | Number |
equilibrium_latitude_dim$record_type
CC ID: 385438
| Seq. Order: | 27 |
|---|---|
| Data Storage Type: | Text |
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
latitude record type or reason record is unavailable |
| General Data Type: | Text |
| Unit of Measure: | NA |
| Allowed Values: | Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
average_footrope_depth
CC ID: 385439
| Seq. Order: | 28 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| 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 |
operation_dim$departure_date_whid
CC ID: 385440
| Seq. Order: | 29 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
date reference that vessel departed for the defined leg or trip |
| General Data Type: | Number |
accessory
CC ID: 385441
| Seq. Order: | 30 |
|---|---|
| Data Storage Type: | Text |
| Max Length: | 80 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Concatenated list of accessories used seperated by semicolons |
| General Data Type: | Text |
| Unit of Measure: | accessory |
operation_dim$captain_person_whid
CC ID: 385442
| Seq. Order: | 31 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
person reference for the vessel captain |
| General Data Type: | Number |
operation_dim$ifq_account_number
CC ID: 385443
| Seq. Order: | 32 |
|---|---|
| Data Storage Type: | Text |
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
unique number assigned to user accounts in the Vessel Accounting Database |
| General Data Type: | Text |
equilibrium_longitude_dim$longitude_degree_units
CC ID: 385444
| Seq. Order: | 33 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of longitude that makes up the degree unit only |
| General Data Type: | Number |
| Unit of Measure: | deg |
| Allowed Values: | -180 to 180 |
operation_dim$state_registration_number
CC ID: 385445
| Seq. Order: | 34 |
|---|---|
| Data Storage Type: | Text |
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
state registration number for the vessel |
| General Data Type: | Text |
operation_dim$scientist_2_person_whid
CC ID: 385446
| Seq. Order: | 35 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
person reference for the second scientist |
| General Data Type: | Number |
distance_fished
CC ID: 385447
| Seq. Order: | 36 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Status: | Active |
| Description: |
Distance (in nm) of the tow from touch down to haul back |
| General Data Type: | Number |
| Unit of Measure: | fished |
equilibrium_longitude_whid
CC ID: 385448
| Seq. Order: | 37 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for equilibrium longitude |
| General Data Type: | Number |
operation_dim$operation_start_time_whid
CC ID: 385449
| Seq. Order: | 38 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
start time reference for the operation |
| General Data Type: | Number |
leg
CC ID: 385450
| Seq. Order: | 39 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
leg number of the survey |
| General Data Type: | Number |
| Allowed Values: | 1,2,3,4,5,6,7,8 |
average_bottom_depth_dim$depth_meters
CC ID: 385451
| Seq. Order: | 40 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| 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 |
| Allowed Values: | 0-1500 |
equilibrium_longitude_dim$record_type
CC ID: 385452
| Seq. Order: | 41 |
|---|---|
| Data Storage Type: | Text |
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
longitude record type or reason record is unavailable |
| General Data Type: | Text |
| Allowed Values: | Longitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
equilibrium_longitude_dim$longitude_compass_direction
CC ID: 385453
| Seq. Order: | 42 |
|---|---|
| Data Storage Type: | Text |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
longitude compass direction |
| General Data Type: | Text |
| Allowed Values: | E, W |
area_dim$ifq_area_id
CC ID: 385454
| Seq. Order: | 43 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
IFQ fishing area ID |
| General Data Type: | Number |
sampling_start_time_dim$military_hour
CC ID: 385455
| Seq. Order: | 44 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
military representation of the hour |
| General Data Type: | Number |
| Allowed Values: | 0-24 |
operation_dim$field_operation_seg_id
CC ID: 385456
| Seq. Order: | 45 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
operation segment id reference to the field operational segment table |
| General Data Type: | Number |
operation_dim$return_date_whid
CC ID: 385457
| Seq. Order: | 46 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
date reference that vessel returned for the defined leg or trip |
| General Data Type: | Number |
operation_dim$departure_port_whid
CC ID: 385458
| Seq. Order: | 47 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
port reference for the departure port |
| General Data Type: | Number |
haul_weight_kg
CC ID: 385459
| Seq. Order: | 48 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Status: | Active |
| Description: |
Total weight of catch measured in kilograms |
| General Data Type: | Number |
| Unit of Measure: | kg |
sampling_start_time_dim$minute
CC ID: 385460
| Seq. Order: | 49 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
number of minutes in the hour |
| General Data Type: | Number |
| Unit of Measure: | min |
| Allowed Values: | 0-60 |
equilibrium_latitude_dim$latitude_compass_direction
CC ID: 385461
| Seq. Order: | 50 |
|---|---|
| Data Storage Type: | Text |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
latitude compass direction |
| General Data Type: | Text |
| Unit of Measure: | NA |
| Allowed Values: | N, S |
transect_whid
CC ID: 385462
| Seq. Order: | 51 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for transect |
| General Data Type: | Number |
operation_dim$operation_end_date_whid
CC ID: 385463
| Seq. Order: | 52 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
end date reference for the operation |
| General Data Type: | Number |
operation_dim$return_port_whid
CC ID: 385464
| Seq. Order: | 53 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
port reference for return port |
| General Data Type: | Number |
gear
CC ID: 385465
| Seq. Order: | 54 |
|---|---|
| Data Storage Type: | Text |
| Max Length: | 40 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Type of gear used |
| General Data Type: | Text |
| Unit of Measure: | gear |
trawl_id
CC ID: 385466
| Seq. Order: | 55 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
identifier for a sampling operation |
| General Data Type: | Number |
equilibrium_latitude_dim$latitude_minute_units
CC ID: 385467
| Seq. Order: | 56 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of latitude that makes up the minute unit only |
| General Data Type: | Number |
| Unit of Measure: | min |
| Allowed Values: | 0-60 |
operation_dim$scientist_1_person_whid
CC ID: 385468
| Seq. Order: | 57 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
person reference for the first scientist |
| General Data Type: | Number |
equilibrium_longitude_dim$longitude_second_units
CC ID: 385469
| Seq. Order: | 58 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of longitude that makes up the second unit only |
| General Data Type: | Number |
| Unit of Measure: | sec |
| Allowed Values: | 0-59 |
sampling_start_hhmmss
CC ID: 385470
| Seq. Order: | 59 |
|---|---|
| Data Storage Type: | Text |
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
| General Data Type: | Text |
sampling_start_time_dim$record_type
CC ID: 385471
| Seq. Order: | 60 |
|---|---|
| Data Storage Type: | Text |
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
time record or reason record is unavailable |
| General Data Type: | Text |
| Allowed Values: | Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
equilibrium_latitude_dim$latitude_in_degree_minute_second
CC ID: 385472
| Seq. Order: | 61 |
|---|---|
| Data Storage Type: | Text |
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
string representation of latitude in degrees, minutes, and seconds for example 4525'01" |
| General Data Type: | Text |
| Unit of Measure: | NA |
| Allowed Values: | any |
sampling_end_time_dim$second
CC ID: 385473
| Seq. Order: | 62 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
number of seconds in the minute |
| General Data Type: | Number |
| Unit of Measure: | sec |
| Allowed Values: | 0-60 |
equilibrium_longitude_dim$longitude_in_degrees
CC ID: 385474
| Seq. Order: | 63 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
numeric representation of longitude in decimal degrees |
| General Data Type: | Number |
| Unit of Measure: | dd |
| Allowed Values: | -180 to 180 |
operation_dim$scientist_3_person_whid
CC ID: 385475
| Seq. Order: | 64 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
person reference for the third scientist |
| General Data Type: | Number |
haul_weight_lb
CC ID: 385476
| Seq. Order: | 65 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Status: | Active |
| Description: |
Total weight of catch measured in pounds |
| General Data Type: | Number |
| Unit of Measure: | lb |
equilibrium_latitude_dim$named_parallel
CC ID: 385477
| Seq. Order: | 66 |
|---|---|
| Data Storage Type: | Text |
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
name of parallel, boundary, or commonly used geograpical location |
| General Data Type: | Text |
| Unit of Measure: | NA |
| Allowed Values: | any |
sampling_start_time_dim$hour
CC ID: 385478
| Seq. Order: | 67 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
standard representation of the hour |
| General Data Type: | Number |
| Unit of Measure: | hr |
| Allowed Values: | 0-12 |
area_dim$record_type
CC ID: 385479
| Seq. Order: | 68 |
|---|---|
| Data Storage Type: | Text |
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
area record or reason record is unavailable |
| General Data Type: | Text |
| Allowed Values: | Area, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Defined |
average_bottom_depth_dim$boundary_indicator
CC ID: 385480
| Seq. Order: | 69 |
|---|---|
| Data Storage Type: | Text |
| Max Length: | 40 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
depth boundry indicator identifying ifp boundary marks |
| General Data Type: | Text |
| Allowed Values: | IFP Boundary Depth, Standard Contour Depth, NA |
area_dim$south_boundary_latitude_whid
CC ID: 385481
| Seq. Order: | 70 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
south boundary latitude warehouse identifier |
| General Data Type: | Number |
net_touchdown_time
CC ID: 385482
| Seq. Order: | 71 |
|---|---|
| Data Storage Type: | Time |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
military time representation of the time |
| General Data Type: | Time |
sampling_end_hhmmss
CC ID: 385483
| Seq. Order: | 72 |
|---|---|
| Data Storage Type: | Text |
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
| General Data Type: | Text |
average_bottom_depth_dim$depth_fathoms
CC ID: 385484
| Seq. Order: | 73 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| 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 |
equilibrium_latitude_whid
CC ID: 385485
| Seq. Order: | 74 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for equilibrium latitude |
| General Data Type: | Number |
operation_dim$operation_end_time_whid
CC ID: 385486
| Seq. Order: | 75 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
end time reference for the operation |
| General Data Type: | Number |
tow
CC ID: 385487
| Seq. Order: | 76 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
operation number of the survey |
| General Data Type: | Number |
average_wireout
CC ID: 385488
| Seq. Order: | 77 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Precision: | 7 |
| 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 |
sampling_start_time_dim$period
CC ID: 385489
| Seq. Order: | 78 |
|---|---|
| Data Storage Type: | Text |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
period of time |
| General Data Type: | Text |
| Allowed Values: | AM, PM |
sampling_end_time_dim$record_type
CC ID: 385490
| Seq. Order: | 79 |
|---|---|
| Data Storage Type: | Text |
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
time record or reason record is unavailable |
| General Data Type: | Text |
| Allowed Values: | Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
project
CC ID: 385491
| Seq. Order: | 80 |
|---|---|
| Data Storage Type: | Text |
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
project name |
| General Data Type: | Text |
| 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 |
pass
CC ID: 385492
| Seq. Order: | 81 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
pass number of the survey |
| General Data Type: | Number |
| Allowed Values: | 1,2,3,4 |
net_height
CC ID: 385493
| Seq. Order: | 82 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Precision: | 7 |
| 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 |
operation_dim$limited_entry_permit_number
CC ID: 385494
| Seq. Order: | 83 |
|---|---|
| Data Storage Type: | Text |
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California |
| General Data Type: | Text |
operation_dim$operation_start_date_whid
CC ID: 385495
| Seq. Order: | 84 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
start date reference for the operation |
| General Data Type: | Number |
equilibrium_latitude_dim$latitude_in_degrees
CC ID: 385496
| Seq. Order: | 85 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Status: | Active |
| Description: |
numeric representation of latitude in degrees |
| General Data Type: | Number |
| Unit of Measure: | dd |
| Allowed Values: | -90 to 90 |
duration
CC ID: 385497
| Seq. Order: | 86 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Status: | Active |
| Description: |
Time duration of the tow from touch down to haul back |
| General Data Type: | Number |
| Unit of Measure: | duration |
net_liftoff_time
CC ID: 385498
| Seq. Order: | 87 |
|---|---|
| Data Storage Type: | Time |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
military time representation of the time |
| General Data Type: | Time |
average_bottom_depth_dim$record_type
CC ID: 385499
| Seq. Order: | 88 |
|---|---|
| Data Storage Type: | Text |
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
depth record or reason record is unavailable |
| General Data Type: | Text |
| Allowed Values: | Depth, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
tow_start_timestamp
CC ID: 385500
| Seq. Order: | 89 |
|---|---|
| Data Storage Type: | Time |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
operation start date timestamp |
| General Data Type: | Time |
equilibrium_longitude_dim$longitude_in_degree_minute_second
CC ID: 385501
| Seq. Order: | 90 |
|---|---|
| Data Storage Type: | Text |
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
string representation of longitude in degrees, minutes, and seconds for example 4525'01" |
| General Data Type: | Text |
year
CC ID: 385502
| Seq. Order: | 91 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
operation year |
| General Data Type: | Number |
| Unit of Measure: | year |
| Allowed Values: | 2007+ |
equilibrium_longitude_dim$longitude_minute_units
CC ID: 385503
| Seq. Order: | 92 |
|---|---|
| Data Storage Type: | Number |
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of longitude that makes up the minute unit only |
| General Data Type: | Number |
| Unit of Measure: | min |
| Allowed Values: | 0-59 |
operation_dim$operation_type
CC ID: 385504
| Seq. Order: | 93 |
|---|---|
| Data Storage Type: | Text |
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
type of operation |
| General Data Type: | Text |
| Allowed Values: | CTD Cast, Drop, Experiment, Search, Trawl, VPR Tow, [null] |