Search Help Show/Hide Menu
Metadata Rubric
83%
5 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Resource Ecology and Fisheries Management Divis... > Fish Abundance Surveys > AFSC/REFM: Inshore research surveys in the east... >

tblOceanST

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

Summary

Abstract

NA

Description

NA

Entity Information

Data Attribute / Type Description
StationID
NUMBER 		Primary key
OceanCode
Unknown 		Foreign key that relates to "OceanCode" in the tblOcean
CruiseID
Unknown 		Same as the 'CruiseID' in tblCruise
SiteCode
Unknown 		From lovSite table; WB is Whale Bay; SL is St.Lazaria; SS is Salisbury Sound; IB is Islas Bay; TB is Torch Bay; GH is Graves Harbor; KB is Kiliuda Bay; IZ is Izuit Bay; PD is Port Dick; AB is Ailiak Bay
StationNo
NUMBER 		Station from which the CTD cast took place
StationCode
Unknown 		Type of cast that occurred at the fixed station; e.g., CTD, Zooplankton, nutrients or chlorphyll
WPT
NUMBER 		Location where the actual cast occurred (not a fixed station as in "tblOcean")
LatDD
NUMBER 		Latitude in decimal degrees where cast occurred; not where the fixed station is located
LongDD
NUMBER 		Longitude in decimal degrees where cast occurred; not where the fixed station is located
Date
NUMBER 		Date when the cast occurred
DepTime
NUMBER 		Deployment time in ADT (Alaska daylight time)
OceanCom
Unknown 		Comments that pertain to the cast or samples collected

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: tblOceanST
Short Name: tblOceanST
Status: Completed
Abstract:

NA
Notes:

Loaded by FGDC Metadata Uploader, batch 7848, 12-14-2015 14:31

Entity Information

Description:

NA

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 StationID NUMBER Primary key
100
 OceanCode Unknown Foreign key that relates to "OceanCode" in the tblOcean
100
 CruiseID Unknown Same as the 'CruiseID' in tblCruise
100
 SiteCode Unknown From lovSite table; WB is Whale Bay; SL is St.Lazaria; SS is Salisbury Sound; IB is Islas Bay; TB is Torch Bay; GH is Graves Harbor; KB is Kiliuda Bay; IZ is Izuit Bay; PD is Port Dick; AB is Ailiak Bay
100
 StationNo NUMBER Station from which the CTD cast took place
100
 StationCode Unknown Type of cast that occurred at the fixed station; e.g., CTD, Zooplankton, nutrients or chlorphyll
100
 WPT NUMBER Location where the actual cast occurred (not a fixed station as in "tblOcean")
100
 LatDD NUMBER Latitude in decimal degrees where cast occurred; not where the fixed station is located
100
 LongDD NUMBER Longitude in decimal degrees where cast occurred; not where the fixed station is located
100
 Date NUMBER Date when the cast occurred
100
 DepTime NUMBER Deployment time in ADT (Alaska daylight time)
100
 OceanCom Unknown Comments that pertain to the cast or samples collected

Attribute Details

StationID

CC ID: 263536
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Primary key
Allowed Values: 1 - 747

OceanCode

CC ID: 263537
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Foreign key that relates to "OceanCode" in the tblOcean
Allowed Values: unknown

CruiseID

CC ID: 263538
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Same as the 'CruiseID' in tblCruise
Allowed Values: unknown

SiteCode

CC ID: 263539
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

From lovSite table; WB is Whale Bay; SL is St.Lazaria; SS is Salisbury Sound; IB is Islas Bay; TB is Torch Bay; GH is Graves Harbor; KB is Kiliuda Bay; IZ is Izuit Bay; PD is Port Dick; AB is Ailiak Bay
Allowed Values: unknown

StationNo

CC ID: 263540
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Station from which the CTD cast took place
Allowed Values: 1 - 11

StationCode

CC ID: 263541
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Type of cast that occurred at the fixed station; e.g., CTD, Zooplankton, nutrients or chlorphyll
Allowed Values: unknown

WPT

CC ID: 263542
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Location where the actual cast occurred (not a fixed station as in "tblOcean")
Allowed Values: 1 - 232

LatDD

CC ID: 263543
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Latitude in decimal degrees where cast occurred; not where the fixed station is located
Allowed Values: 56.56651 - 59.8966

LongDD

CC ID: 263544
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Longitude in decimal degrees where cast occurred; not where the fixed station is located
Allowed Values: -153.15827 - -134.83616

Date

CC ID: 263545
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Date when the cast occurred
Allowed Values: 201104200000 - 201110270000

DepTime

CC ID: 263546
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Deployment time in ADT (Alaska daylight time)
Allowed Values: 815 - 2310

OceanCom

CC ID: 263547
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Comments that pertain to the cast or samples collected
Allowed Values: unknown

Catalog Details

Catalog Item ID: 29762
GUID: gov.noaa.nmfs.inport:29762
Metadata Record Created By: Angie Greig
Metadata Record Created: 2015-12-14 14:31+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-05
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-05
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-05