75123 Entity Published / External 75024 AMMOP Oracle database 1999 - 2013 Data Set Table created from MS Access 1999 Cook Inlet Alaska Marine Mammal Observer Program Form 1. File CIOP99. 20240711MM ASS11US VARCHAR2(26 BYTE) No No Active "MS Access: Description: Associated Form 11US? Caption: 11US." ASS2 VARCHAR2(26 BYTE) No No Active "MS Access: Description: Associated form 2's? Caption: Associated Form 2?." ASS3 VARCHAR2(26 BYTE) No No Active "MS Access: Description: Associated form 3's? Caption: Associated Form 3?." ASS4 VARCHAR2(26 BYTE) No No Active "MS Access: Description: Associated form 4's? Caption: Associated Form 4?." BHNC VARCHAR2(26 BYTE) No No Active "MS Access: Description: Predominate manner the net fished during haul (enter up to three in order of predominance). No caption in MS Access." BSNC VARCHAR2(26 BYTE) No No Active "MS Access: Description: Predominate manner the net fished during soak (enter up to three in order of predominance). No caption in MS Access." COMMENTS VARCHAR2(4000 BYTE) No No Active "MS Access: Description: Comments.? Caption: No MS Access caption." DEBID VARCHAR2(26 BYTE) No No Active "MS Access: Description: 3 digit unique code of person who debriefed observer. Caption: Debrief" DEPBH NUMBER(38,0) No No Active "MS Access: Description: Average water depth in area at beginning of haul, in feet Caption: Depth" DEPBS NUMBER(38,0) No No Active "MS Access: Description: Average water depth in area at beginning of set, in feet. Caption: Depth" DISTBH VARCHAR2(26 BYTE) No No Active "MS Access: Description: Code for maximum distance in meters net is from shore at beginning of haul. Caption: Distance" DISTBS VARCHAR2(26 BYTE) No No Active "MS Access: Description: Code for maximum distance in meters net is from shore at beginning of set. Caption: Distance" DISTNNH VARCHAR2(26 BYTE) No No Active "MS Access: Description: Distance code for distance to next active fishing net at haul. Caption: Dist to nn haul." DISTNNS VARCHAR2(26 BYTE) No No Active "MS Access: Description: Distance code for distance to next active fishing net at soak. Caption: Dist. to next net:." DISTOBH NUMBER(38,0) No No Active "MS Access: Description: Observer distance from net during haul, in feet. Caption: No MS Access caption." DISTOBS VARCHAR2(26 BYTE) No No Active No MS Access description or caption. DISTRICTBH VARCHAR2(26 BYTE) No No Active "MS Access: Description: District code from ADFG statistical map where haul began. No MS Access caption." DISTRICTBS VARCHAR2(26 BYTE) No No Active "MS Access: Description: District code from ADFG statistical map where set began. Caption: DistrictB" EDITID VARCHAR2(26 BYTE) No No Active "MS Access: Description: 3 digit unique code of person who edited data into the form. Caption: Field Edit" ENTID VARCHAR2(26 BYTE) No No Active "MS Access: Description: 3 digit unique code of person who entered data into form. Caption: Data Entry" EO1 VARCHAR2(26 BYTE) No No Active "MS Access: Description: Time when observation stops. Caption: End Obs." EO2 VARCHAR2(26 BYTE) No No Active No MS Access description or caption. EO3 VARCHAR2(26 BYTE) No No Active No MS Access description or caption. EO4 VARCHAR2(26 BYTE) No No Active No MS Access description or caption. EO5 VARCHAR2(26 BYTE) No No Active No MS Access description or caption. ESTDAM NUMBER(38,0) No No Active "MS Access: Description: Estimated square feet (to nearest tenth) of damage. Caption: Est. sq.ft. damage:." FINALID VARCHAR2(26 BYTE) No No Active No MS Access metadata. FISHERY VARCHAR2(26 BYTE) No No Active "MS Access: Description: Fishery observed (drift or set gillnet). Caption: Fishery" FTRIP VARCHAR2(26 BYTE) No No Active "MS Access: Description: Full trip observed? Caption: Full trip (y/n)" GUID VARCHAR2(26 BYTE) No No Active "MS Access: Description: Links Forms 1, 2, 3, and 4 unique to an observed "set" Caption: No MS Access caption." HABBH VARCHAR2(26 BYTE) No No Active "MS Access: Description: Code for substrate type at beginning of haul. Caption: Habitat" HABBS VARCHAR2(26 BYTE) No No Active "MS Access: Description: Code for substrate type at begining of set. Caption: Habitat" LATBH VARCHAR2(26 BYTE) No No Active "MS Access: Description: Latitude to nearest 1/10 minute of begin haul Caption: Latitude" LATBS VARCHAR2(26 BYTE) No No Active "MS Access: Description: Latitude to nearest 1/10 minute of begin set. Caption: Latitude" LBREF VARCHAR2(26 BYTE) No No Active "MS Access: Description: Comments relevant to entries in logbook? Caption: Log book reference (Y/N):." LBREFNO VARCHAR2(26 BYTE) No No Active "MS Access: Description: Comments in logbook #. Caption: (if yes): logbook #." LBREFPG VARCHAR2(26 BYTE) No No Active "MS Access: Description: Comments on page number (?) of logbook. Caption: Logbook page number with comments." LDR NUMBER(38,0) No No Active "MS Access: Description: Set nets only. Seine web used as leader? Caption: If leader, length (fath.):" LONGBH VARCHAR2(26 BYTE) No No Active "MS Access: Description: Longitude to nearest 1/10 minute of begin haul. Caption: Longitude" LONGBS VARCHAR2(26 BYTE) No No Active "MS Access: Description: Longitude to nearest 1/10 minute of begin set. Caption: Longitude" MB300 VARCHAR2(26 BYTE) No No Active "MS Access: Description: Marine birds noted in area during fishing? Caption: MB w/in 300m?." MM10CD1 VARCHAR2(26 BYTE) No No Active "MS Access: Description: Species code of marine mammals within 10m of net if reported by crew. Caption: species code & #:." MM10CD2 VARCHAR2(26 BYTE) No No Active "MS Access: Description: Species code of marine mammals within 10m of net if reported by crew. Caption: species code & #:." MSIZE NUMBER(38,14) No No Active "MS Access: Description: Stretch mesh size in tenths of inches. Caption: Mesh size (inches):" MM10NO1 NUMBER(38,0) No No Active "MS Access: Description: Associated number of marine mammals. Caption: No MS Access caption." MM10NO2 NUMBER(38,0) No No Active "MS Access: Description: Associated number of marine mammals. Caption: No MS Access caption." MM300 VARCHAR2(26 BYTE) No No Active "MS Access: Description: Marine mammals noted in area during fishing? Caption: MM w/in 300m?." NETD NUMBER(38,0) No No Active "MS Access: Description: Hung depth of the net, in feet. Caption: Net depth (ft.)" NETL NUMBER(38,0) No No Active "MS Access: Description: Length of fished net as first set, in fathoms. Caption: Net length (fath.)" NETNO VARCHAR2(26 BYTE) No No Active "MS Access: Description: Position of set net observed based on grid layout. Caption: Set net grid#" NONETS NUMBER(38,0) No No Active "MS Access: Description: Total number of nets being fished by same permit at time of observation. Caption: # of nets fished" NUMNN NUMBER(38,0) No No Active "MS Access: Description: Approx. number of fishing nets within 800m. Caption: # nets<800m:." OBSERVATION_DATE DATE No No Active "MS Access: Description: Date observation of set began. Caption: Date (mm/dd/yy)" OBSID VARCHAR2(26 BYTE) No No Active "MS Access: Description: 3 digit unique observer ID code. Caption: Obs. code" OFFID VARCHAR2(26 BYTE) No No Active "MS Access: Description: 3 digit unique code of office person who reviewed data. Caption: Office Edit" ORIENT VARCHAR2(26 BYTE) No No Active "MS Access: Description: Orientation of net during set code. Caption: Orientation" OVRLP VARCHAR2(26 BYTE) No No Active "MS Access: Description: Mainly for set nets. Any overlap between nearest nets? Caption: Overlap (y/n)" PERMAX VARCHAR2(26 BYTE) No No Active "MS Access: Description: Percent code of largest amount of net fished during set. Caption: max-min % net fished:." PERMIN VARCHAR2(26 BYTE) No No Active "MS Access: Description: Percent code of least amount of net fished during set. Caption: No MS Access caption." PERMITID VARCHAR2(26 BYTE) No No Active "MS Access: Description: CFEC permit (set) or ADFG vessel (drift) number and check digit. Caption: Permit #" PERPH VARCHAR2(26 BYTE) No No Active "MS Access: Description: Percentage of net that was "picked" for fish if a partial haul. Caption: If part % T." PERTG VARCHAR2(26 BYTE) No No Active "MS Access: Description: Code for % time gear was tended. Caption: % time tended gear:." PERWN VARCHAR2(26 BYTE) No No Active "MS Access: Description: Percent code best reflecting total time whole net fished. Caption: % time whole net fished:." PHOTO VARCHAR2(26 BYTE) No No Active "MS Access: Description: Photograph taken? Caption: Photo reference (Y/N):." PHTIME VARCHAR2(26 BYTE) No No Active "MS Access: Description: Time the haul was partially picked. Caption: No MS Access caption." PLATFORM VARCHAR2(26 BYTE) No No Active "MS Access: Description: Platform from which observations were made. Caption: Platform code" PRIMKEY NUMBER(38,0) No No Active No MS Access metadata. PROLL NUMBER(38,0) No No Active "MS Access: Description: Roll number of photographs. Caption: roll#." PSHOT NUMBER(38,0) No No Active "MS Access: Description: Photograph number. Caption: and shot #." RELNETS VARCHAR2(26 BYTE) No No Active "MS Access: Description: Relationship to other nets (outside or inside). Caption: Relt. to nets:" RUNG VARCHAR2(26 BYTE) No No Active "MS Access: Description: Did skipper run gear? Caption: Run Gear (y/n/u)." SEABH NUMBER(38,0) No No Active "MS Access: Description: Sea state code at begining of haul. Caption: No caption in MS Access." SEABS NUMBER(38,0) No No Active "MS Access: Description: Sea state code at begining of set. Caption: Sea state." SO3 VARCHAR2(26 BYTE) No No Active No MS Access description or caption. SETNO NUMBER(38,0) No No Active "MS Access: Description: Sequential number of set observed per day by observer. Caption: Observed Set #" SO1 VARCHAR2(26 BYTE) No No Active "MS Access: Description: Time when first begin observing. Caption: Start obs." SO2 VARCHAR2(26 BYTE) No No Active No MS Access description or caption. SO4 VARCHAR2(26 BYTE) No No Active No MS Access description or caption. SO5 VARCHAR2(26 BYTE) No No Active No MS Access description or caption. STABH VARCHAR2(26 BYTE) No No Active "MS Access: Description: Tide stage code at begin of haul. Caption: Stage." STABS VARCHAR2(26 BYTE) No No Active "MS Access: Description: Tide stage code at begin of set. Caption: Stage." STATWK NUMBER(38,0) No No Active "MS Access: Description: ADFG statistical week. Caption: Week #" TIDEBH VARCHAR2(26 BYTE) No No Active "MS Access: Description: Tide code at beginning of haul. Caption: Tide." TIDEBS VARCHAR2(26 BYTE) No No Active "MS Access: Description: Ttide code at beginning of set. Caption: Tide." TIMEBH VARCHAR2(26 BYTE) No No Active "MS Access: Description: Time beginning set retrieval or pick. Caption: Begin Haul." TIMEBS VARCHAR2(26 BYTE) No No Active "MS Access: Description: Time of drift/set net set start (or time of set net last haul). Caption: Begin Set." TIMEEH VARCHAR2(26 BYTE) No No Active "MS Access: Description: Time set retrieval ends. Caption: End Haul." TIMEES VARCHAR2(26 BYTE) No No Active "MS Access: Description: Time ofdrift/set net begin soak. Caption: Begin Soak." VISBH VARCHAR2(26 BYTE) No No Active "MS Access: Description: Visibility code for conditions during haul. Caption: No caption in MS Access." VISBS VARCHAR2(26 BYTE) No No Active "MS Access: Description: Visibility code for conditions during soak. Caption: Visibility." VPNAME VARCHAR2(26 BYTE) No No Active MS Access: Description: Vessel name (drift) or permit holder name (set; last, first, mi). Caption:Vessel/permit name WEABH VARCHAR2(26 BYTE) No No Active "MS Access: Description: Weather code for conditions during haul. Caption: No caption in MS Access." WEABS VARCHAR2(26 BYTE) No No Active "MS Access: Description: Weather code for conditions during soak. Caption: Weather." WLINE NUMBER(38,0) No No Active "MS Access: Description: If a weedline is present, how long is the drop? Caption: If weedline (inches):" WNFISH VARCHAR2(26 BYTE) No No Active "MS Access: Description: Did entire length and depth of net fish entire set? Caption: Whole net fished for set (y/n)." ZONEBH VARCHAR2(26 BYTE) No No Active "MS Access: Description: Code for land form at beginning of haul. Caption: Zone" ZONEBS VARCHAR2(26 BYTE) No No Active "MS Access: Description: Code for land form at beginning of set. Caption: Zone" gov.noaa.nmfs.inport:75123 Rachel Wuest 2025-03-05T23:40:56 Daniel Woodrich 2025-05-21T19:12:03 2025-05-21 Alaska Fisheries Science Center AFSC 7600 Sand Point Way N.E., Building 4 Seattle WA 98115 USA https://www.afsc.noaa.gov 0700-1700 Pacific Time 1001 Public No 1 Year