ACQUIRING DATA


The Northeast Region distributes the information gathered in this report in a variety of formats.
The data is available by 3.5" floppy disks or over the WDNR network system. Hardware
requirements for this data are within current minimum requirements for all WDNR computers.
Software used to access this information is also installed on all machines. dBase files can be
directly imported in MS Access. The data consists of the original FileMakerPro database, two
databases, and two ArcView shapefiles named and described by the following:

PROJECT.fp3 - The original project site information form and database.

ERRP.dbf - This is an export and subset of the PROJECT.fp3 database consisting of a dBase file
           of site characteristics for Environmental Repair and Restoration Program sites.

LUST.dbf - This is an export and subset of the PROJECT.fp3 database consisting of a dBase file
           of site characteristics for Leaking Underground Storage Tank Program sites.

ERRP.shp
ERRP.dbf - Arcview shapefile of Environmental Repair and Restoration Program locations.
ERRP.shx

LUST.shp
LUST.dbf - ArcView shapefile of Leaking Underground Storage Tank Program locations.
LUST.shx

Both shapefiles contain the appropriate database joined to each and are referenced to the
Wisconsin Transverse Mercator North Amercian Datum 83(91)(WTM83(91)) complying with
WDNR BEITA\GEO standards.

CONCLUSIONS

The information collected is beneficial for many uses. This project fostered the retrieval of data
from closed and soon to be closed case files that soon may be archived. The project has taken
relevant data from generally inaccessible locations throughout the WDNR NER and made it
available to be used currently in making decisions. During the course of the project ranking of
WDNR case files by environmental severity was drastically altered and partially eliminated as the
agency went through a reorganization and portions of the Leaking Underground Storage Tank
program were transferred to another state agency (Wisconsin Department of Commerce). Thus
case ranking by environmental factors was not addressed within the project. However the
database created by this project enables a rapid determination of native site conditions on a local
and regional scale where good data exists. Future updates of this information will enable rapid
and accurate determinations of native environmental conditions in areas where human impacts
may be likely.

Perhaps the greatest utility of this project has been the creation of the GIS query program utilizing
ArcView. The development of this program and use of its final product has allowed the WDNR
Drinking Water and Remediation and Redevelopment Programs to transition more efficiently
toward a GIS digital site locating and information retrieval system. Both programs through Safe
Drinking Water Requirements and Brownfield Initiatives respectively are incorporating GIS
methods into their data systems. The GIS knowledge and developed methods ensued from this
project provided the basis and training platform for the initiation of a coordinated statewide effort
to integrate site information and provide access by unfamiliar GIS users.