Water and Sewer Permits (Historic)
The DEP Application and Permit data will contain information about the different types of applications approved and permits issued on a regular basis. For the latest information, please refer to the Water and Sewer Permits dataset.
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.
Dormant
- Says it updates
- Historical data
- Actually updates about every
- —
- Publisher last updated the data
- Oct 5, 2021
Our mirror
Whether our copy of this data is current with the source.
In sync
- We last synced
- Oct 5, 2021, 11:52 AM
- Rows in our copy
- 37,685
- Rows at the source
- 37,685
- Our copy trails the source by
- under a minute
Columns
Each source column, with the name and type we use to store it.
1 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 |
|---|---|---|---|---|---|---|---|---|
borough_name | Borough Name | Name of the Borough | Not bound | Text | borough_name | text | — | |
serv_order_type | SERV_ORDER_TYPE | An acronym used to identify one or more permits. Sewer Connections Permit=POSIN=Permit filed by a Licensed Master Plumber to apply for a new house sewer connection. Sewer Plug Permit=POSPL=Permit filed by a Licensed Master Plumber to plug an existing sewer house connection. Water Service Plug Permit=POTAP=Permit filed by a Licensed Master Plumber to plug an existing water service line. Private Water Main Construction Permit= POTAP=Permit filed by the owner of a proposed private water main to obtain approval from DEP to build a private water main. Private Sewer Construction Permit=POSPR=Permit filed by the owner of a proposed private sewer to obtain approval from DEP to build a private sewer. Install Manhole Permit=POSCA=Permit filed by a Licensed Master Plumber or an approved contractor to install a manhole in a street. Seepage Basin Permit=POSCA=Permit filed by a Licensed Master Plumber or an approved contractor to install a seepage basin in a street. | Not bound | Text | serv_order_type | text | — | |
borough | BOROUGH | Numeric value representing a Borough Code. One value uniquely identifies each Borough in New York City. | boroughdeclared | Number | borough | numeric | — | |
dateissued | DATEISSUED | The date the permit was issued. | Not bound | Calendar date | dateissued | timestamp | — | |
permit_no | PERMIT_NO | A system generated unique number assigned to each permit. | Not bound | Number | permit_no | numeric | — | |
zip | ZIP | A group of nine numbers issued to a property by the USPS to assist in the sorting of mail and the location of a property. | Not bound |
Download
This file was produced on Aug 19, 2026, 10:00 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/4k4u-823g
- Version
- Content hash:
bac42a8d310d75e705c79c8950125b19ec6ea1a5382289639200fbb1216a71f5 - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Oct 5, 2021, 11:52 AM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Aug 3, 2026, 4:00 AM | full_replace | success | 37,685 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.31 |