From a 500-row sample across 22 columns.
community_boardinspection_dateinspection_type+5longitudeboroughcommunity_board+6longitudeboroughlatitude+2longitudeboroughcommunity_board+6Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| bin | system_id | address | borough | zip_code | status | active_equip | inspection_date | violation_code | law_section | violation_text | violation_type |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1015834 | 2000000122 | 1271 BROADWAY | Manhattan | 10001 | Inactive | 0 | 2021-05-21T00:00:00.000 | AH8U | 24 RCNY §8-05(f)(5) | Required corrective actions not taken based on bacteriological results | PHH |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
bin | text | Department of Buildings (DOB) Building Identification Number | 0% | 100219230000001012541 |
system_id | text | Unique NYC Cooling Tower System Identification Number | 0% | 200001020120000139482000004143 |
address | text | Street name and street number of the physical location of the cooling tower system | 0% | 32 6TH AVE75 9TH AVE225 BROADWAY |
borough | categorical | Borough of the physical location of the cooling tower system | 0% | ManhattanBrooklyn |
GET /api/datasets/f9wb-g8mb GET /api/datasets/f9wb-g8mb/quality GET /api/datasets/f9wb-g8mb/related GET /api/columns?dataset=f9wb-g8mb
longitudecommunity_boardcensus_tract+4longitudeboroughcommunity_board+6longitudeboroughcommunity_board+6longitudeboroughcommunity_board+8| 1015834 |
| 2000000122 |
| 1271 BROADWAY |
| Manhattan |
| 10001 |
| Inactive |
| 0 |
| 2021-05-21T00:00:00.000 |
| AH8C |
| 24 RCNY §8-04(a) |
| Routine monitoring not conducted, documented at least once a week when tower is in use |
| Critical |
| 1015834 | 2000000122 | 1271 BROADWAY | Manhattan | 10001 | Inactive | 0 | 2021-05-21T00:00:00.000 | AH8D | 24 RCNY §8-04(b) | Compliance inspections not conducted, documented at least once every 90 days when the tower is in use | Critical |
| 1015834 | 2000000122 | 1271 BROADWAY | Manhattan | 10001 | Inactive | 0 | 2021-05-21T00:00:00.000 | AH8E | 24 RCNY §8-04(c) | Routine maintenance according to Maintenance Program and Plan not conducted or documented | General |
| 1015834 | 2000000122 | 1271 BROADWAY | Manhattan | 10001 | Inactive | 0 | 2021-05-21T00:00:00.000 | AH8L | 24 RCNY §8-05(c)(3) | No records of all chemicals and biocides (C&B) added | Critical |
| 1015834 | 2000000122 | 1271 BROADWAY | Manhattan | 10001 | Inactive | 0 | 2021-05-21T00:00:00.000 | AH8M | 24 RCNY §8-05(c)(4) | Sufficient quantities and combinations of chemicals not added as specified in the maintenance program and plan | General |
| 1015834 | 2000000122 | 1271 BROADWAY | Manhattan | 10001 | Inactive | 0 | 2021-05-21T00:00:00.000 | AH8Q | 24 RCNY §8-05(f)(1) | Minimum daily water quality measurements not taken or recorded (or if automated, not viewable) | General |
| 1015834 | 2000000122 | 1271 BROADWAY | Manhattan | 10001 | Inactive | 0 | 2021-05-21T00:00:00.000 | AH8S | 24 RCNY §8-05(f)(3) | Legionella samples not collected or analyzed, or results not recorded or reported to DOHMH as required | PHH |
| 1015834 | 2000000122 | 1271 BROADWAY | Manhattan | 10001 | Inactive | 0 | 2021-05-21T00:00:00.000 | AH8V | 24 RCNY §8-06(a) | Improper or inadequate shutdown procedures | General |
| 1015834 | 2000000122 | 1271 BROADWAY | Manhattan | 10001 | Inactive | 0 | 2020-02-25T00:00:00.000 | AH8C | 24 RCNY §8-04(a) | Routine monitoring not conducted, documented at least once a week when tower is in use | Critical |
Showing 12 of 22 columns. All of them are listed below.
Queenszip_code | text | ZIP code of the physical location of the cooling tower system | 0% | 100191002210013 |
status | categorical | Registration status of the cooling tower system | 0% | ActiveInactiveof 2 |
active_equip | categorical | Number of active cooling tower equipment associated with the cooling tower system at the time of publication | 0% | 102of 11 |
inspection_date | datetime | Cooling tower system inspection date | 0% | 2017-01-26T00:00:00.0002017-04-06T00:00:00.0002017-02-28T00:00:00.000 |
violation_code | text | OATH (Office of Administrative Trials and Hearings) Code | 28% | AH8SAH8LAH8E |
law_section | text | Section/Rule of Law of Violation | 28% | 24 RCNY §8-05(f)(3)24 RCNY §8-05(c)(3)24 RCNY §8-04(c) |
violation_text | text | Description of Violation | 28% | No records of all chemic…Legionella samples not c…Routine maintenance acco… |
violation_type | categorical | Health Hazard Category of Violation | 28% | CriticalGeneralPHHof 3 |
citation_text | text | Details of the Violation | 28% | Records reviewed at time…Operational records prov…Chemical and biocide rec… |
summons_number | text | Summons or Ticket Number for OATH hearing at ECB (Environmental Control Board) | 55% | 088094719208809472100880947220 |
inspection_type | categorical | Type of inspection conducted | 0% | CycleNon-Cycleof 2 |
bbl | text | Borough Block Lot | 0% | 100192000110071300011000880018 |
latitude | float | Latitude of the location of the building having the cooling tower | 0% | 40.72007340.71199140.742551 |
longitude | float | Longitude of the location of the building having the cooling tower | 0% | -74.004636-74.008653-74.006055 |
community_board | text | Community Board of the location of the building having the cooling tower | 1% | 105108101 |
council_district | text | Council District of the location of the building having the cooling tower | 1% | 431 |
census_tract | text | The 2020 Census Tract of the location of the building having the cooling tower | 0% | 002100000900013700 |
nta_code | text | NTA (Neighborhood Tabulation Area) code of the location of the building having the cooling tower | 0% | MN0502MN0501MN0101 |