Water — Use and Intensity

Total, indoor, outdoor, and municipal water use.

Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability

9 rows where Borough = "BRONX" and Property Type = "Prison/Incarceration" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Property ID, Property Name, Address 1, Floor Area (ft2), Total Water Use (kgal), Indoor Water Use (kgal), Municipal Indoor Water (kgal)

Calendar Year 9

Property Type 1

  • Prison/Incarceration · 9 ✖

Borough 1

  • BRONX · 9 ✖
Link rowid Calendar Year ▲ Property ID Property Name Borough Address 1 Property Type Floor Area (ft2) Total Water Use (kgal) Indoor Water Use (kgal) Outdoor Water Use (kgal) Municipal Indoor Water (kgal) Municipal Outdoor Water (kgal) Municipal Mixed Water (kgal) Indoor Water Intensity (gal/ft2)
328417 328417 2024 21355087 ACS_47_Horizon Juvenile Center BRONX 560 Brook Ave Prison/Incarceration 97,095 0.0 0.0 0.0 0.0 0.0 0.0  
295009 295009 2023 21355087 ACS_47_Horizon Juvenile Center BRONX 560 Brook Ave Prison/Incarceration 210,444 2610.0 2610.0 0.0 2610.0 0.0 0.0  
270908 270908 2022 21355087 ACS_47_Horizon Juvenile Center BRONX 560 Brook Ave Prison/Incarceration 210,444 2980.0 2980.0 0.0 2980.0 0.0 0.0  
223288 223288 2021 21355087 ACS_47_Horizon Juvenile Center BRONX 560 Brook Ave Prison/Incarceration 210,444 612.7 612.7 0.0 612.7 0.0 0.0  
170199 170199 2019 6293890 ACS - 2000133 - Horizon Juvenile Center (LL84) BRONX 560 Brook Ave Prison/Incarceration 210,444 24373.1 24373.1 0.0 24373.1 0.0 0.0  
145236 145236 2018 6293890 ACS - 2000133 - Horizon Juvenile Center (LL84) BRONX 560 Brook Ave Prison/Incarceration 210,444 0.0 0.0 0.0 0.0 0.0 0.0  
105534 105534 2017 6,293,890 ACS - 2000133 - Horizon Juvenile Center (LL84) BRONX 560 Brook Ave Prison/Incarceration 210,444              
84606 84606 2016 4,628,489 ACS - 2005938 - Bridges Juvenile Center Intake and Admissions (Out of service) BRONX 1221 Spofford Ave Prison/Incarceration 515,500 0.0 0.0 0.0 0.0 0.0 0.0  
74147 74147 2015 4628489 ACS - 2005938 - Bridges Juvenile Center Intake and Admissions BRONX 1221 Spofford Ave Prison/Incarceration 515500 0.0 0.0 0.0 0.0 0.0 0.0 0.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE water(
  "Calendar Year" INT,
  "Property ID" TEXT,
  "Property Name" TEXT,
  Borough TEXT,
  "Address 1" TEXT,
  "Property Type" TEXT,
  "Floor Area (ft2)" TEXT,
  "Total Water Use (kgal)" REAL,
  "Indoor Water Use (kgal)" REAL,
  "Outdoor Water Use (kgal)" REAL,
  "Municipal Indoor Water (kgal)" REAL,
  "Municipal Outdoor Water (kgal)" REAL,
  "Municipal Mixed Water (kgal)" REAL,
  "Indoor Water Intensity (gal/ft2)" REAL
);
CREATE INDEX "idx_water_Calendar Year" ON [water] ("Calendar Year");
CREATE INDEX "idx_water_Property ID" ON [water] ("Property ID");
CREATE INDEX "idx_water_Borough" ON [water] ("Borough");
CREATE INDEX "idx_water_Property Type" ON [water] ("Property Type");