Use Lead Service Line Inventory

The Lead Service Line Inventory solution delivers a set of capabilities that help you inventory lead service lines, validate service line materials in the field, monitor replacement activities and regulatory compliance, and share information with the public.

Understand service line symbology

Lead Service Line Inventory has been created with multiattribute symbology to display both utility-owned and customer-owned service line information. The left side of the symbol always represents a utility-owned service line and the right side represents a customer-owned service line. This symbology cannot be easily changed once the solution is deployed and is best left as designed. The symbology is broken down into four color categories that represent the lead service line status.

The lead status categories are as follows:

  • Red—Lead
  • Yellow—Galvanized Requiring Replacement
  • Blue—Non-Lead
  • Gray—Unknown

The legend includes the combinations of all of these options as shown in the image below.

Utility Side | Customer Side symbology

In addition to the multiattribute symbology, the lead service line point includes a label that identifies unverified lead service lines with a dot. The dot will be located on either the utility side, the customer side, or both sides of the symbol depending on whether the service lines have been verified in the field. The image below shows the various configurations of unverified lead service line points.

Overview of symbols and labels for Utility Side | Customer side symbol

Develop service line inventory

Water utilities are tasked with completing an inventory of their water systems to ensure there are no lead pipes present in their systems. These workflows provide various ways to collect and document the lead service line information.

Add lead service line points

Lead information can be stored in various forms, such as tap cards, paper maps, or other digital assets. These sources of information should be added to a single repository to ensure a complete inventory of lead service lines can be maintained.

As an editor, you want to use a web app to add lead service line status information to the map.

  1. In a browser, sign in to your ArcGIS organization.
  2. At the top of the site, click Groups.
  3. Browse to the Lead Service Line Editors group and locate the Lead Service Line Editor app. Click View Application to launch the app.

    In the Lead Service Line Editor app, the Smart Editor widget is open by default on the left side of the window.

  4. In the editing pane, click a template from the list of options to select it.
  5. With a point selected, click to add the point to the map.
  6. You are prompted to update attributes and click Save.
  7. Continue adding Utility Side and Customer Side points, as needed.

In the workflow below, you will be taking the role of an editor adding data in ArcGIS Pro. The workflow below can be completed in either the web or desktop environments, but if additional editing tasks need to be completed, such as loading data or conducting advanced analyses, ArcGIS Pro provides a more powerful environment to do this work.

Note:

The first time you open the Lead Service Line Editor map in ArcGIS Pro, the layers will show as broken. Follow the steps to Configure the Lead Service Line Editor ArcGIS Pro project to fix your layers.

  1. Open the Lead Service Line Inventory ArcGIS Pro project and sign in to your ArcGIS organization.
  2. In the Catalog pane, expand Maps and double-click Lead Service Line Editor to open the map.
  3. On the Edit tab, in the Snapping group, click Snapping and turn snapping on.
  4. On the Edit tab, in the Features group, click Create.

    The Create Features pane appears.

  5. Click a template to select it and add it to the correct location on the map.
  6. On the Map tab, in the Selection group, click Attributes and fill in the remaining attributes.
  7. Repeat the steps above to add new lead service line points to the map.
  8. On the Edit tab, in the Manage Edits group, click Save to save your edits.

Conduct field inventory

In many cases, a field assessment of existing service line assets may be the most efficient way to develop a lead service line inventory. The information collected in the field can then be used to inform service line replacement and maintenance programs.

You will assume the role of a field technician in a water utility. In this workflow, you will use ArcGIS Field Maps to collect lead service line information.

  1. Open the ArcGIS Field Maps app and sign in to your ArcGIS organization.
  2. Open the Lead Service Line Editor map.
  3. Browse to the collection location.
  4. Tap Add Add.
  5. From the list of features, add a feature from the template list of Utility Side and Customer Side values.
    If the point is added to the wrong location, or you want to move the point manually, move the crosshairs to the correct location by panning the map and tapping Update Point. This moves the added point to the specified location.
  6. Fill in any attributes and tap Submit.

    Ensure the following attributes are filled out for both utility and customer sides, as they drive some of the dashboard indicators.

    • Install Date
    • Side Verified
    • Source
    • Status
    • Reason for Replacement

Manage service line replacement

Water utilities need an inventory of their assets in order to proceed with lead mitigation efforts. Managers need to have a clear understanding of what service lines are at risk for lead, whether lines have been inspected by field technicians, or if they have been replaced due to lead.

You will assume the role of a manager in a water utility. In this workflow, you want to use a web app to update common replacement fields such as Replacement Status, Scheduled Replacement Date, and Reason for Replacement.

  1. In a browser, sign in to your ArcGIS organization.
  2. At the top of the site, click Groups.
  3. Browse to the Lead Service Line Editors group and locate the Lead Service Line Replacement Manager app. Click View Application to launch the app.

    In the upper right of the app, there are a number of widgets that can be used to view the legend, update the basemap, or print the map. The panel on the left side of the app includes a set of options to filter the lead service line points by replacement status and lead categories.

  4. Review the list of included widgets to learn how to use them to update and review lead service replacement status:
    • Filter—Use the Replacement Status and Lead Categories filters to view properties where service lines need replacement or by material category. Select an option from the drop-drown menu and turn on a filter to view the selection in the map.
    • Batch Attribute Editor—Select a group of lead service line points using one of the selection tools and update values for all the selected features at once.
    • Legend—View the included layer in the map. The legend displays what is visible on the map, so zooming in or out can expand or reduce the list if scale suppression is set on the layers.
    • Layer List—View a list of included layers with some additional capabilities to manipulate the layers.
    • Basemap Gallery—Choose to update the basemap for the app.
    • Print—Use the print widget to save an image or PDF of the map.

Monitor inventory and replacement

Understanding how many lead service lines there are and progress on replacing identified lead service lines is important information that needs to be readily accessible. It may also be necessary to provide to regulators, so it is helpful to have a quick view of important metrics. Having a quick view of all of the key metrics related to lead service lines allows executives and managers to gain an understanding of their water system and lead mitigation efforts.

As a member of the utility, you want to have a comprehensive view of lead service lines in the water system. The dashboard includes a mix of charts, gauges, and elements to report on the status of lead in the water system.

  1. Browse to the Lead Service Line Office Viewers group and locate the Lead Service Line Dashboard app. Click View Dashboard to launch the dashboard.
  2. Review the brief descriptions of the included indicators to learn more about them.
    • Lead and Unknown Service Lines—The gauge represents the combined total of lead and unknown service lines. According to the Lead and Copper Rule Revisions, service lines with unknown materials are classified as lead service lines unless evidence proves otherwise. The number in red represents the combined total of lead and unknown service lines, and the number in white represents the total number of service lines in your water system.
    • Unverified Service Lines—The indicator represents the total number of service lines with unverified materials.
    • Unknown Service Lines - Total—The indicator represents the total number of service lines with an unknown lead category.
    • Replaced Lead Service Lines - 2 Year Average—The indicator represents a percentage of the lead service lines replaced over the previous two years. According to the Lead and Copper Rule Revisions, water systems will be required to fully replace at least 3 percent of lead service lines each year when 10 percent of sampling results are above 15 parts per billion.
    • Replaced Lead Service Lines—The indicator represents the total number of lead service lines that have been replaced.

    The following table shows which fields are being used to drive the results of this element. These must be fully filled in to accurately show the lead service line information.

    Element nameFields used

    Lead and Unknown Service Lines

    Utility Status, Customer Status

    Unverified Service Lines

    Utility Side Verified, Customer Side Verified

    Unknown Service Lines

    Utility Status, Customer Status

    Unknown Service Lines - Total

    Replacement Status, Reason for Replacement

    Unknown Service Lines - 2 Year Average

    Utility Install Date, Customer Install Date, Replacement Status, Reason for Replacement, Utility Status, Customer Status

Locate service line information

Communicating lead service line information helps residents locate their properties and allows them to learn if their property may be affected by lead. The Lead-Safe Community site can be used to communicate lead service line information to residents of the community.

You will assume the role of a resident or member of the public. In this workflow, you are interested in locating a given address to find more information about lead service lines.

  1. In a browser, go to the Lead-Safe Community site.
  2. Scroll to the Lead Service Line Map section.
  3. In the app, use the Search text box to enter an address and click Enter.

    You see suggestions as you type and are able to choose the address from the search results.

  4. If a Lead Service Line point exists at the property, click the point to view a pop-up with more information.