25147 Hydrographic Database (OCDBS) Data Set Published / External 9283 Conductivity/Temperature/Depth Project Completed The Oceanography group maintains and provides Conductivity/Temperature/Depth (CTD) instruments to all Center cruises for measuring water column profiles of temperature and salinity. Generally, over 1000 profiles are collected each year on the northeast continental shelf from Cape Hatteras to the Gulf of Maine. Profiles are collected at every station on the Center's bottom trawl surveys and at every station on the Center's Ecosystem Monitoring surveys. The database also contains historical hydrographic data from earlier programs, which used other methods to measure temperature and salinity. To provide hydrographic measurements made by the NEFSC to support research, assessment, and management activities in the Northeast U.S. Shelf Ecosystem. Theme Conductivity Theme Depth Theme Temperature Theme climate Theme hydrography Theme oceanography Theme salinity Theme water column Temporal 1977-present Spatial Gulf of Maine Spatial Middle Atlantic Bight Spatial Northeast U.S. Continental Shelf Northeast Fisheries Science Center Woods Hole MA USA Data Set Oracle Database Monthly Table (digital) Conductivity Temperature Depth (CTD) Instruments, models: Neil Brown Instrument Systems Mark V and Mark III; SeaBird Electronics (SBE) SBE-17, SBE-911+, SBE-19, SBE-19+, SBE-19+V2; General Oceanics Niskin Sampling Bottles (1.7L and 10L); Expendable Bathythermograph (XBT) Conducting wire, Rosette frame with Carousel water sampling system (SBE32) Not applicable 33507 HYDRO_CRUISE Published / External Completed Table that contains cruises that collected hydrographic data. The linking field is cruise_id to the next level; hydro_event. Loaded by batch 9028, 07-18-2016 21:14 Data Table Yes OCDBS Table that contains cruises that collected hydrographic data. The linking field is cruise_id to the next level; hydro_event. 1 CRUISE_ID VARCHAR2 9 Yes No Active Cruise name used to identify the survey or cruise (and as listed in /ftp/pub/hydro). VARCHAR2 2 GEAR_DESC VARCHAR2 30 Yes No Active Brief description of the instrument type used to collect hydrographic data on the cruise: bottle, XBT, SBE-19, SBE-911+, MK-5, MK-3 (various CTD types). VARCHAR2 3 VESSEL VARCHAR2 4 No No Active The 2-character abbreviation of the vessel used for each cruise. The look up table for the abbreviations is called sv_vessel and is located on SOLE. VARCHAR2 4 YEAR VARCHAR2 4 Yes No Active The year in which the cruise took place. VARCHAR2 5 START_DATE DATE 7 No No Active The start date for the first cast/station on the cruise. DATE 6 END_DATE DATE 7 No No Active The date of the last cast for which there are data on a cruise DATE 7 OPSID VARCHAR2 11 Yes Yes Active The linking field for the master cruise table used Center-wide. VARCHAR2 8 DOE DATE 7 No No Active The date of the last entry DATE 9 DOC DATE 7 No No Active The date of the last change to the table DATE 10 UOE VARCHAR2 8 No No Active Who made the last entry (identified by oracle username). VARCHAR2 11 UOC VARCHAR2 8 No No Active Who made the last change to the table (identified by their oracle username). VARCHAR2 12 PURPOSE_CODE NUMBER 22 Yes Yes 4 0 Active The purpose of the cruise indicated by a 2-digit code for which there is a look-up table maintained by DMS. NUMBER 33508 HYDRO_DATA Published / External Completed The hydrographic data table. The primary key is: cruise_id, gear_type, cast number, pressure. Loaded by batch 9028, 07-18-2016 21:14 Data Table Yes OCDBS The hydrographic data table. The primary key is: cruise_id, gear_type, cast number, pressure. 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 OCDBS.HYDRO_EVENT 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 OCDBS.HYDRO_EVENT 3 CAST VARCHAR2 4 Yes Yes Active The consecutive cast number completed on the cruise. VARCHAR2 OCDBS.HYDRO_EVENT 4 PRES NUMBER 22 Yes Yes 5 1 Active The pressure level of the CTD. Note: if the gear type is "XBT" or "bottle", this field is actually DEPTH. However, the difference is minor in continental shelf work so it was decided that we would stick to one variable name; pressure with units decibars. See Oceanography Branch staff for a derivation of pressure to meters if this is more desireable. NUMBER 5 TEMP NUMBER 22 No No 4 2 Active The temperature of the water at a given pressure (units are degrees celcius). NUMBER 6 SALT NUMBER 22 No No 5 3 Active The salinity of the water at a given pressure. Units are psu (practical salinity units). NUMBER 7 FLUOR NUMBER 22 No No 4 3 Active The voltage from the fluorometer typically installed as an external sensor on the CTD (units are volts). NUMBER 8 TRANS NUMBER 22 No No 3 2 Active The light transmission, expressed in volts, from a transmissometer typically attached as an external sensor on the CTD. NUMBER 9 PAR NUMBER 22 No No 3 2 Active The Photosynthetically Active Radiation from a PAR sensor typically installed as an external sensor on the CTD (units are volts). NUMBER 10 PHOSPHATE NUMBER 22 No No 3 2 Active The phosphate concentration of the water sample and the units are micro molar per liter. NUMBER 11 NITRATE NUMBER 22 No No 3 1 Active The nitrate concentration of the water sample, units are micro molar per liter. NUMBER 12 SILICATE NUMBER 22 No No 3 1 Active The silicate concentration of the water sample with units mico molar per liter. NUMBER 13 CHLOROPHYLL NUMBER 22 No No 4 2 Active The chlorophyll concentration of the water sample in micrograms per liter. NUMBER 14 DOX NUMBER 22 No No 4 2 Active Dissolved oxygen concentration of the water sample (ml/l) derived at sea prior to 1990. NUMBER 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 CHL_FL NUMBER 22 No No 4 2 Active Derived chlorophyll concentration (mg/m3) from fluorometer sensor integrated with SBE-911+ CTD package NUMBER 20 PAR_SENSOR NUMBER 22 No No 4 0 Active Photosynthetically active radiation data from PAR sensor integrated with SBE-911+ CTD package, units are MicroEinsteins / (m2)(s)) NUMBER 21 O2 NUMBER 22 No No 4 1 Active Oxygen data (mg/l) collect with an SBE-43 dissolved oxygen sensor integrated with SBE-911+ CTD package NUMBER 33509 HYDRO_EVENT Published / External 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 Data Steward 2025 Person Melrose, Christopher chris.melrose@noaa.gov 28 Tarzwell Drive Narragansett RI 02882 Data Steward 2010 2025 Person Fratantoni, Paula Paula.Fratantoni@noaa.gov 166 Water Street Woods Hole MA 02543-1026 USA 508-495-2306 508-495-2258 Distributor 2000 Organization Northeast Fisheries Science Center NEFSC https://ror.org/02nc0ck44 166 Water Street Woods Hole MA 02543-1026 USA (508)495-2000 https://www.fisheries.noaa.gov/about/northeast-fisheries-science-center NEFSC Home Page Online Resource 8:00 a.m. to 4:30 p.m. Monday - Friday Metadata Contact 2025 Person Melrose, Christopher chris.melrose@noaa.gov 28 Tarzwell Drive Narragansett RI 02882 Metadata Contact 2015 2025 Person Fratantoni, Paula Paula.Fratantoni@noaa.gov 166 Water Street Woods Hole MA 02543-1026 USA 508-495-2306 508-495-2258 Originator 1999 Person Taylor, Maureen maureen.taylor@noaa.gov 166 Water Street Woods Hole MA 02543-1026 USA 508-495-2299 508-495-2258 Point of Contact 2025 Person Melrose, Christopher chris.melrose@noaa.gov 28 Tarzwell Drive Narragansett RI 02882 Point of Contact 2010 2025 Person Fratantoni, Paula Paula.Fratantoni@noaa.gov 166 Water Street Woods Hole MA 02543-1026 USA 508-495-2306 508-495-2258 -76 -65 44.5 34 Continuing 1977-07-31 Earliest event date in database Unclassified Data are publicly available. Questions should be directed to Paula Fratantoni (paula.fratantoni@noaa.gov) NEFSC Data Access Procedure: 1. Formal request in writing usually to the data owner/contact or Center Director; 2. Requester is contacted by data owner to review and verify the request content and details for data delivery options. 3. If data is confidential then owner will determine if the data may be released to the requester; 4. If data can be released, the data is downloaded and packaged for delivery electronically; or the requester may be directed to where the data is available online. NEFSC Data Access Constraint: If data is stored on an internal NEFSC network, the requester may not have direct access to query the data unless they are also authorized for network access. none ftp://ftp.nefsc.noaa.gov/pub/hydro/matlab_files/ Matlab File Output. Data is also available from NODC. ftp://ftp.nefsc.noaa.gov/pub/hydro/nodc_files/ NODC File Output ftp://ftp.nefsc.noaa.gov/pub/hydro Online Resource HTML Webpage with ftp access to NODC-formatted profile data, yearly matlab-formatted data files; cruise reports; Oracle 10g nova database Described in document http://www.nefsc.noaa.gov/epd/oceanography/processing.html Described in document http://www.nefsc.noaa.gov/epd/oceanography/processing.html Data validation during data collection, post audits by internal editors, data validation prior to database loads, Database integrity constraints, Follow up with survey participants Yes Unknown Yes No 2 months Other Long-term archiving < 10 months; Local archiving 2 months Archival of source data preserving unaltered collected data, Scheduled backups, Remote storage backups, Password protection http://www.nefsc.noaa.gov/epd/oceanography/processing.html 33507 Entity 33508 Entity 33509 Entity gov.noaa.nmfs.inport:25147 Patricia Jones 2015-05-27T14:21:51 SysAdmin InPortAdmin 2026-03-04T19:17:17 2016-07-18 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 No 2016-07-18 1 Year 2017-07-18