Find information on spaces, staff, and services.
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.