Baselight

NYC Cooling Tower System Inspection Results

City of New York

@usgov.city_of_new_york_nyc_cooling_tower_system_inspection_results

Loading...
Loading...

About this Dataset

NYC Cooling Tower System Inspection Results

This dataset includes cooling tower regulatory inspection results from the NYC Health Department’s Office of Building Water Systems Oversight (BWSO).

The dataset includes results from two inspection types: cycle or non-cycle. Cycle inspections are regular compliance inspections conducted by BWSO to confirm adherence with cooling tower regulations. Non-cycle may include follow-up inspections or other regulatory inspections to evaluate public health risks.Cooling tower systems that are compliant at the time of inspection have the inspection date with blank values for the violation and citation columns. Building owners that are subject to financial penalties for a cited violation receive a notice of violation with a summons number, as shown in the dataset. The Office of Administrative Trial and Hearings (OATH) adjudicates the summons.

Hearing status and adjudication result are shown separately in the Cooling Tower Hearings dataset (a subset of the OATH Hearings Division Case Status dataset). The summons number in this dataset corresponds with the ticket number field in the Cooling Towers Hearings dataset.
Organization: City of New York
Last updated: 2023-07-24T09:36:42.229484
Tags: building, cooling-tower, inspection

Tables

Table 1

@usgov.city_of_new_york_nyc_cooling_tower_system_inspection_results.table_1
  • 5.85 MB
  • 119,543 rows
  • 22 columns
Loading...
CREATE TABLE table_1 (
  "bin" BIGINT,
  "system_id" BIGINT,
  "address" VARCHAR,
  "borough" VARCHAR,
  "zip_code" VARCHAR,
  "status" VARCHAR,
  "active_equip" BIGINT,
  "inspection_date" TIMESTAMP,
  "violation_code" VARCHAR,
  "law_section" VARCHAR,
  "violation_text" VARCHAR,
  "violation_type" VARCHAR,
  "citation_text" VARCHAR,
  "summons_number" DOUBLE,
  "inspection_type" VARCHAR,
  "bbl" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "community_board" DOUBLE,
  "council_district" DOUBLE,
  "census_tract" DOUBLE,
  "nta_code" VARCHAR
);

Share link

Anyone who has the link will be able to view this.