Water — Use and Intensity
Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability
191 rows where Calendar Year = 2018 and Property Type = "College/University" sorted by Calendar Year descending
This data as json, CSV (advanced)
Suggested facets: Municipal Mixed Water (kgal)
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 130477 | 130477 | 2018 | 1697745 | School of Social Work | MANHATTAN | 1255 Amsterdam Ave SCHL | College/University | 139,392 | 6778.6 | 6778.6 | 0.0 | 6778.6 | 0.0 | 0.0 | |
| 130787 | 130787 | 2018 | 1845677 | 161 William St | MANHATTAN | 161 William St | College/University | 187,518 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 130815 | 130815 | 2018 | 2271551 | ARC | BROOKLYN | 395 Dekalb Ave | College/University | 114,452 | 9425.5 | 9425.5 | 0.0 | 9425.5 | 0.0 | 0.0 | |
| 130816 | 130816 | 2018 | 2271553 | Pratt Studios | BROOKLYN | 369 Dekalb Ave | College/University | 79,532 | 1009.9 | 1009.9 | 0.0 | 1009.9 | 0.0 | 0.0 | |
| 130817 | 130817 | 2018 | 2271554 | Higgins Hall | BROOKLYN | 282 Lafayette Ave | College/University | 138,349 | 10771.9 | 10771.9 | 0.0 | 10771.9 | 0.0 | 0.0 | |
| 130818 | 130818 | 2018 | 2271555 | Film & Video | BROOKLYN | 550 Myrtle Ave | College/University | 15,479 | 195.9 | 195.9 | 0.0 | 195.9 | 0.0 | 0.0 | |
| 130819 | 130819 | 2018 | 2271558 | Student Union | BROOKLYN | 180 Grand Ave | College/University | 11,729 | 167.9 | 167.9 | 0.0 | 167.9 | 0.0 | 0.0 | |
| 130918 | 130918 | 2018 | 2429835 | 214-220 E 21 | MANHATTAN | 214 - 220 East 23rd Street | College/University | 50,509 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 130926 | 130926 | 2018 | 2440099 | 209 E 23 | MANHATTAN | 209 East 23rd Street | College/University | 79,965 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 131188 | 131188 | 2018 | 2609513 | Leo Engineering Building | BRONX | 3825 Corlear Avenue | College/University | 161,880 | 746.1 | 746.1 | 0.0 | 746.1 | 0.0 | 0.0 | |
| 131201 | 131201 | 2018 | 2610158 | Research and Learning Center | BRONX | 3840 Corlear Avenue | College/University | 57,000 | 166.8 | 166.8 | 0.0 | 166.8 | 0.0 | 0.0 | |
| 131317 | 131317 | 2018 | 2636732 | 132 West 21st Street | MANHATTAN | 132 West 21st Street | College/University | 51,384 | 843.1 | 843.1 | 0.0 | 843.1 | 0.0 | 0.0 | |
| 131318 | 131318 | 2018 | 2636736 | Fordham. Rose Hill MAIN | BRONX | 441 E Fordham Road | College/University | 1,470,984 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 131331 | 131331 | 2018 | 2637231 | 133 W21 | MANHATTAN | 133-141 W 21st Street | College/University | 115,895 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 131332 | 131332 | 2018 | 2637247 | 136 W21 | MANHATTAN | 136 West 21st Street | College/University | 77,437 | 561.0 | 561.0 | 0.0 | 561.0 | 0.0 | 0.0 | |
| 132869 | 132869 | 2018 | 2690718 | Steuben Hall | BROOKLYN | 379 Dekalb Ave | College/University | 116,000 | 4189.1 | 4189.1 | 0.0 | 4189.1 | 0.0 | 0.0 | |
| 132870 | 132870 | 2018 | 2690725 | Pratt Manhattan Ctr | MANHATTAN | 144 W 14th St | College/University | 96,382 | 6463.2 | 6463.2 | 0.0 | 6463.2 | 0.0 | 0.0 | |
| 132871 | 132871 | 2018 | 2690772 | Machinery Building | BROOKLYN | 174-204 Steuben St | College/University | 36,439 | 695.7 | 695.7 | 0.0 | 695.7 | 0.0 | 0.0 | |
| 132872 | 132872 | 2018 | 2690777 | East Building | BROOKLYN | 200 Grand Ave | College/University | 53,865 | 897.7 | 897.7 | 0.0 | 897.7 | 0.0 | 0.0 | |
| 132873 | 132873 | 2018 | 2690779 | Main Building | BROOKLYN | 215 Ryerson St | College/University | 52,880 | 951.5 | 951.5 | 0.0 | 951.5 | 0.0 | 0.0 | |
| 132876 | 132876 | 2018 | 2691062 | Memorial Hall | BROOKLYN | 199 - 205 Ryerson St | College/University | 18,524 | 251.3 | 251.3 | 0.0 | 251.3 | 0.0 | 0.0 | |
| 132877 | 132877 | 2018 | 2691065 | South Hall | BROOKLYN | 221 Ryerson St | College/University | 14,000 | 209.4 | 209.4 | 0.0 | 209.4 | 0.0 | 0.0 | |
| 132878 | 132878 | 2018 | 2691080 | Engineering Building | BROOKLYN | 195 -203 Grand Ave | College/University | 58,716 | 1274.7 | 1274.7 | 0.0 | 1274.7 | 0.0 | 0.0 | |
| 132879 | 132879 | 2018 | 2691089 | North Hall | BROOKLYN | 184 - 202 Willoughby Ave | College/University | 67,026 | 3693.0 | 3693.0 | 0.0 | 3693.0 | 0.0 | 0.0 | |
| 132881 | 132881 | 2018 | 2691092 | Thrift Hall | BROOKLYN | 255 Ryerson St | College/University | 9,110 | 10183.7 | 10183.7 | 0.0 | 10183.7 | 0.0 | 0.0 | |
| 132932 | 132932 | 2018 | 2694581 | 16 West 61st Street | MANHATTAN | 16 West 61st Street | College/University | 112,080 | 1366.1 | 1366.1 | 0.0 | 1366.1 | 0.0 | 0.0 | |
| 132996 | 132996 | 2018 | 2704501 | Furman Hall | MANHATTAN | 245 Sullivan Street | College/University | 168,566 | 2706.6 | 2706.6 | 0.0 | 2706.6 | 0.0 | 0.0 | |
| 133004 | 133004 | 2018 | 2704702 | East Building | MANHATTAN | 239 Greene Street | College/University | 103,680 | 893.2 | 893.2 | 0.0 | 893.2 | 0.0 | 0.0 | |
| 133069 | 133069 | 2018 | 2706453 | 19 University Place | MANHATTAN | 13-19 University Place | College/University | 69,021 | 434.4 | 434.4 | 0.0 | 434.4 | 0.0 | 0.0 | |
| 133095 | 133095 | 2018 | 2709659 | 20 Cooper Square | MANHATTAN | 16-26 Cooper Square | College/University | 137,314 | 1695.1 | 1695.1 | 0.0 | 1695.1 | 0.0 | 0.0 | |
| 133096 | 133096 | 2018 | 2709676 | 25 West 4th Street | MANHATTAN | 21-29 West 4th Street | College/University | 73,913 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 133099 | 133099 | 2018 | 2709753 | 7-13 Washington Square North | MANHATTAN | 7-13 Washington Square North | College/University | 95,256 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 133101 | 133101 | 2018 | 2709799 | 721-725 Broadway | MANHATTAN | 725 Broadway | College/University | 262,739 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 133102 | 133102 | 2018 | 2709808 | 715-719 Broadway | MANHATTAN | 715-719 Broadway | College/University | 97,711 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 133103 | 133103 | 2018 | 2709810 | 726 Broadway | MANHATTAN | 726 Broadway | College/University | 415,725 | 7743.8 | 7743.8 | 0.0 | 7743.8 | 0.0 | 0.0 | |
| 133111 | 133111 | 2018 | 2710436 | Brown Building | MANHATTAN | 23-29 Washington Place | College/University | 124,526 | 3397.6 | 3397.6 | 0.0 | 3397.6 | 0.0 | 0.0 | |
| 133139 | 133139 | 2018 | 2711327 | ISC Building | BROOKLYN | 164-182 Willoughby Ave | College/University | 26,314 | 2010.8 | 2010.8 | 0.0 | 2010.8 | 0.0 | 0.0 | |
| 133152 | 133152 | 2018 | 2711501 | Library | BROOKLYN | 224-228 Ryerson St | College/University | 56,839 | 657.5 | 657.5 | 0.0 | 657.5 | 0.0 | 0.0 | |
| 133856 | 133856 | 2018 | 2777309 | Barnard College | MANHATTAN | 3009 Broadway | College/University | 598,000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 133857 | 133857 | 2018 | 2777318 | Barnard Milbank Hall | West 120th St | College/University | 121,000 | 1170.0 | 1170.0 | 0.0 | 1170.0 | 0.0 | 0.0 | ||
| 133976 | 133976 | 2018 | 2788606 | RSA 76-01 147 Street | QUEENS | 76-01 147th St | College/University | 83,793 | 2862.0 | 2862.0 | 0.0 | 2862.0 | 0.0 | 0.0 | |
| 134229 | 134229 | 2018 | 2797736 | Long Island University - 190 Willoughby Street | BROOKLYN | 190 Willoughby Street | College/University | 846,120 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 134680 | 134680 | 2018 | 2807790 | Main Original Buildings | BRONX | 4513 Manhattan College Parkway | College/University | 563,734 | 14640.9 | 10780.9 | 0.0 | 10780.9 | 0.0 | 3859.9 | |
| 134850 | 134850 | 2018 | 2811806 | Dekalb Hall | BROOKLYN | 331-347 Dekalb Ave | College/University | 24,058 | 391.6 | 391.6 | 0.0 | 391.6 | 0.0 | 0.0 | |
| 134956 | 134956 | 2018 | 2814906 | 755 Co-Op City Blvd | BRONX | 755 Co-Op City Blvd | College/University | 77,000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 135137 | 135137 | 2018 | 2825503 | Education Building | MANHATTAN | 35-39 West 4th Street | College/University | 151,070 | 1040.6 | 1040.6 | 0.0 | 1040.6 | 0.0 | 0.0 | |
| 135142 | 135142 | 2018 | 2825661 | Kimball Hall | MANHATTAN | 246 Greene Street | College/University | 45,687 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 135143 | 135143 | 2018 | 2825703 | King Juan Carlos Center | MANHATTAN | 51-54 Washington Square South | College/University | 61,310 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 135151 | 135151 | 2018 | 2826111 | Silver Center - Main Building | MANHATTAN | 100 Washington Square East | College/University | 258,155 | 18135.8 | 18135.8 | 0.0 | 18135.8 | 0.0 | 0.0 | |
| 135155 | 135155 | 2018 | 2826167 | Tisch Hall / KMEC / Shimkin | MANHATTAN | 40 West 4th Street | College/University | 416,607 | 55448.6 | 55448.6 | 0.0 | 55448.6 | 0.0 | 0.0 | |
| 135156 | 135156 | 2018 | 2826188 | Warren Weaver Hall | MANHATTAN | 251 Mercer Street | College/University | 158,590 | 27663.7 | 27663.7 | 0.0 | 27663.7 | 0.0 | 0.0 | |
| 135157 | 135157 | 2018 | 2826196 | Waverly Building | MANHATTAN | 24-26 Waverly Place | College/University | 60,329 | 332.1 | 332.1 | 0.0 | 332.1 | 0.0 | 0.0 | |
| 135159 | 135159 | 2018 | 2826282 | Weissman Hall | MANHATTAN | 421 First Avenue | College/University | 114,926 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 135231 | 135231 | 2018 | 2866471 | 19 West 4th Street | MANHATTAN | 19 West 4th Street | College/University | 128,679 | 434.4 | 434.4 | 0.0 | 434.4 | 0.0 | 0.0 | |
| 135414 | 135414 | 2018 | 2956094 | WCMC - FEIL (RR) Building | 407 E 61st | College/University | 68,635 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | ||
| 135517 | 135517 | 2018 | 2972382 | 8 Third Avenue-The Foundation Building | Eight Third Avenue | College/University | 179,000 | 2813.9 | 2813.9 | 0.0 | 2813.9 | 0.0 | 0.0 | ||
| 135658 | 135658 | 2018 | 3054414 | CMSV 1 | BRONX | 6135 Riverdale Avenue | College/University | 183,559 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 135659 | 135659 | 2018 | 3054433 | CMSV 2 | BRONX | 755 West 261 Street | College/University | 131,979 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 135714 | 135714 | 2018 | 3076540 | LC. Lowenstein Center | MANHATTAN | 113 W 60th St | College/University | 386,575 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 135832 | 135832 | 2018 | 3105049 | Mudd | 500 West 120th | College/University | 287,737 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | ||
| 135860 | 135860 | 2018 | 3107611 | Wilf Hall | MANHATTAN | 135 MacDougal St. | College/University | 48,931 | 576.3 | 576.3 | 0.0 | 576.3 | 0.0 | 0.0 | |
| 135861 | 135861 | 2018 | 3107613 | Genomics | MANHATTAN | 12-16 Waverly Place | College/University | 90,870 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 136208 | 136208 | 2018 | 3118743 | Chemistry | BROOKLYN | 175-177 Grand Ave | College/University | 27,024 | 502.7 | 502.7 | 0.0 | 502.7 | 0.0 | 0.0 | |
| 136217 | 136217 | 2018 | 3118978 | Northwest Corner Building | MANHATTAN | 550 W 120th St | College/University | 207,750 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 136279 | 136279 | 2018 | 3120878 | GC 365 5th Ave | MANHATTAN | 365 5th Avenue | College/University | 885,162 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 137272 | 137272 | 2018 | 3531433 | 433 1st Ave | 433 First Avenue / 339 25th Street | College/University | 169,481 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | ||
| 137521 | 137521 | 2018 | 3612678 | Columbia University (morningside) | MANHATTAN | 410 West 118th Street | College/University | 6,385,382 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 137522 | 137522 | 2018 | 3614737 | Columbia University Medical Center | MANHATTAN | 650 W 168th Street | College/University | 2,904,696 | 170099.0 | 109893.9 | 0.0 | 109893.9 | 0.0 | 60205.1 | |
| 137525 | 137525 | 2018 | 3616399 | New York University: Washington Square | MANHATTAN | 70 Washington Square S | College/University | 10,477,571 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 137535 | 137535 | 2018 | 3619571 | 490 Fulton St - LIU | BROOKLYN | 490 Fulton Street | College/University | 0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 138274 | 138274 | 2018 | 4043179 | 902 Quentin Rd | BROOKLYN | 902 Quentin Rd | College/University | 73,245 | 496.1 | 496.1 | 0.0 | 496.1 | 0.0 | 0.0 | |
| 138413 | 138413 | 2018 | 4046078 | Jacobs Academic | BROOKLYN | 6 Metrotech Center | College/University | 420,000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 138476 | 138476 | 2018 | 4052447 | Sheila C Johnson Center | MANHATTAN | 2 West 13th Street | College/University | 195,123 | 2040.3 | 2040.3 | 0.0 | 2040.3 | 0.0 | 0.0 | |
| 138477 | 138477 | 2018 | 4052485 | Parsons East | MANHATTAN | 25 E.13th Street | College/University | 63,206 | 1399.6 | 1399.6 | 0.0 | 1399.6 | 0.0 | 0.0 | |
| 138478 | 138478 | 2018 | 4052575 | Johnson/Kaplan Building | MANHATTAN | 66 W.12th Street | College/University | 126,418 | 2188.6 | 2188.6 | 0.0 | 2188.6 | 0.0 | 0.0 | |
| 138479 | 138479 | 2018 | 4052580 | Arnhold Hall | MANHATTAN | 55 W.13th Street | College/University | 125,116 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 138480 | 138480 | 2018 | 4053935 | Welcome Center | MANHATTAN | 72 5th Avenue | College/University | 42,427 | 720.6 | 720.6 | 0.0 | 720.6 | 0.0 | 0.0 | |
| 138491 | 138491 | 2018 | 4062644 | New York College of Podiatric Medicine and Foot Center of New York | MANHATTAN | 53 East 124th Street | College/University | 72,579 | 1166.0 | 1166.0 | 0.0 | 1166.0 | 0.0 | 0.0 | |
| 138545 | 138545 | 2018 | 4134731 | Hebrew Union College 1 w 4th St | MANHATTAN | 1 W. 4th Street | College/University | 86,500 | 769.7 | 769.7 | 0.0 | 769.7 | 0.0 | 0.0 | |
| 138546 | 138546 | 2018 | 4134731 | Hebrew Union College 1 w 4th St | MANHATTAN | 1 W. 4th Street | College/University | 86,500 | 769.7 | 769.7 | 0.0 | 769.7 | 0.0 | 0.0 | |
| 138659 | 138659 | 2018 | 4358005 | Kelly Student Commons | BRONX | 3900 Waldo Avenue | College/University | 70,000 | 763.5 | 763.5 | 0.0 | 763.5 | 0.0 | 0.0 | |
| 139443 | 139443 | 2018 | 4408910 | Columbia University Teachers College | MANHATTAN | 525 West 120th Street | College/University | 525,640 | 17427.7 | 17427.7 | 0.0 | 17427.7 | 0.0 | 0.0 | |
| 139500 | 139500 | 2018 | 4409966 | Berkeley 12 East 41st LLC | MANHATTAN | 12 E. 41st Street | College/University | 83,267 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 139933 | 139933 | 2018 | 4492199 | 532 West 215th Street | MANHATTAN | 532 West 215th Street | College/University | 55,000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 140569 | 140569 | 2018 | 4917990 | 404 Lafayette Street, 708 Broadway | MANHATTAN | 404 Lafayette Street | College/University | 178,715 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 140762 | 140762 | 2018 | 4938341 | Monroe: 2505 Jerome Ave | BRONX | 2505 Jerome Ave | College/University | 75,000 | 755.8 | 755.8 | 0.0 | 755.8 | 0.0 | 0.0 | |
| 140921 | 140921 | 2018 | 4950563 | University Center | MANHATTAN | 63 5th Avenue | College/University | 365,000 | 10772.9 | 10772.9 | 0.0 | 10772.9 | 0.0 | 0.0 | |
| 141098 | 141098 | 2018 | 4954258 | New York Institute of Technology | MANHATTAN | 1855 Broadway | College/University | 78,285 | 1561.9 | 0.0 | 0.0 | 0.0 | 0.0 | 1561.9 | |
| 141101 | 141101 | 2018 | 4954491 | 558 RIVERSIDE DRIVE | MANHATTAN | 558 RIVERSIDE DRIVE | College/University | 256,528 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 141102 | 141102 | 2018 | 4954504 | 564 RIVERSIDE DRIVE | MANHATTAN | 560 Riverside Drive | College/University | 339,104 | 6829.2 | 6829.2 | 0.0 | 6829.2 | 0.0 | 0.0 | |
| 141152 | 141152 | 2018 | 4960043 | 3 East 43rd Street | MANHATTAN | 3 East 43rd Street | College/University | 40,000 | 1791.6 | 1791.6 | 0.0 | 1791.6 | 0.0 | 0.0 | |
| 141180 | 141180 | 2018 | 4985858 | Original Campus | BROOKLYN | 200 Grand Ave | College/University | 900,000 | 46591.1 | 46591.1 | 0.0 | 46591.1 | 0.0 | 0.0 | |
| 141408 | 141408 | 2018 | 5083682 | Baker field | MANHATTAN | 533 West 218th street | College/University | 250,000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 141434 | 141434 | 2018 | 5101795 | 707-709 Broadway | MANHATTAN | 707-709 Broadway | College/University | 106,063 | 7612.9 | 7612.9 | 0.0 | 7612.9 | 0.0 | 0.0 | |
| 141435 | 141435 | 2018 | 5101855 | JACOBS CIVIL ENGINEERING | BROOKLYN | 315 Jay Street | College/University | 63,000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 141436 | 141436 | 2018 | 5101913 | 713 Broadway, 2 Washington Place | MANHATTAN | 713 Broadway | College/University | 61,582 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 141469 | 141469 | 2018 | 5236727 | 86-01 23rd Avenue | QUEENS | 8601 23 Ave | College/University | 66,045 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |
| 141736 | 141736 | 2018 | 5819523 | Belfer Hall | MANHATTAN | 2495 amsterdam ave | College/University | 253,942 | 3942.3 | 3942.3 | 0.0 | 3942.3 | 0.0 | 0.0 | |
| 141737 | 141737 | 2018 | 5819529 | Furst Hall | MANHATTAN | 500 west 185th street | College/University | 105,698 | 1879.1 | 1879.1 | 0.0 | 1879.1 | 0.0 | 0.0 | |
| 141738 | 141738 | 2018 | 5819550 | Glueck Center | MANHATTAN | 515 west 185th st | College/University | 59,675 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
Advanced export
JSON shape: default, array, newline-delimited
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");