Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Ecosystems & Aquaculture Division (EAD) > Oceans & Climate Branch (OCB) > Conductivity/Temperature/Depth > Oceanography Branch Hydrographic Database >

Table: HYDRO_EVENT

Entity (ENT) | Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:33509 | Updated: August 9, 2022 | Published / External

Item Identification

Title:	Table: HYDRO_EVENT
Short Name:	HYDRO_EVENT
Status:	Completed
Abstract:	The Hydrographic event table. Each cast/station covered on a cruise is considered an event.
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 event table. Each cast/station covered on a cruise is considered an event.

Data Attributes

Attribute Summary

	Name	Type	Description
100	CRUISE_ID	VARCHAR2	Cruise name used to identify the survey or cruise (and as listed in /ftp/pub/hydro).
100	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	CAST	VARCHAR2	The consecutive cast number completed on the cruise.
100	GEAR_SN	VARCHAR2	The serial number of the instrument (typically the CTD).
100	OP_CODE	VARCHAR2	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.
100	LAT_DD	NUMBER	The latitude of the station express as decimal degrees so that 40 degrees north, 30 minutes = 40.5
100	LON_DD	NUMBER	The longitude of the station expressed as decimal degrees so that 70 degrees, 30 minutes = 70.5
100	GMT_DATE	DATE	The cast date using the Greenwich mean time.
100	GMT_TIME	NUMBER	The GMT time with minutes expressed as decimal hours.
100	GMT_YDAY1	NUMBER	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
100	STA_BTM_DEPTH	NUMBER	The bottom depth where the hydrographic data was collected for a given station.
100	STA	VARCHAR2	The consecutive station occupied on the cruise.
100	STA_STD	VARCHAR2	The standard station occupied on the cruise; typically applicable to MARMAP and GLOBEC cruises.
100	VESSEL_NUM	VARCHAR2	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).
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	SITE_ID	NUMBER	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.

Name

Type

Description

100

CRUISE_ID

VARCHAR2

Cruise name used to identify the survey or cruise (and as listed in /ftp/pub/hydro).

100

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

CAST

VARCHAR2

The consecutive cast number completed on the cruise.

100

GEAR_SN

VARCHAR2

The serial number of the instrument (typically the CTD).

100

OP_CODE

VARCHAR2

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.

100

LAT_DD

NUMBER

The latitude of the station express as decimal degrees so that 40 degrees north, 30 minutes = 40.5

100

LON_DD

NUMBER

The longitude of the station expressed as decimal degrees so that 70 degrees, 30 minutes = 70.5

100

GMT_DATE

DATE

The cast date using the Greenwich mean time.

100

GMT_TIME

NUMBER

The GMT time with minutes expressed as decimal hours.

100

GMT_YDAY1

NUMBER

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

100

STA_BTM_DEPTH

NUMBER

The bottom depth where the hydrographic data was collected for a given station.

100

STA

VARCHAR2

The consecutive station occupied on the cruise.

100

STA_STD

VARCHAR2

The standard station occupied on the cruise; typically applicable to MARMAP and GLOBEC cruises.

100

VESSEL_NUM

VARCHAR2

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).

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

SITE_ID

NUMBER

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.

Attribute Details

CRUISE_ID

CC ID: 332906

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

GEAR_TYPE

CC ID: 332917

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

CAST

CC ID: 332918

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

GEAR_SN

CC ID: 332919

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	The serial number of the instrument (typically the CTD).
General Data Type:	VARCHAR2

OP_CODE

CC ID: 332920

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	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.
General Data Type:	VARCHAR2

LAT_DD

CC ID: 332921

Seq. Order:	6
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	6
Scale:	4
Status:	Active
Description:	The latitude of the station express as decimal degrees so that 40 degrees north, 30 minutes = 40.5
General Data Type:	NUMBER

LON_DD

CC ID: 332922

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	6
Scale:	4
Status:	Active
Description:	The longitude of the station expressed as decimal degrees so that 70 degrees, 30 minutes = 70.5
General Data Type:	NUMBER

GMT_DATE

CC ID: 332923

Seq. Order:	8
Data Storage Type:	DATE
Max Length:	7
Required:	Yes
Primary Key:	No
Status:	Active
Description:	The cast date using the Greenwich mean time.
General Data Type:	DATE

GMT_TIME

CC ID: 332924

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	2
Status:	Active
Description:	The GMT time with minutes expressed as decimal hours.
General Data Type:	NUMBER

GMT_YDAY1

CC ID: 332907

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	7
Scale:	4
Status:	Active
Description:	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
General Data Type:	NUMBER

STA_BTM_DEPTH

CC ID: 332908

Seq. Order:	11
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	The bottom depth where the hydrographic data was collected for a given station.
General Data Type:	NUMBER

STA

CC ID: 332909

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	The consecutive station occupied on the cruise.
General Data Type:	VARCHAR2

STA_STD

CC ID: 332910

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	The standard station occupied on the cruise; typically applicable to MARMAP and GLOBEC cruises.
General Data Type:	VARCHAR2

VESSEL_NUM

CC ID: 332911

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	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).
General Data Type:	VARCHAR2

DOE

CC ID: 332912

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: 332913

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: 332914

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: 332915

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

SITE_ID

CC ID: 332916

Seq. Order:	19
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	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.
General Data Type:	NUMBER

Catalog Details

Catalog Item ID:	33509
GUID:	gov.noaa.nmfs.inport:33509
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