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
Visit the Lead Service Line Inventory solution web page to learn more.
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.
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
Alex,
I am just now seeing this. Thank you very much. I will be in touch if I have any additional questions.
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.
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.
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.
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:
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.
Hi Laura,
Is your diameter field a text/string field? If so, here are a couple of suggestions:
Hope this helps!