Data Access, Assessment and Visualization

Skip Navigation Links.
Data Access, Assessment and Visualization
Data Warehouse – GIS (DWGIS) - Project Summary

Data Warehouse – GIS (DWGIS) - Project Summary

Environmental activities at large facilities, such as the PGDP, where historical industrial practices impacted soil, surface water, sediments, groundwater, and infrastructure generate vast amounts of physical, chemical, spatial, and temporal data from operations, environmental management, health and safety and regulatory compliance activities.  Once collected, the data has to be housed, managed, related, retrieved and distributed in a variety of formats which serve the needs of end-users practicing many disciplines related to site operations.

By 2005, the PGDP had accumulated over 2.1 million environmental monitoring data records, millions of attributes related to the environmental data records, and an immense collection of related physical and geotechnical data kept as paper records.  KRCEE and the DOE Portsmouth-Paducah Project Office evaluated existing web-based data storage and retrieval systems that linked environmental data to GIS and other geospatial data.   A decision was made to adopt and enhance an existing "Data Warehouse – GIS" System developed for managers' and contractors' internal use at the Portsmouth Gaseous Diffusion Plant, Pike county, Ohio.

Development of an enhanced "Data Warehouse – GIS" System for internal use and public access to PGDP data and GIS information began in 2005 as the Paducah Data Warehouse and GIS System (DWGIS) project.   Technical, regulatory and public uses of PGDP spatial and environmental data were identified through collaborative efforts of KRCEE, Scientific Applications International Corporation (SAIC), the PGDP Citizens Advisory Board, DOE-PGDP and DOE-contractor personnel, the Kentucky Geological Survey, the University of Kentucky Earth and Environmental Sciences Department, the Kentucky Cabinet for Environmental Protection, the Kentucky Cabinet for Health Services Radiation Control Program and the U.S. EPA Region IV.

During DWGIS development, collaborators needs and uses were translated into tools and system capabilities that allowed enhanced web-based visual access to PGDP environmental and GIS data.  In 2006, KRCEE submitted the initial beta-tested PGDP-DWGIS (Phase 1) and user’s manual to the DOE.

In 2011, DOE and its site contractors, LATA KY and SWIFT & STALEY, released the Paducah Environmental Geographic Analytical Spatial Information System (PEGASIS).  KRCEE and SAIC continue to support the enhancement of original DWGIS capabilities through the development of geoscience data sets and data assessment tools for PEGASIS.

The Paducah DWGIS, operated as PEGASIS by DOE Site Contractor, LATA KY, can be accessed at http://padgis.latakentucky.com/padgis/ 

PEGASIS
Document TitleDescriptionYear
Paducah DWGIS White Paper Project Proposal Presentation2005
Paducah DWGIS CAB & KWRRI Symposium PosterProject Proposal Presentation 
Data_Warehouse_Geological Society of America PresentationPresentations and Deliverables 
DWGIS Architectural Recommendations Proposal Final Report (Phase 1)Presentations and Deliverables2006
PGDP DWGIS Status and Recommendations Presentation (May 2006)Presentation 2006
DWGIS

Data Warehouse – GIS (DWGIS) – PROJECT SUMMARY POSTER
Kentucky Water Resources Research Institute (KWRRI) Annual Symposium, March 2007

Project Contributors

Steve Hampson, Associate Director, UK- Center for Applied Energy Research, KY Research Consortium for Energy and Environment
David Korns, PI, Scientific Applications International Corporation, Columbus, OH (2005 – 2009)
David Taylor, U.S. Department of Energy, Portsmouth Paducah Project Office
Bruce Meadows, PRS Inc., Paducah
Lisa Crabtree, PRS Inc., Paducah
LeAnn Garner, PRS Inc., Paducah
Dr. Richard Bonczek, U.S. Department of Energy, Portsmouth Paducah Project Office
Tracey Bugg, Scientific Applications International Corporation, Portsmouth, OH