75104 Entity Published / External 75024 AMMOP Oracle database 1999 - 2013 Data Set Table created from MS Access 2000 Cook Inlet Alaska Marine Mammal Observer Program Form 1. File CIOP00. 20241022MM ASS11US VARCHAR2(26 BYTE) No No Active "MS Access: Description: Associated Form 11US? MS Access caption: 11US." ASS2 VARCHAR2(26 BYTE) No No Active "MS Access: Description: Associated form 2's? MS Access caption: Circle other forms for this set: 2." ASS3 VARCHAR2(26 BYTE) No No Active "MS Access: Description: Associated form 3's? MS Access caption: 3." ASS4 VARCHAR2(26 BYTE) No No Active "MS Access: Description: Associated form 4's? MS Access caption: 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) MS Access caption: No caption." 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) MS Access caption: No caption." COMMENTS VARCHAR2(1024 BYTE) No No Active "MS Access: Description: Comments. MS Access caption: No caption." COMYN VARCHAR2(26 BYTE) No No Active "MS Access: Description: Comments written on back of form? MS Access caption: For more info. see back of form:." DEBID VARCHAR2(26 BYTE) No No Active "MS Access: Description: (Debrief ID) 3 digit unique code of person who debriefed observer. MS Access caption: Debrief" DEPBH NUMBER(38,0) No No Active "MS Access: Description: Average water depth in area at beginning of haul, in feet MS Access caption: Depth." DEPBS NUMBER(38,0) No No Active "MS Access: Description: Average water depth in area of soak, in feet MS Access 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 MS Access caption: Distance." DISTBS VARCHAR2(26 BYTE) No No Active "MS Access: Description: Code for maximum distance in meters net is from shore during soak. MS Access caption: Distance" DISTNNH VARCHAR2(26 BYTE) No No Active "MS Access: Description: Distance code for distance to next active fishing net at haul. MS Access 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. MS Access caption: Dist. to next net:" DISTOBH NUMBER(38,0) No No Active "MS Access: Description: Observer distance from net during haul, in feet. MS Access caption: No caption." DISTOBS VARCHAR2(26 BYTE) No No Active "MS Access: Description: Distance code for distance between observer and furthest part of observed net during soak. MS Access caption: No caption." DISTRICTBS VARCHAR2(26 BYTE) No No Active "MS Access: Description: District code from ADFG statistical map. MS Access caption: District" ENTID VARCHAR2(26 BYTE) No No Active "MS Access: Description: (Entry ID) 3 digit unique code of person who entered data into form. MS Access caption: Data Entry" EO1 VARCHAR2(26 BYTE) No No Active "MS Access: Description: Time when observation stops. MS Access caption: End Obs." EO2 VARCHAR2(26 BYTE) No No Active "MS Access: Description: No description. MS Access caption: No caption." EO3 VARCHAR2(26 BYTE) No No Active "MS Access: Description: No description. MS Access caption: No caption." EO4 VARCHAR2(26 BYTE) No No Active "MS Access: Description: No description. MS Access caption: No caption." ESTDAM NUMBER(38,0) No No Active "MS Access: Description: Estimated square feet (to nearest tenth) of damage MS Access caption: Est. sq.ft. damage:." FINALID VARCHAR2(26 BYTE) No No Active "MS Access: Description: (Final ID) 3 digit unique code of the individual who does the final data check. MS Access caption: Final ID" FISHERY VARCHAR2(26 BYTE) No No Active "MS Access: Description: S = Set; D = Drift caption: Fishery" FTRIP VARCHAR2(26 BYTE) No No Active "MS Access: Description: Full trip observed? MS Access caption: Full trip (y/n)" HABBH VARCHAR2(26 BYTE) No No Active "MS Access: Description: Code for substrate type at beginning of haul MS Access caption: Habitat." HABBS VARCHAR2(26 BYTE) No No Active "MS Access: Description: Code for substrate type for soak MS Access caption: Habitat." LATBH VARCHAR2(26 BYTE) No No Active "MS Access: Description: Latitude of begin haul MS Access caption: Latitude." LATBS VARCHAR2(26 BYTE) No No Active "MS Access: Description: Latitude of begin soak. MS Access caption: Latitude" LBREFNO VARCHAR2(26 BYTE) No No Active "MS Access: Description: Comments in logbook #. MS Access caption: Log book #." LBREFPG VARCHAR2(26 BYTE) No No Active "MS Access: Description: Comments on page number (?) of logbook. MS Access caption: page #." LDR NUMBER(38,0) No No Active "MS Access: Description: Set nets only. Web lead used? (zero is default if none present) MS Access caption: If leader, length (fath.)" LONGBH VARCHAR2(26 BYTE) No No Active "MS Access: Description: Longitude of begin haul MS Access caption: Longitude." LONGBS VARCHAR2(26 BYTE) No No Active "MS Access: Description: Longitude of begin soak. MS Access caption: Longitude" MSIZE NUMBER(38,14) No No Active "MS Access: Description: Stretch mesh size in inches MS Access caption: Mesh size (inches)" NETD NUMBER(38,0) No No Active "MS Access: Description: Hung depth of the net, in meshes. MS Access caption: Net depth (meshes)" NETL NUMBER(38,0) No No Active "MS Access: Description: Length of fished net as first set, in fathoms MS Access caption: Net length (fath.)" NETNO VARCHAR2(26 BYTE) No No Active "MS Access: Description: For set nets only. Position of set net observed based on grid layout. MS Access caption: Net ID (if >1 net/permit)" NONETS NUMBER(38,0) No No Active "MS Access: Description: Total number of nets being fished by same permit at time of observation MS Access caption: # of nets fished" NUMNN NUMBER(38,0) No No Active "MS Access: Description: Approx. number of fishing nets within 800m. MS Access caption: # nets<800m" OBSERVATION_DATE DATE No No Active "MS Access: Description: Date observation of set began MS Access caption: Date (mm/dd/yy)" OBSID VARCHAR2(26 BYTE) No No Active "MS Access: Description: (Obs. Code) 3 digit unique observer ID code MS Access caption: Obs. code" OFFID VARCHAR2(26 BYTE) No No Active "MS Access: Description: (Check ID) 3 digit unique code of office person who reviewed data. MS Access caption: Office Edit" ORIENT VARCHAR2(26 BYTE) No No Active "MS Access: Description: Orientation codes of net during set. MS Access caption: Orientation" OVRLP VARCHAR2(26 BYTE) No No Active "MS Access: Description: Mainly for set nets. Any overlap between nearest nets? MS Access caption: Overlap (y/n)" PERMIN VARCHAR2(26 BYTE) No No Active "MS Access: Description: Percent code of least amount of net fished during set. MS Access caption: min % of net fished:." PERMITID VARCHAR2(26 BYTE) No No Active "MS Access: Description: CFEC permit (set) or ADFG vessel (drift) number and check digit. MS Access caption: Permit #" PERTG VARCHAR2(26 BYTE) No No Active "MS Access: Description: Code for % time gear was tended. MS Access caption: % time tended gear:." PERWN VARCHAR2(26 BYTE) No No Active "MS Access: Description: Percent code best reflecting total time whole net fished. MS Access caption: % time whole net fished:." PHET1 VARCHAR2(26 BYTE) No No Active "MS Access: Description: No description. MS Access caption: No caption." PHET2 VARCHAR2(26 BYTE) No No Active "MS Access: Description: No description. MS Access caption: No caption." PHET3 VARCHAR2(26 BYTE) No No Active "MS Access: Description: No description. MS Access caption: No caption." PHET4 VARCHAR2(26 BYTE) No No Active "MS Access: Description: No description. MS Access caption: No caption." PHST1 VARCHAR2(26 BYTE) No No Active "MS Access: Description: If partial haul, time started. MS Access caption: No caption." PHST2 VARCHAR2(26 BYTE) No No Active "MS Access: Description: No description. MS Access caption: No caption." PHST3 VARCHAR2(26 BYTE) No No Active "MS Access: Description: No description. MS Access caption: No caption." PHST4 VARCHAR2(26 BYTE) No No Active "MS Access: Description: No description. MS Access caption: No caption." PLATFORM VARCHAR2(26 BYTE) No No Active "MS Access: Description: Platform from which observations were made MS Access caption: Platform code(s)" PRIMKEY NUMBER(38,0) No No Active No MS Access metadata. PROLL VARCHAR2(26 BYTE) No No Active "MS Access: Description: Roll number of photographs. MS Access caption: Roll #." PSHOT1 NUMBER(38,0) No No Active "MS Access: Description: Beginning frame number. MS Access caption: Frames #." PSHOT2 NUMBER(38,0) No No Active "MS Access: Description: Ending frame number. MS Access caption: to." PULLG VARCHAR2(26 BYTE) No No Active "MS Access: Description: Did fisherman pull the net to keep it taut? MS Access caption: Pulled gear? (y/n)." RELNETIN VARCHAR2(26 BYTE) No No Active "MS Access: Description: No description. MS Access caption: Inside" RELNETOUT VARCHAR2(26 BYTE) No No Active "MS Access: Description: No description. MS Access caption: Outside" RUNG VARCHAR2(26 BYTE) No No Active "MS Access: Description: Did skipper run gear? MS Access caption: Run Gear (y/n/u)." SEABH NUMBER(38,0) No No Active "MS Access: Description: Sea state code at begining of haul MS Access caption: No caption." SEABS NUMBER(38,0) No No Active "MS Access: Description: Sea state code during soak. MS Access caption: Sea state." SETNO NUMBER(38,0) No No Active "MS Access: Description: Sequential number of set observed per day by observer MS Access caption: Observed set" SO1 VARCHAR2(26 BYTE) No No Active "MS Access: Description: Time when first begin observing. MS Access caption: Start obs." SO2 VARCHAR2(26 BYTE) No No Active "MS Access: Description: No description. MS Access caption: No caption." SO3 VARCHAR2(26 BYTE) No No Active "MS Access: Description: No description. MS Access caption: No caption." SO4 VARCHAR2(26 BYTE) No No Active "MS Access: Description: No description. MS Access caption: No caption." STABH VARCHAR2(26 BYTE) No No Active "MS Access: Description: Tide stage code at begin of haul MS Access caption: Stage." STABS VARCHAR2(26 BYTE) No No Active "MS Access: Description: Tide stage code at begin of soak. MS Access caption: Stage" TIDEBH VARCHAR2(26 BYTE) No No Active "MS Access: Description: Tide code at beginning of haul MS Access caption: Tide." TIDEBS VARCHAR2(26 BYTE) No No Active "MS Access: Description: Tide code at beginning of soak. MS Access caption: Tide" TIMEBH VARCHAR2(26 BYTE) No No Active "MS Access: Description: Time beginning set retrieval or pick. MS Access 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). MS Access caption: Begin (set/last haul)." TIMEEH VARCHAR2(26 BYTE) No No Active "MS Access: Description: Time set retrieval ends. MS Access caption: End haul." TIMEES VARCHAR2(26 BYTE) No No Active "MS Access: Description: Time ofdrift/set net begin soak. MS Access caption: Begin/soak." VISBH VARCHAR2(26 BYTE) No No Active "MS Access: Description: Visibility code for conditions during haul. MS Access caption: No caption." VISBS VARCHAR2(26 BYTE) No No Active "MS Access: Description: Visibility code for conditions during soak. MS Access caption: Visibility." VPNAME VARCHAR2(26 BYTE) No No Active "MS Access: Description: Vessel name (drift) or permit holder name (set; last, first, mi) MS Access caption: Vessel/permit name" WEABH VARCHAR2(26 BYTE) No No Active "MS Access: Description: Weather code for conditions during haul. MS Access caption: No caption." WEABS VARCHAR2(26 BYTE) No No Active "MS Access: Description: Weather code for conditions during soak. MS Access caption: Weather." WLINE NUMBER(38,0) No No Active "MS Access: Description: If a weedline is present, how long is the drop? (zero is default if none present) MS Access caption: If weedline (inch)" WNFISH VARCHAR2(26 BYTE) No No Active "MS Access: Description: Did entire length and depth of net fish entire set? MS Access 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 MS Access caption: ZoneH." ZONEBS VARCHAR2(26 BYTE) No No Active "MS Access: Description: Code for land form during soak. MS Access caption: Zone." gov.noaa.nmfs.inport:75104 Rachel Wuest 2025-03-05T19:17:33 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