Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NWFSC Metadata Library > FRAM (Fishery Resource Analysis and Monitoring)... > Southern California Hook and Line Survey - 2020... >

operation_hook_fact

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

Summary

Description

Operation details down to the hook level

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
vessel
varchar 		name of the vessel used for the operation
net_touchdown_time
time 		military time representation of the time
site_dim$distance_to_port_nm
numeric 		distance from site to nearest port in nautical miles
ctd_drop_latitude_whid
int4 		warehouse identifier for CTD drop latitude
drop_sounder_depth_dim$depth_meters
numeric 		depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries)
angler_person_dim$full_name
varchar 		full name in format of First and Last (Suffix)
ctd_drop_longitude_dim$longitude_compass_direction
bpchar 		longitude compass direction
ctd_on_bottom_measure_depth_dim$record_type
varchar 		depth record or reason record is unavailable
sampling_end_time_dim$period
bpchar 		period of time
tide_height_mid_ft
numeric 		tide height at middle (third) drop for a site measured in feet
site_dim$site_number
int4 		site identifier number
drop_latitude_dim$named_parallel
varchar 		name of parallel, boundary, or commonly used geograpical location
operation_dim$state_registration_number
varchar 		state registration number for the vessel
operation_dim$limited_entry_permit_number
bpchar 		federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California
date_dim$record_type
varchar 		date, month, or year record or reason record is unavailable
ctd_drop_latitude_dim$latitude_compass_direction
bpchar 		latitude compass direction
drop_longitude_dim$longitude_in_degrees
numeric 		numeric representation of longitude in decimal degrees
ctd_on_bottom_salinity_psu
numeric 		CTD on bottom salinity in practical salinity units (psu)
hook_dim$record_type
varchar 		hook record or reason record is unavailable
ctd_drop_longitude_dim$longitude_minute_units
int2 		numeric representation of longitude that makes up the minute unit only
marine_reserve_indicator
varchar 		identifier if the hook was inside a marine reserve
operation_dim$scientist_3_person_whid
int4 		person reference for the third scientist
hook_id
int4 		field database hook identifier
angler_person_whid
int4 		warehouse identifier for angler person
tide_height_first_ft
numeric 		tide height at first drop for a site measured in feet
ctd_on_bottom_measure_depth_whid
int4 		warehouse identifier for CTD on bottom measure depth
ctd_on_bottom_measure_depth_dim$depth_fathoms
numeric 		depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries
sunset_time_whid
int4 		warehouse identifier for the sunset time
site_whid
int4 		warehouse identifier for site
drop_sounder_depth_whid
int4 		warehouse identifier for drop sounder depth
drop_longitude_dim$longitude_second_units
int2 		numeric representation of longitude that makes up the second unit only
site_moon_tide_dim$tide_phase
varchar 		tide phase
angler_person_dim$nick_name
varchar 		nickname of person
sunrise_time_dim$minute
int2 		number of minutes in the hour
site_dim$tide_station_latitude_whid
int4 		warehouse identifier to latitude details for site's nearest tide station
operation_dim$operation_start_date_whid
int8 		start date reference for the operation
begin_retrieval_interval_sec
int4 		interval in seconds between gear deployment until gear retrieval began
program
varchar 		type of fram program
date_dim$month_of_year
int2 		numeric representation of month of year
operation_dim$captain_person_whid
int4 		person reference for the vessel captain
tide_height_last_ft
numeric 		tide height at last (fifth) drop for a site measured in feet
set_identifier
varchar 		set identifier
inclusion_whid
int4 		warehouse identifier for what to include in analysis
operation_dim$fpc_person_whid
int4 		person reference for the FPC
operation_dim$record_type
varchar 		operation record or reason record is unavailable
sampling_start_time_dim$military_hour
int2 		military representation of the hour
angler_person_dim$role
varchar 		role taken during an operation
drop_latitude_dim$latitude_in_degree_minute_second
varchar 		string representation of latitude in degrees, minutes, and seconds for example 4525'01"
ctd_drop_time_dim$period
bpchar 		period of time
ctd_on_bottom_measure_depth_dim$depth_meters
numeric 		depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries)
operation_dim$operation_type
varchar 		type of operation
swell_height_ft
numeric 		swell height in feet
operation_dim$ifq_account_number
varchar 		unique number assigned to user accounts in the Vessel Accounting Database
sunrise_time_dim$record_type
varchar 		time record or reason record is unavailable
sampling_end_time_dim$hour
int2 		standard representation of the hour
inclusion_dim$record_type
varchar 		inclusion record or reason record is unavailable
sinker_weight_lbs
int2 		sinker weights in pounds
inclusion_dim$site_inclusion_indicator
varchar 		indicates if site should be included
operation_dim$operation_end_date_whid
int8 		end date reference for the operation
sampling_start_time_dim$second
int2 		number of seconds in the minute
site_dim$tide_station_noaa_id
varchar 		tide station id according to NOAA's Tides and Currents site
tide_height_mid_m
numeric 		tide height at middle (third) drop for a site measured in meters
sunset_time_dim$second
int2 		number of seconds in the minute
site_general_note
varchar 		site general notes
drop_longitude_dim$longitude_compass_direction
bpchar 		longitude compass direction
wave_height_m
numeric 		wave height in meters
hook_note
varchar 		hook notes
site_moon_tide_dim$record_type
varchar 		moon tide record or reason record is unavailable
operation_dim$scientist_4_person_whid
int4 		person reference for the fourth scientist
drop_average_sea_surface_temp_c
numeric 		drop average sea surface temperature in degrees celcius
ctd_drop_time_whid
int4 		warehouse identifier for CTD drop time
tow_end_timestamp
timestamp 		operation end date timestamp
site_dim$inactive_date_whid
int8 		warehouse identifier for the date when the site went inactive
tide_height_first_m
numeric 		tide height at first drop for a site measured in meters
angler_person_dim$record_type
varchar 		person record or reason record is unavailable
pass
int4 		pass number of the survey
tow_start_timestamp
timestamp 		operation start date timestamp
ctd_on_bottom_measure_depth_dim$boundary_indicator
varchar 		depth boundry indicator identifying ifp boundary marks
ctd_drop_time_dim$minute
int2 		number of minutes in the hour
sunrise_time_whid
int4 		warehouse identifier for the sunrise time
drop_time_dim$record_type
varchar 		time record or reason record is unavailable
drop_latitude_dim$latitude_in_degrees
numeric 		numeric representation of latitude in degrees
site_dim$cdfgblock
int4 		CDFG Block Numbers that the sites fall within
operation_dim$coast_guard_number
varchar 		Coast Guard documentation number of vessel
operation_dim$operation_start_time_whid
int8 		start time reference for the operation
site_dim$area_name
varchar 		name of area site is located in
time_to_first_bite_interval_sec
int4 		interval in seconds calculated from the difference between first bite and on bottom
date_dim$full_date
timestamp 		full date value
sunrise_time_dim$hh24miss
bpchar 		concatenation of military hour, minute, second, example 230415 equates to 23:04:15
site_dim$site_longitude_whid
int4 		warehouse identifier to longitude details for site
site_dim$cowcod_conservation_area_indicator
varchar 		indicates if site falls within the cowcod conservation area
hook_dim$gear_performance
varchar 		Gear performance
inclusion_dim$drop_inclusion_indicator
varchar 		indicates if drop should be included
sampling_end_time_dim$military_hour
int2 		military representation of the hour
fishing_time_interval_sec
int4 		interval in seconds calculated from the difference between begin retrieval and on bottomv
ctd_drop_longitude_dim$longitude_second_units
int2 		numeric representation of longitude that makes up the second unit only
sunset_time_dim$period
bpchar 		period of time
hook_whid
int4 		warehouse identifier to hook details
swell_direction_mag
int2 		swell direction in magnetic degrees
net_liftoff_time
time 		military time representation of the time
leg
int2 		leg number of the survey
hook_dim$hook_number
int2 		The hook number on the line
site_dim$site_longitude_dd
numeric 		site longitude in decimal degrees
operation_dim$observer_program
varchar 		description of the observer program
drop_timestamp
timestamp 		drop timestamp
drop_sounder_depth_dim$boundary_indicator
varchar 		depth boundry indicator identifying ifp boundary marks
drop_latitude_dd
numeric 		drop latitude in decimal degrees
drop_time_dim$hour
int2 		standard representation of the hour
date_dim$month_name
varchar 		text representation of month
sunset_time_dim$time
time 		military time representation of the time
sampling_start_time_dim$hour
int2 		standard representation of the hour
drop_latitude_whid
int4 		warehouse identifier for drop latitude
ctd_drop_latitude_dim$record_type
varchar 		latitude record type or reason record is unavailable
ctd_drop_time_dim$second
int2 		number of seconds in the minute
drop_longitude_dim$longitude_in_degree_minute_second
varchar 		string representation of longitude in degrees, minutes, and seconds for example 4525'01"
operation_dim_whid
int4 		warehouse identifier for operation
angler_position
varchar 		position of angler on vessel
sunrise_time_dim$military_hour
int2 		military representation of the hour
sunrise_time_dim$second
int2 		number of seconds in the minute
performance
varchar 		performance of the operation
ctd_sounder_depth_m
numeric 		CTD sounder depth in meters
date_dim$month_abbrev
bpchar 		three character representation of month in capital letters
ctd_drop_longitude_whid
int4 		warehouse identifier for CTD drop longitude
drop_time_dim$hh24miss
bpchar 		concatenation of military hour, minute, second, example 230415 equates to 23:04:15
ctd_drop_latitude_dd
numeric 		high precision value for CTD drop latitude in decimal degrees
site_ocean_weather_note
varchar 		site's ocean and weather notes
drop_time_whid
int4 		warehouse identifier for the drop time
operation_dim$departure_port_whid
int4 		port reference for the departure port
angler_person_dim$first_name
varchar 		first name of person
sampling_end_hhmmss
bpchar 		concatenation of military hour, minute, second, example 230415 equates to 23:04:15
operation_dim$field_operation_seg_id
int8 		operation segment id reference to the field operational segment table
sampling_start_hhmmss
bpchar 		concatenation of military hour, minute, second, example 230415 equates to 23:04:15
drop_latitude_dim$latitude_compass_direction
bpchar 		latitude compass direction
site_dim$record_type
varchar 		site record or reason record is unavailable
swell_height_m
numeric 		swell height in meters
ctd_drop_time_dim$hour
int2 		standard representation of the hour
date_dim$day_of_month
int2 		numeric representation of the day in month
sea_surface_temp_c
numeric 		sea surface temperature in degrees celcius
operation_dim$scientist_2_person_whid
int4 		person reference for the second scientist
drop_latitude_dim$latitude_degree_units
int2 		numeric representation of latitude that makes up the degree unit only
drop_time_dim$second
int2 		number of seconds in the minute
fish_info_note
varchar 		overall fish information note
date_yyyymmdd
bpchar 		text representation of year month day
drop_time_dim$period
bpchar 		period of time
ctd_drop_latitude_dim$named_parallel
varchar 		name of parallel, boundary, or commonly used geograpical location
site_moon_tide_dim$tide_type
varchar 		tide type
date_dim$year
int4 		numeric representation of year
sunrise_time_dim$time
time 		military time representation of the time
ctd_drop_latitude_dim$latitude_degree_units
int2 		numeric representation of latitude that makes up the degree unit only
site_dim$tide_station_longitude_whid
int4 		warehouse identifier to longitude details for site's nearest tide station
operation_dim$scientist_1_person_whid
int4 		person reference for the first scientist
sampling_end_time_dim$record_type
varchar 		time record or reason record is unavailable
first_bite_interval_sec
int4 		interval in seconds between gear deployment until angler feels first bite
site_dim$tide_station_name
varchar 		name of nearest tide station
angler_person_dim$middle_initial
bpchar 		middle initial of person
drop_time_dim$military_hour
int2 		military representation of the hour
sunset_time_dim$record_type
varchar 		time record or reason record is unavailable
ctd_drop_time_dim$time
time 		military time representation of the time
ctd_on_bottom_disolved_oxygen_sbe43_ml_per_l
numeric 		CTD SBE43 sensor on bottom disolved oxygen measured in milliliters per liter
at_surface_interval_sec
int4 		interval in seconds between gear deployment until gear reaches surface concluding the drop
ctd_drop_time_dim$military_hour
int2 		military representation of the hour
site_habitat_note
varchar 		site habitat notes
drop_latitude_dim$latitude_second_units
int2 		numeric representation of latitude that makes up the second unit only
ctd_on_bottom_disolved_oxygen_aanderaa_ml_per_l
numeric 		CTD aanderaa sensor on bottom disolved oxygen measured in milliliters per liter
wave_height_ft
numeric 		wave height in feet
drop_longitude_dim$longitude_minute_units
int2 		numeric representation of longitude that makes up the minute unit only
ctd_sounder_depth_dim$depth_meters
numeric 		depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries)
ctd_drop_longitude_dim$record_type
varchar 		longitude record type or reason record is unavailable
sampling_start_time_dim$period
bpchar 		period of time
drop_time_dim$time
time 		military time representation of the time
angler_person_dim$last_name
varchar 		last name of person
drop_latitude_dim$latitude_minute_units
int2 		numeric representation of latitude that makes up the minute unit only
ctd_on_bottom_temp_c
numeric 		CTD on bottom temperature in degrees celcius
drop_latitude_dim$record_type
varchar 		latitude record type or reason record is unavailable
drop_longitude_dim$record_type
varchar 		longitude record type or reason record is unavailable
operation_dim$return_port_whid
int4 		port reference for return port
sunrise_time_dim$hour
int2 		standard representation of the hour
sampling_end_time_dim$minute
int2 		number of minutes in the hour
tide_height_last_m
numeric 		tide height at last (fifth) drop for a site measured in meters
ctd_drop_time_dim$hh24miss
bpchar 		concatenation of military hour, minute, second, example 230415 equates to 23:04:15
operation_dim$trip_id
int4 		trip identifier number
project
varchar 		project name
ctd_sounder_depth_dim$record_type
varchar 		depth record or reason record is unavailable
ctd_drop_longitude_dim$longitude_in_degree_minute_second
varchar 		string representation of longitude in degrees, minutes, and seconds for example 4525'01"
ctd_sounder_depth_dim$boundary_indicator
varchar 		depth boundry indicator identifying ifp boundary marks
drop_sounder_depth_dim$record_type
varchar 		depth record or reason record is unavailable
drop_longitude_dim$longitude_degree_units
int2 		numeric representation of longitude that makes up the degree unit only
tow
int2 		operation number of the survey
ctd_drop_longitude_dim$longitude_in_degrees
numeric 		numeric representation of longitude in decimal degrees
ctd_drop_time_dim$record_type
varchar 		time record or reason record is unavailable
date_whid
int4 		warehouse identifier for date
sunset_time_dim$military_hour
int2 		military representation of the hour
on_bottom_interval_sec
int4 		interval in seconds between gear deployment until it hits bottom
site_dim$site_latitude_dd
numeric 		site latitude in decimal degrees
ctd_drop_longitude_dd
numeric 		high precision value for CTD drop longitude in decimal degrees
ctd_sounder_depth_dim$depth_fathoms
numeric 		depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries
drop_longitude_dd
numeric 		drop longitude in decimal degrees
hook_dim$hook_result
varchar 		The result of using the hook
operation_dim$operation_end_time_whid
int8 		end time reference for the operation
drop_sounder_depth_dim$depth_fathoms
numeric 		depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries
sampling_end_time_dim$second
int2 		number of seconds in the minute
operation_dim$departure_date_whid
int8 		date reference that vessel departed for the defined leg or trip
sunset_time_dim$hour
int2 		standard representation of the hour
sampling_start_time_dim$record_type
varchar 		time record or reason record is unavailable
sunset_time_dim$minute
int2 		number of minutes in the hour
ctd_drop_latitude_dim$latitude_in_degrees
numeric 		numeric representation of latitude in degrees
site_dim$site_latitude_whid
int4 		warehouse identifier to latitude details for site
drop_detail_note
varchar 		drop detail notes
sunset_time_dim$hh24miss
bpchar 		concatenation of military hour, minute, second, example 230415 equates to 23:04:15
drop_time_dim$minute
int2 		number of minutes in the hour
inclusion_dim$hook_inclusion_indicator
varchar 		indicates if hook should be included
sunrise_time_dim$period
bpchar 		period of time
ctd_drop_latitude_dim$latitude_second_units
int2 		numeric representation of latitude that makes up the second unit only
sampling_start_time_dim$minute
int2 		number of minutes in the hour
ctd_on_bottom_measure_depth_m
numeric 		CTD on bottom measured depth in meters
operation_dim$vessel_id
int2 		field database vessel id number
drop_longitude_whid
int4 		warehouse identifier for drop latitude
operation_dim$return_date_whid
int8 		date reference that vessel returned for the defined leg or trip
ctd_drop_latitude_dim$latitude_minute_units
int2 		numeric representation of latitude that makes up the minute unit only
site_moon_tide_whid
int2 		warehouse identifier for site moon tide
site_moon_tide_dim$moon_phase
varchar 		moon phase
ctd_sounder_depth_whid
int4 		warehouse identifier for CTD sounder depth
ctd_drop_longitude_dim$longitude_degree_units
int2 		numeric representation of longitude that makes up the degree unit only
site_fish_finder_note
varchar 		site fish finder notes
year
int2 		operation year
ctd_drop_latitude_dim$latitude_in_degree_minute_second
varchar 		string representation of latitude in degrees, minutes, and seconds for example 4525'01"
sampling_end_time_whid
int4 		warehouse identifier for the sampling end time
sampling_start_time_whid
int4 		warehouse identifier for the sampling start time
full_moon_pct
int2 		percent of full moon
trawl_id
int8 		identifier for a sampling operation

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: operation_hook_fact

Entity Information

Entity Type: Data Table
Description:

Operation details down to the hook level

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 vessel varchar name of the vessel used for the operation
100
 net_touchdown_time time military time representation of the time
100
 site_dim$distance_to_port_nm numeric distance from site to nearest port in nautical miles
100
 ctd_drop_latitude_whid int4 warehouse identifier for CTD drop latitude
100
 drop_sounder_depth_dim$depth_meters numeric depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries)
100
 angler_person_dim$full_name varchar full name in format of First and Last (Suffix)
100
 ctd_drop_longitude_dim$longitude_compass_direction bpchar longitude compass direction
100
 ctd_on_bottom_measure_depth_dim$record_type varchar depth record or reason record is unavailable
100
 sampling_end_time_dim$period bpchar period of time
100
 tide_height_mid_ft numeric tide height at middle (third) drop for a site measured in feet
100
 site_dim$site_number int4 site identifier number
100
 drop_latitude_dim$named_parallel varchar name of parallel, boundary, or commonly used geograpical location
100
 operation_dim$state_registration_number varchar state registration number for the vessel
100
 operation_dim$limited_entry_permit_number bpchar federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California
100
 date_dim$record_type varchar date, month, or year record or reason record is unavailable
100
 ctd_drop_latitude_dim$latitude_compass_direction bpchar latitude compass direction
100
 drop_longitude_dim$longitude_in_degrees numeric numeric representation of longitude in decimal degrees
100
 ctd_on_bottom_salinity_psu numeric CTD on bottom salinity in practical salinity units (psu)
100
 hook_dim$record_type varchar hook record or reason record is unavailable
100
 ctd_drop_longitude_dim$longitude_minute_units int2 numeric representation of longitude that makes up the minute unit only
100
 marine_reserve_indicator varchar identifier if the hook was inside a marine reserve
100
 operation_dim$scientist_3_person_whid int4 person reference for the third scientist
100
 hook_id int4 field database hook identifier
100
 angler_person_whid int4 warehouse identifier for angler person
100
 tide_height_first_ft numeric tide height at first drop for a site measured in feet
100
 ctd_on_bottom_measure_depth_whid int4 warehouse identifier for CTD on bottom measure depth
100
 ctd_on_bottom_measure_depth_dim$depth_fathoms numeric depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries
100
 sunset_time_whid int4 warehouse identifier for the sunset time
100
 site_whid int4 warehouse identifier for site
100
 drop_sounder_depth_whid int4 warehouse identifier for drop sounder depth
100
 drop_longitude_dim$longitude_second_units int2 numeric representation of longitude that makes up the second unit only
100
 site_moon_tide_dim$tide_phase varchar tide phase
100
 angler_person_dim$nick_name varchar nickname of person
100
 sunrise_time_dim$minute int2 number of minutes in the hour
100
 site_dim$tide_station_latitude_whid int4 warehouse identifier to latitude details for site's nearest tide station
100
 operation_dim$operation_start_date_whid int8 start date reference for the operation
100
 begin_retrieval_interval_sec int4 interval in seconds between gear deployment until gear retrieval began
100
 program varchar type of fram program
100
 date_dim$month_of_year int2 numeric representation of month of year
100
 operation_dim$captain_person_whid int4 person reference for the vessel captain
100
 tide_height_last_ft numeric tide height at last (fifth) drop for a site measured in feet
100
 set_identifier varchar set identifier
100
 inclusion_whid int4 warehouse identifier for what to include in analysis
100
 operation_dim$fpc_person_whid int4 person reference for the FPC
100
 operation_dim$record_type varchar operation record or reason record is unavailable
100
 sampling_start_time_dim$military_hour int2 military representation of the hour
100
 angler_person_dim$role varchar role taken during an operation
100
 drop_latitude_dim$latitude_in_degree_minute_second varchar string representation of latitude in degrees, minutes, and seconds for example 4525'01"
100
 ctd_drop_time_dim$period bpchar period of time
100
 ctd_on_bottom_measure_depth_dim$depth_meters numeric depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries)
100
 operation_dim$operation_type varchar type of operation
100
 swell_height_ft numeric swell height in feet
100
 operation_dim$ifq_account_number varchar unique number assigned to user accounts in the Vessel Accounting Database
100
 sunrise_time_dim$record_type varchar time record or reason record is unavailable
100
 sampling_end_time_dim$hour int2 standard representation of the hour
100
 inclusion_dim$record_type varchar inclusion record or reason record is unavailable
100
 sinker_weight_lbs int2 sinker weights in pounds
100
 inclusion_dim$site_inclusion_indicator varchar indicates if site should be included
100
 operation_dim$operation_end_date_whid int8 end date reference for the operation
100
 sampling_start_time_dim$second int2 number of seconds in the minute
100
 site_dim$tide_station_noaa_id varchar tide station id according to NOAA's Tides and Currents site
100
 tide_height_mid_m numeric tide height at middle (third) drop for a site measured in meters
100
 sunset_time_dim$second int2 number of seconds in the minute
100
 site_general_note varchar site general notes
100
 drop_longitude_dim$longitude_compass_direction bpchar longitude compass direction
100
 wave_height_m numeric wave height in meters
100
 hook_note varchar hook notes
100
 site_moon_tide_dim$record_type varchar moon tide record or reason record is unavailable
100
 operation_dim$scientist_4_person_whid int4 person reference for the fourth scientist
100
 drop_average_sea_surface_temp_c numeric drop average sea surface temperature in degrees celcius
100
 ctd_drop_time_whid int4 warehouse identifier for CTD drop time
100
 tow_end_timestamp timestamp operation end date timestamp
100
 site_dim$inactive_date_whid int8 warehouse identifier for the date when the site went inactive
100
 tide_height_first_m numeric tide height at first drop for a site measured in meters
100
 angler_person_dim$record_type varchar person record or reason record is unavailable
100
 pass int4 pass number of the survey
100
 tow_start_timestamp timestamp operation start date timestamp
100
 ctd_on_bottom_measure_depth_dim$boundary_indicator varchar depth boundry indicator identifying ifp boundary marks
100
 ctd_drop_time_dim$minute int2 number of minutes in the hour
100
 sunrise_time_whid int4 warehouse identifier for the sunrise time
100
 drop_time_dim$record_type varchar time record or reason record is unavailable
100
 drop_latitude_dim$latitude_in_degrees numeric numeric representation of latitude in degrees
100
 site_dim$cdfgblock int4 CDFG Block Numbers that the sites fall within
100
 operation_dim$coast_guard_number varchar Coast Guard documentation number of vessel
100
 operation_dim$operation_start_time_whid int8 start time reference for the operation
100
 site_dim$area_name varchar name of area site is located in
100
 time_to_first_bite_interval_sec int4 interval in seconds calculated from the difference between first bite and on bottom
100
 date_dim$full_date timestamp full date value
100
 sunrise_time_dim$hh24miss bpchar concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100
 site_dim$site_longitude_whid int4 warehouse identifier to longitude details for site
100
 site_dim$cowcod_conservation_area_indicator varchar indicates if site falls within the cowcod conservation area
100
 hook_dim$gear_performance varchar Gear performance
100
 inclusion_dim$drop_inclusion_indicator varchar indicates if drop should be included
100
 sampling_end_time_dim$military_hour int2 military representation of the hour
100
 fishing_time_interval_sec int4 interval in seconds calculated from the difference between begin retrieval and on bottomv
100
 ctd_drop_longitude_dim$longitude_second_units int2 numeric representation of longitude that makes up the second unit only
100
 sunset_time_dim$period bpchar period of time
100
 hook_whid int4 warehouse identifier to hook details
100
 swell_direction_mag int2 swell direction in magnetic degrees
100
 net_liftoff_time time military time representation of the time
100
 leg int2 leg number of the survey
100
 hook_dim$hook_number int2 The hook number on the line
100
 site_dim$site_longitude_dd numeric site longitude in decimal degrees
100
 operation_dim$observer_program varchar description of the observer program
100
 drop_timestamp timestamp drop timestamp
100
 drop_sounder_depth_dim$boundary_indicator varchar depth boundry indicator identifying ifp boundary marks
100
 drop_latitude_dd numeric drop latitude in decimal degrees
100
 drop_time_dim$hour int2 standard representation of the hour
100
 date_dim$month_name varchar text representation of month
100
 sunset_time_dim$time time military time representation of the time
100
 sampling_start_time_dim$hour int2 standard representation of the hour
100
 drop_latitude_whid int4 warehouse identifier for drop latitude
100
 ctd_drop_latitude_dim$record_type varchar latitude record type or reason record is unavailable
100
 ctd_drop_time_dim$second int2 number of seconds in the minute
100
 drop_longitude_dim$longitude_in_degree_minute_second varchar string representation of longitude in degrees, minutes, and seconds for example 4525'01"
100
 operation_dim_whid int4 warehouse identifier for operation
100
 angler_position varchar position of angler on vessel
100
 sunrise_time_dim$military_hour int2 military representation of the hour
100
 sunrise_time_dim$second int2 number of seconds in the minute
100
 performance varchar performance of the operation
100
 ctd_sounder_depth_m numeric CTD sounder depth in meters
100
 date_dim$month_abbrev bpchar three character representation of month in capital letters
100
 ctd_drop_longitude_whid int4 warehouse identifier for CTD drop longitude
100
 drop_time_dim$hh24miss bpchar concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100
 ctd_drop_latitude_dd numeric high precision value for CTD drop latitude in decimal degrees
100
 site_ocean_weather_note varchar site's ocean and weather notes
100
 drop_time_whid int4 warehouse identifier for the drop time
100
 operation_dim$departure_port_whid int4 port reference for the departure port
100
 angler_person_dim$first_name varchar first name of person
100
 sampling_end_hhmmss bpchar concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100
 operation_dim$field_operation_seg_id int8 operation segment id reference to the field operational segment table
100
 sampling_start_hhmmss bpchar concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100
 drop_latitude_dim$latitude_compass_direction bpchar latitude compass direction
100
 site_dim$record_type varchar site record or reason record is unavailable
100
 swell_height_m numeric swell height in meters
100
 ctd_drop_time_dim$hour int2 standard representation of the hour
100
 date_dim$day_of_month int2 numeric representation of the day in month
100
 sea_surface_temp_c numeric sea surface temperature in degrees celcius
100
 operation_dim$scientist_2_person_whid int4 person reference for the second scientist
100
 drop_latitude_dim$latitude_degree_units int2 numeric representation of latitude that makes up the degree unit only
100
 drop_time_dim$second int2 number of seconds in the minute
100
 fish_info_note varchar overall fish information note
100
 date_yyyymmdd bpchar text representation of year month day
100
 drop_time_dim$period bpchar period of time
100
 ctd_drop_latitude_dim$named_parallel varchar name of parallel, boundary, or commonly used geograpical location
100
 site_moon_tide_dim$tide_type varchar tide type
100
 date_dim$year int4 numeric representation of year
100
 sunrise_time_dim$time time military time representation of the time
100
 ctd_drop_latitude_dim$latitude_degree_units int2 numeric representation of latitude that makes up the degree unit only
100
 site_dim$tide_station_longitude_whid int4 warehouse identifier to longitude details for site's nearest tide station
100
 operation_dim$scientist_1_person_whid int4 person reference for the first scientist
100
 sampling_end_time_dim$record_type varchar time record or reason record is unavailable
100
 first_bite_interval_sec int4 interval in seconds between gear deployment until angler feels first bite
100
 site_dim$tide_station_name varchar name of nearest tide station
100
 angler_person_dim$middle_initial bpchar middle initial of person
100
 drop_time_dim$military_hour int2 military representation of the hour
100
 sunset_time_dim$record_type varchar time record or reason record is unavailable
100
 ctd_drop_time_dim$time time military time representation of the time
100
 ctd_on_bottom_disolved_oxygen_sbe43_ml_per_l numeric CTD SBE43 sensor on bottom disolved oxygen measured in milliliters per liter
100
 at_surface_interval_sec int4 interval in seconds between gear deployment until gear reaches surface concluding the drop
100
 ctd_drop_time_dim$military_hour int2 military representation of the hour
100
 site_habitat_note varchar site habitat notes
100
 drop_latitude_dim$latitude_second_units int2 numeric representation of latitude that makes up the second unit only
100
 ctd_on_bottom_disolved_oxygen_aanderaa_ml_per_l numeric CTD aanderaa sensor on bottom disolved oxygen measured in milliliters per liter
100
 wave_height_ft numeric wave height in feet
100
 drop_longitude_dim$longitude_minute_units int2 numeric representation of longitude that makes up the minute unit only
100
 ctd_sounder_depth_dim$depth_meters numeric depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries)
100
 ctd_drop_longitude_dim$record_type varchar longitude record type or reason record is unavailable
100
 sampling_start_time_dim$period bpchar period of time
100
 drop_time_dim$time time military time representation of the time
100
 angler_person_dim$last_name varchar last name of person
100
 drop_latitude_dim$latitude_minute_units int2 numeric representation of latitude that makes up the minute unit only
100
 ctd_on_bottom_temp_c numeric CTD on bottom temperature in degrees celcius
100
 drop_latitude_dim$record_type varchar latitude record type or reason record is unavailable
100
 drop_longitude_dim$record_type varchar longitude record type or reason record is unavailable
100
 operation_dim$return_port_whid int4 port reference for return port
100
 sunrise_time_dim$hour int2 standard representation of the hour
100
 sampling_end_time_dim$minute int2 number of minutes in the hour
100
 tide_height_last_m numeric tide height at last (fifth) drop for a site measured in meters
100
 ctd_drop_time_dim$hh24miss bpchar concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100
 operation_dim$trip_id int4 trip identifier number
100
 project varchar project name
100
 ctd_sounder_depth_dim$record_type varchar depth record or reason record is unavailable
100
 ctd_drop_longitude_dim$longitude_in_degree_minute_second varchar string representation of longitude in degrees, minutes, and seconds for example 4525'01"
100
 ctd_sounder_depth_dim$boundary_indicator varchar depth boundry indicator identifying ifp boundary marks
100
 drop_sounder_depth_dim$record_type varchar depth record or reason record is unavailable
100
 drop_longitude_dim$longitude_degree_units int2 numeric representation of longitude that makes up the degree unit only
100
 tow int2 operation number of the survey
100
 ctd_drop_longitude_dim$longitude_in_degrees numeric numeric representation of longitude in decimal degrees
100
 ctd_drop_time_dim$record_type varchar time record or reason record is unavailable
100
 date_whid int4 warehouse identifier for date
100
 sunset_time_dim$military_hour int2 military representation of the hour
100
 on_bottom_interval_sec int4 interval in seconds between gear deployment until it hits bottom
100
 site_dim$site_latitude_dd numeric site latitude in decimal degrees
100
 ctd_drop_longitude_dd numeric high precision value for CTD drop longitude in decimal degrees
100
 ctd_sounder_depth_dim$depth_fathoms numeric depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries
100
 drop_longitude_dd numeric drop longitude in decimal degrees
100
 hook_dim$hook_result varchar The result of using the hook
100
 operation_dim$operation_end_time_whid int8 end time reference for the operation
100
 drop_sounder_depth_dim$depth_fathoms numeric depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries
100
 sampling_end_time_dim$second int2 number of seconds in the minute
100
 operation_dim$departure_date_whid int8 date reference that vessel departed for the defined leg or trip
100
 sunset_time_dim$hour int2 standard representation of the hour
100
 sampling_start_time_dim$record_type varchar time record or reason record is unavailable
100
 sunset_time_dim$minute int2 number of minutes in the hour
100
 ctd_drop_latitude_dim$latitude_in_degrees numeric numeric representation of latitude in degrees
100
 site_dim$site_latitude_whid int4 warehouse identifier to latitude details for site
100
 drop_detail_note varchar drop detail notes
100
 sunset_time_dim$hh24miss bpchar concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100
 drop_time_dim$minute int2 number of minutes in the hour
100
 inclusion_dim$hook_inclusion_indicator varchar indicates if hook should be included
100
 sunrise_time_dim$period bpchar period of time
100
 ctd_drop_latitude_dim$latitude_second_units int2 numeric representation of latitude that makes up the second unit only
100
 sampling_start_time_dim$minute int2 number of minutes in the hour
100
 ctd_on_bottom_measure_depth_m numeric CTD on bottom measured depth in meters
100
 operation_dim$vessel_id int2 field database vessel id number
100
 drop_longitude_whid int4 warehouse identifier for drop latitude
100
 operation_dim$return_date_whid int8 date reference that vessel returned for the defined leg or trip
100
 ctd_drop_latitude_dim$latitude_minute_units int2 numeric representation of latitude that makes up the minute unit only
100
 site_moon_tide_whid int2 warehouse identifier for site moon tide
100
 site_moon_tide_dim$moon_phase varchar moon phase
100
 ctd_sounder_depth_whid int4 warehouse identifier for CTD sounder depth
100
 ctd_drop_longitude_dim$longitude_degree_units int2 numeric representation of longitude that makes up the degree unit only
100
 site_fish_finder_note varchar site fish finder notes
100
 year int2 operation year
100
 ctd_drop_latitude_dim$latitude_in_degree_minute_second varchar string representation of latitude in degrees, minutes, and seconds for example 4525'01"
100
 sampling_end_time_whid int4 warehouse identifier for the sampling end time
100
 sampling_start_time_whid int4 warehouse identifier for the sampling start time
100
 full_moon_pct int2 percent of full moon
100
 trawl_id int8 identifier for a sampling operation

Attribute Details

vessel

CC ID: 377933
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

name of the vessel used for the operation
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

net_touchdown_time

CC ID: 377934
Data Storage Type: time
Required: No
Primary Key: No
Status: Active
Description:

military time representation of the time

site_dim$distance_to_port_nm

CC ID: 377935
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 1
Status: Active
Description:

distance from site to nearest port in nautical miles
Unit of Measure: m

ctd_drop_latitude_whid

CC ID: 377936
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for CTD drop latitude

drop_sounder_depth_dim$depth_meters

CC ID: 377937
Data Storage Type: numeric
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)
Unit of Measure: m
Allowed Values: 0-1500

angler_person_dim$full_name

CC ID: 377938
Data Storage Type: varchar
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

full name in format of First and Last (Suffix)

ctd_drop_longitude_dim$longitude_compass_direction

CC ID: 377939
Data Storage Type: bpchar
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

longitude compass direction
Allowed Values: E, W

ctd_on_bottom_measure_depth_dim$record_type

CC ID: 377940
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

depth record or reason record is unavailable
Allowed Values: Depth, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

sampling_end_time_dim$period

CC ID: 377941
Data Storage Type: bpchar
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

period of time
Allowed Values: AM, PM

tide_height_mid_ft

CC ID: 377942
Data Storage Type: numeric
Max Length: 4
Required: No
Primary Key: No
Precision: 1
Status: Active
Description:

tide height at middle (third) drop for a site measured in feet
Unit of Measure: ft

site_dim$site_number

CC ID: 377943
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

site identifier number

drop_latitude_dim$named_parallel

CC ID: 377944
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

name of parallel, boundary, or commonly used geograpical location
Unit of Measure: NA
Allowed Values: any

operation_dim$state_registration_number

CC ID: 377945
Data Storage Type: varchar
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

state registration number for the vessel

operation_dim$limited_entry_permit_number

CC ID: 377946
Data Storage Type: bpchar
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

date_dim$record_type

CC ID: 377947
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

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

ctd_drop_latitude_dim$latitude_compass_direction

CC ID: 377948
Data Storage Type: bpchar
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

latitude compass direction
Unit of Measure: NA
Allowed Values: N, S

drop_longitude_dim$longitude_in_degrees

CC ID: 377949
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 8
Status: Active
Description:

numeric representation of longitude in decimal degrees
Unit of Measure: dd
Allowed Values: -180 to 180

ctd_on_bottom_salinity_psu

CC ID: 377950
Data Storage Type: numeric
Max Length: 6
Required: No
Primary Key: No
Precision: 2
Status: Active
Description:

CTD on bottom salinity in practical salinity units (psu)
Unit of Measure: psu

hook_dim$record_type

CC ID: 377951
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

hook record or reason record is unavailable
Allowed Values: Hook, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

ctd_drop_longitude_dim$longitude_minute_units

CC ID: 377952
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of longitude that makes up the minute unit only
Unit of Measure: min
Allowed Values: 0-59

marine_reserve_indicator

CC ID: 377953
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

identifier if the hook was inside a marine reserve
Allowed Values: Is Marine Reserve, Not Marine Reserve, NA

operation_dim$scientist_3_person_whid

CC ID: 377954
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

person reference for the third scientist

hook_id

CC ID: 377955
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

field database hook identifier

angler_person_whid

CC ID: 377956
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for angler person

tide_height_first_ft

CC ID: 377957
Data Storage Type: numeric
Max Length: 4
Required: No
Primary Key: No
Precision: 1
Status: Active
Description:

tide height at first drop for a site measured in feet
Unit of Measure: ft

ctd_on_bottom_measure_depth_whid

CC ID: 377958
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for CTD on bottom measure depth

ctd_on_bottom_measure_depth_dim$depth_fathoms

CC ID: 377959
Data Storage Type: numeric
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
Unit of Measure: fth

sunset_time_whid

CC ID: 377960
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for the sunset time

site_whid

CC ID: 377961
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for site

drop_sounder_depth_whid

CC ID: 377962
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for drop sounder depth

drop_longitude_dim$longitude_second_units

CC ID: 377963
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of longitude that makes up the second unit only
Unit of Measure: sec
Allowed Values: 0-59

site_moon_tide_dim$tide_phase

CC ID: 377964
Data Storage Type: varchar
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

tide phase
Allowed Values: Ebb, Flood, Steady

angler_person_dim$nick_name

CC ID: 377965
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

nickname of person

sunrise_time_dim$minute

CC ID: 377966
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

number of minutes in the hour
Unit of Measure: min
Allowed Values: 0-60

site_dim$tide_station_latitude_whid

CC ID: 377967
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier to latitude details for site's nearest tide station

operation_dim$operation_start_date_whid

CC ID: 377968
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

start date reference for the operation

begin_retrieval_interval_sec

CC ID: 377969
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

interval in seconds between gear deployment until gear retrieval began
Unit of Measure: sec

program

CC ID: 377970
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

type of fram program
Allowed Values: Bottom Trawl, Hook and Line

date_dim$month_of_year

CC ID: 377971
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of month of year
Allowed Values: 1-12

operation_dim$captain_person_whid

CC ID: 377972
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

person reference for the vessel captain

tide_height_last_ft

CC ID: 377973
Data Storage Type: numeric
Max Length: 4
Required: No
Primary Key: No
Precision: 1
Status: Active
Description:

tide height at last (fifth) drop for a site measured in feet
Unit of Measure: ft

set_identifier

CC ID: 377974
Data Storage Type: varchar
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

set identifier

inclusion_whid

CC ID: 377975
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for what to include in analysis

operation_dim$fpc_person_whid

CC ID: 377976
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

person reference for the FPC

operation_dim$record_type

CC ID: 377977
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

operation record or reason record is unavailable
Allowed Values: Operation, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

sampling_start_time_dim$military_hour

CC ID: 377978
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

military representation of the hour
Allowed Values: 0-24

angler_person_dim$role

CC ID: 377979
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

role taken during an operation
Allowed Values: Captain, 2nd Captain, FPC, Cook, Scientist, Deck Hand

drop_latitude_dim$latitude_in_degree_minute_second

CC ID: 377980
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

string representation of latitude in degrees, minutes, and seconds for example 4525'01"
Unit of Measure: NA
Allowed Values: any

ctd_drop_time_dim$period

CC ID: 377981
Data Storage Type: bpchar
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

period of time
Allowed Values: AM, PM

ctd_on_bottom_measure_depth_dim$depth_meters

CC ID: 377982
Data Storage Type: numeric
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)
Unit of Measure: m
Allowed Values: 0-1500

operation_dim$operation_type

CC ID: 377983
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

type of operation
Allowed Values: CTD Cast, Drop, Experiment, Search, Trawl, VPR Tow, [null]

swell_height_ft

CC ID: 377984
Data Storage Type: numeric
Max Length: 4
Required: No
Primary Key: No
Precision: 1
Status: Active
Description:

swell height in feet
Unit of Measure: ft

operation_dim$ifq_account_number

CC ID: 377985
Data Storage Type: varchar
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

unique number assigned to user accounts in the Vessel Accounting Database

sunrise_time_dim$record_type

CC ID: 377986
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

time record or reason record is unavailable
Allowed Values: Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

sampling_end_time_dim$hour

CC ID: 377987
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

standard representation of the hour
Unit of Measure: hr
Allowed Values: 0-12

inclusion_dim$record_type

CC ID: 377988
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

inclusion record or reason record is unavailable
Allowed Values: Inclusion, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

sinker_weight_lbs

CC ID: 377989
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

sinker weights in pounds
Unit of Measure: lbs

inclusion_dim$site_inclusion_indicator

CC ID: 377990
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

indicates if site should be included
Allowed Values: Include Site, Do Not Include Site, NA

operation_dim$operation_end_date_whid

CC ID: 377991
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

end date reference for the operation

sampling_start_time_dim$second

CC ID: 377992
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

number of seconds in the minute
Unit of Measure: sec
Allowed Values: 0-60

site_dim$tide_station_noaa_id

CC ID: 377993
Data Storage Type: varchar
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

tide station id according to NOAA's Tides and Currents site

tide_height_mid_m

CC ID: 377994
Data Storage Type: numeric
Max Length: 8
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

tide height at middle (third) drop for a site measured in meters
Unit of Measure: m

sunset_time_dim$second

CC ID: 377995
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

number of seconds in the minute
Unit of Measure: sec
Allowed Values: 0-60

site_general_note

CC ID: 377996
Data Storage Type: varchar
Max Length: 1000
Required: No
Primary Key: No
Status: Active
Description:

site general notes

drop_longitude_dim$longitude_compass_direction

CC ID: 377997
Data Storage Type: bpchar
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

longitude compass direction
Allowed Values: E, W

wave_height_m

CC ID: 377998
Data Storage Type: numeric
Max Length: 8
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

wave height in meters
Unit of Measure: m

hook_note

CC ID: 377999
Data Storage Type: varchar
Max Length: 1000
Required: No
Primary Key: No
Status: Active
Description:

hook notes

site_moon_tide_dim$record_type

CC ID: 378000
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

moon tide record or reason record is unavailable
Allowed Values: Moon_Tide, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

operation_dim$scientist_4_person_whid

CC ID: 378001
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

person reference for the fourth scientist

drop_average_sea_surface_temp_c

CC ID: 378002
Data Storage Type: numeric
Max Length: 4
Required: No
Primary Key: No
Precision: 1
Status: Active
Description:

drop average sea surface temperature in degrees celcius
Unit of Measure: c

ctd_drop_time_whid

CC ID: 378003
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for CTD drop time

tow_end_timestamp

CC ID: 378004
Data Storage Type: timestamp
Required: No
Primary Key: No
Status: Active
Description:

operation end date timestamp

site_dim$inactive_date_whid

CC ID: 378005
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for the date when the site went inactive

tide_height_first_m

CC ID: 378006
Data Storage Type: numeric
Max Length: 8
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

tide height at first drop for a site measured in meters
Unit of Measure: m

angler_person_dim$record_type

CC ID: 378007
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

person record or reason record is unavailable
Allowed Values: Person, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

pass

CC ID: 378008
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

pass number of the survey
Allowed Values: 1,2,3,4

tow_start_timestamp

CC ID: 378009
Data Storage Type: timestamp
Required: No
Primary Key: No
Status: Active
Description:

operation start date timestamp

ctd_on_bottom_measure_depth_dim$boundary_indicator

CC ID: 378010
Data Storage Type: varchar
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

depth boundry indicator identifying ifp boundary marks
Allowed Values: IFP Boundary Depth, Standard Contour Depth, NA

ctd_drop_time_dim$minute

CC ID: 378011
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

number of minutes in the hour
Unit of Measure: min
Allowed Values: 0-60

sunrise_time_whid

CC ID: 378012
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for the sunrise time

drop_time_dim$record_type

CC ID: 378013
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

time record or reason record is unavailable
Allowed Values: Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

drop_latitude_dim$latitude_in_degrees

CC ID: 378014
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 8
Status: Active
Description:

numeric representation of latitude in degrees
Unit of Measure: dd
Allowed Values: -90 to 90

site_dim$cdfgblock

CC ID: 378015
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

CDFG Block Numbers that the sites fall within

operation_dim$coast_guard_number

CC ID: 378016
Data Storage Type: varchar
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Coast Guard documentation number of vessel

operation_dim$operation_start_time_whid

CC ID: 378017
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

start time reference for the operation

site_dim$area_name

CC ID: 378018
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

name of area site is located in

time_to_first_bite_interval_sec

CC ID: 378019
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

interval in seconds calculated from the difference between first bite and on bottom
Unit of Measure: sec

date_dim$full_date

CC ID: 378020
Data Storage Type: timestamp
Required: No
Primary Key: No
Status: Active
Description:

full date value

sunrise_time_dim$hh24miss

CC ID: 378021
Data Storage Type: bpchar
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

concatenation of military hour, minute, second, example 230415 equates to 23:04:15

site_dim$site_longitude_whid

CC ID: 378022
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier to longitude details for site

site_dim$cowcod_conservation_area_indicator

CC ID: 378023
Data Storage Type: varchar
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

indicates if site falls within the cowcod conservation area
Allowed Values: Inside_Cowcod_Conservancy_Area, Outside_Cowcod_Conservancy_Area.

hook_dim$gear_performance

CC ID: 378024
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Gear performance
Allowed Values: No Problems, Lost Sinker, Minor Tangle, Major Tangle, Lost Gangion, Lost Hook(s), Missing Time, Multiple Hook, Gear Not Deployed

inclusion_dim$drop_inclusion_indicator

CC ID: 378025
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

indicates if drop should be included
Allowed Values: Include Drop, Do Not Include Drop, NA

sampling_end_time_dim$military_hour

CC ID: 378026
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

military representation of the hour
Allowed Values: 0-24

fishing_time_interval_sec

CC ID: 378027
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

interval in seconds calculated from the difference between begin retrieval and on bottomv
Unit of Measure: sec

ctd_drop_longitude_dim$longitude_second_units

CC ID: 378028
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of longitude that makes up the second unit only
Unit of Measure: sec
Allowed Values: 0-59

sunset_time_dim$period

CC ID: 378029
Data Storage Type: bpchar
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

period of time
Allowed Values: AM, PM

hook_whid

CC ID: 378030
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier to hook details

swell_direction_mag

CC ID: 378031
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

swell direction in magnetic degrees
Unit of Measure: mag

net_liftoff_time

CC ID: 378032
Data Storage Type: time
Required: No
Primary Key: No
Status: Active
Description:

military time representation of the time

leg

CC ID: 378033
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

leg number of the survey
Allowed Values: 1,2,3,4,5,6,7,8

hook_dim$hook_number

CC ID: 378034
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

The hook number on the line
Allowed Values: 1-5

site_dim$site_longitude_dd

CC ID: 378035
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 6
Status: Active
Description:

site longitude in decimal degrees
Unit of Measure: dd

operation_dim$observer_program

CC ID: 378036
Data Storage Type: varchar
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

description of the observer program

drop_timestamp

CC ID: 378037
Data Storage Type: timestamp
Required: No
Primary Key: No
Status: Active
Description:

drop timestamp

drop_sounder_depth_dim$boundary_indicator

CC ID: 378038
Data Storage Type: varchar
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

depth boundry indicator identifying ifp boundary marks
Allowed Values: IFP Boundary Depth, Standard Contour Depth, NA

drop_latitude_dd

CC ID: 378039
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 6
Status: Active
Description:

drop latitude in decimal degrees
Unit of Measure: dd

drop_time_dim$hour

CC ID: 378040
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

standard representation of the hour
Unit of Measure: hr
Allowed Values: 0-12

date_dim$month_name

CC ID: 378041
Data Storage Type: varchar
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

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

sunset_time_dim$time

CC ID: 378042
Data Storage Type: time
Required: No
Primary Key: No
Status: Active
Description:

military time representation of the time

sampling_start_time_dim$hour

CC ID: 378043
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

standard representation of the hour
Unit of Measure: hr
Allowed Values: 0-12

drop_latitude_whid

CC ID: 378044
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for drop latitude

ctd_drop_latitude_dim$record_type

CC ID: 378045
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

latitude record type or reason record is unavailable
Unit of Measure: NA
Allowed Values: Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

ctd_drop_time_dim$second

CC ID: 378046
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

number of seconds in the minute
Unit of Measure: sec
Allowed Values: 0-60

drop_longitude_dim$longitude_in_degree_minute_second

CC ID: 378047
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

string representation of longitude in degrees, minutes, and seconds for example 4525'01"

operation_dim_whid

CC ID: 378048
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for operation

angler_position

CC ID: 378049
Data Storage Type: varchar
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

position of angler on vessel
Allowed Values: Bow (a), Mid-ship (b), Stern (c)

sunrise_time_dim$military_hour

CC ID: 378050
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

military representation of the hour
Allowed Values: 0-24

sunrise_time_dim$second

CC ID: 378051
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

number of seconds in the minute
Unit of Measure: sec
Allowed Values: 0-60

performance

CC ID: 378052
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

performance of the operation
Allowed Values: Insufficient Information, Indeterminate, Satisfactory, Trawlable, Untrawlable, Unsatisfactory, [null]

ctd_sounder_depth_m

CC ID: 378053
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

CTD sounder depth in meters
Unit of Measure: m

date_dim$month_abbrev

CC ID: 378054
Data Storage Type: bpchar
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

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

ctd_drop_longitude_whid

CC ID: 378055
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for CTD drop longitude

drop_time_dim$hh24miss

CC ID: 378056
Data Storage Type: bpchar
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

concatenation of military hour, minute, second, example 230415 equates to 23:04:15

ctd_drop_latitude_dd

CC ID: 378057
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 6
Status: Active
Description:

high precision value for CTD drop latitude in decimal degrees
Unit of Measure: dd

site_ocean_weather_note

CC ID: 378058
Data Storage Type: varchar
Max Length: 1000
Required: No
Primary Key: No
Status: Active
Description:

site's ocean and weather notes

drop_time_whid

CC ID: 378059
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for the drop time

operation_dim$departure_port_whid

CC ID: 378060
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

port reference for the departure port

angler_person_dim$first_name

CC ID: 378061
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

first name of person

sampling_end_hhmmss

CC ID: 378062
Data Storage Type: bpchar
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

concatenation of military hour, minute, second, example 230415 equates to 23:04:15

operation_dim$field_operation_seg_id

CC ID: 378063
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

operation segment id reference to the field operational segment table

sampling_start_hhmmss

CC ID: 378064
Data Storage Type: bpchar
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

concatenation of military hour, minute, second, example 230415 equates to 23:04:15

drop_latitude_dim$latitude_compass_direction

CC ID: 378065
Data Storage Type: bpchar
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

latitude compass direction
Unit of Measure: NA
Allowed Values: N, S

site_dim$record_type

CC ID: 378066
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

site record or reason record is unavailable
Allowed Values: Site, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

swell_height_m

CC ID: 378067
Data Storage Type: numeric
Max Length: 8
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

swell height in meters
Unit of Measure: m

ctd_drop_time_dim$hour

CC ID: 378068
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

standard representation of the hour
Unit of Measure: hr
Allowed Values: 0-12

date_dim$day_of_month

CC ID: 378069
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of the day in month
Allowed Values: 1-31

sea_surface_temp_c

CC ID: 378070
Data Storage Type: numeric
Max Length: 6
Required: No
Primary Key: No
Precision: 2
Status: Active
Description:

sea surface temperature in degrees celcius
Unit of Measure: c

operation_dim$scientist_2_person_whid

CC ID: 378071
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

person reference for the second scientist

drop_latitude_dim$latitude_degree_units

CC ID: 378072
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of latitude that makes up the degree unit only
Unit of Measure: deg
Allowed Values: -90 to 90

drop_time_dim$second

CC ID: 378073
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

number of seconds in the minute
Unit of Measure: sec
Allowed Values: 0-60

fish_info_note

CC ID: 378074
Data Storage Type: varchar
Max Length: 1000
Required: No
Primary Key: No
Status: Active
Description:

overall fish information note

date_yyyymmdd

CC ID: 378075
Data Storage Type: bpchar
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

text representation of year month day

drop_time_dim$period

CC ID: 378076
Data Storage Type: bpchar
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

period of time
Allowed Values: AM, PM

ctd_drop_latitude_dim$named_parallel

CC ID: 378077
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

name of parallel, boundary, or commonly used geograpical location
Unit of Measure: NA
Allowed Values: any

site_moon_tide_dim$tide_type

CC ID: 378078
Data Storage Type: varchar
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

tide type
Allowed Values: Spring, Neap, Neither

date_dim$year

CC ID: 378079
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of year
Allowed Values: 1978+

sunrise_time_dim$time

CC ID: 378080
Data Storage Type: time
Required: No
Primary Key: No
Status: Active
Description:

military time representation of the time

ctd_drop_latitude_dim$latitude_degree_units

CC ID: 378081
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of latitude that makes up the degree unit only
Unit of Measure: deg
Allowed Values: -90 to 90

site_dim$tide_station_longitude_whid

CC ID: 378082
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier to longitude details for site's nearest tide station

operation_dim$scientist_1_person_whid

CC ID: 378083
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

person reference for the first scientist

sampling_end_time_dim$record_type

CC ID: 378084
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

time record or reason record is unavailable
Allowed Values: Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

first_bite_interval_sec

CC ID: 378085
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

interval in seconds between gear deployment until angler feels first bite
Unit of Measure: sec

site_dim$tide_station_name

CC ID: 378086
Data Storage Type: varchar
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

name of nearest tide station

angler_person_dim$middle_initial

CC ID: 378087
Data Storage Type: bpchar
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

middle initial of person

drop_time_dim$military_hour

CC ID: 378088
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

military representation of the hour
Allowed Values: 0-24

sunset_time_dim$record_type

CC ID: 378089
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

time record or reason record is unavailable
Allowed Values: Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

ctd_drop_time_dim$time

CC ID: 378090
Data Storage Type: time
Required: No
Primary Key: No
Status: Active
Description:

military time representation of the time

ctd_on_bottom_disolved_oxygen_sbe43_ml_per_l

CC ID: 378091
Data Storage Type: numeric
Max Length: 6
Required: No
Primary Key: No
Precision: 2
Status: Active
Description:

CTD SBE43 sensor on bottom disolved oxygen measured in milliliters per liter
Unit of Measure: ml/l

at_surface_interval_sec

CC ID: 378092
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

interval in seconds between gear deployment until gear reaches surface concluding the drop
Unit of Measure: sec

ctd_drop_time_dim$military_hour

CC ID: 378093
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

military representation of the hour
Allowed Values: 0-24

site_habitat_note

CC ID: 378094
Data Storage Type: varchar
Max Length: 1000
Required: No
Primary Key: No
Status: Active
Description:

site habitat notes

drop_latitude_dim$latitude_second_units

CC ID: 378095
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of latitude that makes up the second unit only
Unit of Measure: sec
Allowed Values: 0-60

ctd_on_bottom_disolved_oxygen_aanderaa_ml_per_l

CC ID: 378096
Data Storage Type: numeric
Max Length: 6
Required: No
Primary Key: No
Precision: 2
Status: Active
Description:

CTD aanderaa sensor on bottom disolved oxygen measured in milliliters per liter
Unit of Measure: ml/l

wave_height_ft

CC ID: 378097
Data Storage Type: numeric
Max Length: 4
Required: No
Primary Key: No
Precision: 1
Status: Active
Description:

wave height in feet
Unit of Measure: ft

drop_longitude_dim$longitude_minute_units

CC ID: 378098
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of longitude that makes up the minute unit only
Unit of Measure: min
Allowed Values: 0-59

ctd_sounder_depth_dim$depth_meters

CC ID: 378099
Data Storage Type: numeric
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)
Unit of Measure: m
Allowed Values: 0-1500

ctd_drop_longitude_dim$record_type

CC ID: 378100
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

longitude record type or reason record is unavailable
Allowed Values: Longitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

sampling_start_time_dim$period

CC ID: 378101
Data Storage Type: bpchar
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

period of time
Allowed Values: AM, PM

drop_time_dim$time

CC ID: 378102
Data Storage Type: time
Required: No
Primary Key: No
Status: Active
Description:

military time representation of the time

angler_person_dim$last_name

CC ID: 378103
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

last name of person

drop_latitude_dim$latitude_minute_units

CC ID: 378104
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of latitude that makes up the minute unit only
Unit of Measure: min
Allowed Values: 0-60

ctd_on_bottom_temp_c

CC ID: 378105
Data Storage Type: numeric
Max Length: 6
Required: No
Primary Key: No
Precision: 2
Status: Active
Description:

CTD on bottom temperature in degrees celcius
Unit of Measure: c

drop_latitude_dim$record_type

CC ID: 378106
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

latitude record type or reason record is unavailable
Unit of Measure: NA
Allowed Values: Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

drop_longitude_dim$record_type

CC ID: 378107
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

longitude record type or reason record is unavailable
Allowed Values: Longitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

operation_dim$return_port_whid

CC ID: 378108
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

port reference for return port

sunrise_time_dim$hour

CC ID: 378109
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

standard representation of the hour
Unit of Measure: hr
Allowed Values: 0-12

sampling_end_time_dim$minute

CC ID: 378110
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

number of minutes in the hour
Unit of Measure: min
Allowed Values: 0-60

tide_height_last_m

CC ID: 378111
Data Storage Type: numeric
Max Length: 8
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

tide height at last (fifth) drop for a site measured in meters
Unit of Measure: m

ctd_drop_time_dim$hh24miss

CC ID: 378112
Data Storage Type: bpchar
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

concatenation of military hour, minute, second, example 230415 equates to 23:04:15

operation_dim$trip_id

CC ID: 378113
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

trip identifier number

project

CC ID: 378114
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

project name
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

ctd_sounder_depth_dim$record_type

CC ID: 378115
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

depth record or reason record is unavailable
Allowed Values: Depth, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

ctd_drop_longitude_dim$longitude_in_degree_minute_second

CC ID: 378116
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

string representation of longitude in degrees, minutes, and seconds for example 4525'01"

ctd_sounder_depth_dim$boundary_indicator

CC ID: 378117
Data Storage Type: varchar
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

depth boundry indicator identifying ifp boundary marks
Allowed Values: IFP Boundary Depth, Standard Contour Depth, NA

drop_sounder_depth_dim$record_type

CC ID: 378118
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

depth record or reason record is unavailable
Allowed Values: Depth, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

drop_longitude_dim$longitude_degree_units

CC ID: 378119
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of longitude that makes up the degree unit only
Unit of Measure: deg
Allowed Values: -180 to 180

tow

CC ID: 378120
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

operation number of the survey

ctd_drop_longitude_dim$longitude_in_degrees

CC ID: 378121
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 8
Status: Active
Description:

numeric representation of longitude in decimal degrees
Unit of Measure: dd
Allowed Values: -180 to 180

ctd_drop_time_dim$record_type

CC ID: 378122
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

time record or reason record is unavailable
Allowed Values: Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

date_whid

CC ID: 378123
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for date

sunset_time_dim$military_hour

CC ID: 378124
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

military representation of the hour
Allowed Values: 0-24

on_bottom_interval_sec

CC ID: 378125
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

interval in seconds between gear deployment until it hits bottom
Unit of Measure: sec

site_dim$site_latitude_dd

CC ID: 378126
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 6
Status: Active
Description:

site latitude in decimal degrees
Unit of Measure: dd

ctd_drop_longitude_dd

CC ID: 378127
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 6
Status: Active
Description:

high precision value for CTD drop longitude in decimal degrees
Unit of Measure: dd

ctd_sounder_depth_dim$depth_fathoms

CC ID: 378128
Data Storage Type: numeric
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
Unit of Measure: fth

drop_longitude_dd

CC ID: 378129
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 6
Status: Active
Description:

drop longitude in decimal degrees
Unit of Measure: dd

hook_dim$hook_result

CC ID: 378130
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

The result of using the hook
Allowed Values: No Bait On Hook, Bait Back On Hook, No Hook, Multiple Hook, Fish, Angler Did Not Drop

operation_dim$operation_end_time_whid

CC ID: 378131
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

end time reference for the operation

drop_sounder_depth_dim$depth_fathoms

CC ID: 378132
Data Storage Type: numeric
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
Unit of Measure: fth

sampling_end_time_dim$second

CC ID: 378133
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

number of seconds in the minute
Unit of Measure: sec
Allowed Values: 0-60

operation_dim$departure_date_whid

CC ID: 378134
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

date reference that vessel departed for the defined leg or trip

sunset_time_dim$hour

CC ID: 378135
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

standard representation of the hour
Unit of Measure: hr
Allowed Values: 0-12

sampling_start_time_dim$record_type

CC ID: 378136
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

time record or reason record is unavailable
Allowed Values: Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

sunset_time_dim$minute

CC ID: 378137
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

number of minutes in the hour
Unit of Measure: min
Allowed Values: 0-60

ctd_drop_latitude_dim$latitude_in_degrees

CC ID: 378138
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 8
Status: Active
Description:

numeric representation of latitude in degrees
Unit of Measure: dd
Allowed Values: -90 to 90

site_dim$site_latitude_whid

CC ID: 378139
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier to latitude details for site

drop_detail_note

CC ID: 378140
Data Storage Type: varchar
Max Length: 1000
Required: No
Primary Key: No
Status: Active
Description:

drop detail notes

sunset_time_dim$hh24miss

CC ID: 378141
Data Storage Type: bpchar
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

concatenation of military hour, minute, second, example 230415 equates to 23:04:15

drop_time_dim$minute

CC ID: 378142
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

number of minutes in the hour
Unit of Measure: min
Allowed Values: 0-60

inclusion_dim$hook_inclusion_indicator

CC ID: 378143
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

indicates if hook should be included
Allowed Values: Include Hook, Do Not Include Hook, NA

sunrise_time_dim$period

CC ID: 378144
Data Storage Type: bpchar
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

period of time
Allowed Values: AM, PM

ctd_drop_latitude_dim$latitude_second_units

CC ID: 378145
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of latitude that makes up the second unit only
Unit of Measure: sec
Allowed Values: 0-60

sampling_start_time_dim$minute

CC ID: 378146
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

number of minutes in the hour
Unit of Measure: min
Allowed Values: 0-60

ctd_on_bottom_measure_depth_m

CC ID: 378147
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

CTD on bottom measured depth in meters
Unit of Measure: m

operation_dim$vessel_id

CC ID: 378148
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

field database vessel id number

drop_longitude_whid

CC ID: 378149
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for drop latitude

operation_dim$return_date_whid

CC ID: 378150
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

date reference that vessel returned for the defined leg or trip

ctd_drop_latitude_dim$latitude_minute_units

CC ID: 378151
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of latitude that makes up the minute unit only
Unit of Measure: min
Allowed Values: 0-60

site_moon_tide_whid

CC ID: 378152
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for site moon tide

site_moon_tide_dim$moon_phase

CC ID: 378153
Data Storage Type: varchar
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

moon phase
Allowed Values: New Moon, Waxing Crescent, First Quarter, Waxing Gibbous, Waning Gibbous, Third Quarter, Waning Crescent, Full Moon

ctd_sounder_depth_whid

CC ID: 378154
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for CTD sounder depth

ctd_drop_longitude_dim$longitude_degree_units

CC ID: 378155
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of longitude that makes up the degree unit only
Unit of Measure: deg
Allowed Values: -180 to 180

site_fish_finder_note

CC ID: 378156
Data Storage Type: varchar
Max Length: 1000
Required: No
Primary Key: No
Status: Active
Description:

site fish finder notes

year

CC ID: 378157
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

operation year
Unit of Measure: year
Allowed Values: 2007+

ctd_drop_latitude_dim$latitude_in_degree_minute_second

CC ID: 378158
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

string representation of latitude in degrees, minutes, and seconds for example 4525'01"
Unit of Measure: NA
Allowed Values: any

sampling_end_time_whid

CC ID: 378159
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for the sampling end time

sampling_start_time_whid

CC ID: 378160
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for the sampling start time

full_moon_pct

CC ID: 378161
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

percent of full moon

trawl_id

CC ID: 378162
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

identifier for a sampling operation

Catalog Details

Catalog Item ID: 36442
GUID: gov.noaa.nmfs.inport:36442
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2017-01-25 13:19+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2017-02-13
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2017-02-13
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2018-02-13