33509 HYDRO_EVENT Entity Published / External 25147 Oceanography Branch Hydrographic Database Data Set Completed The Hydrographic event table. Each cast/station covered on a cruise is considered an event. Loaded by batch 9028, 07-18-2016 21:14 Data Table Yes OCDBS The Hydrographic event table. Each cast/station covered on a cruise is considered an event. 1 CRUISE_ID VARCHAR2 9 Yes Yes Active Cruise name used to identify the survey or cruise (and as listed in /ftp/pub/hydro). VARCHAR2 2 GEAR_TYPE VARCHAR2 15 Yes Yes Active The type of CTD used on the cast, or "bottle" if hydrographic stations were completed using Niskin bottles for discrete depth sampling. VARCHAR2 3 CAST VARCHAR2 4 Yes Yes Active The consecutive cast number completed on the cruise. VARCHAR2 4 GEAR_SN VARCHAR2 6 No No Active The serial number of the instrument (typically the CTD). VARCHAR2 5 OP_CODE VARCHAR2 1 No No Active The operation code for the station, typicall V,B or W representing a Vertical profile, a CTD deployed with a bongo net attached below, or a Water cast to collect a calibration sample for the CTD conductivity sensor. VARCHAR2 6 LAT_DD NUMBER 22 Yes No 6 4 Active The latitude of the station express as decimal degrees so that 40 degrees north, 30 minutes = 40.5 NUMBER 7 LON_DD NUMBER 22 Yes No 6 4 Active The longitude of the station expressed as decimal degrees so that 70 degrees, 30 minutes = 70.5 NUMBER 8 GMT_DATE DATE 7 Yes No Active The cast date using the Greenwich mean time. DATE 9 GMT_TIME NUMBER 22 No No 4 2 Active The GMT time with minutes expressed as decimal hours. NUMBER 10 GMT_YDAY1 NUMBER 22 No No 7 4 Active The calendar year day using GMT_DATE and GMT_TIME. The time is expressed as a decimal day. The conventions is that January 1st, 12:00 noon = 1.5 NUMBER 11 STA_BTM_DEPTH NUMBER 22 No No 4 0 Active The bottom depth where the hydrographic data was collected for a given station. NUMBER 12 STA VARCHAR2 4 No No Active The consecutive station occupied on the cruise. VARCHAR2 13 STA_STD VARCHAR2 4 No No Active The standard station occupied on the cruise; typically applicable to MARMAP and GLOBEC cruises. VARCHAR2 14 VESSEL_NUM VARCHAR2 3 No No Active The consecutive cruise number for each ship by either calendar year (typical of NOAA vessels) or for the life of the ship (typical of UNOLS vessels). VARCHAR2 15 DOE DATE 7 No No Active The date of the last entry DATE 16 DOC DATE 7 No No Active The date of the last change to the table DATE 17 UOE VARCHAR2 8 No No Active Who made the last entry (identified by oracle username). VARCHAR2 18 UOC VARCHAR2 8 No No Active Who made the last change to the table (identified by their oracle username). VARCHAR2 19 SITE_ID NUMBER 22 No No 10 0 Active Introduced with FSCS2.0, it is the pre-planned location of standard bottom trawl survey operations (defined as a three nautical mile circle around the pre-planned location where a bottom trawl will be towed. All operations performed within the site are tied back to the site_id. NUMBER gov.noaa.nmfs.inport:33509 Patricia Jones 2016-07-18T21:14:15 SysAdmin InPortAdmin 2022-08-09T17:11:16 2016-07-27 Northeast Fisheries Science Center NEFSC 166 Water Street Woods Hole MA 02543-1026 USA (508)495-2000 https://www.nefsc.noaa.gov 8:00 a.m. to 4:30 p.m. Monday - Friday 1001 Public No 2016-07-27 1 Year 2017-07-27