home / nyc_ll84

Water — Use and Intensity

Total, indoor, outdoor, and municipal water use.

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

56 rows where Calendar Year = 2022 and Property Type = "Prison/Incarceration" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Address 1, Total Water Use (kgal), Indoor Water Use (kgal), Municipal Indoor Water (kgal)

Borough 4

  • QUEENS 51
  • BROOKLYN 2
  • MANHATTAN 2
  • BRONX 1

Property Type 1

  • Prison/Incarceration · 56 ✖

Calendar Year 1

  • 2022 · 56 ✖
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)
270097 270097 2022 21354249 DOC_1152_Manhattan CC: Manhattan Detention House South MANHATTAN 125 White St Prison/Incarceration 514,000 0.0 0.0 0.0 0.0 0.0 0.0  
270098 270098 2022 21354250 DOC_8963_Manhattan CC: Manhattan Detention House North MANHATTAN 84 Baxter St Prison/Incarceration 236,142 0.0 0.0 0.0 0.0 0.0 0.0  
270176 270176 2022 21354329 Benchmarking Group - 211 QUEENS Rikers Island Prison/Incarceration 5,978,573 5234.1 5234.1 0.0 5234.1 0.0 0.0  
270177 270177 2022 21354330 DOC_10012_Rikers Island RNDC: Sprungs, MOD 3 QUEENS Rikers Island Prison/Incarceration 35,000 0.0 0.0 0.0 0.0 0.0 0.0  
270178 270178 2022 21354331 DOC_10013_Rikers Island RNDC: Mods 2,4,10 QUEENS Rikers Island Prison/Incarceration 30,000 0.0 0.0 0.0 0.0 0.0 0.0  
270179 270179 2022 21354332 DOC_10033_Rikers Island RMSC: 800 Bed Addition QUEENS Rikers Island Prison/Incarceration 225,000 0.0 0.0 0.0 0.0 0.0 0.0  
270181 270181 2022 21354334 DOC_1153_Rikers Island West Facility: 200 Bed Modules QUEENS Rikers Island Prison/Incarceration 30,000 0.0 0.0 0.0 0.0 0.0 0.0  
270182 270182 2022 21354336 DOC_1155_Rikers Island AMKC: Buildings 3&4 QUEENS Rikers Island Prison/Incarceration 20,000 0.0 0.0 0.0 0.0 0.0 0.0  
270183 270183 2022 21354337 DOC_1156_Rikers Island AMKC: Freezer Kitchen QUEENS Rikers Island Prison/Incarceration 800 0.0 0.0 0.0 0.0 0.0 0.0  
270184 270184 2022 21354338 DOC_1157_Rikers Island AMKC: Hart Island Module / S1 QUEENS Rikers Island Prison/Incarceration 10,000 0.0 0.0 0.0 0.0 0.0 0.0  
270185 270185 2022 21354339 DOC_1158_Rikers Island AMKC: Kitchen Switch A QUEENS Rikers Island Prison/Incarceration 800 0.0 0.0 0.0 0.0 0.0 0.0  
270186 270186 2022 21354340 DOC_1159_Rikers Island AMKC: Kitchen Switch B QUEENS Rikers Island Prison/Incarceration 800 0.0 0.0 0.0 0.0 0.0 0.0  
270187 270187 2022 21354341 DOC_1160_Rikers Island AMKC: Module 1 QUEENS Rikers Island Prison/Incarceration 10,000 0.0 0.0 0.0 0.0 0.0 0.0  
270188 270188 2022 21354342 DOC_1161_Rikers Island AMKC: Modules DD/ QUEENS Rikers Island Prison/Incarceration 10,000 0.0 0.0 0.0 0.0 0.0 0.0  
270189 270189 2022 21354343 DOC_1162_Rikers Island AMKC: Modules NN/ QUEENS Rikers Island Prison/Incarceration 8,000 0.0 0.0 0.0 0.0 0.0 0.0  
270190 270190 2022 21354344 DOC_1163_Rikers Island AMKC: Modules OO & PP/ QUEENS Rikers Island Prison/Incarceration 20,000 0.0 0.0 0.0 0.0 0.0 0.0  
270191 270191 2022 21354345 DOC_1164_Rikers Island AMKC: Modules VV/ QUEENS Rikers Island Prison/Incarceration 8,000 0.0 0.0 0.0 0.0 0.0 0.0  
270192 270192 2022 21354346 DOC_1165_Rikers Island AMKC: Modules WW & XX/ QUEENS Rikers Island Prison/Incarceration 20,000 0.0 0.0 0.0 0.0 0.0 0.0  
270193 270193 2022 21354347 DOC_1166_Rikers Island AMKC: Pantry Buildings 1&2 QUEENS Rikers Island Prison/Incarceration 10,000 0.0 0.0 0.0 0.0 0.0 0.0  
270194 270194 2022 21354348 DOC_1167_Rikers Island AMKC: Pantry Buildings 3&4 QUEENS Rikers Island Prison/Incarceration 10,000 0.0 0.0 0.0 0.0 0.0 0.0  
270195 270195 2022 21354349 DOC_1168_Rikers Island AMKC: Pantry Buildings 5 QUEENS Rikers Island Prison/Incarceration 10,000 0.0 0.0 0.0 0.0 0.0 0.0  
270196 270196 2022 21354350 DOC_1169_Rikers Island AMKC: Visit House QUEENS Rikers Island Prison/Incarceration 2,600 0.0 0.0 0.0 0.0 0.0 0.0  
270199 270199 2022 21354353 DOC_1172_Rikers Island EMTC: HIIP 3,4,5,6 & Admin QUEENS Rikers Island Prison/Incarceration 1,800 0.0 0.0 0.0 0.0 0.0 0.0  
270200 270200 2022 21354354 DOC_1173_Rikers Island EMTC: Locker Room QUEENS Rikers Island Prison/Incarceration 15,000 0.0 0.0 0.0 0.0 0.0 0.0  
270201 270201 2022 21354355 DOC_1174_Rikers Island EMTC: Sprung 1 QUEENS Rikers Island Prison/Incarceration 10,000 0.0 0.0 0.0 0.0 0.0 0.0  
270203 270203 2022 21354357 DOC_1176_Rikers Island West Facility: Kitchen QUEENS Rikers Island Prison/Incarceration 4,000 0.0 0.0 0.0 0.0 0.0 0.0  
270211 270211 2022 21354365 DOC_1184_Rikers Island GMDC: East Sprungs & WS QUEENS Rikers Island Prison/Incarceration 33,000 0.0 0.0 0.0 0.0 0.0 0.0  
270212 270212 2022 21354366 DOC_1185_Rikers Island GMDC: Servery & MOD 3 QUEENS Rikers Island Prison/Incarceration 1,600 0.0 0.0 0.0 0.0 0.0 0.0  
270213 270213 2022 21354367 DOC_1186_Rikers Island GMDC: West Sprungs QUEENS Rikers Island Prison/Incarceration 30,000 0.0 0.0 0.0 0.0 0.0 0.0  
270214 270214 2022 21354368 DOC_1187_Rikers Island JATC: Equipment Room A QUEENS Rikers Island Prison/Incarceration 2,500 0.0 0.0 0.0 0.0 0.0 0.0  
270215 270215 2022 21354369 DOC_1188_Rikers Island JATC: Equipment Room B QUEENS Rikers Island Prison/Incarceration 2,500 0.0 0.0 0.0 0.0 0.0 0.0  
270216 270216 2022 21354370 DOC_1189_Rikers Island JATC: Equipment Room C QUEENS Rikers Island Prison/Incarceration 2,500 0.0 0.0 0.0 0.0 0.0 0.0  
270217 270217 2022 21354371 DOC_1190_Rikers Island NIC: Aids Module QUEENS Rikers Island Prison/Incarceration 6,000 0.0 0.0 0.0 0.0 0.0 0.0  
270218 270218 2022 21354372 DOC_1191_Rikers Island NIC: Kitchen / Elevator QUEENS Rikers Island Prison/Incarceration 8,000 0.0 0.0 0.0 0.0 0.0 0.0  
270219 270219 2022 21354373 DOC_1192_Rikers Island OBCC: 300 Bed Annex QUEENS Rikers Island Prison/Incarceration 120,000 0.0 0.0 0.0 0.0 0.0 0.0  
270220 270220 2022 21354374 DOC_1193_Rikers Island OBCC: CPSU 500 Bed Annex QUEENS Rikers Island Prison/Incarceration 120,000 0.0 0.0 0.0 0.0 0.0 0.0  
270221 270221 2022 21354375 DOC_1194_Rikers Island OBCC: Kitchen / Locker Room QUEENS Rikers Island Prison/Incarceration 7,000 0.0 0.0 0.0 0.0 0.0 0.0  
270222 270222 2022 21354376 DOC_1195_Rikers Island OBCC: Main Building QUEENS Rikers Island Prison/Incarceration 461,047 0.0 0.0 0.0 0.0 0.0 0.0  
270224 270224 2022 21354378 DOC_1197_Rikers Island RMSC: Dorms 17-20 QUEENS Rikers Island Prison/Incarceration 32,000 0.0 0.0 0.0 0.0 0.0 0.0  
270225 270225 2022 21354379 DOC_1198_Rikers Island Telecom / SOD / COD QUEENS 14-12 Hazen St Prison/Incarceration 16,000 0.0 0.0 0.0 0.0 0.0 0.0  
270226 270226 2022 21354380 DOC_1199_Rikers Island GMDC: MODS 14,15,16,LL,N,QQ,RR QUEENS Rikers Island Prison/Incarceration 70,980 0.0 0.0 0.0 0.0 0.0 0.0  
270227 270227 2022 21354381 DOC_1200_Rikers Island GMDC: GMDC MODS 4,5,8,9,10,11,12,13 QUEENS Rikers Island Prison/Incarceration 92,000 0.0 0.0 0.0 0.0 0.0 0.0  
270228 270228 2022 21354382 DOC_1201_Rikers Island RMSC: Building 5 QUEENS Rikers Island Prison/Incarceration 9,000 0.0 0.0 0.0 0.0 0.0 0.0  
270229 270229 2022 21354383 DOC_1202_Rikers Island AMKC: AMKC Detention Facility QUEENS Rikers Island Prison/Incarceration 963,830 0.0 0.0 0.0 0.0 0.0 0.0  
270230 270230 2022 21354384 DOC_1203_Rikers Island EMTC: EMTC Detention Facility QUEENS Rikers Island Prison/Incarceration 484,407 0.0 0.0 0.0 0.0 0.0 0.0  
270231 270231 2022 21354385 DOC_1204_Rikers Island GMDC: GMDC Detention Facility QUEENS Rikers Island Prison/Incarceration 533,491 0.0 0.0 0.0 0.0 0.0 0.0  
270232 270232 2022 21354386 DOC_1205_Rikers Island GRVC Detention Facility QUEENS Rikers Island Prison/Incarceration 458,000 0.0 0.0 0.0 0.0 0.0 0.0  
270233 270233 2022 21354387 DOC_1206_Rikers Island RMSC: RMSC Detention Facility QUEENS Rikers Island Prison/Incarceration 291,000 0.0 0.0 0.0 0.0 0.0 0.0  
270234 270234 2022 21354388 DOC_1207_Rikers Island RNDC: RNDC Detention Facility QUEENS Rikers Island Prison/Incarceration 557,200 0.0 0.0 0.0 0.0 0.0 0.0  
270235 270235 2022 21354389 DOC_1208_Rikers Island West Facility: WF Detention Facility QUEENS Rikers Island Prison/Incarceration 94,914 0.0 0.0 0.0 0.0 0.0 0.0  
270238 270238 2022 21354392 DOC_9200_Rikers Island JATC: JATC Detention Facility QUEENS Rikers Island Prison/Incarceration 642,800 0.0 0.0 0.0 0.0 0.0 0.0  
270239 270239 2022 21354393 DOC_9201_Rikers Island NIC: North Infirmary Command QUEENS Rikers Island Prison/Incarceration 66,800 0.0 0.0 0.0 0.0 0.0 0.0  
270327 270327 2022 21354481 DOC_1214_Brooklyn House of Detention #129 BROOKLYN 275 Atlantic Ave Prison/Incarceration 161,765 0.0 0.0 0.0 0.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  
270926 270926 2022 21355105 ACS_108_Crossroads Juvenile Center BROOKLYN 17 Bristol St Prison/Incarceration 105,223 10837.0 10837.0 0.0 10837.0 0.0 0.0  
271606 271606 2022 26656540 DCAS_9104_Queens Borough Hall: Queens Detention Complex Main Building QUEENS 126-02 82nd Ave Prison/Incarceration 177,554 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");
Powered by Datasette · Queries took 920.913ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability