Lead Service Line Location Coordinates
The Department of Environmental Protection (DEP) is offering the following data to provide residents and property owners with information regarding their water service lines.
Open in the graph · Relate this dataset · What these columns mean
Freshness
The publisher's promise
How the agency that publishes this data says it keeps the data current.
Stale
- Says it updates
- Every 6 months
- Actually updates about every
- —
- Publisher last updated the data
- Jan 30, 2026
Our mirror
Whether our copy of this data is current with the source.
In sync
- We last synced
- Jan 30, 2026, 10:13 AM
- Rows in our copy
- 856,912
- Rows at the source
- 856,912
- Our copy trails the source by
- under a minute
Columns
Each source column, with the name and type we use to store it.
0 of 9 columns carry a concept; 9 carry a description from the publisher. Read the concept column before you join. A column with no concept carries no claim from us, and a name that looks like a key is not one.
| Source field | Display name | What the publisher says it is | Concept | Source type | Stored as | Stored type | Row identifier | Unit |
|---|---|---|---|---|---|---|---|---|
address | Address | An address for the tax lot | Not bound | Text | address | text | — | |
shape_leng | Shape Length | Length of feature in internal units | Not bound | Number | shape_leng | numeric | — | |
objectid | OBJECTID | Sequential unique whole numbers that are automatically generated | Not bound | Number | objectid | numeric | — | |
the_geom | the_geom | Geometry column used for mapping | Not bound | MultiPolygon | the_geom | jsonb | — | |
city_owned | City Owned | Identifies City Owned properties | Not bound | Text | city_owned | text | — | |
record_ty | Record Type | Record classification of last know record for property | Not bound | Text | record_ty | text | — | |
material | Material | Last known material category recorded for property | Not bound | Text | material | text | — | |
tbbl | BBL | A concatenation of the borough code, tax block and tax lot | Not bound | Text | tbbl | text | — | |
shape_area | Shape Area | Area of feature in internal units squared | Not bound |
Download
This file was produced on Aug 25, 2026, 10:08 PM.
Refresh this dataset
Source and attribution
Where this data comes from, which version we hold, and what we changed.
- Source
- https://data.cityofnewyork.us/d/jqfp-uff7
- Version
- Content hash:
df8efa16d90c8a16034ec47f987bad936aaf63caae9fcf75d9ed395ce98b42be - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Jan 30, 2026, 10:13 AM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Aug 24, 2026, 2:46 PM | full_replace | success | 856,912 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.68 |