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... >

catch_hooknline_view

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

Summary

Description

Detail and aggregate catch data given a date at a site and species caught

Entity Information

Entity Type
Data View

Data Attribute / Type Description
vessel
varchar 		name of the vessel used for the operation
best_available_taxonomy_dim$structure_source
varchar 		Source of the taxonomic structure
ctd_drop_time_dim$hour
int2 		standard representation of the hour
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
best_available_taxonomy_dim$genus_70
varchar 		genus name
ctd_drop_latitude_whid
int4 		warehouse identifier for CTD drop latitude
species_category
varchar 		upper-level taxonomic ranking
best_available_taxonomy_dim$subfamily_52
varchar 		subfamily name
scientist_1_person_dim$full_name
varchar 		full name in format of First and Last (Suffix)
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
fpc_person_whid
int4 		warehouse identifier for the FPC
site_dim$site_number
int4 		site identifier number
best_available_taxonomy_dim$itis_taxonomic_serial_no
int4 		ITIS taxonomic identifier
scientist_2_person_whid
int4 		warehouse identifier for the second scientist
best_available_taxonomy_dim$grp_nonstandard_taxon_99
varchar 		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
date_dim$record_type
varchar 		date, month, or year record or reason record is unavailable
tide_height_last_ft
numeric 		tide height at last (fifth) drop for a site measured in feet
captain_person_dim$first_name
varchar 		first name of person
ctd_drop_latitude_dim$latitude_compass_direction
bpchar 		latitude compass direction
best_available_taxonomy_dim$superfamily_48
varchar 		superfamily name
departure_port_dim$state_abbrev
bpchar 		two letter state abbreviation
departure_port_dim$state_name
varchar 		state name
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
best_available_taxonomy_dim$acoustics_species_id
int4 		Species ID used in the acoustics program
best_available_taxonomy_dim$worms_aphiaid
int4 		WoRMS taxonomic identifier
scientist_1_person_whid
int4 		warehouse identifier for the first scientist
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
fpc_person_dim$role
varchar 		role taken during an operation
operation_type
varchar 		type of operation
captain_person_dim$last_name
varchar 		last name of person
fpc_person_dim$last_name
varchar 		last name of person
total_catch_numbers
int8 		a count off the number of species caught at a site
scientist_2_person_dim$full_name
varchar 		full name in format of First and Last (Suffix)
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
return_port_dim$state_abbrev
bpchar 		two letter state abbreviation
departure_port_dim$port_group_name
varchar 		port group name for observer program
fpc_person_dim$record_type
varchar 		person record or reason record is unavailable
best_available_taxonomy_dim$record_type
varchar 		record or reason record is unavailable
sunrise_time_dim$hour
int2 		standard representation of the hour
departure_port_whid
int4 		warehouse identifier for the departure port
ctd_sounder_depth_dim$record_type
varchar 		depth record or reason record is unavailable
best_available_taxonomy_dim$family_50
varchar 		family name
set_identifier
varchar 		set identifier
departure_port_dim$port_code
bpchar 		port code for observer program
best_available_taxonomy_dim$kingdom_10
varchar 		kingdom name
best_available_taxonomy_dim$class_30
varchar 		class name
sampling_start_hhmmss
bpchar 		concatenation of military hour, minute, second, example 230415 equates to 23:04:15
sampling_start_time_dim$military_hour
int2 		military representation of the hour
departure_port_dim$port_name_caps
varchar 		port name in all capitals format
pacfin_spid
varchar 		pacfin species id - many taxa may not have one of these
leg
int2 		leg number for the survey
return_port_dim$record_type
varchar 		port record or reason record is unavailable
return_port_dim$state_name
varchar 		state name
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)
ctd_on_bottom_salinity_psu
numeric 		CTD on bottom salinity in practical salinity units (psu)
best_available_taxonomy_dim$observer_species_id
int4 		species identifier used by the observer program
scientist_2_person_dim$last_name
varchar 		last name of person
sunrise_time_dim$record_type
varchar 		time record or reason record is unavailable
sampling_end_time_dim$record_type
varchar 		time record or reason record is unavailable
scientist_2_person_dim$record_type
varchar 		person record or reason record is unavailable
departure_port_dim$record_type
varchar 		port record or reason record is unavailable
sampling_start_time_dim$second
int2 		number of seconds in the minute
scientist_2_person_dim$middle_initial
bpchar 		middle initial of person
tide_height_mid_ft
numeric 		tide height at middle (third) drop for a site measured in feet
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
captain_person_dim$middle_initial
bpchar 		middle initial of person
site_general_note
varchar 		site general notes
captain_person_dim$role
varchar 		role taken during an operation
ctd_sounder_depth_dim$boundary_indicator
varchar 		depth boundry indicator identifying ifp boundary marks
sampling_end_time_whid
int4 		warehouse identifier for the sampling end time
ctd_drop_longitude_dim$longitude_compass_direction
bpchar 		longitude compass direction
best_available_taxonomy_dim$abbreviated_name
varchar 		specialized common name, generally for a well-known species of fish such as ATF, LST, SST
ctd_drop_time_whid
int4 		warehouse identifier for CTD drop time
site_dim$inactive_date_whid
int8 		warehouse identifier for the date when the site went inactive
scientist_2_person_dim$role
varchar 		role taken during an operation
tide_height_first_m
numeric 		tide height at first drop for a site measured in meters
return_port_dim$port_name_std
varchar 		port name in standard format
ctd_drop_time_dim$minute
int2 		number of minutes in the hour
best_available_taxonomy_dim$superorder_38
varchar 		superorder name
sunrise_time_whid
int4 		Warehouse identifier for the sunrise time
best_available_taxonomy_dim$hookandline_species_id
int4 		species identifier used by hook and line
return_port_dim$port_group_code
bpchar 		port group code for observer program
species_subcategory
varchar 		mid-level taxonomic ranking
site_dim$cdfgblock
int4 		CDFG Block Numbers that the sites fall within
date_dim$month_name
varchar 		text representation of month
sunrise_time_dim$military_hour
int2 		military representation of the hour
site_dim$area_name
varchar 		name of area site is located in
date_dim$full_date
timestamp 		full date value
swell_direction_mag
int2 		swell direction in magnetic degrees
site_dim$cowcod_conservation_area_indicator
varchar 		indicates if site falls within the cowcod conservation area
fpc_person_dim$full_name
varchar 		full name in format of First and Last (Suffix)
sampling_end_time_dim$military_hour
int2 		military representation of the hour
ctd_drop_latitude_dd
numeric 		high precision value for CTD drop latitude in decimal degrees
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
best_available_taxonomy_dim$phylum_20
varchar 		phylum name
best_available_taxonomy_dim$suborder_42
varchar 		suborder name
net_liftoff_time
time 		military time representation of the time
sampling_end_hhmmss
bpchar 		concatenation of military hour, minute, second, example 230415 equates to 23:04:15
ctd_drop_longitude_dim$record_type
varchar 		longitude record type or reason record is unavailable
cpue_normalized_catch_numbers
numeric 		a derived number of species caught at a site based off the number of valid hooks deployed at the site
best_available_taxonomy_dim$tribe_60
varchar 		tribe name
vessel_id
int2 		field database vessel id number
site_dim$site_longitude_dd
numeric 		site longitude in decimal degrees
best_available_taxonomy_dim$subclass_32
varchar 		subclass name
sunset_time_dim$time
time 		military time representation of the time
sampling_start_time_dim$hour
int2 		standard representation of the hour
ctd_drop_latitude_dim$record_type
varchar 		latitude record type or reason record is unavailable
scientist_1_person_dim$role
varchar 		role taken during an operation
departure_port_dim$port_group_code
bpchar 		port group code for observer program
scientist_1_person_dim$middle_initial
bpchar 		middle initial of person
site_whid
int4 		warehouse identifier to the site details
captain_person_whid
int4 		warehouse identifier for the vessel captain
best_available_taxonomy_dim$order_40
varchar 		order name
sunrise_time_dim$second
int2 		number of seconds in the minute
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
common_name
varchar 		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
scientific_name
varchar 		scientific name generally composed of the genus and species name and subspecies name if available, but may be the highest taxonomic level
sampling_start_time_dim$period
bpchar 		period of time
site_ocean_weather_note
varchar 		site's ocean and weather notes
best_available_taxonomy_dim$norpac_species_id
int4 		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.
total_catch_wt_kg
numeric 		a sum of the measured weights of a species caught at a site
swell_height_ft
numeric 		swell height in feet
best_available_taxonomy_dim$grp_reg_depth_category
varchar 		management grouping mostly for rockfishes (but could be assigned to any species): nearshore, shelf, or slope, or in future shallower shelf and deeper shelf
scientist_1_person_dim$last_name
varchar 		last name of person
site_dim$record_type
varchar 		site record or reason record is unavailable
return_port_whid
int4 		warehouse identifier for return port
swell_height_m
numeric 		swell height in meters
ctd_on_bottom_temp_c
numeric 		CTD on bottom temperature in degrees celcius
date_dim$day_of_month
int2 		numeric representation of the day in month
sea_surface_temp_c
numeric 		sea surface temperature in degrees celcius
departure_port_dim$port_name_std
varchar 		port name in standard format
ctd_drop_time_dim$period
bpchar 		period of time
fish_info_note
varchar 		overall fish information note
date_yyyymmdd
bpchar 		text representation of year month day
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
site_valid_hooks
int8 		a count of the number of valid hooks deployed at a site
ctd_on_bottom_measure_depth_dim$boundary_indicator
varchar 		depth boundry indicator identifying ifp boundary marks
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
fpc_person_dim$middle_initial
bpchar 		middle initial of person
project_name
varchar 		project name
ctd_sounder_depth_whid
int4 		warehouse identifier for CTD sounder depth
fram_program
varchar 		type of fram program
sampling_end_time_dim$hour
int2 		standard representation of the hour
site_dim$tide_station_name
varchar 		name of nearest tide station
scientist_2_person_dim$nick_name
varchar 		nickname of person
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
taxon_rank
varchar 		name of the lowest taxonomic level used to define scientific name
ctd_on_bottom_disolved_oxygen_sbe43_ml_per_l
numeric 		CTD SBE43 sensor on bottom disolved oxygen measured in milliliters per liter
fpc_person_dim$first_name
varchar 		first name of person
site_habitat_note
varchar 		site habitat notes
scientist_1_person_dim$first_name
varchar 		first name of person
ctd_on_bottom_disolved_oxygen_aanderaa_ml_per_l
numeric 		CTD aanderaa sensor on bottom disolved oxygen measured in milliliters per liter
fpc_person_dim$nick_name
varchar 		nickname of person
best_available_taxonomy_dim$superclass_28
varchar 		superclass name
ctd_drop_longitude_dim$longitude_in_degrees
numeric 		numeric representation of longitude in decimal degrees
ctd_sounder_depth_dim$depth_meters
numeric 		depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries)
site_dim$site_longitude_whid
int4 		warehouse identifier to longitude details for site
ctd_drop_time_dim$second
int2 		number of seconds in the minute
best_available_taxonomy_dim$infraclass_34
varchar 		infraclass name
best_available_taxonomy_dim$pacfin_nom_spid
varchar 		PacFIN nominal species identifier
best_available_taxonomy_dim$subphylum_22
varchar 		subphylum name
scientist_1_person_dim$record_type
varchar 		person record or reason record is unavailable
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
best_available_taxonomy_whid
int4 		warehouse identifier to best available taxonomy
ctd_drop_time_dim$military_hour
int2 		military representation of the hour
best_available_taxonomy_dim$trawl_survey_species_id
int4 		species identifier used by the trawl survey
wave_height_ft
numeric 		wave height in feet
ctd_drop_longitude_dim$longitude_in_degree_minute_second
varchar 		string representation of longitude in degrees, minutes, and seconds for example 4525'01"
scientist_1_person_dim$nick_name
varchar 		nickname of person
best_available_taxonomy_dim$infraorder_44
varchar 		infraorder name
return_port_dim$port_name_caps
varchar 		port name in all capitals format
ctd_drop_time_dim$record_type
varchar 		time record or reason record is unavailable
date_whid
int8 		warehouse identifier for date
site_dim$tide_station_noaa_id
varchar 		tide station id according to NOAA's Tides and Currents site
sunset_time_dim$military_hour
int2 		military representation of the hour
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
best_available_taxonomy_dim$species_80
varchar 		species name
tide_height_first_ft
numeric 		tide height at first drop for a site measured in feet
date_dim$month_of_year
int2 		numeric representation of month of year
sunset_time_whid
int4 		warehouse identifier for the sunset time
sampling_end_time_dim$second
int2 		number of seconds in the minute
sunrise_time_dim$hh24miss
bpchar 		concatenation of military hour, minute, second, example 230415 equates to 23:04:15
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
captain_person_dim$nick_name
varchar 		nickname of person
sunset_time_dim$hh24miss
bpchar 		concatenation of military hour, minute, second, example 230415 equates to 23:04:15
return_port_dim$port_code
bpchar 		port code for observer program
site_moon_tide_dim$tide_phase
varchar 		tide phase
sunrise_time_dim$period
bpchar 		period of time
return_port_dim$port_group_name
varchar 		port group name for observer program
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
scientist_2_person_dim$first_name
varchar 		first name of person
best_available_taxonomy_dim$subspecies_82
varchar 		subspecies name
captain_person_dim$record_type
varchar 		person record or reason record is unavailable
ctd_drop_latitude_dim$latitude_minute_units
int2 		numeric representation of latitude that makes up the minute unit only
site_dim$tide_station_longitude_whid
int4 		warehouse identifier to longitude details for site's nearest tide station
captain_person_dim$full_name
varchar 		full name in format of First and Last (Suffix)
site_moon_tide_whid
int2 		warehouse identifier for site moon tide
site_moon_tide_dim$moon_phase
varchar 		moon phase
wave_height_m
numeric 		wave height in meters
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
ctd_drop_latitude_dim$latitude_in_degree_minute_second
varchar 		string representation of latitude in degrees, minutes, and seconds for example 4525'01"
site_moon_tide_dim$record_type
varchar 		moon tide record or reason record is unavailable
sampling_start_time_whid
int4 		warehouse identifier for the sampling start time
full_moon_pct
int2 		percent of full moon

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_hooknline_view

Entity Information

Entity Type: Data View
Description:

Detail and aggregate catch data given a date at a site and species caught

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 vessel varchar name of the vessel used for the operation
100
 best_available_taxonomy_dim$structure_source varchar Source of the taxonomic structure
100
 ctd_drop_time_dim$hour int2 standard representation of the hour
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
 best_available_taxonomy_dim$genus_70 varchar genus name
100
 ctd_drop_latitude_whid int4 warehouse identifier for CTD drop latitude
100
 species_category varchar upper-level taxonomic ranking
100
 best_available_taxonomy_dim$subfamily_52 varchar subfamily name
100
 scientist_1_person_dim$full_name varchar full name in format of First and Last (Suffix)
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
 fpc_person_whid int4 warehouse identifier for the FPC
100
 site_dim$site_number int4 site identifier number
100
 best_available_taxonomy_dim$itis_taxonomic_serial_no int4 ITIS taxonomic identifier
100
 scientist_2_person_whid int4 warehouse identifier for the second scientist
100
 best_available_taxonomy_dim$grp_nonstandard_taxon_99 varchar 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
 date_dim$record_type varchar date, month, or year record or reason record is unavailable
100
 tide_height_last_ft numeric tide height at last (fifth) drop for a site measured in feet
100
 captain_person_dim$first_name varchar first name of person
100
 ctd_drop_latitude_dim$latitude_compass_direction bpchar latitude compass direction
100
 best_available_taxonomy_dim$superfamily_48 varchar superfamily name
100
 departure_port_dim$state_abbrev bpchar two letter state abbreviation
100
 departure_port_dim$state_name varchar state name
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
 best_available_taxonomy_dim$acoustics_species_id int4 Species ID used in the acoustics program
100
 best_available_taxonomy_dim$worms_aphiaid int4 WoRMS taxonomic identifier
100
 scientist_1_person_whid int4 warehouse identifier for the first scientist
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
 fpc_person_dim$role varchar role taken during an operation
100
 operation_type varchar type of operation
100
 captain_person_dim$last_name varchar last name of person
100
 fpc_person_dim$last_name varchar last name of person
100
 total_catch_numbers int8 a count off the number of species caught at a site
100
 scientist_2_person_dim$full_name varchar full name in format of First and Last (Suffix)
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
 return_port_dim$state_abbrev bpchar two letter state abbreviation
100
 departure_port_dim$port_group_name varchar port group name for observer program
100
 fpc_person_dim$record_type varchar person record or reason record is unavailable
100
 best_available_taxonomy_dim$record_type varchar record or reason record is unavailable
100
 sunrise_time_dim$hour int2 standard representation of the hour
100
 departure_port_whid int4 warehouse identifier for the departure port
100
 ctd_sounder_depth_dim$record_type varchar depth record or reason record is unavailable
100
 best_available_taxonomy_dim$family_50 varchar family name
100
 set_identifier varchar set identifier
100
 departure_port_dim$port_code bpchar port code for observer program
100
 best_available_taxonomy_dim$kingdom_10 varchar kingdom name
100
 best_available_taxonomy_dim$class_30 varchar class name
100
 sampling_start_hhmmss bpchar concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100
 sampling_start_time_dim$military_hour int2 military representation of the hour
100
 departure_port_dim$port_name_caps varchar port name in all capitals format
100
 pacfin_spid varchar pacfin species id - many taxa may not have one of these
100
 leg int2 leg number for the survey
100
 return_port_dim$record_type varchar port record or reason record is unavailable
100
 return_port_dim$state_name varchar state name
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
 ctd_on_bottom_salinity_psu numeric CTD on bottom salinity in practical salinity units (psu)
100
 best_available_taxonomy_dim$observer_species_id int4 species identifier used by the observer program
100
 scientist_2_person_dim$last_name varchar last name of person
100
 sunrise_time_dim$record_type varchar time record or reason record is unavailable
100
 sampling_end_time_dim$record_type varchar time record or reason record is unavailable
100
 scientist_2_person_dim$record_type varchar person record or reason record is unavailable
100
 departure_port_dim$record_type varchar port record or reason record is unavailable
100
 sampling_start_time_dim$second int2 number of seconds in the minute
100
 scientist_2_person_dim$middle_initial bpchar middle initial of person
100
 tide_height_mid_ft numeric tide height at middle (third) drop for a site measured in feet
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
 captain_person_dim$middle_initial bpchar middle initial of person
100
 site_general_note varchar site general notes
100
 captain_person_dim$role varchar role taken during an operation
100
 ctd_sounder_depth_dim$boundary_indicator varchar depth boundry indicator identifying ifp boundary marks
100
 sampling_end_time_whid int4 warehouse identifier for the sampling end time
100
 ctd_drop_longitude_dim$longitude_compass_direction bpchar longitude compass direction
100
 best_available_taxonomy_dim$abbreviated_name varchar specialized common name, generally for a well-known species of fish such as ATF, LST, SST
100
 ctd_drop_time_whid int4 warehouse identifier for CTD drop time
100
 site_dim$inactive_date_whid int8 warehouse identifier for the date when the site went inactive
100
 scientist_2_person_dim$role varchar role taken during an operation
100
 tide_height_first_m numeric tide height at first drop for a site measured in meters
100
 return_port_dim$port_name_std varchar port name in standard format
100
 ctd_drop_time_dim$minute int2 number of minutes in the hour
100
 best_available_taxonomy_dim$superorder_38 varchar superorder name
100
 sunrise_time_whid int4 Warehouse identifier for the sunrise time
100
 best_available_taxonomy_dim$hookandline_species_id int4 species identifier used by hook and line
100
 return_port_dim$port_group_code bpchar port group code for observer program
100
 species_subcategory varchar mid-level taxonomic ranking
100
 site_dim$cdfgblock int4 CDFG Block Numbers that the sites fall within
100
 date_dim$month_name varchar text representation of month
100
 sunrise_time_dim$military_hour int2 military representation of the hour
100
 site_dim$area_name varchar name of area site is located in
100
 date_dim$full_date timestamp full date value
100
 swell_direction_mag int2 swell direction in magnetic degrees
100
 site_dim$cowcod_conservation_area_indicator varchar indicates if site falls within the cowcod conservation area
100
 fpc_person_dim$full_name varchar full name in format of First and Last (Suffix)
100
 sampling_end_time_dim$military_hour int2 military representation of the hour
100
 ctd_drop_latitude_dd numeric high precision value for CTD drop latitude in decimal degrees
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
 best_available_taxonomy_dim$phylum_20 varchar phylum name
100
 best_available_taxonomy_dim$suborder_42 varchar suborder name
100
 net_liftoff_time time military time representation of the time
100
 sampling_end_hhmmss bpchar concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100
 ctd_drop_longitude_dim$record_type varchar longitude record type or reason record is unavailable
100
 cpue_normalized_catch_numbers numeric a derived number of species caught at a site based off the number of valid hooks deployed at the site
100
 best_available_taxonomy_dim$tribe_60 varchar tribe name
100
 vessel_id int2 field database vessel id number
100
 site_dim$site_longitude_dd numeric site longitude in decimal degrees
100
 best_available_taxonomy_dim$subclass_32 varchar subclass name
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
 ctd_drop_latitude_dim$record_type varchar latitude record type or reason record is unavailable
100
 scientist_1_person_dim$role varchar role taken during an operation
100
 departure_port_dim$port_group_code bpchar port group code for observer program
100
 scientist_1_person_dim$middle_initial bpchar middle initial of person
100
 site_whid int4 warehouse identifier to the site details
100
 captain_person_whid int4 warehouse identifier for the vessel captain
100
 best_available_taxonomy_dim$order_40 varchar order name
100
 sunrise_time_dim$second int2 number of seconds in the minute
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
 common_name varchar 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
 scientific_name varchar scientific name generally composed of the genus and species name and subspecies name if available, but may be the highest taxonomic level
100
 sampling_start_time_dim$period bpchar period of time
100
 site_ocean_weather_note varchar site's ocean and weather notes
100
 best_available_taxonomy_dim$norpac_species_id int4 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
 total_catch_wt_kg numeric a sum of the measured weights of a species caught at a site
100
 swell_height_ft numeric swell height in feet
100
 best_available_taxonomy_dim$grp_reg_depth_category varchar 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
 scientist_1_person_dim$last_name varchar last name of person
100
 site_dim$record_type varchar site record or reason record is unavailable
100
 return_port_whid int4 warehouse identifier for return port
100
 swell_height_m numeric swell height in meters
100
 ctd_on_bottom_temp_c numeric CTD on bottom temperature in degrees celcius
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
 departure_port_dim$port_name_std varchar port name in standard format
100
 ctd_drop_time_dim$period bpchar period of time
100
 fish_info_note varchar overall fish information note
100
 date_yyyymmdd bpchar text representation of year month day
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
 site_valid_hooks int8 a count of the number of valid hooks deployed at a site
100
 ctd_on_bottom_measure_depth_dim$boundary_indicator varchar depth boundry indicator identifying ifp boundary marks
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
 fpc_person_dim$middle_initial bpchar middle initial of person
100
 project_name varchar project name
100
 ctd_sounder_depth_whid int4 warehouse identifier for CTD sounder depth
100
 fram_program varchar type of fram program
100
 sampling_end_time_dim$hour int2 standard representation of the hour
100
 site_dim$tide_station_name varchar name of nearest tide station
100
 scientist_2_person_dim$nick_name varchar nickname of person
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
 taxon_rank varchar name of the lowest taxonomic level used to define scientific name
100
 ctd_on_bottom_disolved_oxygen_sbe43_ml_per_l numeric CTD SBE43 sensor on bottom disolved oxygen measured in milliliters per liter
100
 fpc_person_dim$first_name varchar first name of person
100
 site_habitat_note varchar site habitat notes
100
 scientist_1_person_dim$first_name varchar first name of person
100
 ctd_on_bottom_disolved_oxygen_aanderaa_ml_per_l numeric CTD aanderaa sensor on bottom disolved oxygen measured in milliliters per liter
100
 fpc_person_dim$nick_name varchar nickname of person
100
 best_available_taxonomy_dim$superclass_28 varchar superclass name
100
 ctd_drop_longitude_dim$longitude_in_degrees numeric numeric representation of longitude in decimal degrees
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
 site_dim$site_longitude_whid int4 warehouse identifier to longitude details for site
100
 ctd_drop_time_dim$second int2 number of seconds in the minute
100
 best_available_taxonomy_dim$infraclass_34 varchar infraclass name
100
 best_available_taxonomy_dim$pacfin_nom_spid varchar PacFIN nominal species identifier
100
 best_available_taxonomy_dim$subphylum_22 varchar subphylum name
100
 scientist_1_person_dim$record_type varchar person record or reason record is unavailable
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
 best_available_taxonomy_whid int4 warehouse identifier to best available taxonomy
100
 ctd_drop_time_dim$military_hour int2 military representation of the hour
100
 best_available_taxonomy_dim$trawl_survey_species_id int4 species identifier used by the trawl survey
100
 wave_height_ft numeric wave height in feet
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
 scientist_1_person_dim$nick_name varchar nickname of person
100
 best_available_taxonomy_dim$infraorder_44 varchar infraorder name
100
 return_port_dim$port_name_caps varchar port name in all capitals format
100
 ctd_drop_time_dim$record_type varchar time record or reason record is unavailable
100
 date_whid int8 warehouse identifier for date
100
 site_dim$tide_station_noaa_id varchar tide station id according to NOAA's Tides and Currents site
100
 sunset_time_dim$military_hour int2 military representation of the hour
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
 best_available_taxonomy_dim$species_80 varchar species name
100
 tide_height_first_ft numeric tide height at first drop for a site measured in feet
100
 date_dim$month_of_year int2 numeric representation of month of year
100
 sunset_time_whid int4 warehouse identifier for the sunset time
100
 sampling_end_time_dim$second int2 number of seconds in the minute
100
 sunrise_time_dim$hh24miss bpchar concatenation of military hour, minute, second, example 230415 equates to 23:04:15
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
 captain_person_dim$nick_name varchar nickname of person
100
 sunset_time_dim$hh24miss bpchar concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100
 return_port_dim$port_code bpchar port code for observer program
100
 site_moon_tide_dim$tide_phase varchar tide phase
100
 sunrise_time_dim$period bpchar period of time
100
 return_port_dim$port_group_name varchar port group name for observer program
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
 scientist_2_person_dim$first_name varchar first name of person
100
 best_available_taxonomy_dim$subspecies_82 varchar subspecies name
100
 captain_person_dim$record_type varchar person record or reason record is unavailable
100
 ctd_drop_latitude_dim$latitude_minute_units int2 numeric representation of latitude that makes up the minute unit only
100
 site_dim$tide_station_longitude_whid int4 warehouse identifier to longitude details for site's nearest tide station
100
 captain_person_dim$full_name varchar full name in format of First and Last (Suffix)
100
 site_moon_tide_whid int2 warehouse identifier for site moon tide
100
 site_moon_tide_dim$moon_phase varchar moon phase
100
 wave_height_m numeric wave height in meters
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
 ctd_drop_latitude_dim$latitude_in_degree_minute_second varchar string representation of latitude in degrees, minutes, and seconds for example 4525'01"
100
 site_moon_tide_dim$record_type varchar moon tide record or reason record is unavailable
100
 sampling_start_time_whid int4 warehouse identifier for the sampling start time
100
 full_moon_pct int2 percent of full moon

Attribute Details

vessel

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

best_available_taxonomy_dim$structure_source

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

Source of the taxonomic structure
Unit of Measure: unspecified
Allowed Values: Any

ctd_drop_time_dim$hour

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

net_touchdown_time

CC ID: 377457
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: 377458
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

best_available_taxonomy_dim$genus_70

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

genus name

ctd_drop_latitude_whid

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

warehouse identifier for CTD drop latitude

species_category

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

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

best_available_taxonomy_dim$subfamily_52

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

subfamily name

scientist_1_person_dim$full_name

CC ID: 377463
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_on_bottom_measure_depth_dim$record_type

CC ID: 377464
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: 377465
Data Storage Type: bpchar
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

period of time
Allowed Values: AM, PM

fpc_person_whid

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

warehouse identifier for the FPC

site_dim$site_number

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

site identifier number

best_available_taxonomy_dim$itis_taxonomic_serial_no

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

ITIS taxonomic identifier
Unit of Measure: unspecified
Allowed Values: Any

scientist_2_person_whid

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

warehouse identifier for the second scientist

best_available_taxonomy_dim$grp_nonstandard_taxon_99

CC ID: 377470
Data Storage Type: varchar
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

date_dim$record_type

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

tide_height_last_ft

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

captain_person_dim$first_name

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

first name of person

ctd_drop_latitude_dim$latitude_compass_direction

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

best_available_taxonomy_dim$superfamily_48

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

superfamily name

departure_port_dim$state_abbrev

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

two letter state abbreviation
Allowed Values: AK, CA, OR, WA

departure_port_dim$state_name

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

state name
Allowed Values: Alaska, California, Oregon, Washington

ctd_drop_longitude_dim$longitude_minute_units

CC ID: 377478
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: 377479
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

best_available_taxonomy_dim$acoustics_species_id

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

Species ID used in the acoustics program
Unit of Measure: unspecified
Allowed Values: Any

best_available_taxonomy_dim$worms_aphiaid

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

WoRMS taxonomic identifier
Unit of Measure: unspecified
Allowed Values: Any

scientist_1_person_whid

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

warehouse identifier for the first scientist

ctd_on_bottom_measure_depth_whid

CC ID: 377483
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: 377484
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

fpc_person_dim$role

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

operation_type

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

captain_person_dim$last_name

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

last name of person

fpc_person_dim$last_name

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

last name of person

total_catch_numbers

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

a count off the number of species caught at a site

scientist_2_person_dim$full_name

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

full name in format of First and Last (Suffix)

sunrise_time_dim$minute

CC ID: 377491
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: 377492
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

return_port_dim$state_abbrev

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

two letter state abbreviation
Allowed Values: AK, CA, OR, WA

departure_port_dim$port_group_name

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

port group name for observer program

fpc_person_dim$record_type

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

best_available_taxonomy_dim$record_type

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

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

sunrise_time_dim$hour

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

departure_port_whid

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

warehouse identifier for the departure port

ctd_sounder_depth_dim$record_type

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

best_available_taxonomy_dim$family_50

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

family name

set_identifier

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

set identifier

departure_port_dim$port_code

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

port code for observer program

best_available_taxonomy_dim$kingdom_10

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

kingdom name

best_available_taxonomy_dim$class_30

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

class name

sampling_start_hhmmss

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

sampling_start_time_dim$military_hour

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

departure_port_dim$port_name_caps

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

port name in all capitals format

pacfin_spid

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

pacfin species id - many taxa may not have one of these

leg

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

leg number for the survey

return_port_dim$record_type

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

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

return_port_dim$state_name

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

state name
Allowed Values: Alaska, California, Oregon, Washington

ctd_on_bottom_measure_depth_dim$depth_meters

CC ID: 377512
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_on_bottom_salinity_psu

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

best_available_taxonomy_dim$observer_species_id

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

species identifier used by the observer program

scientist_2_person_dim$last_name

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

last name of person

sunrise_time_dim$record_type

CC ID: 377516
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$record_type

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

scientist_2_person_dim$record_type

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

departure_port_dim$record_type

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

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

sampling_start_time_dim$second

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

scientist_2_person_dim$middle_initial

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

middle initial of person

tide_height_mid_ft

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

tide_height_mid_m

CC ID: 377523
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: 377524
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

captain_person_dim$middle_initial

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

middle initial of person

site_general_note

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

site general notes

captain_person_dim$role

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

ctd_sounder_depth_dim$boundary_indicator

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

sampling_end_time_whid

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

warehouse identifier for the sampling end time

ctd_drop_longitude_dim$longitude_compass_direction

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

longitude compass direction
Allowed Values: E, W

best_available_taxonomy_dim$abbreviated_name

CC ID: 377531
Data Storage Type: varchar
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

ctd_drop_time_whid

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

warehouse identifier for CTD drop time

site_dim$inactive_date_whid

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

scientist_2_person_dim$role

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

tide_height_first_m

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

return_port_dim$port_name_std

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

port name in standard format

ctd_drop_time_dim$minute

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

best_available_taxonomy_dim$superorder_38

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

superorder name

sunrise_time_whid

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

Warehouse identifier for the sunrise time

best_available_taxonomy_dim$hookandline_species_id

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

species identifier used by hook and line

return_port_dim$port_group_code

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

port group code for observer program
Allowed Values: AK, AT, BB, CA, CB, CC, EA, FB, LA, MB, MT, NB, NP, SB, SF

species_subcategory

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

mid-level taxonomic ranking
Allowed Values: rockfish, flatfish, shark, crab, NA

site_dim$cdfgblock

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

date_dim$month_name

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

sunrise_time_dim$military_hour

CC ID: 377545
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_dim$area_name

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

name of area site is located in

date_dim$full_date

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

full date value

swell_direction_mag

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

site_dim$cowcod_conservation_area_indicator

CC ID: 377549
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.

fpc_person_dim$full_name

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

full name in format of First and Last (Suffix)

sampling_end_time_dim$military_hour

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

ctd_drop_latitude_dd

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

ctd_drop_longitude_dim$longitude_second_units

CC ID: 377553
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: 377554
Data Storage Type: bpchar
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

period of time
Allowed Values: AM, PM

best_available_taxonomy_dim$phylum_20

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

phylum name

best_available_taxonomy_dim$suborder_42

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

suborder name

net_liftoff_time

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

military time representation of the time

sampling_end_hhmmss

CC ID: 377558
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_longitude_dim$record_type

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

cpue_normalized_catch_numbers

CC ID: 377560
Data Storage Type: numeric
Required: No
Primary Key: No
Status: Active
Description:

a derived number of species caught at a site based off the number of valid hooks deployed at the site

best_available_taxonomy_dim$tribe_60

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

tribe name

vessel_id

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

field database vessel id number

site_dim$site_longitude_dd

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

best_available_taxonomy_dim$subclass_32

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

subclass name

sunset_time_dim$time

CC ID: 377565
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: 377566
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

ctd_drop_latitude_dim$record_type

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

scientist_1_person_dim$role

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

departure_port_dim$port_group_code

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

port group code for observer program
Allowed Values: AK, AT, BB, CA, CB, CC, EA, FB, LA, MB, MT, NB, NP, SB, SF

scientist_1_person_dim$middle_initial

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

middle initial of person

site_whid

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

warehouse identifier to the site details

captain_person_whid

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

warehouse identifier for the vessel captain

best_available_taxonomy_dim$order_40

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

order name

sunrise_time_dim$second

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

ctd_sounder_depth_m

CC ID: 377575
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: 377576
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: 377577
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for CTD drop longitude

common_name

CC ID: 377578
Data Storage Type: varchar
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

scientific_name

CC ID: 377579
Data Storage Type: varchar
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

sampling_start_time_dim$period

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

period of time
Allowed Values: AM, PM

site_ocean_weather_note

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

site's ocean and weather notes

best_available_taxonomy_dim$norpac_species_id

CC ID: 377582
Data Storage Type: int4
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.
Unit of Measure: unspecified
Allowed Values: Any

total_catch_wt_kg

CC ID: 377583
Data Storage Type: numeric
Required: No
Primary Key: No
Status: Active
Description:

a sum of the measured weights of a species caught at a site
Unit of Measure: kg

swell_height_ft

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

best_available_taxonomy_dim$grp_reg_depth_category

CC ID: 377585
Data Storage Type: varchar
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

scientist_1_person_dim$last_name

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

last name of person

site_dim$record_type

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

return_port_whid

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

warehouse identifier for return port

swell_height_m

CC ID: 377589
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_on_bottom_temp_c

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

date_dim$day_of_month

CC ID: 377591
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: 377592
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

departure_port_dim$port_name_std

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

port name in standard format

ctd_drop_time_dim$period

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

period of time
Allowed Values: AM, PM

fish_info_note

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

overall fish information note

date_yyyymmdd

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

text representation of year month day

ctd_drop_latitude_dim$named_parallel

CC ID: 377597
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: 377598
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: 377599
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

numeric representation of year
Allowed Values: 1978+

site_valid_hooks

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

a count of the number of valid hooks deployed at a site

ctd_on_bottom_measure_depth_dim$boundary_indicator

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

sunrise_time_dim$time

CC ID: 377602
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: 377603
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

fpc_person_dim$middle_initial

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

middle initial of person

project_name

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

project name

ctd_sounder_depth_whid

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

warehouse identifier for CTD sounder depth

fram_program

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

sampling_end_time_dim$hour

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

site_dim$tide_station_name

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

name of nearest tide station

scientist_2_person_dim$nick_name

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

nickname of person

sunset_time_dim$record_type

CC ID: 377611
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: 377612
Data Storage Type: time
Required: No
Primary Key: No
Status: Active
Description:

military time representation of the time

taxon_rank

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

name of the lowest taxonomic level used to define scientific name

ctd_on_bottom_disolved_oxygen_sbe43_ml_per_l

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

fpc_person_dim$first_name

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

first name of person

site_habitat_note

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

site habitat notes

scientist_1_person_dim$first_name

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

first name of person

ctd_on_bottom_disolved_oxygen_aanderaa_ml_per_l

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

fpc_person_dim$nick_name

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

nickname of person

best_available_taxonomy_dim$superclass_28

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

superclass name

ctd_drop_longitude_dim$longitude_in_degrees

CC ID: 377621
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_sounder_depth_dim$depth_meters

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

site_dim$site_longitude_whid

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

warehouse identifier to longitude details for site

ctd_drop_time_dim$second

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

best_available_taxonomy_dim$infraclass_34

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

infraclass name

best_available_taxonomy_dim$pacfin_nom_spid

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

PacFIN nominal species identifier
Unit of Measure: unspecified
Allowed Values: Any

best_available_taxonomy_dim$subphylum_22

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

subphylum name

scientist_1_person_dim$record_type

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

sampling_end_time_dim$minute

CC ID: 377629
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: 377630
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: 377631
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

best_available_taxonomy_whid

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

warehouse identifier to best available taxonomy

ctd_drop_time_dim$military_hour

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

best_available_taxonomy_dim$trawl_survey_species_id

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

species identifier used by the trawl survey

wave_height_ft

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

ctd_drop_longitude_dim$longitude_in_degree_minute_second

CC ID: 377636
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"

scientist_1_person_dim$nick_name

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

nickname of person

best_available_taxonomy_dim$infraorder_44

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

infraorder name

return_port_dim$port_name_caps

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

port name in all capitals format

ctd_drop_time_dim$record_type

CC ID: 377640
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: 377641
Data Storage Type: int8
Max Length: 64
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier for date

site_dim$tide_station_noaa_id

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

sunset_time_dim$military_hour

CC ID: 377643
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_dim$site_latitude_dd

CC ID: 377644
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: 377645
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: 377646
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

best_available_taxonomy_dim$species_80

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

species name

tide_height_first_ft

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

date_dim$month_of_year

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

sunset_time_whid

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

warehouse identifier for the sunset time

sampling_end_time_dim$second

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

sunrise_time_dim$hh24miss

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

sunset_time_dim$hour

CC ID: 377653
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: 377654
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: 377655
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: 377656
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: 377657
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

warehouse identifier to latitude details for site

captain_person_dim$nick_name

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

nickname of person

sunset_time_dim$hh24miss

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

return_port_dim$port_code

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

port code for observer program

site_moon_tide_dim$tide_phase

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

tide phase
Allowed Values: Ebb, Flood, Steady

sunrise_time_dim$period

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

period of time
Allowed Values: AM, PM

return_port_dim$port_group_name

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

port group name for observer program

ctd_drop_latitude_dim$latitude_second_units

CC ID: 377664
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: 377665
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: 377666
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

scientist_2_person_dim$first_name

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

first name of person

best_available_taxonomy_dim$subspecies_82

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

subspecies name

captain_person_dim$record_type

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

ctd_drop_latitude_dim$latitude_minute_units

CC ID: 377670
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_dim$tide_station_longitude_whid

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

captain_person_dim$full_name

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

full name in format of First and Last (Suffix)

site_moon_tide_whid

CC ID: 377673
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: 377674
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

wave_height_m

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

ctd_drop_longitude_dim$longitude_degree_units

CC ID: 377676
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: 377677
Data Storage Type: varchar
Max Length: 1000
Required: No
Primary Key: No
Status: Active
Description:

site fish finder notes

ctd_drop_latitude_dim$latitude_in_degree_minute_second

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

site_moon_tide_dim$record_type

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

sampling_start_time_whid

CC ID: 377680
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: 377681
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

percent of full moon

Catalog Details

Catalog Item ID: 36440
GUID: gov.noaa.nmfs.inport:36440
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2017-01-25 13:18+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