idea Does ESRI's Lead Service Line Inventory solution match new EPA guidance? in ArcGIS Solutions Ideas

Does ESRI's Lead Service Line Inventory solution match new EPA guidance?

COSPNWGuy — Thu, 01 Sep 2022 19:22:52 GMT

On August 10th, EPA held a nationwide webinar on the lead and copper rule revisions (LCRR). Included was the data schema that should be followed. ESRI's solution looks close but is not the same. While the EPA does NOT require the exact schema be used, I think it would be a very good idea to. Please consider matching the EPA data schema in the solution. The schema presented is attached to this idea, or can be found on EPA's Lead and Copper page including a recording of the August 10th presentation. In the spreadsheet, the schema is on tab "Detailed Inventory". Since this is mandatory for every water provider with reporting deadlines, time is of the essence. Thanks.

Re: Does ESRI's Lead Service Line Inventory solution match new EPA guidance?

COSPNWGuy — Thu, 01 Sep 2022 19:21:54 GMT

Also attached is a comparison of the EPA documentation template with a comparison of schema from the ESRI L&C service line inventory Solution. The columns are the fields in the EPA template, and the rows represent the matching (or missing) ESRI field.

A Green cell indicates a matching cell in the ESRI schema (along with the field alias). A Red cell indicates no match in the ESRI schema, and a yellow cell indicates a sort-of match, where domain values or field intent don’t quite line up with the format the EPA recommends.

Re: Does ESRI's Lead Service Line Inventory solution match new EPA guidance? - Status changed to: In Product Plan

HowardCrothers — Fri, 02 Sep 2022 14:06:25 GMT

We are releasing an update to the Lead Service Line Inventory solution in November that will incorporate EPA's suggested schema into the solution. The schema changes will be minimal.

We are also exploring adding additional reporting capabilities to the solution to make it easier to populate the EPA template directly from ArcGIS as a means to report back your inventory to regulatory agencies.

Thanks for providing the comparison matrix.

Re: Does ESRI's Lead Service Line Inventory solution match new EPA guidance?

xander — Thu, 13 Oct 2022 10:55:41 GMT

@HowardCrothersHi Howard. Cleveland Water is looking to deploy. Any update on a release date or v2.0 docs? Thanks!

Re: Does ESRI's Lead Service Line Inventory solution match new EPA guidance?

HowardCrothers — Thu, 13 Oct 2022 12:59:09 GMT

@xander Development work is complete, we are doing final testing and working on the updated documentation now. The update will ship with the November 2022 ArcGIS Solutions release, anticipate week of the November 16th.

Re: Does ESRI's Lead Service Line Inventory solution match new EPA guidance?

xander — Thu, 13 Oct 2022 13:03:06 GMT

Thank you for the update. Any chance of getting a preview of the new schema?

Re: Does ESRI's Lead Service Line Inventory solution match new EPA guidance?

HowardCrothers — Thu, 13 Oct 2022 13:07:19 GMT

@xander Absolutely, I'll send you an email and we can set up a time.

Re: Does ESRI's Lead Service Line Inventory solution match new EPA guidance?

KadinBaird41 — Tue, 25 Oct 2022 19:37:00 GMT

@HowardCrothers I would love to get a preview of the new schema as well, we are just starting our inventory and would love to make sure we are using the most up to date solution. Also the reporting capabilities would be very useful as well. Thanks!

Re: Does ESRI's Lead Service Line Inventory solution match new EPA guidance?

ChrisMiller_AK — Wed, 26 Oct 2022 21:20:00 GMT

@HowardCrothers ditto on the new schema, please.

Re: Does ESRI's Lead Service Line Inventory solution match new EPA guidance?

HowardCrothers — Thu, 27 Oct 2022 15:08:03 GMT

@KadinBaird41 & @ChrisMiller_AK - sure we can give a preview. Can you message me your emails so we can setup something up?

Re: Does ESRI's Lead Service Line Inventory solution match new EPA guidance?

ChrisMiller_AK — Thu, 27 Oct 2022 19:11:18 GMT

@HowardCrothers I wish it was that easy...either our admin hasn't enabled the settings to allow PMs or I'm too stupid to find a way to send you a PM. Don't worry about it. Our management just decided to go with the GEC solution. Thanks for getting back to me.

Re: Does ESRI's Lead Service Line Inventory solution match new EPA guidance?

KadinBaird41 — Thu, 03 Nov 2022 21:03:13 GMT

@HowardCrothers I don't know if you have recieved my direct message, it's not showing up in my private conversations, but I am still interested in getting a look at the new schema.

Re: Does ESRI's Lead Service Line Inventory solution match new EPA guidance?

AyanPalit — Thu, 17 Nov 2022 12:12:44 GMT

Enhancement is now available in November 2022 release:

Lead Service Line Inventory

Release notes

Re: Does ESRI's Lead Service Line Inventory solution match new EPA guidance? - Status changed to: Implemented

HowardCrothers — Thu, 17 Nov 2022 14:36:10 GMT

Re: Does ESRI's Lead Service Line Inventory solution match new EPA guidance?

imansbburg — Tue, 29 Nov 2022 20:29:30 GMT

Could we possibly just get a FGDB schema for download to use with ArcGIS Pro 2.9 or earlier? I'm still weary to make the jump to ArcGIS Pro 3, and I still have team members using ArcMap as it is...

Re: Does ESRI's Lead Service Line Inventory solution match new EPA guidance?

JakeMatthys — Mon, 12 Dec 2022 18:29:58 GMT

@HowardCrothers @AyanPalit Hi Howard and Ayan,

Is there an ETA for when the updated Lead Service Line solution will be available ArcGIS Enterprise 10.9.1??

Re: Does ESRI's Lead Service Line Inventory solution match new EPA guidance?

HowardCrothers — Mon, 12 Dec 2022 21:42:31 GMT

@imansbburg If you need a FGDB schema of the latest update to the solution you can just deploy the solution again to ArcGIS Online and export the service to an FGDB. Exporting the service to an FGDB happens through ArcGIS Online and isn't Pro version specific.

Re: Does ESRI's Lead Service Line Inventory solution match new EPA guidance?

HowardCrothers — Mon, 12 Dec 2022 21:48:54 GMT

@jakemathis We can't make Version 3.0 of the Lead Service Line Inventory solution available on ArcGIS Enterprise 10.9.1. Version 3.0 is using some capabilities that are only available in Enterprise 11.0 and beyond.

Re: Does ESRI's Lead Service Line Inventory solution match new EPA guidance?

JakeMatthys — Tue, 13 Dec 2022 00:04:00 GMT

@HowardCrothers Thanks for the information Howard.

Re: Does ESRI's Lead Service Line Inventory solution match new EPA guidance?

imansbburg — Tue, 13 Dec 2022 15:01:15 GMT

Thank you. I did end up deploying the solution in AGOL because I was so curious to look at the feature service schema and setup. The deployment requirements said that ArcGIS Pro 3 was required, but I'm using 2.9.1....but am I understanding correctly there is no true restriction on Pro versions and only for Enterprise?