topic Re: Using the Lead Service Line Inventory Solution in Water Utilities Videos

Using the Lead Service Line Inventory Solution

MariahSalazar — Sun, 10 Oct 2021 19:12:49 GMT

Watch this webinar to learn how the Lead Service Line Inventory solution can help your organization meet the federal regulations of the revised Lead and Copper Rule (LCR).

Esri’s Lead Service Line Inventory solution is available at no cost and configures ArcGIS to meet the challenges of the revised Lead and Copper Rule. Organizations can use ArcGIS to create and maintain lead service inventories, conduct material verifications in the field, manage replacement activities, monitor progress, and inform the community. This solution helps water utilities improve public health by reducing the potential of community exposure to lead in drinking water and maintaining compliance with the revised LCR.

Howard Crothers and Alex Kabak from Esri’s solutions team demonstrate how you can get started with the Lead Service Line Inventory solution, including how to

Load existing data into the solution.
Collect service line information in the field.
Coordinate service line replacement activities.
Create dashboards to monitor progress.
Configure a public-facing website to enable information sharing with the community.

Visit the Lead Service Line Inventory solution web page to learn more.

Re: Using the Lead Service Line Inventory Solution

bburrell — Thu, 29 Dec 2022 15:53:05 GMT

Is there anyway to share the notepad++ document with all the If, then statements? The video does pretty good at laying everything out, but looking for details on the dlt step and python script.

Re: Using the Lead Service Line Inventory Solution

AlexKabak — Tue, 03 Jan 2023 16:08:57 GMT

Hi @bburrell ,

I have attached the base.py file shared in the video as a .txt file as .py files are not supported as attachments here. Please let me know if you have any questions.

Thanks,

Alex

Re: Using the Lead Service Line Inventory Solution

bburrell — Thu, 19 Jan 2023 18:27:30 GMT

Alex,

I am just now seeing this. Thank you very much. I will be in touch if I have any additional questions.

Re: Using the Lead Service Line Inventory Solution

Laura — Tue, 15 Aug 2023 21:37:02 GMT

I'm trying to populate data into the diameter field however it will not accept the inch character amd will therfore not append and update.

Re: Using the Lead Service Line Inventory Solution

AlexKabak — Wed, 16 Aug 2023 19:51:58 GMT

Hi Laura,

Is your diameter field a text/string field? If so, here are a couple of suggestions:

Try removing the inch character. The diameter fields of Lead Service Line Inventory are Double fields, and will not accept text characters.
Try using the Data Loading Tools instead of Append. Data Loading Tools will allow you to load data from a text/string field to a double field. Here is a link to the Data Loading Tools documentation. And here is a link to help with the toolbox installation

Hope this helps!

Re: Using the Lead Service Line Inventory Solution

Laura — Wed, 16 Aug 2023 20:13:04 GMT

removing it worked! However, when trying to push my edits back to AGOL each time I get the request timed out error. I am not trying without the enable undo button enabled, but it seems to be taking quite a while.

Re: Using the Lead Service Line Inventory Solution

AlexKabak — Mon, 21 Aug 2023 14:33:24 GMT

Hi Laura,

Enable Undo doesn't work with a feature service because turning that button on starts an edit session and Calculate Field doesn't work with a feature service in an edit session.

Are you running Calculate Field without the Enable Undo button turned on? I have tested it on my end and can't reproduce your issue. I ran Calculate Field on the diameter field and it hangs up on 5% for about 10 seconds but then finishes successfully. This is with 7250 records.

Re: Using the Lead Service Line Inventory Solution

Laura — Mon, 21 Aug 2023 14:34:47 GMT

It works without the enable undo button. However, I added in quite a few fields. Each field is taking approximate an hour and a half to calculate with up to 14.4k records.

Re: Using the Lead Service Line Inventory Solution

AlexKabak — Mon, 21 Aug 2023 15:26:25 GMT

Is this a field calculation or are you doing an append? Using the Append tool with feature services can take a while.

Re: Using the Lead Service Line Inventory Solution

Laura — Mon, 21 Aug 2023 15:27:04 GMT

calculation

Re: Using the Lead Service Line Inventory Solution

TimG_OWWSB — Wed, 23 Aug 2023 12:07:56 GMT

I have watched the video a few times now, and even with this text document, I'm missing how it's actually implemented into the Excel file.

Also, when I run the DLT, it doesn't create the blue Field Worksheets for me. I've redone the entire process a few times to make sure I didn't miss anything, and I still have the same results.

Re: Using the Lead Service Line Inventory Solution

AlexKabak — Wed, 23 Aug 2023 13:23:17 GMT

In the base.py (which is located in the Scripts folder of the DataLoadingWorkspace), one of the functions is defined as "calculate_utility_status(MATERIAL_UTIL,INSTALLDATE_UTIL,RESYRBLT)".

In the Expression column of the Utility Status field in the Excel file, reference the function by adding "calculate_utility_status(!MATERIAL_UTIL!,!INSTALLDATE_UTIL!,!RESYRBLT!)"

They are nearly the same except in the excel file function the fields are wrapped in "!". Repeat these steps for Customer Status, Utility Source, and Customer Source fields. When the Execute Data Load tool runs, it knows to look for the specified functions in the base.py file and will apply the logic.

As for the blue tabs, there need to be domains in the source database fields to compare against the target database field domains. Please ensure domains are assigned to the fields in your source database. If you are running the Spatial Join tool, the domains get dropped from the result, so you will need to manually add them back before running Create Data Loading Workspace.

Re: Using the Lead Service Line Inventory Solution

MattRingel — Tue, 28 Nov 2023 01:16:48 GMT

Hi, at 37:05 in the video you show your "Create Data Loading Workspace" tool where the target is the hosted feature service using the url. When I try to put in a url for target it gives me an error of "000840: The value is not a Data Element"

I'm using dltsolutions version 2.9.2 which seems to be newer than the version in the video.

How can I use a hosted feature service as the target for "Create Data Loading Workspace"?

Re: Using the Lead Service Line Inventory Solution

SarahRowley — Tue, 12 Dec 2023 20:58:22 GMT

Alex, can you please expand on how the blue tabs are created? What if there are no domains in the source database? Like TimG, I've watched this multiple times, but I'm missing how to get from loading the data, adding the expressions you've mentioned to the excel file and where the blue tabs are created.

Re: Using the Lead Service Line Inventory Solution

AlexKabak — Thu, 14 Dec 2023 21:09:05 GMT

The blue tabs are designed to map values in source coded value domains to values in a target coded value domains. This is especially useful when the values are different or different field types. If your source data doesn't have coded value domains assigned to fields, the blue tabs do not get created.

There are a couple of options to still map your data to the solution:

Create domains in your source data and assign them to fields. This will automatically create the blue tabs when running the Create Data Loading Workspace tool.
Manually create the blue tabs (they don't have to be blue).
- Name the blue tab the name of your source field.
- In column A of the blue tab add the target values from the field in the solution.
- In column B, add the source values. Ensure the title of columns A and B are not the same.
- In the mapping tab find the target field. In the LookupSheet column add the name of the blue tab, in the LookupKeys column add the title of column A from the lookup sheet, and in the LookupValue column add the title of column B from the lookup sheet.
- If you have values in the Lookup columns, the Expression column for that field needs to be empty.

Re: Using the Lead Service Line Inventory Solution

DanielWickens — Fri, 16 Feb 2024 17:36:00 GMT

Matt,

That error appears when the hosted feature layer has been added to the map in ArcGIS Pro. Can you remove it from the map, and try adding the feature layer from the Catalog > Portal when setting it as the target?