The goal of this analysis was to determine the least-cost way to supply county's water needs, at various radii. In particular:

When all other counties are held constant.
When all counties within state are allowed to change.
When all counties within country are allowed to change.

The county-level optimization is exactly the USGS (or other baseline water withdrawal) dataset, since this is what would be applied as demands that would need to be met.

The national-level optimization is the optimize-waterallocation.jl script, for the same reason.

The state-level optimization takes as its starting point the optimize-waterallocation.jl constraints, but adds on a constraint that rivers that flow across state boundaries maintain the values they have under optimize-surface.jl.

analyses/optradii/holdstate.jl performs this optimization and compares the results.



In [1]:

    
using DataFrames, RegressionTables









    



INFO: Recompiling stale cache file /Users/jrising/.julia/lib/v0.6/DataFrames.ji for module DataFrames.
INFO: Recompiling stale cache file /Users/jrising/.julia/lib/v0.6/RegressionTables.ji for module RegressionTables.



In [2]:

    
awwa = readtable("../../prepare/costs/awwadata.csv")









    Out[2]:




x County WaterstatsID UtilityType UtilityName AWWAGroup Category Region AWWA_City State_Name State Zip Country FIPS City PopDens MedianIncome Ground Surface Purchases PrimarySource SplitPercent ResidentialRateStr RateStruct Seasonal ResCharges1000cfService ResCharges1000cfVolume ResCharges1000cfTotal ResCharges1500cfService ResCharges1500cfVolume ResCharges1500cfTotal FixedChargeRatio WWCharges1000cfService WWCharges1000cfVolume WWCharges1000cfTotal WWCharges1500cfService WWCharges1500cfVolume WWCharges1500cfTotal CombResCharges1000cfService CombResCharges1000cfVolume CombResCharges1000cfTotal CombResCharges1500cfService CombResCharges1500cfVolume CombResCharges1500cfTotal MGDailyWaterTreatmntProdCapacity MGDAverageDayWaterProduction MGDMaxDayWaterProduction AvgPlantUtilization MaxPlantUtilization AnnualMGallonsSoldResNonres AnnualMGallonsSoldWholesale AnnualMGallonsSoldTotal SvcPopRetail SvcPopWholesale SvcPopTotal X_x ScvPop DailyPerCapitaConsumptionGallons ActiveAccountResidential ActiveAccountNonRes AccountRatio_NonRes ActiveAccountWholesale ActiveAccountTotal BSFullTimeEmployees MGYWWTotalGallonsTreated WaterPerEmployee BSTotalAssets BSLongtermDebt DebtRatio BSTotalAssetsComb BSLongTermDebtComb DebtRatioComb ISOperatingRevenues ISBeforeDepreciation IncomeStatement_Depreciation_Expense OpExpRev ISInterestExpense ISNetIncome DebtPerMG OpExpPerMG NonOperatingRevenue NonOperatingIncome ISOperatingRevenuesComb ISBeforeDepreciationComb OpExpRevComb ISInterestExpenseComb ISNetIncomeComb AverageCapitalNeeds IncomeStatement_W_C_WW WaterIS_Period WastewaterIS_Period UtilityType_1 WaterOnly TempAve TempVar PrecipAnnual PrecipSeasonal MaxCumDef NDI X_y mean depth
1 1 Ada 20022 4 City of Boise X U West Boise Idaho ID 83701-0500 USA 16001 Boise 325.8 55493 0.0 0.0 0.0 NA NA NA NA 0 0 0 0.0 0 0 0 #DIV/0! 4.56 25.9 30.46 4.56 38.85 43.41 NA NA 30.46 4.56 38.85 43.41 0.0 0.0 0.0 0.00% 0.00% 0.0 0.0 0.0 0 0 0.0 0 0.0 #DIV/0! 0 0 #DIV/0! 0 0 0.0 9171.0 #DIV/0! 0 0 #DIV/0! 304,337,000.00 20,371,000.00 0.07 0.0 0 0 #DIV/0! 0 0 #DIV/0! #DIV/0! 0 0 25,174,000.00 21,381,000.00 0.85 474,000.00 1.952e6 #DIV/0! NA N / R FY09 4 0 10.27 12.89 320.79 4.13 0.325605895 18.12909083 3 1465.266951 1164.528134
2 2 Adams 1609 2 Aurora Water B U West Aurora Colorado CO 80012 USA 8001 Aurora 346.6 60822 0.0 100.0 0.0 1 2 IB 2 0 12.06 39.42 51.48 12.06 59.13 71.19 0.2 2.97 20.42 23.39 2.97 30.63 33.6 15.03 59.84 74.87 15.03 89.76 104.79 160.0 40.41 80.0 25.26% 50.00% 14749.65 0.0 14749.65 314000 0 314000.0 1 314000.0 128.6942675 72811 3999 0.05492302 0 76810 268.0 0.0 55.03600746 1,700,272,392.00 701,818,920.00 0.41 2,202,062,415.00 765,875,228.00 0.35 8.4493197e7 33,252,590.00 10390860 0.39 6,527,282.00 62,555,533.00 47,582.07 2,254.47 0 1 131,056,160.00 67,078,926.00 0.51 6,634,481.00 8.3449478e7 70,687,288.80 Water only CY09 CY09 2 1 9.88 13.02 374 5.25 0.94650584 5.977142948 5 1866.219805 1494.320894
3 3 Alachua 1019 2 Gainesville Regional Utilities B U South Gainesville Florida FL 32614 USA 12001 Gainesville 245.0 36833 100.0 0.0 0.0 2 2 IB 2 0 7.3 12.34 19.64 7.3 22.18 29.48 0.33 6.0 37.92 43.92 6.0 56.89 62.89 13.3 50.26 63.56 13.3 79.07 92.37 54.0 24.957 31.801 46.22% 58.89% 7708.0 0.0 7708.0 124491 0 124491.0 0 124491.0 169.6332122 61851 7645 0.123603499 0 69496 71.0 5620.0 108.5633803 179,640,510.00 108,415,016.00 0.6 394,617,821.00 230,178,472.00 0.58 2.5712256e7 12,590,285.00 6543205 0.49 0 5,179,080.00 14,065.26 1,633.40 1 1 57,688,361.00 25,264,781.00 0.44 561,085.00 1.0288549e7 5,900,862.80 Water only CY09 FY09 2 1 20.78 6.63 1,318.75 2.77 0.027817561 0.455845935 13 3027.0625 2198.633167
4 4 Alameda 1337 2 East Bay Municipal Utility District A U West Oakland California CA 94623 USA 6001 Oakland 2040.3 52384 0.0 100.0 0.0 1 2 DB 3 0 12.03 21.44 33.47 12.03 33.84 45.87 0.36 11.15 5.9 17.05 11.15 5.9 17.05 23.18 27.34 50.52 23.18 39.74 62.92 181.0 181.0 262.0 100.00% 144.75% 61962.4 0.0 61962.4 1300000 0 1.3e6 0 1.3e6 130.5846154 356173 25555 0.071748841 0 381728 1783.0 24090.0 34.75176669 3,709,906,000.00 2,210,846,000.00 0.6 4,374,434,000.00 2,571,183,000.00 0.59 2.91631e8 227,493,000.00 68518000 0.78 0 7,262,000.00 35,680.44 3,671.47 0 1 360,723,000.00 277,633,000.00 0.77 13,509,000.00 5.851e6 177,800,000.00 Water only FY09 FY09 2 1 14.47 6.12 468.05 56.78 46.59137036 0.809378725 15 1523.785408 858.5948757
5 5 Alameda 1283 1 Alameda County Water District B U West Fremont California CA 94538 USA 6001 Fremont 2040.3 100150 34.0 41.0 25.0 3 NA U 1 0 5.81 27.54 33.35 5.81 41.31 47.12 0.14 0.0 0.0 0.0 0.0 0.0 0.0 5.81 27.54 33.35 5.81 41.31 47.12 75.0 50.0 75.0 66.67% 100.00% 15621.62 0.0 15621.62 333648 0 333648.0 1 333648.0 128.2757844 73012 6775 0.092792966 0 79787 214.0 0.0 72.9982243 467,620,400.00 50,844,200.00 0.11 467,620,400.00 50,844,200.00 0.11 5.67777e7 46,199,600.00 10795800 0.81 2,846,600.00 6,792,500.00 3,254.73 2,957.41 1 1 56,777,700.00 46,199,600.00 0.81 2,846,600.00 6.7925e6 22,618,200.00 Water only FY09 N / R 1 1 14.47 6.12 468.05 56.78 46.59137036 0.809378725 15 1523.785408 858.5948757
6 6 Albemarle 2168 2 Albemarle County Service Authority C U South Charlottesville Virginia VA 22911 USA 51003 Waynesboro 127.4 40551 0.0 0.0 100.0 4 NA IB 2 0 6.15 44.62 50.77 6.15 89.24 95.39 0.07 0.0 53.93 53.93 0.0 80.9 80.9 6.15 98.55 104.7 6.15 170.14 176.29 0.0 0.0 0.0 0.00% 0.00% 1545.7 0.0 1545.7 62518 0 62518.0 1 62518.0 67.73720401 15662 1312 0.083769634 0 16974 38.0 0.0 40.67631579 61,594,162.00 0 0 108,336,426.00 364,100.00 0 1.0257885e7 8,786,314.00 1296812 0.86 0 3,428,498.00 0 5,684.36 0 1 18,964,507.00 15,805,202.00 0.83 21,010.00 6.772006e6 3,997,090.00 Water only FY09 FY09 2 1 13.33 11.08 1,123.40 1.35 0.003824258 10.37407846 18 1641.375 1084.430981
7 7 Allegheny 2087 1 Fox Chapel Authority C U Northeast Pittsburgh (FCA) Pennsylvania PA 15238 USA 42003 Pittsburgh 1692.3 37388 0.0 0.0 100.0 4 NA DB 3 0 4.54 53.33 57.87 4.54 80 84.54 0.06 0.0 0.0 0.0 0.0 0.0 0.0 4.54 53.33 57.87 4.54 80 84.54 0.0 1.82 0.0 0.00% 0.00% 467.193 87.729 554.922 18000 1300 19300.0 1 19300.0 78.77379516 5178 243 0.046929316 2 5423 13.0 0.0 42.68630769 27,444,428.00 11,024,794.00 0.4 27,444,428.00 11,024,794.00 0.4 4.301948e6 2,594,875.00 545448 0.6 537,679.00 630,543.00 19,867.29 4,676.11 1 0 4,301,948.00 2,594,875.00 0.6 537,679.00 630543.0 750,000.00 Water only FY09 N / R 1 1 10.63 11.8 987.81 1.52 19.92541983 241.9507224 28 1287.677419 459.8801384
8 8 Allen 1408 2 Lima Department of Utilities C U Midwest Lima Ohio OH 45801 USA 39003 Lima 266.6 35398 0.0 100.0 0.0 1 2 DB 3 0 7.86 13.82 21.68 7.86 20.73 28.59 0.38 17.87 17.71 35.58 17.87 30.36 48.23 25.73 31.53 57.26 25.73 51.09 76.82 30.0 13.5 18.0 45.00% 60.00% 4015.0 2357.9 6372.9 72000 3000 75000.0 1 75000.0 232.8 22130 1929 0.087166742 1 24060 48.79999924 4441.29 130.5922152 34,744,643.00 3,341,854.00 0.1 77,969,109.00 13,684,719.00 0.18 9.365747e6 8,116,866.00 1133394 0.87 287,673.00 184,502.00 524.39 1,273.65 1 0 17,862,416.00 13,597,543.00 0.76 1,048,863.00 989326.0 10,230,266.00 Water only FY08 FY08 2 1 10.39 12.64 927.77 1.63 0.535210085 79.85310308 29 1285.464217 656.343153
9 9 Anderson 30021 2 Oak Ridge, City of C U South Oak Ridge Tennessee TN 37831-0001 USA 47001 Oak Ridge 211.4 54862 0.0 100.0 0.0 1 2 DB 3 0 11.5 24.93 36.43 11.5 41.34 52.84 0.28 13.5 28.22 41.72 13.5 48.44 61.94 25 53.15 78.15 25 89.78 114.78 28.0 10.0 13.0 35.71% 46.43% 1074.0 2174.0 3248.0 27500 0 27500.0 1 0.0 323.5865504 11293 1625 0.143894448 1 12919 0.0 1973.7 #DIV/0! 0 0 #DIV/0! 0 0 #DIV/0! 0.0 0 0 #DIV/0! 0 0 0 0 0 0 0 0 #DIV/0! 0 0.0 1,770,000.00 NA N / R N / R 2 0 13.45 10.63 1,399.02 1.49 0.005511492 13.55470289 36 798.1153846 494.0790067
10 10 Anne Arundel 30006 2 City of Annapolis C U South Annapolis Maryland MD 21401 USA 24003 Annapolis 1246.8 64400 100.0 0.0 0.0 2 2 DB 3 0 4.2 11.34 15.54 4.2 18.63 22.83 0.23 6.07 17.41 23.48 6.07 26.94 33.01 10.27 28.75 39.02 10.27 45.57 55.84 10.0 3.91 6.3 39.10% 63.00% 1186.0 0.0 1186.0 38900 0 38900.0 0 38900.0 83.52995035 10474 1939 0.185125072 0 12413 22.0 1790.0 53.90909091 18,884,860.00 3,254,453.00 0.17 44,424,758.00 7,477,401.00 0.17 3.250584e6 4,736,853.00 554074 1.46 212,320.00 -1,816,385.00 2,744.06 3,993.97 1 0 8,198,446.00 9,122,853.00 1.11 377,027.00 -293936.0 10,872,600.00 Water only CY09 CY09 2 1 9.9 8.85 967.6 1.31 0.711322932 4.596156945 39 1712.142857 1078.942619
11 11 Atchison 4231 1 City of Atchison C U Midwest Atchison Kansas KS 66002 USA 20005 Atchison 37.8 40684 0.0 100.0 0.0 1 2 DB 3 0 23.38 21.99 45.37 23.38 36.49 59.87 0.64 0.0 0.0 0.0 0.0 0.0 0.0 23.38 21.99 45.37 23.38 36.49 59.87 8.6 3.754 5.678 43.65% 66.02% 840.396 188.594 1028.99 10402 2650 13052.0 1 13052.0 215.9937699 3706 496 0.133837021 5 4207 5.5 0.0 187.0890909 11,358,405.00 6,390,072.00 0.56 11,358,405.00 6,390,072.00 0.56 2.733628e6 1,394,251.00 479110 0.51 352,394.00 1,383,936.00 6,210.04 1,354.97 0 1 2,733,628.00 1,394,251.00 0.51 352,394.00 1.383936e6 210,411.00 Water only CY09 N / R 1 1 12.19 13.42 923.55 4.35 0.240948368 1.242559969 65 1099.280899 685.1325214
12 12 Baltimore 1168 2 City of Baltimore Department of Public Works A U South Baltimore Maryland MD 21202 USA 24005 Baltimore 1300.3 39336 0.0 100.0 0.0 1 2 DB 3 0 8.23 16.46 24.69 8.23 28.81 37.04 0.29 11.06 22.13 33.19 11.06 38.72 49.78 19.29 38.59 57.88 19.29 67.53 86.82 360.0 226.0 0.0 62.78% 0.00% 25769.0 37195.0 62964.0 1800000 0 1.8e6 0 1.8e6 95.83561644 193881 0 0 4 193885 893.0 65000.0 70.50839866 1,007,440,000.00 454,940,000.00 0.45 2,761,248,000.00 1,102,175,000.00 0.4 1.1984e8 94,547,000.00 11888000 0.79 10,434,000.00 3,364,000.00 7,225.40 1,501.60 0 0 119,840,000.00 215,670,000.00 1.8 20,462,000.00 8.956e6 74,093,820.80 Water only FY09 N / R 2 1 11.47 10.9 1,106.57 1.31 1.936986763 194.8737825 85 1343.935696 712.3397972
13 13 Bartow 2553 1 Cartersville Water Department C U South Cartersville Georgia GA 30120 USA 13015 Cartersville 196.2 53832 0.0 100.0 0.0 1 2 IB 2 0 6 12 18.0 6 26.94 32.94 0.22 0.0 0.0 0.0 0.0 0.0 0.0 6 12 18.0 6 26.94 32.94 27.0 11.02 14.06 40.81% 52.07% 2363.0 1701.0 4064.0 19382 76818 96200.0 0 96200.0 115.7406089 9036 1401 0.155046481 1 10438 21.0 0.0 193.5238095 0 0 #DIV/0! 0 0 #DIV/0! 1.142e7 10,129,400.00 0 0.89 0 329,600.00 0 2,492.47 1 0 11,420,000.00 10,129,400.00 0.89 0 329600.0 12,039,250.00 Combined water and wastewater FY09 N / R 1 1 15.59 10.03 1,305.98 1.41 0.006829747 4.345174021 101 2453.0 337.4033195
14 14 Bay 2390 1 City of Panama City C U South Panama City Florida FL 32405 USA 12005 Panama City 208.3 41290 0.0 0.0 100.0 4 NA U 1 0 6.4 18.55 24.95 6.4 27.83 34.23 0.23 0.0 0.0 0.0 0.0 0.0 0.0 6.4 18.55 24.95 6.4 27.83 34.23 0.0 0.0 0.0 0.00% 0.00% 1988.175 0.0 1988.175 38000 0 38000.0 0 38000.0 143.3435472 13778 3227 0.234213964 0 17005 89.5 0.0 22.21424581 0 0 #DIV/0! 0 0 #DIV/0! 1.4736091e7 9,689,123.00 2010357 0.66 829,960.00 1,344,651.00 0 4,873.38 1 0 14,736,091.00 9,689,123.00 0.66 829,960.00 1.344651e6 1,157,000.00 Combined water and wastewater FY09 N / R 1 1 14.74 5.77 1,391.78 1.93 0.015210278 1.206090066 105 3947.719008 3598.653966
15 15 Bennington 3905 1 City of Bennington C U Northeast Bennington Vermont VT 5201 USA 50003 Bennington 54.6 44081 5.0 95.0 0.0 1 1 U 1 0 44.87 20.64 65.51 44.87 30.97 75.84 1.45 0.0 0.0 0.0 0.0 0.0 0.0 44.87 20.64 65.51 44.87 30.97 75.84 4.0 1.5 2.8 37.50% 70.00% 538.0 7.2 545.2 13000 1 13001.0 1 13001.0 114.8910569 2800 1000 0.357142857 1 3801 6.0 0.0 90.86666667 8,949,679.00 6,455,608.00 0.72 8,949,679.00 6,455,608.00 0.72 1.385168e6 1,457,974.00 411349 1.05 0 -484,155.00 11,840.81 2,674.20 0 0 1,385,168.00 1,457,974.00 1.05 0 -484155.0 1,000,000.00 Water only FY09 N / R 1 1 5.74 12.9 1,329.05 1.16 0.001165819 8.08999994 125 945.6666667 338.098112
16 16 Benton 1547 3 Benton Washington Reg. Public Water Auth. C U South Rogers Arkansas AR 72756-9088 USA 5007 Rogers 206.6 52932 0.0 100.0 0.0 1 2 NA NA 0 0 0 0.0 0 0 0 #DIV/0! 0.0 0.0 0.0 0.0 0.0 0.0 0 0 0.0 0 0 0.0 16.0 7.01 16.0 43.81% 100.00% 0.0 2260.738 2260.738 0 100540 100540.0 1 0.0 61.60535846 0 0 #DIV/0! 17 17 16.0 0.0 141.296125 68,576,213.00 49,689,705.00 0.72 68,576,213.00 49,689,705.00 0.72 4.625323e6 1,794,047.00 1217860 0.39 1,195,252.00 642,431.00 21,979.42 793.57 0 0 4,625,323.00 1,794,047.00 0.39 1,195,252.00 642431.0 1,350,000.00 Water only N / R N / R 3 0 14.48 11.41 1,139.00 1.93 0.013021176 0.44850403 128 2073.108052 1683.007876
17 17 Benton 3660 2 City of Corvallis C U West Corvallis Oregon OR 97330 USA 41003 Corvallis 121.3 46082 0.0 100.0 0.0 1 2 IDB 4 0 12.15 12.43 24.58 12.15 23.98 36.13 0.51 9.88 29.4 39.28 9.88 44.1 53.98 22.03 41.83 63.86 22.03 68.08 90.11 24.0 7.1 16.2 29.58% 67.50% 2529.4 0.0 2529.4 55125 0 55125.0 1 55125.0 125.7118007 13415 1165 0.086843086 0 14580 32.90999985 3399.73 76.8580982 51,315,434.00 4,625,080.00 0.09 131,933,109.00 23,091,674.00 0.18 8.786133e6 8,051,351.00 1635852 0.92 292,358.00 -487,556.00 1,828.53 3,183.11 0 1 18,083,566.00 16,253,144.00 0.9 1,241,476.00 -1.710462e6 1,263,422.00 Water only FY09 FY09 2 1 10.43 7.47 1,699.13 13.14 0.01281876 1.154751326 128 2073.108052 1683.007876
18 18 Benton 3594 2 Kennewick, City of C U West Kennewick Washington WA 99336 USA 53005 Kennewick 90.0 53899 41.28 58.72 0.0 3 NA U 1 0 9.32 10.57 19.89 9.32 15.86 25.18 0.59 19.24 0.0 19.24 19.24 0.0 19.24 28.56 10.57 39.13 28.56 15.86 44.42 30.0 10.8 24.06 36.00% 80.20% 3673.76 0.0 3673.76 69454 0 69454.0 0 69454.0 144.9174402 19043 2120 0.111326997 0 21163 17.5 1993.78 209.9291429 138,888,272.00 33,997,148.00 0.24 138,888,272.00 33,997,148.00 0.24 8.245542e6 5,288,636.00 2381258 0.64 0 753,095.00 9,254.05 1,439.57 1 1 14,932,355.00 9,196,804.00 0.62 0 2.178827e6 3,943,800.00 Water only N / R FY09 2 1 11.09 11.7 215.24 4.6 0.380828623 888.2173831 128 2073.108052 1683.007876
19 19 Berkeley 2220 2 Berkeley Water & Sanitation C U South Berkeley County South Carolina SC 29461 USA 45015 Berkeley 122.1 52192 0.0 0.0 100.0 4 NA U 1 0 8.5 22.96 31.46 8.5 43.44 51.94 0.2 44.0 0.0 44.0 44.0 0.0 44.0 52.5 22.96 75.46 52.5 43.44 95.94 0.0 0.0 0.0 0.00% 0.00% 1715.581259 0.0 1715.581259 50245 0 50245.0 1 50245.0 93.54607677 17513 758 0.043282133 2 18273 51.29999924 4357.0 33.4421303 115,155,876.95 56,292,833.79 0.49 393,236,182.93 201,870,434.91 0.51 8.3142264e6 5,280,130.67 2582261 0.64 90,975.00 1,261,355.56 32,812.69 3,077.75 0 0 33,591,364.86 16,006,680.00 0.48 7,917,295.00 6.44667398e6 3,671,973.20 Water only FY09 FY09 2 1 16.95 8.56 1,161.20 2.1 0.01130524 18.70009425 130 1517.381481 787.8887881
20 20 Bernalillo 1326 2 Albuquerque Bernalillo County Water Utility Authority B U West Albuquerque New Mexico NM 87120 USA 35001 Albuquerque 517.8 50052 75.0 25.0 0.0 3 1 U 1 1 11.41 14.1 25.51 11.41 21.15 32.56 0.54 7.49 7.81 15.3 7.49 11.71 19.2 18.9 21.91 40.81 18.9 32.86 51.76 294.0 87.51 150.0 29.77% 51.02% 2716.4 0.0 2716.4 595000 0 595000.0 0 0.0 12.50788535 171983 19830 0.115302094 0 191813 210.0 21170.0 12.9352381 1,434,211,198.00 617,193,912.00 0.43 1,434,211,198.00 617,193,912.00 0.43 1.52232345e8 140,185,811.00 393410 0.92 0 19,679,654.00 227,210.25 51,607.20 1 0 152,232,345.00 280,371,622.00 1.84 0 3.9359308e7 #DIV/0! Combined water and wastewater FY08 FY08 2 0 11.33 11.65 278.73 3.18 7.406956469 13.24936598 133 1426.905263 1452.422101
21 21 Bexar 1526 2 San Antonio Water System A U South San Antonio Texas TX 78298 USA 48029 San Antonio 1216.6 47361 94.83 0.0 5.17 2 1 IB 2 1 6.96 19.6 26.56 6.96 30.9 37.86 0.23 7.81 12.31 20.12 7.81 20.0 27.81 14.77 31.91 46.68 14.77 50.9 65.67 826.0 181.4 243.0 21.96% 29.42% 55176.0 119.0 55295.0 1340549 0 1.340549e6 0 1.340549e6 113.0082904 327610 23242 0.07094411 7 350859 645.0 51987.0 85.72868217 2,131,876,349.00 1,064,883,922.00 0.5 3,777,231,489.00 1,846,000,356.00 0.49 2.21512601e8 133,747,390.00 47019268 0.6 39,001,302.00 -2,350,804.00 19,258.23 2,418.80 1 1 356,339,136.00 209,894,831.00 0.59 66,285,409.00 -6.463547e6 151,720,000.00 Water only CY09 CY09 2 1 20.28 8.53 769.17 2.09 17.83594691 11.51035236 136 6421.4 531.8959485
22 22 Black Hawk 1075 1 Waterloo Water Works C U Midwest Waterloo Iowa IA 50704 USA 19013 Waterloo 224.5 44586 100.0 0.0 0.0 2 2 DB 3 0 5.25 7.91 13.16 5.25 13.56 18.81 0.39 0.0 0.0 0.0 0.0 0.0 0.0 5.25 7.91 13.16 5.25 13.56 18.81 50.0 12.8 17.58 25.60% 35.16% 3720.18 104.03 3824.21 70384 3169 73553.0 1 73553.0 142.4454158 24086 1732 0.071908993 2 25820 36.0 0.0 106.2280556 25,505,042.00 2,105,824.00 0.08 25,505,042.00 2,105,824.00 0.08 5.719686e6 4,587,738.00 493497 0.8 108,696.00 1,190,531.00 550.66 1,199.66 1 1 5,719,686.00 4,587,738.00 0.8 108,696.00 1.190531e6 2,564,106.60 Water only CY09 N / R 1 1 8.24 14.4 863.79 4.3 1.298787081 12.72201405 143 1816.675824 1119.17127
23 23 Blount 2299 2 Maryville Utilities, City of C U South Maryville Tennessee TN 37801 USA 47009 Maryville 199.2 52499 0.0 99.94 0.06 1 2 DB 3 0 5.67 16.11 21.78 5.67 25.45 31.12 0.22 5.07 28.2 33.27 5.07 42.3 47.37 10.74 44.31 55.05 10.74 67.75 78.49 6.0 3.974 5.653 66.23% 94.22% 1084.5975 0.0 1084.5975 30374 0 30374.0 1 0.0 97.83038125 12903 1557 0.120669612 0 14460 31.0 0.0 34.98701613 103,294,420.00 51,240,000.00 0.5 103,294,420.00 51,240,000.00 0.5 1.1372336e7 7,736,229.00 1627625 0.68 2,378,155.00 105,235.00 47,243.33 7,132.81 0 0 11,372,336.00 15,472,458.00 1.36 4,756,310.00 210470.0 1,651,657.40 Combined water and wastewater FY09 FY09 2 0 13.65 10.32 1,379.05 1.47 0.007535285 126.845868 150 1436.238095 817.4877471
24 24 Boulder 1610 2 Boulder, City of C U West Boulder Colorado CO 80302 USA 8013 Boulder 396.1 58522 0.0 0.0 100.0 4 NA IB 2 0 8.55 18.44 26.99 8.55 39.62 48.17 0.22 0.96 28.42 29.38 0.96 42.64 43.6 9.51 46.86 56.37 9.51 82.26 91.77 53.0 15.41 30.5 29.08% 57.55% 4987.0 0.0 4987.0 115881 0 115881.0 1 115881.0 117.9055557 25042 3416 0.13641083 0 28458 75.12999725 4915.0 66.37828008 236,489,000.00 45,360,000.00 0.19 342,655,000.00 86,597,000.00 0.25 2.0173e7 11,197,000.00 4989000 0.56 2,114,000.00 862,000.00 9,095.65 2,245.24 0 1 32,894,000.00 18,943,000.00 0.58 3,782,000.00 1.302e6 4,820,091.60 Water only CY09 CY09 2 1 5.09 11.9 556.73 2.11 0.064140355 1.675958612 164 999.4566745 852.4835878
25 25 Boulder 1616 2 Longmont, City of C U West Longmont Colorado CO 80501 USA 8013 Longmont 396.1 66926 0.0 100.0 0.0 1 2 IB 2 0 3.66 4.03 7.69 3.66 6.94 10.6 0.53 7.29 17.22 24.51 7.29 27.06 34.35 10.95 21.25 32.2 10.95 34 44.95 47.0 13.66 29.49 29.06% 62.74% 4245.8 0.0 4245.8 86303 0 86303.0 1 86303.0 134.7847557 23553 2988 0.12686282 0 26541 52.34999847 967.25 81.10410934 332,354,156.00 15,398,953.00 0.05 427,672,924.00 16,017,826.00 0.04 1.202335e7 9,398,073.00 3847442 0.78 0 -2,818,585.00 3,626.87 2,213.50 1 0 19,439,389.00 15,467,067.00 0.8 268,225.00 -4.121233e6 6,945,578.80 Water only CY09 CY09 2 1 5.09 11.9 556.73 2.11 0.064140355 1.675958612 164 999.4566745 852.4835878
26 26 Boulder 4359 2 Lafayette Water Department C U West Lafayette Colorado CO 80026 USA 8013 Lafayette 396.1 73729 0.0 100.0 0.0 1 2 IB 2 0 9.15 14.43 23.58 9.15 24.95 34.1 0.37 8.31 6.41 14.72 8.31 11.41 19.72 17.46 20.84 38.3 17.46 36.36 53.82 13.0 3.7 8.2 28.46% 63.08% 1159.86 29.363 1189.223 32000 800 32800.0 1 32800.0 99.33369529 7671 532 0.069352105 2 8205 21.10000038 741.0 56.3612786 98,136,454.00 17,402,741.00 0.18 126,487,753.00 23,273,971.00 0.18 4.828996e6 2,813,144.00 1646109 0.58 890,948.00 1,073,177.00 14,633.71 2,365.53 0 1 6,482,405.00 4,429,035.00 0.68 1,112,575.00 251207.0 3,344,600.00 Water only FY09 FY09 2 1 5.09 11.9 556.73 2.11 0.064140355 1.675958612 164 999.4566745 852.4835878
27 27 Branch 7355 2 Coldwater Board of Public Utilities C U Midwest Coldwater Michigan MI 7355 USA 26023 Coldwater 91.7 44352 100.0 0.0 0.0 2 2 DB 3 0 12.35 15.26 27.61 12.35 23.98 36.33 0.52 14.59 11.34 25.93 14.59 17.82 32.41 26.94 26.6 53.54 26.94 41.8 68.74 6.6 1.919 3.59 29.08% 54.39% 492.58 0.0 492.58 12700 0 12700.0 0 12700.0 106.2625391 3875 719 0.185548387 0 4594 7.0 917.1 70.36857143 12,355,678.00 5,810,000.00 0.47 27,896,206.00 11,925,000.00 0.43 2.116761e6 1,200,967.00 399671 0.57 248,700.00 341,098.00 11,795.04 2,438.12 0 0 4,571,795.00 2,635,390.00 0.58 526,010.00 533557.0 371,000.00 Water only FY09 FY09 2 1 9.03 12.86 910.12 1.77 0.280595301 1.783249152 175 928.5 458.912301
28 28 Brevard 1640 2 City of Cocoa B U South Cocoa Florida FL 32922 USA 12009 Cocoa 501.9 35392 80.0 20.0 0.0 2 NA IB 2 0 10.47 14.7 25.17 10.47 26.01 36.48 0.4 9.77 32.41 42.18 9.77 50.93 60.7 20.24 47.11 67.35 20.24 76.94 97.18 48.0 25.35 34.45 52.81% 71.77% 8360.514 0.0 8360.514 245000 0 245000.0 1 0.0 93.49190942 76410 0 0 0 76410 143.5 643.66 58.2614216 208,056,605.00 78,185,401.00 0.38 208,056,605.00 78,185,401.00 0.38 4.1132721e7 32,022,078.00 7550957 0.78 3,220,301.00 5,897,698.00 9,351.75 3,830.16 1 1 41,132,721.00 64,044,156.00 1.56 6,440,602.00 1.1795396e7 13,912,815.40 Combined water and wastewater FY09 FY09 2 0 15.34 3.66 1,211.34 3.18 0.08029567 5.438614991 182 1403.222222 2505.831238
29 29 Brevard 1027 2 Melbourne Water Department, City of C U South Melbourne Florida FL 32901 USA 12009 Melbourne 501.9 45212 30.0 70.0 0.0 1 NA NA 4 0 6.25 28.5 34.75 6.25 43.12 49.37 0.14 8.18 43.8 51.98 8.18 66.3 74.48 14.43 72.3 86.73 14.43 109.42 123.85 26.5 14.9 18.9 56.23% 71.32% 0.0 0.0 0.0 150000 15328 165328.0 1 0.0 0 51719 4933 0.095380808 45 56697 80.0 2151.759 0 213,153,688.00 118,629,993.00 0.56 213,153,688.00 118,629,993.00 0.56 4.057917e7 33,164,016.00 9379103 0.82 4,936,601.00 -5,316,559.00 #DIV/0! #DIV/0! 0 1 40,579,170.00 66,329,032.00 1.63 9,873,202.00 -1.0634118e7 531,760.00 Combined water and wastewater FY09 FY09 2 0 15.34 3.66 1,211.34 3.18 0.08029567 5.438614991 182 1403.222222 2505.831238
30 30 Broward 1037 2 Broward County Water and Wastewater Services B U South Broward County Florida FL 33069 USA 12011 Pompano Beach 1449.5 54524 76.07 0.0 23.93 2 NA IB 2 0 12.14 20.55 32.69 12.14 38.66 50.8 0.31 15.43 22.29 37.72 15.43 33.44 48.87 27.57 42.84 70.41 27.57 72.1 99.67 46.0 20.29 22.75 44.11% 49.46% 7182.15 1819.32 9001.47 230000 61000 291000.0 1 0.0 84.74763451 52025 6177 0.118731379 3 58205 349.0 23793.0 25.79217765 809,182,431.00 425,139,830.00 0.53 809,182,431.00 425,139,830.00 0.53 1.08085468e8 64,788,684.00 33120285 0.6 15,814,160.00 1,427,215.00 47,230.04 7,197.57 0 1 108,085,468.00 129,577,368.00 1.2 31,628,320.00 2.85443e6 40,299,934.00 Combined water and wastewater FY09 FY09 2 0 21.59 3.81 1,473.08 3.8 0.603386414 4.01E-06 192 2835.698413 3404.365641
&vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip &vellip



In [3]:

    
awwa[:costs] = convert(DataVector{Float64}, map(x -> isna(x) || x == "#DIV/0!" ? NA : parse(Float64, replace(x, ",", "")), awwa[:ISBeforeDepreciation]));
awwa[:SurfaceMG] = awwa[:Surface] .* awwa[:AnnualMGallonsSoldTotal] / 100
awwa[:GroundMG] = awwa[:Ground] .* awwa[:AnnualMGallonsSoldTotal] / 100
#awwa[:Purchases] = map(x -> isna(x) ? NA : (v = tryparse(Float64, x); isnull(v) ? NA : get(v)), awwa[:Purchases])
awwa[:PurchasesMG] = awwa[:Purchases] .* awwa[:AnnualMGallonsSoldTotal] / 100;



In [4]:

    
mean(awwa[:depth][.!isna.(awwa[:depth])])









    Out[4]:





1125.5941329695002



In [5]:

    
using FixedEffectModels



In [6]:

    
rr = reg(awwa, @model(costs ~ SurfaceMG + GroundMG + PurchasesMG))









    



WARNING: ccdf(d::UnivariateDistribution, X::AbstractArray) is deprecated, use ccdf.(d, X) instead.
Stacktrace:
 [1] depwarn(::String, ::Symbol) at ./deprecated.jl:70
 [2] ccdf(::Distributions.FDist{Float64}, ::Array{Float64,1}) at ./deprecated.jl:57
 [3] coeftable(::FixedEffectModels.RegressionResult) at /Users/jrising/.julia/v0.6/FixedEffectModels/src/RegressionResult.jl:80
 [4] limitstringmime(::MIME{Symbol("text/plain")}, ::FixedEffectModels.RegressionResult) at /Users/jrising/.julia/v0.6/IJulia/src/inline.jl:24
 [5] display_dict(::FixedEffectModels.RegressionResult) at /Users/jrising/.julia/v0.6/IJulia/src/execute_request.jl:28
 [6] (::Compat.#inner#17{Array{Any,1},IJulia.#display_dict,Tuple{FixedEffectModels.RegressionResult}})() at /Users/jrising/.julia/v0.6/Compat/src/Compat.jl:488
 [7] execute_request(::ZMQ.Socket, ::IJulia.Msg) at /Users/jrising/.julia/v0.6/IJulia/src/execute_request.jl:186
 [8] (::Compat.#inner#17{Array{Any,1},IJulia.#execute_request,Tuple{ZMQ.Socket,IJulia.Msg}})() at /Users/jrising/.julia/v0.6/Compat/src/Compat.jl:488
 [9] eventloop(::ZMQ.Socket) at /Users/jrising/.julia/v0.6/IJulia/src/eventloop.jl:8
 [10] (::IJulia.##14#17)() at ./task.jl:335
while loading /Users/jrising/.julia/v0.6/IJulia/src/kernel.jl, in expression starting on line 31






    Out[6]:





                             Linear Model                             
=======================================================================
Number of obs:                 323   Degrees of freedom:              4
R2:                          0.706   R2 Adjusted:                 0.703
F Statistic:               634.506   p-value:                     0.000
              Estimate Std.Error  t value Pr(>|t|)  Lower 95% Upper 95%
SurfaceMG      3188.93   127.086  25.0928    0.000     2938.9   3438.96
GroundMG       1365.21   399.996  3.41305    0.001    578.244   2152.17
PurchasesMG    3106.28   294.385  10.5518    0.000     2527.1   3685.46
(Intercept)  1.48265e6 3.56121e6 0.416332    0.677 -5.52378e6 8.48908e6



In [7]:

    
rr = reg(awwa, @model(costs ~ SurfaceMG + GroundMG + GroundMG & depth + PurchasesMG))









    



=======================================================================
-----------------------------------------------------------------------
=======================================================================






    Out[7]:





                               Linear Model                               
===========================================================================
Number of obs:                   320   Degrees of freedom:                5
R2:                            0.579   R2 Adjusted:                   0.574
F Statistic:                  151.86   p-value:                       0.000
                   Estimate Std.Error  t value Pr(>|t|) Lower 95% Upper 95%
SurfaceMG           1606.73   136.596  11.7626    0.000   1337.98   1875.49
GroundMG            1657.99   492.498   3.3665    0.001   688.991   2626.99
PurchasesMG         3086.09   217.028  14.2198    0.000   2659.09    3513.1
GroundMG & depth   0.277748  0.453235 0.612812    0.540 -0.614003    1.1695
(Intercept)       9.99565e6 2.66335e6  3.75303    0.000 4.75544e6 1.52359e7



In [8]:

    
regtable(rr; renderSettings = latexOutput())









    



===========================================================================
---------------------------------------------------------------------------
===========================================================================
\begin{tabular}{lr}
\toprule
                 & \multicolumn{1}{c}{costs} \\ 
\cmidrule(lr){2-2} 
                 &                       (1) \\ 
\midrule
(Intercept)      &            9995648.366*** \\ 
                 &             (2663351.993) \\ 
SurfaceMG        &               1606.733*** \\ 
                 &                 (136.596) \\ 
GroundMG         &               1657.993*** \\ 
                 &                 (492.498) \\ 
PurchasesMG      &               3086.094*** \\ 
                 &                 (217.028) \\ 
GroundMG & depth &                     0.278 \\ 
                 &                   (0.453) \\ 
\midrule
Estimator        &                       OLS \\ 
\midrule
$N$              &                       320 \\ 
$R^2$            &                     0.579 \\ 
\bottomrule
\end{tabular}



In [15]:

    
using GLM, StatsModels, QuantileRegression
import StatsModels.@formula
import StatsModels.ModelFrame



In [16]:

    
qreg(@formula(costs ~ SurfaceMG + GroundMG + PurchasesMG), awwa, .5)









    



UndefVarError: ModelFrame not defined

Stacktrace:
 [1] qreg(::StatsModels.Formula, ::DataFrames.DataFrame, ::Float64, ::QuantileRegression.IP) at /Users/jrising/.julia/v0.6/QuantileRegression/src/QuantileRegression.jl:35 (repeats 2 times)



In [7]:

    
optnation = readtable("../../analyses/optradii/radius-nation.csv");
optstate = readtable("../../analyses/optradii/radius-state.csv");
#opt200km = readtable("../../analyses/optradii/radius-200km.csv");
opt100km = readtable("../../analyses/optradii/radius-100km.csv");
opt50km = readtable("../../analyses/optradii/radius-50km.csv");
#opt0km = readtable("../../analyses/optradii/radius-0km.csv");
optneighbors = readtable("../../analyses/optradii/radius-neighbors.csv");
optsingle = readtable("../../analyses/optradii/radius-single.csv");
optcounty = readtable("../../analyses/optradii/radius-nothing.csv");



In [10]:

    
DataFrame(radius=["Nation", "State", "Neighbors", "County"], # "200 km", "0 km", "100 km", "50 km", "Single", 
    surface=[sum(optnation[optnation[:variable] .== "withdrawals", :optimized]),
        sum(optstate[optstate[:variable] .== "withdrawals", :optimized]),
#        sum(opt200km[opt200km[:variable] .== "withdrawals", :optimized]),
#        sum(opt100km[opt100km[:variable] .== "withdrawals", :optimized]),
#        sum(opt50km[opt50km[:variable] .== "withdrawals", :optimized]),
#        sum(opt0km[opt0km[:variable] .== "withdrawals", :optimized]),
        sum(optneighbors[optneighbors[:variable] .== "withdrawals", :optimized]),
#        sum(optsingle[optsingle[:variable] .== "withdrawals", :optimized]),
        sum(optcounty[optcounty[:variable] .== "withdrawals", :optimized])],        
    groundwater=[sum(optnation[optnation[:variable] .== "waterfromgw", :optimized]),
        sum(optstate[optstate[:variable] .== "waterfromgw", :optimized]),
#        sum(opt200km[opt200km[:variable] .== "waterfromgw", :optimized]),
#        sum(opt100km[opt100km[:variable] .== "waterfromgw", :optimized]),
#        sum(opt50km[opt50km[:variable] .== "waterfromgw", :optimized]),
#        sum(opt0km[opt0km[:variable] .== "waterfromgw", :optimized]),
        sum(optneighbors[optneighbors[:variable] .== "waterfromgw", :optimized]),
#        sum(optsingle[optsingle[:variable] .== "waterfromgw", :optimized]),
        sum(optcounty[optcounty[:variable] .== "waterfromgw", :optimized])])









    Out[10]:




radius surface groundwater
1 Nation 4.7700663946448874e8 5.727795615511276e6
2 State 1.4261982262421383e10 1.0178368529331375e7
3 Neighbors 4.570581528183927e8 2.5676282261607297e7
4 County 3.726519630078e8 1.0797075467999999e8



In [17]:

    
DataFrame(transition=["County2Neighbors", "", "100km2State", "State2Nation"],
    surface=[sum(optneighbors[optneighbors[:variable] .== "withdrawals", :optimized] - optcounty[optcounty[:variable] .== "withdrawals", :optimized]) / sum(optcounty[optcounty[:variable] .== "withdrawals", :optimized]),
             0,
             sum(optstate[optstate[:variable] .== "withdrawals", :optimized] - opt100km[opt100km[:variable] .== "withdrawals", :optimized]) / sum(opt100km[opt100km[:variable] .== "withdrawals", :optimized]),
             sum(optnation[optnation[:variable] .== "withdrawals", :optimized] - optstate[optstate[:variable] .== "withdrawals", :optimized]) / sum(optstate[optstate[:variable] .== "withdrawals", :optimized])],
    groundwater=[sum(optneighbors[optneighbors[:variable] .== "waterfromgw", :optimized] - optcounty[optcounty[:variable] .== "waterfromgw", :optimized]) / sum(optcounty[optcounty[:variable] .== "waterfromgw", :optimized]),
             0,
             sum(optstate[optstate[:variable] .== "waterfromgw", :optimized] - opt100km[opt100km[:variable] .== "waterfromgw", :optimized]) / sum(opt100km[opt100km[:variable] .== "waterfromgw", :optimized]),
             sum(optnation[optnation[:variable] .== "waterfromgw", :optimized] - optstate[optstate[:variable] .== "waterfromgw", :optimized]) / sum(optstate[optstate[:variable] .== "waterfromgw", :optimized])])









    Out[17]:




transition surface groundwater
1 County2Neighbors -0.9519037243018486 -0.3177891935097157
2 0.0 0.0
3 100km2State 46.84688525625985 -0.9670333073424108
4 State2Nation -0.7027009411896701 -0.06344522575111837



In [11]:

    
stateextracts = sum(reshape(getparametersolution(house, sol_after.sol, :waterfromgw), nrow(recorded), 2), 2);
nationextracts = sum(reshape(getparametersolution(house, sol_before.sol, :waterfromgw), nrow(recorded), 2), 2);



In [20]:

    
diffs_state2county = recorded[:TO_GW] * 1383. - vec(stateextracts);
diffs_nation2state = vec(stateextracts - nationextracts);



In [22]:

    
df = DataFrame(fips=readtable("../../data/extraction/USGS-2010.csv")[:FIPS], state2county=diffs_state2county, nation2state=diffs_nation2state)









    



WARNING: imported binding for df overwritten in module Main






    Out[22]:




fips state2county nation2state
1 1001 13452.398234187258 0.0
2 1003 62275.908108707816 -15874.060042775025
3 1005 5744.905031219915 865.8835775124799
4 1007 3695.116453307127 -828.1292149080609
5 1009 5587.32 0.0
6 1011 -222.86040044584934 1834.0554004458495
7 1013 2033.0100000000002 1043.5431993970915
8 1015 22579.001702385372 -16000.179690772746
9 1017 -2420.2500000000005 2610.363079411765
10 1019 4384.11 0.0
11 1021 6841.105761371275 0.0
12 1023 -2272.0314942316727 -14374.068123244986
13 1025 4231.9800000000005 0.0
14 1027 -2315.115882886881 -312.58411711311874
15 1029 20.74499999999989 1013.8423573622051
16 1031 11972.229461852588 -3271.3801837660085
17 1033 -12768.130217710916 15630.940217710915
18 1035 1503.7244616279077 -120.72446162790698
19 1037 1161.72 0.0
20 1039 9708.66 -4423.704084971649
21 1041 3214.929698127182 -1155.7338259257454
22 1043 -43655.00935695464 30293.5734627196
23 1045 6320.472494844308 4764.821043495628
24 1047 17204.52 0.0
25 1049 -10365.5602 12762.736880487475
26 1051 6832.02 0.0
27 1053 12008.802560451633 2678.657439548366
28 1055 7509.69 -3951.9934619146516
29 1057 -5265.585635847209 2962.8906358472086
30 1059 -1656.9945819386521 4727.254581938652
&vellip &vellip &vellip &vellip



In [91]:

    
mapinited = false
include("../../src/lib/graphing.jl")



In [92]:

    
df[:value] = df[:state2county]
usmap(df, true)









    












    Out[92]:





RCall.RObject{RCall.VecSxp}



In [93]:

    
df[:value] = df[:nation2state]
usmap(df, true)









    












    Out[93]:





RCall.RObject{RCall.VecSxp}

	x	County	WaterstatsID	UtilityType	UtilityName	AWWAGroup	Category	Region	AWWA_City	State_Name	State	Zip	Country	FIPS	City	PopDens	MedianIncome	Ground	Surface	Purchases	PrimarySource	SplitPercent	ResidentialRateStr	RateStruct	Seasonal	ResCharges1000cfService	ResCharges1000cfVolume	ResCharges1000cfTotal	ResCharges1500cfService	ResCharges1500cfVolume	ResCharges1500cfTotal	FixedChargeRatio	WWCharges1000cfService	WWCharges1000cfVolume	WWCharges1000cfTotal	WWCharges1500cfService	WWCharges1500cfVolume	WWCharges1500cfTotal	CombResCharges1000cfService	CombResCharges1000cfVolume	CombResCharges1000cfTotal	CombResCharges1500cfService	CombResCharges1500cfVolume	CombResCharges1500cfTotal	MGDailyWaterTreatmntProdCapacity	MGDAverageDayWaterProduction	MGDMaxDayWaterProduction	AvgPlantUtilization	MaxPlantUtilization	AnnualMGallonsSoldResNonres	AnnualMGallonsSoldWholesale	AnnualMGallonsSoldTotal	SvcPopRetail	SvcPopWholesale	SvcPopTotal	X_x	ScvPop	DailyPerCapitaConsumptionGallons	ActiveAccountResidential	ActiveAccountNonRes	AccountRatio_NonRes	ActiveAccountWholesale	ActiveAccountTotal	BSFullTimeEmployees	MGYWWTotalGallonsTreated	WaterPerEmployee	BSTotalAssets	BSLongtermDebt	DebtRatio	BSTotalAssetsComb	BSLongTermDebtComb	DebtRatioComb	ISOperatingRevenues	ISBeforeDepreciation	IncomeStatement_Depreciation_Expense	OpExpRev	ISInterestExpense	ISNetIncome	DebtPerMG	OpExpPerMG	NonOperatingRevenue	NonOperatingIncome	ISOperatingRevenuesComb	ISBeforeDepreciationComb	OpExpRevComb	ISInterestExpenseComb	ISNetIncomeComb	AverageCapitalNeeds	IncomeStatement_W_C_WW	WaterIS_Period	WastewaterIS_Period	UtilityType_1	WaterOnly	TempAve	TempVar	PrecipAnnual	PrecipSeasonal	MaxCumDef	NDI	X_y	mean	depth
1	1	Ada	20022	4	City of Boise	X	U	West	Boise	Idaho	ID	83701-0500	USA	16001	Boise	325.8	55493	0.0	0.0	0.0	NA	NA	NA	NA	0	0	0	0.0	0	0	0	#DIV/0!	4.56	25.9	30.46	4.56	38.85	43.41	NA	NA	30.46	4.56	38.85	43.41	0.0	0.0	0.0	0.00%	0.00%	0.0	0.0	0.0	0	0	0.0	0	0.0	#DIV/0!	0	0	#DIV/0!	0	0	0.0	9171.0	#DIV/0!	0	0	#DIV/0!	304,337,000.00	20,371,000.00	0.07	0.0	0	0	#DIV/0!	0	0	#DIV/0!	#DIV/0!	0	0	25,174,000.00	21,381,000.00	0.85	474,000.00	1.952e6	#DIV/0!	NA	N / R	FY09	4	0	10.27	12.89	320.79	4.13	0.325605895	18.12909083	3	1465.266951	1164.528134
2	2	Adams	1609	2	Aurora Water	B	U	West	Aurora	Colorado	CO	80012	USA	8001	Aurora	346.6	60822	0.0	100.0	0.0	1	2	IB	2	0	12.06	39.42	51.48	12.06	59.13	71.19	0.2	2.97	20.42	23.39	2.97	30.63	33.6	15.03	59.84	74.87	15.03	89.76	104.79	160.0	40.41	80.0	25.26%	50.00%	14749.65	0.0	14749.65	314000	0	314000.0	1	314000.0	128.6942675	72811	3999	0.05492302	0	76810	268.0	0.0	55.03600746	1,700,272,392.00	701,818,920.00	0.41	2,202,062,415.00	765,875,228.00	0.35	8.4493197e7	33,252,590.00	10390860	0.39	6,527,282.00	62,555,533.00	47,582.07	2,254.47	0	1	131,056,160.00	67,078,926.00	0.51	6,634,481.00	8.3449478e7	70,687,288.80	Water only	CY09	CY09	2	1	9.88	13.02	374	5.25	0.94650584	5.977142948	5	1866.219805	1494.320894
3	3	Alachua	1019	2	Gainesville Regional Utilities	B	U	South	Gainesville	Florida	FL	32614	USA	12001	Gainesville	245.0	36833	100.0	0.0	0.0	2	2	IB	2	0	7.3	12.34	19.64	7.3	22.18	29.48	0.33	6.0	37.92	43.92	6.0	56.89	62.89	13.3	50.26	63.56	13.3	79.07	92.37	54.0	24.957	31.801	46.22%	58.89%	7708.0	0.0	7708.0	124491	0	124491.0	0	124491.0	169.6332122	61851	7645	0.123603499	0	69496	71.0	5620.0	108.5633803	179,640,510.00	108,415,016.00	0.6	394,617,821.00	230,178,472.00	0.58	2.5712256e7	12,590,285.00	6543205	0.49	0	5,179,080.00	14,065.26	1,633.40	1	1	57,688,361.00	25,264,781.00	0.44	561,085.00	1.0288549e7	5,900,862.80	Water only	CY09	FY09	2	1	20.78	6.63	1,318.75	2.77	0.027817561	0.455845935	13	3027.0625	2198.633167
4	4	Alameda	1337	2	East Bay Municipal Utility District	A	U	West	Oakland	California	CA	94623	USA	6001	Oakland	2040.3	52384	0.0	100.0	0.0	1	2	DB	3	0	12.03	21.44	33.47	12.03	33.84	45.87	0.36	11.15	5.9	17.05	11.15	5.9	17.05	23.18	27.34	50.52	23.18	39.74	62.92	181.0	181.0	262.0	100.00%	144.75%	61962.4	0.0	61962.4	1300000	0	1.3e6	0	1.3e6	130.5846154	356173	25555	0.071748841	0	381728	1783.0	24090.0	34.75176669	3,709,906,000.00	2,210,846,000.00	0.6	4,374,434,000.00	2,571,183,000.00	0.59	2.91631e8	227,493,000.00	68518000	0.78	0	7,262,000.00	35,680.44	3,671.47	0	1	360,723,000.00	277,633,000.00	0.77	13,509,000.00	5.851e6	177,800,000.00	Water only	FY09	FY09	2	1	14.47	6.12	468.05	56.78	46.59137036	0.809378725	15	1523.785408	858.5948757
5	5	Alameda	1283	1	Alameda County Water District	B	U	West	Fremont	California	CA	94538	USA	6001	Fremont	2040.3	100150	34.0	41.0	25.0	3	NA	U	1	0	5.81	27.54	33.35	5.81	41.31	47.12	0.14	0.0	0.0	0.0	0.0	0.0	0.0	5.81	27.54	33.35	5.81	41.31	47.12	75.0	50.0	75.0	66.67%	100.00%	15621.62	0.0	15621.62	333648	0	333648.0	1	333648.0	128.2757844	73012	6775	0.092792966	0	79787	214.0	0.0	72.9982243	467,620,400.00	50,844,200.00	0.11	467,620,400.00	50,844,200.00	0.11	5.67777e7	46,199,600.00	10795800	0.81	2,846,600.00	6,792,500.00	3,254.73	2,957.41	1	1	56,777,700.00	46,199,600.00	0.81	2,846,600.00	6.7925e6	22,618,200.00	Water only	FY09	N / R	1	1	14.47	6.12	468.05	56.78	46.59137036	0.809378725	15	1523.785408	858.5948757
6	6	Albemarle	2168	2	Albemarle County Service Authority	C	U	South	Charlottesville	Virginia	VA	22911	USA	51003	Waynesboro	127.4	40551	0.0	0.0	100.0	4	NA	IB	2	0	6.15	44.62	50.77	6.15	89.24	95.39	0.07	0.0	53.93	53.93	0.0	80.9	80.9	6.15	98.55	104.7	6.15	170.14	176.29	0.0	0.0	0.0	0.00%	0.00%	1545.7	0.0	1545.7	62518	0	62518.0	1	62518.0	67.73720401	15662	1312	0.083769634	0	16974	38.0	0.0	40.67631579	61,594,162.00	0	0	108,336,426.00	364,100.00	0	1.0257885e7	8,786,314.00	1296812	0.86	0	3,428,498.00	0	5,684.36	0	1	18,964,507.00	15,805,202.00	0.83	21,010.00	6.772006e6	3,997,090.00	Water only	FY09	FY09	2	1	13.33	11.08	1,123.40	1.35	0.003824258	10.37407846	18	1641.375	1084.430981
7	7	Allegheny	2087	1	Fox Chapel Authority	C	U	Northeast	Pittsburgh (FCA)	Pennsylvania	PA	15238	USA	42003	Pittsburgh	1692.3	37388	0.0	0.0	100.0	4	NA	DB	3	0	4.54	53.33	57.87	4.54	80	84.54	0.06	0.0	0.0	0.0	0.0	0.0	0.0	4.54	53.33	57.87	4.54	80	84.54	0.0	1.82	0.0	0.00%	0.00%	467.193	87.729	554.922	18000	1300	19300.0	1	19300.0	78.77379516	5178	243	0.046929316	2	5423	13.0	0.0	42.68630769	27,444,428.00	11,024,794.00	0.4	27,444,428.00	11,024,794.00	0.4	4.301948e6	2,594,875.00	545448	0.6	537,679.00	630,543.00	19,867.29	4,676.11	1	0	4,301,948.00	2,594,875.00	0.6	537,679.00	630543.0	750,000.00	Water only	FY09	N / R	1	1	10.63	11.8	987.81	1.52	19.92541983	241.9507224	28	1287.677419	459.8801384
8	8	Allen	1408	2	Lima Department of Utilities	C	U	Midwest	Lima	Ohio	OH	45801	USA	39003	Lima	266.6	35398	0.0	100.0	0.0	1	2	DB	3	0	7.86	13.82	21.68	7.86	20.73	28.59	0.38	17.87	17.71	35.58	17.87	30.36	48.23	25.73	31.53	57.26	25.73	51.09	76.82	30.0	13.5	18.0	45.00%	60.00%	4015.0	2357.9	6372.9	72000	3000	75000.0	1	75000.0	232.8	22130	1929	0.087166742	1	24060	48.79999924	4441.29	130.5922152	34,744,643.00	3,341,854.00	0.1	77,969,109.00	13,684,719.00	0.18	9.365747e6	8,116,866.00	1133394	0.87	287,673.00	184,502.00	524.39	1,273.65	1	0	17,862,416.00	13,597,543.00	0.76	1,048,863.00	989326.0	10,230,266.00	Water only	FY08	FY08	2	1	10.39	12.64	927.77	1.63	0.535210085	79.85310308	29	1285.464217	656.343153
9	9	Anderson	30021	2	Oak Ridge, City of	C	U	South	Oak Ridge	Tennessee	TN	37831-0001	USA	47001	Oak Ridge	211.4	54862	0.0	100.0	0.0	1	2	DB	3	0	11.5	24.93	36.43	11.5	41.34	52.84	0.28	13.5	28.22	41.72	13.5	48.44	61.94	25	53.15	78.15	25	89.78	114.78	28.0	10.0	13.0	35.71%	46.43%	1074.0	2174.0	3248.0	27500	0	27500.0	1	0.0	323.5865504	11293	1625	0.143894448	1	12919	0.0	1973.7	#DIV/0!	0	0	#DIV/0!	0	0	#DIV/0!	0.0	0	0	#DIV/0!	0	0	0	0	0	0	0	0	#DIV/0!	0	0.0	1,770,000.00	NA	N / R	N / R	2	0	13.45	10.63	1,399.02	1.49	0.005511492	13.55470289	36	798.1153846	494.0790067
10	10	Anne Arundel	30006	2	City of Annapolis	C	U	South	Annapolis	Maryland	MD	21401	USA	24003	Annapolis	1246.8	64400	100.0	0.0	0.0	2	2	DB	3	0	4.2	11.34	15.54	4.2	18.63	22.83	0.23	6.07	17.41	23.48	6.07	26.94	33.01	10.27	28.75	39.02	10.27	45.57	55.84	10.0	3.91	6.3	39.10%	63.00%	1186.0	0.0	1186.0	38900	0	38900.0	0	38900.0	83.52995035	10474	1939	0.185125072	0	12413	22.0	1790.0	53.90909091	18,884,860.00	3,254,453.00	0.17	44,424,758.00	7,477,401.00	0.17	3.250584e6	4,736,853.00	554074	1.46	212,320.00	-1,816,385.00	2,744.06	3,993.97	1	0	8,198,446.00	9,122,853.00	1.11	377,027.00	-293936.0	10,872,600.00	Water only	CY09	CY09	2	1	9.9	8.85	967.6	1.31	0.711322932	4.596156945	39	1712.142857	1078.942619
11	11	Atchison	4231	1	City of Atchison	C	U	Midwest	Atchison	Kansas	KS	66002	USA	20005	Atchison	37.8	40684	0.0	100.0	0.0	1	2	DB	3	0	23.38	21.99	45.37	23.38	36.49	59.87	0.64	0.0	0.0	0.0	0.0	0.0	0.0	23.38	21.99	45.37	23.38	36.49	59.87	8.6	3.754	5.678	43.65%	66.02%	840.396	188.594	1028.99	10402	2650	13052.0	1	13052.0	215.9937699	3706	496	0.133837021	5	4207	5.5	0.0	187.0890909	11,358,405.00	6,390,072.00	0.56	11,358,405.00	6,390,072.00	0.56	2.733628e6	1,394,251.00	479110	0.51	352,394.00	1,383,936.00	6,210.04	1,354.97	0	1	2,733,628.00	1,394,251.00	0.51	352,394.00	1.383936e6	210,411.00	Water only	CY09	N / R	1	1	12.19	13.42	923.55	4.35	0.240948368	1.242559969	65	1099.280899	685.1325214
12	12	Baltimore	1168	2	City of Baltimore Department of Public Works	A	U	South	Baltimore	Maryland	MD	21202	USA	24005	Baltimore	1300.3	39336	0.0	100.0	0.0	1	2	DB	3	0	8.23	16.46	24.69	8.23	28.81	37.04	0.29	11.06	22.13	33.19	11.06	38.72	49.78	19.29	38.59	57.88	19.29	67.53	86.82	360.0	226.0	0.0	62.78%	0.00%	25769.0	37195.0	62964.0	1800000	0	1.8e6	0	1.8e6	95.83561644	193881	0	0	4	193885	893.0	65000.0	70.50839866	1,007,440,000.00	454,940,000.00	0.45	2,761,248,000.00	1,102,175,000.00	0.4	1.1984e8	94,547,000.00	11888000	0.79	10,434,000.00	3,364,000.00	7,225.40	1,501.60	0	0	119,840,000.00	215,670,000.00	1.8	20,462,000.00	8.956e6	74,093,820.80	Water only	FY09	N / R	2	1	11.47	10.9	1,106.57	1.31	1.936986763	194.8737825	85	1343.935696	712.3397972
13	13	Bartow	2553	1	Cartersville Water Department	C	U	South	Cartersville	Georgia	GA	30120	USA	13015	Cartersville	196.2	53832	0.0	100.0	0.0	1	2	IB	2	0	6	12	18.0	6	26.94	32.94	0.22	0.0	0.0	0.0	0.0	0.0	0.0	6	12	18.0	6	26.94	32.94	27.0	11.02	14.06	40.81%	52.07%	2363.0	1701.0	4064.0	19382	76818	96200.0	0	96200.0	115.7406089	9036	1401	0.155046481	1	10438	21.0	0.0	193.5238095	0	0	#DIV/0!	0	0	#DIV/0!	1.142e7	10,129,400.00	0	0.89	0	329,600.00	0	2,492.47	1	0	11,420,000.00	10,129,400.00	0.89	0	329600.0	12,039,250.00	Combined water and wastewater	FY09	N / R	1	1	15.59	10.03	1,305.98	1.41	0.006829747	4.345174021	101	2453.0	337.4033195
14	14	Bay	2390	1	City of Panama City	C	U	South	Panama City	Florida	FL	32405	USA	12005	Panama City	208.3	41290	0.0	0.0	100.0	4	NA	U	1	0	6.4	18.55	24.95	6.4	27.83	34.23	0.23	0.0	0.0	0.0	0.0	0.0	0.0	6.4	18.55	24.95	6.4	27.83	34.23	0.0	0.0	0.0	0.00%	0.00%	1988.175	0.0	1988.175	38000	0	38000.0	0	38000.0	143.3435472	13778	3227	0.234213964	0	17005	89.5	0.0	22.21424581	0	0	#DIV/0!	0	0	#DIV/0!	1.4736091e7	9,689,123.00	2010357	0.66	829,960.00	1,344,651.00	0	4,873.38	1	0	14,736,091.00	9,689,123.00	0.66	829,960.00	1.344651e6	1,157,000.00	Combined water and wastewater	FY09	N / R	1	1	14.74	5.77	1,391.78	1.93	0.015210278	1.206090066	105	3947.719008	3598.653966
15	15	Bennington	3905	1	City of Bennington	C	U	Northeast	Bennington	Vermont	VT	5201	USA	50003	Bennington	54.6	44081	5.0	95.0	0.0	1	1	U	1	0	44.87	20.64	65.51	44.87	30.97	75.84	1.45	0.0	0.0	0.0	0.0	0.0	0.0	44.87	20.64	65.51	44.87	30.97	75.84	4.0	1.5	2.8	37.50%	70.00%	538.0	7.2	545.2	13000	1	13001.0	1	13001.0	114.8910569	2800	1000	0.357142857	1	3801	6.0	0.0	90.86666667	8,949,679.00	6,455,608.00	0.72	8,949,679.00	6,455,608.00	0.72	1.385168e6	1,457,974.00	411349	1.05	0	-484,155.00	11,840.81	2,674.20	0	0	1,385,168.00	1,457,974.00	1.05	0	-484155.0	1,000,000.00	Water only	FY09	N / R	1	1	5.74	12.9	1,329.05	1.16	0.001165819	8.08999994	125	945.6666667	338.098112
16	16	Benton	1547	3	Benton Washington Reg. Public Water Auth.	C	U	South	Rogers	Arkansas	AR	72756-9088	USA	5007	Rogers	206.6	52932	0.0	100.0	0.0	1	2	NA	NA	0	0	0	0.0	0	0	0	#DIV/0!	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0.0	0	0	0.0	16.0	7.01	16.0	43.81%	100.00%	0.0	2260.738	2260.738	0	100540	100540.0	1	0.0	61.60535846	0	0	#DIV/0!	17	17	16.0	0.0	141.296125	68,576,213.00	49,689,705.00	0.72	68,576,213.00	49,689,705.00	0.72	4.625323e6	1,794,047.00	1217860	0.39	1,195,252.00	642,431.00	21,979.42	793.57	0	0	4,625,323.00	1,794,047.00	0.39	1,195,252.00	642431.0	1,350,000.00	Water only	N / R	N / R	3	0	14.48	11.41	1,139.00	1.93	0.013021176	0.44850403	128	2073.108052	1683.007876
17	17	Benton	3660	2	City of Corvallis	C	U	West	Corvallis	Oregon	OR	97330	USA	41003	Corvallis	121.3	46082	0.0	100.0	0.0	1	2	IDB	4	0	12.15	12.43	24.58	12.15	23.98	36.13	0.51	9.88	29.4	39.28	9.88	44.1	53.98	22.03	41.83	63.86	22.03	68.08	90.11	24.0	7.1	16.2	29.58%	67.50%	2529.4	0.0	2529.4	55125	0	55125.0	1	55125.0	125.7118007	13415	1165	0.086843086	0	14580	32.90999985	3399.73	76.8580982	51,315,434.00	4,625,080.00	0.09	131,933,109.00	23,091,674.00	0.18	8.786133e6	8,051,351.00	1635852	0.92	292,358.00	-487,556.00	1,828.53	3,183.11	0	1	18,083,566.00	16,253,144.00	0.9	1,241,476.00	-1.710462e6	1,263,422.00	Water only	FY09	FY09	2	1	10.43	7.47	1,699.13	13.14	0.01281876	1.154751326	128	2073.108052	1683.007876
18	18	Benton	3594	2	Kennewick, City of	C	U	West	Kennewick	Washington	WA	99336	USA	53005	Kennewick	90.0	53899	41.28	58.72	0.0	3	NA	U	1	0	9.32	10.57	19.89	9.32	15.86	25.18	0.59	19.24	0.0	19.24	19.24	0.0	19.24	28.56	10.57	39.13	28.56	15.86	44.42	30.0	10.8	24.06	36.00%	80.20%	3673.76	0.0	3673.76	69454	0	69454.0	0	69454.0	144.9174402	19043	2120	0.111326997	0	21163	17.5	1993.78	209.9291429	138,888,272.00	33,997,148.00	0.24	138,888,272.00	33,997,148.00	0.24	8.245542e6	5,288,636.00	2381258	0.64	0	753,095.00	9,254.05	1,439.57	1	1	14,932,355.00	9,196,804.00	0.62	0	2.178827e6	3,943,800.00	Water only	N / R	FY09	2	1	11.09	11.7	215.24	4.6	0.380828623	888.2173831	128	2073.108052	1683.007876
19	19	Berkeley	2220	2	Berkeley Water & Sanitation	C	U	South	Berkeley County	South Carolina	SC	29461	USA	45015	Berkeley	122.1	52192	0.0	0.0	100.0	4	NA	U	1	0	8.5	22.96	31.46	8.5	43.44	51.94	0.2	44.0	0.0	44.0	44.0	0.0	44.0	52.5	22.96	75.46	52.5	43.44	95.94	0.0	0.0	0.0	0.00%	0.00%	1715.581259	0.0	1715.581259	50245	0	50245.0	1	50245.0	93.54607677	17513	758	0.043282133	2	18273	51.29999924	4357.0	33.4421303	115,155,876.95	56,292,833.79	0.49	393,236,182.93	201,870,434.91	0.51	8.3142264e6	5,280,130.67	2582261	0.64	90,975.00	1,261,355.56	32,812.69	3,077.75	0	0	33,591,364.86	16,006,680.00	0.48	7,917,295.00	6.44667398e6	3,671,973.20	Water only	FY09	FY09	2	1	16.95	8.56	1,161.20	2.1	0.01130524	18.70009425	130	1517.381481	787.8887881
20	20	Bernalillo	1326	2	Albuquerque Bernalillo County Water Utility Authority	B	U	West	Albuquerque	New Mexico	NM	87120	USA	35001	Albuquerque	517.8	50052	75.0	25.0	0.0	3	1	U	1	1	11.41	14.1	25.51	11.41	21.15	32.56	0.54	7.49	7.81	15.3	7.49	11.71	19.2	18.9	21.91	40.81	18.9	32.86	51.76	294.0	87.51	150.0	29.77%	51.02%	2716.4	0.0	2716.4	595000	0	595000.0	0	0.0	12.50788535	171983	19830	0.115302094	0	191813	210.0	21170.0	12.9352381	1,434,211,198.00	617,193,912.00	0.43	1,434,211,198.00	617,193,912.00	0.43	1.52232345e8	140,185,811.00	393410	0.92	0	19,679,654.00	227,210.25	51,607.20	1	0	152,232,345.00	280,371,622.00	1.84	0	3.9359308e7	#DIV/0!	Combined water and wastewater	FY08	FY08	2	0	11.33	11.65	278.73	3.18	7.406956469	13.24936598	133	1426.905263	1452.422101
21	21	Bexar	1526	2	San Antonio Water System	A	U	South	San Antonio	Texas	TX	78298	USA	48029	San Antonio	1216.6	47361	94.83	0.0	5.17	2	1	IB	2	1	6.96	19.6	26.56	6.96	30.9	37.86	0.23	7.81	12.31	20.12	7.81	20.0	27.81	14.77	31.91	46.68	14.77	50.9	65.67	826.0	181.4	243.0	21.96%	29.42%	55176.0	119.0	55295.0	1340549	0	1.340549e6	0	1.340549e6	113.0082904	327610	23242	0.07094411	7	350859	645.0	51987.0	85.72868217	2,131,876,349.00	1,064,883,922.00	0.5	3,777,231,489.00	1,846,000,356.00	0.49	2.21512601e8	133,747,390.00	47019268	0.6	39,001,302.00	-2,350,804.00	19,258.23	2,418.80	1	1	356,339,136.00	209,894,831.00	0.59	66,285,409.00	-6.463547e6	151,720,000.00	Water only	CY09	CY09	2	1	20.28	8.53	769.17	2.09	17.83594691	11.51035236	136	6421.4	531.8959485
22	22	Black Hawk	1075	1	Waterloo Water Works	C	U	Midwest	Waterloo	Iowa	IA	50704	USA	19013	Waterloo	224.5	44586	100.0	0.0	0.0	2	2	DB	3	0	5.25	7.91	13.16	5.25	13.56	18.81	0.39	0.0	0.0	0.0	0.0	0.0	0.0	5.25	7.91	13.16	5.25	13.56	18.81	50.0	12.8	17.58	25.60%	35.16%	3720.18	104.03	3824.21	70384	3169	73553.0	1	73553.0	142.4454158	24086	1732	0.071908993	2	25820	36.0	0.0	106.2280556	25,505,042.00	2,105,824.00	0.08	25,505,042.00	2,105,824.00	0.08	5.719686e6	4,587,738.00	493497	0.8	108,696.00	1,190,531.00	550.66	1,199.66	1	1	5,719,686.00	4,587,738.00	0.8	108,696.00	1.190531e6	2,564,106.60	Water only	CY09	N / R	1	1	8.24	14.4	863.79	4.3	1.298787081	12.72201405	143	1816.675824	1119.17127
23	23	Blount	2299	2	Maryville Utilities, City of	C	U	South	Maryville	Tennessee	TN	37801	USA	47009	Maryville	199.2	52499	0.0	99.94	0.06	1	2	DB	3	0	5.67	16.11	21.78	5.67	25.45	31.12	0.22	5.07	28.2	33.27	5.07	42.3	47.37	10.74	44.31	55.05	10.74	67.75	78.49	6.0	3.974	5.653	66.23%	94.22%	1084.5975	0.0	1084.5975	30374	0	30374.0	1	0.0	97.83038125	12903	1557	0.120669612	0	14460	31.0	0.0	34.98701613	103,294,420.00	51,240,000.00	0.5	103,294,420.00	51,240,000.00	0.5	1.1372336e7	7,736,229.00	1627625	0.68	2,378,155.00	105,235.00	47,243.33	7,132.81	0	0	11,372,336.00	15,472,458.00	1.36	4,756,310.00	210470.0	1,651,657.40	Combined water and wastewater	FY09	FY09	2	0	13.65	10.32	1,379.05	1.47	0.007535285	126.845868	150	1436.238095	817.4877471
24	24	Boulder	1610	2	Boulder, City of	C	U	West	Boulder	Colorado	CO	80302	USA	8013	Boulder	396.1	58522	0.0	0.0	100.0	4	NA	IB	2	0	8.55	18.44	26.99	8.55	39.62	48.17	0.22	0.96	28.42	29.38	0.96	42.64	43.6	9.51	46.86	56.37	9.51	82.26	91.77	53.0	15.41	30.5	29.08%	57.55%	4987.0	0.0	4987.0	115881	0	115881.0	1	115881.0	117.9055557	25042	3416	0.13641083	0	28458	75.12999725	4915.0	66.37828008	236,489,000.00	45,360,000.00	0.19	342,655,000.00	86,597,000.00	0.25	2.0173e7	11,197,000.00	4989000	0.56	2,114,000.00	862,000.00	9,095.65	2,245.24	0	1	32,894,000.00	18,943,000.00	0.58	3,782,000.00	1.302e6	4,820,091.60	Water only	CY09	CY09	2	1	5.09	11.9	556.73	2.11	0.064140355	1.675958612	164	999.4566745	852.4835878
25	25	Boulder	1616	2	Longmont, City of	C	U	West	Longmont	Colorado	CO	80501	USA	8013	Longmont	396.1	66926	0.0	100.0	0.0	1	2	IB	2	0	3.66	4.03	7.69	3.66	6.94	10.6	0.53	7.29	17.22	24.51	7.29	27.06	34.35	10.95	21.25	32.2	10.95	34	44.95	47.0	13.66	29.49	29.06%	62.74%	4245.8	0.0	4245.8	86303	0	86303.0	1	86303.0	134.7847557	23553	2988	0.12686282	0	26541	52.34999847	967.25	81.10410934	332,354,156.00	15,398,953.00	0.05	427,672,924.00	16,017,826.00	0.04	1.202335e7	9,398,073.00	3847442	0.78	0	-2,818,585.00	3,626.87	2,213.50	1	0	19,439,389.00	15,467,067.00	0.8	268,225.00	-4.121233e6	6,945,578.80	Water only	CY09	CY09	2	1	5.09	11.9	556.73	2.11	0.064140355	1.675958612	164	999.4566745	852.4835878
26	26	Boulder	4359	2	Lafayette Water Department	C	U	West	Lafayette	Colorado	CO	80026	USA	8013	Lafayette	396.1	73729	0.0	100.0	0.0	1	2	IB	2	0	9.15	14.43	23.58	9.15	24.95	34.1	0.37	8.31	6.41	14.72	8.31	11.41	19.72	17.46	20.84	38.3	17.46	36.36	53.82	13.0	3.7	8.2	28.46%	63.08%	1159.86	29.363	1189.223	32000	800	32800.0	1	32800.0	99.33369529	7671	532	0.069352105	2	8205	21.10000038	741.0	56.3612786	98,136,454.00	17,402,741.00	0.18	126,487,753.00	23,273,971.00	0.18	4.828996e6	2,813,144.00	1646109	0.58	890,948.00	1,073,177.00	14,633.71	2,365.53	0	1	6,482,405.00	4,429,035.00	0.68	1,112,575.00	251207.0	3,344,600.00	Water only	FY09	FY09	2	1	5.09	11.9	556.73	2.11	0.064140355	1.675958612	164	999.4566745	852.4835878
27	27	Branch	7355	2	Coldwater Board of Public Utilities	C	U	Midwest	Coldwater	Michigan	MI	7355	USA	26023	Coldwater	91.7	44352	100.0	0.0	0.0	2	2	DB	3	0	12.35	15.26	27.61	12.35	23.98	36.33	0.52	14.59	11.34	25.93	14.59	17.82	32.41	26.94	26.6	53.54	26.94	41.8	68.74	6.6	1.919	3.59	29.08%	54.39%	492.58	0.0	492.58	12700	0	12700.0	0	12700.0	106.2625391	3875	719	0.185548387	0	4594	7.0	917.1	70.36857143	12,355,678.00	5,810,000.00	0.47	27,896,206.00	11,925,000.00	0.43	2.116761e6	1,200,967.00	399671	0.57	248,700.00	341,098.00	11,795.04	2,438.12	0	0	4,571,795.00	2,635,390.00	0.58	526,010.00	533557.0	371,000.00	Water only	FY09	FY09	2	1	9.03	12.86	910.12	1.77	0.280595301	1.783249152	175	928.5	458.912301
28	28	Brevard	1640	2	City of Cocoa	B	U	South	Cocoa	Florida	FL	32922	USA	12009	Cocoa	501.9	35392	80.0	20.0	0.0	2	NA	IB	2	0	10.47	14.7	25.17	10.47	26.01	36.48	0.4	9.77	32.41	42.18	9.77	50.93	60.7	20.24	47.11	67.35	20.24	76.94	97.18	48.0	25.35	34.45	52.81%	71.77%	8360.514	0.0	8360.514	245000	0	245000.0	1	0.0	93.49190942	76410	0	0	0	76410	143.5	643.66	58.2614216	208,056,605.00	78,185,401.00	0.38	208,056,605.00	78,185,401.00	0.38	4.1132721e7	32,022,078.00	7550957	0.78	3,220,301.00	5,897,698.00	9,351.75	3,830.16	1	1	41,132,721.00	64,044,156.00	1.56	6,440,602.00	1.1795396e7	13,912,815.40	Combined water and wastewater	FY09	FY09	2	0	15.34	3.66	1,211.34	3.18	0.08029567	5.438614991	182	1403.222222	2505.831238
29	29	Brevard	1027	2	Melbourne Water Department, City of	C	U	South	Melbourne	Florida	FL	32901	USA	12009	Melbourne	501.9	45212	30.0	70.0	0.0	1	NA	NA	4	0	6.25	28.5	34.75	6.25	43.12	49.37	0.14	8.18	43.8	51.98	8.18	66.3	74.48	14.43	72.3	86.73	14.43	109.42	123.85	26.5	14.9	18.9	56.23%	71.32%	0.0	0.0	0.0	150000	15328	165328.0	1	0.0	0	51719	4933	0.095380808	45	56697	80.0	2151.759	0	213,153,688.00	118,629,993.00	0.56	213,153,688.00	118,629,993.00	0.56	4.057917e7	33,164,016.00	9379103	0.82	4,936,601.00	-5,316,559.00	#DIV/0!	#DIV/0!	0	1	40,579,170.00	66,329,032.00	1.63	9,873,202.00	-1.0634118e7	531,760.00	Combined water and wastewater	FY09	FY09	2	0	15.34	3.66	1,211.34	3.18	0.08029567	5.438614991	182	1403.222222	2505.831238
30	30	Broward	1037	2	Broward County Water and Wastewater Services	B	U	South	Broward County	Florida	FL	33069	USA	12011	Pompano Beach	1449.5	54524	76.07	0.0	23.93	2	NA	IB	2	0	12.14	20.55	32.69	12.14	38.66	50.8	0.31	15.43	22.29	37.72	15.43	33.44	48.87	27.57	42.84	70.41	27.57	72.1	99.67	46.0	20.29	22.75	44.11%	49.46%	7182.15	1819.32	9001.47	230000	61000	291000.0	1	0.0	84.74763451	52025	6177	0.118731379	3	58205	349.0	23793.0	25.79217765	809,182,431.00	425,139,830.00	0.53	809,182,431.00	425,139,830.00	0.53	1.08085468e8	64,788,684.00	33120285	0.6	15,814,160.00	1,427,215.00	47,230.04	7,197.57	0	1	108,085,468.00	129,577,368.00	1.2	31,628,320.00	2.85443e6	40,299,934.00	Combined water and wastewater	FY09	FY09	2	0	21.59	3.81	1,473.08	3.8	0.603386414	4.01E-06	192	2835.698413	3404.365641
&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip	&vellip

	radius	surface	groundwater
1	Nation	4.7700663946448874e8	5.727795615511276e6
2	State	1.4261982262421383e10	1.0178368529331375e7
3	Neighbors	4.570581528183927e8	2.5676282261607297e7
4	County	3.726519630078e8	1.0797075467999999e8

	transition	surface	groundwater
1	County2Neighbors	-0.9519037243018486	-0.3177891935097157
2		0.0	0.0
3	100km2State	46.84688525625985	-0.9670333073424108
4	State2Nation	-0.7027009411896701	-0.06344522575111837

	fips	state2county	nation2state
1	1001	13452.398234187258	0.0
2	1003	62275.908108707816	-15874.060042775025
3	1005	5744.905031219915	865.8835775124799
4	1007	3695.116453307127	-828.1292149080609
5	1009	5587.32	0.0
6	1011	-222.86040044584934	1834.0554004458495
7	1013	2033.0100000000002	1043.5431993970915
8	1015	22579.001702385372	-16000.179690772746
9	1017	-2420.2500000000005	2610.363079411765
10	1019	4384.11	0.0
11	1021	6841.105761371275	0.0
12	1023	-2272.0314942316727	-14374.068123244986
13	1025	4231.9800000000005	0.0
14	1027	-2315.115882886881	-312.58411711311874
15	1029	20.74499999999989	1013.8423573622051
16	1031	11972.229461852588	-3271.3801837660085
17	1033	-12768.130217710916	15630.940217710915
18	1035	1503.7244616279077	-120.72446162790698
19	1037	1161.72	0.0
20	1039	9708.66	-4423.704084971649
21	1041	3214.929698127182	-1155.7338259257454
22	1043	-43655.00935695464	30293.5734627196
23	1045	6320.472494844308	4764.821043495628
24	1047	17204.52	0.0
25	1049	-10365.5602	12762.736880487475
26	1051	6832.02	0.0
27	1053	12008.802560451633	2678.657439548366
28	1055	7509.69	-3951.9934619146516
29	1057	-5265.585635847209	2962.8906358472086
30	1059	-1656.9945819386521	4727.254581938652
&vellip	&vellip	&vellip	&vellip