Lead Service Line Inventory Submission and Mapping Application
Description
In July of 2021 Governor Murphy passed P.L.2021, Ch.183 (A5343/S3398) which requires all Community Water Systems to replace all Lead Service Lines in 10 years by 2031. Additionally, the law requires water systems to submit to the state an initial count which was due Sept. 20, 2021, and an initial Inventory which was due January 22, 2022, with annual updates submitted each year in July.
The Department does not currently have a way to receive this data electronically nor platform for managing this inventory data at the address level. The NJLCR database project that DWSG is currently working to develop with DOIT will address some components of this data, but it will not address the geospatial aspect and does not incorporate tools to manage address level data.
The current process which is to receive data submission on forms or excel spreadsheets as email attachments from 570 different water systems and DWSG staff review, and manual enter the counts from the LSL forms to SDWIS.
Those counts are then exported from SDWIS and merged with the purveyor later to be displayed in the LSLI map that has been developed with BGIS. This current process does not provide address specific information and does not provide an easy way to track changes in submission over time.
There is interest in making the Lead Service Line Inventory data available to the public to supplement information provided to customers by water systems and to potentially become a layer available in the PLEM tool () in the future which would require managing the geospatial data.
Project Justification
DWSG is requesting assistance from DOIT to improve the current Lead Service Line Inventory reporting process that would allow water systems to submit address level data to the department annual with their required LSL inventory updates. The new NJLCR data management tool that is currently being completed should address receiving the submission and the forms but will not parse the data at the address level. If possible can there be an interim solution that would rely on existing tools such as RSP to get the inventory data in more efficiently than the current process which relies on emailed submissions of spreadsheets.
Date Types:
Below are links to the existing LSLI form and reporting instructions which will provide information on the data that is collected through this process.
https://www.nj.gov/dep/lead/resources.html (Select Revised Lead Service Line Inventory Form)
https://www.state.nj.us/dep/watersupply/pdf/lsli-instructions.pdf
Linked work items
IPTD-112
eMOR
IPTD-80
Surface Water Treatment Rule (SWTR) Forms
IPTD-113
ePlanning Tool
IPTD-105
Water Quality Parameter Data Solution
This system is live and successfully receiving LSLI data from Water Systems.
The team has transitioned to maintenance mode, focusing on tweaks and enhancements when necessary, while supporting Water System staff with training and acclimation to the new LSLI system.
UAT Ongoing
Requirements gathering phase completed. SCD Workshop 1 is being scheduled by enfoTech
6/27/2023 - Rich Hyjack initiated the TIP (SAR Process) with NJOIT for the EN Suite Software/infrastructure to be used for this project
FRS v1.0 received 6/8/2023 and sent out internally for comment. Comments due to enfoTech by 6/22/2023
Requirement Workshops #2 and #3 scheduled for 6/28/2023 and 7/28/2023
Initial FRS Scheduled for 6/1/2023
FRS Project Schedule Attached
Working on schedule for Functional Requirement Specification (FRS) sessions with enfoTech and WRM
Waiver approved and PO cut for $1,965,120 on 3/7/2023. Jim and Rich will be working with Mike K. and enfoTech to set up initial project planning meetings for projects
Jim B reported final waiver approved by mid December
DEP received pre approval on the waiver
Grace working on waiver (applies to all 5 linked projects). Back and forth with Treasury ongoing.
9/12/2022 - Received design/dev estimates from enfoTech, need to discuss with WRM management before starting the waiver process
Sent to enfoTech on 8/25 for cost estimate along with 4 other WRM Priority projects
enfotech is the next option to explore - need meeting with program and enfotech with Jim’s team.
Program believes some of the data that will be recorded for the ‘NJ Lead and Copper Rule Data’ Priority #2 will address some of the data needs for this project. It is the geospatial and address level data that is the biggest need for this project.
Look for a national vendor who has built for other states?
Options:
Leveraging the approach to Charging station effort - reach out to previous respondents to RFI, get on the existing contract for software and software services.
2. Also possibly pay a third party for UIPath process for current forms coming in email.
3. Use GIS services contract
4. Rutgers?
Jim describes a FSS solution for this that could start right now. Doesn’t use funding
Need to understand the need in here that isn’t already being handled in the Lead and copper rule project (#77). This might be linking existing address info to the incoming new info.