SkyTruth Aggregates FracFocus Data

Among the many provisions under Act 13, Pennsylvania oil and gas operators now must join several other states by disclosing some generalized information about chemical additives to wells that undergo hydraulic fracturing to a national registry called FracFocus.org. On their main page, FracFocus describes their role in the following manner:

In a single year, FracFocus has made a national impact from the Beltway to the Bakken. During this time, more than 200 energy-producing companies have registered over 15,000 well sites through FracFocus.

This success is the result of nationally recognized organizations working with the oil and natural gas industry to provide public transparency. Learn more and see highlights from the first year of FracFocus.

However, there are strong differences of opinion on what transparency really means.  Does it entail specific data about a well, general information about all the wells, or both?  The chemical registry is focused on specifics about individual wells, and although the data is easily accessible for them, they don’t offer data downloads for users interested in a wider scope.  Whether this amounts to data transparency has everything to do with the lens that one looks through.

Let’s say, for example, that you already know a bit about a given well.  As a random example, let’s use API# 37-131-20104, a well operated by Chesapeake in Wyoming County, PA.  When we conduct a search, we are given the opportunity to download a PDF where we can learn a great deal about the well that is not available from the Pennsylvania Department of Environmental Protection (PADEP) data download section. We learn, for example, that the well was fractured on May 8, 2012 using over 1.3 million gallons of water, as well as the maximum amounts used of chemical additives the hydraulic fracturing fluid, and why they were added to the mix.

Objectively, that is a large step forward in transparency, as this information was not available before.   But what if your questions about the industry are broader?  You may want to know, for example, if some operators are putting diesel fuel into the hydraulic fracturing fluid, or whether some anti-bacterial agents are more prominent in certain geographies than others.  You might want to do a comparison on which companies claim data to be proprietary, relative to the industry as a whole, or whether there is any correlation between particularly noxious chemical additives and well production.  To answer questions like these, you just need a summary of the data that FracFocus already offers.  But unfortunately, FracFocus will not provide this aggregated data.

To help address questions such as these, SkyTruth.org has extracted the data from the PDF documents using a combination of automated and manual techniques, and have made the results available to FracTracker and the general public.  The result is a major step forward in data transparency; even before the chemical data have been picked through and combed over, there are still several new types of data that the general public didn’t have access to before.

FracFocus Data Available for Mapping
SkyTruth’s efforts have allowed us to map FracFocus data. Click on the map above to explore.

The data include over 26,000 records from FracFocus since January 1, 2011 from twenty different states around the country. Now it is possible for people other than industry insiders to learn about variables not provided by the various states, including depth of target formation, fracturing dates, amounts of water used. There is also a separate dataset including all listed chemicals at each well, which comes in at well over 800,000 records for the 21 months of the report.

Of course, users must remain mindful that this is not, in fact, a completely comprehensive dataset.  While several states have recently required disclosure of the chemical additives, in remains a voluntary disclosure in other locations.  Some of the chemicals are listed in the abstract, but marked as proprietary, which naturally limits our understanding of what was put into the well.  And as with other large datasets of this sort, it is likely that there are a significant number of omissions and errors.

At FracTracker, we’d like to extend our gratitude to both FracFocus for collecting the data and making it public, and to SkyTruth, for aggregating it and making it more usable.  In our view, both of these steps are critical for true data transparency.  This transparency, in turn, is indispensable for making an enhanced understanding of the oil and gas industry possible.

PA Waste and Production Maps Available on FT’s FracMapper

Additional Pennsylvania content has been added to FracTracker’s mapping utility, FracMapper. In addition to the Shale Gas Viewer, which contains a lot of basic information about unconventional gas extraction in the Commonwealth, users can now also find information on the latest production and waste reports, which range from January 1, 2012 to June 30, 2012 in both cases. All three maps can be found together on the Pennsylvania Maps page.

Let’s take a look at each of the new maps:

Production

The production map(1) contains separate layers for each of the three kinds of production reported in Pennsylvania:  gas (measured in thousands of cubic feet, or Mcf); condensate (measured in barrels); and oil (measured in barrels).  I have also made county-level maps containing aggregated data by county for each of the three products, including total production, number of wells that contributed to the production (which may differ from “drilled wells”), and the average production of those wells.  So for example, there were two unconventional wells that produced oil in Butler County, for a total of 7,488.34 barrels, which is an average of 3,744.17 per producing well.


Pennsylvania unconventional production map. Click the expanding arrow icon in the top right to gain access to additional functionality.

Waste

There are three layers in this map, all of which are based on the most recent unconventional waste report.  First, there is a generalized layer, which shows the location of the wells producing waste, but does not have any specific content.  This layer exists to improve map performance at the statewide level.  If you zoom in past 1:500,000 (a view showing several counties), then the generalized layer disappears, and the data become available by clicking on any of the wells that reported waste production.  Finally, there is a layer of facilities that received the waste.  If you click on one of the industrial icons, it will bring up the aggregated waste that was received by that facility, and included information on how that waste was disposed of (i.e., injection wells or landfills).  To see the list of disposal methods and their abbreviations, please click on the expanding arrows in the top right of the map below, then the “About” icon on the toolbar.

Pennsylvania unconventional waste production map. Click the expanding arrow icon in the top right to gain access to additional functionality.

  1. As a mapmaker, I am vexed by some rendering issues with this map that have not yet been fully resolved. For each of the three county layers, all counties reporting zero production are supposed to draw transparently, and one of the largest producing counties of gas, Bradford, is supposed to be opaque. While this map remains stylistically unsatisfactory, the data remain accurate. Here is a screen shot of what the map is supposed to look like when showing gas data:

    Hopefully, this issue will be resolved shortly.