Using #Tableau to Evaluate the MMR CS-10 TCE Mass Removal History

featured


Introduction

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!

MMR

Figure 1 – Western Cape Cod, the home of the Massachusettes Military Reservation (MMR).


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.

MMR2

Figure 2 – The MMR base area as viewed in 2017.


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).

CS-10map

Figure 3 – The CS-10 plume area.


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.

Image

Figure 4 – The 3D wireframe portrayal of the TCE/PCE contaminant distribution of CS-10.

 

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.

Click this link to see the remediation story of MMR.

Final Thoughts

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!

CS-10_History

Figure 5 – The viewership history for this article. There have only been 6 views per year!  Really?


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!

Enter your email address to follow this blog and receive notifications of new posts by email.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s