Oyster Bed Water Nitrogen 2011

Northwest Fisheries Science Center
Entity (ENT) | ID: 36831 | Published / External
Created: 2017-02-16   |   Last Modified: 2022-08-09

Parent: EPA oyster project: nitrogen in water. - Transport and fate of nutrient and pathogen loadings into nearshore Puget Sound: consequences for shellfish growing areas
Data Set (DS) | ID: 18605

ID: 36831
Entity (ENT)

* Discovery
• First Pass
» Metadata Rubric

Item Identification

* » Title Oyster Bed Water Nitrogen 2011
Short Name Oyster Bed Water Nitrogen 2011
* Status Planned
Creation Date  
Revision Date  
• Publication Date  
* » Abstract

These data consist of nitrogen (nitrate-N, nitrite-N, and ammonium-N) concentrations (in microgram/liter) in three rivers and associated estuaries collected in 2011 and 2012 as part of project to examine the sources of nutrients and energy supporting commercial oyster beds. Oyster beds were located in the estuary near by the associated river mouth. These rivers including the Dosewallips, Hamma Hamma, and Samish. Details on study sites and objectives can be found in Conway-Cranos, L., P. Kiffney, N. Banas, J. Burke, M. Plummer, S. Naman*, R. Paranjpye , M. Strom, P. MacCready, J. Bucci, and M. Ruckelshaus. 2015. Estuarine organic matter sources subsidize shellfish beds in Puget Sound, WA, USA. Marine Ecology Progress Series 533: 15-28.
* Purpose
Notes
Other Citation Details
• Supplemental Information
DOI (Digital Object Identifier)  
DOI Registration Authority  
DOI Issue Date  

Keywords

Theme Keywords

Thesaurus Keyword
   
   
   

Temporal Keywords

Thesaurus Keyword
   
   
   

* Spatial Keywords

Thesaurus Keyword
   
   
   

Stratum Keywords

Thesaurus Keyword
   
   
   

Instrument Keywords

Thesaurus Keyword
   
   
   

Platform Keywords

Thesaurus Keyword
   
   
   

Physical Location

• » Organization  
• » City  
• » State/Province  
• Country  
• » Location Description

Entity Information

Entity Type Spreadsheet
Active Version? Y
Alias  
Schema Name PARR
» Description

These data consist of nitrogen (nitrate-N, nitrite-N, and ammonium-N) concentrations (in microgram/liter) in three rivers and associated estuaries collected in 2011 and 2012 as part of project to examine the sources of nutrients and energy supporting commercial oyster beds. Oyster beds were located in the estuary near by the associated river mouth. These rivers including the Dosewallips, Hamma Hamma, and Samish. Details on study sites and objectives can be found in Conway-Cranos, L., P. Kiffney, N. Banas, J. Burke, M. Plummer, S. Naman*, R. Paranjpye , M. Strom, P. MacCready, J. Bucci, and M. Ruckelshaus. 2015. Estuarine organic matter sources subsidize shellfish beds in Puget Sound, WA, USA. Marine Ecology Progress Series 533: 15-28.
Change Summary

Data Attributes

Attribute Summary

Score Req'd? PKey? » Name Data Storage Type Description
100 No No Watershed VARCHAR2 The watershed were samples were collected. "Admiralty" refers to samples collected off-shore out of the zone of influence of each watershed and assumed to represent purely a marine source.
100 No No Site VARCHAR2 Habitat types where samples were collected including within oyster bed (oyster bed), river (from within the freshwater zone of each river), offshore (marine sample collected away from influence of each river estuaries).
100 No No Location VARCHAR2 Additional detail on location of where samples where collected (e.g. Hwy 101 bridge indicates sample was collected close to bridge).
100 No No Date Collected DATE Date when each sample was collected.
100 No No NO3- (ug/L) NUMBER Concentration of dissolved nitrate-N in each sample. Units for values are micrograms per liter.
100 No No NO2- (ug/L) NUMBER Concentration of dissolved nitrite-N in each sample. Units for values are micrograms per liter.
100 No No NH4 (ug/L) NUMBER Concentration of dissolved ammonium-N in each sample. Units for values are micrograms per liter.

Attribute Details

Attribute Name Watershed
Seq. Order 1
Data Storage Type VARCHAR2
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

The watershed were samples were collected. "Admiralty" refers to samples collected off-shore out of the zone of influence of each watershed and assumed to represent purely a marine source.
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name Site
Seq. Order 2
Data Storage Type VARCHAR2
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Habitat types where samples were collected including within oyster bed (oyster bed), river (from within the freshwater zone of each river), offshore (marine sample collected away from influence of each river estuaries).
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name Location
Seq. Order 3
Data Storage Type VARCHAR2
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Additional detail on location of where samples where collected (e.g. Hwy 101 bridge indicates sample was collected close to bridge).
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name Date Collected
Seq. Order 4
Data Storage Type DATE
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Date when each sample was collected.
General Data Type DATE
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NO3- (ug/L)
Seq. Order 5
Data Storage Type NUMBER
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Concentration of dissolved nitrate-N in each sample. Units for values are micrograms per liter.
General Data Type NUMBER
Unit of Measure micrograms per liter
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values 0-1000 ug/L
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NO2- (ug/L)
Seq. Order 6
Data Storage Type NUMBER
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Concentration of dissolved nitrite-N in each sample. Units for values are micrograms per liter.
General Data Type NUMBER
Unit of Measure micrograms per liter
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values 0-1000 ug/L
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NH4 (ug/L)
Seq. Order 7
Data Storage Type NUMBER
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Concentration of dissolved ammonium-N in each sample. Units for values are micrograms per liter.
General Data Type NUMBER
Unit of Measure micrograms per liter
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values 0-1000 ug/L
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Support Roles

» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions

Extents

Currentness Reference  

Extent Group 1

Extent Description

Extent Group 1 / Geographic Area

* » W° Bound
* » E° Bound
* » N° Bound
* » S° Bound
* » Description

Extent Group 1 / Vertical Extent

EPSG Code
Vertical Minimum
Vertical Maximum

Extent Group 1 / Time Frame

* » Time Frame Type
* » Start
End
Alternate Start as of Info
Alternate End as of Info
Description

Access Information

* » Security Class  
* Security Classification System  
 
Security Handling Description  
 
• Data Access Policy  
 
» Data Access Procedure  
 
• » Data Access Constraints  
 
• Data Use Constraints  
 
Metadata Access Constraints  
 
Metadata Use Constraints  
 

Distribution Information

Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status

Activity Log

Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description

Issues

Issue Date
Author
Issue
Issue Date
Author
Issue
Issue Date
Author
Issue

FAQs

Date
Author
Question
Answer

Child Items

Rubric scores updated every 15m

Score Type Title
     
     
     

Related Items

Item Type Relationship Type Title
     
     
     

Catalog Details

Catalog Item ID 36831
Metadata Record Created By Jeffrey W Cowen
Metadata Record Created 2017-02-16 19:25+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 Workflow State Published / External
Metadata Last Review Date 2018-02-27
Metadata Review Frequency 1 Year
Metadata Next Review Date 2019-02-27
Tags