Hydrolink | DEQ Automated Data Transfer Web App
Members
- Christian Galvan
- Mesa Greear
- Elijah Meldrim
Abstract
The Hydrolink project is a web app that assists employees at the Idaho Department of Environmental Quality (DEQ) with sending data from their Environmental Data Analysis System (EDAS) to the federal Water Quality Exchange (WQX). The specific type of data that is retrieved from the EDAS and sent to the WQX is Physical-Chemistry data that has been collected from the Beneficial Use Reconnaissance Program (BURP).
Before accessing the web interface, a DEQ employee must be properly authenticated via Microsoft Authenticator and Active Directory. Once authenticated, a DEQ employee can then filter the BURP data results they want sent to the WQX by the locations the data was gathered at, a lower bound date, and an upper bound date. The data can also be alternatively downloaded as a csv file that has been automatically formatted to match the WQX's Physical-Chemistry template.
This project was also developed in such a way that future Boise State University students may expand upon it, allowing additional types of data, besides just Physical-Chemistry data, to be formatted and sent to the WQX.
Description
After opening the website and getting past Microsoft Authentication, the employee will be greeted with the Hydrolink Dashboard page which shows the history of previous WQX upload attempts.
To send specific BURP data to the WQX, the employee will then have to go to the EDAS page via the top bar. On this page there are three important buttons, 'Show Filters', 'Display Results', and 'Download'.
Upon selecting 'Show Filters', a sidebar will appear allowing the employee to search and select however many monitoring locations they wish to include in their BURP data results. They may also select a lower date range and an upper date range. The monitoring locations and the date range the user has selected, i.e. the filters, will be displayed at the top of the sidebar.
Selecting 'Display Results' will then grab Physical-Chemistry BURP data from the EDAS, filtering the results using the user specified filters, and display the data in the WQX Physical-Chemistry data format. This format is split into three parts as seen below, those being the 'Projects Sheet', the 'Locations Sheet', and the 'Results Sheet'.
The 'Display Results' button is where most of the EDAS database access occurs, running three fairly large Microsoft SQL Server queries to get the BURP data for the three previously mentioned sheets. The data queried from the EDAS is also reorganized into a format that matches the WQX Physical-Chemistry data format before it is returned to the Hydrolink web interface to be displayed.
After examining the BURP data results, the employee can then choose to upload the results to the WQX. There are two upload options, 'Upload' and 'Test Upload'. 'Test Upload' will attempt to upload the BURP results to a WQX test database which will then inform the employee whether or not the upload was successful. If the test upload was successful, then the employee can confidently use the regular upload knowing that the BURP data will be correctly transferred to the WQX. Alternatively, the employee can select 'Download' to download a csv file version of the BURP data results.