Locus EIM (Environmental Information Management) logo

Are you Drowning in Environmental Data While Starving for Information?

By Norman S. Wei, Courtesy of Environmental Management and Training, LLC.

MOUNTAIN VIEW, Calif., 1 January 2020 — A recent article in the Harvard Business Review entitled “IT Doesn’t Matter” generated a lot of discussions and an enormous amount of controversy. IT stands for Information Technology. The premise of the article is that information technology is becoming less relevant as a strategic management tool because it has become more accessible and affordable to all. The author argues that since every corporation is deep into IT, no one company can gain any significant strategic advantage by embracing it. In other words, IT has become a commodity. It has now become a necessary but insufficient condition for excellence.

A natural outcome of the Information Technology age is the ease of collecting massive amount of data. As a result, we often find ourselves drowning in data while starving for information! This column discusses some practical ways of managing your environmental data and how best to get the most information out of such data.

Collecting data is relatively easy to do but it does come with costs. Mistakes in data collection can lead to disastrous results. A classic example of data collection run amok is Total Quality Management (TQM) – an excellent management concept of “doing it right the first time”. In the 1990s, TQM was all the rage. Large and small corporations were embracing it. Unfortunately, many TQM administrators began to demand their employees to fill out forms to document and justify every decision as part of the TQM process. It got to the point where employees were spending so much time in filling out forms and preparing internal reports that the system collapsed on its own paper weight. People were collecting data for the sake of collecting data and not analyzing the data to improve management practices. They were drowning in data but starving for information. Once senior management discovered such waste of resources, TQM program was shut down.

Getting Information out of Data

About ten years ago, the consulting firm I worked for got a multi-million dollar contract to work on a large Superfund site in California . The previous consulting firm had installed about 100 monitor wells on site and were collecting massive amount of groundwater quality data. There were reams of computer printout data showing waste solvent concentrations at varying depths at each well over an extended time period. Yet no one had ever bothered to sit down and analyze the data as they were being collected to determine their efficacy. The data kept rolling in from the field. The Superfund site was drowning in data but starving for information. Our firm was then hired to make sense of the data – to interpret the groundwater contamination data to see in which direction the TCE was migrating in the aquifer. Our job was to provide our clients with useful information so that they could go and negotiate a settlement with EPA on how best to remediate the site. It became clear later the previous firm kept on collecting data. It was much more profitable (translation: more billable hours) to have a large team of technicians out in the field generating data than to have a small team of scientists analyzing them.

There is certainly no shortage of data in the environmental field. Every environmental permit requires the permit holder to collect one form of data or another. If you have a wastewater discharge permit, chances are that you are required by law to collect daily flow data, weekly effluent concentrations and calculate monthly averages of various chemical constituents in your waste stream. If you generate hazardous wastes, you are required by law to record how much of what wastes you ship out to a Treatment Storage and Disposal Facility (TSDF). If you have a major air permit, the government requires you to collect data on how many tons of HAPs (hazardous air pollutants) you send up the stack. Every July 1 of each year, many facilities are required by federal law to tell EPA how much chemicals they used, processes or manufactured in the preceding year and how much of the chemicals were “released” to the environment. This is the so-called Toxic Release Inventory Report (or better known as Form R).

The questions facing us are: How can we make the best use of the data we are required by law to collect? How can we benefit from such data? What useful information can we get out of these data?

Let’s start with the often misused (by the environmental zealots) and misunderstood (by the media) TRI database. A great majority of the data contained in the TRI database is based on legally permitted emissions and/or recycling activities. Yet they are all generically termed as “release to the environment”. That’s why every year the public reads about XYZ company being the “largest” polluter in the county because it “releases” so many tons of toxic chemicals to the community. Leaving this injustice behind, you should review the raw data that you use to compile your TRI report and determine how effectively you have been recycling your wastes offsite and how well you have controlled your air emissions. Use your own TRI data as a basis for your internal audit or review of your operations. If you are planning on acquiring a company, the EPA’s TRI data website address is www.epa.gov. is a good place to start your due diligence.

The EPA also compiles a large database on the hazardous waste activities nationwide based on the hazardous wastes generation reports that all large quantity generators send in every even-numbered year. These biennial reports – downloadable from the EPA’s website – can tell you a lot of information.
The latest available database is for year 1999 and can be downloaded from www.epa.gov. It can tell you who have been shipping what type of hazardous wastes to which TSDF. Once you have downloaded the data into your computer, you can import it into a relational database program such as Microsoft Access and analyze the data. One of the main reasons why you want to know who ship what wastes to a site that you are considering is to avoid shipping wastes to a site that receives most of its wastes from small companies. If the site turns into a Superfund site and those small companies go out of business, your company will be forced to bear their shares of the cleanup cost under the “joint and several liability” clause of CERCLA. The joint and several liability means each PRP (Potentially Responsible Party) associated with the Superfund site can be held individually responsible for the entire cleanup cost of the site. So that’s why you need to choose a site that has many financially viable PRPs in order to minimize your potential liability.

Use the air emission data you collect under your air permit to tell you how much VOCs (Volatile Organic Compounds) and HAPs (Hazardous Air Pollutants) are being emitted. Here are some practical ways you can make use of them. Use the information to see how much reformulation of your solvents you need in order to come below the threshold of NESHAP (National Emission Standards for Hazardous Air Pollutants). If you emit more than 10 tons per year of a single HAP or 25 tons per year of any combination of HAPs, you come under NESHAP which requires your facility to meet MACT (Maximum Achievable Control Technology) – another set of stringent emission standards under the Clean Air Act. After reviewing their environmental data, some companies have reformulated their paints to reduce their HAPs and are able to opt out of the stringent requirements under the Title V and NESHAP programs.

Look at the wastewater data you have collected under your wastewater discharge permit. Develop a time chart and look for trends or irregularities. Put your data on a spreadsheet and develop a historical correlation between waste loadings and production level. Very often a significant deviation in the spatial (time related) data trend or a sudden change in the production/waste correlation ratio will point to some malfunction somewhere upstream in the production process. It may indicate a significant leakage within your collection system or some wastage of raw material. Since you are legally required to collect such data (such as daily flow, daily concentrations, etc), you might as well make the most out of it. It could end up helping you improve your source reduction or waste minimization programs and save you some money.

 

Data Management

A few words here about data management. Collecting data is a relatively simple task. Trying to figure out what to do with the data is a different matter. The key to getting useful information out of your data is good data management. And the key to good data management is to make sure you have ownership of your own data. You can’t analyze what you don’t have available to you. Do not hand over your data to an outside firm to “manage” them for you. Here is a nightmare scenario that is all too common: You pay an outside firm to collect environmental data for you. The firm puts your data on its proprietary data system and holds on to it. Every time you need access to your data, you have to pay the firm again to retrieve it. Even worse, when you decide to switch firm, you have to pay the existing firm to download your data and the new firm to upload it.

According to Marian Carr, project manager at Locus Technologies – a California based firm that designs environmental data management systems for its clients to operate themselves ( www.locustec.com ) – “there is a very strong desire from both public and private firms to consolidate environmental data under the owner’s control”. Many of her clients have “horror stories” of having to pay consultants to get back their own data or not being able to get the data at all.

If you feel a need to customize your computer database, make sure someone within your organization knows how to run it after it has been customized. If an outside consulting firm is collecting environmental field data for you, insist that the data be stored in a format that is compatible with your own system. And insist on getting the data transferred to your system. This is the only way to keep from being held hostage by your consultants. The last thing you want is to be totally dependent on some outside contractor to tell you what data and information you have on a day-to-day basis. It can get very expensive – dollar-wise and knowledge-wise.

 

About the author
Norman S. Wei is the founder and principal of Environmental Management and Training, LLC., a consulting and training firm based in Union, Washington. He offers regulatory seminars and consulting services throughout the country. He can be reached by email at norman@proactenv.com. His company website is www.proactenv.com.