DW-SFTIES Transition

Description

Flow Diagram: Develop a flow diagram illustrating all IT items that interact with the current SDWIS.  DOIT/DWSG shall carefully review each item to determine if an action plan is needed for successful transition to DW-SFTIES. 

Data Services: Web services used by the public to get information into E2/SDWIS may be impacted.  All outfacing tools may need to be tweaked or in some cases completely revamped.

Data Flow to EPA: The data flow process from SDWIS State to DW-SFTIES will need to be changed since SDWIS State will no longer exist.  WSGS states that the EPA will need to provide a new FEDREP application.

E2: It is expected that modifications to E2 will be required.

Data Errors: Errors that exist in the SDWIS database must be corrected before migrating to DW-SFTIES.

Data Migration Scripts: Work with EPA contractor Systalex to customize data migration scripts based on NJ’s rules and methods.

Data Migration: Migrate SDWIS-State data to DW-SFTIES system successfully.

Reporting: May need to revamp some DEP reports to hit DW-SFTIES.

Drinking Water Viewer: Once DW-SFTIES is in production, DOIT/DWSG will need to work with the contractor GEC to shift from using SDWIS-State as the data source to DW-SFTIES for Drinking Water Viewer.  GEC has indicated that they will update Drinking Water Viewer to be compatible with DW-SFTIES so the expectation is that this should go smoothly.

Problem Statement

The current Environmental Protection Agency (EPA) enterprise data system “Safe Drinking Water Information System (SDWIS)” is being replaced by an Amazon cloud based “Drinking Water State-Tribal-Federal Information Exchange System” (DW-SFTIES). Once DW-SFTIES moves into Production, EPA will only offer 1 year of current SDWIS version support after that launch date. Once the SDWIS support time frame has expired, DEP may encounter significant problems if support is needed and no longer be able to report drinking water violations to EPA as required under primacy.

Project Justification

The Division of Water Supply and Geoscience must begin laying out a transition plan to EPA to move from SDWIS to DW-SFTIES. Part of this plan must include understanding the impact that the transition to DW-SFTIES will have on interconnectivity to existing SDWIS data flow and system technologies. It is expected that the new data structure for DW-SFTIES will vary significantly from the current SDWIS structure. This will require updates/changes to E2, NJEMS-SDWIS interface applications, and reports.
https://e-enterprisefortheenvironment.net/our-projects/sdwis/

Estimated Transactions

None

Created

25 May 2023, 11:59

Target Rollout Date

30 June 2025

Target Rollout Date Reason

DW-SFTIES has a projected production launch date of 1st Quarter 2025. It is estimated that EPA will provide 1 year of support to state SDWIS users after this launch date of DW-SFTIES. Would like to be up and running well before any EPA support ends. (Note: Have also heard that EPA could support state SDWIS users up to 3 years, but am planning on worse case scenario.)

Updated

25 June 2025, 14:12

Attachments

Activity

Pete Tenebruso 6 July 2023, 15:30

7/6 still somewhat unknown.  EPA signaled they are only 15% complete as of April 2023.  January 2025 is EPA’s target date.  Is this worth it to start work on this is EPA is not far along? DEP has had a poor experience trying to complete EPA based projects that are not fully or close to fully developed. Should we learn from other State’s mistakes.

Mike.Kusmiesz 30 June 2023, 16:51

Meeting scheduled July 11, 2023 with EPA representative to talk about DW-SFTIES plan and development progress.

Mike.Kusmiesz 23 June 2023, 18:43

DW-SFTIES Development Phase Expected Start Date began on 1/9/23. DW-SFTIES Development Phase Expected End Date is 1/31/25. Next Monthly EPA Summary report on this expected on 7/20/23.

As of May 31, 2023 EPA estimated DW-SFTIES Development to be 15% complete. Updated numbers will be out later in July/August.

July/August 2023 EPA will be looking back at the past 6 months progress for DW-SFTIES Development. EPA will then re-evaluate if project schedule timelines need to be modified.

EPA has been asking states to complete a DW-SFTIES Transition Plan. One of the questions is “What is your agencies estimated period of time to transition to DW-SFTIES. Most state responses list “Between 1 and 3 years after DW-SFTIES goes live. That would put us in the 1/31/26 - 1/31/28 timeframe if this project ends on time.

Mike.Kusmiesz 21 June 2023, 11:22

Haven’t been able to obtain a lot of information to date on this project from EPA. Came across this summary dashboard page through. https://usepa.servicenowservices.com/sdwisprogram?id=sdwis_modernization_homepage&sysparm_domain_restore=false&sysparm_stack=no Haven’t gone through it in detail but it should give us some insight into how far along EPA is with modernizing SDWIS. I’ve signed up for all their monthly discussions so I can gain better insight into what is going on.