Skip to main content
BelowGrid

Research

Where U.S. sewer lateral records actually are

The short answer

Cities publish their sewer pipes openly, as maps of mains and manholes. The certificates and inspections for a particular property usually sit in a permit portal behind a login — and often do not exist at all.

From a survey of 15 municipal open-data portals, run in August 2026. Two findings are worth knowing before you go looking for your own property’s records.

The California studies

Each authority describes only itself. These studies compare them, which is the part a homeowner cannot do from any single official page.

  • Ownership

    Is the sewer pipe under the street mine to fix?

    What it found: “Your sewer lateral is your responsibility” is the usual answer and it is wrong in some California cities, where the authority maintains the run to the sewer main — the expensive half.

    64 of 304 authorities take part of the lateral

    Most recent source check

    Who owns the pipe under the road

  • Assistance

    Will anyone help me pay for a sewer lateral repair?

    What it found: Grants, loans and rebates side by side — including which ones refuse anybody who is selling, which is the event most likely to have brought you here.

    Counted from the records on file as they stand when you open it.

    Who helps pay for a repair

  • Local rules

    Does the next city over ask for the same thing when I sell?

    What it found: A certificate issued under one city’s scheme is not the document the next city asks for, and the deadlines are not the same either.

    Counted from the records on file as they stand when you open it.

    How neighbouring cities differ

  • Two pipes

    Why is my water pipe someone else's when my sewer pipe is mine?

    What it found: The sewer lateral and the water service line leave the same building and answer to different authorities — who usually contradict each other about the run beneath the road.

    Counted from the records on file as they stand when you open it.

    Why your two pipes disagree

  • Water lines

    Does my water utility know what my service line is made of?

    What it found: Federal rules made every system inventory its service lines. Most of what is still unknown sits with a few utilities — and most of what is known was worked out from paperwork, building dates or a computer model, not by anyone digging down to look.

    929,761 of 10,101,290 service lines not yet identified

    Most recent source check

    Which water systems know what is buried

Where the records are held

A survey of 15 municipal open-data portals, run in August 2026.

Key figures

83sewer-related datasets
found across 15 municipal and county open-data portals, searched for sewer, lateral, wastewater and side-sewer terms.
1declares a licence
Exactly one of those 83 datasets states its reuse terms in its metadata. The rest are published without any machine-readable licence at all.
0jurisdictions cleared for automated reuse
Not because the terms are restrictive. Because in almost every case nobody has written down what the terms are.

Finding 1

Cities publish the pipes and keep the paperwork

Municipal open-data portals publish sewer infrastructure — mains, manholes, service areas — as map layers. They keep property-level lateral records, the certificates and inspections attached to a particular address, in permit portals behind a login.

Berkeley, California is the cleanest illustration. Berkeley regulates the lateral closely: a sewer lateral certificate is required before transfer of title, certificates transfer with the property, and they stay valid to their printed expiry. Berkeley’s open-data portal publishes sewer mains and manholes, last updated in October 2015. The certificates live in a login-gated portal with per-address search: each one can be looked up and linked to, but not downloaded as data.

Strong regulation, no open records. That pattern held across every jurisdiction examined.

Finding 2

The obstacle is licence review, not data availability

New York City publishes 113,795 rows of property-level sewer permits — of which 17,005 are distinct records, and 6,754 carry a complete borough-block-lot and can therefore be attributed to a parcel. It is the strongest source found anywhere in the survey.

Almost none of the 83 datasets found says what may be done with it. That is not the same as saying no: it means a human has to read the terms of use for each portal before anything can be published from it.

Data availability was never the binding constraint.

What this means if you are looking

Start with the ordinance, not the records. What your city requires is public and citable; the records proving a particular property complied usually sit in a permit portal behind a login, and often do not exist at all. Knowing the requirement tells you what to ask for, and who to ask.

Look up an address

Method, and how to check it

Fifteen Socrata and ArcGIS Hub portals were queried programmatically for sewer, lateral, wastewater and side-sewer terms. Every returned dataset was recorded with its declared licence field, its row count, and the date it was last updated. Four jurisdictions were then verified by hand against the city’s own published pages.

The NYC figures are counts from a full fetch of the DEP Water and Sewer Permits dataset, deduplicated on permit number and request status. The distinction between 113,795 rows and 17,005 distinct records matters: roughly 85% of the rows are byte-identical repeats.

Limitations

Fifteen portals is not a census of U.S. municipal open data. The survey covers portals with machine-readable catalogues, which biases towards larger cities; a city publishing sewer records as PDFs on a departmental page would not appear. Absence of a licence field does not mean reuse is prohibited — it means it is unstated.