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 <a href="https://data.cityofnewyork.us/dataset/Water-and-Sewer-Permits/hphy-6g7m">Water and Sewer Permits</a> dataset.
This dataset has the following 9 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| BOROUGH | borough | number | Numeric value representing a Borough Code. One value uniquely identifies each Borough in New York City. | 3 4 5 1 2 view top 100 |
| Borough Name | borough_name | text | Name of the Borough | BROOKLYN QUEENS STATEN ISLAND NEW YORK BRONX view top 100 |
| BLOCK | block | number | The Tax Block number assigned by the New York City Department of Finance. | 99999 4452 54 9998 4509 view top 100 |
| LOT | lot | number | The Tax Lot number assigned by the New York City Department of Finance. | 1 6 12 17 5 view top 100 |
| ZIP | zip | number | 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. | 112380000 103060000 111010000 112110000 103120000 view top 100 |
| SERV_ORDER_TYPE | serv_order_type | text | 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. | POTAP POSIN POSPL POSCA POSPR view top 100 |
| Permit Description | permit_description | text | A detailed description of the permit issued. | PERMIT-TAP SEWER PERMIT-INSTALL SEWER PERMIT-PLUG SEWER PERMIT-CTCH BASIN/MAN SEWER PERMIT-PRIVATE view top 100 |
| PERMIT_NO | permit_no | number | A system generated unique number assigned to each permit. | 913203 913636 913451 912973 912820 view top 100 |
| DATEISSUED | dateissued | calendar_date | The date the permit was issued. | 2018-02-09T00:00:00.000 2021-07-21T00:00:00.000 2018-07-17T00:00:00.000 2019-02-14T00:00:00.000 2019-03-18T00:00:00.000 view top 100 |