tblOcean
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:29761 | Updated: August 9, 2022 | Published / External
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
OceanID | NUMBER | Primary key | |
|
100
|
OceanCode | Unknown | Foreign key | |
|
100
|
Location | Unknown | Whether it occured in the East GOA (EG000000) or West GOA (WG000000) | |
|
100
|
SiteCode | Unknown | Site location code; 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 No that stays static (permanent) as opposed to "StationID" which is often an autonumber | |
|
100
|
SiteLatDD | NUMBER | Permanent latitude (DD) for the Station No; stays static | |
|
100
|
SiteLongDD | NUMBER | Permanent longitude (DD) for the Station No; stays static |
Attribute Details
OceanID
CC ID: 263529
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Primary key |
| Allowed Values: | 309 - 663 |
OceanCode
CC ID: 263530
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Foreign key |
| Allowed Values: | unknown |
Location
CC ID: 263531
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Whether it occured in the East GOA (EG000000) or West GOA (WG000000) |
| Allowed Values: | unknown |
SiteCode
CC ID: 263532
| Data Storage Type: | Unknown |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Site location code; 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: 263533
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Station No that stays static (permanent) as opposed to "StationID" which is often an autonumber |
| Allowed Values: | 1 - 11 |
SiteLatDD
CC ID: 263534
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Permanent latitude (DD) for the Station No; stays static |
| Allowed Values: | 56.56651 - 59.895467 |
SiteLongDD
CC ID: 263535
| Data Storage Type: | NUMBER |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Permanent longitude (DD) for the Station No; stays static |
| Allowed Values: | -153.158091 - -134.83621 |