IPTD-110
Water Purveyor Report Card
Description
The intent is to develop a dashboard, or story map using the ArcGIS platform to provide an engaging tool for the general public to find their public water system, and learn about their performance with regulatory standards, and how they compare to their peers.
This project would require a storymap/dashboard to be developed based on DWSG standards. These standards will incorporate compliance with regulatory standards, with consideration of the types of violations which are incurred (such as health-based MCL violations or failure to monitor violations), lead service line counts, other system information that will be captured via other methods, such as the Capital Improvement Report RSP service, WQAA Annual Certification forms, Water Loss Audits, or other criteria that DWSG may find pertinent. Information for approximately 290 public water systems across the state would need to be provided and updated each year.
These items should then have some method to allow for DWSG to update parameters on an annual basis in bulk, but with provisions to tweak individual systems on an as-needed basis.
The public-facing product should then be presented in a fashion that is engaging, and allows for multiple ways for users to select public water systems of interests. This could be via PWSID, name of the public water system, or address search (if it is within the service area of the water system). Once selecting a system, the user should be shown general information about the public water system they have selected. Once they continue onwards, they should then be shown details about that water system’s performance, in line with the standards that DWSG has chosen to evaluate water systems on.
A webpage that would be an interactive ArcGIS story map or dashboard that allows users to automatically obtain certain data related to public water system compliance based on criteria established by DWSG. This would need to be hosted on the DWSG website.
Project Justification
https://www.njleg.state.nj.us/2020/Bills/S1000/647_R4.PDF
Specifically
20 9. (New section) No later than one year after the effective date
21 of P.L. , c. (C. ) (pending before the Legislature as this
22 bill), and annually thereafter, the department shall develop and
23 publish on its Internet website a report card for each water purveyor
24 in the State, indicating the water purveyor’s compliance with
25 federal and State drinking water quality standards, its compliance
26 with the requirements of P.L.2017, c.133 (C.58:31-1 et seq.), and
27 any other factors the department deems appropriate. The report
28 card shall be designed to inform the public about the overall
condition of a public community
29 water system, and the quality of water coming from the public community
30 water system.
Program has indicated to me that this project is considered complete.
Mike M. - just added C&E data, still to draft some visuals for this and present to program. Dashboard is out publicly just being tweaked. Expect to hit the Nov 7 deadline.
Mike to seek feedback from Tableau (professional services team) in Dec/Jan after its live. Proposed as free from Tableau.
draft underway https://dep-v-bo4x.dep.state.nj.us/IRM/DEPtableau.aspx?VN=WaterSystemPurveyorScorecard-MM&DN=WSSearch&PS=1
Ed developing a view from data provided, Mike M. doing development. Need to look for places to expend money for advancing this.
Next steps:
Check in between GIS/Reporting - week of 7/25 - Angela to set.
Meeting 7/8/22 with DOIT and program reps confirmed the well written IT sheet requirements and identified potential for dual technologies of Tableau and GIS/AGO which may be integrated. Mapping could rely on points for systems with tabs/links to true GIS mapping and layers of systems Layer polygons were discussed as having enough complexity and inaccuracy to be unreliable for “find my water system” based on an address. The program maintains data by system for municipality served that can drive an address to system identification.
Next steps:
Mike Matsko to set a first meeting about data needed for display with the program and to include Ed A.
Knute to secure PM with Pete and Trish.
TABLEAU Dashboard Example from Mike M. :https://public.tableau.com/app/profile/rafael.maestu/viz/TESTPublicWaterSystemsBasedonDatacagov2/Dashboard12
AGO StoryMaps Examples from Angela
https://njdep.maps.arcgis.com/home/gallery.html?view=grid&sortOrder=desc&sortField=numviews&focus=applications-dashboards
Elements of the Report Card are satisfied by the existing Water Watch tool
We can consider purchase of EAPs from Esri if AGO is the path forward. This can supplement GIS staffing.
Are we solving the problem that a report card of minimum specs is required by law, or are we solving some assumed problem behind why the law called for a report card?
it looks like some of what is expected in the report card may not yet exist as enterprise data. It will be useful for the program to outline all the sources of data required in the report card
meeting set for July 8th 9-10am
The purpose of this meeting is to:
Ensure the needs and scope are understood
Decide on the technology (AGO or Tableau) sufficient to assign DOIT leads
Decide on a project manager responsible for getting to completion by
Mike K. working on IT sheet info - problem clarity. What is the third bucket of info. Looks like Tableau vs. AGO options so far.