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

8 rows where Calendar Year = 2020 and Property Type = "Other - Public Services" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

Borough 4

  • BRONX 4
  • BROOKLYN 2
  • MANHATTAN 1
  • QUEENS 1

Property Type 1

  • Other - Public Services · 8 ✖

Calendar Year 1

  • 2020 · 8 ✖
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)
198164 198164 2020 6296796 FDNY - c057002 - Rescue 3, EMS 18 Campus (LL84) BRONX 1647 Washington Ave Other - Public Services 35250 0.0 0.0 0.0 0.0 0.0 0.0  
198482 198482 2020 6297475 FDNY - c000005 - Fire Academy Randalls Island Campus (LL84) MANHATTAN Wards Island Other - Public Services 160019 0.0 0.0 0.0 0.0 0.0 0.0  
200243 200243 2020 6579395 D & M King Realty LLC - 1736 Shore pkwy BROOKLYN 1736 Shore pkwy Other - Public Services 40283 231.9 231.9 0.0 231.9 0.0 0.0  
200319 200319 2020 6586703 Jacob Shafran - 3674 3rd Avenue BRONX 3674 3rd Avenue Other - Public Services 39900 0.0 0.0 0.0 0.0 0.0 0.0  
200320 200320 2020 6586705 Jacob Shafran - 385 Mcdonald ave BROOKLYN 385 Mcdonald ave Other - Public Services 44000 3051.5 3051.5 0.0 3051.5 0.0 0.0  
206029 206029 2020 8469846 Sammon Build BRONX 2294-96 Grand Avenue Other - Public Services 30000 0.0 0.0 0.0 0.0 0.0 0.0  
209009 209009 2020 12347254 BBL 4-02274-0002: DCAS, NYPD (LL84) QUEENS 120-55 Queens Blvd Other - Public Services 261000 4065.9 4065.9 0.0 4065.9 0.0 0.0  
209208 209208 2020 12714593 Action Environmental - Bronx BRONX 920 E 132nd Street Other - Public Services 155778 1101.5 0.0 0.0 0.0 0.0 1101.5  

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