36425 Catch Acoustics Fact Entity Published / External 18470 Biological data - Integrated acoustic and trawl survey of Pacific hake off the Pacific Coast Data Set Planned Catch data from the Integrated acoustic and trawl survey of Pacific hake off the Pacific Coast Spreadsheet Yes PARR Catch data from the Integrated acoustic and trawl survey of Pacific hake off the Pacific Coast 1 operation_dim$return_port_whid Number 32 No No 0 Active port reference for return port Number 2 tow_end_timestamp Time No No Active operation end date timestamp Time 3 leg Number 16 No No 0 Active leg number of the survey Number 1,2,3,4,5,6,7,8 4 field_identified_taxonomy_dim$subphylum_22 Text 50 No No Active subphylum name Text 5 operation_dim$captain_person_whid Number 32 No No 0 Active person reference for the vessel captain Number 6 field_identified_taxonomy_dim$phylum_20 Text 50 No No Active phylum name Text 7 equilibrium_latitude_dim$latitude_compass_direction Text 1 No No Active latitude compass direction Text NA N, S 8 statistical_partition_whid Number 32 No No 0 Active Warehouse identifier for statistical partition Number 9 most_recent_taxonomy_update_date_dim$year Number 32 No No 0 Active numeric representation of year Number 1978+ 10 equilibrium_longitude_dim$record_type Text 50 No No Active longitude record type or reason record is unavailable Text Longitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned 11 sampling_start_time_dim$second Number 16 No No 0 Active number of seconds in the minute Number sec 0-60 12 equilibrium_latitude_whid Number 32 No No 0 Active Warehouse identifier for equilibrium latitude Number 13 field_identified_taxonomy_dim$pacfin_spid Text 10 No No Active pacfin species id - many taxa may not have one of these Text 14 operation_dim$ifq_account_number Text 12 No No Active unique number assigned to user accounts in the Vessel Accounting Database Text 15 equilibrium_latitude_dim$record_type Text 30 No No Active latitude record type or reason record is unavailable Text NA Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned 16 sampling_end_time_dim$hour Number 16 No No 0 Active standard representation of the hour Number hr 0-12 17 field_identified_taxonomy_dim$superclass_28 Text 50 No No Active superclass name Text 18 sample_weight_lb Number 10 No No 4 Active Weight of a sample of the catch measured in pounds Number lb 19 most_recent_taxonomy_update_date_dim$month_name Text 10 No No Active text representation of month Text January, February, March, April, May, June, July, August, September, October, November, December 20 field_identified_taxonomy_dim$genus_70 Text 50 No No Active genus name Text 21 weight_in_haul_lb Number 10 No No 4 Active Weight of the organisms for the species found in the haul measured in pounds Number lb 22 average_bottom_depth_dim$boundary_indicator Text 40 No No Active depth boundry indicator identifying ifp boundary marks Text IFP Boundary Depth, Standard Contour Depth, NA 23 operation_dim$operation_start_time_whid Number 64 No No 0 Active start time reference for the operation Number 24 equilibrium_longitude_dim$longitude_in_degree_minute_second Text 20 No No Active string representation of longitude in degrees, minutes, and seconds for example 4525'01" Text 25 operation_dim$scientist_1_person_whid Number 32 No No 0 Active person reference for the first scientist Number 26 net_liftoff_time Time No No Active military time representation of the time Time 27 sampling_start_time_dim$minute Number 16 No No 0 Active number of minutes in the hour Number min 0-60 28 operation_dim$scientist_4_person_whid Number 32 No No 0 Active person reference for the fourth scientist Number 29 sampling_start_time_whid Number 64 No No 0 Active Warehouse identifier for the sampling start time Number 30 equilibrium_latitude_dim$latitude_in_degree_minute_second Text 20 No No Active string representation of latitude in degrees, minutes, and seconds for example 4525'01" Text NA any 31 field_identified_taxonomy_dim$itis_taxonomic_serial_no Number 32 No No 0 Active ITIS taxonomic identifier Number unspecified Any 32 operation_dim$departure_port_whid Number 32 No No 0 Active port reference for the departure port Number 33 pass Number 32 No No 0 Active pass number of the survey Number 1,2,3,4 34 sampling_end_time_dim$period Text 2 No No Active period of time Text AM, PM 35 operation_dim$scientist_3_person_whid Number 32 No No 0 Active person reference for the third scientist Number 36 weight_in_haul_kg Number 10 No No 4 Active Weight of the organisms for the species found in the haul measured in kilograms Number kg 37 field_identified_taxonomy_dim$structure_source Text 50 No No 0 Active Source of the taxonomic structure Text unspecified Any 38 most_recent_taxon_update Time No No Active full date value Time 39 equilibrium_longitude_dim$longitude_second_units Number 16 No No 0 Active numeric representation of longitude that makes up the second unit only Number sec 0-59 40 equilibrium_latitude_dim$latitude_degree_units Number 16 No No 0 Active numeric representation of latitude that makes up the degree unit only Number deg -90 to 90 41 whole_haul_weight_lb Number 10 No No 4 Active Weight for the catch that hasn't been sampled out but is the actual measured weight for the haul measured in pounds Number lb 42 project Text 50 No No Active project name Text 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 43 partition Text 50 No No Active Refines the partition type Text Life stage: YOY, larvae, eggs and egg cases, adult, subadult; Size: Large, Small, Unspecified; Gender: Male, Female 44 sampling_start_time_dim$record_type Text 30 No No Active time record or reason record is unavailable Text Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned 45 field_identified_taxonomy_dim$observer_species_id Number 32 No No 0 Active species identifier used by the observer program Number 46 field_identified_taxonomy_dim$worms_aphiaid Number 32 No No 0 Active WoRMS taxonomic identifier Number unspecified Any 47 operation_dim$scientist_2_person_whid Number 32 No No 0 Active person reference for the second scientist Number 48 sampling_start_time_dim$military_hour Number 16 No No 0 Active military representation of the hour Number 0-24 49 most_recent_taxonomy_update_date_dim$yyyymmdd Text 8 No No Active text representation of year month day Text 50 net_touchdown_time Time No No Active military time representation of the time Time 51 operation_dim$vessel_id Number 16 No No 0 Active field database vessel id number Number 52 sampling_start_time_dim$period Text 2 No No Active period of time Text AM, PM 53 trawl_id Number 64 No No 0 Active identifier for a sampling operation Number 54 equilibrium_latitude_dim$latitude_minute_units Number 16 No No 0 Active numeric representation of latitude that makes up the minute unit only Number min 0-60 55 field_identified_taxonomy_dim$hookandline_species_id Number 32 No No 0 Active species identifier used by hook and line Number 56 sampling_end_time_dim$military_hour Number 16 No No 0 Active military representation of the hour Number 0-24 57 field_identified_taxonomy_dim$record_type Text 50 No No Active record or reason record is unavailable Text Taxonomy, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned 58 field_identified_taxonomy_dim$scientific_name_taxonomic_level Text 15 No No Active name of the lowest taxonomic level used to define scientific name Text 59 sampling_start_time_dim$hour Number 16 No No 0 Active standard representation of the hour Number hr 0-12 60 field_identified_taxonomy_dim$pacfin_nom_spid Text 10 No No 0 Active PacFIN nominal species identifier Text unspecified Any 61 field_identified_taxonomy_dim$superfamily_48 Text 50 No No Active superfamily name Text 62 program Text 50 No No Active type of fram program Text Bottom Trawl, Hook and Line 63 sampling_end_hhmmss Text 6 No No Active concatenation of military hour, minute, second, example 230415 equates to 23:04:15 Text 64 field_identified_taxonomy_dim$superorder_38 Text 50 No No Active superorder name Text 65 most_recent_taxonomy_update_date_dim$day_of_month Number 16 No No 0 Active numeric representation of the day in month Number 1-31 66 total_catch_weight_kg Number 10 No No 4 Active Weight of the total catch for the tow measured in kilograms Number kg 67 operation_dim$state_registration_number Text 12 No No Active state registration number for the vessel Text 68 sampling_end_time_whid Number 64 No No 0 Active Warehouse identifier for the sampling end time Number 69 operation_dim$record_type Text 30 No No Active operation record or reason record is unavailable Text Operation, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned 70 average_weight_kg Number 10 No No 4 Active Average weight of the species in this haul (weight_in_haul/number_in_haul) measured in kilograms Number kg 71 equilibrium_latitude_dim$named_parallel Text 50 No No Active name of parallel, boundary, or commonly used geograpical location Text NA any 72 field_identified_taxonomy_dim$common_name Text 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 Text 73 whole_haul_indicator Number 10 No No 4 Active Indicates if the catch weighed is the entire haul or a subsample Number Whole Haulled, Not Whole Haulled 74 operation_dim_whid Number 64 No No 0 Active Warehouse identifier for operation Number 75 most_recent_taxonomy_update_date_whid Number 64 No No 0 Active Warehouse identifier for most recent taxonomy update date Number 76 number_in_haul Number 10 No No 4 Active Count of the organisms for the species found in the haul; some of these may be extrapolated numbers Number 77 field_identified_taxonomy_whid Number 32 No No 0 Active Warehouse identifier to field identified taxonomy Number 78 tow Number 16 No No 0 Active operation number of the survey Number 79 equilibrium_longitude_dim$longitude_minute_units Number 16 No No 0 Active numeric representation of longitude that makes up the minute unit only Number min 0-59 80 average_bottom_depth_dim$depth_fathoms Number 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 Number fth 81 average_bottom_depth_whid Number 32 No No 0 Active Warehouse identifier for average bottom depth Number 82 field_identified_taxonomy_dim$infraclass_34 Text 50 No No Active infraclass name Text 83 field_identified_taxonomy_dim$subspecies_82 Text 50 No No Active subspecies name Text 84 operation_dim$coast_guard_number Text 10 No No Active Coast Guard documentation number of vessel Text 85 field_identified_taxonomy_dim$kingdom_10 Text 50 No No Active kingdom name Text 86 most_recent_taxonomy_update_date_dim$record_type Text 30 No No Active date, month, or year record or reason record is unavailable Text Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned 87 sampling_end_time_dim$record_type Text 30 No No Active time record or reason record is unavailable Text Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned 88 average_bottom_depth_dim$record_type Text 30 No No Active depth record or reason record is unavailable Text Depth, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned 89 sampling_end_time_dim$minute Number 16 No No 0 Active number of minutes in the hour Number min 0-60 90 whole_haul_weight_kg Number 10 No No 4 Active Weight for the catch that hasn't been sampled out but is the actual measured weight for the haul measured in kilograms Number kg 91 field_identified_taxonomy_dim$tribe_60 Text 50 No No Active tribe name Text 92 year Number 16 No No 0 Active operation year Number year 2007+ 93 equilibrium_latitude_dim$latitude_in_degrees Number 12 No No 8 Active numeric representation of latitude in degrees Number dd -90 to 90 94 field_identified_taxonomy_dim$subfamily_52 Text 50 No No Active subfamily name Text 95 field_identified_taxonomy_dim$subclass_32 Text 50 No No Active subclass name Text 96 field_identified_taxonomy_dim$class_30 Text 50 No No Active class name Text 97 equilibrium_longitude_whid Number 32 No No 0 Active Warehouse identifier for equilibrium longitude Number 98 operation_dim$operation_end_date_whid Number 64 No No 0 Active end date reference for the operation Number 99 field_identified_taxonomy_dim$grp_nonstandard_taxon_99 Text 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 Text 100 operation_dim$departure_date_whid Number 64 No No 0 Active date reference that vessel departed for the defined leg or trip Number 101 statistical_partition_dim$record_type Text 25 No No Active statistical partition record or reason record is unavailable Text Statistical Partition, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned 102 sampling_end_time_dim$second Number 16 No No 0 Active number of seconds in the minute Number sec 0-60 103 operation_dim$fpc_person_whid Number 32 No No 0 Active person reference for the FPC Number 104 sampling_start_hhmmss Text 6 No No Active concatenation of military hour, minute, second, example 230415 equates to 23:04:15 Text 105 field_identified_taxonomy_dim$infraorder_44 Text 50 No No Active infraorder name Text 106 performance Text 25 No No Active performance of the operation Text Insufficient Information, Indeterminate, Satisfactory, Trawlable, Untrawlable, Unsatisfactory, [null] 107 total_catch_weight_lb Number 10 No No 4 Active Weight of the total catch for the tow measured in pounds Number lb 108 field_identified_taxonomy_dim$norpac_species_id Number 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. Number unspecified Any 109 field_identified_taxonomy_dim$suborder_42 Text 50 No No Active suborder name Text 110 field_identified_taxonomy_dim$family_50 Text 50 No No Active family name Text 111 field_identified_taxonomy_dim$species_category Text 40 No No Active upper-level taxonomic ranking Text fish, invertebrate, mammal, seabird, reptile, nonspecific organics, NA 112 field_identified_taxonomy_dim$scientific_name Text 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 Text 113 most_recent_taxonomy_update_date_dim$month_abbrev Text 3 No No Active three character representation of month in capital letters Text JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC 114 tow_start_timestamp Time No No Active operation start date timestamp Time 115 field_identified_taxonomy_dim$species_sub_category Text 40 No No Active mid-level taxonomic ranking Text rockfish, flatfish, shark, crab, NA 116 operation_dim$return_date_whid Number 64 No No 0 Active date reference that vessel returned for the defined leg or trip Number 117 operation_dim$observer_program Text 150 No No Active description of the observer program Text 118 statistical_partition_dim$statistical_partition_type Text 30 No No Active Defines the partition type Text Life Stage, Size, Gender 119 equilibrium_longitude_dim$longitude_degree_units Number 16 No No 0 Active numeric representation of longitude that makes up the degree unit only Number deg -180 to 180 120 field_identified_taxonomy_dim$acoustics_species_id Number 32 No No 0 Active Species ID used in the acoustics program Number unspecified Any 121 operation_dim$operation_start_date_whid Number 64 No No 0 Active start date reference for the operation Number 122 average_bottom_depth_dim$depth_meters Number 12 No No 4 Active depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries) Number m 0-1500 123 field_identified_taxonomy_dim$order_40 Text 50 No No Active order name Text 124 field_identified_taxonomy_dim$species_80 Text 50 No No Active species name Text 125 equilibrium_longitude_dim$longitude_in_degrees Number 12 No No 8 Active numeric representation of longitude in decimal degrees Number dd -180 to 180 126 field_identified_taxonomy_dim$trawl_survey_species_id Number 32 No No 0 Active species identifier used by the trawl survey Number 127 average_weight_lb Number 10 No No 4 Active Average weight of the species in this haul (weight_in_haul/number_in_haul) measured in pounds Number lb 128 operation_dim$operation_type Text 20 No No Active type of operation Text CTD Cast, Drop, Experiment, Search, Trawl, VPR Tow, [null] 129 vessel Text 50 No No Active name of the vessel used for the operation Text 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 130 most_recent_taxonomy_update_date_dim$month_of_year Number 16 No No 0 Active numeric representation of month of year Number 1-12 131 equilibrium_longitude_dim$longitude_compass_direction Text 1 No No Active longitude compass direction Text E, W 132 equilibrium_latitude_dim$latitude_second_units Number 16 No No 0 Active numeric representation of latitude that makes up the second unit only Number sec 0-60 133 operation_dim$operation_end_time_whid Number 64 No No 0 Active end time reference for the operation Number 134 field_identified_taxonomy_dim$abbreviated_name Text 50 No No Active specialized common name, generally for a well-known species of fish such as ATF, LST, SST Text 135 operation_dim$limited_entry_permit_number Text 6 No No Active federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California Text 136 operation_dim$field_operation_seg_id Number 64 No No 0 Active operation segment id reference to the field operational segment table Number 137 operation_dim$trip_id Number 32 No No 0 Active trip identifier number Number 138 field_identified_taxonomy_dim$grp_reg_depth_category Text 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 Text 139 sample_weight_kg Number 10 No No 4 Active Weight of a sample of the catch measured in kilograms Number kg 140 transect_whid Number 32 No No 0 Active Warehouse identifier for transect Number gov.noaa.nmfs.inport:36425 Jeffrey Cowen 2017-01-25T10:28:18 SysAdmin InPortAdmin 2022-08-09T17:11:16 2017-03-03 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-03-03 1 Year 2018-03-03