The basic procedure was to create a 500-m radius circular
buffer around each NAWQA sampling site, then calculate a
weighted average for the buffer for nitrogen from fertilizer
and manure. Data processing occurs at 30 meters resolution.
The grid representing the 500-m buffer around the site was
created using GRID SELECTCIRCLE. The location of each site in
NAWQAPT (xcoord and ycoord) forms the center of the buffer.
The average nitrogen input was determined for each ground
water buffer by overlaying the buffer with counties and NLCDe 92
land use to create a set of county/land use weighting factors.
The weighting factors show which counties and NLCDe 92 categories
comprise the buffer and what fraction of the buffer each
county/land use combination covers. The weighting factors are
used to compute weighted averages for the nitrogen from
fertilizer and manure. This avoids doing multiple overlays of
the buffer, counties, and land use.
Here is an example of the county/land use weight table for
STAID 293615098262301 showing the confined and unconfined
manure weighting factors.
Confined animal manure is applied to NLCDe 92 classes 81, 82, 83, 84.
Unconfined animal manure is applied to NLCDe 92 classes 71,
81, 82, 83, 84.
GWBUF_FIPSLU.AWT
FIPS NLCDE AREAKM2 AREAF COUNTY_KM2 COUNTY_F MANURE_CONF MANURE_CONF_KM2 MANURE_UCONF MANURE_UCONF_KM2
48029 11 0.00450000 0.00573395 3254.9 0.00000138 0.00000000 0.00000000 0.00000000 0.00000000
48029 22 0.06750000 0.08600917 3254.9 0.00002074 0.00000000 0.00000000 0.00000000 0.00000000
48029 23 0.07110000 0.09059633 3254.9 0.00002184 0.00000000 0.00000000 0.00000000 0.00000000
48029 31 0.00450000 0.00573395 3254.9 0.00000138 0.00000000 0.00000000 0.00000000 0.00000000
48029 41 0.17550000 0.22362390 3254.9 0.00005392 0.00000000 0.00000000 0.00000000 0.00000000
48029 42 0.35550000 0.45298170 3254.9 0.00010922 0.00000000 0.00000000 0.00000000 0.00000000
48029 51 0.01080000 0.01376147 3254.9 0.00000332 0.00000000 0.00000000 0.00000000 0.00000000
48029 71 0.05130000 0.06536698 3254.9 0.00001576 0.00000000 0.00000000 0.00004887 1049.76800000
48029 81 0.02340000 0.02981651 3254.9 0.00000719 0.00002822 829.24290000 0.00002229 1049.76800000
48029 83 0.02070000 0.02637615 3254.9 0.00000636 0.00002496 829.24290000 0.00001972 1049.76800000
FIPS is the county code. One county occurs in this particular buffer
NLCDE is the NLCDe 92 land use code.
AREAKM2 is the square kilometers of each county/land use combination in the
buffer (Total AREAKM2 for a buffer should be about .785714).
AREAF is the fraction of the buffer represented by each
county/land use combination. (AREAF = AREAKM2/total AREAKM2 for buffer)
COUNTY_KM2 is the total square kilometers of a county.
COUNTY_F is the fraction of the county represented by each county/land use
combination. (COUNTY_F = AREAKM2/COUNTY_KM2)
MANURE_CONF_KM2 is the total square kilometers of [pasture/hay +
row crops + small grains + fallow] in the county.
MANURE_CONF is the fraction of the county [pasture/hay +
row crops + small grains + fallow] represented by county [pasture/hay +
row crops + small grains + fallow] in the GW buffer.
(MANURE_CONF = AREA_KM2/MANURE_CONF_KM2).
Applies only to land use categories 81, 82, 83, 84.
MANURE_UCONF_KM2 is the total square kilometers of [grasslands + pasture/hay +
row crops + small grains + fallow] in the county.
MANURE_UCONF is the fraction of the county [grasslands + pasture/hay +
row crops + small grains + fallow] represented by county [grasslands + pasture/hay +
row crops + small grains + fallow] in the GW buffer.
(MANURE_UCONF = AREA_KM2/MANURE_UCONF_KM2).
Applies only to land use categories 71, 81, 82, 83, 84.
The manure nutrients data compiled for county 48029 are:
MAN82-97.DAT
NMAN92CONF = 242124 kg
NMAN92UCONF = 2504611 kg
NMAN97CONF = 220371 kg
NMAN97UCONF = 2533640 kg
To obtain 1992 nitrogen from manure from confined animals for
the buffer, multiply the total confined manure for the county
by each confined land use fraction in the well buffer:
CONF N fraction CONF N fraction
for of for of
county NLCDE 81 county NLCDE 82
in buffer in buffer
NMAN92CONF = (242124 * .00002822) + (242124 * .00002496) = 13 kg
To obtain 1992 nitrogen from manure from unconfined animals
for the buffer, multiply the total unconfined manure for the
county by each unconfined land use fraction in the well
buffer:
UCONF N fraction UCONF N fraction UCONF N fraction
for of for of for of
county NLCDE 71 county NLCDE 81 county NLCDE 82
in buffer in buffer in buffer
NMAN92UCONF = (2504611 * .00004887) + (2504611 * .00002229) + (2504611 * .00001972) = 228 kg
Here is an example of the county/land use weight table for
STAID 293252098380801 showing the farm and non-farm fertilizer
weighting factors.
Farm fertilizer is applied to NLCDe 92 classes 61, 62, 81, 82, 83, 84 (ALLAG6).
Non-farm fertilizer is applied to NLCDe 92 classes 21, 25, 26, 85.
GWBUF_FIPSLU.AWT
FIPS NLCDE AREAKM2 ALLAG6_KM2 ALLAG6 NONF_KM2 NONF
48029 11 0.00090000 0.00000000 0.00000000 0.00000000 0.00000000
48029 21 0.19890000 0.00000000 0.00000000 333.67320000 0.00059609
48029 22 0.04230000 0.00000000 0.00000000 0.00000000 0.00000000
48029 23 0.12600000 0.00000000 0.00000000 0.00000000 0.00000000
48029 41 0.09000000 0.00000000 0.00000000 0.00000000 0.00000000
48029 42 0.25560000 0.00000000 0.00000000 0.00000000 0.00000000
48029 51 0.03510000 0.00000000 0.00000000 0.00000000 0.00000000
48029 71 0.00720000 0.00000000 0.00000000 0.00000000 0.00000000
48029 81 0.00090000 829.81080000 0.00000108 0.00000000 0.00000000
48029 83 0.01620000 829.81080000 0.00001952 0.00000000 0.00000000
48029 85 0.00990000 0.00000000 0.00000000 333.67320000 0.00002967
ALLAG6_KM2 is the total square kilometers of [orchards vineyards +
revised orchard vineyards + row crops + small grains + pasture/hay + fallow]
in the county.
ALLAG6 is the fraction of the county [orchards vineyards +
revised orchard vineyards + row crops + small grains + pasture/hay + fallow]
represented by county [orchards vineyards + revised orchard vineyards +
row crops + small grains + pasture/hay + fallow] in the GW buffer.
(ALLAG6 = AREA_KM2/ALLAG6_KM2).
Applies only to land use categories 61, 62, 81, 82, 83, 84.
NONF_KM2 is the total square kilometers of [low-intensity residential +
residential without trees + residential with trees + urban grasses] in the county.
NONF is the fraction of the county [low-intensity residential +
residential without trees + residential with trees + urban grasses]
represented by county [low-intensity residential +
residential without trees + residential with trees + urban grasses]
in the GW buffer.
(NONF = AREA_KM2/NONF_KM2).
Applies only to land use categories 21, 25, 26, 85.
The fertilizer nutrients compiled for county 48029 are:
ALLN87-01.DAT
FARMN1992 = 3029739 kg
NONFN1992 = 1810226 kg
To obtain 1992 nitrogen from farm fertilizer for the buffer,
multiply the total farm fertilizer for the county by each farm
fertilizer land use fraction in the well buffer:
FARM N fraction FARM N fraction
for of for of
county NLCDE 81 county NLCDE 83
in buffer in buffer
FARMN92 = (3029739 * 0.00000108) + (3029739 * 0.00001952) = 62 kg
To obtain 1992 nitrogen from nonfarm fertilizer for the
buffer, multiply the total non-farm fertilizer for the county
by each non-farm fertilizer land use fraction in the well
buffer:
NON-FARM N fraction NON-FARM N fraction
for of for of
county NLCDE 21 county NLCDE 85
in buffer in buffer
NONFN92 = (1810226 * 0.00059609) + (1810226 * 0.00002967) = 1133 kg
Processing routines are from the NAWQA area characterization
toolbox. (weightstats sum)