Checking for non-preferred file/folder path names (may take a long time depending on the number of files/folders) ...
This resource contains some files/folders that have non-preferred characters in their name. Show non-conforming files/folders.
This resource contains content types with files that need to be updated to match with metadata changes. Show content type files that need updating.
Generalized Methods for Nitrogen Loading Assessment in Contributing Areas of Selected Lakes of Interest
| Authors: |
|
|
|---|---|---|
| Owners: |
|
This resource does not have an owner who is an active HydroShare user. Contact CUAHSI (help@cuahsi.org) for information on this resource. |
| Type: | Resource | |
| Storage: | The size of this resource is 277.0 MB | |
| Created: | Apr 27, 2022 at 7:46 p.m. (UTC) | |
| Last updated: | Apr 27, 2022 at 8:36 p.m. (UTC) (Metadata update) | |
| Published date: | Apr 27, 2022 at 8:36 p.m. (UTC) | |
| DOI: | 10.4211/hs.20206a86cb6040a68141974659d89a94 | |
| Citation: | See how to cite this resource |
| Sharing Status: | Published |
|---|---|
| Views: | 2270 |
| Downloads: | 61 |
| +1 Votes: | Be the first one to this. |
| Comments: | No comments (yet) |
Abstract
Lakes worldwide are impaired by external nutrient loading due to human activities, specifically agricultural runoff. Excess nutrients can change nutrient dynamics in lakes and contribute to declining water quality. This study utilizes two publicly available datasets, NHDPlus V2 and StreamCat, to investigate and compare the rates of inorganic nitrogen wet deposition, biological nitrogen fixation, and nitrogen fertilizer application within the surrounding watershed of three lakes. To accomplish this, a relational database was created to relate StreamCat values with NHDPlus V2 watershed hierarchy using a unique StreamID. The data from each dataset was loaded into the relational database after performing a geospatial analysis to identify StreamIDs within the watershed for each lake of interest. SQLite queries were then performed to obtain rates of chosen parameters from the relational database in order to compare the three watersheds. This study demonstrated that generalized methods can be developed to relate NHDPlusV2 and StreamCat, in order to simplify querying of water quality data from StreamCat for the watersheds of selected lakes.
Subject Keywords
Content
How to Cite
This resource is shared under the Creative Commons Attribution CC BY.
http://creativecommons.org/licenses/by/4.0/
Comments
There are currently no comments
New Comment