nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Verwendung der Lead Service Line Inventory Lösung

MariahSalazar

Sehen Sie sich dieses Webinar an, um zu erfahren, wie die Lead Service Line Inventory Lösung Ihrer Organisation helfen kann, die bundesweiten Vorschriften der überarbeiteten Lead and Copper Rule (LCR) einzuhalten.

Die Lead Service Line Inventory Lösung von Esri ist kostenlos verfügbar und konfiguriert ArcGIS so, dass es den Herausforderungen der überarbeiteten Lead and Copper Rule gerecht wird. Organisationen können ArcGIS nutzen, um Bleileitungsbestände zu erstellen und zu pflegen, Materialüberprüfungen im Feld durchzuführen, Austauschaktivitäten zu verwalten, den Fortschritt zu überwachen und die Gemeinschaft zu informieren. Diese Lösung hilft Wasserversorgungsunternehmen, die öffentliche Gesundheit zu verbessern, indem sie das Risiko einer Bleiexposition in Trinkwasser verringert und die Einhaltung der überarbeiteten LCR sicherstellt.

Howard Crothers und Alex Kabak vom Esri-Lösungsteam zeigen, wie Sie mit der Lead Service Line Inventory Lösung starten können, einschließlich wie man

vorhandene Daten in die Lösung lädt.
Informationen zur Versorgungsleitung im Feld sammelt.
Austauschaktivitäten der Versorgungsleitungen koordiniert.
Dashboards erstellt, um den Fortschritt zu überwachen.
eine öffentlich zugängliche Website konfiguriert, um den Informationsaustausch mit der Gemeinschaft zu ermöglichen.

Besuchen Sie die Lead Service Line Inventory Lösung Webseite, um mehr zu erfahren.

Finde mehr Beiträge mit dem Tag

Water Distribution

Accepted answers

All comments

DanielWickens

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?

MattRingel

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"?

AlexKabak

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.

TimG_OWWSB

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.

AlexKabak

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.

Laura

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.

AlexKabak

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!

Laura

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.

bburrell

Alex,

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

AlexKabak

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

base.txt

QueryData.zip

bburrell

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.

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.