Southeastern Section–55th Annual Meeting (23–24 March 2006)

Paper No. 9
Presentation Time: 4:30 PM

USING AN ENVIRONMENTAL DATA WAREHOUSE TO INTEGRATE ANALYTICAL DATA, GIS, AND THE WEB


KORNS, David E., SAIC, 4900 Blazer Pkwy, Dublin, OH 43017, CORDIVIOLA, Steven, Kentucky Geological Survey, University of Kentucky, 228 Mining & Mineral Resources, Lexington, KY 40506, HAMPSON, Steve, KRCEE, University of Kentucky, 100 Sower Boulevard, Suite 108, Frankfort, KY 40601, ORMSBEE, Lindell, KRCEE, University of Kentucky, 233 Mining & Mineral Resources, Lexington, KY 40506 and PHILLIPS, Bruce E., Navarro Research Engineering, PO BOX 1470, Building C103, Paducah, KY 42002, scordiviola@kgs.mm.uky.edu

Large, complex facilities such as military bases, research and development laboratories, and Superfund sites generate ever-growing sets of reports, documents, analyses, and GIS databases from the multitude of projects associated with each facility. Unfortunately, many of these data and documents are stored in different databases and coordinate systems, using formats that do not allow for easy exchange among users. In addition, facilities management documents are usually stored in CAD applications that cannot be readily used by GIS technologies. Scientists, contractors, governmental regulators, and others who require daily access to data from hundreds of sampling events, geotechnical investigations, and site-specific GIS features are hindered by the time and effort necessary to gather and prepare these historical data into a useable format.

The Web-based, GIS-enabled Environmental Data Warehouse used for the U.S. DOE Portsmouth and Paducah Gaseous Diffusion Plants illustrates how complex data from a variety of geotechnical, biological, environmental, and health safety studies can be integrated into an easy-to-use interface. Analytical data that are stored in government, university, and contractor databases are harvested using a rule-based process. The data are then reformatted, indexed, and stored in a spatially enabled data warehouse in which each sample location is linked to a master sample location feature table. Likewise, site locations, facility CAD drawings, maps, and photography are converted and loaded into an ESRI ArcGIS geodatabase. Authorized end-users can then access the data via the Web to retrieve and deliver data in prescribed formats, including graphs, maps, charts, and downloads to other applications. The interface allows users to search by text query or by selecting features from a map. Drop-down and menu lists are dynamically generated from the database, allowing simple point-and-click or more robust data mining based on user needs.

This project was funded through a grant from the Department of Energy: Award - DE-FG05-03OR23032