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 231.3 MB | |
| Created: | Apr 27, 2022 at 7:46 p.m. | |
| Last updated: | Apr 27, 2022 at 8:36 p.m. | |
| DOI: | 10.4211/hs.20206a86cb6040a68141974659d89a94 | |
| Citation: | See how to cite this resource |
| Sharing Status: | Published |
|---|---|
| Views: | 467 |
| Downloads: | 13 |
| +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
README.md
Authors
Anh Nguyen
Haley Canham
Emily Jainarain
What's in here
This HydroShare Resource contains
- All the data downloaded from EPA StreamCat database for Hydro Region 16 (Great Basin), stored in
HydroRegion16_unzipped, - GIS analysis results for lakes of interest (Utah Lake, Porcupine Reservoir, and Silver Lake), stored in
GISAnalysisOutput, - A structured database designed to store and connect NHDPlus V2 data and StreamCat data,
- Data to be loaded into the above database, stored in
formatted_data, - Queried and aggregated data of lakes of interest for analysis and visualization, stored in
example_analysis_data, - Jupyter notebooks that extracted, formatted, queried, aggregated and visualized the data,
- An excel file (
important_vars.xlsx) containing handpicked variables of interest (for the example analysis), their description and locations in StreamCat database, - A text file (
streamcat_download.txt) contains the bash command to download StreamCat data for Hydro Region 16, and - The visualization output (
norm_nitrogen_loading.png) of the example analysis.
How to use the resource
- All data are available and ready for analysis. However, if you want to test out the entire workflow, start with downloading the StreamCat data for Hydro Region 16, using the bash command in
streamcat_download.txt. - Then unzip the data using the codes in
data_reformat.ipynb. This notebook also contains the codes for reformatting and creating the tables needed for the designed database. - Use the database as is for the structure is included within the database
- Use
data_query_visualization.ipynbto check out the example query, analysis and visualization.
Citation
Nguyen, A., H. Canham, E. Jainarain (2022). Generalized Methods for Nitrogen Loading Assessment in Contributing Areas of Selected Lakes of Interest, HydroShare, http://www.hydroshare.org/resource/20206a86cb6040a68141974659d89a94
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