Database / Data Management Poster Session

An Integrated Model for Environmental Data Management
 

Andrew M. Adinolfi, P.E., GEI Consultants, Inc., 1021 Main Street, Winchester, MA 01890, Tel: 781-721-4074, Fax: 781-721-4073
Jamie D. Vallee, GEI Consultants, Inc., 1021 Main Street, Winchester, MA 01890, Tel: 781-721-4000 Fax: 781-721-4073
 

Management of chemical and geologic site data in a versatile electronic format is becoming a cost-effective option for most environmental assessment projects, due to recent market trends and advances in technology. Historically, cost-effective electronic data management was limited to GIS-based systems for large, data-intensive sites. Recent market trends that favor the use of electronic databases on projects of smaller scope include faster-paced brownfields-driven cleanup, a greater number of clients and regulatory agencies requiring deliverables in electronic format, and the consolidation of decades worth of data for older sites. Recent technology developments include improved software products, more powerful desktop computers, and the availability of lab-generated electronic data deliverables (EDDs).  We present an approach to database management developed as a response to these trends, geared toward the end use of project decision-making. Proprietary Microsoft Access®-based software is used for initial data compilation. Geologic observations, survey data, and other project specific information are stored in one database, and chemical data are stored in a separate database. A cross-linking database is created to run queries related to spatial and temporal distribution of contaminants. The results may then be exported to preferred software for presentation in tabular or graphical format, preparation of CADD drawings, further analysis such as modeling or risk calculations, and preparation of project deliverables such as boring logs. The approach presented here has been found to be most beneficial for projects entailing multiple properties, , consultants, and/or phases of assessment. Three case studies are presented. Efforts of the entire project team, including management and staff trained in database software, were found to be integral to the success of this approach. Licensed software packages for data storage, analysis, and presentation are also required.

Development of Environmental Process Screening Model Software

Raymond G. Ball, Ph.D.,P.E.,L.S.P., ECSMarin, 27 Midstate Drive, Suite 218, Auburn, MA 01501, Tel: 508-832-6022, Email: rball@ecsmarin.com

As fundamental understanding of environmental processes and associated design equations are developed by researchers, it is imperative that useable design software follow, so as to advance the basic efficiency and accuracy of the environmental design process. The software described here is one effort to attain this goal. This paper presents an overview of the first environmental process screening model software written fully in the Java language for use on the internet, company intranets, or on the desktop. A modular approach to development of the software is being taken so as to make the addition of future modules for other processes programmatically efficient. The first module, an environmental process screening model for the multi-component liquid-phase and vapor-phase granular activated carbon (GAC) adsorption processes, is presented. The software is fully self-contained and has a graphical user interface and database of chemical property information required for the specific process modeling module (eg. adsorption).

Screen shots of the user interface used to design the GAC adsorption process, and a case study will be presented (if sufficient data is available at conference time). Plots of predicted dynamic GAC adsorption column results as compared to actual field results collected at a gasoline station in Massachusetts are presented. Particular attention is paid to the removal of MTBE in the presence of high concentrations of BTEX, dissolved oxygen, and high   total organic carbon. Different types of GAC, including specialty GAC products, may be evaluated for their adsorption potential regarding MTBE.

Massachusetts Military Reservation (MMR) Environmental Web-Based Data Management System

Ann Bernhardt, AMEC Earth & Environmental, 239 Littleton Rd. Suite 1B, Westford, MA 01886 , Tel: 978-692-9090 x306, Fax: 978-692-6633, Email: ann.bernhardt@amec.com
Heather Sullivan, U.S. Army Corps of Engineers, 696 Virginia Road, Concord, MA 01742-2751 ,
Tel: 978-318-8543, Fax:  617-647-8663, Email: Heather.L.Sullivan@nae02.usace.army.mil
Matt Walsh, Matthew.T.Walsh@nae02.usace.army.mil, U.S. Army Corps of Engineers, 696 Virginia Road, Concord, MA 01742-2751, Tel
:  978-318-8647, Fax: 617-647-8663
 

Massachusetts Military Reservation (MMR) Environmental Web-Based Data Management System.  Ann Bernhardt, AMEC Earth & Environmental.  AMEC Earth & Environmental developed a web-based data management system that provides Internet access to groundwater study data at the Massachusetts Military Reservation (MMR).  The site features real-time query, data download, and report building features. Other components of the project include integration of GIS software and environmental data generated by multiple contractors at MMR.  This project will support the groundwater study work AMEC continues to do at MMR under the National Guard Bureau contract.

The Camp Edwards training area at the MMR is a 14,000-acre site with unexploded munitions and potentially other environmental issues as a result of over 60 years use as a military training facility. AMEC has been working at the site since 1997 in support of the Army National Guard.  

The major tasks assigned under this contract are:

  • Implementation of the Impact Area Groundwater Study Workplan
  • Remediation of the Small Arms Training Area
  • Rapid Response Actions
  • Management of the Innovative Technology Evaluation Program

Under the data management project, a web interface provides access to data generated by multiple contractors that has been compiled into a central database.  As an example of the scope of this project, AMEC developed a database of over three million records of sampling data from over 15,000 soil, sediment, surface water, and groundwater at over 500 monitoring wells.  The site will be available for public viewing and will be accessible via the Groundwater Study Program at Camp Edwards site at http:/groundwaterprogram.org.

Various Applications of Soil Contaminant Database Developed For Central Artery/Tunnel Project

Ken S. Chin, P.E. – Bechtel/Parsons Brinckerhoff, 185 Kneeland Street, Boston, MA  02111 , Tel:  617 951-6486; Email:  KSCHIN@bigdig.com
Richard G. Christian, P.E., LSP – Camp Dresser & McKee Inc., 50 Hampshire Street, Cambridge, MA  02139, Tel:  617 452-6268; Email:  christianrg@cdm.com
Andrea E. Sewall, LSP – Camp Dresser & McKee Inc., 50 Hampshire Street, Cambridge, MA  02139,
Tel:  617 452-6261; Email:  sewallae@cdm.com

The Massachusetts Highway Department and Massachusetts Turnpike Authority, under the auspices of the United States Department of Transportation, Federal Highway Administration, are nearing the completion of the construction of a 7.5 mile urban highway corrider which will replace Boston’s elevated Central Artery (Interstate 93) with a new eight to ten lane underground expressway, and a new four lane tunnel (Interstate 90) beneath Boston Harbor connecting South Boston to Logan International Airport in East Boston. To support the Project in managing the excavation and disposal of over 15 million cubic yards of soil materials, one of the largest environmental assessment programs in the country was initiated in the early 1990s to determine the chemical characteristics of soil located within the planned alignment for the Project.  As part of this work, more than 2,300 soil borings were installed and over 8,000 soil samples were collected and analyzed for a comprehensive range of chemical contaminants, including volatile organic compounds, acid/base neutral compounds, total petroleum hydrocarbons, polychlorinated biphenyls and heavy metals.  

During the subsurface drilling investigations conducted for the Project, the soils encountered were characterized as fill materials and naturally occurring soils that exhibited properties largely influenced by numerous anthropogenic activities.  The chemical testing program showed that these activities, such as vehicular traffic and industrial/manufacturing activities, resulted in soils primarily contaminated with petroleum hydrocarbons and metal compounds.  In portions of the alignment, historic documentation indicates that rubble from the Great Fire of 1872 and dredge spoils from Boston Harbor were also sources of these fill materials. As part of this work, an extensive database of soil contaminant data was developed to determine the concentration or range of concentrations of specific chemical constituents present in urban soils found in downtown Boston.  These results were primarily used to delineate the limits of contaminated areas impacting the planned construction areas.  In later phases of the Project, the soil contaminant database has been used by the Project to support various soil management activities, as well as by the regulatory community to support the development of guidelines and criteria governing the management of contaminated soils in Massachusetts.  This paper focuses on the numerous applications of this database throughout the course of the Project, as well as potential future applications for both the regulatory and scientific communities.   

Top
   

Past Conference Programs | Home
  
 
  
Design and Hosting by Dot.Inc Group
Copyright © 2000 University of Massachusetts - All rights reserved.