Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NWFSC Metadata Library > FRAM (Fishery Resource Analysis and Monitoring)... > Biological data - Integrated acoustic and trawl... >

Catch Acoustics Fact

Entity (ENT)  |  Northwest Fisheries Science Center (NWFSC)
GUID: gov.noaa.nmfs.inport:36425  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Catch data from the Integrated acoustic and trawl survey of Pacific hake off the Pacific Coast

Description

Catch data from the Integrated acoustic and trawl survey of Pacific hake off the Pacific Coast

Entity Information

Entity Type
Spreadsheet

Data Attribute / Type Description
operation_dim$return_port_whid
Number 		port reference for return port
tow_end_timestamp
Time 		operation end date timestamp
leg
Number 		leg number of the survey
field_identified_taxonomy_dim$subphylum_22
Text 		subphylum name
operation_dim$captain_person_whid
Number 		person reference for the vessel captain
field_identified_taxonomy_dim$phylum_20
Text 		phylum name
equilibrium_latitude_dim$latitude_compass_direction
Text 		latitude compass direction
statistical_partition_whid
Number 		Warehouse identifier for statistical partition
most_recent_taxonomy_update_date_dim$year
Number 		numeric representation of year
equilibrium_longitude_dim$record_type
Text 		longitude record type or reason record is unavailable
sampling_start_time_dim$second
Number 		number of seconds in the minute
equilibrium_latitude_whid
Number 		Warehouse identifier for equilibrium latitude
field_identified_taxonomy_dim$pacfin_spid
Text 		pacfin species id - many taxa may not have one of these
operation_dim$ifq_account_number
Text 		unique number assigned to user accounts in the Vessel Accounting Database
equilibrium_latitude_dim$record_type
Text 		latitude record type or reason record is unavailable
sampling_end_time_dim$hour
Number 		standard representation of the hour
field_identified_taxonomy_dim$superclass_28
Text 		superclass name
sample_weight_lb
Number 		Weight of a sample of the catch measured in pounds
most_recent_taxonomy_update_date_dim$month_name
Text 		text representation of month
field_identified_taxonomy_dim$genus_70
Text 		genus name
weight_in_haul_lb
Number 		Weight of the organisms for the species found in the haul measured in pounds
average_bottom_depth_dim$boundary_indicator
Text 		depth boundry indicator identifying ifp boundary marks
operation_dim$operation_start_time_whid
Number 		start time reference for the operation
equilibrium_longitude_dim$longitude_in_degree_minute_second
Text 		string representation of longitude in degrees, minutes, and seconds for example 4525'01"
operation_dim$scientist_1_person_whid
Number 		person reference for the first scientist
net_liftoff_time
Time 		military time representation of the time
sampling_start_time_dim$minute
Number 		number of minutes in the hour
operation_dim$scientist_4_person_whid
Number 		person reference for the fourth scientist
sampling_start_time_whid
Number 		Warehouse identifier for the sampling start time
equilibrium_latitude_dim$latitude_in_degree_minute_second
Text 		string representation of latitude in degrees, minutes, and seconds for example 4525'01"
field_identified_taxonomy_dim$itis_taxonomic_serial_no
Number 		ITIS taxonomic identifier
operation_dim$departure_port_whid
Number 		port reference for the departure port
pass
Number 		pass number of the survey
sampling_end_time_dim$period
Text 		period of time
operation_dim$scientist_3_person_whid
Number 		person reference for the third scientist
weight_in_haul_kg
Number 		Weight of the organisms for the species found in the haul measured in kilograms
field_identified_taxonomy_dim$structure_source
Text 		Source of the taxonomic structure
most_recent_taxon_update
Time 		full date value
equilibrium_longitude_dim$longitude_second_units
Number 		numeric representation of longitude that makes up the second unit only
equilibrium_latitude_dim$latitude_degree_units
Number 		numeric representation of latitude that makes up the degree unit only
whole_haul_weight_lb
Number 		Weight for the catch that hasn't been sampled out but is the actual measured weight for the haul measured in pounds
project
Text 		project name
partition
Text 		Refines the partition type
sampling_start_time_dim$record_type
Text 		time record or reason record is unavailable
field_identified_taxonomy_dim$observer_species_id
Number 		species identifier used by the observer program
field_identified_taxonomy_dim$worms_aphiaid
Number 		WoRMS taxonomic identifier
operation_dim$scientist_2_person_whid
Number 		person reference for the second scientist
sampling_start_time_dim$military_hour
Number 		military representation of the hour
most_recent_taxonomy_update_date_dim$yyyymmdd
Text 		text representation of year month day
net_touchdown_time
Time 		military time representation of the time
operation_dim$vessel_id
Number 		field database vessel id number
sampling_start_time_dim$period
Text 		period of time
trawl_id
Number 		identifier for a sampling operation
equilibrium_latitude_dim$latitude_minute_units
Number 		numeric representation of latitude that makes up the minute unit only
field_identified_taxonomy_dim$hookandline_species_id
Number 		species identifier used by hook and line
sampling_end_time_dim$military_hour
Number 		military representation of the hour
field_identified_taxonomy_dim$record_type
Text 		record or reason record is unavailable
field_identified_taxonomy_dim$scientific_name_taxonomic_level
Text 		name of the lowest taxonomic level used to define scientific name
sampling_start_time_dim$hour
Number 		standard representation of the hour
field_identified_taxonomy_dim$pacfin_nom_spid
Text 		PacFIN nominal species identifier
field_identified_taxonomy_dim$superfamily_48
Text 		superfamily name
program
Text 		type of fram program
sampling_end_hhmmss
Text 		concatenation of military hour, minute, second, example 230415 equates to 23:04:15
field_identified_taxonomy_dim$superorder_38
Text 		superorder name
most_recent_taxonomy_update_date_dim$day_of_month
Number 		numeric representation of the day in month
total_catch_weight_kg
Number 		Weight of the total catch for the tow measured in kilograms
operation_dim$state_registration_number
Text 		state registration number for the vessel
sampling_end_time_whid
Number 		Warehouse identifier for the sampling end time
operation_dim$record_type
Text 		operation record or reason record is unavailable
average_weight_kg
Number 		Average weight of the species in this haul (weight_in_haul/number_in_haul) measured in kilograms
equilibrium_latitude_dim$named_parallel
Text 		name of parallel, boundary, or commonly used geograpical location
field_identified_taxonomy_dim$common_name
Text 		only one broadly used common name is supported by this design. If the common name is not fairly universally used or is used by more than one taxon this should be left null
whole_haul_indicator
Number 		Indicates if the catch weighed is the entire haul or a subsample
operation_dim_whid
Number 		Warehouse identifier for operation
most_recent_taxonomy_update_date_whid
Number 		Warehouse identifier for most recent taxonomy update date
number_in_haul
Number 		Count of the organisms for the species found in the haul; some of these may be extrapolated numbers
field_identified_taxonomy_whid
Number 		Warehouse identifier to field identified taxonomy
tow
Number 		operation number of the survey
equilibrium_longitude_dim$longitude_minute_units
Number 		numeric representation of longitude that makes up the minute unit only
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
average_bottom_depth_whid
Number 		Warehouse identifier for average bottom depth
field_identified_taxonomy_dim$infraclass_34
Text 		infraclass name
field_identified_taxonomy_dim$subspecies_82
Text 		subspecies name
operation_dim$coast_guard_number
Text 		Coast Guard documentation number of vessel
field_identified_taxonomy_dim$kingdom_10
Text 		kingdom name
most_recent_taxonomy_update_date_dim$record_type
Text 		date, month, or year record or reason record is unavailable
sampling_end_time_dim$record_type
Text 		time record or reason record is unavailable
average_bottom_depth_dim$record_type
Text 		depth record or reason record is unavailable
sampling_end_time_dim$minute
Number 		number of minutes in the hour
whole_haul_weight_kg
Number 		Weight for the catch that hasn't been sampled out but is the actual measured weight for the haul measured in kilograms
field_identified_taxonomy_dim$tribe_60
Text 		tribe name
year
Number 		operation year
equilibrium_latitude_dim$latitude_in_degrees
Number 		numeric representation of latitude in degrees
field_identified_taxonomy_dim$subfamily_52
Text 		subfamily name
field_identified_taxonomy_dim$subclass_32
Text 		subclass name
field_identified_taxonomy_dim$class_30
Text 		class name
equilibrium_longitude_whid
Number 		Warehouse identifier for equilibrium longitude
operation_dim$operation_end_date_whid
Number 		end date reference for the operation
field_identified_taxonomy_dim$grp_nonstandard_taxon_99
Text 		a pseudo taxonomic level that has a common usage such as Invertebrata, Pisces (Fish). This has been designed to allow for only one level of para- or poly-phyletic group that is the terminus of the definition (it may be associated with a higher level taxonomic hierarchy). Consequently a definition such as Fish->Roundfish would not be supported with this design
operation_dim$departure_date_whid
Number 		date reference that vessel departed for the defined leg or trip
statistical_partition_dim$record_type
Text 		statistical partition record or reason record is unavailable
sampling_end_time_dim$second
Number 		number of seconds in the minute
operation_dim$fpc_person_whid
Number 		person reference for the FPC
sampling_start_hhmmss
Text 		concatenation of military hour, minute, second, example 230415 equates to 23:04:15
field_identified_taxonomy_dim$infraorder_44
Text 		infraorder name
performance
Text 		performance of the operation
total_catch_weight_lb
Number 		Weight of the total catch for the tow measured in pounds
field_identified_taxonomy_dim$norpac_species_id
Number 		A three-digit numeric code assigned by the NMFS Observer Program to each different marine organism expected to be seen in the Bering Sea and northeast Pacific Ocean. Each number is uniquely associated with a species_name and a scientific name.
field_identified_taxonomy_dim$suborder_42
Text 		suborder name
field_identified_taxonomy_dim$family_50
Text 		family name
field_identified_taxonomy_dim$species_category
Text 		upper-level taxonomic ranking
field_identified_taxonomy_dim$scientific_name
Text 		scientific name generally composed of the genus and species name and subspecies name if available, but may be the highest taxonomic level
most_recent_taxonomy_update_date_dim$month_abbrev
Text 		three character representation of month in capital letters
tow_start_timestamp
Time 		operation start date timestamp
field_identified_taxonomy_dim$species_sub_category
Text 		mid-level taxonomic ranking
operation_dim$return_date_whid
Number 		date reference that vessel returned for the defined leg or trip
operation_dim$observer_program
Text 		description of the observer program
statistical_partition_dim$statistical_partition_type
Text 		Defines the partition type
equilibrium_longitude_dim$longitude_degree_units
Number 		numeric representation of longitude that makes up the degree unit only
field_identified_taxonomy_dim$acoustics_species_id
Number 		Species ID used in the acoustics program
operation_dim$operation_start_date_whid
Number 		start date reference for the operation
average_bottom_depth_dim$depth_meters
Number 		depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries)
field_identified_taxonomy_dim$order_40
Text 		order name
field_identified_taxonomy_dim$species_80
Text 		species name
equilibrium_longitude_dim$longitude_in_degrees
Number 		numeric representation of longitude in decimal degrees
field_identified_taxonomy_dim$trawl_survey_species_id
Number 		species identifier used by the trawl survey
average_weight_lb
Number 		Average weight of the species in this haul (weight_in_haul/number_in_haul) measured in pounds
operation_dim$operation_type
Text 		type of operation
vessel
Text 		name of the vessel used for the operation
most_recent_taxonomy_update_date_dim$month_of_year
Number 		numeric representation of month of year
equilibrium_longitude_dim$longitude_compass_direction
Text 		longitude compass direction
equilibrium_latitude_dim$latitude_second_units
Number 		numeric representation of latitude that makes up the second unit only
operation_dim$operation_end_time_whid
Number 		end time reference for the operation
field_identified_taxonomy_dim$abbreviated_name
Text 		specialized common name, generally for a well-known species of fish such as ATF, LST, SST
operation_dim$limited_entry_permit_number
Text 		federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California
operation_dim$field_operation_seg_id
Number 		operation segment id reference to the field operational segment table
operation_dim$trip_id
Number 		trip identifier number
field_identified_taxonomy_dim$grp_reg_depth_category
Text 		management grouping mostly for rockfishes (but could be assigned to any species): nearshore, shelf, or slope, or in future shallower shelf and deeper shelf
sample_weight_kg
Number 		Weight of a sample of the catch measured in kilograms
transect_whid
Number 		Warehouse identifier for transect

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NWFSC) for inquiries on this record.

Item Identification

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

Catch data 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:

Catch data 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
 operation_dim$return_port_whid Number port reference for return port
100
 tow_end_timestamp Time operation end date timestamp
100
 leg Number leg number of the survey
100
 field_identified_taxonomy_dim$subphylum_22 Text subphylum name
100
 operation_dim$captain_person_whid Number person reference for the vessel captain
100
 field_identified_taxonomy_dim$phylum_20 Text phylum name
100
 equilibrium_latitude_dim$latitude_compass_direction Text latitude compass direction
100
 statistical_partition_whid Number Warehouse identifier for statistical partition
100
 most_recent_taxonomy_update_date_dim$year Number numeric representation of year
100
 equilibrium_longitude_dim$record_type Text longitude record type or reason record is unavailable
100
 sampling_start_time_dim$second Number number of seconds in the minute
100
 equilibrium_latitude_whid Number Warehouse identifier for equilibrium latitude
100
 field_identified_taxonomy_dim$pacfin_spid Text pacfin species id - many taxa may not have one of these
100
 operation_dim$ifq_account_number Text unique number assigned to user accounts in the Vessel Accounting Database
100
 equilibrium_latitude_dim$record_type Text latitude record type or reason record is unavailable
100
 sampling_end_time_dim$hour Number standard representation of the hour
100
 field_identified_taxonomy_dim$superclass_28 Text superclass name
100
 sample_weight_lb Number Weight of a sample of the catch measured in pounds
100
 most_recent_taxonomy_update_date_dim$month_name Text text representation of month
100
 field_identified_taxonomy_dim$genus_70 Text genus name
100
 weight_in_haul_lb Number Weight of the organisms for the species found in the haul measured in pounds
100
 average_bottom_depth_dim$boundary_indicator Text depth boundry indicator identifying ifp boundary marks
100
 operation_dim$operation_start_time_whid Number start time reference for the operation
100
 equilibrium_longitude_dim$longitude_in_degree_minute_second Text string representation of longitude in degrees, minutes, and seconds for example 4525'01"
100
 operation_dim$scientist_1_person_whid Number person reference for the first scientist
100
 net_liftoff_time Time military time representation of the time
100
 sampling_start_time_dim$minute Number number of minutes in the hour
100
 operation_dim$scientist_4_person_whid Number person reference for the fourth scientist
100
 sampling_start_time_whid Number Warehouse identifier for the sampling start time
100
 equilibrium_latitude_dim$latitude_in_degree_minute_second Text string representation of latitude in degrees, minutes, and seconds for example 4525'01"
100
 field_identified_taxonomy_dim$itis_taxonomic_serial_no Number ITIS taxonomic identifier
100
 operation_dim$departure_port_whid Number port reference for the departure port
100
 pass Number pass number of the survey
100
 sampling_end_time_dim$period Text period of time
100
 operation_dim$scientist_3_person_whid Number person reference for the third scientist
100
 weight_in_haul_kg Number Weight of the organisms for the species found in the haul measured in kilograms
100
 field_identified_taxonomy_dim$structure_source Text Source of the taxonomic structure
100
 most_recent_taxon_update Time full date value
100
 equilibrium_longitude_dim$longitude_second_units Number numeric representation of longitude 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
 whole_haul_weight_lb Number Weight for the catch that hasn't been sampled out but is the actual measured weight for the haul measured in pounds
100
 project Text project name
100
 partition Text Refines the partition type
100
 sampling_start_time_dim$record_type Text time record or reason record is unavailable
100
 field_identified_taxonomy_dim$observer_species_id Number species identifier used by the observer program
100
 field_identified_taxonomy_dim$worms_aphiaid Number WoRMS taxonomic identifier
100
 operation_dim$scientist_2_person_whid Number person reference for the second scientist
100
 sampling_start_time_dim$military_hour Number military representation of the hour
100
 most_recent_taxonomy_update_date_dim$yyyymmdd Text text representation of year month day
100
 net_touchdown_time Time military time representation of the time
100
 operation_dim$vessel_id Number field database vessel id number
100
 sampling_start_time_dim$period Text period of time
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
 field_identified_taxonomy_dim$hookandline_species_id Number species identifier used by hook and line
100
 sampling_end_time_dim$military_hour Number military representation of the hour
100
 field_identified_taxonomy_dim$record_type Text record or reason record is unavailable
100
 field_identified_taxonomy_dim$scientific_name_taxonomic_level Text name of the lowest taxonomic level used to define scientific name
100
 sampling_start_time_dim$hour Number standard representation of the hour
100
 field_identified_taxonomy_dim$pacfin_nom_spid Text PacFIN nominal species identifier
100
 field_identified_taxonomy_dim$superfamily_48 Text superfamily name
100
 program Text type of fram program
100
 sampling_end_hhmmss Text concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100
 field_identified_taxonomy_dim$superorder_38 Text superorder name
100
 most_recent_taxonomy_update_date_dim$day_of_month Number numeric representation of the day in month
100
 total_catch_weight_kg Number Weight of the total catch for the tow measured in kilograms
100
 operation_dim$state_registration_number Text state registration number for the vessel
100
 sampling_end_time_whid Number Warehouse identifier for the sampling end time
100
 operation_dim$record_type Text operation record or reason record is unavailable
100
 average_weight_kg Number Average weight of the species in this haul (weight_in_haul/number_in_haul) measured in kilograms
100
 equilibrium_latitude_dim$named_parallel Text name of parallel, boundary, or commonly used geograpical location
100
 field_identified_taxonomy_dim$common_name Text only one broadly used common name is supported by this design. If the common name is not fairly universally used or is used by more than one taxon this should be left null
100
 whole_haul_indicator Number Indicates if the catch weighed is the entire haul or a subsample
100
 operation_dim_whid Number Warehouse identifier for operation
100
 most_recent_taxonomy_update_date_whid Number Warehouse identifier for most recent taxonomy update date
100
 number_in_haul Number Count of the organisms for the species found in the haul; some of these may be extrapolated numbers
100
 field_identified_taxonomy_whid Number Warehouse identifier to field identified taxonomy
100
 tow Number operation number of the survey
100
 equilibrium_longitude_dim$longitude_minute_units Number numeric representation of longitude that makes up the minute unit only
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
 average_bottom_depth_whid Number Warehouse identifier for average bottom depth
100
 field_identified_taxonomy_dim$infraclass_34 Text infraclass name
100
 field_identified_taxonomy_dim$subspecies_82 Text subspecies name
100
 operation_dim$coast_guard_number Text Coast Guard documentation number of vessel
100
 field_identified_taxonomy_dim$kingdom_10 Text kingdom name
100
 most_recent_taxonomy_update_date_dim$record_type Text date, month, or year record or reason record is unavailable
100
 sampling_end_time_dim$record_type Text time record or reason record is unavailable
100
 average_bottom_depth_dim$record_type Text depth record or reason record is unavailable
100
 sampling_end_time_dim$minute Number number of minutes in the hour
100
 whole_haul_weight_kg Number Weight for the catch that hasn't been sampled out but is the actual measured weight for the haul measured in kilograms
100
 field_identified_taxonomy_dim$tribe_60 Text tribe name
100
 year Number operation year
100
 equilibrium_latitude_dim$latitude_in_degrees Number numeric representation of latitude in degrees
100
 field_identified_taxonomy_dim$subfamily_52 Text subfamily name
100
 field_identified_taxonomy_dim$subclass_32 Text subclass name
100
 field_identified_taxonomy_dim$class_30 Text class name
100
 equilibrium_longitude_whid Number Warehouse identifier for equilibrium longitude
100
 operation_dim$operation_end_date_whid Number end date reference for the operation
100
 field_identified_taxonomy_dim$grp_nonstandard_taxon_99 Text a pseudo taxonomic level that has a common usage such as Invertebrata, Pisces (Fish). This has been designed to allow for only one level of para- or poly-phyletic group that is the terminus of the definition (it may be associated with a higher level taxonomic hierarchy). Consequently a definition such as Fish->Roundfish would not be supported with this design
100
 operation_dim$departure_date_whid Number date reference that vessel departed for the defined leg or trip
100
 statistical_partition_dim$record_type Text statistical partition record or reason record is unavailable
100
 sampling_end_time_dim$second Number number of seconds in the minute
100
 operation_dim$fpc_person_whid Number person reference for the FPC
100
 sampling_start_hhmmss Text concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100
 field_identified_taxonomy_dim$infraorder_44 Text infraorder name
100
 performance Text performance of the operation
100
 total_catch_weight_lb Number Weight of the total catch for the tow measured in pounds
100
 field_identified_taxonomy_dim$norpac_species_id Number A three-digit numeric code assigned by the NMFS Observer Program to each different marine organism expected to be seen in the Bering Sea and northeast Pacific Ocean. Each number is uniquely associated with a species_name and a scientific name.
100
 field_identified_taxonomy_dim$suborder_42 Text suborder name
100
 field_identified_taxonomy_dim$family_50 Text family name
100
 field_identified_taxonomy_dim$species_category Text upper-level taxonomic ranking
100
 field_identified_taxonomy_dim$scientific_name Text scientific name generally composed of the genus and species name and subspecies name if available, but may be the highest taxonomic level
100
 most_recent_taxonomy_update_date_dim$month_abbrev Text three character representation of month in capital letters
100
 tow_start_timestamp Time operation start date timestamp
100
 field_identified_taxonomy_dim$species_sub_category Text mid-level taxonomic ranking
100
 operation_dim$return_date_whid Number date reference that vessel returned for the defined leg or trip
100
 operation_dim$observer_program Text description of the observer program
100
 statistical_partition_dim$statistical_partition_type Text Defines the partition type
100
 equilibrium_longitude_dim$longitude_degree_units Number numeric representation of longitude that makes up the degree unit only
100
 field_identified_taxonomy_dim$acoustics_species_id Number Species ID used in the acoustics program
100
 operation_dim$operation_start_date_whid Number start date reference for the operation
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
 field_identified_taxonomy_dim$order_40 Text order name
100
 field_identified_taxonomy_dim$species_80 Text species name
100
 equilibrium_longitude_dim$longitude_in_degrees Number numeric representation of longitude in decimal degrees
100
 field_identified_taxonomy_dim$trawl_survey_species_id Number species identifier used by the trawl survey
100
 average_weight_lb Number Average weight of the species in this haul (weight_in_haul/number_in_haul) measured in pounds
100
 operation_dim$operation_type Text type of operation
100
 vessel Text name of the vessel used for the operation
100
 most_recent_taxonomy_update_date_dim$month_of_year Number numeric representation of month of year
100
 equilibrium_longitude_dim$longitude_compass_direction Text longitude compass direction
100
 equilibrium_latitude_dim$latitude_second_units Number numeric representation of latitude that makes up the second unit only
100
 operation_dim$operation_end_time_whid Number end time reference for the operation
100
 field_identified_taxonomy_dim$abbreviated_name Text specialized common name, generally for a well-known species of fish such as ATF, LST, SST
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$field_operation_seg_id Number operation segment id reference to the field operational segment table
100
 operation_dim$trip_id Number trip identifier number
100
 field_identified_taxonomy_dim$grp_reg_depth_category Text management grouping mostly for rockfishes (but could be assigned to any species): nearshore, shelf, or slope, or in future shallower shelf and deeper shelf
100
 sample_weight_kg Number Weight of a sample of the catch measured in kilograms
100
 transect_whid Number Warehouse identifier for transect

Attribute Details

operation_dim$return_port_whid

CC ID: 385272
Seq. Order: 1
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

tow_end_timestamp

CC ID: 385273
Seq. Order: 2
Data Storage Type: Time
Required: No
Primary Key: No
Status: Active
Description:

operation end date timestamp
General Data Type: Time

leg

CC ID: 385274
Seq. Order: 3
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

field_identified_taxonomy_dim$subphylum_22

CC ID: 385275
Seq. Order: 4
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

subphylum name
General Data Type: Text

operation_dim$captain_person_whid

CC ID: 385276
Seq. Order: 5
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

field_identified_taxonomy_dim$phylum_20

CC ID: 385277
Seq. Order: 6
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

phylum name
General Data Type: Text

equilibrium_latitude_dim$latitude_compass_direction

CC ID: 385278
Seq. Order: 7
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

statistical_partition_whid

CC ID: 385279
Seq. Order: 8
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for statistical partition
General Data Type: Number

most_recent_taxonomy_update_date_dim$year

CC ID: 385280
Seq. Order: 9
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of year
General Data Type: Number
Allowed Values: 1978+

equilibrium_longitude_dim$record_type

CC ID: 385281
Seq. Order: 10
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

sampling_start_time_dim$second

CC ID: 385282
Seq. Order: 11
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_latitude_whid

CC ID: 385283
Seq. Order: 12
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

field_identified_taxonomy_dim$pacfin_spid

CC ID: 385284
Seq. Order: 13
Data Storage Type: Text
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

pacfin species id - many taxa may not have one of these
General Data Type: Text

operation_dim$ifq_account_number

CC ID: 385285
Seq. Order: 14
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_latitude_dim$record_type

CC ID: 385286
Seq. Order: 15
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

sampling_end_time_dim$hour

CC ID: 385287
Seq. Order: 16
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

field_identified_taxonomy_dim$superclass_28

CC ID: 385288
Seq. Order: 17
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

superclass name
General Data Type: Text

sample_weight_lb

CC ID: 385289
Seq. Order: 18
Data Storage Type: Number
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Weight of a sample of the catch measured in pounds
General Data Type: Number
Unit of Measure: lb

most_recent_taxonomy_update_date_dim$month_name

CC ID: 385290
Seq. Order: 19
Data Storage Type: Text
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

text representation of month
General Data Type: Text
Allowed Values: January, February, March, April, May, June, July, August, September, October, November, December

field_identified_taxonomy_dim$genus_70

CC ID: 385291
Seq. Order: 20
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

genus name
General Data Type: Text

weight_in_haul_lb

CC ID: 385292
Seq. Order: 21
Data Storage Type: Number
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Weight of the organisms for the species found in the haul measured in pounds
General Data Type: Number
Unit of Measure: lb

average_bottom_depth_dim$boundary_indicator

CC ID: 385293
Seq. Order: 22
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

operation_dim$operation_start_time_whid

CC ID: 385294
Seq. Order: 23
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

equilibrium_longitude_dim$longitude_in_degree_minute_second

CC ID: 385295
Seq. Order: 24
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

operation_dim$scientist_1_person_whid

CC ID: 385296
Seq. Order: 25
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

net_liftoff_time

CC ID: 385297
Seq. Order: 26
Data Storage Type: Time
Required: No
Primary Key: No
Status: Active
Description:

military time representation of the time
General Data Type: Time

sampling_start_time_dim$minute

CC ID: 385298
Seq. Order: 27
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

operation_dim$scientist_4_person_whid

CC ID: 385299
Seq. Order: 28
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

sampling_start_time_whid

CC ID: 385300
Seq. Order: 29
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

equilibrium_latitude_dim$latitude_in_degree_minute_second

CC ID: 385301
Seq. Order: 30
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

field_identified_taxonomy_dim$itis_taxonomic_serial_no

CC ID: 385302
Seq. Order: 31
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

ITIS taxonomic identifier
General Data Type: Number
Unit of Measure: unspecified
Allowed Values: Any

operation_dim$departure_port_whid

CC ID: 385303
Seq. Order: 32
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

pass

CC ID: 385304
Seq. Order: 33
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

sampling_end_time_dim$period

CC ID: 385305
Seq. Order: 34
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

operation_dim$scientist_3_person_whid

CC ID: 385306
Seq. Order: 35
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

weight_in_haul_kg

CC ID: 385307
Seq. Order: 36
Data Storage Type: Number
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Weight of the organisms for the species found in the haul measured in kilograms
General Data Type: Number
Unit of Measure: kg

field_identified_taxonomy_dim$structure_source

CC ID: 385308
Seq. Order: 37
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Source of the taxonomic structure
General Data Type: Text
Unit of Measure: unspecified
Allowed Values: Any

most_recent_taxon_update

CC ID: 385309
Seq. Order: 38
Data Storage Type: Time
Required: No
Primary Key: No
Status: Active
Description:

full date value
General Data Type: Time

equilibrium_longitude_dim$longitude_second_units

CC ID: 385310
Seq. Order: 39
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

equilibrium_latitude_dim$latitude_degree_units

CC ID: 385311
Seq. Order: 40
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

whole_haul_weight_lb

CC ID: 385312
Seq. Order: 41
Data Storage Type: Number
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Weight for the catch that hasn't been sampled out but is the actual measured weight for the haul measured in pounds
General Data Type: Number
Unit of Measure: lb

project

CC ID: 385313
Seq. Order: 42
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

partition

CC ID: 385314
Seq. Order: 43
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Refines the partition type
General Data Type: Text
Allowed Values: Life stage: YOY, larvae, eggs and egg cases, adult, subadult; Size: Large, Small, Unspecified; Gender: Male, Female

sampling_start_time_dim$record_type

CC ID: 385315
Seq. Order: 44
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

field_identified_taxonomy_dim$observer_species_id

CC ID: 385316
Seq. Order: 45
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

species identifier used by the observer program
General Data Type: Number

field_identified_taxonomy_dim$worms_aphiaid

CC ID: 385317
Seq. Order: 46
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

WoRMS taxonomic identifier
General Data Type: Number
Unit of Measure: unspecified
Allowed Values: Any

operation_dim$scientist_2_person_whid

CC ID: 385318
Seq. Order: 47
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

sampling_start_time_dim$military_hour

CC ID: 385319
Seq. Order: 48
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

most_recent_taxonomy_update_date_dim$yyyymmdd

CC ID: 385320
Seq. Order: 49
Data Storage Type: Text
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

text representation of year month day
General Data Type: Text

net_touchdown_time

CC ID: 385321
Seq. Order: 50
Data Storage Type: Time
Required: No
Primary Key: No
Status: Active
Description:

military time representation of the time
General Data Type: Time

operation_dim$vessel_id

CC ID: 385322
Seq. Order: 51
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_start_time_dim$period

CC ID: 385323
Seq. Order: 52
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

trawl_id

CC ID: 385324
Seq. Order: 53
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: 385325
Seq. Order: 54
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

field_identified_taxonomy_dim$hookandline_species_id

CC ID: 385326
Seq. Order: 55
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

species identifier used by hook and line
General Data Type: Number

sampling_end_time_dim$military_hour

CC ID: 385327
Seq. Order: 56
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

field_identified_taxonomy_dim$record_type

CC ID: 385328
Seq. Order: 57
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

record or reason record is unavailable
General Data Type: Text
Allowed Values: Taxonomy, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

field_identified_taxonomy_dim$scientific_name_taxonomic_level

CC ID: 385329
Seq. Order: 58
Data Storage Type: Text
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

name of the lowest taxonomic level used to define scientific name
General Data Type: Text

sampling_start_time_dim$hour

CC ID: 385330
Seq. Order: 59
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

field_identified_taxonomy_dim$pacfin_nom_spid

CC ID: 385331
Seq. Order: 60
Data Storage Type: Text
Max Length: 10
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

PacFIN nominal species identifier
General Data Type: Text
Unit of Measure: unspecified
Allowed Values: Any

field_identified_taxonomy_dim$superfamily_48

CC ID: 385332
Seq. Order: 61
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

superfamily name
General Data Type: Text

program

CC ID: 385333
Seq. Order: 62
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

sampling_end_hhmmss

CC ID: 385334
Seq. Order: 63
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

field_identified_taxonomy_dim$superorder_38

CC ID: 385335
Seq. Order: 64
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

superorder name
General Data Type: Text

most_recent_taxonomy_update_date_dim$day_of_month

CC ID: 385336
Seq. Order: 65
Data Storage Type: Number
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of the day in month
General Data Type: Number
Allowed Values: 1-31

total_catch_weight_kg

CC ID: 385337
Seq. Order: 66
Data Storage Type: Number
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Weight of the total catch for the tow measured in kilograms
General Data Type: Number
Unit of Measure: kg

operation_dim$state_registration_number

CC ID: 385338
Seq. Order: 67
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

sampling_end_time_whid

CC ID: 385339
Seq. Order: 68
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

operation_dim$record_type

CC ID: 385340
Seq. Order: 69
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

average_weight_kg

CC ID: 385341
Seq. Order: 70
Data Storage Type: Number
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Average weight of the species in this haul (weight_in_haul/number_in_haul) measured in kilograms
General Data Type: Number
Unit of Measure: kg

equilibrium_latitude_dim$named_parallel

CC ID: 385342
Seq. Order: 71
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

field_identified_taxonomy_dim$common_name

CC ID: 385343
Seq. Order: 72
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

only one broadly used common name is supported by this design. If the common name is not fairly universally used or is used by more than one taxon this should be left null
General Data Type: Text

whole_haul_indicator

CC ID: 385344
Seq. Order: 73
Data Storage Type: Number
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Indicates if the catch weighed is the entire haul or a subsample
General Data Type: Number
Allowed Values: Whole Haulled, Not Whole Haulled

operation_dim_whid

CC ID: 385345
Seq. Order: 74
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

most_recent_taxonomy_update_date_whid

CC ID: 385346
Seq. Order: 75
Data Storage Type: Number
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier for most recent taxonomy update date
General Data Type: Number

number_in_haul

CC ID: 385347
Seq. Order: 76
Data Storage Type: Number
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Count of the organisms for the species found in the haul; some of these may be extrapolated numbers
General Data Type: Number

field_identified_taxonomy_whid

CC ID: 385348
Seq. Order: 77
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Warehouse identifier to field identified taxonomy
General Data Type: Number

tow

CC ID: 385349
Seq. Order: 78
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

equilibrium_longitude_dim$longitude_minute_units

CC ID: 385350
Seq. Order: 79
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

average_bottom_depth_dim$depth_fathoms

CC ID: 385351
Seq. Order: 80
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

average_bottom_depth_whid

CC ID: 385352
Seq. Order: 81
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

field_identified_taxonomy_dim$infraclass_34

CC ID: 385353
Seq. Order: 82
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

infraclass name
General Data Type: Text

field_identified_taxonomy_dim$subspecies_82

CC ID: 385354
Seq. Order: 83
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

subspecies name
General Data Type: Text

operation_dim$coast_guard_number

CC ID: 385355
Seq. Order: 84
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

field_identified_taxonomy_dim$kingdom_10

CC ID: 385356
Seq. Order: 85
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

kingdom name
General Data Type: Text

most_recent_taxonomy_update_date_dim$record_type

CC ID: 385357
Seq. Order: 86
Data Storage Type: Text
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

date, month, or year record or reason record is unavailable
General Data Type: Text
Allowed Values: Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

sampling_end_time_dim$record_type

CC ID: 385358
Seq. Order: 87
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

average_bottom_depth_dim$record_type

CC ID: 385359
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

sampling_end_time_dim$minute

CC ID: 385360
Seq. Order: 89
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

whole_haul_weight_kg

CC ID: 385361
Seq. Order: 90
Data Storage Type: Number
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Weight for the catch that hasn't been sampled out but is the actual measured weight for the haul measured in kilograms
General Data Type: Number
Unit of Measure: kg

field_identified_taxonomy_dim$tribe_60

CC ID: 385362
Seq. Order: 91
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

tribe name
General Data Type: Text

year

CC ID: 385363
Seq. Order: 92
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_latitude_dim$latitude_in_degrees

CC ID: 385364
Seq. Order: 93
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

field_identified_taxonomy_dim$subfamily_52

CC ID: 385365
Seq. Order: 94
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

subfamily name
General Data Type: Text

field_identified_taxonomy_dim$subclass_32

CC ID: 385366
Seq. Order: 95
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

subclass name
General Data Type: Text

field_identified_taxonomy_dim$class_30

CC ID: 385367
Seq. Order: 96
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

class name
General Data Type: Text

equilibrium_longitude_whid

CC ID: 385368
Seq. Order: 97
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_end_date_whid

CC ID: 385369
Seq. Order: 98
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

field_identified_taxonomy_dim$grp_nonstandard_taxon_99

CC ID: 385370
Seq. Order: 99
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

a pseudo taxonomic level that has a common usage such as Invertebrata, Pisces (Fish). This has been designed to allow for only one level of para- or poly-phyletic group that is the terminus of the definition (it may be associated with a higher level taxonomic hierarchy). Consequently a definition such as Fish->Roundfish would not be supported with this design
General Data Type: Text

operation_dim$departure_date_whid

CC ID: 385371
Seq. Order: 100
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

statistical_partition_dim$record_type

CC ID: 385372
Seq. Order: 101
Data Storage Type: Text
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

statistical partition record or reason record is unavailable
General Data Type: Text
Allowed Values: Statistical Partition, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

sampling_end_time_dim$second

CC ID: 385373
Seq. Order: 102
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$fpc_person_whid

CC ID: 385374
Seq. Order: 103
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

sampling_start_hhmmss

CC ID: 385375
Seq. Order: 104
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

field_identified_taxonomy_dim$infraorder_44

CC ID: 385376
Seq. Order: 105
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

infraorder name
General Data Type: Text

performance

CC ID: 385377
Seq. Order: 106
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]

total_catch_weight_lb

CC ID: 385378
Seq. Order: 107
Data Storage Type: Number
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Weight of the total catch for the tow measured in pounds
General Data Type: Number
Unit of Measure: lb

field_identified_taxonomy_dim$norpac_species_id

CC ID: 385379
Seq. Order: 108
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

A three-digit numeric code assigned by the NMFS Observer Program to each different marine organism expected to be seen in the Bering Sea and northeast Pacific Ocean. Each number is uniquely associated with a species_name and a scientific name.
General Data Type: Number
Unit of Measure: unspecified
Allowed Values: Any

field_identified_taxonomy_dim$suborder_42

CC ID: 385380
Seq. Order: 109
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

suborder name
General Data Type: Text

field_identified_taxonomy_dim$family_50

CC ID: 385381
Seq. Order: 110
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

family name
General Data Type: Text

field_identified_taxonomy_dim$species_category

CC ID: 385382
Seq. Order: 111
Data Storage Type: Text
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

upper-level taxonomic ranking
General Data Type: Text
Allowed Values: fish, invertebrate, mammal, seabird, reptile, nonspecific organics, NA

field_identified_taxonomy_dim$scientific_name

CC ID: 385383
Seq. Order: 112
Data Storage Type: Text
Max Length: 120
Required: No
Primary Key: No
Status: Active
Description:

scientific name generally composed of the genus and species name and subspecies name if available, but may be the highest taxonomic level
General Data Type: Text

most_recent_taxonomy_update_date_dim$month_abbrev

CC ID: 385384
Seq. Order: 113
Data Storage Type: Text
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

three character representation of month in capital letters
General Data Type: Text
Allowed Values: JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC

tow_start_timestamp

CC ID: 385385
Seq. Order: 114
Data Storage Type: Time
Required: No
Primary Key: No
Status: Active
Description:

operation start date timestamp
General Data Type: Time

field_identified_taxonomy_dim$species_sub_category

CC ID: 385386
Seq. Order: 115
Data Storage Type: Text
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

mid-level taxonomic ranking
General Data Type: Text
Allowed Values: rockfish, flatfish, shark, crab, NA

operation_dim$return_date_whid

CC ID: 385387
Seq. Order: 116
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$observer_program

CC ID: 385388
Seq. Order: 117
Data Storage Type: Text
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

description of the observer program
General Data Type: Text

statistical_partition_dim$statistical_partition_type

CC ID: 385389
Seq. Order: 118
Data Storage Type: Text
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Defines the partition type
General Data Type: Text
Allowed Values: Life Stage, Size, Gender

equilibrium_longitude_dim$longitude_degree_units

CC ID: 385390
Seq. Order: 119
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

field_identified_taxonomy_dim$acoustics_species_id

CC ID: 385391
Seq. Order: 120
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Species ID used in the acoustics program
General Data Type: Number
Unit of Measure: unspecified
Allowed Values: Any

operation_dim$operation_start_date_whid

CC ID: 385392
Seq. Order: 121
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

average_bottom_depth_dim$depth_meters

CC ID: 385393
Seq. Order: 122
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

field_identified_taxonomy_dim$order_40

CC ID: 385394
Seq. Order: 123
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

order name
General Data Type: Text

field_identified_taxonomy_dim$species_80

CC ID: 385395
Seq. Order: 124
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

species name
General Data Type: Text

equilibrium_longitude_dim$longitude_in_degrees

CC ID: 385396
Seq. Order: 125
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

field_identified_taxonomy_dim$trawl_survey_species_id

CC ID: 385397
Seq. Order: 126
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

species identifier used by the trawl survey
General Data Type: Number

average_weight_lb

CC ID: 385398
Seq. Order: 127
Data Storage Type: Number
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Average weight of the species in this haul (weight_in_haul/number_in_haul) measured in pounds
General Data Type: Number
Unit of Measure: lb

operation_dim$operation_type

CC ID: 385399
Seq. Order: 128
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]

vessel

CC ID: 385400
Seq. Order: 129
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

most_recent_taxonomy_update_date_dim$month_of_year

CC ID: 385401
Seq. Order: 130
Data Storage Type: Number
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of month of year
General Data Type: Number
Allowed Values: 1-12

equilibrium_longitude_dim$longitude_compass_direction

CC ID: 385402
Seq. Order: 131
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

equilibrium_latitude_dim$latitude_second_units

CC ID: 385403
Seq. Order: 132
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

operation_dim$operation_end_time_whid

CC ID: 385404
Seq. Order: 133
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

field_identified_taxonomy_dim$abbreviated_name

CC ID: 385405
Seq. Order: 134
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

specialized common name, generally for a well-known species of fish such as ATF, LST, SST
General Data Type: Text

operation_dim$limited_entry_permit_number

CC ID: 385406
Seq. Order: 135
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$field_operation_seg_id

CC ID: 385407
Seq. Order: 136
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$trip_id

CC ID: 385408
Seq. Order: 137
Data Storage Type: Number
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

trip identifier number
General Data Type: Number

field_identified_taxonomy_dim$grp_reg_depth_category

CC ID: 385409
Seq. Order: 138
Data Storage Type: Text
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

management grouping mostly for rockfishes (but could be assigned to any species): nearshore, shelf, or slope, or in future shallower shelf and deeper shelf
General Data Type: Text

sample_weight_kg

CC ID: 385410
Seq. Order: 139
Data Storage Type: Number
Max Length: 10
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

Weight of a sample of the catch measured in kilograms
General Data Type: Number
Unit of Measure: kg

transect_whid

CC ID: 385411
Seq. Order: 140
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

Catalog Details

Catalog Item ID: 36425
GUID: gov.noaa.nmfs.inport:36425
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 Last Review Date: 2017-03-03
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2018-03-03