36440 Entity Published / External 18433 Southern California Hook and Line Survey - 2020 Southern California Shelf Rockfish Hook and Line Survey Data Set Data View Detail and aggregate catch data given a date at a site and species caught best_available_taxonomy_dim$abbreviated_name varchar 50 No No Active specialized common name, generally for a well-known species of fish such as ATF, LST, SST best_available_taxonomy_dim$acoustics_species_id int4 32 No No 0 Active Species ID used in the acoustics program unspecified Any best_available_taxonomy_dim$class_30 varchar 50 No No Active class name best_available_taxonomy_dim$family_50 varchar 50 No No Active family name best_available_taxonomy_dim$genus_70 varchar 50 No No Active genus name best_available_taxonomy_dim$grp_nonstandard_taxon_99 varchar 50 No No Active a pseudo taxonomic level that has a common usage such as Invertebrata, Pisces (Fish). This has been designed to allow for only one level of para- or poly-phyletic group that is the terminus of the definition (it may be associated with a higher level taxonomic hierarchy). Consequently a definition such as Fish->Roundfish would not be supported with this design best_available_taxonomy_dim$hookandline_species_id int4 32 No No 0 Active species identifier used by hook and line best_available_taxonomy_dim$itis_taxonomic_serial_no int4 32 No No 0 Active ITIS taxonomic identifier unspecified Any best_available_taxonomy_dim$kingdom_10 varchar 50 No No Active kingdom name best_available_taxonomy_dim$observer_species_id int4 32 No No 0 Active species identifier used by the observer program 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$structure_source varchar 50 No No 0 Active Source of the taxonomic structure unspecified Any best_available_taxonomy_dim$subfamily_52 varchar 50 No No Active subfamily name best_available_taxonomy_dim$suborder_42 varchar 50 No No Active suborder name 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$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$infraclass_34 varchar 50 No No Active infraclass name best_available_taxonomy_dim$infraorder_44 varchar 50 No No Active infraorder name best_available_taxonomy_dim$pacfin_nom_spid varchar 10 No No 0 Active PacFIN nominal species identifier unspecified Any best_available_taxonomy_dim$order_40 varchar 50 No No Active order name best_available_taxonomy_dim$phylum_20 varchar 50 No No Active phylum name best_available_taxonomy_dim$subclass_32 varchar 50 No No Active subclass name best_available_taxonomy_dim$species_80 varchar 50 No No Active species 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$superorder_38 varchar 50 No No Active superorder name best_available_taxonomy_dim$trawl_survey_species_id int4 32 No No 0 Active species identifier used by the trawl survey best_available_taxonomy_dim$tribe_60 varchar 50 No No Active tribe name best_available_taxonomy_dim$worms_aphiaid int4 32 No No 0 Active WoRMS taxonomic identifier unspecified Any best_available_taxonomy_whid int4 32 No No 0 Active warehouse identifier to best available taxonomy captain_person_dim$first_name varchar 30 No No Active first name of person captain_person_dim$full_name varchar 100 No No Active full name in format of First and Last (Suffix) captain_person_dim$last_name varchar 30 No No Active last name of person captain_person_dim$middle_initial bpchar 1 No No Active middle initial of person captain_person_dim$nick_name varchar 30 No No Active nickname of person captain_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 captain_person_dim$role varchar 30 No No Active role taken during an operation Captain, 2nd Captain, FPC, Cook, Scientist, Deck Hand captain_person_whid int4 32 No No 0 Active warehouse identifier for the vessel captain 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 cpue_normalized_catch_numbers numeric No No Active a derived number of species caught at a site based off the number of valid hooks deployed at the site ctd_drop_latitude_dd numeric 12 No No 6 Active high precision value for CTD drop latitude in decimal degrees dd ctd_drop_latitude_dim$latitude_compass_direction bpchar 1 No No Active latitude compass direction NA N, S ctd_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 ctd_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 ctd_drop_latitude_dim$latitude_in_degrees numeric 12 No No 8 Active numeric representation of latitude in degrees dd -90 to 90 ctd_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 ctd_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 ctd_drop_latitude_dim$named_parallel varchar 50 No No Active name of parallel, boundary, or commonly used geograpical location NA any ctd_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 ctd_drop_latitude_whid int4 32 No No 0 Active warehouse identifier for CTD drop latitude ctd_drop_longitude_dd numeric 12 No No 6 Active high precision value for CTD drop longitude in decimal degrees dd ctd_drop_longitude_dim$longitude_compass_direction bpchar 1 No No Active longitude compass direction E, W ctd_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 ctd_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" ctd_drop_longitude_dim$longitude_in_degrees numeric 12 No No 8 Active numeric representation of longitude in decimal degrees dd -180 to 180 ctd_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 ctd_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 ctd_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 ctd_drop_time_dim$hh24miss bpchar 6 No No Active concatenation of military hour, minute, second, example 230415 equates to 23:04:15 ctd_drop_time_dim$hour int2 16 No No 0 Active standard representation of the hour hr 0-12 ctd_drop_time_dim$military_hour int2 16 No No 0 Active military representation of the hour 0-24 ctd_drop_time_dim$minute int2 16 No No 0 Active number of minutes in the hour min 0-60 ctd_drop_time_dim$period bpchar 2 No No Active period of time AM, PM ctd_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 ctd_drop_time_dim$second int2 16 No No 0 Active number of seconds in the minute sec 0-60 ctd_drop_time_dim$time time No No Active military time representation of the time ctd_drop_time_whid int4 32 No No 0 Active warehouse identifier for CTD drop time ctd_on_bottom_disolved_oxygen_aanderaa_ml_per_l numeric 6 No No 2 Active CTD aanderaa sensor on bottom disolved oxygen measured in milliliters per liter ml/l ctd_on_bottom_disolved_oxygen_sbe43_ml_per_l numeric 6 No No 2 Active CTD SBE43 sensor on bottom disolved oxygen measured in milliliters per liter ml/l ctd_on_bottom_measure_depth_dim$boundary_indicator varchar 40 No No Active depth boundry indicator identifying ifp boundary marks IFP Boundary Depth, Standard Contour Depth, NA ctd_on_bottom_measure_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 ctd_on_bottom_measure_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 ctd_on_bottom_measure_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 ctd_on_bottom_measure_depth_m numeric 12 No No 4 Active CTD on bottom measured depth in meters m ctd_on_bottom_measure_depth_whid int4 32 No No 0 Active warehouse identifier for CTD on bottom measure depth ctd_on_bottom_salinity_psu numeric 6 No No 2 Active CTD on bottom salinity in practical salinity units (psu) psu ctd_on_bottom_temp_c numeric 6 No No 2 Active CTD on bottom temperature in degrees celcius c ctd_sounder_depth_dim$boundary_indicator varchar 40 No No Active depth boundry indicator identifying ifp boundary marks IFP Boundary Depth, Standard Contour Depth, NA ctd_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 ctd_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 ctd_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 ctd_sounder_depth_m numeric 12 No No 4 Active CTD sounder depth in meters m ctd_sounder_depth_whid int4 32 No No 0 Active warehouse identifier for CTD sounder depth 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 departure_port_dim$port_code bpchar 3 No No Active port code for observer program departure_port_dim$port_group_code bpchar 2 No No Active port group code for observer program AK, AT, BB, CA, CB, CC, EA, FB, LA, MB, MT, NB, NP, SB, SF departure_port_dim$port_group_name varchar 50 No No Active port group name for observer program departure_port_dim$port_name_caps varchar 50 No No Active port name in all capitals format departure_port_dim$port_name_std varchar 50 No No Active port name in standard format departure_port_dim$record_type varchar 30 No No Active port record or reason record is unavailable Port, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned departure_port_dim$state_name varchar 20 No No Active state name Alaska, California, Oregon, Washington departure_port_whid int4 32 No No 0 Active warehouse identifier for the departure port fish_info_note varchar 1000 No No Active overall fish information note fpc_person_dim$first_name varchar 30 No No Active first name of person fpc_person_dim$full_name varchar 100 No No Active full name in format of First and Last (Suffix) fpc_person_dim$last_name varchar 30 No No Active last name of person fpc_person_dim$middle_initial bpchar 1 No No Active middle initial of person fpc_person_dim$nick_name varchar 30 No No Active nickname of person fpc_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 fpc_person_dim$role varchar 30 No No Active role taken during an operation Captain, 2nd Captain, FPC, Cook, Scientist, Deck Hand fpc_person_whid int4 32 No No 0 Active warehouse identifier for the FPC fram_program varchar 50 No No Active type of fram program Bottom Trawl, Hook and Line full_moon_pct int2 16 No No 0 Active percent of full moon leg int2 16 No No 0 Active leg number for the survey marine_reserve_indicator varchar 20 No No Active identifier if the hook was inside a marine reserve Is Marine Reserve, Not Marine Reserve, NA 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_type varchar 20 No No Active type of operation CTD Cast, Drop, Experiment, Search, Trawl, VPR Tow pacfin_spid varchar 10 No No Active pacfin species id - many taxa may not have one of these project_name varchar 50 No No Active project name return_port_dim$port_code bpchar 3 No No Active port code for observer program return_port_dim$port_group_code bpchar 2 No No Active port group code for observer program AK, AT, BB, CA, CB, CC, EA, FB, LA, MB, MT, NB, NP, SB, SF return_port_dim$port_group_name varchar 50 No No Active port group name for observer program return_port_dim$port_name_caps varchar 50 No No Active port name in all capitals format return_port_dim$port_name_std varchar 50 No No Active port name in standard format return_port_dim$record_type varchar 30 No No Active port record or reason record is unavailable Port, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned return_port_dim$state_abbrev bpchar 2 No No Active two letter state abbreviation AK, CA, OR, WA return_port_dim$state_name varchar 20 No No Active state name Alaska, California, Oregon, Washington return_port_whid int4 32 No No 0 Active warehouse identifier for return port sampling_end_hhmmss bpchar 6 No No Active concatenation of military hour, minute, second, example 230415 equates to 23:04:15 sampling_end_time_dim$hour int2 16 No No 0 Active standard representation of the hour hr 0-12 sampling_end_time_dim$military_hour int2 16 No No 0 Active military representation of the hour 0-24 sampling_end_time_dim$minute int2 16 No No 0 Active number of minutes in the hour min 0-60 sampling_end_time_dim$period bpchar 2 No No Active period of time AM, PM sampling_end_time_dim$record_type varchar 30 No No Active time record or reason record is unavailable Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned sampling_end_time_dim$second int2 16 No No 0 Active number of seconds in the minute sec 0-60 sampling_end_time_whid int4 32 No No 0 Active warehouse identifier for the sampling end time sampling_start_hhmmss bpchar 6 No No Active concatenation of military hour, minute, second, example 230415 equates to 23:04:15 sampling_start_time_dim$hour int2 16 No No 0 Active standard representation of the hour hr 0-12 sampling_start_time_dim$military_hour int2 16 No No 0 Active military representation of the hour 0-24 sampling_start_time_dim$minute int2 16 No No 0 Active number of minutes in the hour min 0-60 sampling_start_time_dim$period bpchar 2 No No Active period of time AM, PM sampling_start_time_dim$record_type varchar 30 No No Active time record or reason record is unavailable Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned sampling_start_time_dim$second int2 16 No No 0 Active number of seconds in the minute sec 0-60 sampling_start_time_whid int4 32 No No 0 Active warehouse identifier for the sampling start time scientific_name varchar 120 No No Active scientific name generally composed of the genus and species name and subspecies name if available, but may be the highest taxonomic level scientist_1_person_dim$first_name varchar 30 No No Active first name of person scientist_1_person_dim$full_name varchar 100 No No Active full name in format of First and Last (Suffix) scientist_1_person_dim$last_name varchar 30 No No Active last name of person scientist_1_person_dim$middle_initial bpchar 1 No No Active middle initial of person scientist_1_person_dim$nick_name varchar 30 No No Active nickname of person scientist_1_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 scientist_1_person_dim$role varchar 30 No No Active role taken during an operation Captain, 2nd Captain, FPC, Cook, Scientist, Deck Hand scientist_1_person_whid int4 32 No No 0 Active warehouse identifier for the first scientist scientist_2_person_dim$first_name varchar 30 No No Active first name of person scientist_2_person_dim$full_name varchar 100 No No Active full name in format of First and Last (Suffix) scientist_2_person_dim$last_name varchar 30 No No Active last name of person scientist_2_person_dim$middle_initial bpchar 1 No No Active middle initial of person scientist_2_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 scientist_2_person_dim$role varchar 30 No No Active role taken during an operation Captain, 2nd Captain, FPC, Cook, Scientist, Deck Hand scientist_2_person_whid int4 32 No No 0 Active warehouse identifier for the second scientist sea_surface_temp_c numeric 6 No No 2 Active sea surface temperature in degrees celcius c set_identifier varchar 12 No No Active set identifier 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_fish_finder_note varchar 1000 No No Active site fish finder notes site_general_note varchar 1000 No No Active site general notes site_habitat_note varchar 1000 No No Active site habitat notes site_moon_tide_dim$moon_phase varchar 15 No No Active moon phase New Moon, Waxing Crescent, First Quarter, Waxing Gibbous, Waning Gibbous, Third Quarter, Waning Crescent, Full Moon site_moon_tide_dim$record_type varchar 20 No No Active moon tide record or reason record is unavailable Moon_Tide, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned site_moon_tide_dim$tide_phase varchar 10 No No Active tide phase Ebb, Flood, Steady site_moon_tide_dim$tide_type varchar 10 No No Active tide type Spring, Neap, Neither site_moon_tide_whid int2 16 No No 0 Active warehouse identifier for site moon tide site_ocean_weather_note varchar 1000 No No Active site's ocean and weather notes site_valid_hooks int8 64 No No 0 Active a count of the number of valid hooks deployed at a site site_whid int4 32 No No 0 Active warehouse identifier to the 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 sunrise_time_dim$hh24miss bpchar 6 No No Active concatenation of military hour, minute, second, example 230415 equates to 23:04:15 sunrise_time_dim$hour int2 16 No No 0 Active standard representation of the hour hr 0-12 sunrise_time_dim$military_hour int2 16 No No 0 Active military representation of the hour 0-24 sunrise_time_dim$minute int2 16 No No 0 Active number of minutes in the hour min 0-60 sunrise_time_dim$period bpchar 2 No No Active period of time AM, PM sunrise_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 sunrise_time_dim$second int2 16 No No 0 Active number of seconds in the minute sec 0-60 sunrise_time_dim$time time No No Active military time representation of the time sunrise_time_whid int4 32 No No 0 Active Warehouse identifier for the sunrise time sunset_time_dim$hh24miss bpchar 6 No No Active concatenation of military hour, minute, second, example 230415 equates to 23:04:15 sunset_time_dim$hour int2 16 No No 0 Active standard representation of the hour hr 0-12 sunset_time_dim$military_hour int2 16 No No 0 Active military representation of the hour 0-24 sunset_time_dim$minute int2 16 No No 0 Active number of minutes in the hour min 0-60 sunset_time_dim$period bpchar 2 No No Active period of time AM, PM sunset_time_dim$second int2 16 No No 0 Active number of seconds in the minute sec 0-60 sunset_time_dim$time time No No Active military time representation of the time sunset_time_whid int4 32 No No 0 Active warehouse identifier for the sunset time swell_direction_mag int2 16 No No 0 Active swell direction in magnetic degrees mag swell_height_ft numeric 4 No No 1 Active swell height in feet ft swell_height_m numeric 8 No No 4 Active swell height in meters m taxon_rank varchar 15 No No Active name of the lowest taxonomic level used to define scientific name tide_height_first_ft numeric 4 No No 1 Active tide height at first drop for a site measured in feet ft tide_height_first_m numeric 8 No No 4 Active tide height at first drop for a site measured in meters m tide_height_last_ft numeric 4 No No 1 Active tide height at last (fifth) drop for a site measured in feet ft tide_height_last_m numeric 8 No No 4 Active tide height at last (fifth) drop for a site measured in meters m tide_height_mid_ft numeric 4 No No 1 Active tide height at middle (third) drop for a site measured in feet ft tide_height_mid_m numeric 8 No No 4 Active tide height at middle (third) drop for a site measured in meters m total_catch_numbers int8 64 No No 0 Active a count off the number of species caught at a site total_catch_wt_kg numeric No No Active a sum of the measured weights of a species caught at a site 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_id int2 16 No No 0 Active field database vessel id number wave_height_ft numeric 4 No No 1 Active wave height in feet ft wave_height_m numeric 8 No No 4 Active wave height in meters m sunset_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 best_available_taxonomy_dim$superfamily_48 varchar 50 No No Active superfamily name departure_port_dim$state_abbrev bpchar 2 No No Active two letter state abbreviation AK, CA, OR, WA ctd_drop_longitude_whid int4 32 No No 0 Active warehouse identifier for CTD drop longitude scientist_2_person_dim$nick_name varchar 30 No No Active nickname of person gov.noaa.nmfs.inport:36440 Jeffrey Cowen 2017-01-25T13:18:51 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