Table: HYDRO_DATA
Northeast Fisheries Science Center
Entity
(ENT)
| ID: 33508
| Published / External
Created: 2016-07-18
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 25147
ID: 33508
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Table: HYDRO_DATA |
---|---|
Short Name | HYDRO_DATA |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
The hydrographic data table. The primary key is: cruise_id, gear_type, cast number, pressure. |
* Purpose | |
Notes |
Loaded by batch 9028, 07-18-2016 21:14 |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | Data Table |
---|---|
Active Version? | Y |
Alias | |
Schema Name | OCDBS |
» Description |
The hydrographic data table. The primary key is: cruise_id, gear_type, cast number, pressure. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | Yes | Yes | CRUISE_ID | VARCHAR2 | Cruise name used to identify the survey or cruise (and as listed in /ftp/pub/hydro). |
100 | Yes | Yes | 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 | Yes | Yes | CAST | VARCHAR2 | The consecutive cast number completed on the cruise. |
100 | Yes | Yes | 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 | No | No | TEMP | NUMBER | The temperature of the water at a given pressure (units are degrees celcius). |
100 | No | No | SALT | NUMBER | The salinity of the water at a given pressure. Units are psu (practical salinity units). |
100 | No | No | FLUOR | NUMBER | The voltage from the fluorometer typically installed as an external sensor on the CTD (units are volts). |
100 | No | No | TRANS | NUMBER | The light transmission, expressed in volts, from a transmissometer typically attached as an external sensor on the CTD. |
100 | No | No | PAR | NUMBER | The Photosynthetically Active Radiation from a PAR sensor typically installed as an external sensor on the CTD (units are volts). |
100 | No | No | PHOSPHATE | NUMBER | The phosphate concentration of the water sample and the units are micro molar per liter. |
100 | No | No | NITRATE | NUMBER | The nitrate concentration of the water sample, units are micro molar per liter. |
100 | No | No | SILICATE | NUMBER | The silicate concentration of the water sample with units mico molar per liter. |
100 | No | No | CHLOROPHYLL | NUMBER | The chlorophyll concentration of the water sample in micrograms per liter. |
100 | No | No | DOX | NUMBER | Dissolved oxygen concentration of the water sample (ml/l) derived at sea prior to 1990. |
100 | No | No | DOE | DATE | The date of the last entry |
100 | No | No | DOC | DATE | The date of the last change to the table |
100 | No | No | UOE | VARCHAR2 | Who made the last entry (identified by oracle username). |
100 | No | No | UOC | VARCHAR2 | Who made the last change to the table (identified by their oracle username). |
100 | No | No | CHL_FL | NUMBER | Derived chlorophyll concentration (mg/m3) from fluorometer sensor integrated with SBE-911+ CTD package |
100 | No | No | PAR_SENSOR | NUMBER | Photosynthetically active radiation data from PAR sensor integrated with SBE-911+ CTD package, units are MicroEinsteins / (m2)(s)) |
100 | No | No | O2 | NUMBER | Oxygen data (mg/l) collect with an SBE-43 dissolved oxygen sensor integrated with SBE-911+ CTD package |
Attribute Details
Attribute Name | CRUISE_ID |
---|---|
Seq. Order | 1 |
Data Storage Type | VARCHAR2 |
Max Length | 9 |
Min Length | |
Required | Yes |
Primary Key | Yes |
Precision | |
Scale | |
Status | Active |
Description |
Cruise name used to identify the survey or cruise (and as listed in /ftp/pub/hydro). |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations |
OCDBS.HYDRO_EVENT |
Derivation | |
Validation Rules |
Attribute Name | GEAR_TYPE |
---|---|
Seq. Order | 2 |
Data Storage Type | VARCHAR2 |
Max Length | 15 |
Min Length | |
Required | Yes |
Primary Key | Yes |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations |
OCDBS.HYDRO_EVENT |
Derivation | |
Validation Rules |
Attribute Name | CAST |
---|---|
Seq. Order | 3 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | Yes |
Primary Key | Yes |
Precision | |
Scale | |
Status | Active |
Description |
The consecutive cast number completed on the cruise. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations |
OCDBS.HYDRO_EVENT |
Derivation | |
Validation Rules |
Attribute Name | PRES |
---|---|
Seq. Order | 4 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TEMP |
---|---|
Seq. Order | 5 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SALT |
---|---|
Seq. Order | 6 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FLUOR |
---|---|
Seq. Order | 7 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TRANS |
---|---|
Seq. Order | 8 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PAR |
---|---|
Seq. Order | 9 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PHOSPHATE |
---|---|
Seq. Order | 10 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NITRATE |
---|---|
Seq. Order | 11 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SILICATE |
---|---|
Seq. Order | 12 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CHLOROPHYLL |
---|---|
Seq. Order | 13 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DOX |
---|---|
Seq. Order | 14 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DOE |
---|---|
Seq. Order | 15 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The date of the last entry |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DOC |
---|---|
Seq. Order | 16 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The date of the last change to the table |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | UOE |
---|---|
Seq. Order | 17 |
Data Storage Type | VARCHAR2 |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Who made the last entry (identified by oracle username). |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | UOC |
---|---|
Seq. Order | 18 |
Data Storage Type | VARCHAR2 |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Who made the last change to the table (identified by their oracle username). |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CHL_FL |
---|---|
Seq. Order | 19 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PAR_SENSOR |
---|---|
Seq. Order | 20 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | O2 |
---|---|
Seq. Order | 21 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 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 Workflow State | Published / External |
Metadata Last Review Date | 2016-07-27 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2017-07-27 |
Tags |
---|