PWT participated in the development of a cutting-edge database tool for environmental investigation and remediation support in collaboration with the URS Corporation, the General Services Administration, and Colorado Department of Public Health and the Environment.
The Integrated Environmental Data Management System (IEDMS) was developed for the GSA at the Denver Federal Center (DFC) to perform a suite of data management and analysis functions. The most unique of these functions is the ability to clarify regulatory decision-making with data that are at or below reporting limits.
Environmental investigation and remediation can generate massive amounts of data that must be managed and analyzed to support regulatory decisions regarding environmental cleanup levels. A complex challenge common to types of projects involves data levels that are above minimum detection limits (MDLs) and below reporting limits (RLs). This can leave a regulatory “gray area” where the data aren’t verifiable enough to substantiate cleanup. The IEDMS was created to be able to verify this type of data.
The DFC’s unique manufacturing and research history, combined with its current potential for use, resulted in the challenge to process and analyze difficult-to-characterize data that would satisfy stringent regulatory criteria. The IEDMS provides data verification and analysis at the lowest limits of data detection to enhance complex regulatory decision-making at the DFC.
Two years of collaboration among the developing parties resulted in the creation of logic flow chart software that verifies data to a degree that “off-the-shelf” environmental data management products can’t. After verification, the system can then manage and analyze the data to support the DFC’s regulatory remediation parameters.
In addition to its primary function, the IEDMS also allows users to produce data reports from common pre-programmed queries, run statistical calculations from single sampling events to multiple time/set parameters, identify geographic data relationships and support GIS shapefiles to assist with geographic services support, and produce a variety of custom graphics and reports that can be exported into other commonly used applications.