Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Prerecruit Survey CTD Data
Short Name: Prerecruit Survey CTD Data
Status: Planned
Abstract:

This table contains cruise and raw and processed data from NWFSC prerecruit survey CTD casts for the years 2011, 2013, 2014, and 2015.

Entity Information

Entity Type: Spreadsheet
Active Version?: Yes
Schema Name: PARR
Description:

This table contains cruise and raw and processed data from NWFSC prerecruit survey CTD casts for the years 2011, 2013, 2014, and 2015.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Cruise VARCHAR2 Vessel name.
100
Year DATE Date of the Cruise.
100
Original_Station VARCHAR2 Old station number for database.
100
Transect NUMBER New transect for database.
100
Station NUMBER New station for database.
100
Depth NUMBER Depth where measurement taken. Units for values are meters.
100
Temperature NUMBER Temperature at depth. Units for values are degrees Celcius.
100
Fluorescence NUMBER Flourescing pigment at depth. Value given is the voltage across the sensor. Units for values are volts.
100
Beam_Transmission NUMBER Light transmission at depth relative to surface. Units for values are percent.
100
Oxygen_Raw NUMBER Raw oxygen levels at depth. Units for values are volts.
100
Salinity NUMBER Salinity at depth. Units for values are practical salinity units.
100
Density NUMBER Water density at depth. CTD reports for density omit the leading 10 such that 24.5 kg m-3 is actually 1024.5 kg m-3. Units for values are kilograms per meter cubed.
100
Dissolved Oxygen NUMBER Milliliter per Liter. Units for values are millileters per liter.

Attribute Details

Cruise

CC ID: 731540
Seq. Order: 1
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Vessel name.

General Data Type: VARCHAR2

Year

CC ID: 731541
Seq. Order: 2
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Date of the Cruise.

General Data Type: DATE

Original_Station

CC ID: 731542
Seq. Order: 3
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Old station number for database.

General Data Type: VARCHAR2

Transect

CC ID: 731543
Seq. Order: 4
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

New transect for database.

General Data Type: NUMBER

Station

CC ID: 731544
Seq. Order: 5
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

New station for database.

General Data Type: NUMBER

Depth

CC ID: 731545
Seq. Order: 6
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Depth where measurement taken. Units for values are meters.

General Data Type: NUMBER
Unit of Measure: meters

Temperature

CC ID: 731546
Seq. Order: 7
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Temperature at depth. Units for values are degrees Celcius.

General Data Type: NUMBER
Unit of Measure: degrees Celcius

Fluorescence

CC ID: 731547
Seq. Order: 8
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Flourescing pigment at depth. Value given is the voltage across the sensor. Units for values are volts.

General Data Type: NUMBER
Unit of Measure: volts

Beam_Transmission

CC ID: 731548
Seq. Order: 9
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Light transmission at depth relative to surface. Units for values are percent.

General Data Type: NUMBER
Unit of Measure: percent

Oxygen_Raw

CC ID: 731549
Seq. Order: 10
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Raw oxygen levels at depth. Units for values are volts.

General Data Type: NUMBER
Unit of Measure: volts

Salinity

CC ID: 731550
Seq. Order: 11
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Salinity at depth. Units for values are practical salinity units.

General Data Type: NUMBER
Unit of Measure: practical salinity units

Density

CC ID: 731551
Seq. Order: 12
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Water density at depth. CTD reports for density omit the leading 10 such that 24.5 kg m-3 is actually 1024.5 kg m-3. Units for values are kilograms per meter cubed.

General Data Type: NUMBER
Unit of Measure: kilograms per meter cubed

Dissolved Oxygen

CC ID: 731552
Seq. Order: 13
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Milliliter per Liter. Units for values are millileters per liter.

General Data Type: NUMBER
Unit of Measure: millileters per liter

Catalog Details

Catalog Item ID: 37560
GUID: gov.noaa.nmfs.inport:37560
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2017-04-03 14:18+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-02-27
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-02-27
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-02-27