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.

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.

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 Service Line 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 Features group, click Create.

   The Create Features pane appears.

4. Click a template to select it and add it to the correct location on the map.
5. On the Map tab, in the Selection group, click Attributes and fill in the remaining attributes.
6. Repeat the steps above to add new lead service line points to the map.
7. 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 mobile worker 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 Field Map.
3. Browse to the collection location.
4. Tap Add .
5. From the list of features, add a feature from the template list of Service Line 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, as they drive some of the dashboard indicators.

   • Entire Service Line Status
   • Utility Side Verified, Customer Side Verified
   • Replacement Status

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 presence 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—The indicator represents the total number of lead service lines.
   • Galvanized—The indicator represents the total number of galvanized service lines requiring replacement.
   • Non-Lead—The indicator represents the total number of non-lead service lines.
   • Unknown—The indicator represents the total number of unknown service lines.
   • Verified Service Lines—The gauge represents the total number of verified service lines. The number in the middle of the gauge represents the number of verified service line and the number at the end of the gauge represents the total number of service lines in the system.
   • Replaced—The indicator represents the total number of replaced lead service lines.
   • Lead Service Line Inventory Table—The table contains all of the fields from the EPA's template for reporting a lead service line inventory.
   • Lead Service Line Inventory Map—The map contains the service lines represented as a point. The list on the right contains lead service lines. Clicking a lead service line in the list will pan the map to its location.

   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 name	Fields used
Lead	Entire Service Line Status
Galvanized	Entire Service Line Status
Non-Lead	Entire Service Line Status
Unknown	Entire Service Line Status
Verified Service Lines	Utility Side Verified, Customer Side Verified
Replaced	Replacement Status

Export service line data

As the lead compliance manager, I need to report the water system's service line inventory to comply with regulations.

1. Verify that you are signed in to your ArcGIS organization and browse to the ServiceLine_reporting service.
2. Click the Export Data drop-down and select Export to CSV file.
3. Update the Title and click Export. It may take a few seconds to complete the export.
4. Click Download.

   The csv with the service line data downloads to a .CSV file.

5. Optionally, after exporting to the CSV copy and paste the data into the EPA's Inventory Template. The fields, field order, and values are identical to those found in the template. Ignore the last 4 fields of the export (globalid, objectid, x, y).

Engage the public

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 in the community. It also includes a link to the Water Service Line Material Survey which allows residents to report the material of their water service lines, allowing water utilities to better understand their water systems and make improvements to eliminate lead pipes within their water systems.

Locate service line information

You will assume the role of a resident or member of the public. In this workflow, you are interested in locating an 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.

   Suggestions are presented as you type and you 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.

Submit a water service line material survey

You will assume the role of a resident who is interested in submitting water line material information for their property.

1. In a browser, go to the Lead-Safe Community site.
2. Click the Water Service Line Material Survey link to open the survey.
3. In the Water Service Line Material Survey form, enter your personal information, water service line information and a photo of your water line service.
4. Click Submit, to submit your survey.

Manage water service line surveys

As water utilities work to eliminate all lead in their water lines, they need the help of the public to report their water line service material to aid in this effort. Water utilities need to complete a full inventory of their system and public surveys can ensure that utilities are capturing possible lead service line locations. This information can help water utilities organize lead replacement campaigns and plan service line replacement.

You will assume the role of a manager tasked with managing and reviewing water service line surveys.

1. In a browser, go to the Service Line Self-Assessment Manager app.

   The app opens and shows a list of surveys as well as a map and a panel to view additional survey details.

2. Scroll to the right and click the Status column filter.
3. Click the Status is drop-down arrow and choose Submitted to view surveys which have not been reviewed.
4. Click one of the surveys to view its details.
5. On the Details tab, click the Edit button .
6. Click the Status drop-down arrow and choose Received.
7. Click Save.
8. In a browser, go to the Service Line Self-Assessment Dashboard app.
9. Use the filters in the dashboard header to explore the survey information and as well as the indicators on the map to view a specific survey details.

   Dashboard charts are linked. As you click and select a category in one chart, related details are filtered and updated in other charts.