2.0 STRUCTURE OF THE AOCI DATA BASE 2.1 FISHERIES DATA FORMATS 2.1.1 SPORT FISHING VESSELS ASCII Files: SFJUN90.DAT, SFJUL90.DAT, and SFJUL91.DAT. COLUMN FIELD DESCRIPTION FORMAT _______________________________________________________________ 01-02 Year I2 03-04 Month I2 05-06 Day I2 07-08 Wind Direction (x 10 Degrees) I2 09-10 Wind Speed (Knots) I2 11-12 Wave Height (Feet) I2 13-13 Weather Conditions: I1 0 = Clear : : : : : : : : : : : : 9 = Heavily Overcast 14-19 Vessel Name Code (I.E., SFV001-SFV130) A6 20-23 Start Time (CDT) I4 Total Fishing Time: 24-25 Hours I2 26-27 Minutes I2 28-30 Fish Species Code: I3 100 = swordfish, Xiphias gladius 101 = sailfish, Istiophorus platypterus 201 = blue marlin, Makaira nigricans 301 = white marlin, Tetrapturus albidus 303 = longbill spearfish, Tetrapturus pfluegeri 402 = yellowfin tuna, Thunnus albacares 405 = bluefin tuna, Thunnus thynnus 501 = Spanish mackerel, Scomberomorus maculatus 601 = king mackerel, Scomberomorus cavalla 701 = wahoo, Acanthocybium solandri 909 = unidentified billfish 31-34 Time Fish Was Hooked (CDT) I4 35-38 Time Fish was Boated, Released, Or Lost (CDT) I4 Area(s) Fished: 39-40 Latitude (Degrees) I2 41-42 Latitude (Minutes) I2 43-44 Longitude (Degrees) I2 45-46 Longitude (Minutes) I2 47-48 Latitude (Degrees) I2 49-50 Latitude (Minutes) I2 51-52 Longitude (Degrees) I2 53-54 Longitude (Minutes) I2 55-56 Latitude (Degrees) I2 57-58 Latitude (Minutes) I2 59-60 Longitude (Degrees) I2 2.1.1 SPORT FISHING VESSELS, continued: 61-62 Longitude (Minutes) I2 63-64 Latitude (Degrees) I2 65-66 Latitude (Minutes) I2 67-68 Longitude (Degrees) I2 69-70 Longitude (Minutes) I2 71-82 Location Fished (1) A12 (1) a few of the fishermen (a total of 19 data records) reported fishing in Green Canyon during the Tournament held on July 26-28, 1990, but did not record the specific locations of the catches. 2.1.2 MENHADEN SPOTTER AIRCRAFT ASCII Files: SAMAY89.DAT, SASEP89.DAT, SAJUN90.DAT, SAJUL90.DAT, and SAJUN91.DAT. COLUMN FIELD DESCRIPTION FORMAT _________________________________________________________________ 01-04 Pilot identification code A4 05-08 Year I4 09-10 Month I2 11-12 Day I2 13-17 Observation number I5 18-21 Time of observation (CDT) I4 22-23 Latitude, degrees I2 24-27 Latitude, minutes and decimal minutes F4.2 28-29 Longitude, degrees I2 30-33 Longitude, minutes and decimal minutes F4.2 34 Species (2) A1 "Y" = Menhaden Number of fish schools observed (3) 35 Minimum I2 37 Maximum I2 (2) other species were occasionally sighted by the spotter pilots but were not included in the data set. (3) the number of menhaden schools was reported as a range, e.g., "5-7 schools", or as an integer number, e.g., "10 schools". The records containing ranges have values recorded in the "minimum" and "maximum" fields; those reported as integer numbers only are recorded in the "maximum" field. 2.1.3 MENHADEN FISHING VESSELS ASCII Files: FVMAY89.DAT, FVSEP89.DAT, FVJUN90.DAT, and FVJUL90.DAT. COLUMN FIELD DESCRIPTION FORMAT _________________________________________________________________ 01-04 Platform code A4 05-08 Year I4 09-10 Month I2 11-12 Day I2 13-17 Observation number I5 18-21 Time of observation (CDT) I4 22-23 Latitude, degrees I2 24-27 Latitude, minutes and decimal minutes F4.2 28-29 Longitude, degrees I2 30-33 Longitude, minutes and decimal minutes F4.2 34 Species: A1 "Y"=Menhaden "N"=Other 35-37 Fish catch in thousands of fish I3 2.1.4 MENHADEN FISHING VESSELS WITH OBSERVERS 2.2 ENVIRONMENTAL DATA 2.2.1 MENHADEN FISHING VESSELS WITH OBSERVERS ASCII Files: FOSEP89.DAT, FOJUN90.DAT and FOJUL90.DAT. COLUMN FIELD DESCRIPTION FORMAT _________________________________________________________________ 01-03 Cruise identification code A3 04-07 Platform code A4 08-12 Observation number I5 13-17 Salinity sample number I5 18-22 Chlorophyll sample number I5 23-26 Year I4 27-28 Month I2 29-30 Day I2 31-34 Time of observation(CDT) I4 35-36 Latitude, degrees I2 37-40 Latitude, minutes and decimal minutes F4.2 41-42 Longitude, degrees I2 43-46 Longitude, minutes and decimal minutes F4.2 47-50 Surface water temperature (degrees C) F4.1 51-53 Secchi Depth (ft) I3 54-55 Forel-ule number I2 56-59 Water Depth (ft) I4 60-66 Surface chlorophyll (mg/cu. meter) F7.4 67-72 Surface salinity (ppt) F6.3 73 Species: A1 "Y"=Menhaden "N"=Other 74-76 Fish catch in thousands of fish I3 77-116 Comments 1 A40 117-156 Comments 2 A40 2.2 ENVIRONMENTAL DATA, continued: 2.2.1 CHARTER BOATS ASCII Files: CBMAY89.DAT, CBSEP89.DAT, CBJUN90.DAT and CBJUL90.DAT. COLUMN FIELD DESCRIPTION FORMAT _________________________________________________________________ 01-03 Cruise identification code A3 04-07 Platform code A4 08-12 Observation number I5 13-17 Salinity sample number I5 18-22 Chlorophyll sample number I5 23-26 Year I4 27-28 Month I2 29-30 Day I2 31-34 Time of observation(CDT) I4 35-36 Latitude, degrees I2 37-40 Latitude, minutes and decimal minutes F4.2 41-42 Longitude, degrees I2 43-46 Longitude, minutes and decimal minutes F4.2 47-50 Surface water temperature (degrees C) F4.1 51-53 Secchi Depth (ft) I3 54-55 Forel-ule number I2 56-59 Water Depth (ft) I4 60-66 Surface chlorophyll (mg/cu. meter) F7.4 67-72 Surface salinity (ppt) F6.3 73-112 Comments 1 A40 113-152 Comments 2 A40 2.2.3 RESEARCH VESSELS 2.2.3.1 R.V. OREGON II ASCII Files: ORAUG88.DAT, ORSEP89.DAT, and ORJUN90.DAT. Card One: Environmental Data File COLUMN FIELD DESCRIPTION FORMAT _________________________________________________________________ 01-01 "1" C 02-03 Vessel code I2 04-08 Station number I5 09-11 Cruise number I3 12-17 Date, MMDDYY I6 18-21 Start time, Military, HHMM I4 22-22 Time zone code I1 23-23 Latitude hemisphere code A1 (1=North or "N"=North) 24-29 Latitude DDMMMM,2 implied decimals I6 30-30 Longitude Hemisphere code A1 (1=West or "W"=West) 31-37 Longitude DDMMMM,2 implied decimals I7 38-40 Gear size I3 41-42 Gear type code I2 43-44 Wind speed, KM/HR I2 45-47 Wind direction, compass degrees I3 48-49 Wave height, M, 1 implied decimal I2 50-54 Barometric pressure,MB,1 implied dec I5 55-57 % cloud cover I3 58-60 Secchi disk reading,M,1 implied decimal I3 61-62 Water color, forel-ule scale I2 63-66 Water depth, M I4 67-70 Midwater sample depth,M I4 71-74 Maximum sample depth,M I4 75-78 Seamap station # (only if seamap CR '85+) A4 Card Two: Environmental Data File COLUMN FIELD DESCRIPTION FORMAT _________________________________________________________________ 01-01 '2' C 02-22 Duplicate of card one 23-23 XBT? (1=Y, 2=N) I1 24-24 STD or CTD? (1=Y, 2=N) I1 25-28 Surface water temperature, C,2 imp dec I4 29-32 Midwater temperature,C,2 imp decimals I4 33-36 Maximum depth water temperature,C,2 imp I4 37-41 Surface salinity,PPT,3 implied decimals I5 42-46 Midwater salinity,PPT,3 implied decimals I5 47-51 Maximum depth salinity,PPT,3 imp decimal I5 52-57 Surface chlorophyll,MG/M3,4 imp decimals I6 58-63 Midwater chlorophyll,MG/M3,4 imp decimals I6 64-69 Maximum depth chlorophyll,MG/M3,4 imp dec I6 2.2.3.1 R.V. OREGON II, continued: Card Three: Environmental Data File COLUMN FIELD DESCRIPTION FORMAT _________________________________________________________________ 01-01 '3' C 02-22 Duplicate of card one 23-25 Surface dissolved oxygen,PPM,1 imp decimal I3 26-28 Midwater disolved oxygen,PPM,1 imp decimal I3 29-31 Maximum depth disolved oxygen,PPM,1 imp dec I3 32-35 Surface turbidity,2 imp dec (% light trans) I4 36-39 Midwater turbidity,2 implied decimals I4 40-43 Maximum depth turbidity,2 imp decimals I4 44-47 Thermocline depth,M I4 2.2.3.1 R.V. GYRE ASCII file: GYJUL790.ASC Field Field Name Type Width Dec Description 1 NB Character 2 Neil Brown CTD serial no. 2 CRUISE Character 5 Gyre cruise number 3 STATION Character 12 Gyre station number 4 G_DATE Character 9 Gregorian date 5 NUM_DATE Numeric 6 Date as YYMMDD 6 TIME Numeric 4 Time of day (GMT) 7 LAT_DEG Numeric 3 Latitude (degrees) 8 LAT_MIN Numeric 6 2 Latitude (minutes) 9 LONG_DEG Numeric 4 Longitude (degrees) 10 LONG_MIN Numeric 6 2 Longitude (minutes) 11 SAM_DEPTH Numeric 6 1 Sample depth (m) 12 PT_1 Numeric 7 3 Water Temperature (øC) 13 CHLOROPHYL Numeric 8 3 Chlorophyll (micrograms/l) 14 UPT Numeric 6 2 ** Not used ** 15 SALINITY Numeric 8 3 Salinity (ppt) 16 OXYGEN Numeric 7 3 Oxygen (ml/l) 17 AMMONIA Numeric 7 3 Ammonia (ppm) 18 PHOSPHATE Numeric 7 3 Phosphate (micromoles/l) 19 SILICON Numeric 6 3 Silicon (micromoles/l) 20 NITRATE Numeric 5 2 Nitrate (micromoles/l) 21 NITRITE Numeric 5 2 Nitrite (micromoles/l) 22 UREA Numeric 5 2 Urea (micromoles/l)