Water — Use and Intensity

Total, indoor, outdoor, and municipal water use.

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

30 rows where Borough = "STATEN IS" and Property Type = "Police Station" 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 10

Property Type 1

  • Police Station · 30 ✖

Borough 1

  • STATEN IS · 30 ✖
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)
328787 328787 2024 21355472 NYPD_4583_120th Precinct STATEN IS 78 Richmond Ter Police Station 15,540 0.0 0.0 0.0 0.0 0.0 0.0  
328788 328788 2024 21355473 NYPD_4584_122nd Precinct STATEN IS 2320 Hylan Blvd Police Station 53,200 259.6 259.6 0.0 259.6 0.0 0.0  
328861 328861 2024 21355559 NYPD_9029_121st Precinct STATEN IS 970 Richmond Ave Police Station 48,797 1067.5 1067.5 0.0 1067.5 0.0 0.0  
295402 295402 2023 21355472 NYPD_4583_120th Precinct STATEN IS 78 Richmond Ter Police Station 15,540 0.0 0.0 0.0 0.0 0.0 0.0  
295403 295403 2023 21355473 NYPD_4584_122nd Precinct STATEN IS 2320 Hylan Blvd Police Station 53,200 285.0 285.0 0.0 285.0 0.0 0.0  
295480 295480 2023 21355559 NYPD_9029_121st Precinct STATEN IS 970 Richmond Ave Police Station 48,797 1.5 1.5 0.0 1.5 0.0 0.0  
271290 271290 2022 21355472 NYPD_4583_120th Precinct STATEN IS 78 Richmond Ter Police Station 15,540 0.0 0.0 0.0 0.0 0.0 0.0  
271291 271291 2022 21355473 NYPD_4584_122nd Precinct STATEN IS 2320 Hylan Blvd Police Station 53,200 325.4 325.4 0.0 325.4 0.0 0.0  
271367 271367 2022 21355559 NYPD_9029_121st Precinct STATEN IS 970 Richmond Ave Police Station 48,797 837.8 837.8 0.0 837.8 0.0 0.0  
223672 223672 2021 21355472 NYPD_4583_120th Precinct STATEN IS 78 Richmond Ter Police Station 15,540 0.0 0.0 0.0 0.0 0.0 0.0  
223673 223673 2021 21355473 NYPD_4584_122nd Precinct STATEN IS 2320 Hylan Blvd Police Station 53,200 338.4 338.4 0.0 338.4 0.0 0.0  
223759 223759 2021 21355559 NYPD_9029_121st Precinct STATEN IS 970 Richmond Ave Police Station 48,797 1841.7 1841.7 0.0 1841.7 0.0 0.0  
198353 198353 2020 6297197 NYPD - 5106476 - 120th Precinct (LL84) STATEN IS 78 Richmond Ter Police Station 15540 0.0 0.0 0.0 0.0 0.0 0.0  
198354 198354 2020 6297198 NYPD - 5107580 - 122nd Precinct (LL84) STATEN IS 2320 Hylan Blvd Police Station 53200 252.1 252.1 0.0 252.1 0.0 0.0  
198454 198454 2020 6297418 NYPD - 5165197 - 121st Precinct (LL84) STATEN IS 970 Richmond Ave Police Station 48797 780.8 780.8 0.0 780.8 0.0 0.0  
170928 170928 2019 6297197 NYPD - 5106476 - 120th Precinct (LL84) STATEN IS 78 Richmond Ter Police Station 15,540 0.0 0.0 0.0 0.0 0.0 0.0  
170929 170929 2019 6297198 NYPD - 5107580 - 122nd Precinct (LL84) STATEN IS 2320 Hylan Blvd Police Station 53,200 2132.0 2132.0 0.0 2132.0 0.0 0.0  
171045 171045 2019 6297418 NYPD - 5165197 - 121st Precinct (LL84) STATEN IS 970 Richmond Ave Police Station 48,797 6465.7 6465.7 0.0 6465.7 0.0 0.0  
145965 145965 2018 6297197 NYPD - 5106476 - 120th Precinct (LL84) STATEN IS 78 Richmond Ter Police Station 15,540 0.0 0.0 0.0 0.0 0.0 0.0  
145966 145966 2018 6297198 NYPD - 5107580 - 122nd Precinct (LL84) STATEN IS 2320 Hylan Blvd Police Station 53,200 0.0 0.0 0.0 0.0 0.0 0.0  
146080 146080 2018 6297418 NYPD - 5165197 - 121st Precinct (LL84) STATEN IS 970 Richmond Ave Police Station 48,797 0.0 0.0 0.0 0.0 0.0 0.0  
105310 105310 2017 6,297,197 NYPD - 5106476 - 120th Precinct (LL84) STATEN IS 78 Richmond Ter Police Station 15,540              
105630 105630 2017 6,297,418 NYPD - 5165197 - 121st Precinct (LL84) STATEN IS 970 Richmond Ave Police Station 48,797              
105901 105901 2017 6,297,198 NYPD - 5107580 - 122nd Precinct (LL84) STATEN IS 2320 Hylan Blvd Police Station 53,200              
85430 85430 2016 4,629,600 NYPD - 5106476 - 120th Precinct (LL84) STATEN IS 78 Richmond Ter Police Station 15,540 0.0 0.0 0.0 0.0 0.0 0.0  
85431 85431 2016 4,629,601 NYPD - 5107580 - 122nd Precinct (LL84) STATEN IS 2320 Hylan Blvd Police Station 53,200 0.0 0.0 0.0 0.0 0.0 0.0  
85547 85547 2016 4,629,815 NYPD - 5165197 - 121st Precinct (LL84) STATEN IS 970 Richmond Ave Police Station 48,797 0.0 0.0 0.0 0.0 0.0 0.0  
74967 74967 2015 4629600 NYPD - 5106476 - 120th Precinct STATEN IS 78 Richmond Ter Police Station 15540 0.0 0.0 0.0 0.0 0.0 0.0 0.0
74968 74968 2015 4629601 NYPD - 5107580 - 122nd Precinct STATEN IS 2320 Hylan Blvd Police Station 53200 0.0 0.0 0.0 0.0 0.0 0.0 0.0
75082 75082 2015 4629815 NYPD - 5165197 - 121st Precinct STATEN IS 970 Richmond Ave Police Station 48797 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");