From a 500-row sample across 14 columns.
bblzipnta_code+4bbllatitudezip+2bbllatitudelongitude+1latitudecommunity_districtlongitudeMappable — coordinate pair `latitude` / `longitude`.
Open on the map →| permit_number | expiration_date | address_no | address_st | bo | zip | bbl | bin | census_tract_2010 | city_council_district | community_district | nta_code |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 40421713 | 2025-12-31T00:00:00.000 | 220-55 | 46 AVENUE | QUEENS | 11361 | 4074740050 | 4160990 | 147100 | 19 | 411 | QN46 |
| 40423200 | 2025-12-31T00:00:00.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
permit_number | text | Permit number | 0% | 404230614042225141309995 |
expiration_date | datetime | Date the permit expires; All permits for nonpotable wells expire yearly on December 31st. | 0% | 1996-12-31T00:00:00.0001989-12-31T00:00:00.0001985-12-31T00:00:00.000 |
address_no | text | Street number for the well location | 0% | 011184 |
address_st | text | Street name for the well location | 0% | BEACH 141 STREETFLATBUSH AVE |
GET /api/datasets/gnyq-kf2y GET /api/datasets/gnyq-kf2y/quality GET /api/datasets/gnyq-kf2y/related GET /api/columns?dataset=gnyq-kf2y
bbllatitudenta_code+2bbllatitudelongitude+1| 59-91 |
| MAURICE AVE |
| QUEENS |
| 11378 |
| 4026560098 |
| 4059712 |
| 22900 |
| 26 |
| 402 |
| QN99 |
| 40910824 | 2025-12-31T00:00:00.000 | 18-15 | 215 STREET | QUEENS | 11360 | 4059380007 | 4454676 | 99703 | 19 | 407 | QN47 |
| 40421976 | 2025-12-31T00:00:00.000 | 140-10 | CRONSTON AVE | QUEENS | 11694 | 4162520018 | 4305502 | 92200 | 32 | 414 | QN10 |
| 40897609 | 2025-12-31T00:00:00.000 | 83-03 | 24 AVENUE | QUEENS | 11370 | 4010780044 | 4023527 | 32900 | 22 | 403 | QN28 |
| 40423061 | 2025-12-31T00:00:00.000 | 2338 | BENSON AVENUE | BROOKLYN | 11214 | 3068740048 | 3185937 | 30200 | 43 | 311 | BK29 |
| 40422126 | 2025-12-31T00:00:00.000 | 2140 | 60 STREET | BROOKLYN | 11204 | 3055220021 | 3132325 | 24600 | 44 | 312 | BK88 |
| 40925931 | 2025-12-31T00:00:00.000 | 2355 | 62 STREET | BROOKLYN | 11204 | 3065560053 | 3172354 | 44600 | 44 | 311 | BK88 |
| 41223844 | 2025-12-31T00:00:00.000 | 260 | CLAWSON STREET | STATEN ISLAND | 10306 | 5036470032 | 5052826 | 12200 | 50 | 502 | SI45 |
| 50043948 | 2025-12-31T00:00:00.000 | 1003 | BANNER AVE | BROOKLYN | 11235 | 3087610001 | 3344605 | 60800 | 48 | 315 | BK17 |
Showing 12 of 14 columns. All of them are listed below.
NEWPORT AVEbo | categorical | Borough of the well location | 0% | BROOKLYNQUEENSSTATEN ISLANDof 6 |
zip | text | Zip code of the well location | 0% | 116941123411223 |
bbl | text | Borough-Block-Lot | 3% | 307392000130226800014105380070 |
bin | text | Building Identification Number | 3% | 300000040000003335470 |
census_tract_2010 | text | Census Tract | 1% | 922009280089200 |
city_council_district | integer | NYC Council District | 1% | 324650 |
community_district | integer | Community Board | 1% | 318315414 |
nta_code | text | Neighborhood Tabulation Area | 1% | QN10BK45BK17 |
latitude | float | Latitude | 1% | 40.7002356140.5762520140.88231964 |
longitude | float | Longitude | 1% | -73.94781435-73.95664819-73.82362506 |