36441 Entity Published / External 18433 Southern California Hook and Line Survey - 2020 Southern California Shelf Rockfish Hook and Line Survey Data Set Data View Hook and Line individual details for only individuals that are not excluded age_years int2 16 No No 0 Active Individual determined age in years angler_person_dim$first_name varchar 30 No No Active first name of person angler_person_dim$record_type varchar 20 No No Active person record or reason record is unavailable Person, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned angler_person_dim$role varchar 30 No No Active role taken during an operation Captain, 2nd Captain, FPC, Cook, Scientist, Deck Hand angler_person_dim$full_name varchar 100 No No Active full name in format of First and Last (Suffix) angler_person_dim$last_name varchar 30 No No Active last name of person angler_person_dim$middle_initial bpchar 1 No No Active middle initial of person angler_person_dim$nick_name varchar 30 No No Active nickname of person best_available_taxonomy_dim$family_50 varchar 50 No No Active family name best_available_taxonomy_dim$genus_70 varchar 50 No No Active genus name best_available_taxonomy_dim$grp_nonstandard_taxon_99 varchar 50 No No Active a pseudo taxonomic level that has a common usage such as Invertebrata, Pisces (Fish). This has been designed to allow for only one level of para- or poly-phyletic group that is the terminus of the definition (it may be associated with a higher level taxonomic hierarchy). Consequently a definition such as Fish->Roundfish would not be supported with this design best_available_taxonomy_dim$grp_reg_depth_category varchar 25 No No Active management grouping mostly for rockfishes (but could be assigned to any species): nearshore, shelf, or slope, or in future shallower shelf and deeper shelf best_available_taxonomy_dim$infraorder_44 varchar 50 No No Active infraorder name best_available_taxonomy_dim$observer_species_id int4 32 No No 0 Active species identifier used by the observer program angler_person_whid int4 32 No No 0 Active Warehouse identifier for the angler best_available_taxonomy_dim$acoustics_species_id int4 32 No No 0 Active Species ID used in the acoustics program unspecified Any best_available_taxonomy_dim$class_30 varchar 50 No No Active class name best_available_taxonomy_dim$infraclass_34 varchar 50 No No Active infraclass name best_available_taxonomy_dim$itis_taxonomic_serial_no int4 32 No No 0 Active ITIS taxonomic identifier unspecified Any best_available_taxonomy_dim$abbreviated_name varchar 50 No No Active specialized common name, generally for a well-known species of fish such as ATF, LST, SST best_available_taxonomy_dim$norpac_species_id int4 32 No No 0 Active A three-digit numeric code assigned by the NMFS Observer Program to each different marine organism expected to be seen in the Bering Sea and northeast Pacific Ocean. Each number is uniquely associated with a species_name and a scientific name. unspecified Any best_available_taxonomy_dim$hookandline_species_id int4 32 No No 0 Active species identifier used by hook and line best_available_taxonomy_dim$kingdom_10 varchar 50 No No Active kingdom name best_available_taxonomy_dim$order_40 varchar 50 No No Active order name best_available_taxonomy_dim$pacfin_nom_spid varchar 10 No No 0 Active PacFIN nominal species identifier unspecified Any best_available_taxonomy_dim$phylum_20 varchar 50 No No Active phylum name best_available_taxonomy_dim$record_type varchar 50 No No Active record or reason record is unavailable Taxonomy, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned best_available_taxonomy_dim$species_80 varchar 50 No No Active species name best_available_taxonomy_dim$structure_source varchar 50 No No 0 Active Source of the taxonomic structure unspecified Any best_available_taxonomy_dim$subclass_32 varchar 50 No No Active subclass name best_available_taxonomy_dim$subfamily_52 varchar 50 No No Active subfamily name best_available_taxonomy_dim$subphylum_22 varchar 50 No No Active subphylum name best_available_taxonomy_dim$subspecies_82 varchar 50 No No Active subspecies name best_available_taxonomy_dim$superclass_28 varchar 50 No No Active superclass name best_available_taxonomy_dim$superfamily_48 varchar 50 No No Active superfamily name best_available_taxonomy_dim$superorder_38 varchar 50 No No Active superorder name best_available_taxonomy_dim$trawl_survey_species_id int4 32 No No 0 Active species identifier used by the trawl survey best_available_taxonomy_dim$tribe_60 varchar 50 No No Active tribe name best_available_taxonomy_observation_detail_dim$means_of_calculation varchar 30 No No Active describes how the measurement was calculated Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned best_available_taxonomy_observation_detail_dim$measurement_procurement varchar 30 No No Active how the measurement was achieved NA, Calculated, Estimated, Observed, Measured, Not Documented best_available_taxonomy_observation_detail_dim$method_description varchar 500 No No Active description of how the observation was taken best_available_taxonomy_observation_detail_dim$observation_type varchar 30 No No Active the type of observation NA, width, length, total_catch_weight, taxonomy, etc best_available_taxonomy_observation_detail_dim$record_type varchar 30 No No Active observation detail record type or reason record is unavailable Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned best_available_taxonomy_observation_detail_whid int4 32 No No 0 Active Warehouse identifier to taxonomy observation detail best_available_taxonomy_whid int4 32 No No 0 Active Warehouse identifier to best available taxonomy common_name varchar 50 No No Active only one broadly used common name is supported by this design. If the common name is not fairly universally used or is used by more than one taxon this should be left null date_dim$day_of_month int2 16 No No 0 Active numeric representation of the day in month 1-31 date_dim$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 to date details date_yyyymmdd bpchar 8 No No Active text representation of year month day disposition_dim$disposition varchar 20 No No Active Identifies condition Live, Dead, NA disposition_dim$record_type varchar 20 No No Active Type of record Disposition, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned disposition_dim$return_indicator varchar 20 No No Active Indicates if returned to sea Returned to Sea, Not Returned to Sea, NA disposition_whid int2 16 No No 0 Active Warehouse identifier to disposition details drop_latitude_dim$latitude_compass_direction bpchar 1 No No Active latitude compass direction NA N, S drop_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 drop_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 drop_latitude_dim$latitude_in_degrees numeric 12 No No 8 Active numeric representation of latitude in degrees dd -90 to 90 drop_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 drop_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 drop_latitude_dim$named_parallel varchar 50 No No Active name of parallel, boundary, or commonly used geograpical location NA any drop_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 drop_latitude_whid int4 32 No No 0 Active Warehouse identifier for the latitude drop to the second unit of measure drop_longitude_dim$longitude_compass_direction bpchar 1 No No Active longitude compass direction E, W drop_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 drop_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" drop_longitude_dim$longitude_in_degrees numeric 12 No No 8 Active numeric representation of longitude in decimal degrees dd -180 to 180 drop_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 drop_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 drop_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 drop_longitude_whid int4 32 No No 0 Active Warehouse identifier for the longitude drop to the second unit of measure drop_sounder_depth_dim$boundary_indicator varchar 40 No No Active depth boundry indicator identifying ifp boundary marks IFP Boundary Depth, Standard Contour Depth, NA drop_sounder_depth_dim$depth_fathoms 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 drop_sounder_depth_dim$depth_meters 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 drop_sounder_depth_whid int4 32 No No 0 Active Warehouse identifier to the drop depth from the sounder sensor to the tenth of a meter unit drop_time_dim$hour int2 16 No No 0 Active standard representation of the hour hr 0-12 drop_time_dim$military_hour int2 16 No No 0 Active military representation of the hour 0-24 drop_time_dim$minute int2 16 No No 0 Active number of minutes in the hour min 0-60 drop_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 drop_time_dim$second int2 16 No No 0 Active number of seconds in the minute sec 0-60 drop_time_dim$time time No No Active military time representation of the time drop_time_whid int8 64 No No 0 Active Warehouse identifier for the drop time 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 best_available_taxonomy_dim$suborder_42 varchar 50 No No Active suborder name best_available_taxonomy_dim$worms_aphiaid int4 32 No No 0 Active WoRMS taxonomic identifier unspecified Any date_dim$full_date timestamp No No Active full date value drop_time_dim$period bpchar 2 No No Active period of time AM, PM drop_sounder_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 drop_time_dim$hh24miss bpchar 6 No No Active concatenation of military hour, minute, second, example 230415 equates to 23:04:15 field_identified_taxonomy_dim$acoustics_species_id int4 32 No No 0 Active Species ID used in the acoustics program unspecified Any field_identified_taxonomy_dim$class_30 varchar 50 No No Active class name field_identified_taxonomy_dim$common_name varchar 50 No No Active only one broadly used common name is supported by this design. If the common name is not fairly universally used or is used by more than one taxon this should be left null field_identified_taxonomy_dim$family_50 varchar 50 No No Active family name field_identified_taxonomy_dim$genus_70 varchar 50 No No Active genus name field_identified_taxonomy_dim$grp_nonstandard_taxon_99 varchar 50 No No Active a pseudo taxonomic level that has a common usage such as Invertebrata, Pisces (Fish). This has been designed to allow for only one level of para- or poly-phyletic group that is the terminus of the definition (it may be associated with a higher level taxonomic hierarchy). Consequently a definition such as Fish->Roundfish would not be supported with this design field_identified_taxonomy_dim$grp_reg_depth_category varchar 25 No No Active management grouping mostly for rockfishes (but could be assigned to any species): nearshore, shelf, or slope, or in future shallower shelf and deeper shelf field_identified_taxonomy_dim$hookandline_species_id int4 32 No No 0 Active species identifier used by hook and line field_identified_taxonomy_dim$infraclass_34 varchar 50 No No Active infraclass name field_identified_taxonomy_dim$infraorder_44 varchar 50 No No Active infraorder name field_identified_taxonomy_dim$itis_taxonomic_serial_no int4 32 No No 0 Active ITIS taxonomic identifier unspecified Any field_identified_taxonomy_dim$kingdom_10 varchar 50 No No Active kingdom name field_identified_taxonomy_dim$norpac_species_id int4 32 No No 0 Active A three-digit numeric code assigned by the NMFS Observer Program to each different marine organism expected to be seen in the Bering Sea and northeast Pacific Ocean. Each number is uniquely associated with a species_name and a scientific name. unspecified Any field_identified_taxonomy_dim$observer_species_id int4 32 No No 0 Active species identifier used by the observer program field_identified_taxonomy_dim$order_40 varchar 50 No No Active order name field_identified_taxonomy_dim$pacfin_nom_spid varchar 10 No No 0 Active PacFIN nominal species identifier unspecified Any field_identified_taxonomy_dim$pacfin_spid varchar 10 No No Active pacfin species id - many taxa may not have one of these field_identified_taxonomy_dim$phylum_20 varchar 50 No No Active phylum name field_identified_taxonomy_dim$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 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 field_identified_taxonomy_dim$species_80 varchar 50 No No Active species name field_identified_taxonomy_dim$species_category varchar 40 No No Active upper-level taxonomic ranking fish, invertebrate, mammal, seabird, reptile, nonspecific organics, NA field_identified_taxonomy_dim$species_sub_category varchar 40 No No Active mid-level taxonomic ranking rockfish, flatfish, shark, crab, NA field_identified_taxonomy_dim$structure_source varchar 50 No No 0 Active Source of the taxonomic structure unspecified Any field_identified_taxonomy_dim$subclass_32 varchar 50 No No Active subclass name field_identified_taxonomy_dim$subfamily_52 varchar 50 No No Active subfamily name field_identified_taxonomy_dim$suborder_42 varchar 50 No No Active suborder name field_identified_taxonomy_dim$subphylum_22 varchar 50 No No Active subphylum name field_identified_taxonomy_dim$subspecies_82 varchar 50 No No Active subspecies name field_identified_taxonomy_dim$superclass_28 varchar 50 No No Active superclass name field_identified_taxonomy_dim$superfamily_48 varchar 50 No No Active superfamily name field_identified_taxonomy_dim$superorder_38 varchar 50 No No Active superorder name field_identified_taxonomy_dim$trawl_survey_species_id int4 32 No No 0 Active species identifier used by the trawl survey field_identified_taxonomy_dim$tribe_60 varchar 50 No No Active tribe name field_identified_taxonomy_dim$worms_aphiaid int4 32 No No 0 Active WoRMS taxonomic identifier unspecified Any field_identified_taxonomy_whid int4 32 No No 0 Active Warehouse identifier to field identified taxonomy fin_clip_number varchar 5 No No Active Individual fin clip tracking number fish_note varchar 1000 No No Active Fish note details hook_dim$gear_performance varchar 30 No No Active Gear performance No Problems, Lost Sinker, Minor Tangle, Major Tangle, Lost Gangion, Lost Hook(s), Missing Time, Multiple Hook, Gear Not Deployed hook_dim$hook_number int2 16 No No 0 Active The hook number on the line 1-5 hook_dim$hook_result varchar 25 No No Active The result of using the hook No Bait On Hook, Bait Back On Hook, No Hook, Multiple Hook, Fish, Angler Did Not Drop hook_dim$record_type varchar 25 No No Active hook record or reason record is unavailable Hook, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned hook_id int4 32 No No 0 Active Field database hook identifier hook_whid int4 32 No No 0 Active Warehouse identifier to hook details inclusion_dim$drop_inclusion_indicator varchar 25 No No Active indicates if drop should be included Include Drop, Do Not Include Drop, NA inclusion_dim$hook_inclusion_indicator varchar 25 No No Active indicates if hook should be included Include Hook, Do Not Include Hook, NA inclusion_dim$record_type varchar 25 No No Active inclusion record or reason record is unavailable Inclusion, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned inclusion_dim$site_inclusion_indicator varchar 25 No No Active indicates if site should be included Include Site, Do Not Include Site, NA inclusion_whid int4 32 No No 0 Active Warehouse identifier for what to include in analysis individual_tracking_id int4 32 No No 0 Active Field individual identification number lab_maturity_detail_dim$biologically_mature_certain_indicator varchar 40 No No Active identifies the certainty of the biological maturity Biologically Mature Certain, Not Biologically Mature Certain, NA lab_maturity_detail_dim$biologically_mature_indicator varchar 25 No No Active identifies biological maturity of the individual Biologically Mature, Not Biologically Mature, NA lab_maturity_detail_dim$functionally_mature_certain_indicator varchar 40 No No Active identifies the certainty of the functionally mature evaluation Functionally Mature Certain, Not Functionally Mature Certain, NA lab_maturity_detail_dim$functionally_mature_indicator varchar 25 No No Active identifies the functional maturity of the individual Functionally Mature, Not Functionally Mature, NA lab_maturity_detail_dim$record_type varchar 30 No No Active lab maturity detail record or reason record is unavailable Lab Maturity Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned lab_maturity_detail_whid int4 32 No No 0 Active Warehouse identifier to lab maturity details leg int2 16 No No 0 Active leg number of the survey 1,2,3,4,5,6,7,8 length_cm numeric 4 No No 1 Active Individual length in centimeters most_recent_age_update timestamp No No Active full date value most_recent_age_update_date_dim$day_of_month int2 16 No No 0 Active numeric representation of the day in month 1-31 most_recent_age_update_date_dim$month_abbrev bpchar 3 No No Active three character representation of month in capital letters JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC most_recent_age_update_date_dim$month_name varchar 10 No No Active text representation of month January, February, March, April, May, June, July, August, September, October, November, December most_recent_age_update_date_dim$month_of_year int2 16 No No 0 Active numeric representation of month of year 1-12 most_recent_age_update_date_dim$record_type varchar 30 No No Active date, month, or year record or reason record is unavailable Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned most_recent_age_update_date_dim$year int4 32 No No 0 Active numeric representation of year 1978+ most_recent_age_update_date_dim$yyyymmdd bpchar 8 No No Active text representation of year month day most_recent_age_update_date_whid int8 64 No No 0 Active Warehouse identifier for most recent age update date most_recent_taxon_update timestamp No No Active full date value most_recent_taxonomy_update_date_dim$day_of_month int2 16 No No 0 Active numeric representation of the day in month 1-31 most_recent_taxonomy_update_date_dim$month_abbrev bpchar 3 No No Active three character representation of month in capital letters JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC most_recent_taxonomy_update_date_dim$month_name varchar 10 No No Active text representation of month January, February, March, April, May, June, July, August, September, October, November, December most_recent_taxonomy_update_date_dim$month_of_year int2 16 No No 0 Active numeric representation of month of year 1-12 most_recent_taxonomy_update_date_dim$record_type varchar 30 No No Active date, month, or year record or reason record is unavailable Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned most_recent_taxonomy_update_date_dim$year int4 32 No No 0 Active numeric representation of year 1978+ most_recent_taxonomy_update_date_dim$yyyymmdd bpchar 8 No No Active text representation of year month day most_recent_taxonomy_update_date_whid int8 64 No No 0 Active Warehouse identifier for most recent taxonomy update date net_liftoff_time time No No Active military time representation of the time net_touchdown_time time No No Active military time representation of the time operation_dim$captain_person_whid int4 32 No No 0 Active person reference for the vessel captain operation_dim$coast_guard_number varchar 10 No No Active Coast Guard documentation number of vessel operation_dim$departure_date_whid int8 64 No No 0 Active date reference that vessel departed for the defined leg or trip operation_dim$departure_port_whid int4 32 No No 0 Active port reference for the departure port operation_dim$field_operation_seg_id int8 64 No No 0 Active operation segment id reference to the field operational segment table operation_dim$fpc_person_whid int4 32 No No 0 Active person reference for the FPC operation_dim$ifq_account_number varchar 12 No No Active unique number assigned to user accounts in the Vessel Accounting Database operation_dim$limited_entry_permit_number bpchar 6 No No Active federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California operation_dim$observer_program varchar 150 No No Active description of the observer program operation_dim$operation_end_date_whid int8 64 No No 0 Active end date reference for the operation operation_dim$operation_end_time_whid int8 64 No No 0 Active end time reference for the operation operation_dim$operation_start_date_whid int8 64 No No 0 Active start date reference for the operation operation_dim$operation_start_time_whid int8 64 No No 0 Active start time reference for the operation operation_dim$operation_type varchar 20 No No Active type of operation CTD Cast, Drop, Experiment, Search, Trawl, VPR Tow, [null] operation_dim$record_type varchar 30 No No Active operation record or reason record is unavailable Operation, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned operation_dim$return_date_whid int8 64 No No 0 Active date reference that vessel returned for the defined leg or trip operation_dim$return_port_whid int4 32 No No 0 Active port reference for return port operation_dim$scientist_1_person_whid int4 32 No No 0 Active person reference for the first scientist operation_dim$scientist_2_person_whid int4 32 No No 0 Active person reference for the second scientist operation_dim$scientist_3_person_whid int4 32 No No 0 Active person reference for the third scientist operation_dim$scientist_4_person_whid int4 32 No No 0 Active person reference for the fourth scientist operation_dim$state_registration_number varchar 12 No No Active state registration number for the vessel operation_dim$trip_id int4 32 No No 0 Active trip identifier number operation_dim$vessel_id int2 16 No No 0 Active field database vessel id number operation_dim_whid int8 64 No No 0 Active Warehouse identifier to operation details otolith_number varchar 4 No No Active Individual otolith tracking number pacfin_spid varchar 10 No No Active pacfin species id - many taxa may not have one of these 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 sampling_end_hhmmss bpchar 6 No No Active concatenation of military hour, minute, second, example 230415 equates to 23:04:15 sampling_end_time_dim$hour int2 16 No No 0 Active standard representation of the hour hr 0-12 sampling_end_time_dim$military_hour int2 16 No No 0 Active military representation of the hour 0-24 sampling_end_time_dim$minute int2 16 No No 0 Active number of minutes in the hour min 0-60 sampling_end_time_dim$period bpchar 2 No No Active period of time AM, PM sampling_end_time_dim$record_type varchar 30 No No Active time record or reason record is unavailable Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned sampling_end_time_dim$second int2 16 No No 0 Active number of seconds in the minute sec 0-60 sampling_end_time_whid int4 32 No No 0 Active Warehouse identifier for the sampling end time of the site visit sampling_start_hhmmss bpchar 6 No No Active concatenation of military hour, minute, second, example 230415 equates to 23:04:15 sampling_start_time_dim$hour int2 16 No No 0 Active standard representation of the hour hr 0-12 sampling_start_time_dim$military_hour int2 16 No No 0 Active military representation of the hour 0-24 sampling_start_time_dim$minute int2 16 No No 0 Active number of minutes in the hour min 0-60 sampling_start_time_dim$period bpchar 2 No No Active period of time AM, PM sampling_start_time_dim$record_type varchar 30 No No Active time record or reason record is unavailable Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned sampling_start_time_dim$second int2 16 No No 0 Active number of seconds in the minute sec 0-60 sampling_start_time_whid int4 32 No No 0 Active Warehouse identifier for the sampling start time of the site visit 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 sex bpchar 1 No No Active unspecified Any sex_dim$record_type varchar 30 No No Active latitude record type or reason record is unavailable NA Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned sex_dim$sex varchar 20 No No Active unspecified Any sex_whid int2 16 No No 0 Active Warehouse identifier to sex details site_dim$area_name varchar 50 No No Active name of area site is located in site_dim$cdfgblock int4 32 No No 0 Active CDFG Block Numbers that the sites fall within site_dim$cowcod_conservation_area_indicator varchar 40 No No Active indicates if site falls within the cowcod conservation area Inside_Cowcod_Conservancy_Area, Outside_Cowcod_Conservancy_Area. site_dim$distance_to_port_nm numeric 12 No No 1 Active distance from site to nearest port in nautical miles m site_dim$inactive_date_whid int8 64 No No 0 Active warehouse identifier for the date when the site went inactive site_dim$record_type varchar 30 No No Active site record or reason record is unavailable Site, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned site_dim$site_latitude_dd numeric 12 No No 6 Active site latitude in decimal degrees dd site_dim$site_latitude_whid int4 32 No No 0 Active warehouse identifier to latitude details for site site_dim$site_longitude_dd numeric 12 No No 6 Active site longitude in decimal degrees dd site_dim$site_longitude_whid int4 32 No No 0 Active warehouse identifier to longitude details for site site_dim$site_number int4 32 No No 0 Active site identifier number site_dim$tide_station_latitude_whid int4 32 No No 0 Active warehouse identifier to latitude details for site's nearest tide station site_dim$tide_station_longitude_whid int4 32 No No 0 Active warehouse identifier to longitude details for site's nearest tide station site_dim$tide_station_name varchar 60 No No Active name of nearest tide station site_dim$tide_station_noaa_id varchar 8 No No Active tide station id according to NOAA's Tides and Currents site site_whid int4 32 No No 0 Active Warehouse identifier to site details species_category varchar 40 No No Active upper-level taxonomic ranking fish, invertebrate, mammal, seabird, reptile, nonspecific organics, NA species_subcategory varchar 40 No No Active mid-level taxonomic ranking rockfish, flatfish, shark, crab, NA taxon_rank varchar 15 No No Active name of the lowest taxonomic level used to define scientific name taxon_source varchar 50 No No Active name of primary source used to get the measurement Angler, FPC, Genetics, Lab Exam, Large Scale, Morphometrics, Morphometrics + Genetics, NA, Quality Assurance, Retrospective Review, Taxon Rank Upped, Whole Organism tow int2 16 No No 0 Active operation number of the survey tow_end_timestamp timestamp No No Active operation end date timestamp tow_start_timestamp timestamp No No Active operation start date timestamp trawl_id int8 64 No No 0 Active identifier for a sampling operation vessel varchar 50 No No Active name of the vessel used for the operation Aggressor, Amy Lynn, BJ Thomas, Blue Horizon, Captain Jack, Coast Pride, Excalibur, Last Straw, Limit Stalker, Mirage, Miss Leona, Morning Star, Ms. Julie, Noahs Ark, Pacific Sun IV, Raven, Sea Eagle, Toronado weight_kg numeric 6 No No 2 Active Individual weight in kilograms year int2 16 No No 0 Active operation year year 2007+ gov.noaa.nmfs.inport:36441 Jeffrey Cowen 2017-01-25T13:18:57 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