IPTD-338
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.
Project Justification
https://e-enterprisefortheenvironment.net/our-projects/sdwis/
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.
Meeting scheduled July 11, 2023 with EPA representative to talk about DW-SFTIES plan and development progress.
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.
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.