Freshwater Ammonia Calculator
Description
This project will require a preliminary test between two software applications (Shinyapps.io and Tableau). Our goal is to determine the most suitable platform based on responsiveness and visual communication of the information. The objectives are to evaluate the connectivity of Tableau with R, compare the ease of developing the application in Tableau versus Shinyapps.io, and to compare the quality and useability of the application features. Making a choice as to which product is suited best for this project may not be possible without developing and testing the target application on both platforms.
Problem Statement
The project is necessary so that implementors (dischargers) of the Surface Water Quality Standards (SWQS) are provided an easy tool to calculate freshwater ammonia criteria based on the updated criteria equation proposed in the SWQS on July 5, 2022.
Project Justification
This tool is needed to assist dischargers in successfully achieving compliance with new or updated water quality standards. It will be used to compare numeric criteria generated using the existing and proposed freshwater ammonia equations. These equations can be quite complex. Specifically, this tool will analyze pH, temperature, and ammonia water quality data collected from the State’s fresh surface waters (rivers, streams and lakes) and compare the ambient ammonia concentrations to the current and proposed freshwater ammonia SWQS. Inquiries made to the Bureau regarding ammonia criteria may be redirected to this application instead of having to be addressed by staff. This project aligns with the DEP’s objective of promoting transparency, efficiency, and innovation using technology.
Estimated Transactions
We aren't sure since we've never implemented a tool like this before. Users will be: DEP (standards, assessment, and permitting) programs, NJPDES permittees and their consultants,
Components
Other (Specify)Tableau
Target Rollout Date
31 July 2023
Target Rollout Date Reason
It will be adopted on or before July 5th, 2022. Then it will take another 3-4 months to get it approved by EPA. Then it becomes official.
Attachments
Activity
Show:
Create issue
Idea
Add watchers
Details
Sponsoring Leadership Area
Water Resource Management
Sponsoring Leadership Area's Priority
AP-30
Program Area Lead(s)
Biswarup Guha and Drew Simoneau
DOIT technical lead(s)
None
All Involved Leadership Areas
Div. of Information TechnologyWater Resource Management
Created: 5 January 2023, 13:50
Updated:
13 July 2023, 12:27