18418 West Coast Groundfish Bottom Trawl Survey Data (Annual West Coast time series groundfish trawl data collection survey) Data Set Published / External 17981 FRAM (Fishery Resource Analysis and Monitoring) Division Project Completed 1998-04-01 2017-01-24 The Fisheries Research Survey team proposes to conduct the West Coast Groundfish Bottom Trawl Survey from May to October 2019. The goal of the survey is to ensure the sustainability of marine fisheries with a focus on ending overfishing. The groundfish fishery supports management for 90+ commercially fished stocks off Washington, Oregon, and California and is the primary source of fishery-independent data necessary for stock assessments of managed groundfish species inhabiting trawlable habitat along the upper continental slope and shelf. The survey provides data on abundance, spatial distributions, sex, length, maturity, weight, and age structure of groundfish in trawlable habitats. The survey also collects key environmental data (temperature, depth, dissolved oxygen, turbidity, in vivo fluorescence, irradiance, wind speed, location) in association with each tow for use in ecosystem based fisheries management. This data set contains information on date, time, vessel, trawl identification (i.e. unique number), trawl performance, location, depth, area swept, trawl duration, temperature, species, haul weight, average individual weight, sex, length, length method, fish age and age structure. Addresses Legal Mandate Raw/field data, Monitoring or sensor data, Time series (of types 1-3) Loaded by batch 4364, 02-13-2013 17:14 Subject to Public Access to Research Results (PARR): Yes Data: Survey data from 2019 for use in future assessments. Field survey: Completion of that portion of the 2019 survey that occurs in FY19. Field survey: completion of that portion of the 2019 survey that occurs in in FY19. Manuscript: A comparative analysis of food habits for several Northeast Pacific rockfishes (Sebastes sp.), using gut contents and stable isotopes.. Manuscript: Relating groundfish diversity and biomass to structure-forming invertebrates in the Northeastern Pacific ocean: an exploration of catch data from a fishery-independent trawl survey.. Manuscript: Sablefish growth in relation to Pyrosomes. Manuscript: Diet structure of arrowtooth flounder, lingcod, Pacific sanddab, petrale sole and sablefish based on stomach contents and stable-isotope analysis.. Manuscript: Assessing reproductive strategies in marine fishes: applications to management. Metadata: Metadata for 2019 survey added to FNSSS. Outreach: Various outreach projects planned - including infographic, blogs, education and service. Presentation: Multiple presentations at WGC, Center Science Symposium etc.. Presentation: Numerous Presentations Planned - will be added as they occur. Report: Cruise Report for 2019 survey. Report: Permit reports to SRP, CA, OR, WA Sanctuaries and Protected Species. Spatial Global Change Master Directory (GCMD) Location Keywords CONTINENT > NORTH AMERICA > UNITED STATES OF AMERICA > CALIFORNIA Spatial Global Change Master Directory (GCMD) Location Keywords CONTINENT > NORTH AMERICA > UNITED STATES OF AMERICA > OREGON Spatial Global Change Master Directory (GCMD) Location Keywords CONTINENT > NORTH AMERICA > UNITED STATES OF AMERICA > WASHINGTON Spatial Global Change Master Directory (GCMD) Location Keywords OCEAN > PACIFIC OCEAN > NORTH PACIFIC OCEAN Theme demersal fish Theme fishery independent Theme groundfish survey Spatial Hatfield Marine Science Center Spatial Northern California Current System Spatial Northwest Fisheries Science Center Instrument Anemometer Instrument Bottom Contact Sensor Instrument CTD Instrument Depth-Temperature Sensor Instrument Net Mensuration Instrument Satellite Compass Instrument Temperature Sensor Platform Bottom Sampler Northwest Fisheries Science Center Seattle WA USA Data Set RDBMS (Oracle SQL Server etc.) Table (digital) Anemometer, Bottom Contact Sensor, CTD, Depth-Temperature Sensor, Net Mensuration, Satellite Compass, Temperature Sensor Water based Platforms - Watercraft - Manned Watercraft - Vessel (Ship) - Fishing Vessels - Trawlers - TO - 01.0.0 Bottom Sampler 36437 Published / External Data Table Catch data from bottom trawl survey 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 target_station_design_dim$station_design_name varchar 50 No No Active name of the design for a collection of stations best_available_taxonomy_dim$structure_source varchar 50 No No 0 Active Source of the taxonomic structure unspecified Any min_depth_m numeric 12 No No 4 Active high precision value of minimum depth measured in meters m actual_station_design_dim$min_depth_whid int4 32 No No 0 Active minimum depth warehouse identifier net_touchdown_time time No No Active military time representation of the time species_category varchar 40 No No Active upper-level taxonomic ranking fish, invertebrate, mammal, seabird, reptile, nonspecific organics, NA year_stn_invalid int2 16 No No Active Survey year the station became invalid for trawl year Any best_available_taxonomy_dim$subfamily_52 varchar 50 No No Active subfamily name sampling_end_time_dim$period bpchar 2 No No Active period of time AM, PM 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. 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$subphylum_22 varchar 50 No No Active subphylum name actual_station_design_dim$station_code varchar 12 No No Active unique identifier for a station definition catch_id int8 64 No No 0 Active unique(legacy) identifier for the catch from a haul, sorted to taxonomic group or debris type. best_available_taxonomy_dim$itis_taxonomic_serial_no int4 32 No No 0 Active ITIS taxonomic identifier unspecified Any field_identified_taxonomy_dim$species_80 varchar 50 No No Active species name field_identified_taxonomy_dim$subfamily_52 varchar 50 No No Active subfamily name 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 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 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 field_identified_taxonomy_dim$superfamily_48 varchar 50 No No Active superfamily name date_dim$full_date timestamp No No Active full date value 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$lower_left_longitude_whid int4 32 No No 0 Active lower left longitude warehouse identifier for a design type of grid unspecified Any total_catch_wt_observation_detail_whid int4 32 No No 0 Active warehouse identifier to total catch weight observation details 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 best_available_taxonomy_dim$superfamily_48 varchar 50 No No Active superfamily name field_identified_taxonomy_dim$superclass_28 varchar 50 No No Active superclass name 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 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 field_identified_taxonomy_dim$infraclass_34 varchar 50 No No Active infraclass name best_available_taxonomy_dim$acoustics_species_id int4 32 No No 0 Active Species ID used in the acoustics program unspecified Any most_recent_taxon_update timestamp No No Active full date value operation_dim$scientist_3_person_whid int4 32 No No 0 Active person reference for the third scientist 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 actual_station_design_dim$area_hectares numeric 12 No No 8 Active station area measured in hectares hectares haul_longitude_whid int4 32 No No 0 Active warehouse identifier for haul longitude best_available_taxonomy_dim$worms_aphiaid int4 32 No No 0 Active WoRMS taxonomic identifier unspecified Any target_station_design_dim$max_depth_whid int4 32 No No 0 Active maximum depth warehouse identifier 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 field_identified_taxonomy_dim$order_40 varchar 50 No No Active order name 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 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 actual_station_design_dim$min_latitude_whid int4 32 No No 0 Active minimum latitude warehouse identifier for a design type of transect pass int4 32 No No 0 Active pass number of the survey 1,2,3,4 actual_station_design_dim$min_depth_m numeric 12 No No 4 Active high precision value of minimum depth measured in meters m 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 total_catch_numbers int4 32 No No 0 Active numbers expansion for a taxonomic group within a haul. max_depth_m numeric 12 No No 4 Active high precision value of maximum depth measured in meters m operation_dim$operation_start_time_whid int8 64 No No 0 Active start time reference for the operation best_available_taxonomy_dim$family_50 varchar 50 No No Active family name field_identified_taxonomy_dim$itis_taxonomic_serial_no int4 32 No No 0 Active ITIS taxonomic identifier unspecified Any program varchar 50 No No Active type of fram program Bottom Trawl, Hook and Line 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 operation_dim$captain_person_whid int4 32 No No 0 Active person reference for the vessel captain total_catch_wt_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 total_catch_wt_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 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 target_station_design_dim$stn_invalid_for_trawl_date_whid int8 64 No No 0 Active station design invalidation date warehouse identifier mean_seafloor_dep_boundary varchar 40 No No Active depth boundry indicator identifying ifp boundary marks IFP Boundary Depth, Standard Contour Depth, NA field_identified_taxonomy_dim$infraorder_44 varchar 50 No No Active infraorder name operation_dim$fpc_person_whid int4 32 No No 0 Active person reference for the FPC best_available_taxonomy_dim$order_40 varchar 50 No No Active order name 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 target_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$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 sampling_start_time_dim$military_hour int2 16 No No 0 Active military representation of the hour 0-24 actual_station_design_dim$station_design_name varchar 50 No No Active name of the design for a collection of stations pacfin_spid varchar 10 No No Active pacfin species id - many taxa may not have one of these leg int2 16 No No 0 Active leg number of the survey 1,2,3,4,5,6,7,8 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$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$active_polygon_dd polygon No No Active collection of vertices of the usuable area inside a station grid measured in decimal degrees dd operation_dim$operation_type varchar 20 No No Active type of operation CTD Cast, Drop, Experiment, Search, Trawl, VPR Tow, [null] subsample_count int4 32 No No 0 Active count of the subsample used for numbers expansion. This is usually either the counted fraction or the subsample that is measured for fish length. best_available_taxonomy_dim$observer_species_id int4 32 No No 0 Active species identifier used by the observer program 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 actual_station_design_dim$transect_latitude_dd numeric 12 No No 8 Active high precision value of transect latitude measured in decimal degrees dd operation_dim$ifq_account_number varchar 12 No No Active unique number assigned to user accounts in the Vessel Accounting Database field_identified_taxonomy_dim$hookandline_species_id int4 32 No No 0 Active species identifier used by hook and line 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 actual_station_design_dim$min_latitude_dd numeric 12 No No 8 Active high precision value of minimum latitude measured in decimal degrees dd 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 most_recent_taxonomy_update_date_dim$month_of_year int2 16 No No 0 Active numeric representation of month of year 1-12 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 operation_dim$operation_end_date_whid int8 64 No No 0 Active end date reference for the operation sampling_start_time_dim$second int2 16 No No 0 Active number of seconds in the minute sec 0-60 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 best_available_taxonomy_dim$superclass_28 varchar 50 No No Active superclass name total_catch_wt_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 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 best_available_taxonomy_dim$subspecies_82 varchar 50 No No Active subspecies name sampling_end_time_whid int8 64 No No 0 Active warehouse identifier for the sampling end time 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 operation_dim$scientist_4_person_whid int4 32 No No 0 Active person reference for the fourth scientist 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 tow_end_timestamp timestamp No No Active operation end date timestamp target_station_design_dim$area_hectares numeric 12 No No 8 Active station area measured in hectares hectares target_station_design_dim$mean_depth_m numeric 12 No No 4 Active high precision value of mean depth measured in meters m 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 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 tow_start_timestamp timestamp No No Active operation start date timestamp best_available_taxonomy_dim$superorder_38 varchar 50 No No Active superorder name best_available_taxonomy_dim$kingdom_10 varchar 50 No No Active kingdom name field_identified_taxonomy_dim$structure_source varchar 50 No No 0 Active Source of the taxonomic structure unspecified Any 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 best_available_taxonomy_dim$hookandline_species_id int4 32 No No 0 Active species identifier used by hook and line operation_dim$trip_id int4 32 No No 0 Active trip identifier number field_identified_taxonomy_dim$family_50 varchar 50 No No Active family name species_subcategory varchar 40 No No Active mid-level taxonomic ranking rockfish, flatfish, shark, crab, NA 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 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 operation_dim$coast_guard_number varchar 10 No No Active Coast Guard documentation number of vessel 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 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 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 operation_dim$operation_end_time_whid int8 64 No No 0 Active end time reference for the operation 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$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$max_latitude_dd numeric 12 No No 8 Active high precision value of maximum latitude measured in decimal degrees dd field_identified_taxonomy_dim$subspecies_82 varchar 50 No No Active subspecies name target_station_design_dim$mean_depth_whid int4 32 No No 0 Active mean depth warehouse identifier 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 sampling_end_time_dim$military_hour int2 16 No No 0 Active military representation of the hour 0-24 sampling_start_time_dim$period bpchar 2 No No Active period of time AM, PM total_catch_wt_kg numeric 10 No No 4 Active total catch weight in kilograms is ordinarily the weight of a taxonomic group within a haul. It is usually the sum of all baskets weights collected for a taxonomic group within a haul, but may be derived as a linear expansion based on a weighed, sorted subsample pulled randomly from the weighed unsorted total within a haul. best_available_taxonomy_dim$phylum_20 varchar 50 No No Active phylum name best_available_taxonomy_dim$suborder_42 varchar 50 No No Active suborder name net_liftoff_time time No No Active military time representation of the time sampling_end_hhmmss bpchar 6 No No Active concatenation of military hour, minute, second, example 230415 equates to 23:04:15 most_recent_taxonomy_update_date_dim$day_of_month int2 16 No No 0 Active numeric representation of the day in month 1-31 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 best_available_taxonomy_dim$tribe_60 varchar 50 No No Active tribe name actual_station_design_dim$mean_depth_whid int4 32 No No 0 Active mean depth warehouse identifier sampling_start_time_dim$minute int2 16 No No 0 Active number of minutes in the hour min 0-60 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 field_identified_taxonomy_dim$worms_aphiaid int4 32 No No 0 Active WoRMS taxonomic identifier unspecified Any 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" 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 midtow_lat_named_parallel varchar 50 No No Active name of parallel, boundary, or commonly used geograpical location NA any 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. most_recent_taxonomy_update_date_dim$yyyymmdd bpchar 8 No No Active text representation of year month day field_identified_taxonomy_dim$subclass_32 varchar 50 No No Active subclass name 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$transect_latitude_dd numeric 12 No No 8 Active high precision value of transect latitude measured in decimal degrees dd target_station_design_whid int4 32 No No 0 Active warehouse identifier for target station design 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$phylum_20 varchar 50 No No Active phylum name actual_station_design_dim$variance_depth_m2 numeric 12 No No 4 Active high precision value of variance depth mesured in squared meters m2 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 operation_dim_whid int8 64 No No 0 Active warehouse identifier for operation field_identified_taxonomy_dim$species_category varchar 40 No No Active upper-level taxonomic ranking fish, invertebrate, mammal, seabird, reptile, nonspecific organics, NA 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 total_catch_wt_observation_detail_dim$method_description varchar 500 No No Active description of how the observation was taken 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 best_available_taxonomy_dim$class_30 varchar 50 No No Active class name 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 performance varchar 25 No No Active performance of the operation Insufficient Information, Indeterminate, Satisfactory, Trawlable, Untrawlable, Unsatisfactory, [null] 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 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 seafloor_depth_whid int4 32 No No 0 Active warehouse identifier for seafloor depth 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$scientific_name_taxonomic_level varchar 15 No No Active name of the lowest taxonomic level used to define scientific 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 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 operation_dim$departure_port_whid int4 32 No No 0 Active port reference for the departure port 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 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 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 operation_dim$field_operation_seg_id int8 64 No No 0 Active operation segment id reference to the field operational segment table haul_latitude_dim$latitude_compass_direction bpchar 1 No No Active latitude compass direction NA N, S 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 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 date_dim$day_of_month int2 16 No No 0 Active numeric representation of the day in month 1-31 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 cpue_kg_per_ha_der numeric 16 No No 12 Active derivation of catch per unit effort in weight (kilograms) per hectare ordinarily estimated as the expanded haul catch weight divided by the area swept by the net. kg/ha field_identified_taxonomy_dim$species_sub_category varchar 40 No No Active mid-level taxonomic ranking rockfish, flatfish, shark, crab, NA field_note varchar 1000 No No Active notes made in the field about the catch operation_dim$scientist_2_person_whid int4 32 No No 0 Active person reference for the second scientist actual_station_design_dim$max_depth_whid int4 32 No No 0 Active maximum depth warehouse identifier 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 target_station_design_dim$max_latitude_whid int4 32 No No 0 Active maximum latitude warehouse identifier for a design type of transect 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 date_dim$year int4 32 No No 0 Active numeric representation of year 1978+ operation_dim$state_registration_number varchar 12 No No Active state registration number for the vessel best_available_taxonomy_dim$genus_70 varchar 50 No No Active genus name total_catch_wt_observation_detail_dim$observation_type varchar 30 No No Active the type of observation NA, width, length, total_catch_weight, taxonomy, etc actual_station_design_dim$transect_latitude_whid int4 32 No No 0 Active latitude warehouse identifier for a design type of transect sampling_end_time_dim$hour int2 16 No No 0 Active standard representation of the hour hr 0-12 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 field_identified_taxonomy_dim$pacfin_spid varchar 10 No No Active pacfin species id - many taxa may not have one of these latitude_dd numeric 12 No No 8 Active numeric representation of latitude in degrees dd -90 to 90 taxon_rank varchar 15 No No Active name of the lowest taxonomic level used to define scientific name 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 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$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 target_station_design_dim$min_latitude_dd numeric 12 No No 8 Active high precision value of minimum latitude measured in decimal degrees dd field_identified_taxonomy_dim$tribe_60 varchar 50 No No Active tribe name field_identified_taxonomy_dim$observer_species_id int4 32 No No 0 Active species identifier used by the observer program 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 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 most_recent_taxonomy_update_date_dim$year int4 32 No No 0 Active numeric representation of year 1978+ 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 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 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$upper_left_longitude_whid int4 32 No No 0 Active upper left longitude warehouse identifier for a design type of grid field_identified_taxonomy_dim$class_30 varchar 50 No No Active class name statistical_partition_whid int4 32 No No 0 Active warehouse identifier for statistical partition best_available_taxonomy_dim$infraclass_34 varchar 50 No No Active infraclass name best_available_taxonomy_dim$pacfin_nom_spid varchar 10 No No 0 Active PacFIN nominal species identifier unspecified Any best_available_taxonomy_dim$subphylum_22 varchar 50 No No Active subphylum name actual_station_design_dim$max_depth_m numeric 12 No No 4 Active high precision value of maximum depth measured in meters m 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 sampling_end_time_dim$minute int2 16 No No 0 Active number of minutes in the hour min 0-60 date_yyyymmdd bpchar 8 No No Active text representation of year month day best_available_taxonomy_whid int4 32 No No 0 Active warehouse identifier to best available taxonomy haul_longitude_dim$longitude_compass_direction bpchar 1 No No Active longitude compass direction E, W 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 best_available_taxonomy_dim$trawl_survey_species_id int4 32 No No 0 Active species identifier used by the trawl survey total_catch_wt_observation_detail_dim$measurement_procurement varchar 30 No No Active how the measurement was achieved NA, Calculated, Estimated, Observed, Measured, Not Documented 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 target_station_design_dim$transect_latitude_whid int4 32 No No 0 Active latitude warehouse identifier for a design type of transect best_available_taxonomy_dim$infraorder_44 varchar 50 No No Active infraorder name field_identified_taxonomy_dim$superorder_38 varchar 50 No No Active superorder name 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 operation_dim$observer_program varchar 150 No No Active description of the observer program actual_station_design_whid int4 32 No No 0 Active warehouse identifier for station design tow int2 16 No No 0 Active operation number of the survey 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 date_whid int8 64 No No 0 Active warehouse identifier for date target_station_design_dim$min_latitude_whid int4 32 No No 0 Active minimum latitude warehouse identifier for a design type of transect subsample_wt_kg numeric 10 No No 4 Active weight in kilograms of the subsample used for numbers expansion. This is usually either the counted fraction or the subsample that is measured for fish length. kg operation_dim$return_port_whid int4 32 No No 0 Active port reference for return port field_identified_taxonomy_whid int4 32 No No 0 Active warehouse identifier to field identified taxonomy 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_whid int8 64 No No 0 Active warehouse identifier for most recent taxonomy update date 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_dim$species_80 varchar 50 No No Active species 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 date_dim$month_of_year int2 16 No No 0 Active numeric representation of month of year 1-12 field_identified_taxonomy_dim$kingdom_10 varchar 50 No No Active kingdom name sampling_end_time_dim$second int2 16 No No 0 Active number of seconds in the minute sec 0-60 haul_latitude_whid int4 32 No No 0 Active warehouse identifier for haul latitude operation_dim$departure_date_whid int8 64 No No 0 Active date reference that vessel departed for the defined leg or trip actual_station_design_dim$max_latitude_whid int4 32 No No 0 Active maximum latitude warehouse identifier for a design type of transect 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 target_station_design_dim$variance_depth_m2 numeric 12 No No 4 Active high precision value of variance depth mesured in squared meters m2 field_identified_taxonomy_dim$acoustics_species_id int4 32 No No 0 Active Species ID used in the acoustics program unspecified Any 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 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 operation_dim$scientist_1_person_whid int4 32 No No 0 Active person reference for the first scientist 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 best_available_taxonomy_dim$subclass_32 varchar 50 No No Active subclass name 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 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 field_identified_taxonomy_dim$trawl_survey_species_id int4 32 No No 0 Active species identifier used by the trawl survey cpue_numbers_per_ha_der numeric 16 No No 12 Active derivation of catch per unit effort in numbers of individuals per hectare ordinarily estimated as the expanded haul catch in numbers divided by the area swept by the net. best_available_taxonomy_observation_detail_dim$method_description varchar 500 No No Active description of how the observation was taken sampling_start_hhmmss bpchar 6 No No Active concatenation of military hour, minute, second, example 230415 equates to 23:04:15 operation_dim$vessel_id int2 16 No No 0 Active field database vessel id number 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 target_station_design_dim$min_depth_whid int4 32 No No 0 Active minimum depth warehouse identifier 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 operation_dim$return_date_whid int8 64 No No 0 Active date reference that vessel returned for the defined leg or trip field_identified_taxonomy_dim$suborder_42 varchar 50 No No Active suborder name field_identified_taxonomy_dim$pacfin_nom_spid varchar 10 No No 0 Active PacFIN nominal species identifier unspecified Any best_available_taxonomy_observation_detail_whid int4 32 No No 0 Active warehouse identifier to best available taxonomy observation detail 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 sampling_start_time_dim$hour int2 16 No No 0 Active standard representation of the hour hr 0-12 year int2 16 No No 0 Active operation year year 2007+ actual_station_design_dim$stn_invalid_for_trawl_date_whid int8 64 No No 0 Active station design invalidation date warehouse identifier statistical_partition_dim$statistical_partition_type varchar 30 No No Active Defines the partition type Life Stage, Size, Gender operation_dim$operation_start_date_whid int8 64 No No 0 Active start date reference for the operation longitude_dd numeric 12 No No 8 Active numeric representation of longitude in decimal degrees dd -180 to 180 field_identified_taxonomy_dim$genus_70 varchar 50 No No Active genus name station_code varchar 12 No No Active unique identifier for a station definition 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 sampling_start_time_whid int8 64 No No 0 Active warehouse identifier for the sampling start time 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 trawl_id int8 64 No No 0 Active identifier for a sampling operation 36438 Published / External Data Table Individuals caught and measured on the bottom trawl survey 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 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 sampling_start_time_dim$minute int2 16 No No 0 Active number of minutes in the hour min 0-60 best_available_taxonomy_dim$phylum_20 varchar 50 No No Active phylum name performance varchar 25 No No Active performance of the operation Insufficient Information, Indeterminate, Satisfactory, Trawlable, Untrawlable, Unsatisfactory, [null] 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 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 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 best_available_taxonomy_dim$structure_source varchar 50 No No 0 Active Source of the taxonomic structure unspecified Any best_available_taxonomy_dim$family_50 varchar 50 No No Active family name 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$lower_left_latitude_whid int4 32 No No 0 Active lower left latitude warehouse identifier for a design type of grid 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 width_observation_detail_dim$method_description varchar 500 No No Active description of how the observation was taken 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 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_age_update_date_dim$yyyymmdd bpchar 8 No No Active text representation of year month day individual_tracking_id int8 64 No No 0 Active Individual tracking id ovary_id numeric 25 No No Active Ovary sample number or barcode unspecifid Any target_station_design_dim$stn_invalid_for_trawl_date_whid int8 64 No No 0 Active station design invalidation date warehouse identifier standard_survey_whid int4 32 No No 0 Active Warehouse identifier for standard survey operation_dim$scientist_1_person_whid int4 32 No No 0 Active person reference for the first scientist most_recent_maturity_update_date_whid int8 64 No No 0 Active Warehouse identifier for most recent maturity update date net_liftoff_time time No No Active military time representation of the time actual_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_dim$variance_depth_m2 numeric 12 No No 4 Active high precision value of variance depth mesured in squared meters m2 target_station_design_dim$min_depth_whid int4 32 No No 0 Active minimum depth warehouse identifier 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 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 field_identified_taxonomy_dim$itis_taxonomic_serial_no int4 32 No No 0 Active ITIS taxonomic identifier unspecified Any operation_dim$departure_port_whid int4 32 No No 0 Active port reference for the departure port 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 sex_whid int2 16 No No 0 Active Warehouse identifier to sex details target_station_design_whid int4 32 No No 0 Active warehouse identifier for target station design target_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$upper_left_longitude_whid int4 32 No No 0 Active upper left longitude warehouse identifier for a design type of grid pass int4 32 No No 0 Active pass number of the survey 1,2,3,4 sampling_end_time_dim$period bpchar 2 No No Active period of time AM, PM operation_dim$scientist_3_person_whid int4 32 No No 0 Active person reference for the third scientist field_identified_taxonomy_dim$structure_source varchar 50 No No 0 Active Source of the taxonomic structure unspecified Any width_cm numeric 8 No No 4 Active Individual width measured in centimeters cm most_recent_taxon_update timestamp No No Active full date value 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 operation_dim$operation_start_date_whid int8 64 No No 0 Active start date reference for the operation best_available_taxonomy_dim$observer_species_id int4 32 No No 0 Active species identifier used by the observer program 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 midtow_lat_named_parallel varchar 50 No No Active name of parallel, boundary, or commonly used geograpical location NA any field_identified_taxonomy_dim$species_category varchar 40 No No Active upper-level taxonomic ranking fish, invertebrate, mammal, seabird, reptile, nonspecific organics, NA 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. 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 operation_dim$field_operation_seg_id int8 64 No No 0 Active operation segment id reference to the field operational segment table sampling_end_time_whid int4 32 No No 0 Active warehouse identifier for the sampling end time 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 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 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$mean_depth_whid int4 32 No No 0 Active mean depth warehouse identifier stomach_id numeric 25 No No Active Stomach sample number or barcode unspecified Any 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 trawl_id int8 64 No No 0 Active identifier for a sampling operation 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 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 best_available_taxonomy_whid int4 32 No No 0 Active warehouse identifier to best available taxonomy 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 species_category varchar 40 No No Active upper-level taxonomic ranking fish, invertebrate, mammal, seabird, reptile, nonspecific organics, NA field_identified_taxonomy_dim$hookandline_species_id int4 32 No No 0 Active species identifier used by hook and line 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 best_available_taxonomy_dim$subphylum_22 varchar 50 No No Active subphylum name 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 longitude_dd numeric 12 No No 8 Active numeric representation of longitude in decimal degrees dd -180 to 180 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 program varchar 50 No No Active type of fram program Bottom Trawl, Hook and Line width_observation_detail_dim$observation_type varchar 30 No No Active the type of observation NA, width, length, total_catch_weight, taxonomy, etc field_identified_taxonomy_dim$superorder_38 varchar 50 No No Active superorder name operation_dim$operation_end_time_whid int8 64 No No 0 Active end time reference for the operation target_station_design_dim$min_latitude_dd numeric 12 No No 8 Active high precision value of minimum latitude measured in decimal degrees dd most_recent_maturity_update_date_dim$yyyymmdd bpchar 8 No No Active text representation of year month day 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 operation_dim$operation_start_time_whid int8 64 No No 0 Active start time reference for the operation field_identified_taxonomy_dim$infraorder_44 varchar 50 No No Active infraorder name 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 length_timestamp timestamp No No Active Timestamp at the point the length is taken on an individual 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 best_available_taxonomy_dim$pacfin_nom_spid varchar 10 No No 0 Active PacFIN nominal species identifier unspecified Any 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 field_identified_taxonomy_dim$worms_aphiaid int4 32 No No 0 Active WoRMS taxonomic identifier unspecified Any max_depth_m numeric 12 No No 4 Active high precision value of maximum depth measured in meters m field_identified_taxonomy_whid int4 32 No No 0 Active warehouse identifier to field identified taxonomy most_recent_age_update_date_dim$month_of_year int2 16 No No 0 Active numeric representation of month of year 1-12 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 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 haul_longitude_whid int4 32 No No 0 Active warehouse identifier for haul longitude date_dim$year int4 32 No No 0 Active numeric representation of year 1978+ 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_whid int4 32 No No 0 Active warehouse identifier for station design operation_dim$coast_guard_number varchar 10 No No Active Coast Guard documentation number of vessel field_identified_taxonomy_dim$kingdom_10 varchar 50 No No Active kingdom name 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_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 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 field_identified_taxonomy_dim$acoustics_species_id int4 32 No No 0 Active Species ID used in the acoustics program unspecified Any sampling_end_time_dim$minute int2 16 No No 0 Active number of minutes in the hour min 0-60 date_yyyymmdd bpchar 8 No No Active text representation of year month day 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_compass_direction bpchar 1 No No Active latitude compass direction NA N, S year int2 16 No No 0 Active operation year year 2007+ 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 field_identified_taxonomy_dim$subfamily_52 varchar 50 No No Active subfamily name sampling_start_time_dim$hour int2 16 No No 0 Active standard representation of the hour hr 0-12 most_recent_maturity_update_date_dim$month_of_year int2 16 No No 0 Active numeric representation of month of year 1-12 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 best_available_taxonomy_dim$subfamily_52 varchar 50 No No Active subfamily name otosag_id int4 25 No No Active Otolith barcode or sample number unspecified Any 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 date_whid int8 64 No No 0 Active warehouse identifier for date target_station_design_dim$min_latitude_whid int4 32 No No 0 Active minimum latitude warehouse identifier for a design type of transect 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 operation_dim$departure_date_whid int8 64 No No 0 Active date reference that vessel departed for the defined leg or trip length_observation_detail_dim$observation_type varchar 30 No No Active the type of observation NA, width, length, total_catch_weight, taxonomy, etc operation_dim$fpc_person_whid int4 32 No No 0 Active person reference for the FPC actual_station_design_dim$transect_latitude_whid int4 32 No No 0 Active latitude warehouse identifier for a design type of transect length_cm numeric 8 No No 4 Active Individual length measured in centimeters cm 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 operation_dim$operation_end_date_whid int8 64 No No 0 Active end date reference for the operation 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 actual_station_design_dim$max_depth_whid int4 32 No No 0 Active maximum depth warehouse identifier actual_station_design_dim$min_depth_m numeric 12 No No 4 Active high precision value of minimum depth measured in meters m operation_dim$return_date_whid int8 64 No No 0 Active date reference that vessel returned for the defined leg or trip haul_longitude_dim$longitude_compass_direction bpchar 1 No No Active longitude compass direction E, W target_station_design_dim$transect_latitude_whid int4 32 No No 0 Active latitude warehouse identifier for a design type of transect date_dim$full_date timestamp No No Active full date value 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 actual_station_design_dim$mean_depth_whid int4 32 No No 0 Active mean depth warehouse identifier min_depth_m numeric 12 No No 4 Active high precision value of minimum depth measured in meters m year_stn_invalid int2 16 No No Active Survey year the station became invalid for trawl year Any 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 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 station_code varchar 12 No No Active unique identifier for a station definition 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_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 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 most_recent_taxonomy_update_date_dim$month_of_year int2 16 No No 0 Active numeric representation of month of year 1-12 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 best_available_taxonomy_dim$superfamily_48 varchar 50 No No Active superfamily name 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 actual_station_design_dim$transect_latitude_dd numeric 12 No No 8 Active high precision value of transect latitude measured in decimal degrees dd weight_kg numeric 8 No No 3 Active Individual weight measured in kilograms kg 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 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 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 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 operation_dim$return_port_whid int4 32 No No 0 Active port reference for return port actual_station_design_dim$min_latitude_dd numeric 12 No No 8 Active high precision value of minimum latitude measured in decimal degrees dd tow_end_timestamp timestamp No No Active operation end date timestamp 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 field_identified_taxonomy_dim$subphylum_22 varchar 50 No No Active subphylum name operation_dim$captain_person_whid int4 32 No No 0 Active person reference for the vessel captain 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 length_observation_detail_dim$method_description varchar 500 No No Active description of how the observation was taken best_available_taxonomy_dim$suborder_42 varchar 50 No No Active suborder name most_recent_age_update_date_whid int8 64 No No 0 Active Warehouse identifier for most recent age update date field_identified_taxonomy_dim$phylum_20 varchar 50 No No Active phylum name best_available_taxonomy_dim$superclass_28 varchar 50 No No Active superclass name statistical_partition_whid int4 32 No No 0 Active warehouse identifier for statistical partition 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 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_whid int4 32 No No 0 Active Warehouse identifier to taxonomy observation detail field_identified_taxonomy_dim$pacfin_spid varchar 10 No No Active pacfin species id - many taxa may not have one of these operation_dim$ifq_account_number varchar 12 No No Active unique number assigned to user accounts in the Vessel Accounting Database best_available_taxonomy_dim$subspecies_82 varchar 50 No No Active subspecies name 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 width_observation_detail_dim$measurement_procurement varchar 30 No No Active how the measurement was achieved NA, Calculated, Estimated, Observed, Measured, Not Documented target_station_design_dim$area_hectares numeric 12 No No 8 Active station area measured in hectares hectares age_years numeric 10 No No 0 Active Individual age measured in years yrs sampling_start_hhmmss bpchar 6 No No Active concatenation of military hour, minute, second, example 230415 equates to 23:04:15 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 best_available_taxonomy_dim$hookandline_species_id int4 32 No No 0 Active species identifier used by hook and line 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 field_identified_taxonomy_dim$genus_70 varchar 50 No No Active genus name most_recent_taxonomy_update_date_dim$year int4 32 No No 0 Active numeric representation of year 1978+ 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 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 operation_dim$scientist_4_person_whid int4 32 No No 0 Active person reference for the fourth scientist 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 target_station_design_dim$transect_latitude_dd numeric 12 No No 8 Active high precision value of transect latitude measured in decimal degrees dd mean_seafloor_dep_boundary varchar 40 No No Active depth boundry indicator identifying ifp boundary marks IFP Boundary Depth, Standard Contour Depth, NA 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 sampling_start_time_dim$second int2 16 No No 0 Active number of seconds in the minute sec 0-60 actual_station_design_dim$station_invalid_survey_year int2 16 No No Active Survey year the station became invalid for trawl year Any sampling_start_time_whid int4 32 No No 0 Active warehouse identifier for the sampling start time 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 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 tissue_id numeric 25 No No Active Tissue sample number or barcode unspecified 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 best_available_taxonomy_dim$tribe_60 varchar 50 No No Active tribe name field_note varchar 1000 No No Active Note made in the field about an individual sex_dim$sex varchar 20 No No Active biological sex of individual unspecified Any actual_station_design_dim$station_code varchar 12 No No Active unique identifier for a station definition latitude_dd numeric 12 No No 8 Active numeric representation of latitude in degrees dd -90 to 90 actual_station_design_dim$station_design_name varchar 50 No No Active name of the design for a collection of stations 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 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 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 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 most_recent_age_update timestamp No No Active full date value actual_station_design_dim$area_hectares numeric 12 No No 8 Active station area measured in hectares hectares taxon_rank varchar 15 No No Active name of the lowest taxonomic level used to define scientific name 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_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 operation_dim_whid int8 64 No No 0 Active warehouse identifier for operation operation_dim$scientist_2_person_whid int4 32 No No 0 Active person reference for the second scientist most_recent_taxonomy_update_date_dim$yyyymmdd bpchar 8 No No Active text representation of year month day best_available_taxonomy_dim$genus_70 varchar 50 No No Active genus name net_touchdown_time time No No Active military time representation of the time best_available_taxonomy_dim$itis_taxonomic_serial_no int4 32 No No 0 Active ITIS taxonomic identifier unspecified Any operation_dim$vessel_id int2 16 No No 0 Active field database vessel id number left_pectoral_fin_id int4 25 No No Active Left pectoral fin sample number or barcode unspecified Any best_available_taxonomy_dim$worms_aphiaid int4 32 No No 0 Active WoRMS taxonomic identifier unspecified Any lab_maturity_detail_dim$biologically_mature_indicator varchar 25 No No Active identifies biological maturity of the individual Biologically Mature, Not Biologically Mature, NA most_recent_taxonomy_update_date_whid int8 64 No No 0 Active Warehouse identifier for most recent taxonomy update date haul_latitude_whid int4 32 No No 0 Active warehouse identifier for haul latitude operation_dim$state_registration_number varchar 12 No No Active state registration number for the vessel 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 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 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 best_available_taxonomy_observation_detail_dim$method_description varchar 500 No No Active description of how the observation was taken width_observation_detail_whid int4 32 No No 0 Active Warehouse identifier to taxonomy observation detail 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 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 actual_station_design_dim$mean_depth_m numeric 12 No No 4 Active high precision value of mean depth measured in meters m field_identified_taxonomy_dim$pacfin_nom_spid varchar 10 No No 0 Active PacFIN nominal species identifier unspecified Any field_identified_taxonomy_dim$superclass_28 varchar 50 No No Active superclass name actual_station_design_dim$max_depth_m numeric 12 No No 4 Active high precision value of maximum depth measured in meters m field_identified_taxonomy_dim$superfamily_48 varchar 50 No No Active superfamily name 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 tow_start_timestamp timestamp No No Active operation start date timestamp 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 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 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 best_available_taxonomy_dim$infraclass_34 varchar 50 No No Active infraclass name 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 target_station_design_dim$max_latitude_dd numeric 12 No No 8 Active high precision value of maximum latitude measured in decimal degrees dd operation_dim$trip_id int4 32 No No 0 Active trip identifier number sampling_start_time_dim$period bpchar 2 No No Active period of time AM, PM 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 sampling_end_hhmmss bpchar 6 No No Active concatenation of military hour, minute, second, example 230415 equates to 23:04:15 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 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$station_grid_dd polygon No No Active collection of vertices of grid points of a grid design measured in decimal degrees dd most_recent_age_update_date_dim$day_of_month int2 16 No No 0 Active numeric representation of the day in month 1-31 tow int2 16 No No 0 Active operation number of the survey actual_station_design_dim$stn_invalid_for_trawl_date_whid int8 64 No No 0 Active station design invalidation date warehouse identifier 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 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 field_identified_taxonomy_dim$infraclass_34 varchar 50 No No Active infraclass name 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 field_identified_taxonomy_dim$subspecies_82 varchar 50 No No Active subspecies name best_available_taxonomy_dim$acoustics_species_id int4 32 No No 0 Active Species ID used in the acoustics program unspecified Any actual_station_design_dim$max_latitude_whid int4 32 No No 0 Active maximum latitude warehouse identifier for a design type of transect most_recent_age_update_date_dim$year int4 32 No No 0 Active numeric representation of year 1978+ species_subcategory varchar 40 No No Active mid-level taxonomic ranking rockfish, flatfish, shark, crab, NA date_dim$day_of_month int2 16 No No 0 Active numeric representation of the day in month 1-31 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 field_identified_taxonomy_dim$tribe_60 varchar 50 No No Active tribe name leg int2 16 No No 0 Active leg number of the survey 1,2,3,4,5,6,7,8 field_identified_taxonomy_dim$subclass_32 varchar 50 No No Active subclass name best_available_taxonomy_observation_detail_whid int4 32 No No 0 Active warehouse identifier to best available taxonomy observation detail 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 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 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 field_identified_taxonomy_dim$class_30 varchar 50 No No Active class name sampling_end_time_dim$hour int2 16 No No 0 Active standard representation of the hour hr 0-12 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 sampling_start_time_dim$military_hour int2 16 No No 0 Active military representation of the hour 0-24 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" 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_time_dim$second int2 16 No No 0 Active number of seconds in the minute sec 0-60 best_available_taxonomy_dim$superorder_38 varchar 50 No No Active superorder name best_available_taxonomy_dim$kingdom_10 varchar 50 No No Active kingdom name field_identified_taxonomy_dim$trawl_survey_species_id int4 32 No No 0 Active species identifier used by the trawl survey 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 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 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$suborder_42 varchar 50 No No Active suborder name field_identified_taxonomy_dim$family_50 varchar 50 No No Active family name 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 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 best_available_taxonomy_dim$class_30 varchar 50 No No Active class name seafloor_depth_whid int4 32 No No 0 Active warehouse identifier for seafloor depth target_station_design_dim$mean_depth_m numeric 12 No No 4 Active high precision value of mean depth measured in meters m field_identified_taxonomy_dim$species_sub_category varchar 40 No No Active mid-level taxonomic ranking rockfish, flatfish, shark, crab, NA operation_dim$observer_program varchar 150 No No Active description of the observer program 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 pacfin_spid varchar 10 No No Active pacfin species id - many taxa may not have one of these best_available_taxonomy_dim$infraorder_44 varchar 50 No No Active infraorder name most_recent_maturity_update_date_dim$day_of_month int2 16 No No 0 Active numeric representation of the day in month 1-31 statistical_partition_dim$statistical_partition_type varchar 30 No No Active Defines the partition type Life Stage, Size, Gender 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 36439 Published / External Data Table Operation details including dates, times, location, depths, tempuratures, etc 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 operation_dim$return_port_whid int4 32 No No 0 Active port reference for return port distance_hb2end_m_der numeric 10 No No 4 Active Estimate of the distance traveled by the trawl net during the period following the start of net haulback (start of haulback to net liftoff period) in meters. Expected to be estimated from a hierarchy of methods favoring the use of gear positions derived by the ITI or from its bearing and horizontal range traces, including input from some form of gyrocompass m performance varchar 25 No No Active performance of the operation Insufficient Information, Indeterminate, Satisfactory, Trawlable, Untrawlable, Unsatisfactory, [null] 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 nonspecific_organics_weight_kg numeric 16 No No 3 Active Total non-specific organics weight in kilograms kg gear_start_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 vessel_start_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 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 gear_depth_m_der numeric 10 No No 4 Active Single point estimate for depth at the gear in meters for a haul. The standard up through present has been the mean over the center 80 percent of the tow duration from the best depth sensor trace within the haul m sampling_end_time_dim$hour int2 16 No No 0 Active standard representation of the hour hr 0-12 o2_at_gear_ml_per_l_der numeric 10 No No 4 Active Single point estimate for oxygen concentration in milliliters/Liter at the gear for a haul. The standard up through present has been the mean over the center 80 percent of the tow duration of the best oxygen concentration sensor trace within the haul ml/l sampling_start_hhmmss bpchar 6 No No Active concatenation of military hour, minute, second, example 230415 equates to 23:04:15 gear_start_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 gear_end_latitude_dd numeric 12 No No 8 Active Latitude at the gear when sampling ceases (net liftoff for trawling). dd target_station_design_dim$stn_invalid_for_trawl_date_whid int8 64 No No 0 Active station design invalidation date warehouse identifier operation_dim$scientist_1_person_whid int4 32 No No 0 Active person reference for the first scientist mean_seafloor_dep_boundary varchar 40 No No Active depth boundry indicator identifying ifp boundary marks IFP Boundary Depth, Standard Contour Depth, NA actual_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_dim$variance_depth_m2 numeric 12 No No 4 Active high precision value of variance depth mesured in squared meters m2 vessel_start_latitude_whid int4 32 No No 0 Active Warehouse identifier for vessel start latitude target_station_design_dim$min_depth_whid int4 32 No No 0 Active minimum depth warehouse identifier gear_end_latitude_dim$latitude_in_degrees numeric 12 No No 8 Active numeric representation of latitude in degrees dd -90 to 90 salinity_at_gear_psu_der numeric 10 No No 4 Active Single point estimate for salinity in degrees C at the gear for a haul. The standard up through present has been the mean over the center 80 percent of the tow duration of the best salinity sensor trace within the haul. This CTD sensor trace is ordinarily subjected to a skew filter followed by a weighted mean algorithm rather than a simple descriptive mean calculation psu 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 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 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$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 vessel_end_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 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 pass int4 32 No No 0 Active pass number of the survey 1,2,3,4 sampling_end_time_dim$period bpchar 2 No No Active period of time AM, PM 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 gear_start_longitude_dim$longitude_compass_direction bpchar 1 No No Active longitude compass direction E, W vessel_start_latitude_dd numeric 12 No No 8 Active Latitude at the vessel when sampling commences (net touchdown for trawling). dd date_whid int8 64 No No 0 Active warehouse identifier for date actual_station_design_dim$area_hectares numeric 12 No No 8 Active station area measured in hectares hectares gear_end_longitude_dim$longitude_in_degrees numeric 12 No No 8 Active numeric representation of longitude in decimal degrees dd -180 to 180 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 midtow_position_type varchar 25 No No Active Method used for deriving the haul latitude/longitude single point Gear Net Touchdown, Gear Start Haulback, Gear Track Midpoint, Station-defined Midpoint, Vessel Abort, Vessel Net Touchdown, Vessel Operation End, Vessel Operation Start, Vessel Start Haulback, Vessel Track Midpoint target_station_design_dim$min_latitude_whid int4 32 No No 0 Active minimum latitude warehouse identifier for a design type of transect 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. vessel_end_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 gear_end_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 operation_dim$field_operation_seg_id int8 64 No No 0 Active operation segment id reference to the field operational segment table vessel_end_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 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 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 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$mean_depth_whid int4 32 No No 0 Active mean depth warehouse identifier 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 gear_start_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 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 gear_end_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$longitude_minute_units int2 16 No No 0 Active numeric representation of longitude that makes up the minute unit only min 0-59 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 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 gear_start_longitude_dim$longitude_in_degrees numeric 12 No No 8 Active numeric representation of longitude in decimal degrees dd -180 to 180 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 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 sampling_end_time_dim$second int2 16 No No 0 Active number of seconds in the minute sec 0-60 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 vessel_end_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 latitude_dim$latitude_compass_direction bpchar 1 No No Active latitude compass direction NA N, S gear_end_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 gear_end_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 vessel_end_latitude_dd numeric 12 No No 8 Active Longitude at the vessel when sampling commences (net touchdown for trawling). dd program varchar 50 No No Active type of fram program Bottom Trawl, Hook and Line station_code varchar 12 No No Active unique identifier for a station definition target_station_design_dim$max_depth_whid int4 32 No No 0 Active maximum depth warehouse identifier 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 vessel_end_longitude_dim$longitude_in_degrees numeric 12 No No 8 Active numeric representation of longitude in decimal degrees dd -180 to 180 operation_dim$state_registration_number varchar 12 No No Active state registration number for the vessel temperature_at_surface_c_der numeric 10 No No 4 Active Single point estimate for surface temperature in degrees C for a haul. This has been collected in various ways over the course of the survey. It is likely that the PI-associated temperature sensor would be the most reliable; other sources would have to be evaluated for survey cycles preceding the introduction of this sensor unit. It is ordinarily expected that the depth represented by the temperature estimate be provided in association with the temperature estimate itself c net_width_m_der numeric 10 No No 4 Active Single point estimate for spread at the net wings in in meters for a haul. The standard up through present has been the mean over the center 80 percent of the tow duration of the best wingspread trace within the haul m operation_dim$operation_start_time_whid int8 64 No No 0 Active start time reference for the operation vessel_end_longitude_dim$longitude_compass_direction bpchar 1 No No Active longitude compass direction E, W vessel_start_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 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 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 max_depth_m numeric 12 No No 4 Active high precision value of maximum depth measured in meters m actual_station_design_dim$transect_latitude_whid int4 32 No No 0 Active latitude warehouse identifier for a design type of transect operation_dim$observer_program varchar 150 No No Active description of the observer program vessel_start_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 date_dim$year int4 32 No No 0 Active numeric representation of year 1978+ 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. operation_dim$coast_guard_number varchar 10 No No Active Coast Guard documentation number of vessel area_swept_ha_der numeric 16 No No 12 Active Product of the net width and fished distance (touchdown to liftoff distance) in hectares ha 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$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 date_yyyymmdd bpchar 8 No No Active text representation of year month day 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_compass_direction bpchar 1 No No Active latitude compass direction NA N, S sampling_end_timestamp timestamp No No Active Date and time that sampling stopped; almost exclusively the net liftoff time. gear_start_latitude_whid int4 32 No No 0 Active Warehouse identifier for gear start latitude vessel_end_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 gear_end_longitude_dim$longitude_compass_direction bpchar 1 No No Active longitude compass direction E, W temperature_at_gear_c_der numeric 10 No No 4 Active Single point estimate for temperature in degrees C at the gear for a haul. The standard up through present has been the mean over the center 80 percent of the tow duration of the best temperature sensor trace within the haul c vessel_end_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" 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 vessel_start_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 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 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 operation_dim$departure_date_whid int8 64 No No 0 Active date reference that vessel departed for the defined leg or trip 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 vessel_end_longitude_whid int4 32 No No 0 Active Warehouse identifier for vessel end longitude vessel_start_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 vessel_start_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" vessel_start_longitude_dd numeric 12 No No 8 Active Latitude at the vessel when sampling ceases (net liftoff for trawling). dd longitude_dd numeric 12 No No 8 Active numeric representation of longitude in decimal degrees dd -180 to 180 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 operation_dim$operation_end_date_whid int8 64 No No 0 Active end date reference for the operation tow_end_timestamp timestamp No No Active operation end date timestamp operation_dim$scientist_3_person_whid int4 32 No No 0 Active person reference for the third scientist vessel_start_latitude_dim$latitude_in_degrees numeric 12 No No 8 Active numeric representation of latitude in degrees dd -90 to 90 actual_station_design_dim$max_depth_whid int4 32 No No 0 Active maximum depth warehouse identifier 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" operation_dim$return_date_whid int8 64 No No 0 Active date reference that vessel returned for the defined leg or trip latitude_dim$named_parallel varchar 50 No No Active name of parallel, boundary, or commonly used geograpical location NA any haul_longitude_dim$longitude_compass_direction bpchar 1 No No Active longitude compass direction E, W year int2 16 No No 0 Active operation year year 2007+ target_station_design_dim$transect_latitude_whid int4 32 No No 0 Active latitude warehouse identifier for a design type of transect latitude_hi_prec_dd numeric 12 No No 8 Active The latitude portion of a derived single point position for a haul in decimal degrees. Expected to be used generally for making spatial decisions about a haul or mapping it as a single point dd 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 operation_dim$operation_end_time_whid int8 64 No No 0 Active end time reference for the operation min_depth_m numeric 12 No No 4 Active high precision value of minimum depth measured in meters m year_stn_invalid int2 16 No No Active Survey year the station became invalid for trawl year Any 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 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 fluorescence_at_surface_mg_per_m3_der numeric 10 No No 4 Active Single point fluorescence estimate for a haul in micrograms of chlorophyll per liter. This estimate has not been computed to date; it is unknow what the best estimator would be, but likely a simple mean would be appropriate mg/m3 vessel_start_longitude_dim$longitude_compass_direction bpchar 1 No No Active longitude compass direction E, W seafloor_depth_whid int4 32 No No 0 Active warehouse identifier for seafloor depth 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 leg int2 16 No No 0 Active leg number of the survey 1,2,3,4,5,6,7,8 gear_start_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 vessel_end_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 actual_station_design_dim$transect_latitude_dd numeric 12 No No 8 Active high precision value of transect latitude measured in decimal degrees dd net_liftoff_time time No No Active military time representation of the time depth_hi_prec_m numeric 10 No No 4 Active Single point estimate for seafloor depth representing the overall seafloor depth in meters for the haul. The standard up through present has been the single point estimate of gear depth summed with the single point estimate of net height in meters m 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 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 vessel_start_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 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 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 operation_dim$captain_person_whid int4 32 No No 0 Active person reference for the vessel captain 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 sample_duration_hr_der numeric 10 No No 6 Active Difference in hours between the net liftoff and touchdown times hr longitude_dim$longitude_in_degrees numeric 12 No No 8 Active numeric representation of longitude in decimal degrees dd -180 to 180 vessel_start_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 date_dim$full_date timestamp No No Active full date value operation_dim$ifq_account_number varchar 12 No No Active unique number assigned to user accounts in the Vessel Accounting Database gear_start_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 vessel_end_latitude_whid int4 32 No No 0 Active Warehouse identifier for vessel end latitude 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 target_station_design_dim$area_hectares numeric 12 No No 8 Active station area measured in hectares hectares gear_end_latitude_dim$named_parallel varchar 50 No No Active name of parallel, boundary, or commonly used geograpical location NA any gear_end_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 vessel_start_latitude_dim$named_parallel varchar 50 No No Active name of parallel, boundary, or commonly used geograpical location NA any gear_end_latitude_dim$latitude_compass_direction bpchar 1 No No Active latitude compass direction NA N, S 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 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 gear_start_longitude_dd numeric 12 No No 8 Active Longitude at the gear when sampling commences (net touchdown for trawling). 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 distance_start2hb_m_der numeric 10 No No 4 Active Estimate of the distance traveled by the trawl net during the period preceeding the start of net haulback (net touchdown to start of haulback period) in meters. Expected to be estimated from a hierarchy of methods favoring the use of gear positions derived by the ITI or from its bearing and horizontal range traces m 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$lower_right_latitude_whid int4 32 No No 0 Active lower right latitude warehouse identifier for a design type of grid 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 sampling_start_time_dim$second int2 16 No No 0 Active number of seconds in the minute sec 0-60 actual_station_design_dim$station_invalid_survey_year int2 16 No No Active Survey year the station became invalid for trawl year Any sampling_start_time_whid int8 64 No No 0 Active warehouse identifier for the sampling start time 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 vessel_start_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 mean_seafloor_dep_position_type varchar 25 No No Active Method used for deriving the seafloor depth single point Bottom Depth, Gross Operation Depth, Headrope Depth, Station-defined Midpoint target_station_design_whid int4 32 No No 0 Active warehouse identifier for target station design vessel_end_latitude_dim$named_parallel varchar 50 No No Active name of parallel, boundary, or commonly used geograpical location NA any 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 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$station_code varchar 12 No No Active unique identifier for a station definition latitude_dd numeric 12 No No 8 Active numeric representation of latitude in degrees dd -90 to 90 actual_station_design_dim$station_design_name varchar 50 No No Active name of the design for a collection of stations operation_dim$departure_port_whid int4 32 No No 0 Active port reference for the departure port 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 vessel_end_latitude_dim$latitude_compass_direction bpchar 1 No No Active latitude compass direction NA N, S vertebrate_weight_kg numeric 16 No No 3 Active Total catch vertebrate weight in kilograms kg vessel_start_longitude_whid int4 32 No No 0 Active Warehouse identifier for vessel start longitude 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 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 turbidity_ntu_der numeric 10 No No 4 Active Single point turbidity estimate for a haul in ntu (nephelometric turbidity units). This estimate has not been computed to date; it is unknow what the best estimator would be ntu 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 operation_dim$scientist_2_person_whid int4 32 No No 0 Active person reference for the second scientist 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$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 net_touchdown_time time No No Active military time representation of the time 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 operation_dim$vessel_id int2 16 No No 0 Active field database vessel id number sampling_start_time_dim$period bpchar 2 No No Active period of time AM, PM gear_start_latitude_dd numeric 12 No No 8 Active Latitude at the gear when sampling commences (net touchdown for trawling). dd gear_end_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 gear_end_longitude_dd numeric 12 No No 8 Active Longitude at the gear when sampling ceases (net liftoff for trawling). dd gear_start_latitude_dim$latitude_compass_direction bpchar 1 No No Active latitude compass direction NA N, S haul_latitude_whid int4 32 No No 0 Active warehouse identifier for haul latitude invertebrate_weight_kg numeric 16 No No 3 Active Total catch invertebrate weight in kilograms kg trawl_id int8 64 No No 0 Active identifier for a sampling operation operation_dim$operation_start_date_whid int8 64 No No 0 Active start date reference for the operation target_station_design_dim$min_latitude_dd numeric 12 No No 8 Active high precision value of minimum latitude measured in decimal degrees dd gear_start_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 gear_start_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 gear_start_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 gear_start_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_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 vessel_end_latitude_dim$latitude_in_degrees numeric 12 No No 8 Active numeric representation of latitude in degrees dd -90 to 90 sampling_start_time_dim$hour int2 16 No No 0 Active standard representation of the hour hr 0-12 actual_station_design_dim$mean_depth_m numeric 12 No No 4 Active high precision value of mean depth measured in meters m gear_end_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" actual_station_design_dim$max_depth_m numeric 12 No No 4 Active high precision value of maximum depth measured in meters m gear_end_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 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 tow_start_timestamp timestamp No No Active operation start date timestamp actual_station_design_dim$mean_depth_whid int4 32 No No 0 Active mean depth warehouse identifier distance_start2end_m_der numeric 10 No No 4 Active Estimate of the distance traveled by the trawl net during the period it was fully in contact with the seafloor (net touchdown to liftoff period) in meters. Expected to be estimated from a hierarchy of methods favoring the use of gear positions derived by the ITI or from its bearing and horizontal range traces m 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 actual_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$max_latitude_dd numeric 12 No No 8 Active high precision value of maximum latitude measured in decimal degrees dd sampling_end_time_whid int8 64 No No 0 Active warehouse identifier for the sampling end time longitude_hi_prec_dd numeric 12 No No 8 Active The longitude portion of a derived single point position for a haul in decimal degrees. Expected to be used generally for making spatial decisions about a haul or mapping it as a single point dd 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 sampling_end_hhmmss bpchar 6 No No Active concatenation of military hour, minute, second, example 230415 equates to 23:04:15 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 sampling_start_timestamp timestamp No No Active Date and time that sampling began; almost exclusively the net touchdown time. operation_dim$fpc_person_whid int4 32 No No 0 Active person reference for the FPC operation_dim_whid int4 32 No No 0 Active warehouse identifier for operation 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 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 vessel_start_longitude_dim$longitude_in_degrees numeric 12 No No 8 Active numeric representation of longitude in decimal degrees dd -180 to 180 vessel_start_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 tow int2 16 No No 0 Active operation number of the survey actual_station_design_dim$stn_invalid_for_trawl_date_whid int8 64 No No 0 Active station design invalidation date warehouse identifier vessel_end_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_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 actual_station_design_dim$max_latitude_whid int4 32 No No 0 Active maximum latitude warehouse identifier for a design type of transect vessel_start_latitude_dim$latitude_compass_direction bpchar 1 No No Active latitude compass direction NA N, S gear_start_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" longitude_dim$longitude_compass_direction bpchar 1 No No Active longitude compass direction E, W date_dim$day_of_month int2 16 No No 0 Active numeric representation of the day in month 1-31 latitude_dim$latitude_in_degrees numeric 12 No No 8 Active numeric representation of latitude in degrees dd -90 to 90 sampling_start_time_dim$minute int2 16 No No 0 Active number of minutes in the hour min 0-60 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 gear_start_latitude_dim$named_parallel varchar 50 No No Active name of parallel, boundary, or commonly used geograpical location NA any 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 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 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 sampling_start_time_dim$military_hour int2 16 No No 0 Active military representation of the hour 0-24 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 gear_end_latitude_whid int4 32 No No 0 Active Warehouse identifier for gear end latitude 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 midtow_lat_named_parallel varchar 50 No No Active name of parallel, boundary, or commonly used geograpical location NA any haul_longitude_whid int4 32 No No 0 Active warehouse identifier for haul longitude sampling_end_time_dim$minute int2 16 No No 0 Active number of minutes in the hour min 0-60 vessel_end_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 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$min_depth_m numeric 12 No No 4 Active high precision value of minimum depth measured in meters m gear_end_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 gear_end_longitude_whid int4 32 No No 0 Active Warehouse identifier for gear end longitude 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 net_height_m_der numeric 10 No No 4 Active Single point estimate for net height at the net wings in in meters for a haul. The standard up through present has been the mean over the center 80 percent of the tow duration of the best height trace within the haul. It should be noted that the candidate traces for this estimate are the ITI headrope to footrope height and the PI headrope to bottom height sensor traces m operation_dim$scientist_4_person_whid int4 32 No No 0 Active person reference for the fourth scientist actual_station_design_dim$min_depth_whid int4 32 No No 0 Active minimum depth warehouse identifier sampling_end_time_dim$military_hour int2 16 No No 0 Active military representation of the hour 0-24 actual_station_design_dim$min_latitude_whid int4 32 No No 0 Active minimum latitude warehouse identifier for a design type of transect 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 vessel_end_longitude_dd numeric 12 No No 8 Active Longitude at the vessel when sampling ceases (net touchdown for trawling). dd actual_station_design_whid int4 32 No No 0 Active warehouse identifier for station design operation_dim$operation_type varchar 20 No No Active type of operation CTD Cast, Drop, Experiment, Search, Trawl, VPR Tow, [null] 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$upper_left_longitude_whid int4 32 No No 0 Active upper left longitude warehouse identifier for a design type of grid gear_end_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_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" date_dim$month_of_year int2 16 No No 0 Active numeric representation of month of year 1-12 vessel_end_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 door_width_m_der numeric 10 No No 4 Active Single point estimate for spread at the doors in meters for a haul. The standard up through present has been the mean over the center 80 percent of the tow duration of the best (only, to date) doorspread trace within the haul m 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$trip_id int4 32 No No 0 Active trip identifier number target_station_design_dim$station_design_name varchar 50 No No Active name of the design for a collection of stations gear_start_longitude_whid int4 32 No No 0 Active Warehouse identifier for gear start longitude 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 gear_start_latitude_dim$latitude_in_degrees numeric 12 No No 8 Active numeric representation of latitude in degrees dd -90 to 90 Data Steward 2021-01-01 2021-06-06 Person Whitmire, Curt curt.whitmire@noaa.gov https://orcid.org/0000-0001-9176-1486 2725 Montlake Boulevard East Seattle WA 98112 USA Data Steward 2015-10-01 2020-12-31 Person Horness, Beth Beth.Horness@noaa.gov 2725 Montlake Boulevard East Seattle WA 98112 206-860-3311 Distributor 2015-10-01 Organization Northwest Fisheries Science Center NWFSC nmfs.nwfsc.metadata@noaa.gov https://ror.org/05r7z1k40 2725 Montlake Boulevard East Seattle WA 98112 USA 206-860-3200 https://www.nwfsc.noaa.gov NWFSC Home Online Resource Metadata Contact 2015-10-01 Organization Northwest Fisheries Science Center NWFSC nmfs.nwfsc.metadata@noaa.gov https://ror.org/05r7z1k40 2725 Montlake Boulevard East Seattle WA 98112 USA 206-860-3200 https://www.nwfsc.noaa.gov NWFSC Home Online Resource Originator 2015-10-01 2019-11-15 Person Hay, Todd todd.hay@noaa.gov 2725 Montlake Blvd. East Seattle WA 98112 Point of Contact 2015-10-01 2020-12-31 Person Horness, Beth Beth.Horness@noaa.gov 2725 Montlake Boulevard East Seattle WA 98112 206-860-3311 -124.0472 -122.3062 47.6449 44.6229 Northwest Fisheries Science Center: office and laboratory site for sample processing and analysis Continuing 1998-04-01 -122.3062 -122.3062 47.6449 47.6449 Northern California Current System: California Current System - US-canada border to US-Mexico border at depths of 55 - 1280 m Continuing 1998-04-01 -124.0472 -122.3062 47.6449 44.6229 Hatfield Marine Science Center: office and laboratory site for sample processing and analysis Continuing 1998-04-01 -124.0472 -122.3062 47.6449 44.6229 Northern California Current System: Samples taken and recorded Continuing 1998-04-01 -124.0472 -122.3062 47.6449 44.6229 Northern California Current System: Observations made and recorded Continuing 1998-04-01 Unclassified PDR is submitted N/A https://www.nwfsc.noaa.gov/data/api/v1/source/trawl.catch_fact/selection.json 2015-10-01 Organization Northwest Fisheries Science Center https://ror.org/05r7z1k40 Trawl Catch (RESTful) Catch data from bottom trawl survey Text (Structured) https://www.nwfsc.noaa.gov/data/api/v1/source/trawl.individual_fact/selection.json 2015-10-01 Organization Northwest Fisheries Science Center https://ror.org/05r7z1k40 Trawl Specimens (RESTful) Individuals caught and measured on the bottom trawl survey Text (Structured) https://www.nwfsc.noaa.gov/data/api/v1/source/trawl.operation_haul_fact/selection.json 2015-10-01 Organization Northwest Fisheries Science Center https://ror.org/05r7z1k40 Trawl Haul Characteristics (RESTful) Operation details including dates, times, location, depths, tempuratures, etc Text (Structured) https://www.webapps.nwfsc.noaa.gov/apex/parrdata/inventory/tables/table/trawl_catch 2015-10-01 Organization Northwest Fisheries Science Center https://ror.org/05r7z1k40 Trawl Catch Catch data from bottom trawl survey https://www.webapps.nwfsc.noaa.gov/apex/parrdata/inventory/tables/table/trawl_haul_characteristics 2015-10-01 Organization Northwest Fisheries Science Center https://ror.org/05r7z1k40 Trawl Haul Characteristics Operation details including dates, times, location, depths, tempuratures, etc https://www.webapps.nwfsc.noaa.gov/apex/parrdata/inventory/tables/table/trawl_specimens 2015-10-01 Organization Northwest Fisheries Science Center https://ror.org/05r7z1k40 Trawl Specimens Individuals caught and measured on the bottom trawl survey https://www.nwfsc.noaa.gov/data/map FRAM Data Warehouse Online Resource Web site This data set contains information on date, time, vessel, trawl identification (i.e. unique number), trawl performance, location, depth, area swept, trawl duration, temperature, species, haul weight, average individual weight, sex, length, length method, fish age and age structure. https://www.nwfsc.noaa.gov/data/map FRAM Data Warehouse Online Resource Web site This data set contains information on date, time, vessel, trawl identification (i.e. unique number), trawl performance, location, depth, area swept, trawl duration, temperature, species, haul weight, average individual weight, sex, length, length method, fish age and age structure. https://www.nwfsc.noaa.gov/data/map FRAM Data Warehouse Online Resource Web site This data set contains information on date, time, vessel, trawl identification (i.e. unique number), trawl performance, location, depth, area swept, trawl duration, temperature, species, haul weight, average individual weight, sex, length, length method, fish age and age structure. https://www.webapps.nwfsc.noaa.gov/apex/parrdata/inventory/datasets/dataset/131 West Coast Groundfish Bottom Trawl Survey Data Online Resource Web site NWFSC Dataset Information page. This data set contains information on date, time, vessel, trawl identification (i.e. unique number), trawl performance, location, depth, area swept, trawl duration, temperature, species, haul weight, average individual weight, sex, length, length method, fish age and age structure. RDBMS (Oracle, SQL Server, etc.) High Extensive data review is accomplished using time-series data analysis tools to review the quality of the tows, as well as significant SQL code to confirm fish sampling quality. Yes 10 Yes No Yes 120 QA/QC is performed during this time. NCEI-MD 120 The Northwest Fisheries Science Center facilitates backup and recovery of all data and IT components which are managed by IT Operations through the capture of static (point-in-time) backup data to physical media. Once data is captured to physical media (every 1-3 days), a duplicate is made and routinely (weekly) transported to an offsite archive facility where it is maintained throughout the data's applicable life-cycle. Data is captured using at-sea data collection software that records sensor time-series as well as captures fish catch and individual compositions. 36437 Entity 36438 Entity 36439 Entity gov.noaa.nmfs.inport:18418 Jeffrey Cowen 2013-02-13T17:14:23 SysAdmin InPortAdmin 2026-03-04T19:17:17 2019-06-04 Northwest Fisheries Science Center NWFSC 2725 Montlake Boulevard East Seattle WA 98112 USA 206-860-3200 https://www.nwfsc.noaa.gov 1001 Public No No 2019-06-04 1 Year 2020-06-04