EFFECTIVE DATA MANAGEMENT, VISUALIZATION AND REPORTING IN AN ENVIRONMENTAL RESTORATION PROJECT: A LOS ALAMOS NATIONAL LABORATORY CASE STUDY

摘要

This paper provides an overview and discusses the SMART system and how it facilitates data management within an environmental restoration project. SMART has four main components: data inputs, data storage, data cleanup and QA, and data retrieval (outputs). SMART data inputs consist of multiple subsystems designed to accurately capture, track, validate and audit analytical sampling activities. SMART interfaces include planning, collection, shipping, receiving, invoicing, verification and validation for analytical sampling activities. SMART data storage is built on a framework of transactional databases feeding multiple data marts which are linked to GIS repositories. The transactional databases support a high level of security, tracking and auditing for both newly generated data and for clean up of legacy data. The data marts support rapid data retrieval and analysis of large amounts of analytical and regulatory data. The GIS repository supports spatial data storage and retrieval. Document repositories support document production, tracking of regulatory deliverables and document retrieval. SMART data editing tools are designed to facilitate cleanup of legacy data issues and perform final QA functions in production data. SMART data retrieval, visualization and reporting tools provide a simple-to-use interface for drilling down and extracting information, characterizing and analyzing that information and generating and displaying the data in a variety of maps, charts and tables. SMART data outputs also support the auditing and tracking of regulatory deliverables.