Lead Service Line Inventory Solution - Arcade Expression

ChrisMiller_AK — Wed, 19 Jul 2023 19:43:16 GMT

I'm trying to understand how the "assumed lead" category is assigned in the Public Web Map

The symbology expression is dependent on utilitystatus and custstatus is equal to 1.

What is "1" and where do find this. Is it just saying, "not null"? We can't make the map public if we can't explain it. 🙂 There's really no mention of "assumed lead" categories in the EPA Guidance documentation. Curious what the reasoning was to include this category in the solution.

"If the value of utilstatus is equal to 1 and the value of utilsource is "Installation record (e.g., tap card)," or if the value of custstatus is equal to 1 and the value of custsource is "Installation record (e.g., tap card)," then return "Lead."

If the value of utilstatus is equal to 1 and the value of utilsource is "Water sampling only with no records," or if the value of custstatus is equal to 1 and the value of custsource is "Water sampling only with no records," then return "Lead."

Re: Lead Service Line Inventory Solution - Arcade Expression

AlexKabak — Wed, 19 Jul 2023 20:29:44 GMT

Hi Chris,

The "1" you reference above is the coded value of "Lead" in the list of values for both the utilstatus and custstatus fields, which are the 2 fields representing the material classification of the utility side and customer side of the line. The utilsource and custsource fields represent the source of information (how the material was determined) of both sides of the service line.

The expression that powers the symbols, specifically the "Lead" and "Assumed Lead" categories, uses the material classification (in this case, Lead) and the source of information to determine whether or not the "Lead" classification is "known" or "assumed". The sources we chose for known are:

Installation record (e.g., tap card)
Water sampling only with no records
Field inspection only with no records
Service line repair or replacement record

The sources we chose for assumed are:

Statistical analysis
Previous materials evaluation
Installation date is after the lead ban
Service line diameter is greater than 2 inches
Other

We added "Assumed Lead" as a category until the material has been verified with one of the "known" values above. Some states may accept some of the "assumed" sources as a means of verification, and in that case the expression can be adjusted.

topic Lead Service Line Inventory Solution - Arcade Expression in Water Utilities Questions

Lead Service Line Inventory Solution - Arcade Expression

Re: Lead Service Line Inventory Solution - Arcade Expression