Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Ecosystems & Aquaculture Division (EAD) > Oceans & Climate Branch (OCB) > Conductivity/Temperature/Depth > Oceanography Branch Hydrographic Database >

Table: HYDRO_DATA

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:33508  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

The hydrographic data table. The primary key is: cruise_id, gear_type, cast number, pressure.

Description

The hydrographic data table. The primary key is: cruise_id, gear_type, cast number, pressure.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
CRUISE_ID
VARCHAR2 		Cruise name used to identify the survey or cruise (and as listed in /ftp/pub/hydro).
GEAR_TYPE
VARCHAR2 		The type of CTD used on the cast, or "bottle" if hydrographic stations were completed using Niskin bottles for discrete depth sampling.
CAST
VARCHAR2 		The consecutive cast number completed on the cruise.
PRES
NUMBER 		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.
TEMP
NUMBER 		The temperature of the water at a given pressure (units are degrees celcius).
SALT
NUMBER 		The salinity of the water at a given pressure. Units are psu (practical salinity units).
FLUOR
NUMBER 		The voltage from the fluorometer typically installed as an external sensor on the CTD (units are volts).
TRANS
NUMBER 		The light transmission, expressed in volts, from a transmissometer typically attached as an external sensor on the CTD.
PAR
NUMBER 		The Photosynthetically Active Radiation from a PAR sensor typically installed as an external sensor on the CTD (units are volts).
PHOSPHATE
NUMBER 		The phosphate concentration of the water sample and the units are micro molar per liter.
NITRATE
NUMBER 		The nitrate concentration of the water sample, units are micro molar per liter.
SILICATE
NUMBER 		The silicate concentration of the water sample with units mico molar per liter.
CHLOROPHYLL
NUMBER 		The chlorophyll concentration of the water sample in micrograms per liter.
DOX
NUMBER 		Dissolved oxygen concentration of the water sample (ml/l) derived at sea prior to 1990.
DOE
DATE 		The date of the last entry
DOC
DATE 		The date of the last change to the table
UOE
VARCHAR2 		Who made the last entry (identified by oracle username).
UOC
VARCHAR2 		Who made the last change to the table (identified by their oracle username).
CHL_FL
NUMBER 		Derived chlorophyll concentration (mg/m3) from fluorometer sensor integrated with SBE-911+ CTD package
PAR_SENSOR
NUMBER 		Photosynthetically active radiation data from PAR sensor integrated with SBE-911+ CTD package, units are MicroEinsteins / (m2)(s))
O2
NUMBER 		Oxygen data (mg/l) collect with an SBE-43 dissolved oxygen sensor integrated with SBE-911+ CTD package

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NEFSC) for inquiries on this record.

Item Identification

Title: Table: HYDRO_DATA
Short Name: HYDRO_DATA
Status: Completed
Abstract:

The hydrographic data table. The primary key is: cruise_id, gear_type, cast number, pressure.
Notes:

Loaded by batch 9028, 07-18-2016 21:14

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: OCDBS
Description:

The hydrographic data table. The primary key is: cruise_id, gear_type, cast number, pressure.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key CRUISE_ID VARCHAR2 Cruise name used to identify the survey or cruise (and as listed in /ftp/pub/hydro).
100
 Primary Key GEAR_TYPE VARCHAR2 The type of CTD used on the cast, or "bottle" if hydrographic stations were completed using Niskin bottles for discrete depth sampling.
100
 Primary Key CAST VARCHAR2 The consecutive cast number completed on the cruise.
100
 Primary Key PRES NUMBER 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.
100
 TEMP NUMBER The temperature of the water at a given pressure (units are degrees celcius).
100
 SALT NUMBER The salinity of the water at a given pressure. Units are psu (practical salinity units).
100
 FLUOR NUMBER The voltage from the fluorometer typically installed as an external sensor on the CTD (units are volts).
100
 TRANS NUMBER The light transmission, expressed in volts, from a transmissometer typically attached as an external sensor on the CTD.
100
 PAR NUMBER The Photosynthetically Active Radiation from a PAR sensor typically installed as an external sensor on the CTD (units are volts).
100
 PHOSPHATE NUMBER The phosphate concentration of the water sample and the units are micro molar per liter.
100
 NITRATE NUMBER The nitrate concentration of the water sample, units are micro molar per liter.
100
 SILICATE NUMBER The silicate concentration of the water sample with units mico molar per liter.
100
 CHLOROPHYLL NUMBER The chlorophyll concentration of the water sample in micrograms per liter.
100
 DOX NUMBER Dissolved oxygen concentration of the water sample (ml/l) derived at sea prior to 1990.
100
 DOE DATE The date of the last entry
100
 DOC DATE The date of the last change to the table
100
 UOE VARCHAR2 Who made the last entry (identified by oracle username).
100
 UOC VARCHAR2 Who made the last change to the table (identified by their oracle username).
100
 CHL_FL NUMBER Derived chlorophyll concentration (mg/m3) from fluorometer sensor integrated with SBE-911+ CTD package
100
 PAR_SENSOR NUMBER Photosynthetically active radiation data from PAR sensor integrated with SBE-911+ CTD package, units are MicroEinsteins / (m2)(s))
100
 O2 NUMBER Oxygen data (mg/l) collect with an SBE-43 dissolved oxygen sensor integrated with SBE-911+ CTD package

Attribute Details

CRUISE_ID

CC ID: 332885
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 9
Required: Yes
Primary Key: Yes
Status: Active
Description:

Cruise name used to identify the survey or cruise (and as listed in /ftp/pub/hydro).
General Data Type: VARCHAR2
Foreign Key Relations:

OCDBS.HYDRO_EVENT

GEAR_TYPE

CC ID: 332886
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 15
Required: Yes
Primary Key: Yes
Status: Active
Description:

The type of CTD used on the cast, or "bottle" if hydrographic stations were completed using Niskin bottles for discrete depth sampling.
General Data Type: VARCHAR2
Foreign Key Relations:

OCDBS.HYDRO_EVENT

CAST

CC ID: 332887
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 4
Required: Yes
Primary Key: Yes
Status: Active
Description:

The consecutive cast number completed on the cruise.
General Data Type: VARCHAR2
Foreign Key Relations:

OCDBS.HYDRO_EVENT

PRES

CC ID: 332900
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 5
Scale: 1
Status: Active
Description:

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.
General Data Type: NUMBER

TEMP

CC ID: 332901
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 2
Status: Active
Description:

The temperature of the water at a given pressure (units are degrees celcius).
General Data Type: NUMBER

SALT

CC ID: 332902
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 3
Status: Active
Description:

The salinity of the water at a given pressure. Units are psu (practical salinity units).
General Data Type: NUMBER

FLUOR

CC ID: 332903
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 3
Status: Active
Description:

The voltage from the fluorometer typically installed as an external sensor on the CTD (units are volts).
General Data Type: NUMBER

TRANS

CC ID: 332904
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 2
Status: Active
Description:

The light transmission, expressed in volts, from a transmissometer typically attached as an external sensor on the CTD.
General Data Type: NUMBER

PAR

CC ID: 332905
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 2
Status: Active
Description:

The Photosynthetically Active Radiation from a PAR sensor typically installed as an external sensor on the CTD (units are volts).
General Data Type: NUMBER

PHOSPHATE

CC ID: 332888
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 2
Status: Active
Description:

The phosphate concentration of the water sample and the units are micro molar per liter.
General Data Type: NUMBER

NITRATE

CC ID: 332889
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 1
Status: Active
Description:

The nitrate concentration of the water sample, units are micro molar per liter.
General Data Type: NUMBER

SILICATE

CC ID: 332890
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 1
Status: Active
Description:

The silicate concentration of the water sample with units mico molar per liter.
General Data Type: NUMBER

CHLOROPHYLL

CC ID: 332891
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 2
Status: Active
Description:

The chlorophyll concentration of the water sample in micrograms per liter.
General Data Type: NUMBER

DOX

CC ID: 332892
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 2
Status: Active
Description:

Dissolved oxygen concentration of the water sample (ml/l) derived at sea prior to 1990.
General Data Type: NUMBER

DOE

CC ID: 332893
Seq. Order: 15
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

The date of the last entry
General Data Type: DATE

DOC

CC ID: 332894
Seq. Order: 16
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

The date of the last change to the table
General Data Type: DATE

UOE

CC ID: 332895
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Who made the last entry (identified by oracle username).
General Data Type: VARCHAR2

UOC

CC ID: 332896
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Who made the last change to the table (identified by their oracle username).
General Data Type: VARCHAR2

CHL_FL

CC ID: 332897
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 2
Status: Active
Description:

Derived chlorophyll concentration (mg/m3) from fluorometer sensor integrated with SBE-911+ CTD package
General Data Type: NUMBER

PAR_SENSOR

CC ID: 332898
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Photosynthetically active radiation data from PAR sensor integrated with SBE-911+ CTD package, units are MicroEinsteins / (m2)(s))
General Data Type: NUMBER

O2

CC ID: 332899
Seq. Order: 21
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 1
Status: Active
Description:

Oxygen data (mg/l) collect with an SBE-43 dissolved oxygen sensor integrated with SBE-911+ CTD package
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 33508
GUID: gov.noaa.nmfs.inport:33508
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-07-18 21:14+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-07-27
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-07-27
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-07-27