Item Identification

Title: Operation Acoustics Fact
Short Name: Operation Acoustics Fact
Status: Planned
Abstract:

Operation details from the Integrated acoustic and trawl survey of Pacific hake off the Pacific Coast

Entity Information

Entity Type: Spreadsheet
Active Version?: Yes
Schema Name: PARR
Description:

Operation details from the Integrated acoustic and trawl survey of Pacific hake off the Pacific Coast

Data Attributes

Attribute Summary

Rubric Score Primary Key? 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]

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: 2019-06-04 13:14+0000
Metadata Record Published: 2017-03-03
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2018-03-04