abbreviation. Interpretation was performed by the reviewer when the UCS code was not included
ih the description of the soil boring. Also when encountering analytical results in contamination
reports a minimum detection level was frequently recorded as the result. This detection level is
indicated in the table with a negative sign. Table 2 provides a description for each field in the
table. The table has the field name with field type and the entry that may be allowed when
entering data into the field. The entry limitations allow the reviewer the option of entering only
certain types of information into a record. This entry option prohibits the reviewer from entering
erroneous data into the table. The last column is a description of the field name, use this
description as a guide when querying the database.

GIS and USES

Geographic Information System (GIS) allows the use of maps to be relationally joined to
databases. The standard WDNR GIS software is Environmental Systems Research Institute
(ESRI) ArcView software. This allows databases to be queried with results being displayed in
mapped locations. The database that was collected during this project allows soil characteristics,
hydraulic conductivity, depth to bedrock, depth to water table and background soil and water
analytical results to be displayed spatially. An example would be to query all soil contamination
locations where background arsenic levels were greater than 0.03 micrograms per liter. All
relevant locations would then be highlighted in ArcView. Using the above example, Table 2 and
the query builder tool in ArcView, the following statement {[As0_5W] > 0.03) or {[As5_1OW] >
0.03} would yield the proper results. The user may zoom to an area of concern and select all the
locations and print a summary report of conditions. These conditions reports are commonly done
to identify indigenous metals concentrations to compare local background concentrations from
site to site when evaluating case closure criteria relative to Natural Resources code NR720.19.
soil requirements. An additional major use is the employment of this project to characterize
petroleum site screening factors for sites to determine the division of caseloads between WDNR
and Wisconsin Department of Commerce (WDOC). The most relevant screening factors include
the presence of clay, hydraulic conductivity, and depth to bedrock. Additional site screening
factors can be added as needed with future updates as they occur.

RECOMMENDATIONS

The following are possible suggestions that could be made to make this information more usable
and provide guidance to future data collection.

    Currently the WDNR requires that consultants submit quarterly reports of samples taken in a
    tabular paper format. The WDNR should request e-mailed or computer disk copies in WDNR
    database supported formats of this same information which can easily be linked to currently
    located sites in a GIS environment.

    Along with the above information many contamination files have Autocad drawing files with
    detailed site drawings that can be joined to each site using hot-link features in ArcView GIS.
    Requests could be made to receive this information when submitting reports. All WDNR
    computers in receipt of such digital information would require adequate virus control software.
  *Currently groundwater monitoring remediation wells are being computerized with an
    associated unique well identification number. A system should be developed that will link
    these computerized forms to the site GIS location. The groundwater monitoring well
    construction report should have a field where the contamination site unique identification
    number can be entered and/or all contamination sites located in GIS should have the
    corresponding unique well identification number(s) in a table for each well that has been
    drilled at the location. Thus information collected by outside contractors can be linked
    immediately within the GIS environment.



				
      
      
				

					






Table 2. Field Definitions


Field Name
ErrpLust
Unique_id
WaterDepth
Rt-drock Deot


Field Type
Text
Number
Number
Number


Formula I Entry Option
Required Value
Only Allow Values of Type "Number"
Only Allow Values of Type "Number'
Onlv Allow Values of Tvoe "Number'


Description
Contamination Type
Unique Field for Relating
Water Depth
Bedrock Depth


Well1                 Number
Well2                 Number
Well3                 Number
Well4                 Number
Well5                 Number
Well6                 Number


Only Allow Values of Type "Number"  monitoring vveii ruum uii o
Only Allow Values of Type "Number"  Monitoring Well Number on Site
Only Allow Values of Type "Number'  Monitoring Well Number on Site
Only Allow Values of Type "Number"  Monitoring Well Number on Site
Only Allow Values of Type "Number"  Monitoring Well Number on Site
flnlv AIInw VVInhip of Tvne "Number"   Monitoring Well Number on Site