<URL:http://water.usgs.gov/nawqa-only/gw.html>
This data set consists of 1995 irrigation water use information for NAWQA ground water study areas (Land Use Studies and Subunit Surveys). The water use data was supplied by Molly Maupin.
This is one of the ancillary GIS data layers developed to characterize NAWQA ground water studies for national synthesis of water-quality data.
The water use input data set did include Alaska and Hawaii, but we do not have NLCDE for those areas (so no weighting factors are available).
<URL:http://water.usgs.gov/watuse/pdf1995/html/>
Ground water study boundaries are gridded at 30 meters and snapped to the NLCDE. Data processing occurs at 30 meters resolution.
The sum of each irrigation water use variable was determined for the study area by running the GRID command, "zonalstats" with the sum option.
Processing routines are from the NAWQA area characterization toolbox.
The basic procedure is to calculate a sum of each water use variable in the ground water study.
The sum of each irrigation water use variable in the ground water study is calculated by multiplying the total for the irrigation water use variable in a county by the fraction of all agricultural land in that county in the ground water study and summing the values for each county in the ground water study.
Here are the weighting factors for pasture/hay and row crops for the ground water study around nvbrlusag2_trg, which contains one county:
GWBNDC1_FIPSLU.AWT FIPS NLCDE AREAKM2 ALLAG6 ALLAG6_KM2 32001 81 77.81040000 0.42003190 185.24880000ALLAG6 is the fraction of the total ag land in the county that is in the ground water study.
(ALLAG6 = AREAKM2 / ALLAG6_KM2)The irrigation water use data for county 32001 are:
IRRWU.DAT Water use variable Value WGWFR 13.400 mgd WGWTO 13.400 mgd WSWFR 120.700 mgd WSWSA 0.000 mgd WSWTO 120.700 mgd WFRTO 134.100 mgd WSATO 0.000 mgd WTOTL 134.100 mgd CUSFR 91.400 mgd CUSSA 0.000 mgd CUTOT 91.400 mgd CLOSS 38.400 mgd IRSPR 7.500 thousand acres IRSPRKM2 30.351 sq km IRMIC 0.000 thousand acres IRMICKM2 0.000 sq km IRSUR 37.100 thousand acres IRSURKM2 150.138 sq km IRTOT 44.600 thousand acres IRTOTKM2 180.490 sq km IRRECWW 0.010 mgdAccording to the water use table, county 32001 has a total of 180.49 km2 of IRTOTKM2 (total irrigated area).
The total irrigated area in the ground water study is calculated as fraction of total agland in the county in the ground water study * total irrigated area in the whole county (applies only to agland categories in ground water study):
ALLAG6 * IRTOTKM2 for NLCDE 81 = 0.42003190 * 180.490 = 75.81 km2 of irrigated area in ground water studyA limitation of this procedure may occur when the amount of irrigated land from the water use data base differs from the amount of county ag land from NLCDE. If irrigated area from the water use data base is more than NLCDE ag land, sometimes calculated irrigated area in a ground water study is more than the total NLCDE ag land calculated in the ground water study.
For example, calculated total irrigated area exceeds the total agricultural land area for ground water study rioglusag1_trg:
TOTAL AREA OF CALCULATED AGRICULTURAL LAND IN IRRIGATED AREA IN rioglusag1_trg rioglusag1_trg 52.270199 61.063County/NLCDE weighting factors for the ground water study are:
County NLCDE AREAKM2 ALLAG6 ALLAG6_KM2
35013 11 1.80900000 0.00000000 0.00000000
35013 21 0.07020000 0.00000000 0.00000000
35013 23 0.79740000 0.00000000 0.00000000
35013 31 0.25920000 0.00000000 0.00000000
35013 41 0.01890000 0.00000000 0.00000000
35013 51 20.09880000 0.00000000 0.00000000
35013 61 1.59750000 0.00593691 269.07930000 **
35013 62 1.12230000 0.00417089 269.07930000
35013 71 21.70620000 0.00000000 0.00000000
35013 81 8.39160000 0.03118634 269.07930000
35013 82 29.89440000 0.11109880 269.07930000
35013 84 0.03060000 0.00011372 269.07930000
35013 85 0.03060000 0.00000000 0.00000000
35051 11 0.55350000 0.00000000 0.00000000
35051 21 0.00270000 0.00000000 0.00000000
35051 23 0.16650000 0.00000000 0.00000000
35051 31 0.01260000 0.00000000 0.00000000
35051 41 0.00360000 0.00000000 0.00000000
35051 51 8.53020000 0.00000000 0.00000000
35051 62 0.33570000 0.01343031 24.99570000 ***
35051 71 8.39970000 0.00000000 0.00000000
35051 81 1.84410000 0.07377668 24.99570000
35051 82 8.98020000 0.35926980 24.99570000
35051 84 0.07380000 0.00295251 24.99570000
35051 85 0.00450000 0.00000000 0.00000000
__________
114.7 km2 total area of
ground water study
The total irrigated area calculated for counties 35013 and 35051 show:
FIPS IRTOTKM2 km2
35013 292.345 ** --- 292 km2 of irrigated area exceeds
269 km2 of NLCDE ag land in
gw study area from county 35013
35051 36.665 *** --- 37 km2 of irrigated area exceeds
25 km2 of NLCDE ag land in
gw study area from county 35051
The irrigated area in the ground water study is calculated as
the sum of ALLAG6 * IRTOTKM2 for each ag land class in each
county:
FIPS NLCDE AREAKM2 ALLAG6 * IRTOTKM2
35013 61 1.5975 0.00593691 292.3 = 1.733
35013 62 1.1223 0.00417089 292.3 = 1.219
35013 81 8.3916 0.03118634 292.3 = 9.114
35013 82 29.8944 0.11109880 292.3 = 32.445
35013 84 0.0306 0.00011372 292.3 = .0330
35051 62 0.3357 0.01343031 36.7 = .4929
35051 81 1.8441 0.07377668 36.7 = 2.7074
35051 82 8.9802 0.35926980 36.7 = 13.1852
35051 84 0.0738 0.00295251 36.7 = .1083
________ ______________
52.3 km2 61.03 km2 of irrigated area in gw study
of ag land (but NLCDE shows only 52.3 km2 of
in gw study ag land in the ground water study)
The irrigated area estimated from water use data was not
compared to irrigation practices derived from NRI.
Data users must adjust accordingly for possible discrepancies in the various data sets.
Processing routines are from the NAWQA area characterization toolbox. (Example below.)
&r weightstats gwbndc1_fipslu.awt d:/ancill/watuse/wu95/irrwu.dat gwbndc1_irrwu95.dat sum areaid allag6 countyg fipsb ~ WGWFR WGWTO WSWFR WSWSA WSWTO WFRTO WSATO WTOTL ~ CUSFR CUSSA CUTOT CLOSS IRSPRKM2 IRMICKM2 IRSURKM2 IRTOTKM2 IRRECWW
with doughnuts without doughnuts cut out (correct) not cut out (incorrect) AREAID GRID AREA (M2) GRID AREA (M2) cnbrluscr1_bnd 7,044,202,800.000 7,392,941,100.000 cnbrluscr1_trg 5,706,866,700.000 6,766,256,700.000 connlusrc1_bnd 1,756,677,600.000 2,064,634,200.000 connlusrc1_trg 587,594,700.000 610,191,000.000 connsus2_bnd 6,848,918,100.000 7,617,282,300.000 nvbrlusrc1_trg 155,431,800.000 155,443,500.000 spltluscr2_trg 207,267,300.000 228,433,500.000
Also added studies that are resampled studies, but do not have the same boundaries in cycle 2 as were used in cycle 1:
albelusag1, nvbrsus2, trinsus3, sanjluscr1a, sanjlusor2a.
Also added willlusag3, which has the same boundaries as cycle 1 willlusag2.
The data set is organized by SUCODE and AREAID. The data represent the sum of the water use feature for the study area.
The fields for 1995 irrigation water use characteristics are:
SUID NAWQA study unit SUCODE NAWQA study unit/network code AREAID Ground water boundary coverage WGWFR Withdrawals, total fresh ground water (Mgal/day) WGWTO Withdrawals, total ground water (Mgal/day) WSWFR Withdrawals, total fresh surface water (Mgal/day) WSWSA Withdrawals, total saline surface water (Mgal/day) WSWTO Withdrawals, total surface water (Mgal/day) WFRTO Withdrawals, total fresh (Mgal/day)h WSATO Withdrawals, total saline (Mgal/day) WTOTL Withdrawals, total (Mgal/day) CUSFR Consumptive Use, fresh (Mgal/day) CUSSA Consumptive Use, saline (Mgal/day) CUTOT Consumptive Use Total (Mgal/day) CLOSS Conveyance Losses (Mgal/day) IRSPRKM2 Irrigated area, sprinkler systems (KM2) IRMICKM2 Irrigated area, micro-irrigation systems (KM2) IRSURKM2 Irrigated area, surface (flood) systems (KM2) IRTOTKM2 Irrigated area, total (KM2) IRRECWW Reclaimed wastewater (Mgal/day)
kjhitt@usgs.gov
kjhitt@usgs.gov