Update How the UIC Web App Pulls in Source Water Protection Zone (SWPZ) Contact Information

[rsparker-utah]

Issue
The current table view that the UIC Web App currently references (VW_WATER_SYSTEM_ADMIN_CONTACTS) will be going away within a year.

Background
Per Jeff Mabey, the database that the VW_WATER_SYSTEM_ADMIN_CONTACTS view is being referenced from is no longer being actively used. The replication is still in place and for now it is working fine; however, it is expected that SDWIS (the app provided by the EPA that DDW uses to manage public water systems) is expected to be replaced in May 2026. The replacement system (i.e., DWSFTIES) that the EPA is coding is a hosted solution. Because of this, the way that the UIC Web App gathers source water protection zone contact information needs to be updated to prevent interruptions. Jeff proposed exposing an API endpoint, allowing for the management of the source of the data regardless of the database (i.e., SDWIS or DWSFTIES). The Apigee Google Cloud Platform (GCP) service that provides a comprehensive API management platform was recommended as a possible path forward for this initiative.

Request
Update how the UIC Web App references the SWPZ contact information with the proposed API endpoint structure.

[steveoh]

Are you planning to manage the creation of the endpoint and provide the details to us when it's ready to be used?

[rsparker-utah]

To be honest, I don't really have any knowledge about endpoint creation or what that entails. Is this something that I first need to coordinate with our DWQ DTS folks (e.g., Jeff Mabey) to get set up?

[steveoh]

I think that sounds like a good starting point.

[rsparker-utah]

Sounds good, thanks. I'll reach out to our DWQ DTS folks and see what needs to be done to initiate the creation of the endpoint and associated details.

[steveoh]

Ben Meibus is the apigee admin and will do the work in there. We will need someone with knowledge of the drinking water systems to give him the details/credentials to create the right connections within the database.

[steveoh]

@rsparker-utah has there been any progress with this? Is the service available for us to migrate to?

[rsparker-utah]

@steveoh As far as I know, the service isn't quite ready yet. I'll follow up with our DEQ DTS folks to see if they can provide an update.

[rsparker-utah]

Quick update for reference, per email (on 8/5/2025), Jeff Mabey will be the contact for planning this enhancement on the DEQ DTS side. Tentative timeline for the DEQ DTS folks is FY26 Q2.