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

20 rows where Calendar Year = 2017 and Property Type = "Prison/Incarceration" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Address 1, Floor Area (ft2)

Borough 4

  • QUEENS 14
  • BROOKLYN 3
  • MANHATTAN 2
  • BRONX 1

Property Type 1

  • Prison/Incarceration · 20 ✖

Calendar Year 1

  • 2017 · 20 ✖
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)
95806 95806 2017 6,166,149 G & M Realty Of NY LLC BROOKLYN 55-65 Bay 34 street Prison/Incarceration 38,320 475.3 475.3   475.3      
105213 105213 2017 6,294,369 DOC - 3000605 - Brooklyn CC Campus: Brooklyn House of Detention #129 (LL84) BROOKLYN 275 Atlantic Ave Prison/Incarceration 161,765              
105534 105534 2017 6,293,890 ACS - 2000133 - Horizon Juvenile Center (LL84) BRONX 560 Brook Ave Prison/Incarceration 210,444              
105612 105612 2017 6,297,409 DOC - 1002364 - Manhattan CC Campus: Manhattan Detention House North (LL84) MANHATTAN 100 Baxter St Prison/Incarceration 236,142              
105634 105634 2017 6,297,486 DOC - c072003 - Rikers Island AMKC Campus (LL84) QUEENS Rikers Island Prison/Incarceration 1,104,830              
105642 105642 2017 6,297,490 DOC - c072007 - Rikers Island RNDC Campus (LL84) QUEENS Rikers Island Prison/Incarceration 622,200              
105826 105826 2017 6,294,364 DOC - 1088394 - Manhattan CC Campus: Manhattan Detention House South (LL84) MANHATTAN 125 White St Prison/Incarceration 514,000              
105913 105913 2017 6,297,428 DOC - 2999999 - Rikers Island Transportation Garage (ASRS) (LL84) QUEENS Rikers Island Prison/Incarceration 73,895              
106222 106222 2017 6,297,493 DOC - c072010 - Rikers Island NIC Campus (LL84) QUEENS Rikers Island Prison/Incarceration 80,800              
106694 106694 2017 6,297,489 DOC - c072006 - Rikers Island GMDC Campus (LL84) QUEENS Rikers Island Prison/Incarceration 761,071              
106718 106718 2017 6,294,368 DOC - 2096863 - Rikers Island GRVC Detention Facility (LL84) QUEENS Rikers Island Prison/Incarceration 458,000              
106814 106814 2017 6,297,488 DOC - c072005 - Rikers Island EMTC Campus (LL84) QUEENS Rikers Island Prison/Incarceration 511,207              
106823 106823 2017 6,297,491 DOC - c072008 - Rikers Island West Facility Campus (LL84) QUEENS Rikers Island Prison/Incarceration 128,914              
106912 106912 2017 6,294,370 DOC - 4458616 - Queens BH Campus: Queens Detention Complex Aux. Building (LL84) QUEENS 126-02 82nd Ave Prison/Incarceration 31,333              
107001 107001 2017 6,293,924 ACS - 3378202 - Crossroads Juvenile Center (LL84) BROOKLYN 17 Bristol St Prison/Incarceration 210,444              
107028 107028 2017 6,294,366 DOC - 2116652 - Rikers Island Powerhouse (LL84) QUEENS Rikers Island Prison/Incarceration 36,450              
107105 107105 2017 6,297,487 DOC - c072004 - Rikers Island JATC Campus (LL84) QUEENS Rikers Island Prison/Incarceration 650,300              
107277 107277 2017 6,297,426 DOC - 4458617 - Queens BH Campus: Queens Detention Complex Main Building (LL84) QUEENS 126-02 82nd Ave Prison/Incarceration 177,554              
107306 107306 2017 6,297,492 DOC - c072009 - Rikers Island OBCC Campus (LL84) QUEENS Rikers Island Prison/Incarceration 708,047              
107402 107402 2017 6,297,485 DOC - c072002 - Rikers Island RMSC Campus (LL84) QUEENS Rikers Island Prison/Incarceration 557,000              

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 877.476ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability