Slide Menu
Jump to Section...
Search Help Show/Hide Menu
Metadata Rubric
100%
5.99 / 6
View Report
NWFSC Metadata Library > FRAM (Fishery Resource Analysis and Monitoring)... > West Coast Groundfish Bottom Trawl Survey Data... >

individual_fact

Entity (ENT)  |  Northwest Fisheries Science Center (NWFSC)
GUID: gov.noaa.nmfs.inport:36438  |  Updated: August 9, 2022  |  Published / External 

Item Identification

Title: individual_fact

Entity Information

Entity Type: Data Table
Description:

Individuals caught and measured on the bottom trawl survey

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 actual_station_design_dim$transect_station_longitude_dd numeric high precision value of transect station longitude measured in decimal degrees
100
 standard_survey_dim$standard_survey_weight_indicator varchar identifies if the individual is part of the Standard Weight Survey
100
 sampling_start_time_dim$minute int2 number of minutes in the hour
100
 best_available_taxonomy_dim$phylum_20 varchar phylum name
100
 performance varchar performance of the operation
100
 actual_station_design_dim$upper_right_latitude_whid int4 upper right latitude warehouse identifier for a design type of grid
100
 date_dim$record_type varchar date, month, or year record or reason record is unavailable
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
 best_available_taxonomy_dim$structure_source varchar Source of the taxonomic structure
100
 best_available_taxonomy_dim$family_50 varchar family name
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
 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$lower_left_latitude_whid int4 lower left latitude warehouse identifier for a design type of grid
100
 best_available_taxonomy_dim$record_type varchar record or reason record is unavailable
100
 width_observation_detail_dim$method_description varchar description of how the observation was taken
100
 station_ur_lon_dd numeric high precision value of upper right longitude of design type grid measured in decimal degrees
100
 most_recent_taxonomy_update_date_dim$day_of_month int2 numeric representation of the day in month
100
 most_recent_age_update_date_dim$yyyymmdd bpchar text representation of year month day
100
 individual_tracking_id int8 Individual tracking id
100
 ovary_id numeric Ovary sample number or barcode
100
 target_station_design_dim$stn_invalid_for_trawl_date_whid int8 station design invalidation date warehouse identifier
100
 standard_survey_whid int4 Warehouse identifier for standard survey
100
 operation_dim$scientist_1_person_whid int4 person reference for the first scientist
100
 most_recent_maturity_update_date_whid int8 Warehouse identifier for most recent maturity update date
100
 net_liftoff_time time military time representation of the time
100
 actual_station_design_dim$variance_depth_m2 numeric high precision value of variance depth mesured in squared meters
100
 target_station_design_dim$variance_depth_m2 numeric high precision value of variance depth mesured in squared meters
100
 target_station_design_dim$min_depth_whid int4 minimum depth warehouse identifier
100
 target_station_design_dim$transect_station_longitude_dd numeric high precision value of transect station longitude measured in decimal degrees
100
 actual_station_design_dim$lower_left_longitude_whid int4 lower left longitude warehouse identifier for a design type of grid
100
 field_identified_taxonomy_dim$itis_taxonomic_serial_no int4 ITIS taxonomic identifier
100
 operation_dim$departure_port_whid int4 port reference for the departure port
100
 haul_latitude_dim$record_type varchar latitude record type or reason record is unavailable
100
 sex_whid int2 Warehouse identifier to sex details
100
 target_station_design_whid int4 warehouse identifier for target station design
100
 target_station_design_dim$max_latitude_whid int4 maximum latitude warehouse identifier for a design type of transect
100
 actual_station_design_dim$upper_left_longitude_whid int4 upper left longitude warehouse identifier for a design type of grid
100
 pass int4 pass number of the survey
100
 sampling_end_time_dim$period bpchar period of time
100
 operation_dim$scientist_3_person_whid int4 person reference for the third scientist
100
 field_identified_taxonomy_dim$structure_source varchar Source of the taxonomic structure
100
 width_cm numeric Individual width measured in centimeters
100
 most_recent_taxon_update timestamp full date value
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
 operation_dim$operation_start_date_whid int8 start date reference for the operation
100
 best_available_taxonomy_dim$observer_species_id int4 species identifier used by the observer program
100
 project varchar project name
100
 midtow_lat_named_parallel varchar name of parallel, boundary, or commonly used geograpical location
100
 field_identified_taxonomy_dim$species_category varchar upper-level taxonomic ranking
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
 sampling_start_time_dim$record_type varchar time record or reason record is unavailable
100
 operation_dim$field_operation_seg_id int8 operation segment id reference to the field operational segment table
100
 sampling_end_time_whid int4 warehouse identifier for the sampling end time
100
 standard_survey_dim$record_type varchar standard survey record or reason record is unavailable
100
 depth_m numeric depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries)
100
 target_station_design_dim$upper_right_longitude_whid int4 upper right longitude warehouse identifier for a design type of grid
100
 target_station_design_dim$mean_depth_whid int4 mean depth warehouse identifier
100
 stomach_id numeric Stomach sample number or barcode
100
 target_station_design_dim$station_design_type varchar type of design underlying the survey station set: Transect or Grid to date
100
 trawl_id int8 identifier for a sampling operation
100
 station_ur_lat_dd numeric high precision value of upper right latitude of design type grid measured in decimal degrees
100
 width_type varchar describes how the measurement was calculated
100
 best_available_taxonomy_whid int4 warehouse identifier to best available taxonomy
100
 statistical_partition_dim$record_type varchar statistical partition record or reason record is unavailable
100
 species_category varchar upper-level taxonomic ranking
100
 field_identified_taxonomy_dim$hookandline_species_id int4 species identifier used by hook and line
100
 station_ll_lat_dd numeric high precision value of lower left latitude of design type grid measured in decimal degrees
100
 best_available_taxonomy_dim$subphylum_22 varchar subphylum name
100
 field_identified_taxonomy_dim$record_type varchar record or reason record is unavailable
100
 field_identified_taxonomy_dim$scientific_name_taxonomic_level varchar name of the lowest taxonomic level used to define scientific name
100
 longitude_dd numeric numeric representation of longitude in decimal degrees
100
 haul_longitude_dim$longitude_minute_units int2 numeric representation of longitude that makes up the minute unit only
100
 program varchar type of fram program
100
 width_observation_detail_dim$observation_type varchar the type of observation
100
 field_identified_taxonomy_dim$superorder_38 varchar superorder name
100
 operation_dim$operation_end_time_whid int8 end time reference for the operation
100
 target_station_design_dim$min_latitude_dd numeric high precision value of minimum latitude measured in decimal degrees
100
 most_recent_maturity_update_date_dim$yyyymmdd bpchar text representation of year month day
100
 most_recent_maturity_update_date_dim$month_name varchar text representation of month
100
 operation_dim$operation_start_time_whid int8 start time reference for the operation
100
 field_identified_taxonomy_dim$infraorder_44 varchar infraorder name
100
 standard_survey_dim$standard_survey_length_or_width_indicator varchar identifies if the individual is part of the Standard Length Survey
100
 length_timestamp timestamp Timestamp at the point the length is taken on an individual
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
 best_available_taxonomy_dim$pacfin_nom_spid varchar PacFIN nominal species identifier
100
 actual_station_design_dim$station_design_type varchar type of design underlying the survey station set: Transect or Grid to date
100
 field_identified_taxonomy_dim$worms_aphiaid int4 WoRMS taxonomic identifier
100
 max_depth_m numeric high precision value of maximum depth measured in meters
100
 field_identified_taxonomy_whid int4 warehouse identifier to field identified taxonomy
100
 most_recent_age_update_date_dim$month_of_year int2 numeric representation of month of year
100
 length_type varchar describes how the measurement was calculated
100
 station_lr_lon_dd numeric high precision value of lower right longitude of design type grid measured in decimal degrees
100
 haul_longitude_whid int4 warehouse identifier for haul longitude
100
 date_dim$year int4 numeric representation of year
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
 actual_station_design_whid int4 warehouse identifier for station design
100
 operation_dim$coast_guard_number varchar Coast Guard documentation number of vessel
100
 field_identified_taxonomy_dim$kingdom_10 varchar kingdom name
100
 most_recent_taxonomy_update_date_dim$record_type varchar date, month, or year record or reason record is unavailable
100
 most_recent_age_update_date_dim$month_name varchar text representation of month
100
 taxon_source varchar name of primary source used to get the measurement
100
 field_identified_taxonomy_dim$acoustics_species_id int4 Species ID used in the acoustics program
100
 sampling_end_time_dim$minute int2 number of minutes in the hour
100
 date_yyyymmdd bpchar text representation of year month day
100
 haul_latitude_dim$latitude_in_degree_minute_second varchar string representation of latitude in degrees, minutes, and seconds for example 4525'01"
100
 haul_latitude_dim$latitude_compass_direction bpchar latitude compass direction
100
 year int2 operation year
100
 most_recent_age_update_date_dim$record_type varchar date, month, or year record or reason record is unavailable
100
 field_identified_taxonomy_dim$subfamily_52 varchar subfamily name
100
 sampling_start_time_dim$hour int2 standard representation of the hour
100
 most_recent_maturity_update_date_dim$month_of_year int2 numeric representation of month of year
100
 lab_maturity_detail_dim$functionally_mature_certain_indicator varchar identifies the certainty of the functionally mature evaluation
100
 best_available_taxonomy_dim$subfamily_52 varchar subfamily name
100
 otosag_id int4 Otolith barcode or sample number
100
 haul_latitude_dim$latitude_second_units int2 numeric representation of latitude that makes up the second unit only
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
 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$departure_date_whid int8 date reference that vessel departed for the defined leg or trip
100
 length_observation_detail_dim$observation_type varchar the type of observation
100
 operation_dim$fpc_person_whid int4 person reference for the FPC
100
 actual_station_design_dim$transect_latitude_whid int4 latitude warehouse identifier for a design type of transect
100
 length_cm numeric Individual length measured in centimeters
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_end_date_whid int8 end date reference for the operation
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$max_depth_whid int4 maximum depth warehouse identifier
100
 actual_station_design_dim$min_depth_m numeric high precision value of minimum depth measured in meters
100
 operation_dim$return_date_whid int8 date reference that vessel returned for the defined leg or trip
100
 haul_longitude_dim$longitude_compass_direction bpchar longitude compass direction
100
 target_station_design_dim$transect_latitude_whid int4 latitude warehouse identifier for a design type of transect
100
 date_dim$full_date timestamp full date value
100
 target_station_design_dim$upper_left_latitude_whid int4 upper left latitude warehouse identifier for a design type of grid
100
 actual_station_design_dim$mean_depth_whid int4 mean depth warehouse identifier
100
 min_depth_m numeric high precision value of minimum depth measured in meters
100
 year_stn_invalid int2 Survey year the station became invalid for trawl
100
 length_observation_detail_dim$record_type varchar observation detail record type or reason record is unavailable
100
 target_station_design_dim$upper_left_longitude_whid int4 upper left longitude warehouse identifier for a design type of grid
100
 station_code varchar unique identifier for a station definition
100
 station_ul_lat_dd numeric high precision value of upper left latitude of design type grid measured in decimal degrees
100
 station_ll_lon_dd numeric high precision value of lower left longitude of design type grid measured in decimal degrees
100
 vessel varchar name of the vessel used for the operation
100
 most_recent_taxonomy_update_date_dim$month_of_year int2 numeric representation of month of year
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
 best_available_taxonomy_dim$superfamily_48 varchar superfamily name
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
 actual_station_design_dim$transect_latitude_dd numeric high precision value of transect latitude measured in decimal degrees
100
 weight_kg numeric Individual weight measured in kilograms
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
 width_observation_detail_dim$source_primary varchar name of primary source used to get the measurement
100
 target_station_design_dim$transect_station_longitude_whid int4 longitude on transect warehouse identifier for a design type of transect
100
 actual_station_design_dim$station_grid_dd polygon collection of vertices of grid points of a grid design measured in decimal degrees
100
 operation_dim$return_port_whid int4 port reference for return port
100
 actual_station_design_dim$min_latitude_dd numeric high precision value of minimum latitude measured in decimal degrees
100
 tow_end_timestamp timestamp operation end date timestamp
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
 field_identified_taxonomy_dim$subphylum_22 varchar subphylum name
100
 operation_dim$captain_person_whid int4 person reference for the vessel captain
100
 target_station_design_dim$lower_left_latitude_whid int4 lower left latitude warehouse identifier for a design type of grid
100
 length_observation_detail_dim$method_description varchar description of how the observation was taken
100
 best_available_taxonomy_dim$suborder_42 varchar suborder name
100
 most_recent_age_update_date_whid int8 Warehouse identifier for most recent age update date
100
 field_identified_taxonomy_dim$phylum_20 varchar phylum name
100
 best_available_taxonomy_dim$superclass_28 varchar superclass name
100
 statistical_partition_whid int4 warehouse identifier for statistical partition
100
 target_station_design_dim$upper_right_latitude_whid int4 upper right latitude warehouse identifier for a design type of grid
100
 length_observation_detail_dim$measurement_procurement varchar how the measurement was achieved
100
 length_observation_detail_whid int4 Warehouse identifier to taxonomy observation detail
100
 field_identified_taxonomy_dim$pacfin_spid varchar pacfin species id - many taxa may not have one of these
100
 operation_dim$ifq_account_number varchar unique number assigned to user accounts in the Vessel Accounting Database
100
 best_available_taxonomy_dim$subspecies_82 varchar subspecies name
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
 width_observation_detail_dim$measurement_procurement varchar how the measurement was achieved
100
 target_station_design_dim$area_hectares numeric station area measured in hectares
100
 age_years numeric Individual age measured in years
100
 sampling_start_hhmmss bpchar concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100
 most_recent_taxonomy_update_date_dim$month_name varchar text representation of month
100
 best_available_taxonomy_dim$hookandline_species_id int4 species identifier used by hook and line
100
 best_available_taxonomy_observation_detail_dim$observation_type varchar the type of observation
100
 field_identified_taxonomy_dim$genus_70 varchar genus name
100
 most_recent_taxonomy_update_date_dim$year int4 numeric representation of year
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
 field_identified_taxonomy_dim$abbreviated_name varchar specialized common name, generally for a well-known species of fish such as ATF, LST, SST
100
 operation_dim$scientist_4_person_whid int4 person reference for the fourth scientist
100
 actual_station_design_dim$lower_right_longitude_whid int4 lower right longitude warehouse identifier for a design type of grid
100
 target_station_design_dim$transect_latitude_dd numeric high precision value of transect latitude measured in decimal degrees
100
 mean_seafloor_dep_boundary varchar depth boundry indicator identifying ifp boundary marks
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
 sampling_start_time_dim$second int2 number of seconds in the minute
100
 actual_station_design_dim$station_invalid_survey_year int2 Survey year the station became invalid for trawl
100
 sampling_start_time_whid int4 warehouse identifier for the sampling start time
100
 target_station_design_dim$lower_right_longitude_whid int4 lower right longitude warehouse identifier for a design type of grid
100
 haul_longitude_dim$record_type varchar longitude record type or reason record is unavailable
100
 tissue_id numeric Tissue sample number or barcode
100
 actual_station_design_dim$transect_station_longitude_whid int4 longitude on transect warehouse identifier for a design type of transect
100
 best_available_taxonomy_dim$tribe_60 varchar tribe name
100
 field_note varchar Note made in the field about an individual
67
 sex_dim$sex varchar
100
 actual_station_design_dim$station_code varchar unique identifier for a station definition
100
 latitude_dd numeric numeric representation of latitude in degrees
100
 actual_station_design_dim$station_design_name varchar name of the design for a collection of stations
100
 lab_maturity_detail_dim$biologically_mature_certain_indicator varchar identifies the certainty of the biological maturity
100
 actual_station_design_dim$lower_right_latitude_whid int4 lower right latitude warehouse identifier for a design type of grid
100
 haul_longitude_dim$longitude_degree_units int2 numeric representation of longitude that makes up the degree unit only
100
 best_available_taxonomy_observation_detail_dim$means_of_calculation varchar describes how the measurement was calculated
100
 most_recent_age_update timestamp full date value
100
 actual_station_design_dim$area_hectares numeric station area measured in hectares
100
 taxon_rank varchar name of the lowest taxonomic level used to define scientific name
100
 best_available_taxonomy_observation_detail_dim$record_type varchar observation detail record type or reason record is unavailable
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
 field_identified_taxonomy_dim$observer_species_id int4 species identifier used by the observer program
100
 operation_dim_whid int8 warehouse identifier for operation
100
 operation_dim$scientist_2_person_whid int4 person reference for the second scientist
100
 most_recent_taxonomy_update_date_dim$yyyymmdd bpchar text representation of year month day
100
 best_available_taxonomy_dim$genus_70 varchar genus name
100
 net_touchdown_time time military time representation of the time
100
 best_available_taxonomy_dim$itis_taxonomic_serial_no int4 ITIS taxonomic identifier
100
 operation_dim$vessel_id int2 field database vessel id number
100
 left_pectoral_fin_id int4 Left pectoral fin sample number or barcode
100
 best_available_taxonomy_dim$worms_aphiaid int4 WoRMS taxonomic identifier
100
 lab_maturity_detail_dim$biologically_mature_indicator varchar identifies biological maturity of the individual
100
 most_recent_taxonomy_update_date_whid int8 Warehouse identifier for most recent taxonomy update date
100
 haul_latitude_whid int4 warehouse identifier for haul latitude
100
 operation_dim$state_registration_number varchar state registration number for the vessel
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
 date_dim$month_abbrev bpchar three character representation of month in capital letters
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
 best_available_taxonomy_observation_detail_dim$method_description varchar description of how the observation was taken
100
 width_observation_detail_whid int4 Warehouse identifier to taxonomy observation detail
100
 haul_latitude_dim$latitude_degree_units int2 numeric representation of latitude that makes up the degree unit only
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
 actual_station_design_dim$mean_depth_m numeric high precision value of mean depth measured in meters
100
 field_identified_taxonomy_dim$pacfin_nom_spid varchar PacFIN nominal species identifier
100
 field_identified_taxonomy_dim$superclass_28 varchar superclass name
100
 actual_station_design_dim$max_depth_m numeric high precision value of maximum depth measured in meters
100
 field_identified_taxonomy_dim$superfamily_48 varchar superfamily name
100
 most_recent_age_update_date_dim$month_abbrev bpchar three character representation of month in capital letters
100
 tow_start_timestamp timestamp operation start date timestamp
100
 actual_station_design_dim$reason_station_invalid varchar reason station was invalidated, multiple reasons are comma separated
100
 standard_survey_dim$standard_survey_maturity_indicator varchar identifies if the individual is part of the Standard Maturity Survey
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$infraclass_34 varchar infraclass name
100
 length_observation_detail_dim$source_primary varchar name of primary source used to get the measurement
100
 target_station_design_dim$max_latitude_dd numeric high precision value of maximum latitude measured in decimal degrees
100
 operation_dim$trip_id int4 trip identifier number
100
 sampling_start_time_dim$period bpchar period of time
100
 operation_dim$record_type varchar operation record or reason record is unavailable
100
 sampling_end_hhmmss bpchar concatenation of military hour, minute, second, example 230415 equates to 23:04:15
100
 date_dim$month_name varchar text representation of month
100
 target_station_design_dim$lower_left_longitude_whid int4 lower left longitude warehouse identifier for a design type of grid
100
 target_station_design_dim$station_grid_dd polygon collection of vertices of grid points of a grid design measured in decimal degrees
100
 most_recent_age_update_date_dim$day_of_month int2 numeric representation of the day in month
100
 tow int2 operation number of the survey
100
 actual_station_design_dim$stn_invalid_for_trawl_date_whid int8 station design invalidation date warehouse identifier
100
 standard_survey_dim$standard_survey_age_indicator varchar identifies if the individual is part of the Standard Age Survey
100
 width_observation_detail_dim$record_type varchar observation detail record type or reason record is unavailable
100
 field_identified_taxonomy_dim$infraclass_34 varchar infraclass name
100
 most_recent_maturity_update_date_dim$record_type varchar date, month, or year record or reason record is unavailable
100
 field_identified_taxonomy_dim$subspecies_82 varchar subspecies name
100
 best_available_taxonomy_dim$acoustics_species_id int4 Species ID used in the acoustics program
100
 actual_station_design_dim$max_latitude_whid int4 maximum latitude warehouse identifier for a design type of transect
100
 most_recent_age_update_date_dim$year int4 numeric representation of year
100
 species_subcategory varchar mid-level taxonomic ranking
100
 date_dim$day_of_month int2 numeric representation of the day in month
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
 field_identified_taxonomy_dim$tribe_60 varchar tribe name
100
 leg int2 leg number of the survey
100
 field_identified_taxonomy_dim$subclass_32 varchar subclass name
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
 station_ul_lon_dd numeric high precision value of upper left longitude of design type grid measured in decimal degrees
100
 most_recent_taxonomy_update_date_dim$month_abbrev bpchar three character representation of month in capital letters
100
 field_identified_taxonomy_dim$class_30 varchar class name
100
 sampling_end_time_dim$hour int2 standard representation of the hour
100
 actual_station_design_dim$upper_left_latitude_whid int4 upper left latitude warehouse identifier for a design type of grid
100
 sampling_start_time_dim$military_hour int2 military representation of the hour
100
 haul_longitude_dim$longitude_in_degree_minute_second varchar string representation of longitude in degrees, minutes, and seconds for example 4525'01"
100
 reason_stn_invalid varchar reason station was invalidated, multiple reasons are comma separated
100
 sampling_end_time_dim$second int2 number of seconds in the minute
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$trawl_survey_species_id int4 species identifier used by the trawl survey
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
 partition varchar Refines the partition type
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$suborder_42 varchar suborder name
100
 field_identified_taxonomy_dim$family_50 varchar family name
100
 sampling_end_time_dim$record_type varchar time record or reason record is unavailable
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
 best_available_taxonomy_dim$class_30 varchar class name
100
 seafloor_depth_whid int4 warehouse identifier for seafloor depth
100
 target_station_design_dim$mean_depth_m numeric high precision value of mean depth measured in meters
100
 field_identified_taxonomy_dim$species_sub_category varchar mid-level taxonomic ranking
100
 operation_dim$observer_program varchar description of the observer program
100
 lab_maturity_detail_dim$functionally_mature_indicator varchar identifies the functional maturity of the individual
100
 pacfin_spid varchar pacfin species id - many taxa may not have one of these
100
 best_available_taxonomy_dim$infraorder_44 varchar infraorder name
100
 most_recent_maturity_update_date_dim$day_of_month int2 numeric representation of the day in month
100
 statistical_partition_dim$statistical_partition_type varchar Defines the partition type
100
 target_station_design_dim$record_type varchar station design record or reason record is unavailable
100
 best_available_taxonomy_dim$order_40 varchar order name
100
 actual_station_design_dim$min_depth_whid int4 minimum depth warehouse identifier
100
 actual_station_design_dim$max_latitude_dd numeric high precision value of maximum latitude measured in decimal degrees
100
 field_identified_taxonomy_dim$order_40 varchar order name
100
 field_identified_taxonomy_dim$species_80 varchar species name
100
 sampling_end_time_dim$military_hour int2 military representation of the hour
100
 lab_maturity_detail_dim$record_type varchar lab maturity detail record or reason record is unavailable
100
 best_available_taxonomy_dim$species_80 varchar species name
100
 best_available_taxonomy_observation_detail_dim$measurement_procurement varchar how the measurement was achieved
100
 target_station_design_dim$lower_right_latitude_whid int4 lower right latitude warehouse identifier for a design type of grid
100
 operation_dim$operation_type varchar type of operation
100
 haul_latitude_dim$latitude_minute_units int2 numeric representation of latitude that makes up the minute unit only
100
 actual_station_design_dim$record_type varchar station design record or reason record is unavailable
100
 target_station_design_dim$max_depth_whid int4 maximum depth warehouse identifier
100
 best_available_taxonomy_dim$subclass_32 varchar subclass name
100
 haul_longitude_dim$longitude_second_units int2 numeric representation of longitude that makes up the second unit only
100
 sex_dim$record_type varchar latitude record type or reason record is unavailable
100
 actual_station_design_dim$min_latitude_whid int4 minimum latitude warehouse identifier for a design type of transect
100
 date_dim$month_of_year int2 numeric representation of month of year
100
 most_recent_maturity_update_date_dim$month_abbrev bpchar three character representation of month in capital letters
100
 operation_dim$limited_entry_permit_number bpchar federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California
67
 sex bpchar
100
 target_station_design_dim$station_design_name varchar name of the design for a collection of stations
100
 best_available_taxonomy_dim$trawl_survey_species_id int4 species identifier used by the trawl survey
100
 lab_maturity_detail_whid int2 Warehouse identifier for lab maturity details
100
 most_recent_maturity_update_date_dim$full_date timestamp full date value
100
 most_recent_maturity_update_date_dim$year int4 numeric representation of year

Attribute Details

actual_station_design_dim$transect_station_longitude_dd

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

standard_survey_dim$standard_survey_weight_indicator

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

identifies if the individual is part of the Standard Weight Survey
Allowed Values: Standard Survey Weight, Not Standard Survey Weight, NA

sampling_start_time_dim$minute

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

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

best_available_taxonomy_dim$phylum_20

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

phylum name

performance

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

actual_station_design_dim$upper_right_latitude_whid

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

date_dim$record_type

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

actual_station_design_dim$lower_left_longitude_dd

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

best_available_taxonomy_dim$structure_source

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

best_available_taxonomy_dim$family_50

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

family name

actual_station_design_dim$upper_right_longitude_dd

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

actual_station_design_dim$upper_right_longitude_whid

CC ID: 376851
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$lower_left_latitude_whid

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

best_available_taxonomy_dim$record_type

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

width_observation_detail_dim$method_description

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

description of how the observation was taken

station_ur_lon_dd

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

most_recent_taxonomy_update_date_dim$day_of_month

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

most_recent_age_update_date_dim$yyyymmdd

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

text representation of year month day

individual_tracking_id

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

Individual tracking id

ovary_id

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

Ovary sample number or barcode
Unit of Measure: unspecifid
Allowed Values: Any

target_station_design_dim$stn_invalid_for_trawl_date_whid

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

station design invalidation date warehouse identifier

standard_survey_whid

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

Warehouse identifier for standard survey

operation_dim$scientist_1_person_whid

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

person reference for the first scientist

most_recent_maturity_update_date_whid

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

Warehouse identifier for most recent maturity update date

net_liftoff_time

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

military time representation of the time

actual_station_design_dim$variance_depth_m2

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

target_station_design_dim$variance_depth_m2

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

target_station_design_dim$min_depth_whid

CC ID: 376867
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$transect_station_longitude_dd

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

actual_station_design_dim$lower_left_longitude_whid

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

field_identified_taxonomy_dim$itis_taxonomic_serial_no

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

operation_dim$departure_port_whid

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

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

sex_whid

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

Warehouse identifier to sex details

target_station_design_whid

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

warehouse identifier for target station design

target_station_design_dim$max_latitude_whid

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

actual_station_design_dim$upper_left_longitude_whid

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

pass

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

sampling_end_time_dim$period

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

period of time
Allowed Values: AM, PM

operation_dim$scientist_3_person_whid

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

person reference for the third scientist

field_identified_taxonomy_dim$structure_source

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

width_cm

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

Individual width measured in centimeters
Unit of Measure: cm

most_recent_taxon_update

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

full date value

best_available_taxonomy_dim$abbreviated_name

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

operation_dim$operation_start_date_whid

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

start date reference for the operation

best_available_taxonomy_dim$observer_species_id

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

species identifier used by the observer program

project

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

midtow_lat_named_parallel

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

field_identified_taxonomy_dim$species_category

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

centroid_id

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

sampling_start_time_dim$record_type

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

operation_dim$field_operation_seg_id

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

operation segment id reference to the field operational segment table

sampling_end_time_whid

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

warehouse identifier for the sampling end time

standard_survey_dim$record_type

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

standard survey record or reason record is unavailable
Allowed Values: Standard Survey, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

depth_m

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

target_station_design_dim$upper_right_longitude_whid

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

target_station_design_dim$mean_depth_whid

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

mean depth warehouse identifier

stomach_id

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

Stomach sample number or barcode
Unit of Measure: unspecified
Allowed Values: Any

target_station_design_dim$station_design_type

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

trawl_id

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

identifier for a sampling operation

station_ur_lat_dd

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

width_type

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

best_available_taxonomy_whid

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

warehouse identifier to best available taxonomy

statistical_partition_dim$record_type

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

species_category

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

field_identified_taxonomy_dim$hookandline_species_id

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

species identifier used by hook and line

station_ll_lat_dd

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

best_available_taxonomy_dim$subphylum_22

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

subphylum name

field_identified_taxonomy_dim$record_type

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

field_identified_taxonomy_dim$scientific_name_taxonomic_level

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

longitude_dd

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

haul_longitude_dim$longitude_minute_units

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

program

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

width_observation_detail_dim$observation_type

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

field_identified_taxonomy_dim$superorder_38

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

superorder name

operation_dim$operation_end_time_whid

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

end time reference for the operation

target_station_design_dim$min_latitude_dd

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

most_recent_maturity_update_date_dim$yyyymmdd

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

text representation of year month day

most_recent_maturity_update_date_dim$month_name

CC ID: 376918
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$operation_start_time_whid

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

start time reference for the operation

field_identified_taxonomy_dim$infraorder_44

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

infraorder name

standard_survey_dim$standard_survey_length_or_width_indicator

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

identifies if the individual is part of the Standard Length Survey
Allowed Values: Standard Survey Length, Not Standard Survey Length, NA

length_timestamp

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

Timestamp at the point the length is taken on an individual

field_identified_taxonomy_dim$common_name

CC ID: 376923
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$pacfin_nom_spid

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

actual_station_design_dim$station_design_type

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

field_identified_taxonomy_dim$worms_aphiaid

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

max_depth_m

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

field_identified_taxonomy_whid

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

warehouse identifier to field identified taxonomy

most_recent_age_update_date_dim$month_of_year

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

length_type

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

station_lr_lon_dd

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

haul_longitude_whid

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

warehouse identifier for haul longitude

date_dim$year

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

numeric representation of year
Allowed Values: 1978+

actual_station_design_dim$centroid_id

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

actual_station_design_whid

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

warehouse identifier for station design

operation_dim$coast_guard_number

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

Coast Guard documentation number of vessel

field_identified_taxonomy_dim$kingdom_10

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

kingdom name

most_recent_taxonomy_update_date_dim$record_type

CC ID: 376938
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_age_update_date_dim$month_name

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

taxon_source

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

field_identified_taxonomy_dim$acoustics_species_id

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

sampling_end_time_dim$minute

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

text representation of year month day

haul_latitude_dim$latitude_in_degree_minute_second

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

haul_latitude_dim$latitude_compass_direction

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

year

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

most_recent_age_update_date_dim$record_type

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

field_identified_taxonomy_dim$subfamily_52

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

subfamily name

sampling_start_time_dim$hour

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

most_recent_maturity_update_date_dim$month_of_year

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

lab_maturity_detail_dim$functionally_mature_certain_indicator

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

identifies the certainty of the functionally mature evaluation
Allowed Values: Functionally Mature Certain, Not Functionally Mature Certain, NA

best_available_taxonomy_dim$subfamily_52

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

subfamily name

otosag_id

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

Otolith barcode or sample number
Unit of Measure: unspecified
Allowed Values: Any

haul_latitude_dim$latitude_second_units

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

date_whid

CC ID: 376955
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: 376956
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

field_identified_taxonomy_dim$grp_nonstandard_taxon_99

CC ID: 376957
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$departure_date_whid

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

length_observation_detail_dim$observation_type

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

operation_dim$fpc_person_whid

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

person reference for the FPC

actual_station_design_dim$transect_latitude_whid

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

length_cm

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

Individual length measured in centimeters
Unit of Measure: cm

target_station_design_dim$active_polygon_dd

CC ID: 376963
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_end_date_whid

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

end date reference for the operation

field_identified_taxonomy_dim$scientific_name

CC ID: 376965
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$max_depth_whid

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

maximum depth warehouse identifier

actual_station_design_dim$min_depth_m

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

operation_dim$return_date_whid

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

haul_longitude_dim$longitude_compass_direction

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

longitude compass direction
Allowed Values: E, W

target_station_design_dim$transect_latitude_whid

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

date_dim$full_date

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

full date value

target_station_design_dim$upper_left_latitude_whid

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

actual_station_design_dim$mean_depth_whid

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

mean depth warehouse identifier

min_depth_m

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

year_stn_invalid

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

length_observation_detail_dim$record_type

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

target_station_design_dim$upper_left_longitude_whid

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

station_code

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

unique identifier for a station definition

station_ul_lat_dd

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

station_ll_lon_dd

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

vessel

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

most_recent_taxonomy_update_date_dim$month_of_year

CC ID: 376982
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$lower_left_latitude_dd

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

best_available_taxonomy_dim$superfamily_48

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

superfamily name

depth_ftm

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

actual_station_design_dim$transect_latitude_dd

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

weight_kg

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

Individual weight measured in kilograms
Unit of Measure: kg

field_identified_taxonomy_dim$grp_reg_depth_category

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

width_observation_detail_dim$source_primary

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

target_station_design_dim$transect_station_longitude_whid

CC ID: 376990
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$station_grid_dd

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

operation_dim$return_port_whid

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

port reference for return port

actual_station_design_dim$min_latitude_dd

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

tow_end_timestamp

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

operation end date timestamp

best_available_taxonomy_dim$grp_reg_depth_category

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

field_identified_taxonomy_dim$subphylum_22

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

subphylum name

operation_dim$captain_person_whid

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

person reference for the vessel captain

target_station_design_dim$lower_left_latitude_whid

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

length_observation_detail_dim$method_description

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

description of how the observation was taken

best_available_taxonomy_dim$suborder_42

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

suborder name

most_recent_age_update_date_whid

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

Warehouse identifier for most recent age update date

field_identified_taxonomy_dim$phylum_20

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

phylum name

best_available_taxonomy_dim$superclass_28

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

superclass name

statistical_partition_whid

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

warehouse identifier for statistical partition

target_station_design_dim$upper_right_latitude_whid

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

length_observation_detail_dim$measurement_procurement

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

length_observation_detail_whid

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

Warehouse identifier to taxonomy observation detail

field_identified_taxonomy_dim$pacfin_spid

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

operation_dim$ifq_account_number

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

best_available_taxonomy_dim$subspecies_82

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

subspecies name

scientific_name

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

width_observation_detail_dim$measurement_procurement

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

target_station_design_dim$area_hectares

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

age_years

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

Individual age measured in years
Unit of Measure: yrs

sampling_start_hhmmss

CC ID: 377015
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$month_name

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

best_available_taxonomy_dim$hookandline_species_id

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

species identifier used by hook and line

best_available_taxonomy_observation_detail_dim$observation_type

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

field_identified_taxonomy_dim$genus_70

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

genus name

most_recent_taxonomy_update_date_dim$year

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

numeric representation of year
Allowed Values: 1978+

actual_station_design_dim$active_polygon_dd

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

field_identified_taxonomy_dim$abbreviated_name

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

operation_dim$scientist_4_person_whid

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

person reference for the fourth scientist

actual_station_design_dim$lower_right_longitude_whid

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

target_station_design_dim$transect_latitude_dd

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

mean_seafloor_dep_boundary

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

best_available_taxonomy_dim$grp_nonstandard_taxon_99

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

sampling_start_time_dim$second

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

actual_station_design_dim$station_invalid_survey_year

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

sampling_start_time_whid

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

warehouse identifier for the sampling start time

target_station_design_dim$lower_right_longitude_whid

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

haul_longitude_dim$record_type

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

tissue_id

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

Tissue sample number or barcode
Unit of Measure: unspecified
Allowed Values: Any

actual_station_design_dim$transect_station_longitude_whid

CC ID: 377034
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$tribe_60

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

tribe name

field_note

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

Note made in the field about an individual

sex_dim$sex

CC ID: 377037
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Unit of Measure: unspecified
Allowed Values: Any

actual_station_design_dim$station_code

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

unique identifier for a station definition

latitude_dd

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

actual_station_design_dim$station_design_name

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

name of the design for a collection of stations

lab_maturity_detail_dim$biologically_mature_certain_indicator

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

identifies the certainty of the biological maturity
Allowed Values: Biologically Mature Certain, Not Biologically Mature Certain, NA

actual_station_design_dim$lower_right_latitude_whid

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

haul_longitude_dim$longitude_degree_units

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

best_available_taxonomy_observation_detail_dim$means_of_calculation

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

most_recent_age_update

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

full date value

actual_station_design_dim$area_hectares

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

taxon_rank

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

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

best_available_taxonomy_dim$norpac_species_id

CC ID: 377049
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$observer_species_id

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

species identifier used by the observer program

operation_dim_whid

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

warehouse identifier for operation

operation_dim$scientist_2_person_whid

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

person reference for the second scientist

most_recent_taxonomy_update_date_dim$yyyymmdd

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

text representation of year month day

best_available_taxonomy_dim$genus_70

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

genus name

net_touchdown_time

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

military time representation of the time

best_available_taxonomy_dim$itis_taxonomic_serial_no

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

operation_dim$vessel_id

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

field database vessel id number

left_pectoral_fin_id

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

Left pectoral fin sample number or barcode
Unit of Measure: unspecified
Allowed Values: Any

best_available_taxonomy_dim$worms_aphiaid

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

lab_maturity_detail_dim$biologically_mature_indicator

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

identifies biological maturity of the individual
Allowed Values: Biologically Mature, Not Biologically Mature, NA

most_recent_taxonomy_update_date_whid

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

haul_latitude_whid

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

warehouse identifier for haul latitude

operation_dim$state_registration_number

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

state registration number for the vessel

actual_station_design_dim$upper_right_latitude_dd

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

date_dim$month_abbrev

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

actual_station_design_dim$upper_left_longitude_dd

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

best_available_taxonomy_observation_detail_dim$method_description

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

description of how the observation was taken

width_observation_detail_whid

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

Warehouse identifier to taxonomy observation detail

haul_latitude_dim$latitude_degree_units

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

common_name

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

actual_station_design_dim$mean_depth_m

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

field_identified_taxonomy_dim$pacfin_nom_spid

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

field_identified_taxonomy_dim$superclass_28

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

superclass name

actual_station_design_dim$max_depth_m

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

field_identified_taxonomy_dim$superfamily_48

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

superfamily name

most_recent_age_update_date_dim$month_abbrev

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

tow_start_timestamp

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

operation start date timestamp

actual_station_design_dim$reason_station_invalid

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

standard_survey_dim$standard_survey_maturity_indicator

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

identifies if the individual is part of the Standard Maturity Survey
Allowed Values: Standard Survey Maturity, Not Standard Survey Maturity, NA

station_lr_lat_dd

CC ID: 377080
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$infraclass_34

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

infraclass name

length_observation_detail_dim$source_primary

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

target_station_design_dim$max_latitude_dd

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

operation_dim$trip_id

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

trip identifier number

sampling_start_time_dim$period

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

period of time
Allowed Values: AM, PM

operation_dim$record_type

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

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

sampling_end_hhmmss

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

date_dim$month_name

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

target_station_design_dim$lower_left_longitude_whid

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

target_station_design_dim$station_grid_dd

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

most_recent_age_update_date_dim$day_of_month

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

tow

CC ID: 377092
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$stn_invalid_for_trawl_date_whid

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

station design invalidation date warehouse identifier

standard_survey_dim$standard_survey_age_indicator

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

identifies if the individual is part of the Standard Age Survey
Allowed Values: Standard Survey Age, Not Standard Survey Age, NA

width_observation_detail_dim$record_type

CC ID: 377095
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$infraclass_34

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

infraclass name

most_recent_maturity_update_date_dim$record_type

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

field_identified_taxonomy_dim$subspecies_82

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

subspecies name

best_available_taxonomy_dim$acoustics_species_id

CC ID: 377099
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$max_latitude_whid

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

most_recent_age_update_date_dim$year

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

numeric representation of year
Allowed Values: 1978+

species_subcategory

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

date_dim$day_of_month

CC ID: 377103
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_latitude_dd

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

field_identified_taxonomy_dim$tribe_60

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

tribe name

leg

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

field_identified_taxonomy_dim$subclass_32

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

subclass name

best_available_taxonomy_observation_detail_whid

CC ID: 377108
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: 377109
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

station_ul_lon_dd

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

most_recent_taxonomy_update_date_dim$month_abbrev

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

field_identified_taxonomy_dim$class_30

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

class name

sampling_end_time_dim$hour

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

actual_station_design_dim$upper_left_latitude_whid

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

sampling_start_time_dim$military_hour

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

haul_longitude_dim$longitude_in_degree_minute_second

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

reason_stn_invalid

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

sampling_end_time_dim$second

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

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

best_available_taxonomy_dim$superorder_38

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

kingdom name

field_identified_taxonomy_dim$trawl_survey_species_id

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

species identifier used by the trawl survey

actual_station_design_dim$lower_right_latitude_dd

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

partition

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

field_identified_taxonomy_dim$norpac_species_id

CC ID: 377124
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$suborder_42

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

suborder name

field_identified_taxonomy_dim$family_50

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

family name

sampling_end_time_dim$record_type

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

actual_station_design_dim$lower_right_longitude_dd

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

best_available_taxonomy_dim$class_30

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

class name

seafloor_depth_whid

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

warehouse identifier for seafloor depth

target_station_design_dim$mean_depth_m

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

field_identified_taxonomy_dim$species_sub_category

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

operation_dim$observer_program

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

description of the observer program

lab_maturity_detail_dim$functionally_mature_indicator

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

identifies the functional maturity of the individual
Allowed Values: Functionally Mature, Not Functionally Mature, NA

pacfin_spid

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

best_available_taxonomy_dim$infraorder_44

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

infraorder name

most_recent_maturity_update_date_dim$day_of_month

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

statistical_partition_dim$statistical_partition_type

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

target_station_design_dim$record_type

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

best_available_taxonomy_dim$order_40

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

order name

actual_station_design_dim$min_depth_whid

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

minimum depth warehouse identifier

actual_station_design_dim$max_latitude_dd

CC ID: 377142
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$order_40

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

order name

field_identified_taxonomy_dim$species_80

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

species name

sampling_end_time_dim$military_hour

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

lab_maturity_detail_dim$record_type

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

lab maturity detail record or reason record is unavailable
Allowed Values: Lab Maturity Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned

best_available_taxonomy_dim$species_80

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

species name

best_available_taxonomy_observation_detail_dim$measurement_procurement

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

target_station_design_dim$lower_right_latitude_whid

CC ID: 377149
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$operation_type

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

haul_latitude_dim$latitude_minute_units

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

actual_station_design_dim$record_type

CC ID: 377152
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$max_depth_whid

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

maximum depth warehouse identifier

best_available_taxonomy_dim$subclass_32

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

subclass name

haul_longitude_dim$longitude_second_units

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

sex_dim$record_type

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

actual_station_design_dim$min_latitude_whid

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

date_dim$month_of_year

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

most_recent_maturity_update_date_dim$month_abbrev

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

operation_dim$limited_entry_permit_number

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

sex

CC ID: 377161
Data Storage Type: bpchar
Max Length: 1
Required: No
Primary Key: No
Status: Active
Unit of Measure: unspecified
Allowed Values: Any

target_station_design_dim$station_design_name

CC ID: 377162
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$trawl_survey_species_id

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

species identifier used by the trawl survey

lab_maturity_detail_whid

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

Warehouse identifier for lab maturity details

most_recent_maturity_update_date_dim$full_date

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

full date value

most_recent_maturity_update_date_dim$year

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

numeric representation of year
Allowed Values: 1978+

Catalog Details

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