Slide Menu
System Maintenance Notice, Sunday, January 23, 2022 @ 8am-2pm Eastern. The Operations Team will be performing system maintenance on all server environments. During this scheduled downtime, InPort will not be available.
View All
Search Help Show/Hide Menu

Item Identification

Title: catch_fact

Entity Information

Entity Type: Data Table
Description:

Catch data from bottom trawl survey

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
vessel varchar name of the vessel used for the operation
100
target_station_design_dim$station_design_name varchar name of the design for a collection of stations
100
best_available_taxonomy_dim$structure_source varchar Source of the taxonomic structure
100
min_depth_m numeric high precision value of minimum depth measured in meters
100
actual_station_design_dim$min_depth_whid int4 minimum depth warehouse identifier
100
net_touchdown_time time military time representation of the time
100
species_category varchar upper-level taxonomic ranking
100
year_stn_invalid int2 Survey year the station became invalid for trawl
100
best_available_taxonomy_dim$subfamily_52 varchar subfamily name
100
sampling_end_time_dim$period bpchar period of time
100
actual_station_design_dim$centroid_id numeric eight character code representing a unique identifier for a grid cell that is composed of a truncated latitude and longitude central to the cell. For example, 46252413 represents latitude 46 degrees 25 minutes and longitude -124 degrees and 13 minutes. The grid cells are small enough that 8 characters captures uniqueness. Note that these are NOT technically or mathematically centroids of the polygons.
100
field_identified_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
field_identified_taxonomy_dim$subphylum_22 varchar subphylum name
100
actual_station_design_dim$station_code varchar unique identifier for a station definition
100
catch_id int8 unique(legacy) identifier for the catch from a haul, sorted to taxonomic group or debris type.
100
best_available_taxonomy_dim$itis_taxonomic_serial_no int4 ITIS taxonomic identifier
100
field_identified_taxonomy_dim$species_80 varchar species name
100
field_identified_taxonomy_dim$subfamily_52 varchar subfamily name
100
haul_latitude_dim$record_type varchar latitude record type or reason record is unavailable
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
operation_dim$limited_entry_permit_number bpchar federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California
100
field_identified_taxonomy_dim$superfamily_48 varchar superfamily name
100
date_dim$full_date timestamp full date value
100
actual_station_design_dim$station_invalid_survey_year int2 Survey year the station became invalid for trawl
100
actual_station_design_dim$lower_left_longitude_whid int4 lower left longitude warehouse identifier for a design type of grid
100
total_catch_wt_observation_detail_whid int4 warehouse identifier to total catch weight observation details
100
target_station_design_dim$transect_station_longitude_whid int4 longitude on transect warehouse identifier for a design type of transect
100
best_available_taxonomy_dim$superfamily_48 varchar superfamily name
100
field_identified_taxonomy_dim$superclass_28 varchar superclass name
100
haul_latitude_dim$latitude_in_degree_minute_second varchar string representation of latitude in degrees, minutes, and seconds for example 4525'01"
100
actual_station_design_dim$station_grid_dd polygon collection of vertices of grid points of a grid design measured in decimal degrees
100
field_identified_taxonomy_dim$infraclass_34 varchar infraclass name
100
best_available_taxonomy_dim$acoustics_species_id int4 Species ID used in the acoustics program
100
most_recent_taxon_update timestamp full date value
100
operation_dim$scientist_3_person_whid int4 person reference for the third scientist
100
target_station_design_dim$lower_left_latitude_whid int4 lower left latitude warehouse identifier for a design type of grid
100
actual_station_design_dim$area_hectares numeric station area measured in hectares
100
haul_longitude_whid int4 warehouse identifier for haul longitude
100
best_available_taxonomy_dim$worms_aphiaid int4 WoRMS taxonomic identifier
100
target_station_design_dim$max_depth_whid int4 maximum depth warehouse identifier
100
best_available_taxonomy_observation_detail_dim$record_type varchar observation detail record type or reason record is unavailable
100
field_identified_taxonomy_dim$order_40 varchar order name
100
most_recent_taxonomy_update_date_dim$record_type varchar date, month, or year record or reason record is unavailable
100
haul_longitude_dim$longitude_second_units int2 numeric representation of longitude that makes up the second unit only
100
actual_station_design_dim$min_latitude_whid int4 minimum latitude warehouse identifier for a design type of transect
100
pass int4 pass number of the survey
100
actual_station_design_dim$min_depth_m numeric high precision value of minimum depth measured in meters
100
station_ul_lat_dd numeric high precision value of upper left latitude of design type grid measured in decimal degrees
100
total_catch_numbers int4 numbers expansion for a taxonomic group within a haul.
100
max_depth_m numeric high precision value of maximum depth measured in meters
100
operation_dim$operation_start_time_whid int8 start time reference for the operation
100
best_available_taxonomy_dim$family_50 varchar family name
100
field_identified_taxonomy_dim$itis_taxonomic_serial_no int4 ITIS taxonomic identifier
100
program varchar type of fram program
100
best_available_taxonomy_dim$record_type varchar record or reason record is unavailable
100
operation_dim$captain_person_whid int4 person reference for the vessel captain
100
total_catch_wt_observation_detail_dim$source_primary varchar name of primary source used to get the measurement
100
total_catch_wt_observation_detail_dim$means_of_calculation varchar describes how the measurement was calculated
100
actual_station_design_dim$upper_left_latitude_whid int4 upper left latitude warehouse identifier for a design type of grid
100
target_station_design_dim$stn_invalid_for_trawl_date_whid int8 station design invalidation date warehouse identifier
100
mean_seafloor_dep_boundary varchar depth boundry indicator identifying ifp boundary marks
100
field_identified_taxonomy_dim$infraorder_44 varchar infraorder name
100
operation_dim$fpc_person_whid int4 person reference for the FPC
100
best_available_taxonomy_dim$order_40 varchar order name
100
haul_latitude_dim$latitude_second_units int2 numeric representation of latitude that makes up the second unit only
100
target_station_design_dim$max_latitude_dd numeric high precision value of maximum latitude measured in decimal degrees
100
actual_station_design_dim$upper_left_latitude_dd numeric high precision value of upper left latitude of design type grid measured in decimal degrees
100
sampling_start_time_dim$military_hour int2 military representation of the hour
100
actual_station_design_dim$station_design_name varchar name of the design for a collection of stations
100
pacfin_spid varchar pacfin species id - many taxa may not have one of these
100
leg int2 leg number of the survey
100
actual_station_design_dim$lower_left_longitude_dd numeric high precision value of lower left longitude of design type grid measured in decimal degrees
100
actual_station_design_dim$record_type varchar station design record or reason record is unavailable
100
target_station_design_dim$active_polygon_dd polygon collection of vertices of the usuable area inside a station grid measured in decimal degrees
100
operation_dim$operation_type varchar type of operation
100
subsample_count int4 count of the subsample used for numbers expansion. This is usually either the counted fraction or the subsample that is measured for fish length.
100
best_available_taxonomy_dim$observer_species_id int4 species identifier used by the observer program
100
reason_stn_invalid varchar reason station was invalidated, multiple reasons are comma separated
100
actual_station_design_dim$transect_latitude_dd numeric high precision value of transect latitude measured in decimal degrees
100
operation_dim$ifq_account_number varchar unique number assigned to user accounts in the Vessel Accounting Database
100
field_identified_taxonomy_dim$hookandline_species_id int4 species identifier used by hook and line
100
target_station_design_dim$upper_right_longitude_whid int4 upper right longitude warehouse identifier for a design type of grid
100
actual_station_design_dim$min_latitude_dd numeric high precision value of minimum latitude measured in decimal degrees
100
station_ll_lat_dd numeric high precision value of lower left latitude of design type grid measured in decimal degrees
100
most_recent_taxonomy_update_date_dim$month_of_year int2 numeric representation of month of year
100
actual_station_design_dim$upper_right_latitude_whid int4 upper right latitude warehouse identifier for a design type of grid
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
field_identified_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
best_available_taxonomy_dim$superclass_28 varchar superclass name
100
total_catch_wt_observation_detail_dim$record_type varchar observation detail record type or reason record is unavailable
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
best_available_taxonomy_dim$subspecies_82 varchar subspecies name
100
sampling_end_time_whid int8 warehouse identifier for the sampling end time
100
actual_station_design_dim$transect_station_longitude_dd numeric high precision value of transect station longitude measured in decimal degrees
100
operation_dim$scientist_4_person_whid int4 person reference for the fourth scientist
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
tow_end_timestamp timestamp operation end date timestamp
100
target_station_design_dim$area_hectares numeric station area measured in hectares
100
target_station_design_dim$mean_depth_m numeric high precision value of mean depth measured in meters
100
most_recent_taxonomy_update_date_dim$month_name varchar text representation of month
100
actual_station_design_dim$lower_right_longitude_dd numeric high precision value of lower right longitude of design type grid measured in decimal degrees
100
tow_start_timestamp timestamp operation start date timestamp
100
best_available_taxonomy_dim$superorder_38 varchar superorder name
100
best_available_taxonomy_dim$kingdom_10 varchar kingdom name
100
field_identified_taxonomy_dim$structure_source varchar Source of the taxonomic structure
100
station_lr_lat_dd numeric high precision value of lower right latitude of design type grid measured in decimal degrees
100
best_available_taxonomy_dim$hookandline_species_id int4 species identifier used by hook and line
100
operation_dim$trip_id int4 trip identifier number
100
field_identified_taxonomy_dim$family_50 varchar family name
100
species_subcategory varchar mid-level taxonomic ranking
100
actual_station_design_dim$upper_right_latitude_dd numeric high precision value of upper right latitude of design type grid measured in decimal degrees
100
field_identified_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
operation_dim$coast_guard_number varchar Coast Guard documentation number of vessel
100
date_dim$month_name varchar text representation of month
100
operation_dim$record_type varchar operation record or reason record is unavailable
100
target_station_design_dim$lower_left_longitude_whid int4 lower left longitude warehouse identifier for a design type of grid
100
operation_dim$operation_end_time_whid int8 end time reference for the operation
100
actual_station_design_dim$upper_right_longitude_whid int4 upper right longitude warehouse identifier for a design type of grid
100
actual_station_design_dim$transect_station_longitude_whid int4 longitude on transect warehouse identifier for a design type of transect
100
actual_station_design_dim$max_latitude_dd numeric high precision value of maximum latitude measured in decimal degrees
100
field_identified_taxonomy_dim$subspecies_82 varchar subspecies name
100
target_station_design_dim$mean_depth_whid int4 mean depth warehouse identifier
100
field_identified_taxonomy_dim$abbreviated_name varchar specialized common name, generally for a well-known species of fish such as ATF, LST, SST
100
sampling_end_time_dim$military_hour int2 military representation of the hour
100
sampling_start_time_dim$period bpchar period of time
100
total_catch_wt_kg numeric total catch weight in kilograms is ordinarily the weight of a taxonomic group within a haul. It is usually the sum of all baskets weights collected for a taxonomic group within a haul, but may be derived as a linear expansion based on a weighed, sorted subsample pulled randomly from the weighed unsorted total within a haul.
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
most_recent_taxonomy_update_date_dim$day_of_month int2 numeric representation of the day in month
100
partition varchar Refines the partition type
100
best_available_taxonomy_dim$tribe_60 varchar tribe name
100
actual_station_design_dim$mean_depth_whid int4 mean depth warehouse identifier
100
sampling_start_time_dim$minute int2 number of minutes in the hour
100
target_station_design_dim$upper_left_longitude_whid int4 upper left longitude warehouse identifier for a design type of grid
100
field_identified_taxonomy_dim$worms_aphiaid int4 WoRMS taxonomic identifier
100
haul_longitude_dim$longitude_in_degree_minute_second varchar string representation of longitude in degrees, minutes, and seconds for example 4525'01"
100
station_ur_lon_dd numeric high precision value of upper right longitude of design type grid measured in decimal degrees
100
statistical_partition_dim$record_type varchar statistical partition record or reason record is unavailable
100
midtow_lat_named_parallel varchar name of parallel, boundary, or commonly used geograpical location
100
centroid_id numeric eight character code representing a unique identifier for a grid cell that is composed of a truncated latitude and longitude central to the cell. For example, 46252413 represents latitude 46 degrees 25 minutes and longitude -124 degrees and 13 minutes. The grid cells are small enough that 8 characters captures uniqueness. Note that these are NOT technically or mathematically centroids of the polygons.
100
most_recent_taxonomy_update_date_dim$yyyymmdd bpchar text representation of year month day
100
field_identified_taxonomy_dim$subclass_32 varchar subclass name
100
target_station_design_dim$station_grid_dd polygon collection of vertices of grid points of a grid design measured in decimal degrees
100
target_station_design_dim$transect_latitude_dd numeric high precision value of transect latitude measured in decimal degrees
100
target_station_design_whid int4 warehouse identifier for target station design
100
field_identified_taxonomy_dim$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
field_identified_taxonomy_dim$phylum_20 varchar phylum name
100
actual_station_design_dim$variance_depth_m2 numeric high precision value of variance depth mesured in squared meters
100
haul_latitude_dim$latitude_minute_units int2 numeric representation of latitude that makes up the minute unit only
100
operation_dim_whid int8 warehouse identifier for operation
100
field_identified_taxonomy_dim$species_category varchar upper-level taxonomic ranking
100
best_available_taxonomy_observation_detail_dim$measurement_procurement varchar how the measurement was achieved
100
total_catch_wt_observation_detail_dim$method_description varchar description of how the observation was taken
100
depth_ftm 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$class_30 varchar class name
100
actual_station_design_dim$lower_left_latitude_dd numeric high precision value of lower left latitude of design type grid measured in decimal degrees
100
performance varchar performance of the operation
100
date_dim$month_abbrev bpchar three character representation of month in capital letters
100
station_ll_lon_dd numeric high precision value of lower left longitude of design type grid measured in decimal degrees
100
seafloor_depth_whid int4 warehouse identifier for seafloor depth
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
field_identified_taxonomy_dim$scientific_name_taxonomic_level varchar name of the lowest taxonomic level used to define scientific name
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
target_station_design_dim$station_design_type varchar type of design underlying the survey station set: Transect or Grid to date
100
operation_dim$departure_port_whid int4 port reference for the departure port
100
haul_latitude_dim$latitude_degree_units int2 numeric representation of latitude that makes up the degree unit only
100
actual_station_design_dim$lower_right_latitude_dd numeric high precision value of lower right latitude of design type grid measured in decimal degrees
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
operation_dim$field_operation_seg_id int8 operation segment id reference to the field operational segment table
100
haul_latitude_dim$latitude_compass_direction bpchar latitude compass direction
100
field_identified_taxonomy_dim$record_type varchar record or reason record is unavailable
100
station_lr_lon_dd numeric high precision value of lower right longitude of design type grid measured in decimal degrees
100
date_dim$day_of_month int2 numeric representation of the day in month
100
actual_station_design_dim$upper_left_longitude_dd numeric high precision value of upper left longitude of design type grid measured in decimal degrees
100
cpue_kg_per_ha_der numeric derivation of catch per unit effort in weight (kilograms) per hectare ordinarily estimated as the expanded haul catch weight divided by the area swept by the net.
100
field_identified_taxonomy_dim$species_sub_category varchar mid-level taxonomic ranking
100
field_note varchar notes made in the field about the catch
100
operation_dim$scientist_2_person_whid int4 person reference for the second scientist
100
actual_station_design_dim$max_depth_whid int4 maximum depth warehouse identifier
100
most_recent_taxonomy_update_date_dim$month_abbrev bpchar three character representation of month in capital letters
100
target_station_design_dim$max_latitude_whid int4 maximum latitude warehouse identifier for a design type of transect
100
haul_longitude_dim$longitude_minute_units int2 numeric representation of longitude that makes up the minute unit only
100
date_dim$year int4 numeric representation of year
100
operation_dim$state_registration_number varchar state registration number for the vessel
100
best_available_taxonomy_dim$genus_70 varchar genus name
100
total_catch_wt_observation_detail_dim$observation_type varchar the type of observation
100
actual_station_design_dim$transect_latitude_whid int4 latitude warehouse identifier for a design type of transect
100
sampling_end_time_dim$hour int2 standard representation of the hour
100
target_station_design_dim$lower_right_latitude_whid int4 lower right latitude warehouse identifier for a design type of grid
100
field_identified_taxonomy_dim$pacfin_spid varchar pacfin species id - many taxa may not have one of these
100
latitude_dd numeric numeric representation of latitude in degrees
100
taxon_rank varchar name of the lowest taxonomic level used to define scientific name
100
haul_longitude_dim$record_type varchar longitude record type or reason record is unavailable
100
actual_station_design_dim$active_polygon_dd polygon collection of vertices of the usuable area inside a station grid measured in decimal degrees
100
actual_station_design_dim$reason_station_invalid varchar reason station was invalidated, multiple reasons are comma separated
100
target_station_design_dim$min_latitude_dd numeric high precision value of minimum latitude measured in decimal degrees
100
field_identified_taxonomy_dim$tribe_60 varchar tribe name
100
field_identified_taxonomy_dim$observer_species_id int4 species identifier used by the observer program
100
sampling_end_time_dim$record_type varchar time record or reason record is unavailable
100
target_station_design_dim$transect_station_longitude_dd numeric high precision value of transect station longitude measured in decimal degrees
100
most_recent_taxonomy_update_date_dim$year int4 numeric representation of year
100
target_station_design_dim$upper_left_latitude_whid int4 upper left latitude warehouse identifier for a design type of grid
100
field_identified_taxonomy_dim$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
actual_station_design_dim$mean_depth_m numeric high precision value of mean depth measured in meters
100
actual_station_design_dim$upper_left_longitude_whid int4 upper left longitude warehouse identifier for a design type of grid
100
field_identified_taxonomy_dim$class_30 varchar class name
100
statistical_partition_whid int4 warehouse identifier for statistical partition
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
actual_station_design_dim$max_depth_m numeric high precision value of maximum depth measured in meters
100
best_available_taxonomy_observation_detail_dim$means_of_calculation varchar describes how the measurement was calculated
100
sampling_end_time_dim$minute int2 number of minutes in the hour
100
date_yyyymmdd bpchar text representation of year month day
100
best_available_taxonomy_whid int4 warehouse identifier to best available taxonomy
100
haul_longitude_dim$longitude_compass_direction bpchar longitude compass direction
100
project varchar project name
100
best_available_taxonomy_dim$trawl_survey_species_id int4 species identifier used by the trawl survey
100
total_catch_wt_observation_detail_dim$measurement_procurement varchar how the measurement was achieved
100
station_ur_lat_dd numeric high precision value of upper right latitude of design type grid measured in decimal degrees
100
target_station_design_dim$transect_latitude_whid int4 latitude warehouse identifier for a design type of transect
100
best_available_taxonomy_dim$infraorder_44 varchar infraorder name
100
field_identified_taxonomy_dim$superorder_38 varchar superorder name
100
actual_station_design_dim$lower_right_latitude_whid int4 lower right latitude warehouse identifier for a design type of grid
100
operation_dim$observer_program varchar description of the observer program
100
actual_station_design_whid int4 warehouse identifier for station design
100
tow int2 operation number of the survey
100
actual_station_design_dim$lower_right_longitude_whid int4 lower right longitude warehouse identifier for a design type of grid
100
date_whid int8 warehouse identifier for date
100
target_station_design_dim$min_latitude_whid int4 minimum latitude warehouse identifier for a design type of transect
100
subsample_wt_kg numeric weight in kilograms of the subsample used for numbers expansion. This is usually either the counted fraction or the subsample that is measured for fish length.
100
operation_dim$return_port_whid int4 port reference for return port
100
field_identified_taxonomy_whid int4 warehouse identifier to field identified taxonomy
100
date_dim$record_type varchar date, month, or year record or reason record is unavailable
100
most_recent_taxonomy_update_date_whid int8 warehouse identifier for most recent taxonomy update date
100
best_available_taxonomy_observation_detail_dim$observation_type varchar the type of observation
100
best_available_taxonomy_dim$species_80 varchar species name
100
taxon_source varchar name of primary source used to get the measurement
100
date_dim$month_of_year int2 numeric representation of month of year
100
field_identified_taxonomy_dim$kingdom_10 varchar kingdom name
100
sampling_end_time_dim$second int2 number of seconds in the minute
100
haul_latitude_whid int4 warehouse identifier for haul latitude
100
operation_dim$departure_date_whid int8 date reference that vessel departed for the defined leg or trip
100
actual_station_design_dim$max_latitude_whid int4 maximum latitude warehouse identifier for a design type of transect
100
sampling_start_time_dim$record_type varchar time record or reason record is unavailable
100
target_station_design_dim$variance_depth_m2 numeric high precision value of variance depth mesured in squared meters
100
field_identified_taxonomy_dim$acoustics_species_id int4 Species ID used in the acoustics program
100
actual_station_design_dim$upper_right_longitude_dd numeric high precision value of upper right longitude of design type grid measured in decimal degrees
100
depth_m numeric depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries)
100
operation_dim$scientist_1_person_whid int4 person reference for the first scientist
100
target_station_design_dim$upper_right_latitude_whid int4 upper right latitude warehouse identifier for a design type of grid
100
best_available_taxonomy_dim$subclass_32 varchar subclass name
100
haul_longitude_dim$longitude_degree_units int2 numeric representation of longitude that makes up the degree unit only
100
target_station_design_dim$record_type varchar station design record or reason record is unavailable
100
field_identified_taxonomy_dim$trawl_survey_species_id int4 species identifier used by the trawl survey
100
cpue_numbers_per_ha_der numeric derivation of catch per unit effort in numbers of individuals per hectare ordinarily estimated as the expanded haul catch in numbers divided by the area swept by the net.
100
best_available_taxonomy_observation_detail_dim$method_description varchar description of how the observation was taken
100
sampling_start_hhmmss bpchar concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100
operation_dim$vessel_id int2 field database vessel id number
100
actual_station_design_dim$station_design_type varchar type of design underlying the survey station set: Transect or Grid to date
100
target_station_design_dim$min_depth_whid int4 minimum depth warehouse identifier
100
target_station_design_dim$lower_right_longitude_whid int4 lower right longitude warehouse identifier for a design type of grid
100
operation_dim$return_date_whid int8 date reference that vessel returned for the defined leg or trip
100
field_identified_taxonomy_dim$suborder_42 varchar suborder name
100
field_identified_taxonomy_dim$pacfin_nom_spid varchar PacFIN nominal species identifier
100
best_available_taxonomy_observation_detail_whid int4 warehouse identifier to best available taxonomy observation detail
100
seafloor_depth_dim$record_type varchar depth record or reason record is unavailable
100
sampling_start_time_dim$hour int2 standard representation of the hour
100
year int2 operation year
100
actual_station_design_dim$stn_invalid_for_trawl_date_whid int8 station design invalidation date warehouse identifier
100
statistical_partition_dim$statistical_partition_type varchar Defines the partition type
100
operation_dim$operation_start_date_whid int8 start date reference for the operation
100
longitude_dd numeric numeric representation of longitude in decimal degrees
100
field_identified_taxonomy_dim$genus_70 varchar genus name
100
station_code varchar unique identifier for a station definition
100
station_ul_lon_dd numeric high precision value of upper left longitude of design type grid measured in decimal degrees
100
sampling_start_time_whid int8 warehouse identifier for the sampling start time
100
actual_station_design_dim$lower_left_latitude_whid int4 lower left latitude warehouse identifier for a design type of grid
100
trawl_id int8 identifier for a sampling operation

Attribute Details

vessel

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

target_station_design_dim$station_design_name

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

name of the design for a collection of stations

best_available_taxonomy_dim$structure_source

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

min_depth_m

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

high precision value of minimum depth measured in meters

Unit of Measure: m

actual_station_design_dim$min_depth_whid

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

minimum depth warehouse identifier

net_touchdown_time

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

military time representation of the time

species_category

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

year_stn_invalid

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

Survey year the station became invalid for trawl

Unit of Measure: year
Allowed Values: Any

best_available_taxonomy_dim$subfamily_52

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

subfamily name

sampling_end_time_dim$period

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

period of time

Allowed Values: AM, PM

actual_station_design_dim$centroid_id

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

eight character code representing a unique identifier for a grid cell that is composed of a truncated latitude and longitude central to the cell. For example, 46252413 represents latitude 46 degrees 25 minutes and longitude -124 degrees and 13 minutes. The grid cells are small enough that 8 characters captures uniqueness. Note that these are NOT technically or mathematically centroids of the polygons.

field_identified_taxonomy_dim$norpac_species_id

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

field_identified_taxonomy_dim$subphylum_22

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

subphylum name

actual_station_design_dim$station_code

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

unique identifier for a station definition

catch_id

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

unique(legacy) identifier for the catch from a haul, sorted to taxonomic group or debris type.

best_available_taxonomy_dim$itis_taxonomic_serial_no

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

field_identified_taxonomy_dim$species_80

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

species name

field_identified_taxonomy_dim$subfamily_52

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

subfamily name

haul_latitude_dim$record_type

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

best_available_taxonomy_dim$grp_nonstandard_taxon_99

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

operation_dim$limited_entry_permit_number

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

field_identified_taxonomy_dim$superfamily_48

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

superfamily name

date_dim$full_date

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

full date value

actual_station_design_dim$station_invalid_survey_year

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

Survey year the station became invalid for trawl

Unit of Measure: year
Allowed Values: Any

actual_station_design_dim$lower_left_longitude_whid

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

lower left longitude warehouse identifier for a design type of grid

Unit of Measure: unspecified
Allowed Values: Any

total_catch_wt_observation_detail_whid

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

warehouse identifier to total catch weight observation details

target_station_design_dim$transect_station_longitude_whid

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

longitude on transect warehouse identifier for a design type of transect

best_available_taxonomy_dim$superfamily_48

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

superfamily name

field_identified_taxonomy_dim$superclass_28

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

superclass name

haul_latitude_dim$latitude_in_degree_minute_second

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

actual_station_design_dim$station_grid_dd

CC ID: 376588
Data Storage Type: polygon
Required: No
Primary Key: No
Status: Active
Description:

collection of vertices of grid points of a grid design measured in decimal degrees

Unit of Measure: dd

field_identified_taxonomy_dim$infraclass_34

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

infraclass name

best_available_taxonomy_dim$acoustics_species_id

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

most_recent_taxon_update

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

full date value

operation_dim$scientist_3_person_whid

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

person reference for the third scientist

target_station_design_dim$lower_left_latitude_whid

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

lower left latitude warehouse identifier for a design type of grid

actual_station_design_dim$area_hectares

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

station area measured in hectares

Unit of Measure: hectares

haul_longitude_whid

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

warehouse identifier for haul longitude

best_available_taxonomy_dim$worms_aphiaid

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

target_station_design_dim$max_depth_whid

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

maximum depth warehouse identifier

best_available_taxonomy_observation_detail_dim$record_type

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

observation detail record type or reason record is unavailable

Allowed Values: Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

field_identified_taxonomy_dim$order_40

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

order name

most_recent_taxonomy_update_date_dim$record_type

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

haul_longitude_dim$longitude_second_units

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

actual_station_design_dim$min_latitude_whid

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

minimum latitude warehouse identifier for a design type of transect

pass

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

actual_station_design_dim$min_depth_m

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

high precision value of minimum depth measured in meters

Unit of Measure: m

station_ul_lat_dd

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

high precision value of upper left latitude of design type grid measured in decimal degrees

Unit of Measure: dd

total_catch_numbers

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

numbers expansion for a taxonomic group within a haul.

max_depth_m

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

high precision value of maximum depth measured in meters

Unit of Measure: m

operation_dim$operation_start_time_whid

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

start time reference for the operation

best_available_taxonomy_dim$family_50

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

family name

field_identified_taxonomy_dim$itis_taxonomic_serial_no

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

program

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

best_available_taxonomy_dim$record_type

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

operation_dim$captain_person_whid

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

person reference for the vessel captain

total_catch_wt_observation_detail_dim$source_primary

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

name of primary source used to get the measurement

Allowed Values: Angler, FPC, Genetics, Lab Exam, Large Scale, Morphometrics, Morphometrics + Genetics, NA, Quality Assurance, Retrospective Review, Taxon Rank Upped, Whole Organism

total_catch_wt_observation_detail_dim$means_of_calculation

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

describes how the measurement was calculated

Allowed Values: Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

actual_station_design_dim$upper_left_latitude_whid

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

upper left latitude warehouse identifier for a design type of grid

target_station_design_dim$stn_invalid_for_trawl_date_whid

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

station design invalidation date warehouse identifier

mean_seafloor_dep_boundary

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

field_identified_taxonomy_dim$infraorder_44

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

infraorder name

operation_dim$fpc_person_whid

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

person reference for the FPC

best_available_taxonomy_dim$order_40

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

order name

haul_latitude_dim$latitude_second_units

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

target_station_design_dim$max_latitude_dd

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

high precision value of maximum latitude measured in decimal degrees

Unit of Measure: dd

actual_station_design_dim$upper_left_latitude_dd

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

high precision value of upper left latitude of design type grid measured in decimal degrees

Unit of Measure: dd

sampling_start_time_dim$military_hour

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

actual_station_design_dim$station_design_name

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

name of the design for a collection of stations

pacfin_spid

CC ID: 376627
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: 376628
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

actual_station_design_dim$lower_left_longitude_dd

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

high precision value of lower left longitude of design type grid measured in decimal degrees

Unit of Measure: dd

actual_station_design_dim$record_type

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

station design record or reason record is unavailable

Allowed Values: Station Design, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

target_station_design_dim$active_polygon_dd

CC ID: 376631
Data Storage Type: polygon
Required: No
Primary Key: No
Status: Active
Description:

collection of vertices of the usuable area inside a station grid measured in decimal degrees

Unit of Measure: dd

operation_dim$operation_type

CC ID: 376632
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]

subsample_count

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

count of the subsample used for numbers expansion. This is usually either the counted fraction or the subsample that is measured for fish length.

best_available_taxonomy_dim$observer_species_id

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

species identifier used by the observer program

reason_stn_invalid

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

reason station was invalidated, multiple reasons are comma separated

Allowed Values: California State MPA, Cowcod Conservation Area, ENC Avoidance, Farallon Island Radioactive Waste Dump, ONMS MPA, ONMS Permit Exclusion, Outside Survey Extent, Mooring, San Clemente Is. Military test range

actual_station_design_dim$transect_latitude_dd

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

high precision value of transect latitude measured in decimal degrees

Unit of Measure: dd

operation_dim$ifq_account_number

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

field_identified_taxonomy_dim$hookandline_species_id

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

species identifier used by hook and line

target_station_design_dim$upper_right_longitude_whid

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

upper right longitude warehouse identifier for a design type of grid

actual_station_design_dim$min_latitude_dd

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

high precision value of minimum latitude measured in decimal degrees

Unit of Measure: dd

station_ll_lat_dd

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

high precision value of lower left latitude of design type grid measured in decimal degrees

Unit of Measure: dd

most_recent_taxonomy_update_date_dim$month_of_year

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

actual_station_design_dim$upper_right_latitude_whid

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

upper right latitude warehouse identifier for a design type of grid

operation_dim$operation_end_date_whid

CC ID: 376644
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: 376645
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

field_identified_taxonomy_dim$grp_reg_depth_category

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

best_available_taxonomy_dim$superclass_28

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

superclass name

total_catch_wt_observation_detail_dim$record_type

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

observation detail record type or reason record is unavailable

Allowed Values: Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

common_name

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

best_available_taxonomy_dim$subspecies_82

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

subspecies name

sampling_end_time_whid

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

warehouse identifier for the sampling end time

actual_station_design_dim$transect_station_longitude_dd

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

high precision value of transect station longitude measured in decimal degrees

Unit of Measure: dd

operation_dim$scientist_4_person_whid

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

person reference for the fourth scientist

best_available_taxonomy_dim$abbreviated_name

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

tow_end_timestamp

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

operation end date timestamp

target_station_design_dim$area_hectares

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

station area measured in hectares

Unit of Measure: hectares

target_station_design_dim$mean_depth_m

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

high precision value of mean depth measured in meters

Unit of Measure: m

most_recent_taxonomy_update_date_dim$month_name

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

actual_station_design_dim$lower_right_longitude_dd

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

high precision value of lower right longitude of design type grid measured in decimal degrees

Unit of Measure: dd

tow_start_timestamp

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

operation start date timestamp

best_available_taxonomy_dim$superorder_38

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

superorder name

best_available_taxonomy_dim$kingdom_10

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

kingdom name

field_identified_taxonomy_dim$structure_source

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

station_lr_lat_dd

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

high precision value of lower right latitude of design type grid measured in decimal degrees

Unit of Measure: dd

best_available_taxonomy_dim$hookandline_species_id

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

species identifier used by hook and line

operation_dim$trip_id

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

trip identifier number

field_identified_taxonomy_dim$family_50

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

family name

species_subcategory

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

actual_station_design_dim$upper_right_latitude_dd

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

high precision value of upper right latitude of design type grid measured in decimal degrees

Unit of Measure: dd

field_identified_taxonomy_dim$grp_nonstandard_taxon_99

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

operation_dim$coast_guard_number

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

Coast Guard documentation number of vessel

date_dim$month_name

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

operation_dim$record_type

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

target_station_design_dim$lower_left_longitude_whid

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

lower left longitude warehouse identifier for a design type of grid

Unit of Measure: unspecified
Allowed Values: Any

operation_dim$operation_end_time_whid

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

end time reference for the operation

actual_station_design_dim$upper_right_longitude_whid

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

upper right longitude warehouse identifier for a design type of grid

actual_station_design_dim$transect_station_longitude_whid

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

longitude on transect warehouse identifier for a design type of transect

actual_station_design_dim$max_latitude_dd

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

high precision value of maximum latitude measured in decimal degrees

Unit of Measure: dd

field_identified_taxonomy_dim$subspecies_82

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

subspecies name

target_station_design_dim$mean_depth_whid

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

mean depth warehouse identifier

field_identified_taxonomy_dim$abbreviated_name

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

sampling_end_time_dim$military_hour

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

sampling_start_time_dim$period

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

period of time

Allowed Values: AM, PM

total_catch_wt_kg

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

total catch weight in kilograms is ordinarily the weight of a taxonomic group within a haul. It is usually the sum of all baskets weights collected for a taxonomic group within a haul, but may be derived as a linear expansion based on a weighed, sorted subsample pulled randomly from the weighed unsorted total within a haul.

best_available_taxonomy_dim$phylum_20

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

suborder name

net_liftoff_time

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

military time representation of the time

sampling_end_hhmmss

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

most_recent_taxonomy_update_date_dim$day_of_month

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

partition

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

Refines the partition type

Allowed Values: Life stage: YOY, larvae, eggs and egg cases, adult, subadult; Size: Large, Small, Unspecified; Gender: Male, Female

best_available_taxonomy_dim$tribe_60

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

tribe name

actual_station_design_dim$mean_depth_whid

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

mean depth warehouse identifier

sampling_start_time_dim$minute

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

target_station_design_dim$upper_left_longitude_whid

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

upper left longitude warehouse identifier for a design type of grid

field_identified_taxonomy_dim$worms_aphiaid

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

haul_longitude_dim$longitude_in_degree_minute_second

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

station_ur_lon_dd

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

high precision value of upper right longitude of design type grid measured in decimal degrees

Unit of Measure: dd

statistical_partition_dim$record_type

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

statistical partition record or reason record is unavailable

Allowed Values: Statistical Partition, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

midtow_lat_named_parallel

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

centroid_id

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

eight character code representing a unique identifier for a grid cell that is composed of a truncated latitude and longitude central to the cell. For example, 46252413 represents latitude 46 degrees 25 minutes and longitude -124 degrees and 13 minutes. The grid cells are small enough that 8 characters captures uniqueness. Note that these are NOT technically or mathematically centroids of the polygons.

most_recent_taxonomy_update_date_dim$yyyymmdd

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

text representation of year month day

field_identified_taxonomy_dim$subclass_32

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

subclass name

target_station_design_dim$station_grid_dd

CC ID: 376703
Data Storage Type: polygon
Required: No
Primary Key: No
Status: Active
Description:

collection of vertices of grid points of a grid design measured in decimal degrees

Unit of Measure: dd

target_station_design_dim$transect_latitude_dd

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

high precision value of transect latitude measured in decimal degrees

Unit of Measure: dd

target_station_design_whid

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

warehouse identifier for target station design

field_identified_taxonomy_dim$common_name

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

field_identified_taxonomy_dim$phylum_20

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

phylum name

actual_station_design_dim$variance_depth_m2

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

high precision value of variance depth mesured in squared meters

Unit of Measure: m2

haul_latitude_dim$latitude_minute_units

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

operation_dim_whid

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

warehouse identifier for operation

field_identified_taxonomy_dim$species_category

CC ID: 376711
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_observation_detail_dim$measurement_procurement

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

how the measurement was achieved

Allowed Values: NA, Calculated, Estimated, Observed, Measured, Not Documented

total_catch_wt_observation_detail_dim$method_description

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

description of how the observation was taken

depth_ftm

CC ID: 376714
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$class_30

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

class name

actual_station_design_dim$lower_left_latitude_dd

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

high precision value of lower left latitude of design type grid measured in decimal degrees

Unit of Measure: dd

performance

CC ID: 376717
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]

date_dim$month_abbrev

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

station_ll_lon_dd

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

high precision value of lower left longitude of design type grid measured in decimal degrees

Unit of Measure: dd

seafloor_depth_whid

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

warehouse identifier for seafloor depth

scientific_name

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

field_identified_taxonomy_dim$scientific_name_taxonomic_level

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

best_available_taxonomy_dim$norpac_species_id

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

target_station_design_dim$station_design_type

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

type of design underlying the survey station set: Transect or Grid to date

Allowed Values: Transect, Grid

operation_dim$departure_port_whid

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

port reference for the departure port

haul_latitude_dim$latitude_degree_units

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

actual_station_design_dim$lower_right_latitude_dd

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

high precision value of lower right latitude of design type grid measured in decimal degrees

Unit of Measure: dd

best_available_taxonomy_dim$grp_reg_depth_category

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

operation_dim$field_operation_seg_id

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

haul_latitude_dim$latitude_compass_direction

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

field_identified_taxonomy_dim$record_type

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

station_lr_lon_dd

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

high precision value of lower right longitude of design type grid measured in decimal degrees

Unit of Measure: dd

date_dim$day_of_month

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

actual_station_design_dim$upper_left_longitude_dd

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

high precision value of upper left longitude of design type grid measured in decimal degrees

Unit of Measure: dd

cpue_kg_per_ha_der

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

derivation of catch per unit effort in weight (kilograms) per hectare ordinarily estimated as the expanded haul catch weight divided by the area swept by the net.

Unit of Measure: kg/ha

field_identified_taxonomy_dim$species_sub_category

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

field_note

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

notes made in the field about the catch

operation_dim$scientist_2_person_whid

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

person reference for the second scientist

actual_station_design_dim$max_depth_whid

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

maximum depth warehouse identifier

most_recent_taxonomy_update_date_dim$month_abbrev

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

target_station_design_dim$max_latitude_whid

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

maximum latitude warehouse identifier for a design type of transect

haul_longitude_dim$longitude_minute_units

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

date_dim$year

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

numeric representation of year

Allowed Values: 1978+

operation_dim$state_registration_number

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

state registration number for the vessel

best_available_taxonomy_dim$genus_70

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

genus name

total_catch_wt_observation_detail_dim$observation_type

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

the type of observation

Allowed Values: NA, width, length, total_catch_weight, taxonomy, etc

actual_station_design_dim$transect_latitude_whid

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

latitude warehouse identifier for a design type of transect

sampling_end_time_dim$hour

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

target_station_design_dim$lower_right_latitude_whid

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

lower right latitude warehouse identifier for a design type of grid

field_identified_taxonomy_dim$pacfin_spid

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

latitude_dd

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

taxon_rank

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

haul_longitude_dim$record_type

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

actual_station_design_dim$active_polygon_dd

CC ID: 376754
Data Storage Type: polygon
Required: No
Primary Key: No
Status: Active
Description:

collection of vertices of the usuable area inside a station grid measured in decimal degrees

Unit of Measure: dd

actual_station_design_dim$reason_station_invalid

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

reason station was invalidated, multiple reasons are comma separated

Allowed Values: California State MPA, Cowcod Conservation Area, ENC Avoidance, Farallon Island Radioactive Waste Dump, ONMS MPA, ONMS Permit Exclusion, Outside Survey Extent, Mooring, San Clemente Is. Military test range

target_station_design_dim$min_latitude_dd

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

high precision value of minimum latitude measured in decimal degrees

Unit of Measure: dd

field_identified_taxonomy_dim$tribe_60

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

tribe name

field_identified_taxonomy_dim$observer_species_id

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

species identifier used by the observer program

sampling_end_time_dim$record_type

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

target_station_design_dim$transect_station_longitude_dd

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

high precision value of transect station longitude measured in decimal degrees

Unit of Measure: dd

most_recent_taxonomy_update_date_dim$year

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

numeric representation of year

Allowed Values: 1978+

target_station_design_dim$upper_left_latitude_whid

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

upper left latitude warehouse identifier for a design type of grid

field_identified_taxonomy_dim$scientific_name

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

actual_station_design_dim$mean_depth_m

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

high precision value of mean depth measured in meters

Unit of Measure: m

actual_station_design_dim$upper_left_longitude_whid

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

upper left longitude warehouse identifier for a design type of grid

field_identified_taxonomy_dim$class_30

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

class name

statistical_partition_whid

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

warehouse identifier for statistical partition

best_available_taxonomy_dim$infraclass_34

CC ID: 376768
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: 376769
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: 376770
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

subphylum name

actual_station_design_dim$max_depth_m

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

high precision value of maximum depth measured in meters

Unit of Measure: m

best_available_taxonomy_observation_detail_dim$means_of_calculation

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

describes how the measurement was calculated

Allowed Values: Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

sampling_end_time_dim$minute

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

date_yyyymmdd

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

text representation of year month day

best_available_taxonomy_whid

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

warehouse identifier to best available taxonomy

haul_longitude_dim$longitude_compass_direction

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

longitude compass direction

Allowed Values: E, W

project

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

best_available_taxonomy_dim$trawl_survey_species_id

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

species identifier used by the trawl survey

total_catch_wt_observation_detail_dim$measurement_procurement

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

how the measurement was achieved

Allowed Values: NA, Calculated, Estimated, Observed, Measured, Not Documented

station_ur_lat_dd

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

high precision value of upper right latitude of design type grid measured in decimal degrees

Unit of Measure: dd

target_station_design_dim$transect_latitude_whid

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

latitude warehouse identifier for a design type of transect

best_available_taxonomy_dim$infraorder_44

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

infraorder name

field_identified_taxonomy_dim$superorder_38

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

superorder name

actual_station_design_dim$lower_right_latitude_whid

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

lower right latitude warehouse identifier for a design type of grid

operation_dim$observer_program

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

description of the observer program

actual_station_design_whid

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

warehouse identifier for station design

tow

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

operation number of the survey

actual_station_design_dim$lower_right_longitude_whid

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

lower right longitude warehouse identifier for a design type of grid

date_whid

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

warehouse identifier for date

target_station_design_dim$min_latitude_whid

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

minimum latitude warehouse identifier for a design type of transect

subsample_wt_kg

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

weight in kilograms of the subsample used for numbers expansion. This is usually either the counted fraction or the subsample that is measured for fish length.

Unit of Measure: kg

operation_dim$return_port_whid

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

port reference for return port

field_identified_taxonomy_whid

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

warehouse identifier to field identified taxonomy

date_dim$record_type

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

most_recent_taxonomy_update_date_whid

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

warehouse identifier for most recent taxonomy update date

best_available_taxonomy_observation_detail_dim$observation_type

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

the type of observation

Allowed Values: NA, width, length, total_catch_weight, taxonomy, etc

best_available_taxonomy_dim$species_80

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

species name

taxon_source

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

name of primary source used to get the measurement

Allowed Values: Angler, FPC, Genetics, Lab Exam, Large Scale, Morphometrics, Morphometrics + Genetics, NA, Quality Assurance, Retrospective Review, Taxon Rank Upped, Whole Organism

date_dim$month_of_year

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

field_identified_taxonomy_dim$kingdom_10

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

kingdom name

sampling_end_time_dim$second

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

haul_latitude_whid

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

warehouse identifier for haul latitude

operation_dim$departure_date_whid

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

actual_station_design_dim$max_latitude_whid

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

maximum latitude warehouse identifier for a design type of transect

sampling_start_time_dim$record_type

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

target_station_design_dim$variance_depth_m2

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

high precision value of variance depth mesured in squared meters

Unit of Measure: m2

field_identified_taxonomy_dim$acoustics_species_id

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

actual_station_design_dim$upper_right_longitude_dd

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

high precision value of upper right longitude of design type grid measured in decimal degrees

Unit of Measure: dd

depth_m

CC ID: 376809
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$scientist_1_person_whid

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

person reference for the first scientist

target_station_design_dim$upper_right_latitude_whid

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

upper right latitude warehouse identifier for a design type of grid

best_available_taxonomy_dim$subclass_32

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

subclass name

haul_longitude_dim$longitude_degree_units

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

target_station_design_dim$record_type

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

station design record or reason record is unavailable

Allowed Values: Station Design, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

field_identified_taxonomy_dim$trawl_survey_species_id

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

species identifier used by the trawl survey

cpue_numbers_per_ha_der

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

derivation of catch per unit effort in numbers of individuals per hectare ordinarily estimated as the expanded haul catch in numbers divided by the area swept by the net.

best_available_taxonomy_observation_detail_dim$method_description

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

description of how the observation was taken

sampling_start_hhmmss

CC ID: 376818
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$vessel_id

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

field database vessel id number

actual_station_design_dim$station_design_type

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

type of design underlying the survey station set: Transect or Grid to date

Allowed Values: Transect, Grid

target_station_design_dim$min_depth_whid

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

minimum depth warehouse identifier

target_station_design_dim$lower_right_longitude_whid

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

lower right longitude warehouse identifier for a design type of grid

operation_dim$return_date_whid

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

field_identified_taxonomy_dim$suborder_42

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

suborder name

field_identified_taxonomy_dim$pacfin_nom_spid

CC ID: 376825
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_observation_detail_whid

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

warehouse identifier to best available taxonomy observation detail

seafloor_depth_dim$record_type

CC ID: 376827
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_start_time_dim$hour

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

year

CC ID: 376829
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+

actual_station_design_dim$stn_invalid_for_trawl_date_whid

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

station design invalidation date warehouse identifier

statistical_partition_dim$statistical_partition_type

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

Defines the partition type

Allowed Values: Life Stage, Size, Gender

operation_dim$operation_start_date_whid

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

start date reference for the operation

longitude_dd

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

field_identified_taxonomy_dim$genus_70

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

genus name

station_code

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

unique identifier for a station definition

station_ul_lon_dd

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

high precision value of upper left longitude of design type grid measured in decimal degrees

Unit of Measure: dd

sampling_start_time_whid

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

warehouse identifier for the sampling start time

actual_station_design_dim$lower_left_latitude_whid

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

lower left latitude warehouse identifier for a design type of grid

trawl_id

CC ID: 376839
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: 36437
GUID: gov.noaa.nmfs.inport:36437
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2017-01-25 13:14+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2017-02-13
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2018-02-14