<URL:http://water.usgs.gov/nawqa-only/gw.html>
This data set consists of nitrogen inputs from fertilizer, manure, and atmospheric deposition calculated for 500-m buffers around CYCLE 1 GROUND WATER SAMPLING SITES. For national synthesis, several years of N data bracketing the sampling period are averaged to arrive at one number to represent N loads for each site for all the years during cycle 1. Not all of the NAWQA sampling sites are included in the data set; only the sites in ground water networks requested by Tom Nolan were processed.
This is one of the ancillary GIS data layers developed to characterize NAWQA ground water studies for national synthesis of water-quality data.
The input data set did not include Alaska and Hawaii.
The fertilizer input data set was compiled for 1987 to 2001. During this period, two states--Colorado and Washington--changed the way they reported fertilizer types sold. This change in reporting affected the estimation of nonfarm fertilizer use because fewer categories of fertilizer were reported. For certain years (1997-2001 for WA and 1996-2001 for CO), the estimated nonfarm fertilizer is low. Users should account for this discrepancy when using this data. The farm fertilizer estimates did not show this discrepancy.
Nutrients National Synthesis is averaging 10 years of nonfarm fertilizer data (1992-2001) for GW sites in CO and WA in study units sampled during 1996-98 (FY 1994 studies UCOL and PUGT) and during 1999-2001 (HPGW) to come up with one number to represent N loads for each site for cycle 1 of NAWQA. Study units sampled in those states during other years (FY 1991 studies SPLT and CCPT sampled 1993-95) would not be affected because the sampling occurred before the years when the fertilizer data was changed. For GW sites other than those in UCOL, PUGT, and HPGW, Nutrients Synthesis is averaging several years of data spanning the years of sampling to come up with one number to represent N loads for each site for cycle 1 of NAWQA, as described below.
For fertilizer, Nutrients National Synthesis is representing N load per well buffer as:
FY 91 studies - average of 92, 93, 94, 95 fertilizer values for the buffer FY 94 studies - average of 95, 96, 97, 98 except for well networks in PUGT and UCOL * FY 97 studies - average of 98, 99, 00, 01 except for wells in HPGW in Colorado * *for non-farm fertilizer, all PUGT and UCOL well buffers and HPGW well buffers in Colorado will get the average of all 10 years of non-farm fertilizerHere is an example of how we would calculate N input for farm fertilizer for a well in a FY 94 study:
FARMN92 = 18,087 FARMN93 = 17,342 FARMN94 = 16,128 FARMN95 = 15,278 * FARMN96 = 15,153 * FARMN97 = 14,697 * FARMN98 = 14,081 * FARMN99 = 15,974 FARMN00 = 16,948 FARMN01 = 14,972 FARMNAVG = FARMN95 + FARMN96 + FARMN97 + FARMN98 / 4For manure, Nutrients National Synthesis is representing N load per well buffer as:
FY 91 studies - average of 92 and 97 manure values for the buffer FY 94 studies - 97 manure values FY 97 studies - 97 manure valuesFor atmospheric deposition, Nutrients National Synthesis is representing N deposition per well buffer as:
FY 91 studies - average of 92, 93, 94, 95 atmospheric
deposition values for the buffer
FY 94 studies - average of 95, 96, 97, 98
FY 97 studies - average of 98, 99, 00, 01
On 12/15/05, Tom Nolan supplied a list of 5188 sites, sucodes,
and year of study (1991, 1994, or 1997) for cycle 1 nutrients
analysis, and all of the sites were in NAWQAPT.
<URL:http://water.usgs.gov/nawqa-only/gw.html>Nitrogen input from fertilizer (1987-2001) and manure (1982, 1987, 1992 and 1997) calculated for each well buffer based on NLCDE land use within the buffer - a value for each year (fertilizer 1987, 1988, 1989, 1990, 1991, 1992, 1993, 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001; manure 1982, 1987, 1992,1997).
<URL:http://water.usgs.gov/nawqa-only/gw.html>Nitrogen input from atmospheric deposition (1985-2001) calculated for each well buffer - a value for each year (1985, 1986, 1987, 1988, 1989, 1990, 1991, 1992, 1993, 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001).
Calculate the N input values for cycle 1 wells by averaging data for the years bracketing the sampling period to come up with one number per well buffer to represent each type of N input.
-------------------------------------------------------------------------------------------
FARM FERTILIZER (NLCDE 61,62,82,83)
WELL YEAR FARM FERTILIZER N INPUT CALCULATED AS
--------- --------------------------------------------------------------
91 wells average of 92 93 94 95 farm fertilizer inputs
94 wells average of 95 96 97 98 farm fertilizer inputs
97 wells average of 98 99 00 01 farm fertilizer inputs
NON-FARM FERTILIZER (NLCDE 21,25,26,85)
WELL YEAR NON-FARM FERTILIZER N INPUT CALCULATED AS
--------- --------------------------------------------------------------
91 wells average of 92 93 94 95 non-farm fertilizer inputs
94 wells average of 95 96 97 98 non-farm fertilizer inputs - except for PUGT, UCOL*
97 wells average of 98 99 00 01 non-farm fertilizer inputs - except for HPGW wells in CO*
The exceptions for NON-FARM FERTILIZER are wells that are in
Washington or Colorado, sampled after 1995.
WELL NON-FARM FERTILIZER N INPUT CALCULATED AS
---------------- -----------------------------------------------------------------
PUGT (WA) average of 92 93 94 95 96 97 98 99 00 01 non-farm fertilizer inputs
UCOL (CO) "
HPGW (CO only) "
-------------------------------------------------------------------------------------------
MANURE FROM UNCONFINED ANIMALS (NLCDE 71,81,82,83,84)
WELL YEAR UNCONFINED ANIMAL MANURE N INPUT CALCULATED AS
--------- ---------------------------------------------
91 wells average of 92 and 97 unconfined manure inputs
94 wells 97 unconfined manure input
97 wells 97 unconfined manure input
MANURE FROM CONFINED ANIMALS (NLCDE 81,82,83,84)
WELL YEAR CONFINED ANIMAL MANURE N INPUT CALCULATED AS
--------- ---------------------------------------------
91 wells average of 92 and 97 confined manure inputs
94 wells 97 confined manure input
97 wells 97 confined manure input
-------------------------------------------------------------------------------------------
ATMOSPHERIC DEPOSITION
WELL YEAR ATMOSPHERIC DEPOSITION N INPUT RATE CALCULATED AS
--------- -----------------------------------------------
91 wells average of 92 93 94 95 atmospheric deposition rate
94 wells average of 95 96 97 98 atmospheric deposition rate
97 wells average of 98 99 00 01 atmospheric deposition rate
-------------------------------------------------------------------------------------------
The original data set was nut_input_082704.txt.
All sites in NAWQAPT 11/01/2005 were processed using new fertilizer, manure, and nitrogen atmospheric deposition N inputs by county (September 2005 version) and revised county/NLCDE weighting factors based on new 1990 county grid.
Note: (Sept 2006) Some sites listed in Tom Nolan's data set for the Cycle 1 nutrients circular (circular051806.sas7bdat) are missing because Tom added some reference networks after the N inputs were calculated. N inputs for these sites will be calculated soon:
YR SUCODE TYPE NDCODE STAID 1997 acadreffo1 fo few 310044092590901 1997 acadreffo1 fo few 310202092392601 1997 ltenreffo1 fo few 352458086034702 1991 albereffo1 fo few 363529076291701These sites are in Tom's list but are not in the N inputs data set because they fall outside the county/NLCDE grids and therefore do not have county/land use weighting factors.
YR SUCODE TYPE NDCODE STAID 1994 pugtluscr1 ag ok 490031122221501 1994 pugtluscr1 ag ok 490031122225301 1994 pugtluscr1 ag ok 490042122241001 1994 pugtluscr1 ag ok 490101122221501 1994 pugtluscr1 ag ok 490103122240301 1994 pugtluscr1 ag ok 490117122195901
Missing fertilizer or manure data is coded -99. This should apply only to wells in COOK (Alaska), OAHU (Hawaii), PUGT (Canada).
Missing atmospheric deposition rate data is coded as -9999. This applies only to COOK, OAHU, PUGT.
The fields are:
AREAID NAWQA station id
FERTILIZER BY YEAR
FARMN87 1987 nitrogen from fertilizer on farm land (kg)
FARMN88 1988 nitrogen from fertilizer on farm land (kg)
FARMN89 1989 nitrogen from fertilizer on farm land (kg)
FARMN90 1990 nitrogen from fertilizer on farm land (kg)
FARMN91 1991 nitrogen from fertilizer on farm land (kg)
FARMN92 1992 nitrogen from fertilizer on farm land (kg)
FARMN93 1993 nitrogen from fertilizer on farm land (kg)
FARMN94 1994 nitrogen from fertilizer on farm land (kg)
FARMN95 1995 nitrogen from fertilizer on farm land (kg)
FARMN96 1996 nitrogen from fertilizer on farm land (kg)
FARMN97 1997 nitrogen from fertilizer on farm land (kg)
FARMN98 1998 nitrogen from fertilizer on farm land (kg)
FARMN99 1999 nitrogen from fertilizer on farm land (kg)
FARMN00 2000 nitrogen from fertilizer on farm land (kg)
FARMN01 2001 nitrogen from fertilizer on farm land (kg)
NONFN87 1987 nitrogen from fertilizer on non-farm land (kg)
NONFN88 1988 nitrogen from fertilizer on non-farm land (kg)
NONFN89 1989 nitrogen from fertilizer on non-farm land (kg)
NONFN90 1990 nitrogen from fertilizer on non-farm land (kg)
NONFN91 1991 nitrogen from fertilizer on non-farm land (kg)
NONFN92 1992 nitrogen from fertilizer on non-farm land (kg)
NONFN93 1993 nitrogen from fertilizer on non-farm land (kg)
NONFN94 1994 nitrogen from fertilizer on non-farm land (kg)
NONFN95 1995 nitrogen from fertilizer on non-farm land (kg)
NONFN96 1996 nitrogen from fertilizer on non-farm land (kg)
NONFN97 1997 nitrogen from fertilizer on non-farm land (kg)
NONFN98 1998 nitrogen from fertilizer on non-farm land (kg)
NONFN99 1999 nitrogen from fertilizer on non-farm land (kg)
NONFN00 2000 nitrogen from fertilizer on non-farm land (kg)
NONFN01 2001 nitrogen from fertilizer on non-farm land (kg)
MANURE BY YEAR
NMAN82CONF 1982 nitrogen from manure from confined animals (kg)
NMAN87CONF 1987 nitrogen from manure from confined animals (kg)
NMAN92CONF 1992 nitrogen from manure from confined animals (kg)
NMAN97CONF 1997 nitrogen from manure from confined animals (kg)
NMAN82UCONF 1982 nitrogen from manure from unconfined animals (kg)
NMAN87UCONF 1987 nitrogen from manure from unconfined animals (kg)
NMAN92UCONF 1992 nitrogen from manure from unconfined animals (kg)
NMAN97UCONF 1997 nitrogen from manure from unconfined animals (kg)
ATMOSPHERIC DEPOSITION RATE BY YEAR
NDEP85 1985 average nitrogen deposition rate (kg/km2)
NDEP86 1986 average nitrogen deposition rate (kg/km2)
NDEP87 1987 average nitrogen deposition rate (kg/km2)
NDEP88 1988 average nitrogen deposition rate (kg/km2)
NDEP89 1989 average nitrogen deposition rate (kg/km2)
NDEP90 1990 average nitrogen deposition rate (kg/km2)
NDEP91 1991 average nitrogen deposition rate (kg/km2)
NDEP92 1992 average nitrogen deposition rate (kg/km2)
NDEP93 1993 average nitrogen deposition rate (kg/km2)
NDEP94 1994 average nitrogen deposition rate (kg/km2)
NDEP95 1995 average nitrogen deposition rate (kg/km2)
NDEP96 1996 average nitrogen deposition rate (kg/km2)
NDEP97 1997 average nitrogen deposition rate (kg/km2)
NDEP98 1998 average nitrogen deposition rate (kg/km2)
NDEP99 1999 average nitrogen deposition rate (kg/km2)
NDEP00 2000 average nitrogen deposition rate (kg/km2)
NDEP01 2001 average nitrogen deposition rate (kg/km2)
N INPUTS CALCULATED FOR THE BUFFER
TO REPRESENT N INPUT DURING THE SAMPLING PERIOD
FARMNAVG Farm fertilizer (kg)
NONFNAVG Non-farm fertilizer (kg)
NMANCAVG Manure from confined animals (kg)
NMANUAVG Manure from unconfined animals (kg)
FMYR Method used for calculating fertilizer/manure input
NDEPAVG Atmospheric deposition rate (kg/km2)
DYR Method used for calculating atmospheric deposition
rate input
The values of FMYR are:
91 - fertilizer/manure calculated using method for 1991 studies 94 - fertilizer/manure calculated using method for 1994 studies 97 - fertilizer/manure calculated using method for 1997 studies -4 - fertilizer/manure calculated using method for PUGT and UCOL -7 - fertilizer/manure calculated using method for HPGW wells in COThe values of DYR are:
91 - atmospheric deposition calculated using method for 1991 studies 94 - atmospheric deposition calculated using method for 1994 studies 97 - atmospheric deposition calculated using method for 1997 studies
kjhitt@usgs.gov
kjhitt@usgs.gov