Lead service line inventory

Map your lead service lines for residents.

Attach your service line inventory. You get a map residents can search by address, with every line coloured by lead status, and a count of each group.

Free to start. Reports on a paid seat.

Or ask for
Highland Park Water Service Line Inventory
A satellite photo of residential blocks in Highland Park, Michigan, with every water service line drawn as a short stroke from the street to the house, coloured orange for presumed lead, red for known lead and green for non-lead or already replaced. Orange fills the blocks to the north and east, with red strokes among them; green gathers in the blocks to the south-west.
Lead statusService lines
Presumed lead2,535
Known lead292
Non-lead or already replaced686

Of 3,513 lines. Residents find their own by searching the address.

Every water service line in Highland Park, Michigan, coloured by lead status, with its address in the pop-up.

For whoever answers for the lead lines

The inventory exists.Residents want to know about their own line.

The state wants the numbers.

Under the federal Lead and Copper Rule Revisions, water systems keep an inventory of their service lines, the pipes from the water main into each building, and make it public.

Here you attach the file you already publish. Mapstack makes the map residents search and the counts the state asks for, and reads the file closely enough to say where it would mislead.

One real inventory

Every service line in Highland Park, counted for the state

The City of Highland Park, Michigan, published its inventory in October 2024 for the state and federal lead rules: each line from the main to the house, with its materials, its status and its replacement dates.

Lead or presumed lead
80.5%of the lines, all marked as needing replacement
Checked in the field
282of the known lead lines; the rest are known from other records
Kept out
210inspection dates sitting in the replacement-date columns
Lead statusShare of lines
Presumed lead72.2%
Non-lead or already replaced19.5%
Known lead8.3%

It checks the dates before it counts them.

Asked for the lines replaced each year, Mapstack found 210 lines still marked as needing replacement with dates from a 2023 inspection project in the replacement-date columns. Counted as they stood, they would have passed for replacements and overstated progress. It kept them out, showed them apart as inspections, and said why.

City of Highland Park, Michigan, Service Line Inventory, October 2024, from the Detroit Data portal. Run on 15 November 2026.

From the inventory you publish to a map and a count

What you bring
Service line inventory

Columns: Address (the building it serves), Material (lead, copper and others), Federal class (lead or not), Status (to replace or not), Replaced (a date for each side), Project (the scheme). 3,513 rows. Here each line comes drawn from the main to the house. A list of addresses works too: each is found and placed.

What you get

  • A map of every line, coloured by lead status, for residents to search.
  • A count of each group, with the rule used for each.
  • Replacements by year, from the file’s own dates, with inspections kept apart.
  • What would throw the counts off, from spellings that differ to columns left empty.

Write it up for residents and the state at once

One more request turns the findings into a report.

It closes with a line for both readers: a service-line classification is not a tap-water test result.

Make that into a short report we can publish for residents and attach to our submission to the state: the map, the counts for each group, a chart of lead lines replaced each year, how you counted, and the caveats about the data.

A report with the map, the table of the three groups, a chart of replacements by year with the inspections shown apart, the method and the caveats, ready to publish or to download as a PDF or Word document.

How it goes

You bring the inventory. Mapstack makes the map and the count.

  1. Attach the inventory and say who the map is for.

  2. Mapstack maps every line and counts each group.

  3. You get how each group was counted.

Common questions

What happens to our inventory?

  • It stays in your workspace. Only people with a seat in your workspace can see it. Nothing leaves unless you publish it yourself.

  • It is not used to train AI. Your data and your conversations are not used to train AI models.

  • It is still yours. You keep ownership of what you bring in. Delete it and it is removed.

The full answer is in the documentation: Your data, privacy and security.

What does it cost?

  • Free to start. One seat, for you, with a starter amount of work each month. No card.

  • The map, the counts and the checks are on the free seat. With your own files and public sharing.

  • The written report is on a paid seat. Paid seats are per person, and bring more work each month.

The prices are on the pricing page.

What can residents do with the map?

  • Find their own line. Search by street address and the map goes to it.

  • See what it is made of. The pop-up gives the material on the city side and the home side, and whether it needs replacing.

  • Open it from one link. Publish the map and share the link.

Map yours.

Free to start. Reports on a paid seat.