Evaluating The Ecological Health of Puget Sound'S (WA) Pelagic Foodweb Using CTD Townetting Casts Logs from 2011 to 2012
Entity (ENT) | Northwest Fisheries Science Center (NWFSC)GUID: gov.noaa.nmfs.inport:36243 | Updated: August 9, 2022 | Published / External
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
|
|
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 |