Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

Water and Sewer Permits (Historic)

4k4u-823gEnvironment9 columns
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.
View on NYC Open Data↗

Quality

C78.0 / 100

From a 500-row sample across 9 columns.

completeness100/ 25% weight
consistency67/ 20% weight
accuracy98/ 20% weight
timeliness0/ 15% weight
usability100/ 20% weight
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • Water and Sewer Permits0.70
  • Watershed Water Quality Data0.33
  • Historic Land Use Data0.31
  • NYCDEP Recreation Area Maps0.31
  • Drinking Water Quality Distribution Monitoring Data0.31
  • New York City's Flood Vulnerability Index0.30
  • Local Law 84 Monthly Data (Calendar Year)0.29
  • New York City Climate Projections: Temperature and Precipitation

Geography

Has borough codes (`borough`) — joinable, but needs boundary shapes to draw.

Sample rows

boroughborough_nameblocklotzipserv_order_typepermit_descriptionpermit_nodateissued
1NEW YORK31100040000POSINSEWER PERMIT-INSTALL9262972021-07-15T00:00:00.000
1NEW YORK7314100020000POSPLSEWER PERMIT-PLUG925882

Columns

9 queryable · 9 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
boroughcategoricalNumeric value representing a Borough Code. One value uniquely identifies each Borough in New York City.0%345of 5
borough_namecategoricalName of the Borough0%BROOKLYNQUEENSSTATEN ISLANDof 11
blockintegerThe Tax Block number assigned by the New York City Department of Finance.0%99999445254
lotintegerThe Tax Lot number assigned by the New York City Department of Finance.0%16

Query this from your own app

GET /api/datasets/4k4u-823g
GET /api/datasets/4k4u-823g/quality
GET /api/datasets/4k4u-823g/related
GET /api/columns?dataset=4k4u-823g
0.29
2021-07-08T00:00:00.000
1NEW YORK17943100130000POSINSEWER PERMIT-INSTALL9263012021-07-15T00:00:00.000
1NEW YORK21824100130000POTAPPERMIT-TAP9255322021-07-01T00:00:00.000
1NEW YORK34675100020000POTAPPERMIT-TAP9275862021-07-30T00:00:00.000
1NEW YORK34675100020000POTAPPERMIT-TAP9275872021-07-30T00:00:00.000
1NEW YORK35064100020000POTAPPERMIT-TAP9258172021-07-08T00:00:00.000
1NEW YORK4239100020000POSINSEWER PERMIT-INSTALL9265872021-07-20T00:00:00.000
1NEW YORK42943100090000POTAPPERMIT-TAP9266772021-07-21T00:00:00.000
1NEW YORK4426100030000POSINSEWER PERMIT-INSTALL9275062021-07-29T00:00:00.000
12
zipintegerA group of nine numbers issued to a property by the USPS to assist in the sorting of mail and the location of a property.0%112380000103060000111010000
serv_order_typecategoricalAn 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 ob0%POTAPPOSINPOSPLof 5
permit_descriptioncategoricalA detailed description of the permit issued.0%PERMIT-TAPSEWER PERMIT-INSTALLSEWER PERMIT-PLUGof 9
permit_nointegerA system generated unique number assigned to each permit.0%913203913636913451
dateissueddatetimeThe date the permit was issued.0%2021-07-21T00:00:00.0002018-02-09T00:00:00.0002018-07-17T00:00:00.000