36438 Entity Published / External 18418 West Coast Groundfish Bottom Trawl Survey Data - 2020 West Coast Groundfish Bottom Trawl Survey and indices of abundance Data Set Data Table Individuals caught and measured on the bottom trawl survey actual_station_design_dim$active_polygon_dd polygon No No Active collection of vertices of the usuable area inside a station grid measured in decimal degrees dd actual_station_design_dim$area_hectares numeric 12 No No 8 Active station area measured in hectares hectares actual_station_design_dim$centroid_id numeric 10 No No 0 Active 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_dim$lower_left_latitude_dd numeric 12 No No 8 Active high precision value of lower left latitude of design type grid measured in decimal degrees dd actual_station_design_dim$lower_left_latitude_whid int4 32 No No 0 Active lower left latitude warehouse identifier for a design type of grid actual_station_design_dim$lower_left_longitude_dd numeric 12 No No 8 Active high precision value of lower left longitude of design type grid measured in decimal degrees dd actual_station_design_dim$lower_right_latitude_dd numeric 12 No No 8 Active high precision value of lower right latitude of design type grid measured in decimal degrees dd actual_station_design_dim$lower_right_latitude_whid int4 32 No No 0 Active lower right latitude warehouse identifier for a design type of grid actual_station_design_dim$lower_right_longitude_dd numeric 12 No No 8 Active high precision value of lower right longitude of design type grid measured in decimal degrees dd actual_station_design_dim$lower_right_longitude_whid int4 32 No No 0 Active lower right longitude warehouse identifier for a design type of grid actual_station_design_dim$max_depth_whid int4 32 No No 0 Active maximum depth warehouse identifier actual_station_design_dim$max_latitude_whid int4 32 No No 0 Active maximum latitude warehouse identifier for a design type of transect actual_station_design_dim$min_depth_m numeric 12 No No 4 Active high precision value of minimum depth measured in meters m actual_station_design_dim$min_latitude_dd numeric 12 No No 8 Active high precision value of minimum latitude measured in decimal degrees dd actual_station_design_dim$min_latitude_whid int4 32 No No 0 Active minimum latitude warehouse identifier for a design type of transect actual_station_design_dim$record_type varchar 30 No No Active station design record or reason record is unavailable Station Design, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned actual_station_design_dim$station_design_type varchar 15 No No Active type of design underlying the survey station set: Transect or Grid to date Transect, Grid actual_station_design_dim$station_grid_dd polygon No No Active collection of vertices of grid points of a grid design measured in decimal degrees dd actual_station_design_dim$stn_invalid_for_trawl_date_whid int8 64 No No 0 Active station design invalidation date warehouse identifier actual_station_design_dim$transect_latitude_dd numeric 12 No No 8 Active high precision value of transect latitude measured in decimal degrees dd actual_station_design_dim$transect_latitude_whid int4 32 No No 0 Active latitude warehouse identifier for a design type of transect actual_station_design_dim$transect_station_longitude_dd numeric 12 No No 8 Active high precision value of transect station longitude measured in decimal degrees dd actual_station_design_dim$upper_right_longitude_dd numeric 12 No No 8 Active high precision value of upper right longitude of design type grid measured in decimal degrees dd actual_station_design_dim$upper_right_longitude_whid int4 32 No No 0 Active upper right longitude warehouse identifier for a design type of grid actual_station_design_dim$variance_depth_m2 numeric 12 No No 4 Active high precision value of variance depth mesured in squared meters m2 actual_station_design_dim$lower_left_longitude_whid int4 32 No No 0 Active lower left longitude warehouse identifier for a design type of grid unspecified Any actual_station_design_dim$upper_left_longitude_whid int4 32 No No 0 Active upper left longitude warehouse identifier for a design type of grid actual_station_design_dim$max_depth_m numeric 12 No No 4 Active high precision value of maximum depth measured in meters m actual_station_design_dim$mean_depth_m numeric 12 No No 4 Active high precision value of mean depth measured in meters m actual_station_design_dim$reason_station_invalid varchar 150 No No Active reason station was invalidated, multiple reasons are comma separated California State MPA, Cowcod Conservation Area, ENC Avoidance, Farallon Island Radioactive Waste Dump, ONMS MPA, ONMS Permit Exclusion, Outside Survey Extent, Mooring, San Clemente Is. Military test range actual_station_design_dim$max_latitude_dd numeric 12 No No 8 Active high precision value of maximum latitude measured in decimal degrees dd actual_station_design_dim$min_depth_whid int4 32 No No 0 Active minimum depth warehouse identifier actual_station_design_dim$mean_depth_whid int4 32 No No 0 Active mean depth warehouse identifier actual_station_design_dim$station_code varchar 12 No No Active unique identifier for a station definition actual_station_design_dim$station_design_name varchar 50 No No Active name of the design for a collection of stations actual_station_design_dim$station_invalid_survey_year int2 16 No No Active Survey year the station became invalid for trawl year Any actual_station_design_dim$transect_station_longitude_whid int4 32 No No 0 Active longitude on transect warehouse identifier for a design type of transect actual_station_design_dim$upper_left_latitude_dd numeric 12 No No 8 Active high precision value of upper left latitude of design type grid measured in decimal degrees dd actual_station_design_dim$upper_left_latitude_whid int4 32 No No 0 Active upper left latitude warehouse identifier for a design type of grid actual_station_design_dim$upper_left_longitude_dd numeric 12 No No 8 Active high precision value of upper left longitude of design type grid measured in decimal degrees dd actual_station_design_dim$upper_right_latitude_dd numeric 12 No No 8 Active high precision value of upper right latitude of design type grid measured in decimal degrees dd actual_station_design_dim$upper_right_latitude_whid int4 32 No No 0 Active upper right latitude warehouse identifier for a design type of grid actual_station_design_whid int4 32 No No 0 Active warehouse identifier for station design age_years numeric 10 No No 0 Active Individual age measured in years yrs best_available_taxonomy_dim$abbreviated_name varchar 50 No No Active specialized common name, generally for a well-known species of fish such as ATF, LST, SST best_available_taxonomy_dim$acoustics_species_id int4 32 No No 0 Active Species ID used in the acoustics program unspecified Any best_available_taxonomy_dim$class_30 varchar 50 No No Active class name best_available_taxonomy_dim$family_50 varchar 50 No No Active family name best_available_taxonomy_dim$genus_70 varchar 50 No No Active genus name best_available_taxonomy_dim$grp_nonstandard_taxon_99 varchar 50 No No Active 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 best_available_taxonomy_dim$grp_reg_depth_category varchar 25 No No Active management grouping mostly for rockfishes (but could be assigned to any species): nearshore, shelf, or slope, or in future shallower shelf and deeper shelf best_available_taxonomy_dim$hookandline_species_id int4 32 No No 0 Active species identifier used by hook and line best_available_taxonomy_dim$infraclass_34 varchar 50 No No Active infraclass name best_available_taxonomy_dim$infraorder_44 varchar 50 No No Active infraorder name best_available_taxonomy_dim$itis_taxonomic_serial_no int4 32 No No 0 Active ITIS taxonomic identifier unspecified Any best_available_taxonomy_dim$kingdom_10 varchar 50 No No Active kingdom name best_available_taxonomy_dim$norpac_species_id int4 32 No No 0 Active 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. unspecified Any best_available_taxonomy_dim$observer_species_id int4 32 No No 0 Active species identifier used by the observer program best_available_taxonomy_dim$order_40 varchar 50 No No Active order name best_available_taxonomy_dim$pacfin_nom_spid varchar 10 No No 0 Active PacFIN nominal species identifier unspecified Any best_available_taxonomy_dim$phylum_20 varchar 50 No No Active phylum name best_available_taxonomy_dim$record_type varchar 50 No No Active record or reason record is unavailable Taxonomy, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned best_available_taxonomy_dim$species_80 varchar 50 No No Active species name best_available_taxonomy_dim$structure_source varchar 50 No No 0 Active Source of the taxonomic structure unspecified Any best_available_taxonomy_dim$subclass_32 varchar 50 No No Active subclass name best_available_taxonomy_dim$subfamily_52 varchar 50 No No Active subfamily name best_available_taxonomy_dim$superfamily_48 varchar 50 No No Active superfamily name best_available_taxonomy_dim$superorder_38 varchar 50 No No Active superorder name best_available_taxonomy_dim$trawl_survey_species_id int4 32 No No 0 Active species identifier used by the trawl survey best_available_taxonomy_dim$tribe_60 varchar 50 No No Active tribe name best_available_taxonomy_dim$worms_aphiaid int4 32 No No 0 Active WoRMS taxonomic identifier unspecified Any best_available_taxonomy_observation_detail_dim$means_of_calculation varchar 30 No No Active describes how the measurement was calculated Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned best_available_taxonomy_observation_detail_dim$measurement_procurement varchar 30 No No Active how the measurement was achieved NA, Calculated, Estimated, Observed, Measured, Not Documented best_available_taxonomy_observation_detail_dim$method_description varchar 500 No No Active description of how the observation was taken best_available_taxonomy_observation_detail_dim$observation_type varchar 30 No No Active the type of observation NA, width, length, total_catch_weight, taxonomy, etc best_available_taxonomy_observation_detail_dim$record_type varchar 30 No No Active observation detail record type or reason record is unavailable Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned best_available_taxonomy_observation_detail_whid int4 32 No No 0 Active warehouse identifier to best available taxonomy observation detail centroid_id numeric 10 No No 0 Active 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. best_available_taxonomy_dim$suborder_42 varchar 50 No No Active suborder name best_available_taxonomy_dim$subspecies_82 varchar 50 No No Active subspecies name best_available_taxonomy_dim$superclass_28 varchar 50 No No Active superclass name best_available_taxonomy_dim$subphylum_22 varchar 50 No No Active subphylum name best_available_taxonomy_whid int4 32 No No 0 Active warehouse identifier to best available taxonomy common_name varchar 50 No No Active 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 date_dim$day_of_month int2 16 No No 0 Active numeric representation of the day in month 1-31 date_dim$full_date timestamp No No Active full date value date_dim$month_abbrev bpchar 3 No No Active three character representation of month in capital letters JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC date_dim$month_name varchar 10 No No Active text representation of month January, February, March, April, May, June, July, August, September, October, November, December date_dim$month_of_year int2 16 No No 0 Active numeric representation of month of year 1-12 date_dim$record_type varchar 30 No No Active date, month, or year record or reason record is unavailable Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned date_dim$year int4 32 No No 0 Active numeric representation of year 1978+ date_whid int8 64 No No 0 Active warehouse identifier for date depth_ftm numeric 12 No No 4 Active depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries fth depth_m numeric 12 No No 4 Active depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries) m 0-1500 field_identified_taxonomy_dim$abbreviated_name varchar 50 No No Active specialized common name, generally for a well-known species of fish such as ATF, LST, SST field_identified_taxonomy_dim$class_30 varchar 50 No No Active class name field_identified_taxonomy_dim$common_name varchar 50 No No Active only one broadly used common name is supported by this design. If the common name is not fairly universally used or is used by more than one taxon this should be left null field_identified_taxonomy_dim$family_50 varchar 50 No No Active family name field_identified_taxonomy_dim$genus_70 varchar 50 No No Active genus name field_identified_taxonomy_dim$grp_nonstandard_taxon_99 varchar 50 No No Active 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 field_identified_taxonomy_dim$grp_reg_depth_category varchar 25 No No Active 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$hookandline_species_id int4 32 No No 0 Active species identifier used by hook and line field_identified_taxonomy_dim$infraclass_34 varchar 50 No No Active infraclass name field_identified_taxonomy_dim$infraorder_44 varchar 50 No No Active infraorder name field_identified_taxonomy_dim$itis_taxonomic_serial_no int4 32 No No 0 Active ITIS taxonomic identifier unspecified Any field_identified_taxonomy_dim$kingdom_10 varchar 50 No No Active kingdom name field_identified_taxonomy_dim$norpac_species_id int4 32 No No 0 Active 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. unspecified Any field_identified_taxonomy_dim$observer_species_id int4 32 No No 0 Active species identifier used by the observer program field_identified_taxonomy_dim$order_40 varchar 50 No No Active order name field_identified_taxonomy_dim$pacfin_nom_spid varchar 10 No No 0 Active PacFIN nominal species identifier unspecified Any field_identified_taxonomy_dim$pacfin_spid varchar 10 No No Active pacfin species id - many taxa may not have one of these field_identified_taxonomy_dim$phylum_20 varchar 50 No No Active phylum name field_identified_taxonomy_dim$scientific_name varchar 120 No No Active scientific name generally composed of the genus and species name and subspecies name if available, but may be the highest taxonomic level field_identified_taxonomy_dim$species_80 varchar 50 No No Active species name field_identified_taxonomy_dim$species_category varchar 40 No No Active upper-level taxonomic ranking fish, invertebrate, mammal, seabird, reptile, nonspecific organics, NA field_identified_taxonomy_dim$species_sub_category varchar 40 No No Active mid-level taxonomic ranking rockfish, flatfish, shark, crab, NA field_identified_taxonomy_dim$structure_source varchar 50 No No 0 Active Source of the taxonomic structure unspecified Any field_identified_taxonomy_dim$subclass_32 varchar 50 No No Active subclass name field_identified_taxonomy_dim$subfamily_52 varchar 50 No No Active subfamily name field_identified_taxonomy_dim$suborder_42 varchar 50 No No Active suborder name field_identified_taxonomy_dim$subphylum_22 varchar 50 No No Active subphylum name field_identified_taxonomy_dim$subspecies_82 varchar 50 No No Active subspecies name field_identified_taxonomy_dim$superclass_28 varchar 50 No No Active superclass name field_identified_taxonomy_dim$superfamily_48 varchar 50 No No Active superfamily name field_identified_taxonomy_dim$trawl_survey_species_id int4 32 No No 0 Active species identifier used by the trawl survey field_identified_taxonomy_dim$tribe_60 varchar 50 No No Active tribe name field_identified_taxonomy_dim$worms_aphiaid int4 32 No No 0 Active WoRMS taxonomic identifier unspecified Any field_identified_taxonomy_whid int4 32 No No 0 Active warehouse identifier to field identified taxonomy field_note varchar 1000 No No Active Note made in the field about an individual haul_latitude_dim$latitude_compass_direction bpchar 1 No No Active latitude compass direction NA N, S date_yyyymmdd bpchar 8 No No Active text representation of year month day field_identified_taxonomy_dim$acoustics_species_id int4 32 No No 0 Active Species ID used in the acoustics program unspecified Any field_identified_taxonomy_dim$record_type varchar 50 No No Active record or reason record is unavailable Taxonomy, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned field_identified_taxonomy_dim$scientific_name_taxonomic_level varchar 15 No No Active name of the lowest taxonomic level used to define scientific name field_identified_taxonomy_dim$superorder_38 varchar 50 No No Active superorder name haul_latitude_dim$latitude_degree_units int2 16 No No 0 Active numeric representation of latitude that makes up the degree unit only deg -90 to 90 haul_latitude_dim$latitude_in_degree_minute_second varchar 20 No No Active string representation of latitude in degrees, minutes, and seconds for example 4525'01" NA any haul_latitude_dim$latitude_minute_units int2 16 No No 0 Active numeric representation of latitude that makes up the minute unit only min 0-60 haul_latitude_dim$latitude_second_units int2 16 No No 0 Active numeric representation of latitude that makes up the second unit only sec 0-60 haul_latitude_dim$record_type varchar 30 No No Active latitude record type or reason record is unavailable NA Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned haul_latitude_whid int4 32 No No 0 Active warehouse identifier for haul latitude haul_longitude_dim$longitude_compass_direction bpchar 1 No No Active longitude compass direction E, W haul_longitude_dim$longitude_degree_units int2 16 No No 0 Active numeric representation of longitude that makes up the degree unit only deg -180 to 180 haul_longitude_dim$longitude_in_degree_minute_second varchar 20 No No Active string representation of longitude in degrees, minutes, and seconds for example 4525'01" haul_longitude_dim$longitude_minute_units int2 16 No No 0 Active numeric representation of longitude that makes up the minute unit only min 0-59 haul_longitude_dim$longitude_second_units int2 16 No No 0 Active numeric representation of longitude that makes up the second unit only sec 0-59 haul_longitude_dim$record_type varchar 50 No No Active longitude record type or reason record is unavailable Longitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned haul_longitude_whid int4 32 No No 0 Active warehouse identifier for haul longitude individual_tracking_id int8 64 No No 0 Active Individual tracking id lab_maturity_detail_dim$biologically_mature_certain_indicator varchar 40 No No Active identifies the certainty of the biological maturity Biologically Mature Certain, Not Biologically Mature Certain, NA lab_maturity_detail_dim$biologically_mature_indicator varchar 25 No No Active identifies biological maturity of the individual Biologically Mature, Not Biologically Mature, NA lab_maturity_detail_dim$functionally_mature_certain_indicator varchar 40 No No Active identifies the certainty of the functionally mature evaluation Functionally Mature Certain, Not Functionally Mature Certain, NA lab_maturity_detail_dim$functionally_mature_indicator varchar 25 No No Active identifies the functional maturity of the individual Functionally Mature, Not Functionally Mature, NA lab_maturity_detail_dim$record_type varchar 30 No No Active lab maturity detail record or reason record is unavailable Lab Maturity Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned lab_maturity_detail_whid int2 16 No No 0 Active Warehouse identifier for lab maturity details latitude_dd numeric 12 No No 8 Active numeric representation of latitude in degrees dd -90 to 90 left_pectoral_fin_id int4 25 No No Active Left pectoral fin sample number or barcode unspecified Any leg int2 16 No No 0 Active leg number of the survey 1,2,3,4,5,6,7,8 length_cm numeric 8 No No 4 Active Individual length measured in centimeters cm length_observation_detail_dim$measurement_procurement varchar 30 No No Active how the measurement was achieved NA, Calculated, Estimated, Observed, Measured, Not Documented length_observation_detail_dim$method_description varchar 500 No No Active description of how the observation was taken length_observation_detail_dim$observation_type varchar 30 No No Active the type of observation NA, width, length, total_catch_weight, taxonomy, etc length_observation_detail_dim$record_type varchar 30 No No Active observation detail record type or reason record is unavailable Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned length_observation_detail_dim$source_primary varchar 50 No No Active name of primary source used to get the measurement Angler, FPC, Genetics, Lab Exam, Large Scale, Morphometrics, Morphometrics + Genetics, NA, Quality Assurance, Retrospective Review, Taxon Rank Upped, Whole Organism length_observation_detail_whid int4 32 No No 0 Active Warehouse identifier to taxonomy observation detail length_timestamp timestamp No No Active Timestamp at the point the length is taken on an individual length_type varchar 30 No No Active describes how the measurement was calculated Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned longitude_dd numeric 12 No No 8 Active numeric representation of longitude in decimal degrees dd -180 to 180 max_depth_m numeric 12 No No 4 Active high precision value of maximum depth measured in meters m mean_seafloor_dep_boundary varchar 40 No No Active depth boundry indicator identifying ifp boundary marks IFP Boundary Depth, Standard Contour Depth, NA midtow_lat_named_parallel varchar 50 No No Active name of parallel, boundary, or commonly used geograpical location NA any min_depth_m numeric 12 No No 4 Active high precision value of minimum depth measured in meters m most_recent_age_update timestamp No No Active full date value most_recent_age_update_date_dim$day_of_month int2 16 No No 0 Active numeric representation of the day in month 1-31 most_recent_age_update_date_dim$month_abbrev bpchar 3 No No Active three character representation of month in capital letters JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC most_recent_age_update_date_dim$month_name varchar 10 No No Active text representation of month January, February, March, April, May, June, July, August, September, October, November, December most_recent_age_update_date_dim$month_of_year int2 16 No No 0 Active numeric representation of month of year 1-12 most_recent_age_update_date_dim$record_type varchar 30 No No Active date, month, or year record or reason record is unavailable Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned most_recent_age_update_date_dim$year int4 32 No No 0 Active numeric representation of year 1978+ most_recent_age_update_date_dim$yyyymmdd bpchar 8 No No Active text representation of year month day most_recent_age_update_date_whid int8 64 No No 0 Active Warehouse identifier for most recent age update date most_recent_maturity_update_date_dim$day_of_month int2 16 No No 0 Active numeric representation of the day in month 1-31 most_recent_maturity_update_date_dim$full_date timestamp No No Active full date value most_recent_maturity_update_date_dim$month_abbrev bpchar 3 No No Active three character representation of month in capital letters JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC most_recent_maturity_update_date_dim$month_name varchar 10 No No Active text representation of month January, February, March, April, May, June, July, August, September, October, November, December most_recent_maturity_update_date_dim$month_of_year int2 16 No No 0 Active numeric representation of month of year 1-12 most_recent_maturity_update_date_dim$record_type varchar 30 No No Active date, month, or year record or reason record is unavailable Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned most_recent_maturity_update_date_dim$year int4 32 No No 0 Active numeric representation of year 1978+ most_recent_maturity_update_date_dim$yyyymmdd bpchar 8 No No Active text representation of year month day most_recent_maturity_update_date_whid int8 64 No No 0 Active Warehouse identifier for most recent maturity update date most_recent_taxon_update timestamp No No Active full date value most_recent_taxonomy_update_date_dim$day_of_month int2 16 No No 0 Active numeric representation of the day in month 1-31 most_recent_taxonomy_update_date_dim$month_abbrev bpchar 3 No No Active three character representation of month in capital letters JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC most_recent_taxonomy_update_date_dim$month_name varchar 10 No No Active text representation of month January, February, March, April, May, June, July, August, September, October, November, December most_recent_taxonomy_update_date_dim$month_of_year int2 16 No No 0 Active numeric representation of month of year 1-12 most_recent_taxonomy_update_date_dim$record_type varchar 30 No No Active date, month, or year record or reason record is unavailable Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned most_recent_taxonomy_update_date_dim$year int4 32 No No 0 Active numeric representation of year 1978+ most_recent_taxonomy_update_date_dim$yyyymmdd bpchar 8 No No Active text representation of year month day most_recent_taxonomy_update_date_whid int8 64 No No 0 Active Warehouse identifier for most recent taxonomy update date net_liftoff_time time No No Active military time representation of the time net_touchdown_time time No No Active military time representation of the time operation_dim$captain_person_whid int4 32 No No 0 Active person reference for the vessel captain operation_dim$coast_guard_number varchar 10 No No Active Coast Guard documentation number of vessel operation_dim$departure_date_whid int8 64 No No 0 Active date reference that vessel departed for the defined leg or trip operation_dim$departure_port_whid int4 32 No No 0 Active port reference for the departure port operation_dim$field_operation_seg_id int8 64 No No 0 Active operation segment id reference to the field operational segment table operation_dim$fpc_person_whid int4 32 No No 0 Active person reference for the FPC operation_dim$ifq_account_number varchar 12 No No Active unique number assigned to user accounts in the Vessel Accounting Database operation_dim$limited_entry_permit_number bpchar 6 No No Active federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California operation_dim$observer_program varchar 150 No No Active description of the observer program operation_dim$operation_end_date_whid int8 64 No No 0 Active end date reference for the operation operation_dim$operation_end_time_whid int8 64 No No 0 Active end time reference for the operation operation_dim$operation_start_date_whid int8 64 No No 0 Active start date reference for the operation operation_dim$operation_start_time_whid int8 64 No No 0 Active start time reference for the operation operation_dim$operation_type varchar 20 No No Active type of operation CTD Cast, Drop, Experiment, Search, Trawl, VPR Tow, [null] operation_dim$record_type varchar 30 No No Active operation record or reason record is unavailable Operation, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned operation_dim$return_date_whid int8 64 No No 0 Active date reference that vessel returned for the defined leg or trip operation_dim$return_port_whid int4 32 No No 0 Active port reference for return port operation_dim$scientist_1_person_whid int4 32 No No 0 Active person reference for the first scientist operation_dim$scientist_2_person_whid int4 32 No No 0 Active person reference for the second scientist operation_dim$scientist_3_person_whid int4 32 No No 0 Active person reference for the third scientist operation_dim$scientist_4_person_whid int4 32 No No 0 Active person reference for the fourth scientist operation_dim$state_registration_number varchar 12 No No Active state registration number for the vessel operation_dim$trip_id int4 32 No No 0 Active trip identifier number operation_dim$vessel_id int2 16 No No 0 Active field database vessel id number operation_dim_whid int8 64 No No 0 Active warehouse identifier for operation otosag_id int4 25 No No Active Otolith barcode or sample number unspecified Any ovary_id numeric 25 No No Active Ovary sample number or barcode unspecifid Any pacfin_spid varchar 10 No No Active pacfin species id - many taxa may not have one of these partition varchar 50 No No Active Refines the partition type Life stage: YOY, larvae, eggs and egg cases, adult, subadult; Size: Large, Small, Unspecified; Gender: Male, Female pass int4 32 No No 0 Active pass number of the survey 1,2,3,4 performance varchar 25 No No Active performance of the operation Insufficient Information, Indeterminate, Satisfactory, Trawlable, Untrawlable, Unsatisfactory, [null] program varchar 50 No No Active type of fram program Bottom Trawl, Hook and Line project varchar 50 No No Active project name 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 reason_stn_invalid varchar 150 No No Active reason station was invalidated, multiple reasons are comma separated 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_hhmmss bpchar 6 No No Active concatenation of military hour, minute, second, example 230415 equates to 23:04:15 sampling_end_time_dim$hour int2 16 No No 0 Active standard representation of the hour hr 0-12 sampling_end_time_dim$military_hour int2 16 No No 0 Active military representation of the hour 0-24 sampling_end_time_dim$minute int2 16 No No 0 Active number of minutes in the hour min 0-60 sampling_end_time_dim$period bpchar 2 No No Active period of time AM, PM sampling_end_time_dim$record_type varchar 30 No No Active time record or reason record is unavailable Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned sampling_end_time_dim$second int2 16 No No 0 Active number of seconds in the minute sec 0-60 sampling_end_time_whid int4 32 No No 0 Active warehouse identifier for the sampling end time sampling_start_hhmmss bpchar 6 No No Active concatenation of military hour, minute, second, example 230415 equates to 23:04:15 sampling_start_time_dim$hour int2 16 No No 0 Active standard representation of the hour hr 0-12 sampling_start_time_dim$military_hour int2 16 No No 0 Active military representation of the hour 0-24 sampling_start_time_dim$minute int2 16 No No 0 Active number of minutes in the hour min 0-60 sampling_start_time_dim$period bpchar 2 No No Active period of time AM, PM sampling_start_time_dim$record_type varchar 30 No No Active time record or reason record is unavailable Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned sampling_start_time_dim$second int2 16 No No 0 Active number of seconds in the minute sec 0-60 sampling_start_time_whid int4 32 No No 0 Active warehouse identifier for the sampling start time scientific_name varchar 120 No No Active scientific name generally composed of the genus and species name and subspecies name if available, but may be the highest taxonomic level seafloor_depth_dim$record_type varchar 30 No No Active depth record or reason record is unavailable Depth, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned seafloor_depth_whid int4 32 No No 0 Active warehouse identifier for seafloor depth sex bpchar 1 No No Active unspecified Any sex_dim$record_type varchar 30 No No Active latitude record type or reason record is unavailable NA Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned sex_dim$sex varchar 20 No No Active biological sex of individual unspecified Any sex_whid int2 16 No No 0 Active Warehouse identifier to sex details species_category varchar 40 No No Active upper-level taxonomic ranking fish, invertebrate, mammal, seabird, reptile, nonspecific organics, NA species_subcategory varchar 40 No No Active mid-level taxonomic ranking rockfish, flatfish, shark, crab, NA standard_survey_dim$record_type varchar 30 No No Active standard survey record or reason record is unavailable Standard Survey, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned standard_survey_dim$standard_survey_age_indicator varchar 50 No No Active identifies if the individual is part of the Standard Age Survey Standard Survey Age, Not Standard Survey Age, NA standard_survey_dim$standard_survey_length_or_width_indicator varchar 50 No No Active identifies if the individual is part of the Standard Length Survey Standard Survey Length, Not Standard Survey Length, NA standard_survey_dim$standard_survey_maturity_indicator varchar 50 No No Active identifies if the individual is part of the Standard Maturity Survey Standard Survey Maturity, Not Standard Survey Maturity, NA standard_survey_dim$standard_survey_weight_indicator varchar 50 No No Active identifies if the individual is part of the Standard Weight Survey Standard Survey Weight, Not Standard Survey Weight, NA standard_survey_whid int4 32 No No 0 Active Warehouse identifier for standard survey station_code varchar 12 No No Active unique identifier for a station definition station_ll_lat_dd numeric 12 No No 8 Active high precision value of lower left latitude of design type grid measured in decimal degrees dd station_ll_lon_dd numeric 12 No No 8 Active high precision value of lower left longitude of design type grid measured in decimal degrees dd station_lr_lat_dd numeric 12 No No 8 Active high precision value of lower right latitude of design type grid measured in decimal degrees dd station_lr_lon_dd numeric 12 No No 8 Active high precision value of lower right longitude of design type grid measured in decimal degrees dd station_ul_lat_dd numeric 12 No No 8 Active high precision value of upper left latitude of design type grid measured in decimal degrees dd station_ul_lon_dd numeric 12 No No 8 Active high precision value of upper left longitude of design type grid measured in decimal degrees dd station_ur_lat_dd numeric 12 No No 8 Active high precision value of upper right latitude of design type grid measured in decimal degrees dd station_ur_lon_dd numeric 12 No No 8 Active high precision value of upper right longitude of design type grid measured in decimal degrees dd statistical_partition_dim$record_type varchar 25 No No Active statistical partition record or reason record is unavailable Statistical Partition, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned statistical_partition_dim$statistical_partition_type varchar 30 No No Active Defines the partition type Life Stage, Size, Gender statistical_partition_whid int4 32 No No 0 Active warehouse identifier for statistical partition stomach_id numeric 25 No No Active Stomach sample number or barcode unspecified Any target_station_design_dim$active_polygon_dd polygon No No Active collection of vertices of the usuable area inside a station grid measured in decimal degrees dd target_station_design_dim$area_hectares numeric 12 No No 8 Active station area measured in hectares hectares target_station_design_dim$lower_left_latitude_whid int4 32 No No 0 Active lower left latitude warehouse identifier for a design type of grid target_station_design_dim$lower_left_longitude_whid int4 32 No No 0 Active lower left longitude warehouse identifier for a design type of grid unspecified Any target_station_design_dim$lower_right_latitude_whid int4 32 No No 0 Active lower right latitude warehouse identifier for a design type of grid target_station_design_dim$lower_right_longitude_whid int4 32 No No 0 Active lower right longitude warehouse identifier for a design type of grid target_station_design_dim$max_depth_whid int4 32 No No 0 Active maximum depth warehouse identifier target_station_design_dim$max_latitude_dd numeric 12 No No 8 Active high precision value of maximum latitude measured in decimal degrees dd target_station_design_dim$max_latitude_whid int4 32 No No 0 Active maximum latitude warehouse identifier for a design type of transect target_station_design_dim$mean_depth_m numeric 12 No No 4 Active high precision value of mean depth measured in meters m target_station_design_dim$mean_depth_whid int4 32 No No 0 Active mean depth warehouse identifier target_station_design_dim$min_depth_whid int4 32 No No 0 Active minimum depth warehouse identifier target_station_design_dim$min_latitude_dd numeric 12 No No 8 Active high precision value of minimum latitude measured in decimal degrees dd target_station_design_dim$min_latitude_whid int4 32 No No 0 Active minimum latitude warehouse identifier for a design type of transect target_station_design_dim$record_type varchar 30 No No Active station design record or reason record is unavailable Station Design, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned target_station_design_dim$station_design_name varchar 50 No No Active name of the design for a collection of stations target_station_design_dim$station_design_type varchar 15 No No Active type of design underlying the survey station set: Transect or Grid to date Transect, Grid target_station_design_dim$station_grid_dd polygon No No Active collection of vertices of grid points of a grid design measured in decimal degrees dd target_station_design_dim$stn_invalid_for_trawl_date_whid int8 64 No No 0 Active station design invalidation date warehouse identifier target_station_design_dim$transect_latitude_dd numeric 12 No No 8 Active high precision value of transect latitude measured in decimal degrees dd target_station_design_dim$transect_latitude_whid int4 32 No No 0 Active latitude warehouse identifier for a design type of transect target_station_design_dim$transect_station_longitude_dd numeric 12 No No 8 Active high precision value of transect station longitude measured in decimal degrees dd target_station_design_dim$transect_station_longitude_whid int4 32 No No 0 Active longitude on transect warehouse identifier for a design type of transect target_station_design_dim$upper_left_latitude_whid int4 32 No No 0 Active upper left latitude warehouse identifier for a design type of grid target_station_design_dim$upper_left_longitude_whid int4 32 No No 0 Active upper left longitude warehouse identifier for a design type of grid target_station_design_dim$upper_right_latitude_whid int4 32 No No 0 Active upper right latitude warehouse identifier for a design type of grid target_station_design_dim$upper_right_longitude_whid int4 32 No No 0 Active upper right longitude warehouse identifier for a design type of grid target_station_design_dim$variance_depth_m2 numeric 12 No No 4 Active high precision value of variance depth mesured in squared meters m2 target_station_design_whid int4 32 No No 0 Active warehouse identifier for target station design taxon_rank varchar 15 No No Active name of the lowest taxonomic level used to define scientific name taxon_source varchar 50 No No Active name of primary source used to get the measurement Angler, FPC, Genetics, Lab Exam, Large Scale, Morphometrics, Morphometrics + Genetics, NA, Quality Assurance, Retrospective Review, Taxon Rank Upped, Whole Organism tissue_id numeric 25 No No Active Tissue sample number or barcode unspecified Any tow int2 16 No No 0 Active operation number of the survey tow_end_timestamp timestamp No No Active operation end date timestamp tow_start_timestamp timestamp No No Active operation start date timestamp trawl_id int8 64 No No 0 Active identifier for a sampling operation vessel varchar 50 No No Active name of the vessel used for the operation 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 weight_kg numeric 8 No No 3 Active Individual weight measured in kilograms kg width_cm numeric 8 No No 4 Active Individual width measured in centimeters cm width_observation_detail_dim$measurement_procurement varchar 30 No No Active how the measurement was achieved NA, Calculated, Estimated, Observed, Measured, Not Documented width_observation_detail_dim$method_description varchar 500 No No Active description of how the observation was taken width_observation_detail_dim$observation_type varchar 30 No No Active the type of observation NA, width, length, total_catch_weight, taxonomy, etc width_observation_detail_dim$record_type varchar 30 No No Active observation detail record type or reason record is unavailable Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned width_observation_detail_dim$source_primary varchar 50 No No Active name of primary source used to get the measurement Angler, FPC, Genetics, Lab Exam, Large Scale, Morphometrics, Morphometrics + Genetics, NA, Quality Assurance, Retrospective Review, Taxon Rank Upped, Whole Organism width_observation_detail_whid int4 32 No No 0 Active Warehouse identifier to taxonomy observation detail width_type varchar 30 No No Active describes how the measurement was calculated Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned year int2 16 No No 0 Active operation year year 2007+ year_stn_invalid int2 16 No No Active Survey year the station became invalid for trawl year Any gov.noaa.nmfs.inport:36438 Jeffrey Cowen 2017-01-25T13:15:06 Curt Whitmire 2024-06-06T18:53:04 2017-02-13 Northwest Fisheries Science Center NWFSC 2725 Montlake Boulevard East Seattle WA 98112 USA 206-860-3200 https://www.nwfsc.noaa.gov 1001 Public No 2017-02-13 1 Year 2018-02-13