Summary Databases Delivered to the Arkansas Department of Health

The results of these geostatistical operations were compiled into a collection of databases and spreadsheets that were compatible with the Arkansas Department of Health's reporting methods. These Microsoft Access and Excel spreadsheets contain the summary information for all of the Public Water System Intakes and Potential Sources of Contamination (PSOC) for Arkansas.

PSOC Report Database

A database was created in Microsoft Access from the output (.dbf) tables from ArcView3.2 that contained a Distance-to-Intake value for each potential source of contamination. These distances were computed in feet. For the final summary statistics of PSOC count, per distance zone; per Public Water System Intake, the Access database tables were exported into Microsoft Excel and the Pivot-Table command simplified the summary report generation. A step-by-step wizard guided the conversion of the psoc distance database, into a summary by zone for each public water system.

Assessment Area Statistics Database

Another database was created within Access that contained all of the assessment area statistics for land cover characteristics, as described in the Area Calculations section. These summary statistics for each public water system were organized by the unique ID numbers and grouped by each land cover characteristic that was extracted from the GIS data layers (such as Geology, Land Use, and Soil Type). The area statistics for each public water system were calculated by the ArcView - Spatial Analyst operation called "Tabulate Areas". This operation populates the database table (.dbf) with the area of each "land cover" map category contained within each water system assessment area. The resulting database table was then exported from ArcView as a dbaseIV (.dbf) file and imported into Microsoft Access. The database operations within Access made the actual calculation of percent area and total area of each assessment area much easier than ArcView, and therefore most of the clean-up of the data occurred within the Access software. The Access database tables are fully documented and a description of each data column can be viewed by selecting the "design" view from within Access.

Standard Industrial Codes Defined as Potential Sources of Contamination

The Arkansas Department of Health and United States Geological Survey office in Little Rock, provided CAST a list of the Standard Industrial Codes (SIC) that were to be considered as PSOC's within the Arkansas source water assessment. These SIC codes were used to select the appropriate businesses from the Acxiom InfoBase data product, prior to geocoding and inclusion into the PSOC data layer. A full listing of these SIC codes and their descriptions will be included in Appendix D of this document. It is important to note that the United States Census Bureau has renamed this coding methodology to the North American Industry Classification System (NAICS) and more information regarding this change and its affect may be found at the following web address: (http://www.census.gov/epcd/www/naics.html).

Final Map Production and Delivery

The final collection of two to five color maps for each of the public water systems were delivered in a .pdf file that was named after the six digit water system intake identification number (eg. 101201.pdf). These Adobe Acrobat Reader compatible files contained anywhere from two to five color maps of the PSOC sites contained within the assessment area of each public water system intake. The source water assessment team specified that the "type" of source the system used would determine the size, quantity and contents of each public water system map (collection). Surface water sources have very large assessment areas that contain many point locations of PSOC's, and therefore maps had to be generated at a different scale than the groundwater systems with 3 mile (or less) radius assessment areas.

FINAL MAP EXAMPLES:

Ground Water System

Surface Water System #208101

Surface Water System #209102

Non-Community System #t0035101

Non-Community System #t0040101