36439 Entity Published / External 18418 West Coast Groundfish Bottom Trawl Survey Data - 2020 West Coast Groundfish Bottom Trawl Survey and indices of abundance Data Set Data Table Operation details including dates, times, location, depths, tempuratures, etc actual_station_design_dim$active_polygon_dd polygon No No Active collection of vertices of the usuable area inside a station grid measured in decimal degrees dd actual_station_design_dim$area_hectares numeric 12 No No 8 Active station area measured in hectares hectares actual_station_design_dim$centroid_id numeric 10 No No 0 Active eight character code representing a unique identifier for a grid cell that is composed of a truncated latitude and longitude central to the cell. For example, 46252413 represents latitude 46 degrees 25 minutes and longitude -124 degrees and 13 minutes. The grid cells are small enough that 8 characters captures uniqueness. Note that these are NOT technically or mathematically centroids of the polygons. actual_station_design_dim$lower_left_latitude_dd numeric 12 No No 8 Active high precision value of lower left latitude of design type grid measured in decimal degrees dd actual_station_design_dim$lower_left_latitude_whid int4 32 No No 0 Active lower left latitude warehouse identifier for a design type of grid actual_station_design_dim$lower_left_longitude_dd numeric 12 No No 8 Active high precision value of lower left longitude of design type grid measured in decimal degrees dd actual_station_design_dim$lower_left_longitude_whid int4 32 No No 0 Active lower left longitude warehouse identifier for a design type of grid unspecified Any actual_station_design_dim$lower_right_latitude_dd numeric 12 No No 8 Active high precision value of lower right latitude of design type grid measured in decimal degrees dd actual_station_design_dim$lower_right_latitude_whid int4 32 No No 0 Active lower right latitude warehouse identifier for a design type of grid actual_station_design_dim$lower_right_longitude_dd numeric 12 No No 8 Active high precision value of lower right longitude of design type grid measured in decimal degrees dd actual_station_design_dim$lower_right_longitude_whid int4 32 No No 0 Active lower right longitude warehouse identifier for a design type of grid actual_station_design_dim$max_depth_m numeric 12 No No 4 Active high precision value of maximum depth measured in meters m actual_station_design_dim$max_depth_whid int4 32 No No 0 Active maximum depth warehouse identifier actual_station_design_dim$max_latitude_dd numeric 12 No No 8 Active high precision value of maximum latitude measured in decimal degrees dd actual_station_design_dim$max_latitude_whid int4 32 No No 0 Active maximum latitude warehouse identifier for a design type of transect 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$mean_depth_whid int4 32 No No 0 Active mean 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 actual_station_design_dim$min_depth_whid int4 32 No No 0 Active minimum depth warehouse identifier actual_station_design_dim$min_latitude_dd numeric 12 No No 8 Active high precision value of minimum latitude measured in decimal degrees dd actual_station_design_dim$min_latitude_whid int4 32 No No 0 Active minimum latitude warehouse identifier for a design type of transect actual_station_design_dim$reason_station_invalid varchar 150 No No Active reason station was invalidated, multiple reasons are comma separated California State MPA, Cowcod Conservation Area, ENC Avoidance, Farallon Island Radioactive Waste Dump, ONMS MPA, ONMS Permit Exclusion, Outside Survey Extent, Mooring, San Clemente Is. Military test range actual_station_design_dim$record_type varchar 30 No No Active station design record or reason record is unavailable Station Design, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned actual_station_design_dim$station_code varchar 12 No No Active unique identifier for a station definition actual_station_design_dim$station_design_name varchar 50 No No Active name of the design for a collection of stations actual_station_design_dim$station_design_type varchar 15 No No Active type of design underlying the survey station set: Transect or Grid to date Transect, Grid actual_station_design_dim$station_grid_dd polygon No No Active collection of vertices of grid points of a grid design measured in decimal degrees dd actual_station_design_dim$station_invalid_survey_year int2 16 No No Active Survey year the station became invalid for trawl year Any actual_station_design_dim$stn_invalid_for_trawl_date_whid int8 64 No No 0 Active station design invalidation date warehouse identifier actual_station_design_dim$transect_latitude_dd numeric 12 No No 8 Active high precision value of transect latitude measured in decimal degrees dd actual_station_design_dim$transect_latitude_whid int4 32 No No 0 Active latitude warehouse identifier for a design type of transect actual_station_design_dim$transect_station_longitude_dd numeric 12 No No 8 Active high precision value of transect station longitude measured in decimal degrees dd actual_station_design_dim$transect_station_longitude_whid int4 32 No No 0 Active longitude on transect warehouse identifier for a design type of transect actual_station_design_dim$upper_left_latitude_dd numeric 12 No No 8 Active high precision value of upper left latitude of design type grid measured in decimal degrees dd actual_station_design_dim$upper_left_latitude_whid int4 32 No No 0 Active upper left latitude warehouse identifier for a design type of grid actual_station_design_dim$upper_left_longitude_dd numeric 12 No No 8 Active high precision value of upper left longitude of design type grid measured in decimal degrees dd actual_station_design_dim$upper_left_longitude_whid int4 32 No No 0 Active upper left longitude warehouse identifier for a design type of grid actual_station_design_dim$upper_right_latitude_dd numeric 12 No No 8 Active high precision value of upper right latitude of design type grid measured in decimal degrees dd actual_station_design_dim$upper_right_latitude_whid int4 32 No No 0 Active upper right latitude warehouse identifier for a design type of grid actual_station_design_dim$upper_right_longitude_dd numeric 12 No No 8 Active high precision value of upper right longitude of design type grid measured in decimal degrees dd actual_station_design_dim$upper_right_longitude_whid int4 32 No No 0 Active upper right longitude warehouse identifier for a design type of grid actual_station_design_dim$variance_depth_m2 numeric 12 No No 4 Active high precision value of variance depth mesured in squared meters m2 actual_station_design_whid int4 32 No No 0 Active warehouse identifier for station design 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 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. date_dim$day_of_month int2 16 No No 0 Active numeric representation of the day in month 1-31 date_dim$full_date timestamp No No Active full date value date_dim$month_abbrev bpchar 3 No No Active three character representation of month in capital letters JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC date_dim$month_name varchar 10 No No Active text representation of month January, February, March, April, May, June, July, August, September, October, November, December date_dim$month_of_year int2 16 No No 0 Active numeric representation of month of year 1-12 date_dim$record_type varchar 30 No No Active date, month, or year record or reason record is unavailable Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned date_dim$year int4 32 No No 0 Active numeric representation of year 1978+ date_whid int8 64 No No 0 Active warehouse identifier for date date_yyyymmdd bpchar 8 No No Active text representation of year month day depth_ftm numeric 12 No No 4 Active depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries fth depth_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 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 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 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 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 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 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 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 gear_end_latitude_dd numeric 12 No No 8 Active Latitude at the gear when sampling ceases (net liftoff for trawling). dd gear_end_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 gear_end_latitude_dim$latitude_in_degrees numeric 12 No No 8 Active numeric representation of latitude in degrees dd -90 to 90 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 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_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 gear_end_latitude_whid int4 32 No No 0 Active Warehouse identifier for gear end latitude gear_end_longitude_dd numeric 12 No No 8 Active Longitude at the gear when sampling ceases (net liftoff for trawling). dd gear_end_longitude_dim$longitude_compass_direction bpchar 1 No No Active longitude compass direction E, W 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_dim$longitude_in_degree_minute_second varchar 20 No No Active string representation of longitude in degrees, minutes, and seconds for example 4525'01" gear_end_longitude_dim$longitude_in_degrees numeric 12 No No 8 Active numeric representation of longitude in decimal degrees dd -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 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 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 gear_end_longitude_whid int4 32 No No 0 Active Warehouse identifier for gear end longitude gear_start_latitude_dd numeric 12 No No 8 Active Latitude at the gear when sampling commences (net touchdown for trawling). dd gear_start_latitude_dim$latitude_compass_direction bpchar 1 No No Active latitude compass direction NA N, S 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 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_start_latitude_dim$latitude_in_degrees numeric 12 No No 8 Active numeric representation of latitude in degrees dd -90 to 90 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 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_latitude_dim$named_parallel varchar 50 No No Active name of parallel, boundary, or commonly used geograpical location NA any 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_latitude_whid int4 32 No No 0 Active Warehouse identifier for gear start latitude gear_start_longitude_dd numeric 12 No No 8 Active Longitude at the gear when sampling commences (net touchdown for trawling). dd gear_start_longitude_dim$longitude_compass_direction bpchar 1 No No Active longitude compass direction E, W 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_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" gear_start_longitude_dim$longitude_in_degrees numeric 12 No No 8 Active numeric representation of longitude in decimal degrees dd -180 to 180 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 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 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 gear_start_longitude_whid int4 32 No No 0 Active Warehouse identifier for gear start longitude haul_latitude_dim$latitude_compass_direction bpchar 1 No No Active latitude compass direction NA N, S haul_latitude_dim$latitude_degree_units int2 16 No No 0 Active numeric representation of latitude that makes up the degree unit only deg -90 to 90 haul_latitude_dim$latitude_in_degree_minute_second varchar 20 No No Active string representation of latitude in degrees, minutes, and seconds for example 4525'01" NA any haul_latitude_dim$latitude_minute_units int2 16 No No 0 Active numeric representation of latitude that makes up the minute unit only min 0-60 haul_latitude_dim$latitude_second_units int2 16 No No 0 Active numeric representation of latitude that makes up the second unit only sec 0-60 haul_latitude_dim$record_type varchar 30 No No Active latitude record type or reason record is unavailable NA Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned haul_latitude_whid int4 32 No No 0 Active warehouse identifier for haul latitude haul_longitude_dim$longitude_compass_direction bpchar 1 No No Active longitude compass direction E, W haul_longitude_dim$longitude_degree_units int2 16 No No 0 Active numeric representation of longitude that makes up the degree unit only deg -180 to 180 haul_longitude_dim$longitude_in_degree_minute_second varchar 20 No No Active string representation of longitude in degrees, minutes, and seconds for example 4525'01" haul_longitude_dim$longitude_minute_units int2 16 No No 0 Active numeric representation of longitude that makes up the minute unit only min 0-59 haul_longitude_dim$longitude_second_units int2 16 No No 0 Active numeric representation of longitude that makes up the second unit only sec 0-59 haul_longitude_dim$record_type varchar 50 No No Active longitude record type or reason record is unavailable Longitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned haul_longitude_whid int4 32 No No 0 Active warehouse identifier for haul longitude invertebrate_weight_kg numeric 16 No No 3 Active Total catch invertebrate weight in kilograms kg latitude_dd numeric 12 No No 8 Active numeric representation of latitude in degrees dd -90 to 90 latitude_dim$latitude_compass_direction bpchar 1 No No Active latitude compass direction NA N, S 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 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 latitude_dim$latitude_in_degrees numeric 12 No No 8 Active numeric representation of latitude in degrees dd -90 to 90 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$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$named_parallel varchar 50 No No Active name of parallel, boundary, or commonly used geograpical location NA any 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 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 leg int2 16 No No 0 Active leg number of the survey 1,2,3,4,5,6,7,8 longitude_dd numeric 12 No No 8 Active numeric representation of longitude in decimal degrees dd -180 to 180 longitude_dim$longitude_compass_direction bpchar 1 No No Active longitude compass direction E, W 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 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_in_degrees numeric 12 No No 8 Active numeric representation of longitude in decimal degrees dd -180 to 180 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 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 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 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 max_depth_m numeric 12 No No 4 Active high precision value of maximum depth measured in meters m mean_seafloor_dep_boundary varchar 40 No No Active depth boundry indicator identifying ifp boundary marks IFP Boundary Depth, Standard Contour Depth, NA 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 midtow_lat_named_parallel varchar 50 No No Active name of parallel, boundary, or commonly used geograpical location NA any 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 min_depth_m numeric 12 No No 4 Active high precision value of minimum depth measured in meters m 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 net_liftoff_time time No No Active military time representation of the time net_touchdown_time time No No Active military time representation of the time 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 nonspecific_organics_weight_kg numeric 16 No No 3 Active Total non-specific organics weight in kilograms kg 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 operation_dim$captain_person_whid int4 32 No No 0 Active person reference for the vessel captain operation_dim$coast_guard_number varchar 10 No No Active Coast Guard documentation number of vessel operation_dim$departure_date_whid int8 64 No No 0 Active date reference that vessel departed for the defined leg or trip operation_dim$departure_port_whid int4 32 No No 0 Active port reference for the departure port operation_dim$field_operation_seg_id int8 64 No No 0 Active operation segment id reference to the field operational segment table operation_dim$fpc_person_whid int4 32 No No 0 Active person reference for the FPC operation_dim$ifq_account_number varchar 12 No No Active unique number assigned to user accounts in the Vessel Accounting Database operation_dim$limited_entry_permit_number bpchar 6 No No Active federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California operation_dim$observer_program varchar 150 No No Active description of the observer program operation_dim$operation_end_date_whid int8 64 No No 0 Active end date reference for the operation operation_dim$operation_end_time_whid int8 64 No No 0 Active end time reference for the operation operation_dim$operation_start_date_whid int8 64 No No 0 Active start date reference for the operation operation_dim$operation_start_time_whid int8 64 No No 0 Active start time reference for the operation operation_dim$operation_type varchar 20 No No Active type of operation CTD Cast, Drop, Experiment, Search, Trawl, VPR Tow, [null] operation_dim$record_type varchar 30 No No Active operation record or reason record is unavailable Operation, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned operation_dim$return_date_whid int8 64 No No 0 Active date reference that vessel returned for the defined leg or trip operation_dim$return_port_whid int4 32 No No 0 Active port reference for return port operation_dim$scientist_1_person_whid int4 32 No No 0 Active person reference for the first scientist operation_dim$scientist_2_person_whid int4 32 No No 0 Active person reference for the second scientist operation_dim$scientist_3_person_whid int4 32 No No 0 Active person reference for the third scientist operation_dim$scientist_4_person_whid int4 32 No No 0 Active person reference for the fourth scientist operation_dim$state_registration_number varchar 12 No No Active state registration number for the vessel operation_dim$trip_id int4 32 No No 0 Active trip identifier number operation_dim$vessel_id int2 16 No No 0 Active field database vessel id number operation_dim_whid int4 32 No No 0 Active warehouse identifier for operation pass int4 32 No No 0 Active pass number of the survey 1,2,3,4 performance varchar 25 No No Active performance of the operation Insufficient Information, Indeterminate, Satisfactory, Trawlable, Untrawlable, Unsatisfactory, [null] program varchar 50 No No Active type of fram program Bottom Trawl, Hook and Line project varchar 50 No No Active project name Groundfish Shelf Survey, Groundfish Slope and Shelf Combination Survery, Groundfish Slope Survey, Groundfish Triennial Shelf Survery, Hypoxia Study, Santa Barbara Basin Study, Shelf Rockfish [2004-2015], Video Study reason_stn_invalid varchar 150 No No Active reason station was invalidated, multiple reasons are comma separated California State MPA, Cowcod Conservation Area, ENC Avoidance, Farallon Island Radioactive Waste Dump, ONMS MPA, ONMS Permit Exclusion, Outside Survey Extent, Mooring, San Clemente Is. Military test range 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 sample_duration_hr_der numeric 10 No No 6 Active Difference in hours between the net liftoff and touchdown times hr sampling_end_hhmmss bpchar 6 No No Active concatenation of military hour, minute, second, example 230415 equates to 23:04:15 sampling_end_time_dim$hour int2 16 No No 0 Active standard representation of the hour hr 0-12 sampling_end_time_dim$military_hour int2 16 No No 0 Active military representation of the hour 0-24 sampling_end_time_dim$minute int2 16 No No 0 Active number of minutes in the hour min 0-60 sampling_end_time_dim$period bpchar 2 No No Active period of time AM, PM sampling_end_time_dim$record_type varchar 30 No No Active time record or reason record is unavailable Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned sampling_end_time_dim$second int2 16 No No 0 Active number of seconds in the minute sec 0-60 sampling_end_time_whid int8 64 No No 0 Active warehouse identifier for the sampling end time sampling_end_timestamp timestamp No No Active Date and time that sampling stopped; almost exclusively the net liftoff time. sampling_start_hhmmss bpchar 6 No No Active concatenation of military hour, minute, second, example 230415 equates to 23:04:15 sampling_start_time_dim$hour int2 16 No No 0 Active standard representation of the hour hr 0-12 sampling_start_time_dim$military_hour int2 16 No No 0 Active military representation of the hour 0-24 sampling_start_time_dim$minute int2 16 No No 0 Active number of minutes in the hour min 0-60 sampling_start_time_dim$period bpchar 2 No No Active period of time AM, PM sampling_start_time_dim$record_type varchar 30 No No Active time record or reason record is unavailable Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned sampling_start_time_dim$second int2 16 No No 0 Active number of seconds in the minute sec 0-60 sampling_start_time_whid int8 64 No No 0 Active warehouse identifier for the sampling start time sampling_start_timestamp timestamp No No Active Date and time that sampling began; almost exclusively the net touchdown time. seafloor_depth_dim$record_type varchar 30 No No Active depth record or reason record is unavailable Depth, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned seafloor_depth_whid int4 32 No No 0 Active warehouse identifier for seafloor depth station_code varchar 12 No No Active unique identifier for a station definition station_ll_lat_dd numeric 12 No No 8 Active high precision value of lower left latitude of design type grid measured in decimal degrees dd station_ll_lon_dd numeric 12 No No 8 Active high precision value of lower left longitude of design type grid measured in decimal degrees dd station_lr_lat_dd numeric 12 No No 8 Active high precision value of lower right latitude of design type grid measured in decimal degrees dd station_lr_lon_dd numeric 12 No No 8 Active high precision value of lower right longitude of design type grid measured in decimal degrees dd station_ul_lat_dd numeric 12 No No 8 Active high precision value of upper left latitude of design type grid measured in decimal degrees dd station_ul_lon_dd numeric 12 No No 8 Active high precision value of upper left longitude of design type grid measured in decimal degrees dd station_ur_lat_dd numeric 12 No No 8 Active high precision value of upper right latitude of design type grid measured in decimal degrees dd station_ur_lon_dd numeric 12 No No 8 Active high precision value of upper right longitude of design type grid measured in decimal degrees dd target_station_design_dim$active_polygon_dd polygon No No Active collection of vertices of the usuable area inside a station grid measured in decimal degrees dd target_station_design_dim$area_hectares numeric 12 No No 8 Active station area measured in hectares hectares target_station_design_dim$lower_left_latitude_whid int4 32 No No 0 Active lower left latitude warehouse identifier for a design type of grid target_station_design_dim$lower_left_longitude_whid int4 32 No No 0 Active lower left longitude warehouse identifier for a design type of grid unspecified Any target_station_design_dim$lower_right_latitude_whid int4 32 No No 0 Active lower right latitude warehouse identifier for a design type of grid target_station_design_dim$lower_right_longitude_whid int4 32 No No 0 Active lower right longitude warehouse identifier for a design type of grid target_station_design_dim$max_depth_whid int4 32 No No 0 Active maximum depth warehouse identifier target_station_design_dim$max_latitude_dd numeric 12 No No 8 Active high precision value of maximum latitude measured in decimal degrees dd target_station_design_dim$max_latitude_whid int4 32 No No 0 Active maximum latitude warehouse identifier for a design type of transect target_station_design_dim$mean_depth_m numeric 12 No No 4 Active high precision value of mean depth measured in meters m target_station_design_dim$mean_depth_whid int4 32 No No 0 Active mean depth warehouse identifier target_station_design_dim$min_depth_whid int4 32 No No 0 Active minimum depth warehouse identifier target_station_design_dim$min_latitude_dd numeric 12 No No 8 Active high precision value of minimum latitude measured in decimal degrees dd target_station_design_dim$min_latitude_whid int4 32 No No 0 Active minimum latitude warehouse identifier for a design type of transect target_station_design_dim$record_type varchar 30 No No Active station design record or reason record is unavailable Station Design, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned target_station_design_dim$station_design_name varchar 50 No No Active name of the design for a collection of stations target_station_design_dim$station_design_type varchar 15 No No Active type of design underlying the survey station set: Transect or Grid to date Transect, Grid target_station_design_dim$station_grid_dd polygon No No Active collection of vertices of grid points of a grid design measured in decimal degrees dd target_station_design_dim$stn_invalid_for_trawl_date_whid int8 64 No No 0 Active station design invalidation date warehouse identifier target_station_design_dim$transect_latitude_dd numeric 12 No No 8 Active high precision value of transect latitude measured in decimal degrees dd target_station_design_dim$transect_latitude_whid int4 32 No No 0 Active latitude warehouse identifier for a design type of transect target_station_design_dim$transect_station_longitude_dd numeric 12 No No 8 Active high precision value of transect station longitude measured in decimal degrees dd target_station_design_dim$transect_station_longitude_whid int4 32 No No 0 Active longitude on transect warehouse identifier for a design type of transect target_station_design_dim$upper_left_latitude_whid int4 32 No No 0 Active upper left latitude warehouse identifier for a design type of grid target_station_design_dim$upper_left_longitude_whid int4 32 No No 0 Active upper left longitude warehouse identifier for a design type of grid target_station_design_dim$upper_right_latitude_whid int4 32 No No 0 Active upper right latitude warehouse identifier for a design type of grid target_station_design_dim$upper_right_longitude_whid int4 32 No No 0 Active upper right longitude warehouse identifier for a design type of grid target_station_design_dim$variance_depth_m2 numeric 12 No No 4 Active high precision value of variance depth mesured in squared meters m2 target_station_design_whid int4 32 No No 0 Active warehouse identifier for target station design 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 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 tow int2 16 No No 0 Active operation number of the survey tow_end_timestamp timestamp No No Active operation end date timestamp tow_start_timestamp timestamp No No Active operation start date timestamp trawl_id int8 64 No No 0 Active identifier for a sampling operation 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 vertebrate_weight_kg numeric 16 No No 3 Active Total catch vertebrate weight in kilograms kg 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 vessel_end_latitude_dd numeric 12 No No 8 Active Longitude at the vessel when sampling commences (net touchdown for trawling). dd vessel_end_latitude_dim$latitude_compass_direction bpchar 1 No No Active latitude compass direction NA N, S 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 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 vessel_end_latitude_dim$latitude_in_degrees numeric 12 No No 8 Active numeric representation of latitude in degrees dd -90 to 90 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 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 vessel_end_latitude_dim$named_parallel varchar 50 No No Active name of parallel, boundary, or commonly used geograpical location NA any 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 vessel_end_latitude_whid int4 32 No No 0 Active Warehouse identifier for vessel end latitude vessel_end_longitude_dd numeric 12 No No 8 Active Longitude at the vessel when sampling ceases (net touchdown for trawling). dd vessel_end_longitude_dim$longitude_compass_direction bpchar 1 No No Active longitude compass direction E, W 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 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" vessel_end_longitude_dim$longitude_in_degrees numeric 12 No No 8 Active numeric representation of longitude in decimal degrees dd -180 to 180 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 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 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 vessel_end_longitude_whid int4 32 No No 0 Active Warehouse identifier for vessel end longitude vessel_start_latitude_dd numeric 12 No No 8 Active Latitude at the vessel when sampling commences (net touchdown for trawling). dd vessel_start_latitude_dim$latitude_compass_direction bpchar 1 No No Active latitude compass direction NA N, S 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 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 vessel_start_latitude_dim$latitude_in_degrees numeric 12 No No 8 Active numeric representation of latitude in degrees dd -90 to 90 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 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 vessel_start_latitude_dim$named_parallel varchar 50 No No Active name of parallel, boundary, or commonly used geograpical location NA any 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_latitude_whid int4 32 No No 0 Active Warehouse identifier for vessel start latitude vessel_start_longitude_dd numeric 12 No No 8 Active Latitude at the vessel when sampling ceases (net liftoff for trawling). dd vessel_start_longitude_dim$longitude_compass_direction bpchar 1 No No Active longitude compass direction E, W 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 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_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 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 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 vessel_start_longitude_whid int4 32 No No 0 Active Warehouse identifier for vessel start longitude year int2 16 No No 0 Active operation year year 2007+ year_stn_invalid int2 16 No No Active Survey year the station became invalid for trawl year Any gov.noaa.nmfs.inport:36439 Jeffrey Cowen 2017-01-25T13:15:14 SysAdmin InPortAdmin 2022-08-09T17:11:17 2017-02-13 Northwest Fisheries Science Center NWFSC 2725 Montlake Boulevard East Seattle WA 98112 USA 206-860-3200 https://www.nwfsc.noaa.gov 1001 Public No 2017-02-13 1 Year 2018-02-13