Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Large Farm Irrigation Coefficients #3

Open
6 tasks done
julieshortridge opened this issue May 13, 2022 · 19 comments
Open
6 tasks done

Large Farm Irrigation Coefficients #3

julieshortridge opened this issue May 13, 2022 · 19 comments

Comments

@julieshortridge
Copy link

julieshortridge commented May 13, 2022

Task: Develop county-level coefficients of large farm unreported irrigation withdrawals.
@laljeet @jdkleiner @rburghol

  • Action items:
    • Calculate volume of large farm unreported ( Wunr_lg) in all counties using rainfall deficit approach. Large farm unreported is the total irrigation volume, minus DEQ reported, minus small farm volume from before.
      Wunr_lg = Wtotal - Wunr_sm - Wrep_irr
      Wtotal = Total irrigated acres x Rainfall_Deficit
    • Create table with coefficients of large farm unreported as percentage of reported irrigation withdrawals in counties with usda and vdeq irrigation data for each county c and usda year y:
      C_irr_lgc,y = Wunr_lg / Wrep_irr
    • Create table with coefficients of large farm unreported as percentage of reported withdrawals (all use types) in all counties with usda data for each county c and usda year y:
      C_tot_lgc,y = Wunr_lg / Wrep_tot
    • Map of C_irr_lg
    • Map of C_tot_lg
    • Trend analysis: As with small farm irrigation, identify any counties with monotonic trend in all four years
@laljeet
Copy link
Collaborator

laljeet commented May 19, 2022

Using DEQ Irrigation withdrawals and Rainfall Deficit Approach

Large Farmers Unreported 2002

<style> </style>
County Total.Irri.Area Facility_withdrawal_mg SM_F_Unreported All_Irrigation Large_Farm_unreported C_irr_lg
ORANGE 1556 0.45 29.57 868.23 838.21 1862.689
MECKLENBURG 4158 5.59 129.93 2289.12 2153.6 385.2594
POWHATAN 230 0.58 19.9 143.03 122.55 211.2931
PRINCE WILLIAM 1173 3.4 6.08 713.23 703.75 206.9853
LUNENBURG 1484 10 31.37 763.26 721.89 72.189
CULPEPER 589 4.11 64.66 343.08 274.31 66.74209
LOUDOUN 3666 36.6 108.94 2158.79 2013.25 55.00683
HALIFAX 2617 26.816 44.36 1415.67 1344.494 50.13775
DINWIDDIE 1164 14.055 61.72 624.71 548.935 39.05621
FRANKLIN 1126 11.81 126.01 586.33 448.51 37.97714
PITTSYLVANIA 5606 86.068 117.96 3134.05 2930.022 34.04311
SOUTHAMPTON 2385 41 0 1183.5 1142.5 27.86585
MIDDLESEX 651 13.4 9.27 377.11 354.44 26.45075
NEW KENT 458 11.89 9.5 290.19 268.8 22.60723
FREDERICK 520 9 84.83 277.42 183.59 20.39889
SHENANDOAH 1110 30.277 20.09 619.37 569.003 18.79324
SUSSEX 1410 38.6 7.92 698.18 651.66 16.88238
SURRY 1472 53.203 16.68 818.22 748.337 14.06569
AMELIA 886 42.093 67.09 545.32 436.137 10.36127
KING WILLIAM 2457 143.51 9.38 1535.81 1382.92 9.636402
MONTGOMERY 303 17 24.97 184.56 142.59 8.387647
ROCKINGHAM 4355 276.896 102.09 2555.25 2176.264 7.8595
GREENSVILLE 734 50.8297 0 385.33 334.5003 6.580804
PRINCE EDWARD 526 38.6 27.87 318.71 252.24 6.534715
NORTHAMPTON 9338 742.087 26.14 5548.58 4780.353 6.441769
CHESTERFIELD 571 55 22.25 363 285.75 5.195455
HANOVER 2393 236.0457 174.95 1506 1095.004 4.63895
ISLE OF WIGHT 791 97.5 2.75 434.63 334.38 3.429538
AUGUSTA 3416 461.554 113.45 2106.15 1531.146 3.317371
PAGE 238 34.476 7.9 134.32 91.944 2.666899
SPOTSYLVANIA 346 60.56 24.41 211.12 126.15 2.083058
CLARKE 327 42.8 50.45 175.5 82.25 1.921729
SUFFOLK CITY 1167 208.64 57.92 620.1 353.54 1.694498
CHARLES CITY 1122 268.67 13.39 715.67 433.61 1.613913
WESTMORELAND 1474 311.381 69.11 835.03 454.539 1.459752
NELSON 795 192.13 86.62 474.92 196.17 1.021027
ACCOMACK 9716 3444.534 9.88 5649.03 2194.616 0.63713
KING AND QUEEN 743 256.91 39.39 457.31 161.01 0.626718
CAROLINE 2272 960.526 14.85 1350.01 374.634 0.39003
ESSEX 246 140.34 23.09 145.65 -17.78 -0.12669
ROANOKE 92 20.7 44.18 49.57 -15.31 -0.73961
FAIRFAX 101 14.599 62.06 62.06 -14.599 -1

Large Farmers Unreported 2007

<style> </style>
County Total.Irri.Area Facility_withdrawal_mg SM_F_Unreported All_Irrigation Large_Farm_unreported C_irr_lg
MECKLENBURG 3235 7.17 36.42 1963.55 1919.96 267.7768
PATRICK 432 1 11.39 223.57 211.18 211.18
PRINCE WILLIAM 685 2.632 52.69 405.56 350.238 133.0691
HALIFAX 1549 9.12 71.65 902.26 821.49 90.07566
LOUDOUN 3533 32.6308 88.31 2197.1 2076.159 63.62575
CHESAPEAKE CITY 239 1.440575 27.67 118.09 88.97943 61.7666
LUNENBURG 770 8.66 20.72 455.89 426.51 49.25058
PITTSYLVANIA 4187 65.3438 37.07 2425.47 2323.056 35.55129
CHARLES CITY 739 11.9 5.78 355.69 338.01 28.4042
BEDFORD 567 11.9226 23.36 323.02 287.7374 24.13378
SUSSEX 1645 41.22 0 891.61 850.39 20.63052
AMELIA 562 15.681 20.88 308.8 272.239 17.36107
CHARLOTTE 731 23.2 76.9 413.34 313.24 13.50172
SURRY 1028 39.699 11.36 530.92 479.861 12.08748
ROCKINGHAM 4808 167.963 110.1 2196.42 1918.357 11.42131
SHENANDOAH 755 29.928 64.29 388.32 294.102 9.826985
PAGE 296 12.17 23.52 148.14 112.45 9.239934
DINWIDDIE 1885 97.3087 13.18 993.6 883.1113 9.075358
FREDERICK 298 13.534 60.23 177.7 103.936 7.679622
SOUTHAMPTON 3507 259.1787 49.07 1912.05 1603.801 6.188014
CLARKE 514 44 36.42 311.98 231.56 5.262727
CAMPBELL 779 59.51 59.25 431.35 312.59 5.252731
HANOVER 3188 274.1886 60.4 1660.05 1325.461 4.834123
NORTHAMPTON 9286 907.2193 26.78 5181.48 4247.481 4.681868
ORANGE 627 70 20.89 335.84 244.95 3.499286
MONTGOMERY 384 46.54 22.62 228.58 159.42 3.42544
POWHATAN 28 3.3 1.11 15.5 11.09 3.360606
AUGUSTA 3813 592.1592 103.41 2022.04 1326.471 2.240058
ISLE OF WIGHT 702 123 23.75 379 232.25 1.888211
MIDDLESEX 480 90.576 0 253.01 162.434 1.793345
KING GEORGE 672 175.802 12.86 411.46 222.798 1.267323
CAROLINE 2112 541.364 45.43 1214.45 627.656 1.159397
KING WILLIAM 2690 702.694 0 1472.34 769.646 1.095279
CHESTERFIELD 185 37.9 24.83 99.88 37.15 0.980211
ACCOMACK 6508 1779.744 26.51 3520.5 1714.246 0.963198
NEW KENT 495 138.01 3.52 248.79 107.26 0.77719
CULPEPER 1266 410.727 39.17 740.12 290.223 0.706608
SUFFOLK CITY 616 180.6075 32.37 293.21 80.2325 0.444237
SPOTSYLVANIA 144 25.43 43.91 80.04 10.7 0.420763
WESTMORELAND 1673 863.926 3.12 1043.97 176.924 0.204791
NELSON 774 468.463 50.61 403.86 -115.213 -0.24594
FAIRFAX 40 17.4 23.85 23.85 -17.4 -1
KING AND QUEEN 16 293.42 8.71 8.71 -293.42 -1

Large Farmers Unreported 2012

<style> </style>
County Total.Irri.Area Facility_withdrawal_mg SM_F_Unreported All_Irrigation Large_Farm_unreported C_irr_lg
PRINCE EDWARD 96 0.05148 6.21 54.18 47.91852 930.8182
HALIFAX 2152 2.139 118.02 1138.92 1018.761 476.2791
LOUDOUN 580 0.4321 134.63 332.28 197.2179 456.4173
PITTSYLVANIA 3717 27.14079 98.95 1998.84 1872.749 69.00129
ISLE OF WIGHT 702 5.75 5.03 271.35 260.57 45.31652
DINWIDDIE 1162 17.00596 28.84 632.3 586.454 34.48521
LUNENBURG 444 6.76 15.57 209.45 187.12 27.68047
CHARLOTTE 759 15.3 44.35 396.03 336.38 21.98562
SURRY 1238 22.35 28.45 541.82 491.02 21.96957
ORANGE 563 11 24.38 269.18 233.8 21.25455
PRINCE WILLIAM 1006 47.42 39.82 580.62 493.38 10.40447
POWHATAN 99 4 10.63 52.61 37.98 9.495
PAGE 1005 51.94 9.61 508.34 446.79 8.602041
SHENANDOAH 719 31.96 52.72 341.47 256.79 8.034731
SUSSEX 1371 71.71 11.98 656.97 573.28 7.994422
SOUTHAMPTON 3246 159.7402 10.55 1223.62 1053.33 6.594018
ROCKINGHAM 5645 578.196 160.63 2590.81 1851.984 3.203038
AUGUSTA 3271 424.6243 39.74 1494.28 1029.916 2.425475
NORTHAMPTON 6335 881.646 22.12 2981.69 2077.924 2.356869
CULPEPER 641 93.1449 32.92 329.68 203.6151 2.186004
HANOVER 3338 560.29 133.88 1809.25 1115.08 1.990184
GREENSVILLE 246 32.252 3.62 99.02 63.148 1.957956
MONTGOMERY 349 65.645 21.43 202.17 115.095 1.753294
CLARKE 249 46.58 15.47 137.61 75.56 1.622155
MIDDLESEX 477 88.8 9.12 241.78 143.86 1.620045
WESTMORELAND 1642 380.14 1.12 923.21 541.95 1.425659
AMELIA 374 85.5 27.17 225.81 113.14 1.323275
BEDFORD 93 11.55 30.99 53.38 10.84 0.938528
CAMPBELL 290 57.88 52.7 155.95 45.37 0.783863
KING WILLIAM 1125 352.326 8.94 628.93 267.664 0.759706
CHARLES CITY 1435 405.611 5.41 705.97 294.949 0.727172
SPOTSYLVANIA 58 10.2 16.86 33.72 6.66 0.652941
FLOYD 192 21.1 77.19 111.43 13.14 0.622749
CAROLINE 1959 792.39 14.27 1118.13 311.47 0.393077
CHESTERFIELD 64 22.9 6.67 35.57 6 0.262009
SUFFOLK CITY 414 133.01 22.65 151.21 -4.45 -0.03346
NELSON 862 424.98 29.01 438.76 -15.23 -0.03584
KING GEORGE 350 216.35 19.7 202.75 -33.3 -0.15392
ACCOMACK 5371 3414.518 25.7 2556.56 -883.658 -0.25879
HENRICO 7 100.69 3.52 3.52 -100.69 -1
KING AND QUEEN 18 246.17 10.06 10.06 -246.17 -1

Large Farmers Unreported 2017

<style> </style>
County Total.Irri.Area Facility_withdrawal_mg SM_F_Unreported All_Irrigation Large_Farm_unreported C_irr_lg
SPOTSYLVANIA 96 0.146 12.62 44.88 32.114 219.9589
PRINCE WILLIAM 943 14.541 16.76 464.93 433.629 29.82113
DINWIDDIE 1578 31.129 12.62 737.68 693.931 22.29211
CHARLOTTE 534 15.35 49.45 280.91 216.11 14.07883
SHENANDOAH 893 36.38 52.92 477.36 388.06 10.66685
ROCKINGHAM 5526 254.245 146.24 2865.72 2465.235 9.696297
AMELIA 205 9.343 9.39 101.29 82.557 8.836241
SURRY 929 43.719 4.53 420.43 372.181 8.513026
AUGUSTA 2550 175.66 104.89 1344.12 1063.57 6.054708
CHESAPEAKE CITY 72 0.896212 20.94 26.45 4.613788 5.148099
POWHATAN 63 4.3 8.25 32.47 19.92 4.632558
NORTHAMPTON 5857 529.2497 4.05 2962.53 2429.23 4.589951
MIDDLESEX 270 22.39 12.27 127.37 92.71 4.140688
NEW KENT 271 24.19 8.78 132.17 99.2 4.100868
ISLE OF WIGHT 934 71.1 14.46 365.01 279.45 3.93038
SOUTHAMPTON 1624 138.2595 5.44 631.21 487.5105 3.526054
MONTGOMERY 323 42.2739 19.21 172.32 110.8361 2.621857
CLARKE 143 16.56 17.78 74.77 40.43 2.441425
CULPEPER 615 81.2651 90.16 332.03 160.6049 1.976308
HANOVER 3569 583.8264 87.68 1748.23 1076.724 1.844253
CAROLINE 3411 543.92 8.58 1540.07 987.57 1.815653
KING WILLIAM 1618 285.391 8.44 802.89 509.059 1.783725
PAGE 108 25.55 10.86 58.65 22.24 0.87045
SUFFOLK CITY 585 111.95 23.7 231.11 95.46 0.852702
CHARLES CITY 1376 344.0851 6.76 619.8 268.9549 0.781652
SUSSEX 699 195.364 6.29 293.27 91.616 0.46895
KING AND QUEEN 1221 418.6888 18.32 604.59 167.5812 0.400252
ACCOMACK 5079 1673.848 26.93 2358.08 657.3022 0.392689
CAMPBELL 313 121.59 22.92 179.32 34.81 0.28629
WESTMORELAND 882 321.7426 51.3 407.62 34.5774 0.107469
NELSON 1016 474.32 35.98 553.93 43.63 0.091984
FLOYD 182 31.672 67.81 101.17 1.688 0.053296
BEDFORD 51 16.15 26.01 26.01 -16.15 -1
ESSEX 3 340.34 1.46 1.46 -340.34 -1
GREENSVILLE 5 48.91836 2.29 2.29 -48.9184 -1
HENRICO 28 97.14 13.51 13.51 -97.14 -1
ROANOKE 71 0.75 35.91 35.91 -0.75 -1

@laljeet
Copy link
Collaborator

laljeet commented May 19, 2022

Using DEQ Total withdrawals and Rainfall Deficit Approach

Large Farmers Unreported 2002

<style> </style>
County Total.Irri.Area Facility_withdrawal_mg SM_F_Unreported All_Irrigation Large_Farm_unreported C_tot_lg
NORTHAMPTON 9338 997.0889 26.14 5548.58 4525.351 4.538563
PITTSYLVANIA 5606 1800.395 117.96 3134.05 1215.695 0.675238
MECKLENBURG 4158 1132.005 129.93 2289.12 1027.185 0.907403
SURRY 1472 136.3014 16.68 818.22 665.2386 4.880643
HALIFAX 2617 772.2776 44.36 1415.67 599.0324 0.77567
CHARLOTTE 1454 116.545 105.62 760.22 538.055 4.616715
LUNENBURG 1484 231.424 31.37 763.26 500.466 2.16255
DINWIDDIE 1164 102.639 61.72 624.71 460.351 4.485147
AMELIA 886 42.093 67.09 545.32 436.137 10.36127
CHARLES CITY 1122 291.196 13.39 715.67 411.084 1.411709
SUSSEX 1410 397.3285 7.92 698.18 292.9315 0.737253
FLOYD 779 59.2953 116.25 462.05 286.5047 4.831828
ORANGE 1556 569.231 29.57 868.23 269.429 0.473321
MIDDLESEX 651 117.3 9.27 377.11 250.54 2.135891
ACCOMACK 9716 5389.551 9.88 5649.03 249.5991 0.046312
GRAYSON 619 67.504 38.95 313.1 206.646 3.061241
APPOMATTOX 508 87.302 11.35 303.47 204.818 2.346086
CARROLL 785 168.574 30.67 401.24 201.996 1.198263
RAPPAHANNOCK 335 14.576 5.74 192.28 171.964 11.79775
KING AND QUEEN 743 261.51 39.39 457.31 156.41 0.598103
CUMBERLAND 222 2.622 16.91 139 119.468 45.56369
WESTMORELAND 1474 663.7307 69.11 835.03 102.1893 0.153962
MADISON 333 39.538 38.34 177.3 99.422 2.514594
POWHATAN 230 32.6476 19.9 143.03 90.4824 2.771487
MATHEWS 117 1.113 2.94 68.77 64.717 58.14645
LEE 1374 597.42 115.13 775.45 62.9 0.105286
FRANKLIN 1126 414.587 126.01 586.33 45.733 0.11031
NOTTOWAY 457 214.159 18.64 266.19 33.391 0.155917
BLAND 135 72.718 11.07 71.16 -12.628 -0.17366
LOUISA 365 199.934 26.94 192.78 -34.094 -0.17053
BRUNSWICK 1474 731.753 64.54 754.98 -41.313 -0.05646
NORTHUMBERLAND 38 73.9144 5.82 22.13 -57.6044 -0.77934
LOUDOUN 3666 2154.691 108.94 2158.79 -104.841 -0.04866
PRINCE EDWARD 526 408.714 27.87 318.71 -117.874 -0.2884
PATRICK 325 241.6111 75.91 184.11 -133.411 -0.55217
CLARKE 327 259.3761 50.45 175.5 -134.326 -0.51788
SCOTT 637 380.623 92.2 326.27 -146.553 -0.38503
ESSEX 246 295.8453 23.09 145.65 -173.285 -0.58573
BUCKINGHAM 469 459.12 9.86 289.16 -179.82 -0.39166
GREENE 36 201.2057 18.48 18.48 -201.206 -1
NELSON 795 593.2255 86.62 474.92 -204.926 -0.34544
FLUVANNA 57 264.9282 13.72 32.59 -246.058 -0.92877
GREENSVILLE 734 647.5772 0 385.33 -262.247 -0.40497
CULPEPER 589 598.094 64.66 343.08 -319.674 -0.53449
GLOUCESTER 98 445.9206 30.63 58.86 -417.691 -0.93669
FREDERICK 520 672.497 84.83 277.42 -479.907 -0.71362
FAUQUIER 862 917.868 119.38 509.44 -527.808 -0.57504
GOOCHLAND 101 695.2937 14.08 61.84 -647.534 -0.93131
HENRICO 49 677.1815 30.58 30.58 -677.182 -1
PAGE 238 876.3444 7.9 134.32 -749.924 -0.85574
KING GEORGE 3 761.1532 1.81 1.81 -761.153 -1
CRAIG 130 862.29 16.29 70.6 -807.98 -0.93702
ROCKBRIDGE 700 1333.349 33.97 432.33 -934.989 -0.70123
WYTHE 1061 1596.589 11.88 572.82 -1035.65 -0.64866
CAROLINE 2272 2657.677 14.85 1350.01 -1322.52 -0.49762
SHENANDOAH 1110 1967.59 20.09 619.37 -1368.31 -0.69542
CAMPBELL 1328 2215.335 73.37 749.49 -1539.21 -0.6948
PULASKI 320 1760.111 1.75 187.08 -1574.78 -0.89471
RUSSELL 251 1644.277 54.53 116 -1582.81 -0.96262
HENRY 416 1815.299 22.09 235.67 -1601.72 -0.88234
CHESAPEAKE CITY 314 1681.94 99.62 165.51 -1616.05 -0.96082
TAZEWELL 245 1763.684 14.42 121.84 -1656.26 -0.93909
SMYTH 452 2503.458 18.05 214.67 -2306.84 -0.92146
WISE 28 2350.495 4.82 13.51 -2341.81 -0.9963
AUGUSTA 3416 4341.005 113.45 2106.15 -2348.31 -0.54096
WASHINGTON 836 3081.793 64.21 346.3 -2799.7 -0.90847
BOTETOURT 253 2906.554 44.52 146.29 -2804.78 -0.96499
ALBEMARLE 1387 3908.21 65.43 756.21 -3217.43 -0.82325
STAFFORD 186 3516.87 13.19 111.51 -3418.55 -0.97204
SPOTSYLVANIA 346 3729.491 24.41 211.12 -3542.78 -0.94994
WARREN 151 3691.946 38.98 84.1 -3646.83 -0.98778
BATH 109 4118.789 0 63.95 -4054.84 -0.98447
BEDFORD 676 4864.39 88.21 375.04 -4577.56 -0.94103
HANOVER 2393 5914.352 174.95 1506 -4583.3 -0.77495
SOUTHAMPTON 2385 6068.353 0 1183.5 -4884.85 -0.80497
JAMES CITY 102 5502.305 7.56 64.3 -5445.56 -0.98969
AMHERST 144 5863 21.77 87.1 -5797.67 -0.98886
KING WILLIAM 2457 7514.243 9.38 1535.81 -5987.81 -0.79686
ROCKINGHAM 4355 8784.345 102.09 2555.25 -6331.19 -0.72074
ROANOKE 92 7430.96 44.18 49.57 -7425.57 -0.99927
MONTGOMERY 303 8396.089 24.97 184.56 -8236.5 -0.98099
VIRGINIA BEACH CITY 431 10522.48 19.9 245.08 -10297.3 -0.9786
NEW KENT 458 14967.41 9.5 290.19 -14686.7 -0.98125
ISLE OF WIGHT 791 16964.96 2.75 434.63 -16533.1 -0.97454
PRINCE WILLIAM 1173 21593.87 6.08 713.23 -20886.7 -0.96725
ALLEGHANY 191 21938.66 6.34 110.03 -21835 -0.99527
GILES 193 24886.24 15.21 104.81 -24796.6 -0.9964
YORK 41 31129.51 25.45 25.45 -31129.5 -1
FAIRFAX 101 31715.89 62.06 62.06 -31715.9 -1
CHESTERFIELD 571 32908.71 22.25 363 -32568 -0.98965
SUFFOLK CITY 1167 35591.82 57.92 620.1 -35029.6 -0.9842

Large Farmers Unreported 2007

<style> </style>
County Total.Irri.Area Facility_withdrawal_mg SM_F_Unreported All_Irrigation Large_Farm_unreported C_tot_lg
NORTHAMPTON 9286 1183.686 26.78 5181.48 3971.014 3.354787
PITTSYLVANIA 4187 1073.054 37.07 2425.47 1315.346 1.225796
MECKLENBURG 3235 713.222 36.42 1963.55 1213.908 1.702006
DINWIDDIE 1885 156.3327 13.18 993.6 824.0873 5.271369
HANOVER 3188 1033.165 60.4 1660.05 566.4851 0.548301
SURRY 1028 103.262 11.36 530.92 416.298 4.031473
CHARLES CITY 739 45.21013 5.78 355.69 304.6999 6.739637
SUSSEX 1645 588.938 0 891.61 302.672 0.513928
AMELIA 562 15.681 20.88 308.8 272.239 17.36107
LUNENBURG 770 216.203 20.72 455.89 218.967 1.012784
CHARLOTTE 731 119.473 76.9 413.34 216.967 1.816033
ACCOMACK 6508 3324.218 26.51 3520.5 169.7717 0.051071
CARROLL 600 163.0234 16.67 322.65 142.9566 0.876908
HALIFAX 1549 698.4145 71.65 902.26 132.1955 0.189279
MIDDLESEX 480 160.2157 0 253.01 92.79427 0.579183
RAPPAHANNOCK 132 14.271 30.71 72.39 27.409 1.920608
RICHMOND 243 113.7787 1.16 140.51 25.57128 0.224746
CLARKE 514 258.6409 36.42 311.98 16.91914 0.065416
MATHEWS 53 5.9702 10.32 28.78 12.4898 2.092024
PRINCE EDWARD 123 30.88316 34.5 70.73 5.346837 0.173131
GRAYSON 97 50.13227 19.74 51.75 -18.1223 -0.36149
FLOYD 108 22.396 63.94 63.94 -22.396 -1
CRAIG 6 32.0455 3.34 3.34 -32.0455 -1
POWHATAN 28 50.1273 1.11 15.5 -35.7373 -0.71293
BLAND 10 57.531 5.69 5.69 -57.531 -1
PATRICK 432 285.8151 11.39 223.57 -73.6351 -0.25763
LOUISA 279 196.0423 27.77 143.5 -80.3123 -0.40967
MADISON 69 105.548 19.64 34.75 -90.438 -0.85684
FRANKLIN 872 492.8103 76.33 475.42 -93.7203 -0.19018
APPOMATTOX 43 97.49015 23.58 23.58 -97.4902 -1
BUCKINGHAM 39 161.2807 13.54 20.31 -154.511 -0.95802
BRUNSWICK 1316 931.0598 15.53 786.16 -160.43 -0.17231
GREENE 154 248.5711 23.57 77.24 -194.901 -0.78409
WESTMORELAND 1673 1235.924 3.12 1043.97 -195.074 -0.15784
FLUVANNA 264 346.6548 15.21 133.81 -228.055 -0.65787
PRINCE GEORGE 6 255.9439 3.05 3.05 -255.944 -1
NOTTOWAY 386 464.5778 17.69 213.33 -268.938 -0.57889
KING AND QUEEN 16 298.32 8.71 8.71 -298.32 -1
SCOTT 243 397.3463 44.01 127.31 -314.046 -0.79036
ORANGE 627 719.1761 20.89 335.84 -404.226 -0.56207
LOUDOUN 3533 2538.797 88.31 2197.1 -430.007 -0.16937
PAGE 296 605.7942 23.52 148.14 -481.174 -0.79429
GLOUCESTER 58 507.5373 30.7 30.7 -507.537 -1
CULPEPER 1266 1255.776 39.17 740.12 -554.826 -0.44182
RUSSELL 134 644.7502 13.45 64.35 -593.85 -0.92105
LEE 297 766.738 24.31 167.94 -623.108 -0.81267
BOTETOURT 63 659.3764 13.92 35.09 -638.206 -0.96789
NELSON 774 1060.21 50.61 403.86 -706.96 -0.66681
FAUQUIER 920 1254.396 94.73 544.7 -804.426 -0.64129
HENRY 525 1111.624 3.34 291.83 -823.134 -0.74048
KING GEORGE 672 1242.08 12.86 411.46 -843.48 -0.67909
GOOCHLAND 20 949.7262 10.09 10.09 -949.726 -1
NORTHUMBERLAND 62 987.2377 0.57 35.39 -952.418 -0.96473
ROCKBRIDGE 109 1052.877 24.39 57.8 -1019.47 -0.96827
TAZEWELL 330 1247.325 15.84 180.27 -1082.9 -0.86817
CAROLINE 2112 2399.617 45.43 1214.45 -1230.6 -0.51283
SMYTH 188 1719.006 37.11 105.7 -1650.42 -0.9601
PULASKI 241 1780.94 13.05 136.78 -1657.21 -0.93053
SHENANDOAH 755 2007.441 64.29 388.32 -1683.41 -0.83859
WISE 115 1773.069 2.55 58.54 -1717.08 -0.96842
CAMPBELL 779 2235.982 59.25 431.35 -1863.88 -0.83359
FREDERICK 298 2243.942 60.23 177.7 -2126.47 -0.94765
AUGUSTA 3813 4114.818 103.41 2022.04 -2196.19 -0.53373
WYTHE 164 3002.442 32.39 96.57 -2938.26 -0.97862
WASHINGTON 410 3408.196 61.82 206.07 -3263.95 -0.95768
ALBEMARLE 1026 3966.777 33.62 492.74 -3507.66 -0.88426
SOUTHAMPTON 3507 5903.591 49.07 1912.05 -4040.61 -0.68443
SPOTSYLVANIA 144 4155.782 43.91 80.04 -4119.65 -0.99131
WARREN 58 4304.443 33.97 33.97 -4304.44 -1
CHESAPEAKE CITY 239 4509.785 27.67 118.09 -4419.37 -0.97995
BATH 7 4446.422 4.14 4.14 -4446.42 -1
ROANOKE 94 4487.925 29.69 52.65 -4464.97 -0.99488
STAFFORD 221 4652.618 6.17 124.02 -4534.77 -0.97467
JAMES CITY 29 5613.277 7.91 14.33 -5606.86 -0.99886
KING WILLIAM 2690 7165.262 0 1472.34 -5692.92 -0.79452
AMHERST 147 5940.585 15.67 85.31 -5870.95 -0.98828
BEDFORD 567 6611.068 23.36 323.02 -6311.41 -0.95467
ROCKINGHAM 4808 9031.399 110.1 2196.42 -6945.08 -0.76899
MONTGOMERY 384 8688.828 22.62 228.58 -8482.87 -0.9763
NEW KENT 495 10425.08 3.52 248.79 -10179.8 -0.97647
HENRICO 25 11258.71 12.49 12.49 -11258.7 -1
VIRGINIA BEACH CITY 193 13960.18 27.75 105.02 -13882.9 -0.99446
ISLE OF WIGHT 702 15366.27 23.75 379 -15011 -0.97688
GILES 30 22192.28 7.14 16.48 -22182.9 -0.99958
PRINCE WILLIAM 685 28178.82 52.69 405.56 -27826 -0.98748
YORK 17 32214.19 8.74 8.74 -32214.2 -1
CHESTERFIELD 185 33392.74 24.83 99.88 -33317.7 -0.99775
FAIRFAX 40 34091.97 23.85 23.85 -34092 -1
SUFFOLK CITY 616 38298.19 32.37 293.21 -38037.4 -0.99319

Large Farmers Unreported 2012

<style> </style>
County Total.Irri.Area Facility_withdrawal_mg SM_F_Unreported All_Irrigation Large_Farm_unreported C_tot_lg
NORTHAMPTON 6335 1177.015 22.12 2981.69 1782.555 1.514472
PITTSYLVANIA 3717 703.5115 98.95 1998.84 1196.379 1.700581
DINWIDDIE 1162 52.41692 28.84 632.3 551.0431 10.51269
HANOVER 3338 1177.759 133.88 1809.25 497.6114 0.422507
MECKLENBURG 2760 585.5844 25.86 1081.56 470.1156 0.802814
SURRY 1238 78.11996 28.45 541.82 435.25 5.57156
CARROLL 1086 190.4055 10.16 580.53 379.9645 1.995554
HALIFAX 2152 675.589 118.02 1138.92 345.311 0.511126
CHARLES CITY 1435 428.0656 5.41 705.97 272.4944 0.636572
CHARLOTTE 759 82.747 44.35 396.03 268.933 3.250063
SUSSEX 1371 456.542 11.98 656.97 188.448 0.412773
WESTMORELAND 1642 757.3936 1.12 923.21 164.6964 0.217452
BRUNSWICK 1280 361.7987 16.87 539.76 161.0913 0.445251
MIDDLESEX 477 144.406 9.12 241.78 88.25397 0.611152
AMELIA 374 117.781 27.17 225.81 80.859 0.68652
LUNENBURG 444 170.069 15.57 209.45 23.811 0.140008
POWHATAN 99 40.7775 10.63 52.61 1.2025 0.029489
RAPPAHANNOCK 121 13.24 48.05 61.2 -0.09 -0.0068
FLOYD 192 34.472 77.19 111.43 -0.232 -0.00673
CUMBERLAND 18 2.3137 9.72 9.72 -2.3137 -1
MATHEWS 17 7.8853 8.11 8.11 -7.8853 -1
APPOMATTOX 105 42.3 42.52 55.12 -29.7 -0.70213
MADISON 70 49.5564 13.7 31.98 -31.2764 -0.63113
GRAYSON 45 36.6599 24.49 24.49 -36.6599 -1
RICHMOND 126 100.346 11.56 69.37 -42.536 -0.42389
PRINCE GEORGE 8 107.5899 4.09 4.09 -107.59 -1
NORTHUMBERLAND 38 135.1638 1.02 19.34 -116.844 -0.86446
LOUISA 278 217.1385 42.92 135.58 -124.478 -0.57327
BUCKINGHAM 16 125.099 8.38 8.38 -125.099 -1
CLARKE 249 252.6576 15.47 137.61 -130.518 -0.51658
PAGE 1005 646.848 9.61 508.34 -148.118 -0.22898
FRANKLIN 893 450.9327 35.76 310 -176.693 -0.39184
SOUTHAMPTON 3246 1398.276 10.55 1223.62 -185.206 -0.13245
PATRICK 108 251.0541 18.49 52.56 -216.984 -0.86429
GREENE 49 228.9864 17.48 22.54 -223.926 -0.9779
RUSSELL 12 233.732 5.47 5.47 -233.732 -1
KING AND QUEEN 18 250.445 10.06 10.06 -250.445 -1
FLUVANNA 144 326.771 30.98 73.14 -284.611 -0.87098
PRINCE EDWARD 96 380.8697 6.21 54.18 -332.9 -0.87405
SCOTT 56 377.6281 9.92 24.15 -363.398 -0.96232
NOTTOWAY 75 392.96 30.28 41.29 -381.95 -0.97198
ORANGE 563 641.9746 24.38 269.18 -397.175 -0.61868
KING GEORGE 350 636.7857 19.7 202.75 -453.736 -0.71254
GLOUCESTER 46 475.7657 23.32 23.32 -475.766 -1
BOTETOURT 52 621.3561 12.99 27.02 -607.326 -0.97742
TAZEWELL 18 613.3172 8.8 8.8 -613.317 -1
NELSON 862 1032.9 29.01 438.76 -623.15 -0.6033
GREENSVILLE 246 743.8175 3.62 99.02 -648.417 -0.87174
CULPEPER 641 998.4472 32.92 329.68 -701.687 -0.70278
ROCKBRIDGE 137 818.7137 27.46 63.75 -782.424 -0.95567
LEE 61 800.624 28.19 28.19 -800.624 -1
GOOCHLAND 32 801.5221 15.85 15.85 -801.522 -1
CRAIG 10 895.4523 5.65 5.65 -895.452 -1
FAUQUIER 394 1089.439 110.87 211.04 -989.269 -0.90805
HENRY 137 1209.686 21.94 75.13 -1156.5 -0.95603
CAROLINE 1959 2654.551 14.27 1118.13 -1550.69 -0.58416
FREDERICK 151 1624.9 40.8 77.99 -1587.71 -0.97711
PULASKI 14 1651.929 7.98 7.98 -1651.93 -1
CAMPBELL 290 1786.791 52.7 155.95 -1683.54 -0.94221
SHENANDOAH 719 1984.426 52.72 341.47 -1695.68 -0.85449
ACCOMACK 5371 4613.682 25.7 2556.56 -2082.82 -0.45144
SMYTH 18 2090.007 9.41 9.41 -2090.01 -1
LOUDOUN 580 2337.318 134.63 332.28 -2139.67 -0.91544
DICKENSON 12 2145.649 5.8 5.8 -2145.65 -1
JAMES CITY 37 2230.916 6.72 16.59 -2221.05 -0.99558
CHESAPEAKE CITY 282 2422.933 30.56 126.72 -2326.77 -0.96031
HIGHLAND 20 2577.252 4.46 9.9 -2571.81 -0.99789
AUGUSTA 3271 4038.266 39.74 1494.28 -2583.73 -0.63981
WISE 12 2587.331 4.52 4.52 -2587.33 -1
WYTHE 72 2699.777 28.13 38.95 -2688.96 -0.99599
ALBEMARLE 1456 3716.215 83.9 727.16 -3072.95 -0.8269
WARREN 12 3510.696 6.38 6.38 -3510.7 -1
WASHINGTON 224 3633.409 43.22 108.77 -3567.86 -0.98196
SPOTSYLVANIA 58 3808.417 16.86 33.72 -3791.56 -0.99557
BATH 19 3818.33 9.61 9.61 -3818.33 -1
STAFFORD 25 3946.842 14.46 14.46 -3946.84 -1
ISLE OF WIGHT 702 4499.247 5.03 271.35 -4232.93 -0.94081
ROANOKE 96 4364.626 26.47 47.94 -4343.16 -0.99508
BEDFORD 93 6562.061 30.99 53.38 -6539.67 -0.99659
ROCKINGHAM 5645 9269.704 160.63 2590.81 -6839.52 -0.73784
VIRGINIA BEACH CITY 180 7247.616 20.99 85.87 -7182.74 -0.99105
KING WILLIAM 1125 7903.223 8.94 628.93 -7283.23 -0.92155
YORK 21 8251.782 3.54 9.3 -8246.02 -0.9993
HENRICO 7 9648.405 3.52 3.52 -9648.4 -1
MONTGOMERY 349 10645.25 21.43 202.17 -10464.5 -0.98302
ALLEGHANY 8 14351.13 4.18 4.18 -14351.1 -1
PRINCE WILLIAM 1006 24517.31 39.82 580.62 -23976.5 -0.97794
GILES 32 24019.44 18.4 18.4 -24019.4 -1
FAIRFAX 50 32000.1 30.83 30.83 -32000.1 -1
CHESTERFIELD 64 32729.12 6.67 35.57 -32700.2 -0.99912
SUFFOLK CITY 414 33496.68 22.65 151.21 -33368.1 -0.99616

Large Farmers Unreported 2017

<style> </style>
County Total.Irri.Area Facility_withdrawal_mg SM_F_Unreported All_Irrigation Large_Farm_unreported C_tot_lg
NORTHAMPTON 5857 883.1606 4.05 2962.53 2075.319 2.349878
MECKLENBURG 4163 717.9267 47.21 1946.1 1180.963 1.644964
DINWIDDIE 1578 156.4844 12.62 737.68 568.5756 3.633432
LUNENBURG 1408 189.453 7.28 683.69 486.957 2.570331
BRUNSWICK 2115 588.3132 2.73 963.94 372.8968 0.633841
BLAND 801 68.0126 2.16 431.6 361.4274 5.314124
SURRY 929 119.0785 4.53 420.43 296.8216 2.492655
HANOVER 3569 1365.922 87.68 1748.23 294.6281 0.215699
CHARLES CITY 1376 389.4208 6.76 619.8 223.6192 0.574235
KING AND QUEEN 1221 423.2449 18.32 604.59 163.0251 0.385179
CHARLOTTE 534 97.947 49.45 280.91 133.513 1.363115
CARROLL 597 182.0327 8.21 306.42 116.1773 0.638222
CUMBERLAND 167 5.11825 13.27 96.38 77.99175 15.23797
AMELIA 205 59.99334 9.39 101.29 31.90666 0.531837
MIDDLESEX 270 92.47545 12.27 127.37 22.62455 0.244655
GRAYSON 160 74.95833 10.6 80.76 -4.79833 -0.06401
MATHEWS 10 4.953694 5.19 5.19 -4.95369 -1
APPOMATTOX 24 6.5 12.78 12.78 -6.5 -1
RAPPAHANNOCK 61 12.237 30.85 30.85 -12.237 -1
POWHATAN 63 69.95639 8.25 32.47 -45.7364 -0.65378
FLOYD 182 79.81044 67.81 101.17 -46.4504 -0.58201
MADISON 80 65.751 33.25 39.7 -59.301 -0.9019
WESTMORELAND 882 436.6395 51.3 407.62 -80.3195 -0.18395
BUCKINGHAM 65 121.18 10.58 36.2 -95.56 -0.78858
RICHMOND 29 102.711 7.97 14.45 -96.231 -0.93691
CAROLINE 3411 1675.266 8.58 1540.07 -143.776 -0.08582
PATRICK 213 232.3817 36.57 101.16 -167.792 -0.72205
LANCASTER 12 177.5552 5.35 5.35 -177.555 -1
CLARKE 143 237.3854 17.78 74.77 -180.395 -0.75993
LOUISA 215 264.1097 49.45 118.14 -195.42 -0.73992
GREENE 24 229.4875 11.45 11.45 -229.487 -1
HALIFAX 1061 730.0528 25.25 515.2 -240.103 -0.32888
SUSSEX 699 541.7868 6.29 293.27 -254.807 -0.47031
PITTSYLVANIA 1492 929.0033 37.13 710.18 -255.953 -0.27551
FLUVANNA 79 311.7914 10.43 45.76 -276.461 -0.88669
FRANKLIN 441 448.8089 39.65 163.42 -325.039 -0.72423
NOTTOWAY 44 392.2 22.96 22.96 -392.2 -1
SCOTT 13 415.799 6.15 6.15 -415.799 -1
PRINCE EDWARD 14 428.1339 7.51 7.51 -428.134 -1
ESSEX 3 440.2143 1.46 1.46 -440.214 -1
GLOUCESTER 13 486.6015 6.64 6.64 -486.602 -1
NELSON 1016 1035.723 35.98 553.93 -517.773 -0.49991
BOTETOURT 10 532.3323 5.54 5.54 -532.332 -1
ORANGE 214 638.6902 20.06 110.07 -548.68 -0.85907
PAGE 108 658.1734 10.86 58.65 -610.383 -0.92739
ROCKBRIDGE 83 670.4299 21.21 44.02 -647.62 -0.96598
GOOCHLAND 112 732.6279 11.01 61.66 -681.978 -0.93087
GREENSVILLE 5 729.4155 2.29 2.29 -729.415 -1
CULPEPER 615 1074.751 90.16 332.03 -832.881 -0.77495
LEE 32 870.482 14.01 14.01 -870.482 -1
ACCOMACK 5079 3309.035 26.93 2358.08 -977.885 -0.29552
FAUQUIER 452 1176.654 109.07 227.18 -1058.54 -0.89962
CRAIG 115 1247.686 10.5 63.56 -1194.63 -0.95747
HENRY 43 1227.356 7.36 22.62 -1212.1 -0.98757
PULASKI 28 1598.12 15.8 15.8 -1598.12 -1
SHENANDOAH 893 2336.518 52.92 477.36 -1912.08 -0.81835
FREDERICK 38 1937.021 7.86 19.91 -1924.97 -0.99378
CHESAPEAKE CITY 72 1982.655 20.94 26.45 -1977.14 -0.99722
SMYTH 28 2062.959 13.27 13.27 -2062.96 -1
CAMPBELL 313 2235.733 22.92 179.32 -2079.33 -0.93005
SOUTHAMPTON 1624 2809.936 5.44 631.21 -2184.17 -0.7773
WISE 27 2262.56 6.6 11.87 -2257.29 -0.99767
AUGUSTA 2550 3502.974 104.89 1344.12 -2263.74 -0.64623
WYTHE 18 2789.952 9.93 9.93 -2789.95 -1
JAMES CITY 40 3185.089 14.03 20.79 -3178.33 -0.99788
WARREN 10 3619.162 5.53 5.53 -3619.16 -1
WASHINGTON 122 3971.443 24.06 57.55 -3937.95 -0.99157
SPOTSYLVANIA 96 4081.042 12.62 44.88 -4048.78 -0.9921
ROANOKE 71 4181.906 35.91 35.91 -4181.91 -1
LOUDOUN 392 4344.776 120.6 195.36 -4270.02 -0.98279
ALBEMARLE 783 4644.929 61.61 426.9 -4279.64 -0.92136
STAFFORD 10 4400.723 5.1 5.1 -4400.72 -1
AMHERST 176 6120.39 12.2 93.33 -6039.26 -0.98674
ROCKINGHAM 5526 8875.608 146.24 2865.72 -6156.13 -0.6936
KING WILLIAM 1618 7126.215 8.44 802.89 -6331.76 -0.88852
YORK 11 6494.848 5.4 5.4 -6494.85 -1
NEW KENT 271 6832.186 8.78 132.17 -6708.8 -0.98194
BEDFORD 51 6874.716 26.01 26.01 -6874.72 -1
ISLE OF WIGHT 934 7678.511 14.46 365.01 -7327.96 -0.95435
HENRICO 28 9402.481 13.51 13.51 -9402.48 -1
MONTGOMERY 323 9659.75 19.21 172.32 -9506.64 -0.98415
VIRGINIA BEACH CITY 315 10503.86 22.98 111.36 -10415.5 -0.99159
PRINCE WILLIAM 943 25403.48 16.76 464.93 -24955.3 -0.98236
GILES 27 25126.1 13.43 13.43 -25126.1 -1
FAIRFAX 60 32642.41 29.58 29.58 -32642.4 -1
SUFFOLK CITY 585 35939.42 23.7 231.11 -35732 -0.99423
CHESTERFIELD 75 36089.35 13.27 35.54 -36067.1 -0.99938

@laljeet
Copy link
Collaborator

laljeet commented May 19, 2022

Map of C_irr_lg

2002Large farm unreported DeqIrrigation
2007Large farm unreported DeqIrrigation
2012Large farm unreported DeqIrrigation
2017Large farm unreported DeqIrrigation

@laljeet
Copy link
Collaborator

laljeet commented May 19, 2022

Map of C_tot_lg
A lot of values are -ve for coefficient (reported withdrawals (all use types) is high)
2002Large farm unreported Deq Total
2007Large farm unreported Deq Total
2012Large farm unreported Deq Total
2017Large farm unreported Deq Total

@laljeet
Copy link
Collaborator

laljeet commented May 27, 2022

  • Scatter Plot for Ag census Irrigation vs VDEQ reported
  • Update the Large farmers unreported method
  • generate timeseries

@laljeet
Copy link
Collaborator

laljeet commented May 27, 2022

Scatter_AgCenusus VS DeqIRR

@laljeet
Copy link
Collaborator

laljeet commented May 27, 2022

Using DEQ Irrigation withdrawals and Rainfall Deficit Approach (Updated)

Large Farmers Unreported 2002

<style> </style>
County Total.Irri.Area Irr.Area.Under.TH Facility_Total_mg PPT Irrigation SM_F_Unreported Facility_withdrawal_mg All_Irrigation Large_Farm_unreported C_tot_lg
ACCOMACK 9716 17 5389.551 215.86 546 9.88 3444.534 5649.03 2194.616 0.407198
ALBEMARLE 1387 120 3908.21 249.55 512 65.43 0 756.21 690.78 0.176751
ALLEGHANY 191 11 21938.66 220.71 541 6.34 0 110.03 103.69 0.004726
AMELIA 886 109 42.093 183.52 578 67.09 42.093 545.32 436.137 10.36127
AMHERST 144 36 5863 194.36 568 21.77 0 87.1 65.33 0.011143
APPOMATTOX 508 19 87.302 200.94 561 11.35 0 303.47 292.12 3.346086
AUGUSTA 3416 184 4341.005 183.24 579 113.45 461.554 2106.15 1531.146 0.352717
BATH 109 0 4118.789 211.17 551 0 0 63.95 63.95 0.015526
BEDFORD 676 159 4864.39 241.49 521 88.21 0 375.04 286.83 0.058965
BLAND 135 21 72.718 266.76 495 11.07 0 71.16 60.09 0.826343
BOTETOURT 253 77 2906.554 219.1 543 44.52 0 146.29 101.77 0.035014
BRUNSWICK 1474 126 731.753 280.95 481 64.54 0 754.98 690.44 0.943542
BUCKINGHAM 469 16 459.12 182.8 579 9.86 0 289.16 279.3 0.608338
CAMPBELL 1328 130 2215.335 231.63 530 73.37 0 749.49 676.12 0.3052
CAROLINE 2272 25 2657.677 203.9 558 14.85 960.526 1350.01 374.634 0.140963
CARROLL 785 60 168.574 281.67 480 30.67 0 401.24 370.57 2.198263
CHARLES CITY 1122 21 291.196 162.91 599 13.39 268.67 715.67 433.61 1.489066
CHARLOTTE 1454 202 116.545 271.47 491 105.62 0 760.22 654.6 5.616715
CHESTERFIELD 571 35 32908.71 164.69 597 22.25 55 363 285.75 0.008683
CLARKE 327 94 259.3761 257.98 504 50.45 42.8 175.5 82.25 0.317107
CRAIG 130 30 862.29 252.17 510 16.29 0 70.6 54.31 0.062983
CULPEPER 589 111 598.094 214.71 547 64.66 4.11 343.08 274.31 0.45864
CUMBERLAND 222 27 2.622 174.03 588 16.91 0 139 122.09 46.56369
DINWIDDIE 1164 115 102.639 257.98 504 61.72 14.055 624.71 548.935 5.348211
ESSEX 246 39 295.8453 205.9 556 23.09 140.34 145.65 -17.78 -0.0601
FAIRFAX 101 101 31715.89 185.45 577 62.06 14.599 62.06 -14.599 -0.00046
FAUQUIER 862 202 917.868 206.7 555 119.38 0 509.44 390.06 0.424963
FLOYD 779 196 59.2953 204.98 557 116.25 0 462.05 345.8 5.831828
FLUVANNA 57 24 264.9282 225.19 537 13.72 0 32.59 18.87 0.071227
FRANKLIN 1126 242 414.587 273.46 489 126.01 11.81 586.33 448.51 1.081824
FREDERICK 520 159 672.497 261.41 501 84.83 9 277.42 183.59 0.272998
GILES 193 28 24886.24 252.49 510 15.21 0 104.81 89.6 0.0036
GLOUCESTER 98 51 445.9206 198.37 564 30.63 0 58.86 28.23 0.063307
GOOCHLAND 101 23 695.2937 187.49 575 14.08 0 61.84 47.76 0.06869
GRAYSON 619 77 67.504 287.24 475 38.95 0 313.1 274.15 4.061241
GREENE 36 36 201.2057 279.71 482 18.48 0 18.48 0 0
GREENSVILLE 734 0 647.5772 268.68 493 0 50.8297 385.33 334.5003 0.516541
HALIFAX 2617 82 772.2776 253.93 508 44.36 26.816 1415.67 1344.494 1.740947
HANOVER 2393 278 5914.352 170.63 591 174.95 236.0457 1506 1095.004 0.185144
HENRICO 49 49 677.1815 175.58 586 30.58 0 30.58 0 0
HENRY 416 39 1815.299 230.12 532 22.09 0 235.67 213.58 0.117656
ISLE OF WIGHT 791 5 16964.96 246.5 516 2.75 97.5 434.63 334.38 0.01971
JAMES CITY 102 12 5502.305 169.8 592 7.56 0 64.3 56.74 0.010312
KING AND QUEEN 743 64 261.51 184.5 578 39.39 256.91 457.31 161.01 0.615693
KING GEORGE 3 3 761.1532 194.17 568 1.81 0 1.81 0 0
KING WILLIAM 2457 15 7514.243 174.97 587 9.38 143.51 1535.81 1382.92 0.18404
LEE 1374 204 597.42 232.23 530 115.13 0 775.45 660.32 1.105286
LOUDOUN 3666 185 2154.691 209.01 553 108.94 36.6 2158.79 2013.25 0.934357
LOUISA 365 51 199.934 266.05 496 26.94 0 192.78 165.84 0.829474
LUNENBURG 1484 61 231.424 278.51 483 31.37 10 763.26 721.89 3.119339
MADISON 333 72 39.538 261.94 500 38.34 0 177.3 138.96 3.514594
MATHEWS 117 5 1.113 209.99 552 2.94 0 68.77 65.83 59.14645
MECKLENBURG 4158 236 1132.005 244.82 517 129.93 5.59 2289.12 2153.6 1.902465
MIDDLESEX 651 16 117.3 217.69 544 9.27 13.4 377.11 354.44 3.021654
MONTGOMERY 303 41 8396.089 189.56 572 24.97 17 184.56 142.59 0.016983
NELSON 795 145 593.2255 200.79 561 86.62 192.13 474.92 196.17 0.330684
NEW KENT 458 15 14967.41 167.24 595 9.5 11.89 290.19 268.8 0.017959
NORTHAMPTON 9338 44 997.0889 204.19 558 26.14 742.087 5548.58 4780.353 4.79431
NORTHUMBERLAND 38 10 73.9144 215.27 547 5.82 0 22.13 16.31 0.220661
NOTTOWAY 457 32 214.159 215.41 547 18.64 0 266.19 247.55 1.155917
ORANGE 1556 53 569.231 237.63 524 29.57 0.45 868.23 838.21 1.47253
PAGE 238 14 876.3444 231.87 530 7.9 34.476 134.32 91.944 0.104918
PATRICK 325 134 241.6111 230.32 532 75.91 0 184.11 108.2 0.447827
PITTSYLVANIA 5606 211 1800.395 237 525 117.96 86.068 3134.05 2930.022 1.627433
POWHATAN 230 32 32.6476 177.67 584 19.9 0.58 143.03 122.55 3.753722
PRINCE EDWARD 526 46 408.714 192.82 569 27.87 38.6 318.71 252.24 0.617155
PRINCE WILLIAM 1173 10 21593.87 191.17 571 6.08 3.4 713.23 703.75 0.03259
PULASKI 320 3 1760.111 212.68 549 1.75 0 187.08 185.33 0.105294
RAPPAHANNOCK 335 10 14.576 222.83 539 5.74 0 192.28 186.54 12.79775
ROANOKE 92 82 7430.96 255.62 506 44.18 20.7 49.57 -15.31 -0.00206
ROCKBRIDGE 700 55 1333.349 182.33 580 33.97 0 432.33 398.36 0.298767
ROCKINGHAM 4355 174 8784.345 211.37 551 102.09 276.896 2555.25 2176.264 0.247743
RUSSELL 251 118 1644.277 327.72 434 54.53 0 116 61.47 0.037384
SCOTT 637 180 380.623 281.04 481 92.2 0 326.27 234.07 0.614965
SHENANDOAH 1110 36 1967.59 237.71 524 20.09 30.277 619.37 569.003 0.289188
SMYTH 452 38 2503.458 315.77 446 18.05 0 214.67 196.62 0.078539
SOUTHAMPTON 2385 0 6068.353 296.08 466 0 41 1183.5 1142.5 0.188272
SPOTSYLVANIA 346 40 3729.491 188.63 573 24.41 60.56 211.12 126.15 0.033825
STAFFORD 186 22 3516.87 198.83 563 13.19 0 111.51 98.32 0.027957
SURRY 1472 30 136.3014 239.91 522 16.68 53.203 818.22 748.337 5.49031
SUSSEX 1410 16 397.3285 297.29 465 7.92 38.6 698.18 651.66 1.640104
TAZEWELL 245 29 1763.684 294.61 467 14.42 0 121.84 107.42 0.060907
WARREN 151 70 3691.946 238.84 523 38.98 0 84.1 45.12 0.012221
WASHINGTON 836 155 3081.793 372.99 389 64.21 0 346.3 282.09 0.091534
WESTMORELAND 1474 122 663.7307 229.79 532 69.11 311.381 835.03 454.539 0.684824
WISE 28 10 2350.495 308.96 453 4.82 0 13.51 8.69 0.003697
WYTHE 1061 22 1596.589 254.55 507 11.88 0 572.82 560.94 0.351336
YORK 41 41 31129.51 179.13 583 25.45 0 25.45 0 0
CHESAPEAKE CITY 314 189 1681.94 266.87 495 99.62 0 165.51 65.89 0.039175
SUFFOLK CITY 1167 109 35591.82 262.99 499 57.92 208.64 620.1 353.54 0.009933
VIRGINIA BEACH CITY 431 35 10522.48 228.38 534 19.9 0 245.08 225.18 0.0214

Large Farmers Unreported 2007

<style> </style>
County Total.Irri.Area Irr.Area.Under.TH Facility_Total_mg PPT Irrigation SM_F_Unreported Facility_withdrawal_mg All_Irrigation Large_Farm_unreported C_tot_lg
ACCOMACK 6508 49 3324.218 254.2 508 26.51 1779.744 3520.5 1714.246 0.515684
ALBEMARLE 1026 70 3966.777 310.72 451 33.62 0 492.74 459.12 0.115741
AMELIA 562 38 15.681 245.76 516 20.88 15.681 308.8 272.239 17.36107
AMHERST 147 27 5940.585 216.57 545 15.67 0 85.31 69.64 0.011723
APPOMATTOX 43 43 97.49015 246.72 515 23.58 0 23.58 0 0
AUGUSTA 3813 195 4114.818 263.68 498 103.41 592.1592 2022.04 1326.471 0.322364
BATH 7 7 4446.422 206.39 556 4.14 0 4.14 0 0
BEDFORD 567 41 6611.068 227.42 535 23.36 11.9226 323.02 287.7374 0.043524
BLAND 10 10 57.531 227.8 534 5.69 0 5.69 0 0
BOTETOURT 63 25 659.3764 238.53 523 13.92 0 35.09 21.17 0.032106
BRUNSWICK 1316 26 931.0598 200.65 561 15.53 0 786.16 770.63 0.827691
BUCKINGHAM 39 26 161.2807 272.59 489 13.54 0 20.31 6.77 0.041977
CAMPBELL 779 107 2235.982 242.45 520 59.25 59.51 431.35 312.59 0.1398
CAROLINE 2112 79 2399.617 221.7 540 45.43 541.364 1214.45 627.656 0.261565
CARROLL 600 31 163.0234 257.15 505 16.67 0 322.65 305.98 1.876908
CHARLES CITY 739 12 45.21013 310.18 452 5.78 11.9 355.69 338.01 7.476422
CHARLOTTE 731 136 119.473 231.06 531 76.9 23.2 413.34 313.24 2.621847
CHESTERFIELD 185 46 33392.74 254.63 507 24.83 37.9 99.88 37.15 0.001113
CLARKE 514 60 258.6409 191.58 570 36.42 44 311.98 231.56 0.895296
CRAIG 6 6 32.0455 239.52 522 3.34 0 3.34 0 0
CULPEPER 1266 67 1255.776 212.79 549 39.17 410.727 740.12 290.223 0.231111
DINWIDDIE 1885 25 156.3327 266.9 495 13.18 97.3087 993.6 883.1113 5.648922
FAIRFAX 40 40 34091.97 202.2 560 23.85 17.4 23.85 -17.4 -0.00051
FAUQUIER 920 160 1254.396 206.09 556 94.73 0 544.7 449.97 0.358715
FLOYD 108 108 22.396 205.91 556 63.94 0 63.94 0 0
FLUVANNA 264 30 346.6548 285.7 476 15.21 0 133.81 118.6 0.342127
FRANKLIN 872 140 492.8103 249.5 512 76.33 0 475.42 399.09 0.809825
FREDERICK 298 101 2243.942 202.47 560 60.23 13.534 177.7 103.936 0.046318
GILES 30 13 22192.28 246.32 516 7.14 0 16.48 9.34 0.000421
GLOUCESTER 58 58 507.5373 265.47 497 30.7 0 30.7 0 0
GOOCHLAND 20 20 949.7262 287.78 474 10.09 0 10.09 0 0
GRAYSON 97 37 50.13227 260.92 501 19.74 0 51.75 32.01 0.638511
GREENE 154 47 248.5711 291.39 471 23.57 0 77.24 53.67 0.215914
HALIFAX 1549 123 698.4145 215.03 547 71.65 9.12 902.26 821.49 1.176221
HANOVER 3188 116 1033.165 272.89 489 60.4 274.1886 1660.05 1325.461 1.282914
HENRICO 25 25 11258.71 293.27 469 12.49 0 12.49 0 0
HENRY 525 6 1111.624 240.14 522 3.34 0 291.83 288.49 0.259521
ISLE OF WIGHT 702 44 15366.27 255.19 507 23.75 123 379 232.25 0.015114
JAMES CITY 29 16 5613.277 298.49 464 7.91 0 14.33 6.42 0.001144
KING AND QUEEN 16 16 298.32 250.93 511 8.71 293.42 8.71 -293.42 -0.98357
KING GEORGE 672 21 1242.08 187.45 575 12.86 175.802 411.46 222.798 0.179375
KING WILLIAM 2690 0 7165.262 247.95 514 0 702.694 1472.34 769.646 0.107414
LEE 297 43 766.738 230.55 531 24.31 0 167.94 143.63 0.187326
LOUDOUN 3533 142 2538.797 177.57 584 88.31 32.6308 2197.1 2076.159 0.817773
LOUISA 279 54 196.0423 278.76 483 27.77 0 143.5 115.73 0.590332
LUNENBURG 770 35 216.203 206.45 556 20.72 8.66 455.89 426.51 1.972729
MADISON 69 39 105.548 289.26 473 19.64 0 34.75 15.11 0.143158
MATHEWS 53 19 5.9702 252.32 510 10.32 0 28.78 18.46 3.092024
MECKLENBURG 3235 60 713.222 191.51 570 36.42 7.17 1963.55 1919.96 2.691953
MIDDLESEX 480 0 160.2157 266.65 495 0 90.576 253.01 162.434 1.013846
MONTGOMERY 384 38 8688.828 203.37 559 22.62 46.54 228.58 159.42 0.018348
NELSON 774 97 1060.21 271.92 490 50.61 468.463 403.86 -115.213 -0.10867
NEW KENT 495 7 10425.08 290.31 472 3.52 138.01 248.79 107.26 0.010289
NORTHAMPTON 9286 48 1183.686 238.36 524 26.78 907.2193 5181.48 4247.481 3.588351
NORTHUMBERLAND 62 1 987.2377 226.46 536 0.57 0 35.39 34.82 0.03527
NOTTOWAY 386 32 464.5778 243.11 519 17.69 0 213.33 195.64 0.421113
ORANGE 627 39 719.1761 258.99 503 20.89 70 335.84 244.95 0.340598
PAGE 296 47 605.7942 291.6 470 23.52 12.17 148.14 112.45 0.185624
PATRICK 432 22 285.8151 276.37 486 11.39 1 223.57 211.18 0.738869
PITTSYLVANIA 4187 64 1073.054 217.54 544 37.07 65.3438 2425.47 2323.056 2.164901
POWHATAN 28 2 50.1273 242.05 520 1.11 3.3 15.5 11.09 0.221237
PRINCE EDWARD 123 60 30.88316 221.93 540 34.5 0 70.73 36.23 1.173131
PRINCE GEORGE 6 6 255.9439 285.09 477 3.05 0 3.05 0 0
PRINCE WILLIAM 685 89 28178.82 206.26 556 52.69 2.632 405.56 350.238 0.012429
PULASKI 241 23 1780.94 229.17 533 13.05 0 136.78 123.73 0.069475
RAPPAHANNOCK 132 56 14.271 246.93 515 30.71 0 72.39 41.68 2.920608
RICHMOND 243 2 113.7787 219.4 543 1.16 0 140.51 139.35 1.224746
ROANOKE 94 53 4487.925 235.72 526 29.69 0 52.65 22.96 0.005116
ROCKBRIDGE 109 46 1052.877 263.87 498 24.39 0 57.8 33.41 0.031732
ROCKINGHAM 4808 241 9031.399 332.69 429 110.1 167.963 2196.42 1918.357 0.21241
RUSSELL 134 28 644.7502 310.95 451 13.45 0 64.35 50.9 0.078945
SCOTT 243 84 397.3463 270.35 492 44.01 0 127.31 83.3 0.209641
SHENANDOAH 755 125 2007.441 278.97 483 64.29 29.928 388.32 294.102 0.146506
SMYTH 188 66 1719.006 233.52 528 37.11 0 105.7 68.59 0.039901
SOUTHAMPTON 3507 90 5903.591 249.88 512 49.07 259.1787 1912.05 1603.801 0.271665
SPOTSYLVANIA 144 79 4155.782 240.3 522 43.91 25.43 80.04 10.7 0.002575
STAFFORD 221 11 4652.618 234.59 527 6.17 0 124.02 117.85 0.02533
SURRY 1028 22 103.262 277.11 485 11.36 39.699 530.92 479.861 4.647024
SUSSEX 1645 0 588.938 252.6 509 0 41.22 891.61 850.39 1.443938
TAZEWELL 330 29 1247.325 249.47 513 15.84 0 180.27 164.43 0.131826
WARREN 58 58 4304.443 212.2 550 33.97 0 33.97 0 0
WASHINGTON 410 123 3408.196 290.22 472 61.82 0 206.07 144.25 0.042324
WESTMORELAND 1673 5 1235.924 175.57 586 3.12 863.926 1043.97 176.924 0.143151
WISE 115 5 1773.069 284.42 478 2.55 0 58.54 55.99 0.031578
WYTHE 164 55 3002.442 209.39 553 32.39 0 96.57 64.18 0.021376
YORK 17 17 32214.19 278.94 483 8.74 0 8.74 0 0
CHESAPEAKE CITY 239 56 4509.785 297.57 464 27.67 1.440575 118.09 88.97943 0.01973
SUFFOLK CITY 616 68 38298.19 314.63 447 32.37 180.6075 293.21 80.2325 0.002095
VIRGINIA BEACH CITY 193 51 13960.18 250.71 511 27.75 0 105.02 77.27 0.005535

Large Farmers Unreported 2012

<style> </style>
County Total.Irri.Area Irr.Area.Under.TH Facility_Total_mg PPT Irrigation SM_F_Unreported Facility_withdrawal_mg All_Irrigation Large_Farm_unreported C_tot_lg
ACCOMACK 5371 54 4613.682 315.02 447 25.7 3414.518 2556.56 -883.658 -0.19153
ALBEMARLE 1456 168 3716.215 292.78 469 83.9 0 727.16 643.26 0.173095
ALLEGHANY 8 8 14351.13 271.22 491 4.18 0 4.18 0 0
AMELIA 374 45 117.781 195.37 567 27.17 85.5 225.81 113.14 0.960596
APPOMATTOX 105 81 42.3 269.17 493 42.52 0 55.12 12.6 0.297872
AUGUSTA 3271 87 4038.266 332.94 429 39.74 424.6243 1494.28 1029.916 0.255039
BATH 19 19 3818.33 287.21 475 9.61 0 9.61 0 0
BEDFORD 93 54 6562.061 223.25 539 30.99 11.55 53.38 10.84 0.001652
BOTETOURT 52 25 621.3561 274.14 488 12.99 0 27.02 14.03 0.02258
BRUNSWICK 1280 40 361.7987 366.46 396 16.87 0 539.76 522.89 1.445251
BUCKINGHAM 16 16 125.099 269.99 492 8.38 0 8.38 0 0
CAMPBELL 290 98 1786.791 256.6 505 52.7 57.88 155.95 45.37 0.025392
CAROLINE 1959 25 2654.551 225.94 536 14.27 792.39 1118.13 311.47 0.117334
CARROLL 1086 19 190.4055 259.57 502 10.16 0 580.53 570.37 2.995554
CHARLES CITY 1435 11 428.0656 300.37 462 5.41 405.611 705.97 294.949 0.689028
CHARLOTTE 759 85 82.747 272.3 490 44.35 15.3 396.03 336.38 4.065162
CHESTERFIELD 64 12 32729.12 240.09 522 6.67 22.9 35.57 6 0.000183
CLARKE 249 28 252.6576 243.06 519 15.47 46.58 137.61 75.56 0.299061
CRAIG 10 10 895.4523 230.71 531 5.65 0 5.65 0 0
CULPEPER 641 64 998.4472 279.19 483 32.92 93.1449 329.68 203.6151 0.203932
CUMBERLAND 18 18 2.3137 255.47 507 9.72 0 9.72 0 0
DICKENSON 12 12 2145.649 308.27 454 5.8 0 5.8 0 0
DINWIDDIE 1162 53 52.41692 251.02 511 28.84 17.00596 632.3 586.454 11.18826
FAIRFAX 50 50 32000.1 182.77 579 30.83 0 30.83 0 0
FAUQUIER 394 207 1089.439 258.57 503 110.87 0 211.04 100.17 0.091946
FLOYD 192 133 34.472 216.51 545 77.19 21.1 111.43 13.14 0.381179
FLUVANNA 144 61 326.771 284.91 477 30.98 0 73.14 42.16 0.12902
FRANKLIN 893 103 450.9327 436.18 326 35.76 0 310 274.24 0.608162
FREDERICK 151 79 1624.9 277.36 485 40.8 0 77.99 37.19 0.022888
GILES 32 32 24019.44 222.16 540 18.4 0 18.4 0 0
GLOUCESTER 46 46 475.7657 286.32 476 23.32 0 23.32 0 0
GOOCHLAND 32 32 801.5221 296.55 465 15.85 0 15.85 0 0
GRAYSON 45 45 36.6599 251.37 511 24.49 0 24.49 0 0
GREENE 49 38 228.9864 330.5 432 17.48 0 22.54 5.06 0.022097
GREENSVILLE 246 9 743.8175 384.09 378 3.62 32.252 99.02 63.148 0.084897
HALIFAX 2152 223 675.589 265.24 497 118.02 2.139 1138.92 1018.761 1.50796
HANOVER 3338 247 1177.759 252.59 509 133.88 560.29 1809.25 1115.08 0.946781
HENRICO 7 7 9648.405 290.28 472 3.52 100.69 3.52 -100.69 -0.01044
HENRY 137 40 1209.686 246.69 515 21.94 0 75.13 53.19 0.04397
HIGHLAND 20 9 2577.252 296.95 465 4.46 0 9.9 5.44 0.002111
ISLE OF WIGHT 702 13 4499.247 399.4 363 5.03 5.75 271.35 260.57 0.057914
JAMES CITY 37 15 2230.916 341.42 421 6.72 0 16.59 9.87 0.004424
KING AND QUEEN 18 18 250.445 236.84 525 10.06 246.17 10.06 -246.17 -0.98293
KING GEORGE 350 34 636.7857 218.14 544 19.7 216.35 202.75 -33.3 -0.05229
KING WILLIAM 1125 16 7903.223 236.94 525 8.94 352.326 628.93 267.664 0.033868
LEE 61 61 800.624 327.51 434 28.19 0 28.19 0 0
LOUDOUN 580 235 2337.318 223.71 538 134.63 0.4321 332.28 197.2179 0.084378
LOUISA 278 88 217.1385 304.24 458 42.92 0 135.58 92.66 0.426732
LUNENBURG 444 33 170.069 319.14 443 15.57 6.76 209.45 187.12 1.100259
MADISON 70 30 49.5564 332.64 429 13.7 0 31.98 18.28 0.368873
MATHEWS 17 17 7.8853 313.66 448 8.11 0 8.11 0 0
MECKLENBURG 2760 66 585.5844 394.32 368 25.86 0 1081.56 1055.7 1.802814
MIDDLESEX 477 18 144.406 285.59 476 9.12 88.8 241.78 143.86 0.996219
MONTGOMERY 349 37 10645.25 217.7 544 21.43 65.645 202.17 115.095 0.010812
NELSON 862 57 1032.9 284.05 478 29.01 424.98 438.76 -15.23 -0.01474
NORTHAMPTON 6335 47 1177.015 319.6 442 22.12 881.646 2981.69 2077.924 1.765419
NORTHUMBERLAND 38 2 135.1638 283.85 478 1.02 0 19.34 18.32 0.135539
NOTTOWAY 75 55 392.96 245.45 517 30.28 0 41.29 11.01 0.028018
ORANGE 563 51 641.9746 312.69 449 24.38 11 269.18 233.8 0.364189
PAGE 1005 19 646.848 286.71 475 9.61 51.94 508.34 446.79 0.690719
PATRICK 108 38 251.0541 304.98 457 18.49 0 52.56 34.07 0.135708
PITTSYLVANIA 3717 184 703.5115 256.64 505 98.95 27.14079 1998.84 1872.749 2.662002
POWHATAN 99 20 40.7775 262.98 499 10.63 4 52.61 37.98 0.931396
PRINCE EDWARD 96 11 380.8697 232.14 530 6.21 0.05148 54.18 47.91852 0.125813
PRINCE GEORGE 8 8 107.5899 282.06 480 4.09 0 4.09 0 0
PRINCE WILLIAM 1006 69 24517.31 219.82 542 39.82 47.42 580.62 493.38 0.020124
PULASKI 14 14 1651.929 226.95 535 7.98 0 7.98 0 0
RAPPAHANNOCK 121 95 13.24 286.53 475 48.05 0 61.2 13.15 0.993202
RICHMOND 126 21 100.346 244.79 517 11.56 0 69.37 57.81 0.576107
ROANOKE 96 53 4364.626 292.6 469 26.47 0 47.94 21.47 0.004919
ROCKBRIDGE 137 59 818.7137 325.1 437 27.46 0 63.75 36.29 0.044326
ROCKINGHAM 5645 350 9269.704 331.01 431 160.63 578.196 2590.81 1851.984 0.199789
RUSSELL 12 12 233.732 334.45 428 5.47 0 5.47 0 0
SCOTT 56 23 377.6281 357.26 405 9.92 0 24.15 14.23 0.037683
SHENANDOAH 719 111 1984.426 315.7 446 52.72 31.96 341.47 256.79 0.129403
SMYTH 18 18 2090.007 270.66 491 9.41 0 9.41 0 0
SOUTHAMPTON 3246 28 1398.276 408.28 354 10.55 159.7402 1223.62 1053.33 0.753306
SPOTSYLVANIA 58 29 3808.417 216.38 546 16.86 10.2 33.72 6.66 0.001749
STAFFORD 25 25 3946.842 218.84 543 14.46 0 14.46 0 0
SURRY 1238 65 78.11996 351.19 411 28.45 22.35 541.82 491.02 6.285462
SUSSEX 1371 25 456.542 311.6 450 11.98 71.71 656.97 573.28 1.2557
TAZEWELL 18 18 613.3172 302.98 459 8.8 0 8.8 0 0
WARREN 12 12 3510.696 262.79 499 6.38 0 6.38 0 0
WASHINGTON 224 89 3633.409 306.03 456 43.22 0 108.77 65.55 0.018041
WESTMORELAND 1642 2 757.3936 234.47 528 1.12 380.14 923.21 541.95 0.715546
WISE 12 12 2587.331 408.33 354 4.52 0 4.52 0 0
WYTHE 72 52 2699.777 253.77 508 28.13 0 38.95 10.82 0.004008
YORK 21 8 8251.782 345.53 416 3.54 0 9.3 5.76 0.000698
CHESAPEAKE CITY 282 68 2422.933 339.65 422 30.56 0 126.72 96.16 0.039687
SUFFOLK CITY 414 62 33496.68 418.81 343 22.65 133.01 151.21 -4.45 -0.00013
VIRGINIA BEACH CITY 180 44 7247.616 314.3 448 20.99 0 85.87 64.88 0.008952

Large Farmers Unreported 2017

<style> </style>
County Total.Irri.Area Irr.Area.Under.TH Facility_Total_mg PPT Irrigation SM_F_Unreported Facility_withdrawal_mg All_Irrigation Large_Farm_unreported C_tot_lg
ACCOMACK 5079 58 3309.035 325.98 436 26.93 1673.848 2358.08 657.3022 0.198639
ALBEMARLE 783 113 4644.929 250.08 512 61.61 0 426.9 365.29 0.078643
AMELIA 205 19 59.99334 297.94 464 9.39 9.343 101.29 82.557 1.376103
AMHERST 176 23 6120.39 264.25 498 12.2 0 93.33 81.13 0.013256
APPOMATTOX 24 24 6.5 262.29 500 12.78 0 12.78 0 0
AUGUSTA 2550 199 3502.974 267.19 495 104.89 175.66 1344.12 1063.57 0.303619
BEDFORD 51 51 6874.716 283.18 479 26.01 16.15 26.01 -16.15 -0.00235
BLAND 801 4 68.0126 256.15 506 2.16 0 431.6 429.44 6.314124
BOTETOURT 10 10 532.3323 242.11 520 5.54 0 5.54 0 0
BRUNSWICK 2115 6 588.3132 333.93 428 2.73 0 963.94 961.21 1.633841
BUCKINGHAM 65 19 121.18 239.07 523 10.58 0 36.2 25.62 0.211421
CAMPBELL 313 40 2235.733 224.4 538 22.92 121.59 179.32 34.81 0.01557
CAROLINE 3411 19 1675.266 337.88 424 8.58 543.92 1540.07 987.57 0.5895
CARROLL 597 16 182.0327 280.39 482 8.21 0 306.42 298.21 1.638222
CHARLES CITY 1376 15 389.4208 339.03 423 6.76 344.0851 619.8 268.9549 0.690654
CHARLOTTE 534 94 97.947 268.04 494 49.45 15.35 280.91 216.11 2.206397
CHESTERFIELD 75 28 36089.35 317.01 445 13.27 0 35.54 22.27 0.000617
CLARKE 143 34 237.3854 270.91 491 17.78 16.56 74.77 40.43 0.170314
CRAIG 115 19 1247.686 243.33 519 10.5 0 63.56 53.06 0.042527
CULPEPER 615 167 1074.751 255.33 507 90.16 81.2651 332.03 160.6049 0.149435
CUMBERLAND 167 23 5.11825 219.8 542 13.27 0 96.38 83.11 16.23797
DINWIDDIE 1578 27 156.4844 323.25 439 12.62 31.129 737.68 693.931 4.434505
ESSEX 3 3 440.2143 304.12 458 1.46 340.34 1.46 -340.34 -0.77312
FAIRFAX 60 60 32642.41 299.07 463 29.58 0 29.58 0 0
FAUQUIER 452 217 1176.654 289.97 472 109.07 0 227.18 118.11 0.100378
FLOYD 182 122 79.81044 240.31 522 67.81 31.672 101.17 1.688 0.02115
FLUVANNA 79 18 311.7914 217.59 544 10.43 0 45.76 35.33 0.113313
FRANKLIN 441 107 448.8089 413.52 348 39.65 0 163.42 123.77 0.275774
FREDERICK 38 15 1937.021 269.65 492 7.86 0 19.91 12.05 0.006221
GILES 27 27 25126.1 294.61 467 13.43 0 13.43 0 0
GLOUCESTER 13 13 486.6015 282.46 480 6.64 0 6.64 0 0
GOOCHLAND 112 20 732.6279 245.12 517 11.01 0 61.66 50.65 0.069135
GRAYSON 160 21 74.95833 287.67 474 10.6 0 80.76 70.16 0.935987
GREENE 24 24 229.4875 314.34 448 11.45 0 11.45 0 0
GREENSVILLE 5 5 729.4155 332.42 430 2.29 48.91836 2.29 -48.9184 -0.06707
HALIFAX 1061 52 730.0528 306.49 456 25.25 0 515.2 489.95 0.671116
HANOVER 3569 179 1365.922 302.35 460 87.68 583.8264 1748.23 1076.724 0.788276
HENRICO 28 28 9402.481 309.16 453 13.51 97.14 13.51 -97.14 -0.01033
HENRY 43 14 1227.356 268.15 494 7.36 0 22.62 15.26 0.012433
ISLE OF WIGHT 934 37 7678.511 395.49 367 14.46 71.1 365.01 279.45 0.036394
JAMES CITY 40 27 3185.089 273.6 488 14.03 0 20.79 6.76 0.002122
KING AND QUEEN 1221 37 423.2449 297.21 465 18.32 418.6888 604.59 167.5812 0.395944
KING WILLIAM 1618 17 7126.215 296.25 466 8.44 285.391 802.89 509.059 0.071435
LANCASTER 12 12 177.5552 342.73 419 5.35 0 5.35 0 0
LEE 32 32 870.482 351.04 411 14.01 0 14.01 0 0
LOUDOUN 392 242 4344.776 293.73 468 120.6 0 195.36 74.76 0.017207
LOUISA 215 90 264.1097 246.28 516 49.45 0 118.14 68.69 0.260081
LUNENBURG 1408 15 189.453 306.44 456 7.28 0 683.69 676.41 3.570331
MADISON 80 67 65.751 296.25 466 33.25 0 39.7 6.45 0.098097
MATHEWS 10 10 4.953694 274.9 487 5.19 0 5.19 0 0
MECKLENBURG 4163 101 717.9267 323.14 439 47.21 0 1946.1 1898.89 2.644964
MIDDLESEX 270 26 92.47545 318.98 443 12.27 22.39 127.37 92.71 1.002536
MONTGOMERY 323 36 9659.75 261.1 501 19.21 42.2739 172.32 110.8361 0.011474
NELSON 1016 66 1035.723 249.6 512 35.98 474.32 553.93 43.63 0.042125
NEW KENT 271 18 6832.186 303.81 458 8.78 24.19 132.17 99.2 0.01452
NORTHAMPTON 5857 8 883.1606 286.89 475 4.05 529.2497 2962.53 2429.23 2.75061
NOTTOWAY 44 44 392.2 271.51 490 22.96 0 22.96 0 0
ORANGE 214 39 638.6902 279.31 483 20.06 0 110.07 90.01 0.140929
PAGE 108 20 658.1734 252.41 510 10.86 25.55 58.65 22.24 0.03379
PATRICK 213 77 232.3817 315.62 446 36.57 0 101.16 64.59 0.277948
PITTSYLVANIA 1492 78 929.0033 314.63 447 37.13 0 710.18 673.05 0.724486
POWHATAN 63 16 69.95639 278.17 484 8.25 4.3 32.47 19.92 0.284749
PRINCE EDWARD 14 14 428.1339 257.96 504 7.51 0 7.51 0 0
PRINCE WILLIAM 943 34 25403.48 298.57 463 16.76 14.541 464.93 433.629 0.01707
PULASKI 28 28 1598.12 232.42 530 15.8 0 15.8 0 0
RAPPAHANNOCK 61 61 12.237 286.95 475 30.85 0 30.85 0 0
RICHMOND 29 16 102.711 293.6 468 7.97 0 14.45 6.48 0.06309
ROANOKE 71 71 4181.906 286.85 475 35.91 0.75 35.91 -0.75 -0.00018
ROCKBRIDGE 83 40 670.4299 263.72 498 21.21 0 44.02 22.81 0.034023
ROCKINGHAM 5526 282 8875.608 275.33 487 146.24 254.245 2865.72 2465.235 0.277754
SCOTT 13 13 415.799 317.51 444 6.15 0 6.15 0 0
SHENANDOAH 893 99 2336.518 260.5 502 52.92 36.38 477.36 388.06 0.166085
SMYTH 28 28 2062.959 317.14 445 13.27 0 13.27 0 0
SOUTHAMPTON 1624 14 2809.936 397.15 365 5.44 138.2595 631.21 487.5105 0.173495
SPOTSYLVANIA 96 27 4081.042 323.44 439 12.62 0.146 44.88 32.114 0.007869
STAFFORD 10 10 4400.723 283.35 479 5.1 0 5.1 0 0
SURRY 929 10 119.0785 337.31 425 4.53 43.719 420.43 372.181 3.125511
SUSSEX 699 15 541.7868 368.46 394 6.29 195.364 293.27 91.616 0.1691
WARREN 10 10 3619.162 242.86 519 5.53 0 5.53 0 0
WASHINGTON 122 51 3971.443 319.35 443 24.06 0 57.55 33.49 0.008433
WESTMORELAND 882 111 436.6395 327.94 434 51.3 321.7426 407.62 34.5774 0.07919
WISE 27 15 2262.56 349.44 413 6.6 0 11.87 5.27 0.002329
WYTHE 18 18 2789.952 244.4 518 9.93 0 9.93 0 0
YORK 11 11 6494.848 300.68 461 5.4 0 5.4 0 0
CHESAPEAKE CITY 72 57 1982.655 416.67 345 20.94 0.896212 26.45 4.61379 0.002327
SUFFOLK CITY 585 60 35939.42 390.7 371 23.7 111.95 231.11 95.46 0.002656
VIRGINIA BEACH CITY 315 65 10503.86 430.3 332 22.98 0 111.36 88.38 0.008414

@laljeet
Copy link
Collaborator

laljeet commented May 27, 2022

2002Large farm unreported DeqIrrigation
2007Large farm unreported DeqIrrigation
2012Large farm unreported DeqIrrigation
2017Large farm unreported DeqIrrigation

@laljeet
Copy link
Collaborator

laljeet commented May 27, 2022

2002Large farm unreported Deq Total
2007Large farm unreported Deq Total
2012Large farm unreported Deq Total
2017Large farm unreported Deq Total

Map_of_Virginia_Counties_and_Independent_Cities svg

@laljeet
Copy link
Collaborator

laljeet commented May 27, 2022

MK Trend

Irrigation Coefficient

<style> </style>
County c2002 c2007 c2012 c2017 Tau_MK p_MK Monotonic
CAROLINE 0.39003 1.159397 0.393077 1.815653 0.667 0.308 N
AUGUSTA 3.317371 2.240058 2.425475 6.054708 0.333 0.734 N
ISLE OF WIGHT 3.429538 1.888211 45.31652 3.93038 0.333 0.734 N
SPOTSYLVANIA 2.083058 0.420763 0.652941 219.9589 0.333 0.734 N
CLARKE 1.921729 5.262727 1.622155 2.441425 0 1 N
NELSON 1.021027 -0.24594 -0.03584 0.091984 0 1 N
ROCKINGHAM 7.8595 11.42131 3.203038 9.696297 0 1 N
KING AND QUEEN 0.626718 -1 -1 0.400252 -0.183 1 N
ACCOMACK 0.63713 0.963198 -0.25879 0.392689 -0.333 0.734 N
AMELIA 10.36127 17.36107 1.323275 8.836241 -0.333 0.734 N
CHARLES CITY 1.613913 28.4042 0.727172 0.781652 -0.333 0.734 N
CULPEPER 66.74209 0.706608 2.186004 1.976308 -0.333 0.734 N
DINWIDDIE 39.05621 9.075358 34.48521 22.29211 -0.333 0.734 N
KING WILLIAM 9.636402 1.095279 0.759706 1.783725 -0.333 0.734 N
MIDDLESEX 26.45075 1.793345 1.620045 4.140688 -0.333 0.734 N
PAGE 2.666899 9.239934 8.602041 0.87045 -0.333 0.734 N
POWHATAN 211.2931 3.360606 9.495 4.632558 -0.333 0.734 N
SHENANDOAH 18.79324 9.826985 8.034731 10.66685 -0.333 0.734 N
SUFFOLK CITY 1.694498 0.444237 -0.03346 0.852702 -0.333 0.734 N
SURRY 14.06569 12.08748 21.96957 8.513026 -0.333 0.734 N
HANOVER 4.63895 4.834123 1.990184 1.844253 -0.667 0.308 N
MONTGOMERY 8.387647 3.42544 1.753294 2.621857 -0.667 0.308 N
NORTHAMPTON 6.441769 4.681868 2.356869 4.589951 -0.667 0.308 N
PRINCE WILLIAM 206.9853 133.0691 10.40447 29.82113 -0.667 0.308 N
SOUTHAMPTON 27.86585 6.188014 6.594018 3.526054 -0.667 0.308 N
SUSSEX 16.88238 20.63052 7.994422 0.46895 -0.667 0.308 N
WESTMORELAND 1.459752 0.204791 1.425659 0.107469 -0.667 0.308 N

Total Withdrawal Coefficient

<style> </style>
County c2002 c2007 c2012 c2017 Tau_MK p_MK Monotonic
GLOUCESTER 0.063307 0 0 0 -0.707 0.371 Y
WARREN 0.012221 0 0 0 -0.707 0.371 Y
GILES 0.0036 0.000421 0 0 -0.913 0.149 Y
LEE 1.105286 0.187326 0 0 -0.913 0.149 Y
MATHEWS 59.14645 3.092024 0 0 -0.913 0.149 Y
PULASKI 0.105294 0.069475 0 0 -0.913 0.149 Y
SMYTH 0.078539 0.039901 0 0 -0.913 0.149 Y
STAFFORD 0.027957 0.02533 0 0 -0.913 0.149 Y
BEDFORD 0.058965 0.043524 0.001652 -0.00235 -1 0.089 Y
BOTETOURT 0.035014 0.032106 0.02258 0 -1 0.089 Y
CAMPBELL 0.3052 0.1398 0.025392 0.01557 -1 0.089 Y
CULPEPER 0.45864 0.231111 0.203932 0.149435 -1 0.089 Y
FRANKLIN 1.081824 0.809825 0.608162 0.275774 -1 0.089 Y
FREDERICK 0.272998 0.046318 0.022888 0.006221 -1 0.089 Y
LOUDOUN 0.934357 0.817773 0.084378 0.017207 -1 0.089 Y
LOUISA 0.829474 0.590332 0.426732 0.260081 -1 0.089 Y
NOTTOWAY 1.155917 0.421113 0.028018 0 -1 0.089 Y
RAPPAHANNOCK 12.79775 2.920608 0.993202 0 -1 0.089 Y
SCOTT 0.614965 0.209641 0.037683 0 -1 0.089 Y
SUSSEX 1.640104 1.443938 1.2557 0.1691 -1 0.089 Y
WASHINGTON 0.091534 0.042324 0.018041 0.008433 -1 0.089 Y
WYTHE 0.351336 0.021376 0.004008 0 -1 0.089 Y
BRUNSWICK 0.943542 0.827691 1.445251 1.633841 0.667 0.308 N
FAIRFAX -0.00046 -0.00051 0 0 0.548 0.47 N
CAROLINE 0.140963 0.261565 0.117334 0.5895 0.333 0.734 N
ISLE OF WIGHT 0.01971 0.015114 0.057914 0.036394 0.333 0.734 N
YORK 0 0 0.000698 0 0.236 1 N
GOOCHLAND 0.06869 0 0 0.069135 0.183 1 N
DINWIDDIE 5.348211 5.648922 11.18826 4.434505 0 1 N
FLUVANNA 0.071227 0.342127 0.12902 0.113313 0 1 N
HANOVER 0.185144 1.282914 0.946781 0.788276 0 1 N
KING AND QUEEN 0.615693 -0.98357 -0.98293 0.395944 0 1 N
LUNENBURG 3.119339 1.972729 1.100259 3.570331 0 1 N
MECKLENBURG 1.902465 2.691953 1.802814 2.644964 0 1 N
NELSON 0.330684 -0.10867 -0.01474 0.042125 0 1 N
PAGE 0.104918 0.185624 0.690719 0.03379 0 1 N
PITTSYLVANIA 1.627433 2.164901 2.662002 0.724486 0 1 N
ROANOKE -0.00206 0.005116 0.004919 -0.00018 0 1 N
ROCKINGHAM 0.247743 0.21241 0.199789 0.277754 0 1 N
SOUTHAMPTON 0.188272 0.271665 0.753306 0.173495 0 1 N
CRAIG 0.062983 0 0 0.042527 -0.183 1 N
GREENE 0 0.215914 0.022097 0 -0.183 1 N
ACCOMACK 0.407198 0.515684 -0.19153 0.198639 -0.333 0.734 N
AMELIA 10.36127 17.36107 0.960596 1.376103 -0.333 0.734 N
BUCKINGHAM 0.608338 0.041977 0 0.211421 -0.333 0.734 N
CARROLL 2.198263 1.876908 2.995554 1.638222 -0.333 0.734 N
CHARLES CITY 1.489066 7.476422 0.689028 0.690654 -0.333 0.734 N
CHESAPEAKE CITY 0.039175 0.01973 0.039687 0.002327 -0.333 0.734 N
FLOYD 5.831828 0 0.381179 0.02115 -0.333 0.734 N
GRAYSON 4.061241 0.638511 0 0.935987 -0.333 0.734 N
JAMES CITY 0.010312 0.001144 0.004424 0.002122 -0.333 0.734 N
MONTGOMERY 0.016983 0.018348 0.010812 0.011474 -0.333 0.734 N
PATRICK 0.447827 0.738869 0.135708 0.277948 -0.333 0.734 N
POWHATAN 3.753722 0.221237 0.931396 0.284749 -0.333 0.734 N
PRINCE WILLIAM 0.03259 0.012429 0.020124 0.01707 -0.333 0.734 N
ROCKBRIDGE 0.298767 0.031732 0.044326 0.034023 -0.333 0.734 N
SHENANDOAH 0.289188 0.146506 0.129403 0.166085 -0.333 0.734 N
SPOTSYLVANIA 0.033825 0.002575 0.001749 0.007869 -0.333 0.734 N
SUFFOLK CITY 0.009933 0.002095 -0.00013 0.002656 -0.333 0.734 N
SURRY 5.49031 4.647024 6.285462 3.125511 -0.333 0.734 N
VIRGINIA BEACH CITY 0.0214 0.005535 0.008952 0.008414 -0.333 0.734 N
WESTMORELAND 0.684824 0.143151 0.715546 0.07919 -0.333 0.734 N
WISE 0.003697 0.031578 0 0.002329 -0.333 0.734 N
APPOMATTOX 3.346086 0 0.297872 0 -0.548 0.47 N
HENRICO 0 0 -0.01044 -0.01033 -0.548 0.47 N
ALBEMARLE 0.176751 0.115741 0.173095 0.078643 -0.667 0.308 N
AUGUSTA 0.352717 0.322364 0.255039 0.303619 -0.667 0.308 N
CHARLOTTE 5.616715 2.621847 4.065162 2.206397 -0.667 0.308 N
CHESTERFIELD 0.008683 0.001113 0.000183 0.000617 -0.667 0.308 N
CLARKE 0.317107 0.895296 0.299061 0.170314 -0.667 0.308 N
FAUQUIER 0.424963 0.358715 0.091946 0.100378 -0.667 0.308 N
HALIFAX 1.740947 1.176221 1.50796 0.671116 -0.667 0.308 N
HENRY 0.117656 0.259521 0.04397 0.012433 -0.667 0.308 N
KING WILLIAM 0.18404 0.107414 0.033868 0.071435 -0.667 0.308 N
MADISON 3.514594 0.143158 0.368873 0.098097 -0.667 0.308 N
MIDDLESEX 3.021654 1.013846 0.996219 1.002536 -0.667 0.308 N
NORTHAMPTON 4.79431 3.588351 1.765419 2.75061 -0.667 0.308 N
ORANGE 1.47253 0.340598 0.364189 0.140929 -0.667 0.308 N
PRINCE EDWARD 0.617155 1.173131 0.125813 0 -0.667 0.308 N

@rburghol
Copy link
Contributor

When to use/prefer methods:

  • small farms:
    • if VWUDS data is complete (high % of eligible reporters reporting), and small farm area varies with large farm area, small farm irrigation coefficient is robust method.
    • if not, need ag census area.
  • how would def vs coeff compare if we use median instead of mean?

@rburghol
Copy link
Contributor

rburghol commented May 27, 2022

Bar Chart of Total State Irrigation by Year:

  • Crop Deficit Method w/Max Acreage
  • Crop Deficit Method w/Median Acreage
  • DEQ Reported
  • Irrigation Survey reported

@laljeet
Copy link
Collaborator

laljeet commented Jun 2, 2022

State_Summary_Large Farm max mean
State_Summary_Large Farm Median

@laljeet
Copy link
Collaborator

laljeet commented Jun 2, 2022

State_Summary_MeanCoeff_MaxUnderTh
State_Summary_MedianCoeff_MedianUnderTh

@laljeet
Copy link
Collaborator

laljeet commented Jun 2, 2022

  • Median coefficient results in higher unreported withdrawals in some counties where median = mean
    This bumps up the state's yearly unreported withdrawals

Proposed Method for limits on counties with large unreported withdrawals

  • Get the max irrigation demand for each year
  • Unreported withdrawals based on the coefficient method can't exceed the max irrigation demand.
    State_Summary_Large Farm Median Coeff limit

@laljeet
Copy link
Collaborator

laljeet commented Jun 3, 2022

Barplot

@laljeet
Copy link
Collaborator

laljeet commented Jun 6, 2022

@rburghol @julieshortridge @jdkleiner

Months: June to August

Effective Rainfall: Rainfall over 1.5 inches in 2 consecutive days is considered runoff

<style> </style>
  2003 2008 2013 2018
Rainfall (inches) 17 11.3 16.6 18.6
Effective Rainfall (inches) 16.3 10 11.3 15.4
Irrigation applied (Survey) (inches) 4.8 7.2 6 3.6
Sum (effective rain + irr) 21.1 17.2 17.3 19

PPT6_8

Months April to October (Previously in Presentation)

<style> </style>
  2003 2008 2013 2018
Rainfall (inches) 39.7 27.6 29 43.9
Effective Rainfall (inches) 34.9 23.8 25.7 34.2
Irrigation applied (Survey) (inches) 4.8 7.2 6 3.6
Sum (effective rain + irr) 39.7 31 31.7 37.8

PPT4_10

@julieshortridge
Copy link
Author

Thanks Lal! This is interesting to see, and I think would put us in a much more reasonable ballpark of water demand. For instance, assuming June-August is 14 weeks, with a water demand of 1" per week for the first and last four weeks, and 1.5" per week for the middle six weeks, that would be a total water demand of 17".

I'd be inclined to set crop water demand over that period to 20" as an initial test and see how our numbers compare. If we were using 30" before and an average effective rainfall of ~12", we're assuming ~18" of water put on. Now we'd be down to something like 8" of water put on, so I suspect our volume estimates would be around 8/18 = 44% of what they were.

@rburghol what do you think?

@rburghol
Copy link
Contributor

rburghol commented Jun 6, 2022

@julieshortridge I think that makes lot of sense, both the final totals, and your idea to do more need in the middle weeks. Thanks to both of you!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants