The previous version (2006) of this data set was created by Kerie J. Hitt using the November 2005 version of NAWQAPT and the 2005 version of the nitrogen atmospheric deposition grids.
This is for internal use only.
! 1) Limited NAWQAPT to groundwater sites.
! Tool: Analysis>Extract>Select tool
! Criteria: ("SUID" <> 'cook' AND "SUID" <> 'oahu') AND ~
! ( "STYPE" = 'GW' OR "STYPE" = 'GW-CR' OR "STYPE" = 'GW-HZ' OR ~
! "STYPE" = 'GW-IW' OR "STYPE" = 'GW-MW' OR "STYPE" = 'GW-TH')
! Input: NAWQA sampling points (NAWQAPT)
! Output: groundwater sites (point_Select).
!
! 2) Populated groundwater sites with PROCGRP
! (buffers of sites with the same PROCGRP value do not overlap).
! Tool: Join
! Input: NawqaGWBuf_point (contains PROCGRP; provided by NACT tool)
! Input: groundwater sites (point_Select)
! Output: groundwater sites with PROCGRP (point_Select)
!
! 3) Separated groundwater sites into a set with PROCGRP and
! a set without PROCGRP.
! Tool: Analysis>Extract>Select tool
! Criteria: PROCGRP > 0
! Input: point_Select
! Output: gwpnts_w_procgrp
!
! Criteria: PROCGRP < 1
! Input: point_Select
! Output: gwpnts_wo_procgrp
!
! 4) Created buffers for each group of sites
! Tool: Buffer
! Criteria: 500 meters
! Input: gwpnts_w_procgrp
! Output: gwbuff1
!
! Input: gwpnts_wo_procgrp
! Output: gwbuff2
!
! 5) Generated "GRP" for sites without PROCGRP
! (buffers of sites with the same GRP value do not overlap).
! Tool: NACT Addons>Watersheds>Group Non-overlapping Polygons
! Input: gwbuff2
! Output: gwbuff2_new
!
! 6) Combined gwbuff1 and gwbuff2_new
! Added PROCGRP item to gwbuff2_new.
! Calculated PROCGRP = 1432 (last PROCGRP number in gwbuff1) + "GRP".
! Made items in gwbuff1 and gwbuff2_new the same.
!
! Tool: Merge
! Input: gwbuff1 AND gwbuff2_new
! Output: gwbuff
!
! 7) Resampled the 1-kilometer grid of nitrogen atmospheric deposition
! for 1985 (atmsqkm85g) to create a 500-meter grid
! (atmsqkm85g_Resample), because the 500-meter buffer was smaller
! than the 1-km grid cell - a condition that prevents the Feature
! Statistics to Table tool from working.
! Tool: Resample
! Input: atmsqkm85g
! Output: atmsqkm85g_Resample
!
! 8) Determined the average nitrogen deposition rate for the buffered
! groundwater sites.
! Tool: NAWQA Area-Characterization Tools > Feature Statistics to Table
! Criteria: Mean
! Input: gwbuff AND atmsqkm85g_Resample
! Output: gwbuff_atm85_FSTT.dbf
!
NOTE: This tool computes statistics summarizing raster cell values for areas covered by each feature in a feature class and write the results to a table. In this case, the mean nitrogen deposition rate (kg/sqkm) was determined from the nitrogen atmospheric deposition grid for the buffer area for each site. Processing occurred at the 30-meter resolution (snapped to the nlcde grid).
! ! 9) Joined output file to gwbuff table. ! Tool: Join ! Input: gwbuff.dbf AND gwbuff_atm85_FSTT.dbf ! Output: gwbuff.dbf ! ! 10) Repeated steps 7 through 9 for 1986 through 2001. ! ! 11) Output gwbuff.dbf with atmospheric deposition data as atmdep.dbf. ! ! 12) Cleaned up file and saved as gwbuf_ndep_sep2012.txt.
The nitrogen atmospheric deposition rate numbers represent weighted averages for the groundwater buffer. Missing data is -9999.
The fields are:
STAID NAWQA station id NDEP85 1985 average nitrogen deposition rate (kg/sqkm) NDEP86 1986 average nitrogen deposition rate (kg/sqkm) NDEP87 1987 average nitrogen deposition rate (kg/sqkm) NDEP88 1988 average nitrogen deposition rate (kg/sqkm) NDEP89 1989 average nitrogen deposition rate (kg/sqkm) NDEP90 1990 average nitrogen deposition rate (kg/sqkm) NDEP91 1991 average nitrogen deposition rate (kg/sqkm) NDEP92 1992 average nitrogen deposition rate (kg/sqkm) NDEP93 1993 average nitrogen deposition rate (kg/sqkm) NDEP94 1994 average nitrogen deposition rate (kg/sqkm) NDEP95 1995 average nitrogen deposition rate (kg/sqkm) NDEP96 1996 average nitrogen deposition rate (kg/sqkm) NDEP97 1997 average nitrogen deposition rate (kg/sqkm) NDEP98 1998 average nitrogen deposition rate (kg/sqkm) NDEP99 1999 average nitrogen deposition rate (kg/sqkm) NDEP00 2000 average nitrogen deposition rate (kg/sqkm) NDEP01 2001 average nitrogen deposition rate (kg/sqkm)