Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Evaluating The Ecological Health of Puget Sound'S (WA) Pelagic Foodweb Using CTD Townetting Casts Logs from 2011 to 2012
Short Name: EPA Townetting CTD Casts Logs
Status: Planned
Abstract:

Cast log with details on each water column profile that was collected. Profile data are linked to cast log using the Cast Key.

Entity Information

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

Cast log with details on each water column profile that was collected. Profile data are linked to cast log using the Cast Key.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ID NUMBER Auto ID.
100
CTD NUMBER Ctd ID Number.
100
Cast NUMBER Cast number unique within CTD.
100
Cast Key NUMBER Concantenation of CTD and Cast number.
100
Day NUMBER Day of month for profile.
100
Month VARCHAR2 Month profile was taken.
100
Month Integer NUMBER Month integer profile was taken.
100
Year NUMBER Year of profile.
100
Time PST DATE Time in PST.
100
Flag VARCHAR2 Designation indicating which cast were actual samples. Only cast labeled as SAMPLE are actual water column profiles.
100
SiteName VARCHAR2 Site name matching SiteName in Sites table.
100
Tow NUMBER Tow ID to match CTD profiles with fish sampled via surface trawl.
100
Processing Batch NUMBER Batch number of profiles processed using SeaBird data processing application.
100
Con File VARCHAR2 Instrument configuration file used to derive variables from cast.
100
Notes VARCHAR2 Notes on cast.
100
Data Flag VARCHAR2 Data quality flag with notes describing any data for the cast that should not be used.

Attribute Details

ID

CC ID: 753083
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Auto ID.

General Data Type: NUMBER

CTD

CC ID: 753084
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Ctd ID Number.

General Data Type: NUMBER

Cast

CC ID: 753085
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Cast number unique within CTD.

General Data Type: NUMBER

Cast Key

CC ID: 753086
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Concantenation of CTD and Cast number.

General Data Type: NUMBER

Day

CC ID: 753087
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Day of month for profile.

General Data Type: NUMBER

Month

CC ID: 753088
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Month profile was taken.

General Data Type: VARCHAR2

Month Integer

CC ID: 753089
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Month integer profile was taken.

General Data Type: NUMBER

Year

CC ID: 753090
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Year of profile.

General Data Type: NUMBER

Time PST

CC ID: 753091
Seq. Order: 9
Data Storage Type: DATE
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Time in PST.

General Data Type: DATE

Flag

CC ID: 753092
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Designation indicating which cast were actual samples. Only cast labeled as SAMPLE are actual water column profiles.

General Data Type: VARCHAR2

SiteName

CC ID: 753093
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Site name matching SiteName in Sites table.

General Data Type: VARCHAR2

Tow

CC ID: 753094
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Tow ID to match CTD profiles with fish sampled via surface trawl.

General Data Type: NUMBER

Processing Batch

CC ID: 753095
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Batch number of profiles processed using SeaBird data processing application.

General Data Type: NUMBER

Con File

CC ID: 753096
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Instrument configuration file used to derive variables from cast.

General Data Type: VARCHAR2

Notes

CC ID: 753097
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Notes on cast.

General Data Type: VARCHAR2

Data Flag

CC ID: 753098
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Data quality flag with notes describing any data for the cast that should not be used.

General Data Type: VARCHAR2

Catalog Details

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