I spent over 10 years working on the remediation of contaminated groundwater in Cape Cod, MA (Figure 1). I loved doing this type of work by helping restore the environmental health of the groundwater and surface water systems. Spending time in Cape Cod wasn’t bad either!
The sites we worked on are located in the Massachusetts Military Reservation (MMR) in western Cape Cod, MA. The Otis Air National Guard Base (Figure 2) is where historical operations released chemicals to the groundwater system.
Decades of rain and snow have provided the driving forces to move these contaminants down-gradient such that the zones of contamination are miles long and wide and hundreds of feet thick. Figure 3 shows one of the plumes that is known as the Chemical Spill-10 plume (CS-10).
Many hundreds of millions of dollars were spent on environmental characterization studies to quantify the nature and extent of groundwater contamination. Geologic investigations were used to assess the 4D (x,y,z, and time) contaminant distributions (Figure 4). This information was used to build a 3d concentration field for numerical simulation of the CS-10 flow, transport, and predicted remediation effectiveness. The characterization work was necessary to design and build the groundwater pump and treat systems needed to perform the remediation. This is one of the largest groundwater restoration projects ever attempted in US history.
Using Tableau to Visualize Remediation Effectiveness
Tableau was used to evaluate the Chemical Spill-10 TCE mass removal history from 1999 to 2007. The data in this example is real! The actual mass removed at extraction wells was measured and a program titled the History of Operations and Modeling Evaluations (HOME) was used to produce the data shown in this demonstration. Although HOME had a database back-end, it had an Excel front-end, which was state-of-the-art for producing these types of analytics back in 2004!
HOME was a computational framework I created to keep track of the actual remediation progress being made. The computations performed time integrations of contaminant mass removal times flow rate to estimate the total amount of contaminant mass removed. The code I wrote for computing the remediation progress can be viewed by clicking the following link: Computing Contaminant Mass Capture in Modflow-Surfact.
I strongly encourage you to look at that code if (1) you like scientific programs, or (2) you like to see how pretty C code can look when it is properly formatted and colored (LOL!). Who says a data dork/programmer like me doesn’t have any style?
As shown in the video below, I used Tableau to visualize the remediation performance history. An example animation of cumulative mass removal is completed as well as a couple of dashboards to show the mass removal performance of any or all extractions wells.
Update in April, 2017.
This article was written about 4 years ago. It has been viewed a total of 25 times as shown in Figure 5! That is ridiculous! What is wrong with you 3danim8 blog readers? This conclusively proves to me that I’m going to have to republish some of my early work to show you the great stuff I did all those years ago!
If you like this article and would like to see more of what I write, please subscribe to my blog by taking 5 seconds to enter your email address below. It is free and it motivates me to continue writing, so thanks!